In: Finance
1. What's the NPV of the following cash flows with a 8% WACC?
2. What's the payback period of the following cash flows with a 8% WACC?
3. What's the discounted payback period of the following cash flows with a 8% WACC?
4. What's the profitability index of the following cash flows with a 8% WACC?
Year 0 = 100,000
Year 1 = 10,000
Year 2 = 50,000
Year 3 = 45,000
Year 4 = 25,000
1. Calculation of NPV
NPV = Present value of cash Inflow - Present value of Cash Outflow
| Year | Cash Flow | PVF @8% | PV of cash Flow | 
| 0 | -100000 | 1 | -100000 | 
| 1 | 10000 | 0.926 | 9260 | 
| 2 | 50000 | 0.857 | 42850 | 
| 3 | 45000 | 0.794 | 35730 | 
| 4 | 25000 | 0.735 | 18375 | 
| NPV | 6215 | 
2. Calculation of Payback period
Initial Investment = 100000
| Year | Cash Inflow | Cumulative Cash Inflow | 
| 1 | 10000 | 10000 | 
| 2 | 50000 | 60000 | 
| 3 | 45000 | 105000 | 
| 4 | 25000 | 130000 | 
Payback period = Year before Full recovery + Unrecovered cost / Cash Flow during the year
= 2 years + 40000/45000
= 2.89 years
Unrecovered Cost = Initial Investment - Cumulative cash flow at the end of 2nd year.
3. Calcuation of Discounted Payback period
| Year | Cash Flow | Discounted Cash Flow (refer NPV solution in point 1) | Cumulative Discounted Cash Flow | 
| 0 | -100000 | -100000 | -100000 | 
| 1 | 10000 | 9260 | -90740 | 
| 2 | 50000 | 42850 | -47890 | 
| 3 | 45000 | 35730 | -12160 | 
| 4 | 25000 | 18375 | 6214 | 
Discounted Payback period = 3 years + (12160 / 18375)
= 3.66 years
4. Profitability Index
= 1 + Net Present value (NPV) / Initial Investment
= 1 + 6215 / 100000
= 1.062