In: Finance
Compute the discounted payback statistic for Project C if the appropriate cost of capital is 8 percent and the maximum allowable discounted payback period is three years. (Do not round intermediate calculations and round your final answer to 2 decimal places.)
Project C | ||||||
Time: | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow: | –$1,300 | $600 | $570 | $610 | $360 | $160 |
Project C | Discount rate= | 0.08 | ||||
Year | Cash flow stream | Cumulative cash flow | Discounting factor | Discounted CF | Cumulative cash flow | Cumulative discounted CF |
0 | -1300 | -1300 | 1 | -1300 | -1300 | -1300 |
1 | 600 | -700 | 1.08 | 555.5556 | -700 | -744.444 |
2 | 570 | -130 | 1.1664 | 488.6831 | -130 | -255.761 |
3 | 610 | 480 | 1.259712 | 484.2377 | 480 | 228.4764 |
4 | 360 | 840 | 1.360489 | 264.6107 | 840 | 493.0871 |
5 | 160 | 1000 | 1.469328 | 108.8933 | 1000 | 601.9804 |
Discounted payback period is the time by which discounted cashflow cover the intial investment outlay | ||||||
this is happening between year 2 and 3 | ||||||
therefore by interpolation payback period = 2 + (0-(-255.76))/(228.48-(-255.76)) | ||||||
2.53 Years | ||||||
Where | ||||||
Discounting factor =(1 + discount rate)^(corresponding year) | ||||||
Discounted Cashflow=Cash flow stream/discounting factor |