|
Table 4-Financial Analysis-Planning Scenario _
<br /> Assumptions
<br /> Initial Generation(kw-hrs): 4,800,000 Design and Permitting Costs(not Financed)(1) $ 500,000 \
<br /> Final Maximum Generation: 4,800,000 Construction Cost $ 5,000,000
<br /> Generation Escalation(%): 0.0% 5%Contingency: $ 250,000
<br /> Construction Interest 52,500
<br /> CWRPDA Loan $ - 1%Service Fee 52,500
<br /> Low Interest Rate 2% Loan Amount $ 5,407,500
<br /> Term(years): 20
<br /> CWCB Loan: $5,407,500 Note:Assumes Loan reserve pays final year.
<br /> Loan Rate: 2.0%
<br /> Term(years): 30 Net Present Value of Costs $6,190,612
<br /> Net Present Value of Revenue $6,525,486
<br /> O&M Amount: $ 50,000 Prsnt Val of Revenue minus Costs $ 334,874
<br /> O&M Escalation(%): 1.5% Benefit/Cost Ratio 1.05
<br /> Lease Power Priv. Escal.(%): 1.5%
<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 0&M Payment Annual Cost Ann.Rev.(3) Revenue Revenue Less Pre.Costs
<br /> 2015 Construction lyr $ - $ - $ - $ - $ - $ - $ (500,000)
<br /> 2016 3,201,600 11,143 50,000 8,403 69,547 235,136 165,590 165,590 $ (334,410)
<br /> 2017 4,800,000 - 265,589 13,084 50,750 11,774 341,197 300,735 (40,462) 125,128 $ (374,872)
<br /> 2018 4,800,000 - 265,589 13,084 51,511 11,951 342,135 319,571 (22,564) 102,564 $ (397,436)
<br /> 2019 4,800,000 - 265,589 13,084 52,284 12,130 343,087 340,796 (2,291) 100,273 $ (399,727)
<br /> 2020 4,800,000 - 265,589 13,084 53,068 12,312 344,053 354,058 10,005 110,279 $ (389,721)
<br /> 2021 4,800,000 - 265,589 13,084 53,864 12,496 345,033 349,874 4,841 115,119 $ (384,881)
<br /> 2022 4,800,000 - 265,589 13,084 54,672 12,684 346,029 359,065 13,036 128,156 $ (371,844)
<br /> 2023 4,800,000 - 265,589 13,084 55,492 12,874 347,039 367,119 20,080 148,236 $ (351,764)
<br /> 2024 4,800,000 - 265,589 13,084 56,325 13,067 348,065 372,579 24,515 172,750 $ (327,250)
<br /> 2025 4,800,000 - 265,589 13,084 57,169 13,263 349,106 376,788 27,683 200,433 $ (299,567)
<br /> 2026 4,800,000 - 265,589 13,084 58,027 13,462 350,162 349,431 (731) 199,702 $ (300,298)
<br /> 2027 4,800,000 - 241,444 13,084 58,897 13,664 327,090 349,431 22,341 222,043 $ (277,957)
<br /> 2028 4,800,000 - 241,444 13,084 59,781 13,869 328,178 349,431 21,253 243,296 $ (256,704)
<br /> 2029 4,800,000 - 241,444 13,084 60,678 14,077 329,283 349,431 20,148 263,443 $ (236,557)
<br /> 2030 4,800,000 - 241,444 13,084 61,588 14,288 330,404 349,431 19,027 282,470 $ (217,530)
<br /> 2031 4,800,000 - 241,444 13,084 62,512 14,503 331,543 349,431 17,888 300,358 $ (199,642)
<br /> 2032 4,800,000 - 241,444 13,084 63,449 14,720 332,698 349,431 16,733 317,091 $ (182,909)
<br /> 2033 4,800,000 - 241,444 13,084 64,401 14,941 333,870 349,431 15,561 332,652 $ (167,348)
<br /> 2034 4,800,000 - 241,444 13,084 65,367 15,165 335,061 349,431 14,370 347,023 $ (152,977)
<br /> 2035 4,800,000 - 241,444 13,084 66,348 15,393 336,268 349,431 13,163 360,185 $ (139,815)
<br /> 2036 4,800,000 - 241,444 13,084 67,343 15,624 337,495 349,431 11,936 372,121 $ (127,879)
<br /> 2037 4,800,000 - 241,444 13,084 68,353 15,858 338,739 349,431 10,692 382,813 $ (117,187)
<br /> 2038 4,800,000 - 241,444 13,084 69,378 16,096 340,002 349,431 9,429 392,242 $ (107,758)
<br /> 2039 4,800,000 - 241,444 13,084 70,419 16,337 341,284 349,431 8,147 400,389 $ (99,611)
<br /> 2040 4,800,000 - 241,444 13,084 71,475 16,582 342,586 349,431 6,845 407,234 $ (92,766)
<br /> 2041 4,800,000 - 241,444 13,084 72,547 16,831 343,907 349,431 5,524 412,758 $ (87,242)
<br /> 2042 4,800,000 - 241,444 13,084 73,635 17,083 345,247 349,431 4,184 416,942 $ (83,058)
<br /> 2043 4,800,000 - 241,444 13,084 74,740 17,340 346,608 349,431 2,823 419,765 $ (80,235)
<br /> 2044 4,800,000 - 241,444 13,084 75,861 17,600 347,989 349,431 1,442 421,207 $ (78,793)
<br /> 2045 4,800,000 - 241,444 13,084 76,999 17,864 349,391 349,431 40 421,247 $ (78,753)
<br /> 2046 4,800,000 - - 13,084 78,154 18,132 109,370 349,431 240,061 661,308 $ 161,308
<br /> 2047 4,800,000 - - 13,084 79,326 18,404 110,814 349,431 238,617 899,925 $ 399,925
<br /> 2048 4,800,000 - - 13,084 80,516 18,680 112,280 349,431 237,151 1,137,077 $ 637,077
<br /> 2049 4,800,000 - - 13,084 81,724 18,960 113,768 349,431 235,663 1,372,740 $ 872,740
<br /> 2050 4,800,000 - - 13,084 82,950 19,244 115,278 349,431 234,153 1,606,893 $ 1,106,893
<br /> 2051 4,800,000 - - 13,084 84,194 19,533 116,811 349,431 232,620 1,839,513 $ 1,339,513
<br /> 2052 4,800,000 - - 13,084 85,457 19,826 118,367 349,431 231,064 2,070,577 $ 1,570,577
<br /> 2053 4,800,000 - - 13,084 86,739 20,123 119,946 349,431 229,485 2,300,062 $ 1,800,062
<br /> 2054 4,800,000 - - 13,084 88,040 20,425 121,549 349,431 227,882 2,527,944 $ 2,027,944
<br /> 2055 4,800,000 - - 13,084 89,361 20,732 123,176 349,431 226,255 2,754,199 $ 2,254,199
<br /> Notes
<br /> 1)NW unfinanced costs include the following:CH2MHiII 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 l0 years.
<br /> 3)Assumes revenue after 30 year term to be the same as year 30.
<br /> 12
<br />
|