In: Finance
| An investment project costs $15,300 and has annual cash flows of $3,500 for six years. | 
| Required : | |
| (a) | What is the discounted payback period if the discount rate is zero percent? | 
| (Click to select)4.724.284.024.464.37 | |
| (b) | What is the discounted payback period if the discount rate is 3 percent? | 
| (Click to select)4.414.664.855.114.76 | 
| (c) | What is the discounted payback period if the discount rate is 21 percent? | 
| (Click to select)3.353.98Never4.351.02 | 
We first computed the discounted cash flows as cash flows/ (1+rate)^n
Then we find the cumulative discounted cash flows
Discounted payback = Year in which Discounted Cumulative CF is last negative -(Last negative discounted cumulative CF/ CF of next year)
| 0% | 3% | 21% | |||||||
| Year | cash flows | Discounted CF | Cumulative DCF | Discounted CF | Cumulative DCF | Discounted CF | Cumulative DCF | ||
| 0 | -15300 | -15300 | -15300 | -15300 | -15300 | -15300 | -15300 | ||
| 1 | 3500 | 3500 | -11800 | 3398.058 | -11901.9 | 2892.562 | -12407.4 | ||
| 2 | 3500 | 3500 | -8300 | 3299.086 | -8602.86 | 2390.547 | -10016.9 | ||
| 3 | 3500 | 3500 | -4800 | 3202.996 | -5399.86 | 1975.659 | -8041.23 | ||
| 4 | 3500 | 3500 | -1300 | 3109.705 | -2290.16 | 1632.776 | -6408.46 | ||
| 5 | 3500 | 3500 | 2200 | 3019.131 | 728.9752 | 1349.402 | -5059.05 | ||
| 6 | 3500 | 3500 | 5700 | 2931.195 | 3660.17 | 1115.208 | -3943.85 | ||
| Discounted payback | 4.37 | 4.76 | Never | ||||||
WORKINGS
