Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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

ROI
Gain - investment cost ÷ investment cost = percentage

PI
Greater than l for single project.

Attachments
Purchase this Solution
Solution Summary

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

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

Purchase this Solution
Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Introduction to Finance

This quiz test introductory finance topics.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

View More Free Quizzes
Related BrainMass Solutions

  • Financial Analysis for a hospital project

    - Create a financial analysis of these projects and based on Net Present Value (NPV), Return on Investment (ROI), and Profitability Index (PI).

  • Net Present Value, Return on Investment, and Profitability Index

    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.

  • NPV, IRR, PI and Payback Period

    C) Profitability index D) Payback period Prepare a brief memo advocating which project should be chosen and why. You must select a project and recommend it based on your analysis. Do not discuss the merits of both.

  • Difference between IRR and PI? Lease or Buy?

    47192 Difference between IRR and PI? Lease or Buy? What are some differences between IRR and PI? What would Lisa Cross say about IRR? Why would an organization choose to lease an asset instead of buying it?

  • Capital Rationing

    NPV of project A= $600,000 Thus, NPV criteria does not give the best solution Instead of undertaking A as suggested by NPV criteria, undertake projects B and C Determines the projects to choose based on NPV criterion when there

  • Capital Budgeting: NPV, PI, IRR, Payback

    IRR is nice for comparisons among projects or alternative uses of cash. When there is a limit on funds and so projects must be ranked and compete with each other, a firm cannot do all projects with a positive NPV or PI above 1.

  • Excel: Relationship Between NPV and IRR

    The PI is directly correlated with the NPV in that if the NPV is positive then the PI will be over 1.00, and a negative NPV will produce a PI of less than 1.00.

  • IRR, MIRR, and Discounted Cashflow

    The decision to accept or reject a Capital Budgeting project depends on an analysis of the cash flows generated by the project and its cost.

  • Capital Budgeting Techniques: NPV, PI, IRR, MIRR, and Payback.

    A third/forth capital project analysis method is the PI and accounts for the present value of a projects future cash flows which is then divided by the initial cost. This is an estimate of cash inflow generation.

View More Related Solutions