In: Finance
Siblene Penn is considering a project that has the following cash flow data. What is the discounted payback using a 11.2% cost of capital?
Year 0 1 2 3 4 5
Cash flows -$6,750 $2,000 $2,025 $2,050 $2,075 $2,100
| Discounted Payback period= A+(B/C) | ||||
| Where, | ||||
| A=last period number with negative cumulative present value of cashflows | ||||
| B=absolute value of cumulative present value of net cashflow at the end of period A | ||||
| C=total present value of cash inflow during the period following period A | ||||
| Year | Cashflow | Discount [email protected]% | Present value | Cumulative present value | 
| 0 | -6,750.00 | 1.00 | -6,750.00 | -6,750.00 | 
| 1 | 2,000.00 | 0.90 | 1,798.56 | -4,951.44 | 
| 2 | 2,025.00 | 0.81 | 1,637.63 | -3,313.81 | 
| 3 | 2,050.00 | 0.73 | 1,490.87 | -1,822.94 | 
| 4 | 2,075.00 | 0.65 | 1,357.06 | -465.88 | 
| 5 | 2,100.00 | 0.59 | 1,235.08 | 769.20 | 
| Discounted Payback period= | 4+(465.88/1235.08) | |||
| 4.38 | years |