In: Accounting
A flood control project has construction cost during the first year (i.e. at EOY 1) of $10 million, during the second year of $7 million, and during the third year of $4 million, It is completed at the end of the third year and thereafter incurs an annual operating cost of $170,000 per year. Benefits from the project begin during the fourth year and are valued at $1,300,000 in that year, growing at a 2% rate of increase out to the end of the project life, which is 50 years (i.e., three years of construction, 47 years of operation). Assuming an interest rate of 7%, determine if this is a viable project, that is do the capitalized benefits exceed the capitalized costs?
Justification has been provided below :-



Detailed table of present value of benefits for 47 years has been provided below :-
| Year | Amount(In $) | Present value factor @ 7% | Present value |
| 1 | 1300000 | 0.93458 | 1214953 |
| 2 | 1326000 | 0.87344 | 1158180 |
| 3 | 1352520 | 0.81630 | 1104059 |
| 4 | 1379570 | 0.76290 | 1052468 |
| 5 | 1407162 | 0.71299 | 1003287 |
| 6 | 1435305 | 0.66634 | 956404 |
| 7 | 1464011 | 0.62275 | 911713 |
| 8 | 1493291 | 0.58201 | 869109 |
| 9 | 1523157 | 0.54393 | 828497 |
| 10 | 1553620 | 0.50835 | 789782 |
| 11 | 1584693 | 0.47509 | 752876 |
| 12 | 1616387 | 0.44401 | 717695 |
| 13 | 1648714 | 0.41496 | 684158 |
| 14 | 1681689 | 0.38782 | 652188 |
| 15 | 1715322 | 0.36245 | 621712 |
| 16 | 1749629 | 0.33873 | 592660 |
| 17 | 1784621 | 0.31657 | 564965 |
| 18 | 1820314 | 0.29586 | 538565 |
| 19 | 1856720 | 0.27651 | 513399 |
| 20 | 1893855 | 0.25842 | 489408 |
| 21 | 1931732 | 0.24151 | 466538 |
| 22 | 1970366 | 0.22571 | 444738 |
| 23 | 2009774 | 0.21095 | 423955 |
| 24 | 2049969 | 0.19715 | 404144 |
| 25 | 2090968 | 0.18425 | 385259 |
| 26 | 2132788 | 0.17220 | 367256 |
| 27 | 2175444 | 0.16093 | 350095 |
| 28 | 2218952 | 0.15040 | 333735 |
| 29 | 2263331 | 0.14056 | 318140 |
| 30 | 2308598 | 0.13137 | 303274 |
| 31 | 2354770 | 0.12277 | 289102 |
| 32 | 2401865 | 0.11474 | 275593 |
| 33 | 2449903 | 0.10723 | 262715 |
| 34 | 2498901 | 0.10022 | 250438 |
| 35 | 2548879 | 0.09366 | 238735 |
| 36 | 2599856 | 0.08754 | 227580 |
| 37 | 2651854 | 0.08181 | 216945 |
| 38 | 2704891 | 0.07646 | 206807 |
| 39 | 2758988 | 0.07146 | 197144 |
| 40 | 2814168 | 0.06678 | 187931 |
| 41 | 2870452 | 0.06241 | 179149 |
| 42 | 2927861 | 0.05833 | 170778 |
| 43 | 2986418 | 0.05451 | 162798 |
| 44 | 3046146 | 0.05095 | 155190 |
| 45 | 3107069 | 0.04761 | 147938 |
| 46 | 3169210 | 0.04450 | 141025 |
| 47 | 3232595 | 0.04159 | 134435 |
| Total | 23257520 |