|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Uncompahgre Valley Water Users
<br /> Borrower Association FINAL
<br /> Loan Contract Number CT 2015-174
<br /> Principal $6,999,300.00 $5,426,813.80
<br /> Interest Rate 2.00% 2.00%
<br /> Frequency Annual Annual
<br /> Term(in Years) 20 20
<br /> First Payment Due April 1,2018
<br /> Payment Amount $428,054.22 $331,886.12
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> BALANCE
<br /> No. Due Date Amount
<br /> $ 5,426,813.80
<br /> 1 1-Apr-18 $331,886.12 $ 223,349.84 S 108,536.28 $ 5,203,463.96
<br /> 2 1-Apr-19 $331,886.12 S 227,816.84 $ 104,069.28 S 4,975,647.12
<br /> 3 1-Apr-20 $331,886.12 S 232,373.18 $ 99,512.94 S 4,743,273.94
<br /> 4 1-Apr-21 $331,886.12 $ 237,020.64 $ 94,865.48 S 4,506,253.30
<br /> 5 1-Apr-22 $331,886.12 $ 241,761.05 S 90,125.07 $ 4,264,492.25
<br /> 6 1-Apr-23 $331,886.12 $ 246,596.27 S 85,289.85 S 4,017,895.98
<br /> 7 1-Apr-24 $331,886.12 $ 251,528.20 $ 80,357.92 S 3,766,367.78
<br /> 8 1-Apr-25 $331,886.12 S 256,558.76 S 75,327.36 S 3,509,809.02
<br /> 9 1-Apr-26 $331,886.12 S 261,689.94 $ 70,196.18 S 3,248,119.08
<br /> 10 1-Apr-27 $331,886.12 $ 266,923.74 S 64,962.38 $ 2,981,195.34
<br /> 11 1-Apr=28 $331,886.12 $ 272,262.21 S 59,623.91 S 2,708,933.13
<br /> 12 1-Apr-29 $331,886.12 $ 277,707.46 $ 54,178.66 S 2,431,225.67
<br /> 13 1-Apr-30 $331,886.12 S 283,261.61 $ 48,624.51 $ 2,147,964.06
<br /> 14 1-Apr-31 $331,886.12 $ 288,926.84 $ 42,959.28 $ 1,859,037.22
<br /> 15 1-Apr-32 $331,886.12 $ 294,705.38 S 37,180.74 S 1,564,331.84
<br /> 16 I-Apr-33 $331,886.12 $ 300,599.48 $ 31,286.64 $ 1,263,732.36
<br /> 17 I-Apr-34 $331,886.12 $ 306,611.47 $ 25,274.65 $ 957,120.89
<br /> 18 I-Apr-35 $331,886.12 $ 312,743.70 $ 19,142.42 $ 6449377.19
<br /> 19 1-Apr-36 $331,886.12 $ 318,998.58 $ 12,887.54 $ 325,378.61
<br /> 20 I-Apr-37 $331,886.18 S 325,378.61 $ 6,507.57 $ -
<br /> TOTALS $6,637,722.46 $5,426,813.80 1 $1,210,908.66 $0.00
<br /> AmartUncompahgmVWUA0515.xlsx SSB 4/4/2017
<br />
|