Please don't do this in Excel. Please do it in Word.
See attached file.
You have been hired in the finance department at a large, metropolitan for-profit hospital. Your duties are very important to the entire hospital in terms of financing operating costs. Additionally, you are also in charge of 3 employees who work under you to help with the day-to-day accounting activities. Your role includes budgeting, managing the general ledger accounts, utilizing financial formulas to perform accounting activities, and training and development of your 3 employees. This professional career is exciting and challenging for you but is also enjoyable and rewarding as you work your way up the career ladder toward reaching your goal of becoming the chief executive officer (CEO) of the hospital.
Due to scarce resources, your organization is faced with the decision of choosing between mutually exclusive projects (I.e., Build a Rehab. Center or Build a Neonatal Wing). You have been asked to develop a financial analysis of two projects and based on Net Present Value (NPV), Return on Investment (ROI), and Profitability Index (PI), explain which project is best to implement.
The concept needs to be explained that is what the instructor is looking for. You can make up your own numbers to explain the concept.
Table for NPV
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Salvage Value
Net cash flow (70,000) 20,000 20,000 20,000 20,000 20,000 20,000
Present value factor
(10% cost of capital) n/a 0.909 0.826 0.751 0.683 0.620 0.620
Present value answer (70,000) 18,180 16,520 15,020 13,660 12,400 6,200
Net present value =11,980
Gain - investment cost ÷ investment cost = percentage
Greater than l for single project.
Please see the attached file(s) for the complete tutorial.
From the hypothetical investment figures for Projects 1 and 2, in terms of net present value and given that the metropolitan for-profit hospital is facing scarce resources and must choose between two mutually exclusive projects, the project that must be funded is Project 1.
From this project, the hospital's stockholders will have an optimal value - $4,330 higher than that of Project 2.
If the decision is based on the projects' return on investment, ...
The solution assists in developing an analysis of projects based on the net present value, return of investment, and probability index.