In: Finance
Use the following cash flows to calculate the NPV, IRR, PI. The firm's WACC is 6%. Y0 = ($1,500), Y1= $600, Y2 = $700, Y3 = $500. Determine which statement is true.
a) NPV = 108.84; IRR = 9.99%; PI = 1.07
b) NPV = 108.84; IRR = 10.47%; PI = 1.07
c) NPV = 108.84; IRR = 9.99%; PI = 0.0726
d) NPV = 300; IRR = 9.99%; PI = 1.20
Please Explain
a) NPV = 108.84; IRR = 9.99%; PI = 1.07
Working:
| NPV | $ 108.84 | |||||||
| IRR | 9.99% | |||||||
| PI | 1.07 | |||||||
| working: | ||||||||
| a. | ||||||||
| Year | Cash flow | Discount factor@6% | Pesent Value | |||||
| 1 | $ 600 | 0.943 | $ 566.04 | |||||
| 2 | $ 700 | 0.890 | $ 623.00 | |||||
| 3 | $ 500 | 0.840 | $ 419.81 | |||||
| Total | $ 1,608.84 | |||||||
| Less:Costs of Project | $ 1,500.00 | |||||||
| Net Present Value | $ 108.84 | |||||||
| b. | PI (Profitability Index) | = | $ 1,608.84 | / | $ 1,500.00 | |||
| = | 1.07 | |||||||
| c. | At 10% | |||||||
| Year | Cash flow | Discount factor@10% | Pesent Value | |||||
| 1 | $ 600 | 0.909 | $ 545.45 | |||||
| 2 | $ 700 | 0.826 | $ 578.51 | |||||
| 3 | $ 500 | 0.751 | $ 375.66 | |||||
| Total | $ 1,499.62 | |||||||
| Less:Costs of Project | $ 1,500.00 | |||||||
| Net Present Value | $ -0.38 | |||||||
| IRR | = | 6%+(10%-6%)*(108.84/(108.84+0.38)) | ||||||
| = | 9.99% | |||||||
| IRR is the rate at which NPV is zero. | ||||||||