In: Finance
Compute the discounted payback statistic for Project D if the appropriate cost of capital is 12 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "0" (zero).)
Project D | ||||||
Time: | 0 | 1 | 2 | 3 | 4 | 5 |
Cash flow: | –$12,200 | $3,470 | $4,420 | $1,760 | $0 | $1,240 |
Ans 0
The project does not payback.
Year | Project Cash Flows (i) | DF@ 12% | DF@ 12% (ii) | PV of Project A ( (i) * (ii) ) | Cumulative Cash Flow |
0 | -12200 | 1 | 1 | (12,200.00) | (12,200.00) |
1 | 3470 | 1/((1+12%)^1) | 0.893 | 3,098.21 | (9,101.79) |
2 | 4420 | 1/((1+12%)^2) | 0.797 | 3,523.60 | (5,578.19) |
3 | 1760 | 1/((1+12%)^3) | 0.712 | 1,252.73 | (4,325.46) |
4 | 0 | 1/((1+12%)^4) | 0.636 | - | (4,325.46) |
5 | 1240 | 1/((1+12%)^5) | 0.567 | 703.61 | (3,621.85) |
NPV | (3,621.85) |