In: Finance
Given the new found interest in nuclear power plants due to potential carbon taxes, you consider starting a company to build a nuclear power plant. Before you can build the plant, you need to gather permits, fight lawsuits and so forth. That will cost $800 million today and take 5 years to resolve with a 35% probability of success. If you build the plant, you must pay $9 billion the day you start building the plant, which is immediately after the lawsuits etc are resolved. The power plant itself takes 4 years to build. At that point the plant starts operating (exactly 4 years from when construction started). You receive $1 billion per year for 50 years starting one year from when the plant starts operating. At the end of the project, you have to pay $3 billion to shut down the plant. Your discount rate is 6% (annual rate, annual compounding).
Assume that you made the $800 million investment and the 5 years of permits, lawsuits and so forth have passed. The $800 million investment was successful. Now you are debating if you should make the plant or not today. What is the NPV of the plant?
Since project NPV is $$2,285 million, hence you should accept the project.
| Amount in $ millions | |||
| Investment made five year before | -800 | ||
| Value of investment after 5 years (year 0) at 6% interest rate | -1,071 | ||
| Investment needed after 5 years (year 0) | -9,000 | ||
| Project cash flow every year (from year 5) | 1,000 | ||
| Payment to shut the plant at the end of project (year 54) | -3,000 | ||
| Discount rate | 6% | ||
| Project NPV | 2,285 | ||
| Year | Cash flows | Discount factor (at 6%) | Discounted cash flow |
| 0 | -10,071 | 1.000 | -10,071 |
| 1 | 0 | 0.943 | 0 |
| 2 | 0 | 0.890 | 0 |
| 3 | 0 | 0.840 | 0 |
| 4 | 0 | 0.792 | 0 |
| 5 | 1,000 | 0.747 | 747 |
| 6 | 1,000 | 0.705 | 705 |
| 7 | 1,000 | 0.665 | 665 |
| 8 | 1,000 | 0.627 | 627 |
| 9 | 1,000 | 0.592 | 592 |
| 10 | 1,000 | 0.558 | 558 |
| 11 | 1,000 | 0.527 | 527 |
| 12 | 1,000 | 0.497 | 497 |
| 13 | 1,000 | 0.469 | 469 |
| 14 | 1,000 | 0.442 | 442 |
| 15 | 1,000 | 0.417 | 417 |
| 16 | 1,000 | 0.394 | 394 |
| 17 | 1,000 | 0.371 | 371 |
| 18 | 1,000 | 0.350 | 350 |
| 19 | 1,000 | 0.331 | 331 |
| 20 | 1,000 | 0.312 | 312 |
| 21 | 1,000 | 0.294 | 294 |
| 22 | 1,000 | 0.278 | 278 |
| 23 | 1,000 | 0.262 | 262 |
| 24 | 1,000 | 0.247 | 247 |
| 25 | 1,000 | 0.233 | 233 |
| 26 | 1,000 | 0.220 | 220 |
| 27 | 1,000 | 0.207 | 207 |
| 28 | 1,000 | 0.196 | 196 |
| 29 | 1,000 | 0.185 | 185 |
| 30 | 1,000 | 0.174 | 174 |
| 31 | 1,000 | 0.164 | 164 |
| 32 | 1,000 | 0.155 | 155 |
| 33 | 1,000 | 0.146 | 146 |
| 34 | 1,000 | 0.138 | 138 |
| 35 | 1,000 | 0.130 | 130 |
| 36 | 1,000 | 0.123 | 123 |
| 37 | 1,000 | 0.116 | 116 |
| 38 | 1,000 | 0.109 | 109 |
| 39 | 1,000 | 0.103 | 103 |
| 40 | 1,000 | 0.097 | 97 |
| 41 | 1,000 | 0.092 | 92 |
| 42 | 1,000 | 0.087 | 87 |
| 43 | 1,000 | 0.082 | 82 |
| 44 | 1,000 | 0.077 | 77 |
| 45 | 1,000 | 0.073 | 73 |
| 46 | 1,000 | 0.069 | 69 |
| 47 | 1,000 | 0.065 | 65 |
| 48 | 1,000 | 0.061 | 61 |
| 49 | 1,000 | 0.058 | 58 |
| 50 | 1,000 | 0.054 | 54 |
| 51 | 1,000 | 0.051 | 51 |
| 52 | 1,000 | 0.048 | 48 |
| 53 | 1,000 | 0.046 | 46 |
| 54 | -2,000 | 0.043 | -86 |
Excel formula:


