.. * COLORADO WATER CONSER VA TION BOARD
<br />LOAN REPAYMENT SCHEDULE
<br />Borrower
<br />The Water Supply and Storage
<br />Annual
<br />Company
<br />Loan Contract Number
<br />C150281
<br />Principal
<br />$704,503.91
<br />Interest Rate
<br />3.70%
<br />Frequency
<br />Annual
<br />Term (In Years)
<br />30
<br />First Payment Due
<br />April 1, 2011
<br />Payment Amount
<br />$39,270.64
<br />Loan
<br />Annual
<br />Annual
<br />$
<br />13,204.00
<br />$
<br />Payment
<br />Payment
<br />Payment
<br />Principal
<br />Interest
<br />Principal
<br />No.
<br />Due Date
<br />Amount
<br />25,578.10
<br />$
<br />BALANCE
<br />$ 704,503.91
<br />1
<br />1- Apr -11
<br />$39,270.64
<br />$
<br />13,204.00
<br />$
<br />26,066.64
<br />$
<br />691,299.91
<br />2
<br />1- Apr -12
<br />$39,270.64
<br />$
<br />13,692.54
<br />$
<br />25,578.10
<br />$
<br />677,607.37
<br />3
<br />1- Apr -13
<br />$39,270.64
<br />$
<br />14,199.17
<br />$
<br />25,071.47
<br />$
<br />663,408.20
<br />4
<br />1- Apr -14
<br />$39,270.64
<br />$
<br />14,724.54
<br />$
<br />24,546.10
<br />$
<br />648,683.66
<br />5
<br />1- Apr -15
<br />$39,270.64
<br />$
<br />15,269.34
<br />$
<br />24,001.30
<br />$
<br />633,414.32
<br />6
<br />1- Apr -16
<br />$39,270.64
<br />$
<br />15,834.31
<br />$
<br />23,436.33
<br />$
<br />617,580.01
<br />7
<br />1- Apr -17
<br />$39,270.64
<br />$
<br />16,420.18
<br />$
<br />22,850.46
<br />$
<br />601,159.83
<br />8
<br />1- Apr -18
<br />$39,270.64
<br />$
<br />17,027.73
<br />$
<br />22,242.91
<br />$
<br />584,132.10
<br />9
<br />1- Apr -19
<br />$39,270.64
<br />$
<br />17,657.75
<br />$
<br />21,612.89
<br />$
<br />566,474.35
<br />10
<br />1- Apr -20
<br />$39,270.64
<br />$
<br />18,311.09
<br />$
<br />20,959.55
<br />$
<br />548,163.26
<br />11
<br />1- Apr -21
<br />$39,270.64
<br />$
<br />18,988.60
<br />$
<br />20,282.04
<br />$
<br />529,174.66
<br />12
<br />1- Apr -22
<br />$39,270.64
<br />$
<br />19,691.18
<br />$
<br />19,579.46
<br />$
<br />509,483.48
<br />13
<br />1- Apr -23
<br />$39,270.64
<br />$
<br />20,419.75
<br />$
<br />18,850.89
<br />$
<br />489,063.73
<br />14
<br />1- Apr -24
<br />$39,270.64
<br />$
<br />21,175.28
<br />$
<br />18,095.36
<br />$
<br />467,888.45
<br />15
<br />1- Apr -25
<br />$39,270.64
<br />$
<br />21,958.77
<br />$
<br />17,311.87
<br />$
<br />445,929.68
<br />16
<br />1- Apr -26
<br />$39,270.64
<br />$
<br />22,771.24
<br />$
<br />16,499.40
<br />$
<br />423,158.44
<br />17
<br />1- Apr -27
<br />$39,270.64
<br />$
<br />23,613.78
<br />$
<br />15,656.86
<br />$
<br />399,544.66
<br />18
<br />1- Apr -28
<br />$39,270.64
<br />$
<br />24,487.49
<br />$
<br />14,783.15
<br />$
<br />375,057.17
<br />19
<br />1- Apr -29
<br />$39,270.64
<br />$
<br />25,393.52
<br />$
<br />13,877.12
<br />$
<br />349,663.65
<br />20
<br />1- Apr -30
<br />$39,270.64
<br />$
<br />26,333.08
<br />$
<br />12,937.56
<br />$
<br />323,330.57
<br />21
<br />1- Apr -31
<br />$39,270.64
<br />$
<br />27,307.41
<br />$
<br />11,963.23
<br />$
<br />296,023.16
<br />22
<br />1- Apr -32
<br />$39,270.64
<br />$
<br />28,317.78
<br />$
<br />10,952.86
<br />$
<br />267,705.38
<br />23
<br />1- Apr -33
<br />$39,270.64
<br />$
<br />29,365.54
<br />$
<br />9,905.10
<br />$
<br />238,339.84
<br />24
<br />1- Apr -34
<br />$39,270.64
<br />$
<br />30,452.07
<br />$
<br />8,818.57
<br />$
<br />207,887.77
<br />25
<br />1- Apr -35
<br />$39,270.64
<br />$
<br />31,578.79
<br />$
<br />7,691.85
<br />$
<br />176,308.98
<br />26
<br />I- Apr -36
<br />$39,270.64
<br />$
<br />32,747.21
<br />$
<br />6,523.43
<br />$
<br />143,561.77
<br />27
<br />1- Apr -37
<br />$39,270.64
<br />$
<br />33,958.85
<br />$
<br />5,311.79
<br />$
<br />109,602.92
<br />28
<br />1- Apr -38
<br />$39,270.64
<br />$
<br />35,215.33
<br />$
<br />4,055.31
<br />$
<br />74,387.59
<br />29
<br />1- Apr -39
<br />$39,270.64
<br />$
<br />36,518.30
<br />$
<br />2,752.34
<br />$
<br />37,869.29
<br />30
<br />1- Apr-40
<br />$39,270.45
<br />$
<br />37,869.29
<br />$
<br />1,40116
<br />$
<br />-
<br />TOTALS $1,178,119.01 $704,503.91 1 $473,615.10 1 $0.00
<br />Amort Water Supply C 150281 0409.xls SSB 3/3/2010
<br />
|