Table 5-Financial Analysis-Probable Scenario
<br /> Assumptions
<br /> Initial Generation(kw-hrs): 5,000,000 Design and Permitting Costs(not Financed)(1) $ 500,000
<br /> Final Maximum Generation: 5,000,000 Construction Cost $ 4,900,000
<br /> Generation Escalation(%): 0.0% 2%Contingency: $ 98,000
<br /> Construction Interest 49,980
<br /> CWRPDA Loan $ - 1%Service Fee 49,980
<br /> Low Interest Rate 2% Loan Amount $ 5,147,940
<br /> Term(years): 20
<br /> CWCB Loan: $5,147,940 Note:Assumes Loan reserve pays final year.
<br /> Loan Rate: 2.0%
<br /> Term(years): 30 Net Present Value of Costs $ 5,960,918
<br /> Net Present Value of Revenue $7,078,185
<br /> O&M Amount: $ 50,000 Prsnt.Val.of Revenue minus Costs $ 1,117,268
<br /> O&M Escalation(%): 1.5% Benefit/Cost Ratio 1.19
<br /> Lease Power Priv. Escal.(%): 0.0%
<br /> Internal Discount Rate(%): 4.0%
<br /> 1 2 3 4 5 6 7 8 9 10 11 12
<br /> Generation CWRPDA CWCB MPEI USBR LPP Total Total Annual Net Cummulative Cumm.Rev.
<br /> Year (kw-hrs) Payment Pmt.(2) Payment O&M Payment Annual Cost Ann.Rev.(3) Revenue Revenue Less Pre.Costs
<br /> 2015 Construction 1 yr $ - $ - $ - $ - $ - $ - $ (500,000)
<br /> 2016 3,335,000 11,608 50,000 8,670 70,278 244,934 174,656 174,656 $ (325,344)
<br /> 2017 5,000,000 - 252,841 13,629 50,750 12,000 329,220 313,268 (15,952) 158,704 $ (341,296)
<br /> 2018 5,000,000 - 252,841 13,629 51,511 12,000 329,981 332,886 2,905 161,609 $ (338,391)
<br /> 2019 5,000,000 - 252,841 13,629 52,284 12,000 330,754 354,992 24,238 185,847 $ (314,153)
<br /> 2020 5,000,000 - 252,841 13,629 53,068 12,000 331,538 368,809 37,271 223,118 $ (276,882)
<br /> 2021 5,000,000 - 252,841 13,629 53,864 12,000 332,334 364,454 32,120 255,239 $ (244,761)
<br /> 2022 5,000,000 - 252,841 13,629 54,672 12,000 333,142 374,029 40,887 296,126 $ (203,874)
<br /> 2023 5,000,000 - 252,841 13,629 55,492 12,000 333,962 382,416 48,454 344,580 $ (155,420)
<br /> 2024 5,000,000 - 252,841 13,629 56,325 12,000 334,794 388,104 53,310 397,890 $ (102,110)
<br /> 2025 5,000,000 - 252,841 13,629 57,169 12,000 335,639 392,489 56,850 454,740 $ (45,260)
<br /> 2026 5,000,000 - 252,841 13,629 58,027 12,000 336,497 388,990 52,493 507,233 $ 7,233
<br /> 2027 5,000,000 - 229,855 13,629 58,897 12,000 314,382 388,990 74,608 581,841 $ 81,841
<br /> 2028 5,000,000 - 229,855 13,629 59,781 12,000 315,265 388,990 73,724 655,565 $ 155,565
<br /> 2029 5,000,000 - 229,855 13,629 60,678 12,000 316,162 388,990 72,828 728,393 $ 228,393
<br /> 2030 5,000,000 - 229,855 13,629 61,588 12,000 317,072 388,990 71,918 800,310 $ 300,310
<br /> 2031 5,000,000 - 229,855 13,629 62,512 12,000 317,996 388,990 70,994 871,304 $ 371,304
<br /> 2032 5,000,000 - 229,855 13,629 63,449 12,000 318,933 388,990 70,056 941,360 $ 441,360
<br /> 2033 5,000,000 - 229,855 13,629 64,401 12,000 319,885 388,990 69,104 1,010,464 $ 510,464
<br /> 2034 5,000,000 - 229,855 13,629 65,367 12,000 320,851 388,990 68,138 1,078,603 $ 578,603
<br /> 2035 5,000,000 - 229,855 13,629 66,348 12,000 321,832 388,990 67,158 1,145,761 $ 645,761
<br /> 2036 5,000,000 - 229,855 13,629 67,343 12,000 322,827 388,990 66,163 1,211,923 $ 711,923
<br /> 2037 5,000,000 - 229,855 13,629 68,353 12,000 323,837 388,990 65,152 1,277,076 $ 777,076
<br /> 2038 5,000,000 - 229,855 13,629 69,378 12,000 324,862 388,990 64,127 1,341,203 $ 841,203
<br /> 2039 5,000,000 - 229,855 13,629 70,419 12,000 325,903 388,990 63,086 1,404,289 $ 904,289
<br /> 2040 5,000,000 - 229,855 13,629 71,475 12,000 326,959 388,990 62,030 1,466,319 $ 966,319
<br /> 2041 5,000,000 - 229,855 13,629 72,547 12,000 328,031 388,990 60,958 1,527,278 $ 1,027,278
<br /> 2042 5,000,000 - 229,855 13,629 73,635 12,000 329,120 388,990 59,870 1,587,147 $ 1,087,147
<br /> 2043 5,000,000 - 229,855 13,629 74,740 12,000 330,224 388,990 58,765 1,645,913 $ 1,145,913
<br /> 2044 5,000,000 - 229,855 13,629 75,861 12,000 331,345 388,990 57,644 1,703,557 $ 1,203,557
<br /> 2045 5,000,000 - 229,855 13,629 76,999 12,000 332,483 388,990 56,506 1,760,063 $ 1,260,063
<br /> 2046 5,000,000 - - 13,629 78,154 12,000 103,783 388,990 285,206 2,045,270 $ 1,545,270
<br /> 2047 5,000,000 - - 13,629 79,326 12,000 104,955 388,990 284,034 2,329,304 $ 1,829,304
<br /> 2048 5,000,000 - - 13,629 80,516 12,000 106,145 388,990 282,844 2,612,148 $ 2,112,148
<br /> 2049 5,000,000 - - 13,629 81,724 12,000 107,353 388,990 281,637 2,893,785 $ 2,393,785
<br /> 2050 5,000,000 - - 13,629 82,950 12,000 108,579 388,990 280,411 3,174,195 $ 2,674,195
<br /> 2051 5,000,000 - - 13,629 84,194 12,000 109,823 388,990 279,166 3,453,362 $ 2,953,362
<br /> 2052 5,000,000 - - 13,629 85,457 12,000 111,086 388,990 277,903 3,731,265 $ 3,231,265
<br /> 2053 5,000,000 - - 13,629 86,739 12,000 112,368 388,990 276,622 4,007,887 $ 3,507,887
<br /> 2054 5,000,000 - - 13,629 88,040 12,000 113,669 388,990 275,321 4,283,207 $ 3,783,207
<br /> 2055 5,000,000 - - 13,629 89,361 12,000 114,990 388,990 274,000 4,557,207 $ 4,057,207
<br /> Notes
<br /> 1)NW unfinanced costs include the following:CH2MHilI Feasibility and Design,Reclamation LOPP costs.,and MPEI system study($300k to date).
<br /> 2)CWCB loan reserve built up at 10%of payment for 10 years.
<br /> 3)Assumes revenue after 30year term to be the same as year 30.
<br /> 13
<br />
|