In: Finance
Home Depot has been presented with an investment opportunity that will yield end-of-year cash flows of $45,000 per year in years 1 through 4, $38,000 per years 5 through 9, and $42,000 in year 10. This investment will cost the firm $185,000 today, and the firm's cost of capital is 6%. What is the NPV for this investment? Please include formula and numbers used.
Ans $ 121172.63
Year | Project Cash Flows (i) | DF@ 6% | DF@ 6% (ii) | PV of Project ( (i) * (ii) ) |
0 | -185000 | 1 | 1 | (1,85,000.00) |
1 | 45000 | 1/((1+6%)^1) | 0.943 | 42,452.83 |
2 | 45000 | 1/((1+6%)^2) | 0.890 | 40,049.84 |
3 | 45000 | 1/((1+6%)^3) | 0.840 | 37,782.87 |
4 | 45000 | 1/((1+6%)^4) | 0.792 | 35,644.21 |
5 | 38000 | 1/((1+6%)^5) | 0.747 | 28,395.81 |
6 | 38000 | 1/((1+6%)^6) | 0.705 | 26,788.50 |
7 | 38000 | 1/((1+6%)^7) | 0.665 | 25,272.17 |
8 | 38000 | 1/((1+6%)^8) | 0.627 | 23,841.67 |
9 | 38000 | 1/((1+6%)^9) | 0.592 | 22,492.14 |
10 | 42000 | 1/((1+6%)^10) | 0.558 | 23,452.58 |
PV | 1,21,172.63 |