|
<br />............................................
<br />
<br />
<br />Chapter VIII - Financial Analysis for the LTWD
<br />
<br />
<br />
<br />Table VIII-I: LTWD Annual Expenditures and Revenues
<br />
<br /> Financin~
<br />Source Principal Rate Years Payment
<br />Loan @ 90% $4,945,500 3.60% 20 $351,126.72
<br />
<br />(rounded)
<br />
<br />$4,945,500
<br />
<br />0.5%
<br />6%
<br />
<br />Assumptions
<br />
<br />Increase
<br />
<br />@90%
<br />
<br />Operating Expenses
<br />on Reserves
<br />
<br />Loan Amount
<br />
<br />Annual
<br />Interest
<br />
<br />Total
<br />
<br />Debt Service
<br />Coverage
<br />Ratio
<br />
<br />Total
<br />Expenditures
<br />
<br />CWCB Interest
<br />
<br />on Reserve
<br />Funds
<br />
<br />Expenditures
<br />
<br />Payments on
<br />CWCB Loan
<br />
<br />Annual
<br />
<br />Loan
<br />Reserve Fund
<br />
<br />Existing Debt
<br />Service
<br />
<br />Annual
<br />Operating
<br />Expenses
<br />
<br />Annual
<br />Revenues
<br />
<br />1.02
<br />1.01
<br />1.01
<br />1.00
<br />1.00
<br />1.00
<br />0,99
<br />0.98
<br />0,99
<br />0.97
<br />0.98
<br />0.98
<br />0.97
<br />0.96
<br />2.16
<br />3.34
<br />3.32
<br />3.30
<br />3.27
<br />3.76
<br />
<br />$5,054,854
<br />$5,068,584
<br />$5,076,810
<br />$5,089,562
<br />$5,097,406
<br />$5,107,595
<br />$5,121,719
<br />$5,138,224
<br />$5,116,617
<br />$5,158,467
<br />$5,133,898
<br />$5,147,059
<br />$5,167,297
<br />$5,202,041
<br />$3,940,513
<br />$3,595,476
<br />$3,610,348
<br />$3,625,294
<br />$3,640,315
<br />$3,325,353
<br />
<br />$2,107
<br />$4,214
<br />$6,320
<br />$8,427
<br />$10,534
<br />$12,641
<br />$14,747
<br />$16,854
<br />$18,961
<br />$21,068
<br />$21,068
<br />$21,068
<br />$21,068
<br />$21,068
<br />$21,068
<br />$21,068
<br />$21,068
<br />$21,068
<br />$21,068
<br />$0
<br />
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351.127
<br />
<br />Summation
<br />
<br />$35,113
<br />$70,225
<br />$105,338
<br />$140,451
<br />$175,563
<br />$210,676
<br />$245,789
<br />$280,901
<br />$316,014
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$351,127
<br />$0
<br />
<br />127)
<br />
<br />~o I $5,091,337 I $7,022,534 I $305,480 I $93,417,434 L
<br />- -
<br />25 BOVLE
<br />
<br />Annual
<br />
<br />$35,113
<br />$35,113
<br />$35,113
<br />$35,113
<br />$35,113
<br />$35,113
<br />$35,113
<br />$35,113
<br />$35,113
<br />$35,113
<br />
<br />($351
<br />
<br />$28,798,021
<br />
<br />$57,902,359
<br />
<br />$96,900,000
<br />
<br />Year of
<br />Operation Year
<br />-
<br />1 2007
<br />2 2008
<br />3 2009
<br />4 2010
<br />5 2011
<br />6 2012
<br />7 2013
<br />8 2014
<br />9 2015
<br />10 2016
<br />11 2017
<br />12 2018
<br />13 2019
<br />14 2020
<br />15 2021
<br />16 2022
<br />17 2023
<br />18 2024
<br />19 2025
<br />20 2026
<br /> -
<br />Totals
<br /> -
<br /> -
<br />Dry Creek Reservoir Project
<br />
<br />$1,910,721
<br />$1,912,758
<br />$1,909,222
<br />$1,910,142
<br />$1,906,085
<br />$1,904,302
<br />$1,906,385
<br />$1,910,777
<br />$1,876,987
<br />$1,906,582
<br />$1,902,692
<br />$1,901,347
<br />$1,907,007
<br />$1,927,100
<br />$650,847
<br />$291,012
<br />$291,012
<br />$291,012
<br />$291,012
<br />$291,012
<br />
<br />$2,760,000
<br />$2,773,800
<br />$2,787,669
<br />$2,801,607
<br />$2,815,615
<br />$2,829,693
<br />$2,843,842
<br />$2,858,061
<br />$2,872,351
<br />$2,886,713
<br />$2,901,147
<br />$2,915,652
<br />$2,930,231
<br />$2,944,882
<br />$2,959,606
<br />$2,974,404
<br />$2,989,276
<br />$3,004,223
<br />
<br />$3,019,244
<br />$3,034,340
<br />
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />$5,100,000
<br />
|