A company is analyzing the possibility of building a power plant with an initial investment of $ 400,000 that will save $ 60,000 per year in terms of production losses and energy cost reductions. This power plant has an economic life of 20 years and requires an overhaul every 10 years of operation at a cost of $ 30,000. Perform a comprehensive economic analysis (Net present value and IRR) to determine whether the investment is feasible or not. Given the 15% capital cost and residual value of the power plant at the end of the 20th year is $ 40,000.
Year | Cash flows | cost of capital | PV of cash flows |
0 | -$4,00,000 | $1 | -$4,00,000 |
1 | $60,000 | $0.870 | $52,173.91 |
2 | $60,000 | $0.756 | $45,368.62 |
3 | $60,000 | $0.658 | $39,450.97 |
4 | $60,000 | $0.572 | $34,305.19 |
5 | $60,000 | $0.497 | $29,830.60 |
6 | $60,000 | $0.432 | $25,939.66 |
7 | $60,000 | $0.376 | $22,556.22 |
8 | $60,000 | $0.327 | $19,614.11 |
9 | $60,000 | $0.284 | $17,055.74 |
10 | $30,000 | $0.247 | $7,415.54 |
11 | $60,000 | $0.215 | $12,896.59 |
12 | $60,000 | $0.187 | $11,214.43 |
13 | $60,000 | $0.163 | $9,751.68 |
14 | $60,000 | $0.141 | $8,479.72 |
15 | $60,000 | $0.123 | $7,373.67 |
16 | $60,000 | $0.107 | $6,411.89 |
17 | $60,000 | $0.093 | $5,575.55 |
18 | $60,000 | $0.081 | $4,848.31 |
19 | $60,000 | $0.070 | $4,215.92 |
20 | $70,000 | $0.061 | $4,277.02 |
NPV | -$31,244.65 |
IRR = 14%
This is not a feasiblw investment as the NPV is negaitve.
Get Answers For Free
Most questions answered within 1 hours.