|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Bergen Ditch and Reservoir Final
<br /> Company
<br /> Loan Contract Number C150344
<br /> Principal $2,111,102.00
<br /> Interest Rate 3.15%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due April 1,2017
<br /> Payment Amount $109,805.70
<br /> Loan Annual Annual Principal
<br /> Payment Payment Principal Interest
<br /> Payment No. BALANCE
<br /> Due Date Amount
<br /> $ 2,111,102.00
<br /> Adjustment 1-Apr-16 $337.46 $ 337.46 $ - $ 2,110,764.54
<br /> 1 1-Apr-17 $109,805.70 $ 43,305.99 $ 66,499.71 $ 2,067,458.55
<br /> 2 1-Apr-18 $109,805.70 $ 44,680.76 $ 65,124.94 $ 2,022,777.79
<br /> 3 1-Apr-19 $109,805.70 $ 46,088.20 $ 63,717.50 $ 1,976,689.59
<br /> 4 1-Apr-20 $109,805.70 $ 47,539.98 $ 62,265.72 $ 1,929,149.61
<br /> 5 1-Apr-21 $109,805.70 $ 49,037.49 $ 60,768.21 $ 1,880,112.12
<br /> 6 1-Apr-22 $109,805.70 $ 50,582.17 $ 59,223.53 $ 1,829,529.95
<br /> 7 1-Apr-23 $109,805.70 $ 52,175.51 $ 57,630.19 $ 1,777,354.44
<br /> 8 1-Apr-24 $109,805.70 $ 53,819.04 $ 55,986.66 $ 1,723,535.40
<br /> 9 1-Apr-25 $109,805.70 $ 55,514.33 $ 54,291.37 $ 1,668,021.07
<br /> 10 1-Apr-26 $109,805.70 $ 57,263.04 $ 52,542.66 $ 1,610,758.03
<br /> 11 1-Apr-27 $109,805.70 $ 59,066.82 $ 50,738.88 $ 1,551,691.21
<br /> 12 1-Apr-28 $109,805.70 $ 60,927.43 $ 48,878.27 $ 1,490,763.78
<br /> 13 1-Apr-29 $109,805.70 $ 62,846.64 $ 46,959.06 $ 1,427,917.14
<br /> 14 1-Apr-30 $109,805.70 $ 64,826.31 $ 44,979.39 $ 1,363,090.83
<br /> 15 1-Apr-31 $109,805.70 $ 66,868.34 $ 42,937.36 $ 1,296,222.49
<br /> 16 1-Apr-32 $109,805.70 $ 68,974.69 $ 40,831.01 $ 1,227,247.80
<br /> 17 1-Apr-33 $109,805.70 $ 71,147.39 $ 38,658.31 $ 1,156,100.41
<br /> 18 1-Apr-34 $109,805.70 $ 73,388.54 $ 36,417.16 $ 1,082,711.87
<br /> 19 1-Apr-35 $109,805.70 $ 75,700.28 $ 34,105.42 $ 1,007,011.59
<br /> 20 1-Apr-36 $109,805.70 $ 78,084.83 $ 31,720.87 $ 928,926.76
<br /> 21 1-Apr-37 $109,805.70 $ 80,544.51 $ 29,261.19 $ 848,382.25
<br /> 22 1-Apr-38 $109,805.70 $ 83,081.66 $ 26,724.04 $ 765,300.59
<br /> 23 1-Apr-39 $109,805.70 $ 85,698.73 $ 24,106.97 $ 679,601.86
<br /> 24 1-Apr-40 $109,805.70 $ 88,398.24 $ 21,407.46 $ 591,203.62
<br /> 25 1-Apr-41 $109,805.70 $ 91,182.79 $ 18,622.91 $ 500,020.83
<br /> 26 1-Apr-42 $109,805.70 $ 94,055.04 $ 15,750.66 $ 405,965.79
<br /> 27 1-Apr-43 $109,805.70 $ 97,017.78 $ 12,787.92 $ 308,948.01
<br /> 28 1-Apr-44 $109,805.70 $ 100,073.84 $ 9,731.86 $ 208,874.17
<br /> 29 1-Apr-45 $109,805.70 $ 103,226.16 $ 6,579.54 $ 105,648.01
<br /> 30 1-Apr-46 $108,975.92 $ 105,648.01 $ 3,327.91 $ -
<br /> TOTALS $3,293,341.22 $2.110,764.54 $1,182,576.68 $0.00
<br /> Amort Bergen C150344 1112.xlsx SSB 3/30/2016
<br />
|