by | Aug 1, 2022 | Finance

Design a brand new college or university. You are free to select which type of institution, i.e. private, public, 4‐year, 2‐year, technical. The primary purpose of this project is to gain a greater awareness and appreciation of how various units work together to meet the institution’s mission. You will create the mission. You will make decisions regarding size, setting, enrollment, curricular and extra‐curricular details, etc.

Please submit your sketch of your ideal budget for your own college or university. The budget should be multi-layered including every college or school (depending on the type of institution you are creating) and department unit. Please include which budget model(s) your institution utilizes. There are sample budgets and spreadsheets for you to utilize in your final project as templates. Please include background information about your institution as well as a detailed spreadsheet that outline’s your institutional budget for the fiscal year. You are welcome to include as many charts, graphs, and spreadsheets as you deem pertinent in explaining your institution and how the resources are managed. Your final project should not exceed more than 20 pages and must include a minimum of 5 pages.

by | Aug 1, 2022 | Finance

Assignment Instructions

During the past few months your work has not gone unnoticed. You have been promoted to the Chief Nursing Officer of TAMIUGH! During this time TAMIU, as a university, opened another Texas A&M campus at Del Rio, Texas, now known as TAMIU-II. As part of this process the state is considering purchasing a nearby hospital, that would become TAMIUGH-II.

You have been asked to assist the CFO in the process of due diligence. The CFO has gone over the financial records of the new hospital thoroughly to create the attached financial report. However, he has asked you to help him interpret what these numbers indicate. Your instructor has provided a separate table, which contains various financial ratios, how they are calculated and what each of these indicate.

Your task is to review the attached financial report, and to provide an analysis for each of nine items listed at the right. Once this has been completed, you are to provide a brief overview of the financial status of this hospital, as to what this all means when considered together, along with a recommendation as to whether the state should or should not purchase TAMIUGH-II. Remember this assessment and evaluation is solely based on this financial report. There are other members on your team who will report on issues such as the quality of care provided at the hospital, the level of technology and infrastructure at the facility, and the opportunities that this hospital would present to area residents. Once the report is completed upload it to the appropriate assignment link in this module.

PLEASE PUT ANSWERS ON COLUMN H ON SPREADSHEET. CONTACT ME AT 817-907-7060 WITH QUESTIONS OR CONCERNS.

by | Aug 1, 2022 | Finance

Type

Project

Length

4 pages for The written report (A4-size, double spaced, excluding references and appendices)

Submission

Written reports and Excel files submitted online

Requirements

Requirements for Project : Portfolio Construction

The task: The lecturer assigns 4 publicly listed stocks to each student. Students are required to download the most recent 5 years’ daily stock price for the assigned stocks, use Excel (particularly the Solver function) to construct the opportunity set, the minimum variance frontier, the global minimum variance portfolio, the efficient frontier, and the optimal risky portfolio. Students are required to download the most recent 5 years’ daily risk-free return for the economy where the stocks are listed, and construct the optimal complete portfolio for a client whose maximum acceptable level of risk is a standard deviation of 30% for his/her portfolio return.

Written report: Discuss the relevant information of the 4 stocks; discuss how you construct the required portfolios and frontiers. Your discussion should relate what you are doing in the project to what we have learned so far in the paper, particularly Chapters 5 and 6.

Excel file:

Store all the stock prices, risk-free rate, the composition of the required portfolios (the Excel functions used should be embedded in the Excel file), a graph showing all the required portfolios and frontiers. The Excel file should be professionally presented.

Programme learning goals

This assessment covers the following programme learning goals:

Be effective thinkers and problem solvers

Be effective communicators (written and oral)

Be able to apply finance knowledge to issues in professional finance practice

Paper learning outcomes

This assessment event measures paper learning outcomes 1, 2, and 5 stated above in the “Paper information” section.

Recommended reading

Bodie, Z., Kane, A., and Marcus, A.J. (2019). Essentials of Investments, 11 th Edition. McGrawHill/Irwin.

Recommended books:

Elton, E. J., Gruber, M. J., Brown S. J. and Goetzman, W. N., Modern Portfolio Theory and Investment Analysis, 6th Edition, John Wiley.

Fabozzi, F. J., Bond Markets, Analysis and Strategies, 5th Edition, Prentice Hall.

by | Aug 1, 2022 | Finance

Unit I Essay

Instructions

Ratio Analysis

This is your opportunity to play detective and do some financial statement analysis. Please select any publicly traded company. The CSU Online Library has several databases to choose from that are good starting points for your research:

Mergent Online,

Business Insights: Global,

Business Source Ultimate, and

ABI/INFORM Collection.

In addition to using at least one database article or report from the CSU Online Library, you may also use any reliable website, such as the company’s web page.

For the company you select, find the annual report and the financial ratio information for the following ratios:

debt-to-equity,

current ratio,

return on equity,

quick ratio,

working capital ratio,

price earnings ratio, and

earnings per share.

Once you have reviewed the information, write an essay that begins with a brief introduction to your chosen company. Next, explain how the company is doing with respect to the ratios. In one to three sentences, briefly summarize what each of the ratios are telling you about the company. Conclude with how you predict it will do in the future.

Your essay should be at least one page in length. Use APA format to cite and reference all quoted and paraphrased material, including your textbook. Use a minimum of two sources, one of which may be the textbook. Include a title page, introduction, body, conclusion, and references page. An abstract is not required.

by | Aug 1, 2022 | Finance

In this assignment, you will develop an expansionary capital budgeting plan. In order to complete this task, you first need to identify the stakeholder. Start by reviewing the question statements outlined below. Respond to the questions 1-4 in a word document. Then, complete question 5, the capital budgeting plan using Excel.

What do you consider as the most important stakeholder? Is it important for corporations to focus on maximizing shareholder wealth? Explain in your own words where each of the major stakeholders is represented within the financial statements of the corporation. You should be able to discuss at least four major stakeholders at this point. For example, the customers provide sales revenue and are represented within the income statement sales revenue figures.

Assess the relevant cash flows used to form a capital budgeting decision model. For this assignment, focus on an expansionary problem.

Evaluate the cost of capital (WACC) for use in a capital budgeting decision model. Make sure to define each component of the formula. Explain how the resulting cost of capital (WACC) is used within a capital budgeting model. How can the Capital Asset Pricing Model contribute to this analysis? Explain.

Weigh each of the following decision metrics that can be used within a capital budgeting decision model: net present value, internal rate of return, modified internal rate of return, payback period, and discounted payback period. Explain how each metric is formed and discuss the critical value of each when forming conclusions within a capital budgeting decision model. Discuss which method has the strongest basis for being used and under which conditions each might be the preferred method.

Develop a capital budgeting decision model that displays cash flows, cost of capital, and decision metrics (i.e., NPV, IRR, MIRR, regular payback, and discounted payback). Then, form a conclusion based upon the analysis. What are some problems with the payback period? Is NPV better than IRR? Develop your analysis within an Excel spreadsheet-based on this information:

Assume for a project a company’s units sold are 3,500,000 in the year 2019, and they are projected to grow each subsequent year at 5% until the end of the project in year 2023.

Assume each unit will sell for $2.10.

Assume the variable cost of producing each unit is $1.10.

Assume the fixed costs are $100,000 per year

Assume straight-line depreciation of a machine (lasting until the end of the project) with an initial investment in a machine of $500,000 and $0 salvage value

The cost of capital is calculated based upon funding from retained earnings and from debt. The company is assumed to fund itself with 50% debt and 50% retained earnings. The cost of debt capital, rD, is 7%. The cost of capital from retained earnings, rS, is based upon the Capital Asset Pricing Model. The risk-free rate in the market is 5% and the difference between the expected return on the market and the risk-free rate is 5%. The beta of the company is 2.0. The tax rate is assumed to be 40%.

Calculate the project cash flows and apply the decision metrics

Complete a sensitivity analysis in which you reevaluate the model considering the selling price per unit is $1.90, $2.00, and $2.30. Present and comment on the results.

Write your answers to the qualitative questions in a Word document and paste your spreadsheet analyses into the Word document.

by | Aug 1, 2022 | Finance

You will need to calculate the financial ratios needed to determine Johnson & Johnson’s current financial health. Once you’ve calculated these ratios, the results will be used to analyze the business’s current financial position and help them make decisions about how to improve or maintain their financial health. Pay particular attention to working capital management. If liquidity is an issue,

consider how the company will meet its short-term obligations.

All supporting documents are attached the Financial Formulas spreadsheet and the balance sheet, income statement, and cash flow statement from Mergent Online.