Question

In: Finance

Profitability Index NPV/Initial Investment Can you please give me a breakdown how to figure out NPV/Intitial...

Profitability Index NPV/Initial Investment

Can you please give me a breakdown how to figure out NPV/Intitial investment. If you cab please just show me an example how to figure it out.

On an sheet, just want an example and a breakdown on how you came up with it. Thanks

Solutions

Expert Solution

Profitability Index is the ratio of the present value of future cash flows of the project to the initial investments in the project. This index helps in cost benefit analysis of investment projects and helps them rank in order of the best return on initial investments.

  • If the index is more than 1, then the investment is worthy because then you may earn back more than you invest in.
  • If the index is less than 1, then it’s better to step back and look for other opportunities. Because when PI is less than 1 that means you would not get back the money you would invest. Why bother to invest at all?

If the index is equal to 1, then it’s an indifferent or neutral project. You shouldn’t invest in the project until and unless you consider it better than other projects available during the period. If you find that the PI of all other projects to be negative, then consider investing in this project

Consider the following Example.

Investment $40,000
Life 5 Years
PV Factor @10%
Year Cashflows PV
1 18000 0.909 16362
2 12000 0.827 9924
3 10000 0.752 7520
4 9000 0.683 6147
5 6000 0.621 3726
Total PV 43679
(-) Investment 40,000
NPV 3,679
PI 1.092
PI > 1
So Accept the project

We have considered WACC as 10%. We can get the PV factor for 10% from the PV Table.

PI = 43679/40000 = 1.092

NPV = 43679- 40000 = $3679


Related Solutions

Profitability Index NPV/Initial Investment Can you please give me a breakdown how to figure out NPV/Intitial...
Profitability Index NPV/Initial Investment Can you please give me a breakdown how to figure out NPV/Intitial investment. If you cab please just show me an example how to figure it out.
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial...
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s payback period? f. What is...
Hi, I can't figure out this question in excel, can someone please show me the excel...
Hi, I can't figure out this question in excel, can someone please show me the excel formulas to input in order to solve for part A and B please!!!! The following table contains closing monthly stock prices for Oracle Corporation (ORCL), Microsoft Corporation (MSFT), and NVidia (NVDA) for the first half of 2017. Ticker 6/30/2017 5/31/2017 4/30/2017 3/31/2017 2/28/2017 1/31/2017 ORCL 50.14 45.39 44.96 44.61 42.59 40.11 MSFT 68.93 69.84 68.46 65.86 63.98 64.65 NVDA 144.56 144.35 104.3 108.93 101.48...
What Is Confidence Interval, and how can it be used? Could you please give me a...
What Is Confidence Interval, and how can it be used? Could you please give me a few examples and thanks so much.
Under what circumstances will you prefer profitability index to NPV as project evaluation techniques
Under what circumstances will you prefer profitability index to NPV as project evaluation techniques
How do I calculate the up-market Beta? Can you give me an example please? Can you...
How do I calculate the up-market Beta? Can you give me an example please? Can you give an examp;le of when it is was a good market timer and when it is a bad market timer
Can you please give me 1 example on how would the variable expenses increase as a...
Can you please give me 1 example on how would the variable expenses increase as a percentage of the selling price ?
1. NPV, IRR, Profitability Index You are reviewing a new project. The required return for assets...
1. NPV, IRR, Profitability Index You are reviewing a new project. The required return for assets of this risk level is 12%. The estimated cash flows are: ◦      Year 0: CF = −165,000 ◦      Year 1: CF = 63,120; ◦      Year 2: CF = 70,800; ◦      Year 3: CF = 91,080; }  What is the NPV, IRR and the profitability index? }  Should you accept or reject this project? 2. Payback, Discounted Payback and AAR You are reviewing a new project. The required return for assets...
What is the Profitability Index and what does it tell about a project or investment?  How...
What is the Profitability Index and what does it tell about a project or investment?  How is it calculated?
can you please give me an example of a state diagram and a flow chart for...
can you please give me an example of a state diagram and a flow chart for a simple program?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT