In: Finance
What is the discounted payback period on Versace's proposed
investment in a new line of fashion clothes? The expected cash
flows appear below. Note that year 0 and year 1 cash flows are
negative. (Answer in years; round to 2 decimals)
Year 0 cash flow = -95,000
Year 1 cash flow = -18,000
Year 2 cash flow = 50,000
Year 3 cash flow = 49,000
Year 4 cash flow = 54,000
Year 5 cash flow = 45,000
Year 6 cash flow = 46,000
Required rate of return = 14.00%
Ans 4.31 years
Year | Project Cash Flows (i) | DF@ 14% | DF@ 14% (ii) | PV of Project A ( (i) * (ii) ) | Cumulative Cash Flow |
0 | -95000 | 1 | 1 | (95,000.00) | (95,000.00) |
1 | -18000 | 1/((1+14%)^1) | 0.877 | (15,789.47) | (1,10,789.47) |
2 | 50000 | 1/((1+14%)^2) | 0.769 | 38,473.38 | (72,316.10) |
3 | 49000 | 1/((1+14%)^3) | 0.675 | 33,073.60 | (39,242.49) |
4 | 54000 | 1/((1+14%)^4) | 0.592 | 31,972.33 | (7,270.16) |
5 | 45000 | 1/((1+14%)^5) | 0.519 | 23,371.59 | 16,101.43 |
6 | 46000 | 1/((1+14%)^6) | 0.456 | 20,956.98 | 37,058.41 |
NPV | 37,058.41 | ||||
Discounted Payback Period = | 4 years + 7270.16/23371.59 | ||||
4.31 years | |||||