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.

Solutions

Expert Solution

PRESENT VALUE OF CASH FLOW  = Its the value of all cash inflows expected to be generated from a project in future discounted at an required rate of return.

INITIAL INVESTMENT = Its the investment done in any project at its initial stage for example purchase price of a machinery etc. It can also include working capital requirement at initial stage or any other   cost required to get the project \ asset get started. it is also callled CASH OUTFLOW.

NPV ( NET PRESENT VALUE) = Its the present value of cash inflows adjusted for present value of cash outflows.

NPV = PRESENT VALUE OF CASH INFLOWS - PRESENT VALUE OF CASH OUTFLOW

PROFITABILITY INDEX = NPV \ INITIAL INVESTMENT

ACCEPT PROJECT ONLY  IF PROFITABILITY INDEX FOR THE PROJECT IS GREATER THEN 1 .

I am including and easy example

Q.. F Ltd. is interested in investing a project which requiring $50,000 as initial investment. It will generate cash inflows as

YEAR 1 = $20,000

YEAR 2= $29,000

YEAR 3 = $27,000

YEAR 4= $16,000

YEAR 5= $35,000

after that company will withdraw from the project. Evaluate the project using profitability index , cost of capital is 10%.

PRESENT VALUE OF CASH INFLOWS

YEAR CASH INFLOW PRESENT VALUE FACTOR @10% PRESENT VALUE
1 20,000 0.909 18,180
2 29,000 0.826 23,954
3 27,000 0.751 20,277
4 16,000 0.683 10,928
5 35,000 0.621 21,735
95,074

PRESENT VALUE OF CASH INFLOWS = 95,074

NPV = PRESENT VALUE OF CASH INFLOWS - PRESENT VALUE OF CASH OUT FLOWS

= 95,074 - 50,000

= 45,074

PROFITABILITY INDEX = NPV \ INITIAL INVESTMENT

= 45,074\ 50,000

= 0.9014

Since profitability index is less then 1 we should not invest in this project . If it has been a case of mutually exclusive projects to be evaluated on the basis of profitability index , we would have selected the project having highest profitability index.


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. On an sheet, just want an example and a breakdown on how you came up with it. Thanks
. 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