In: Finance
Consider the following project. Using Discounted Payback Period method (10% rate), how long will it take to recover the investment?
| Year | |||||||
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | |
| Investment | -4000 | ||||||
| Profit | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | |
| Year | Cash flow | × discount rate | Discounted cash flow | Capital recovery to date | Balance to be recovered |
| 0 | -4000 | 1.00000 | $ (4,000.00) | 0 | $ 4,000.00 |
| 1 | 1100 | 0.90909 | $ 1,000.00 | $ 1,000.00 | $ 3,000.00 |
| 2 | 1100 | 0.82645 | $ 909.09 | $ 1,909.09 | $ 2,090.91 |
| 3 | 1100 | 0.75131 | $ 826.45 | $ 2,735.54 | $ 1,264.46 |
| 4 | 1100 | 0.68301 | $ 751.31 | $ 3,486.85 | $ 513.15 |
| 5 | 1100 | 0.62092 | $ 683.01 | $ 4,169.87 | $ - |
| 6 | 1100 | 0.56447 | $ 620.92 | $ 4,790.79 | $ - |
| Capital is recovered fully in year 5 | |||||
| Discounted pay back period is | 4 + 513.15/683.01 | 4.75 |
It takes 4.75 years to recover
please rate.