Explore BrainMass

Explore BrainMass

    Developing an Analysis of Projects Based on NPV, ROI, and PI

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com June 4, 2020, 2:04 am ad1c9bdddf


    Solution Preview

    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, ...

    Solution Summary

    The solution assists in developing an analysis of projects based on the net present value, return of investment, and probability index.