COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Lookout Mountain Water District
<br /> Loan Contract Number C153598 RE2016-247
<br /> Principal $600,000.00
<br /> Interest Rate 5.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due February 1,1993
<br /> Payment Amount $39,030.86
<br /> Loan Annual Annual Principal
<br /> Payment Payment Due Payment Principal Interest BALANCE
<br /> No. Date Amount
<br /> $ 600,000.00
<br /> 1 1-Feb-93 $39,030.00 $ 9,031.15 $ 29,998.85 $ 590,968.85
<br /> 2 1-Feb-94 $39,030.86 $ 9,482.42 $ 29,548.44 $ 581,486.43
<br /> 3 1-Feb-95 $39,030.86 $ 9,956.54 $ 29,074.32 $ 571,529.89
<br /> 4 1-Feb-96 $39,030.86 $ 10,454.37 $ 28,576.49 $ 561,075.52
<br /> 5 1-Feb-97 $39,030.86 $ 10,977.08 $ 28,053.78 $ 550,098.44
<br /> 6 1-Feb-98 $39,030.86 $ 11,525.94 $ 27,504.92 $ 538,572.50
<br /> 7 1-Feb-99 $39,030.86 $ 12,102.23 $ 26,928.63 $ 526,470.27
<br /> 8 1-Mar-00 $39,030.86 $ 12,708.53 $ 26,322.33 $ 513,761.74
<br /> 9 1-Mar-01 $39,030.86 $ 13,342.63 $ 25,688.23 $ 500,419.11
<br /> 10 1-Mar-02 $39,030.86 $ 14,008.75 $ 25,022.11 $ 486,410.36
<br /> 11 1-Mar-03 $39,030.86 $ 14,710.34 $ 24,320.52 $ 471,700.02
<br /> 12 1-Mar-04 $39,030.86 $ 15,445.86 $ 23,585.00 $ 456,254.16
<br /> 13 1-Mar-05 $39,030.86 $ 16,218.15 $ 22,812.71 $ 440,036.01
<br /> 14 1-Mar-06 $39,030.86 $ 17,029.06 $ 22,001.80 $ 423,006.95
<br /> 15 1-Mar-07 $39,030.86 $ 17,880.51 $ 21,150.35 $ 405,126.44
<br /> 16 1-Mar-08 $39,030.86 $ 18,774.54 $ 20,256.32 $ 386,351.90
<br /> 17 1-Mar-09 $39,030.86 $ 19,713.26 $ 19,317.60 $ 366,638.64
<br /> 18 1-Mar-10 $39,030.86 $ 20,698.93 $ 18,331.93 $ 345,939.71
<br /> 19 1-Mar-11 $39,030.86 $ 21,733.87 $ 17,296.99 $ 324,205.84
<br /> 20 1-Mar-12 $39,030.86 $ 22,820.57 $ 16,210.29 $ 301,385.27
<br /> 21 1-Mar-13 $39,030.86 $ 23,961.60 $ 15,069.26 $ 277,423.67
<br /> 22 1-Mar-14 $39,030.86 $ 25,159.68 $ 13,871.18 $ 252,263.99
<br /> 23 1-Mar-15 $39,030.86 $ 26,417.66 $ 12,613.20 $ 225,846.33
<br /> 24 1-Mar-16 $39,030.86 $ 27,738.54 $ 11,292.32 $ 198,107.79
<br /> 25 1-Mar-17 $39,030.86 $ 29,125.47 $ 9,905.39 $ 168,982.32
<br /> 26 1-Mar-18 $39,030.86 $ 30,581.74 $ 8,449.12 $ 138,400.58
<br /> 27 1-Mar-19 $39,030.86 $ 32,110.83 $ 6,920.03 $ 106,289.75
<br /> 28 1-Mar-20 $39,030.86 $ 33,716.37 $ 5,314.49 $ 72,573.38
<br /> 29 1-Mar-21 $39,030.86 $ 35,402.19 $ 3,628.67 $ 37,171.19
<br /> 30 1-Mar-22 $39,029.75 $ 37,171.19 $ 1,858.56 $ -
<br /> TOTALS [$1,170,923.831 $600,000.00 1 $570,923.83 T $0.00
<br /> SSB 03/01/01
<br /> Amort Lookout C153598.xls 2/17/2017
<br />
|