|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Crystal Lakes Water and Sewer
<br /> Borrower Final
<br /> Association
<br /> Loan Contract Number C150325 RE2016-352
<br /> Principal $2,016,459.59
<br /> Interest Rate 4.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due January 1,2017
<br /> Payment Amount $116,612.06
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 2,016,459.59
<br /> 1 1-Jan-17 $116,612.06 $ 35,953.68 $ 80,658.38 $ 1,980,505.91
<br /> 2 1-Jan-18 $116,612.06 $ 37,391.82 $ 79,220.24 $ 1,943,114.09
<br /> 3 1-Jan-19 $116,612.06 $ 38,887.50 $ 77,724.56 $ 1,904,226.59
<br /> 4 1-Jan-20 $116,612.06 $ 40,443.00 $ 76,169.06 $ 1,863,783.59
<br /> 5 1-Jan-21 $116,612.06 $ 42,060.72 $ 74,551.34 $ 1,821,722.87
<br /> 6 1-Jan-22 $116,612.06 $ 43,743.15 $ 72,868.91 $ 1,777,979.72
<br /> 7 1-Jan-23 $116,612.06 $ 45,492.87 $ 71,119.19 $ 1,732,486.85
<br /> • 8 1-Jan-24 $116,612.06 $ 47,312.59 $ 69,299.47 $ 1,685,174.26
<br /> 9 1-Jan-25 $116,612.06 $ 49,205.09 $ 67,406.97 $ 1,635,969.17
<br /> 10 1-Jan-26 $116,612.06 $ 51,173.29 $ 65,438.77 $ 1,584,795.88
<br /> 11 1-Jan-27 $116,612.06 $ 53,220.22 $ 63,391.84 $ 1,531,575.66
<br /> 12 1-Jan-28 $116,612.06 $ 55,349.03 $ 61,263.03 $ 1,476,226.63
<br /> 13 1-Jan-29 $116,612.06 $ 57,562.99 $ 59,049.07 $ 1,418,663.64
<br /> 14 1-Jan-30 $116,612.06 $ 59,865.51 $ 56,746.55 $ 1,358,798.13
<br /> 15 1-Jan-31 $116,612.06 $ 62,260.13 $ 54,351.93 $ 1,296,538.00
<br /> 16 1-Jan-32 $116,612.06 $ 64,750.54 $ 51,861.52 $ 1,231,787.46
<br /> 17 1-Jan-33 $116,612.06 $ 67,340.56 $ 49,271.50 $ 1,164,446.90
<br /> 18 1-Jan-34 $116,612.06 $ 70,034.18 $ 46,577.88 $ 1,094,412.72
<br /> 19 1-Jan-35 $116,612.06 $ 72,835.55 $ 43,776.51 $ 1,021,577.17
<br /> 20 1-Jan-36 $116,612.06 $ 75,748.97 $ 40,863.09 $ 945,828.20
<br /> 21 1-Jan-37 $116,612.06 $ 78,778.93 $ 37,833.13 $ 867,049.27
<br /> 22 1-Jan-38 $116,612.06 $ 81,930.09 $ 34,681.97 $ 785,119.18
<br /> 23 1-Jan-39 $116,612.06 $ 85,207.29 $ 31,404.77 $ 699,911.89
<br /> 24 1-Jan-40 $116,612.06 $ 88,615.58 $ 27,996.48 $ 611,296.31
<br /> 25 1-Jan-41 $116,612.06 $ 92,160.21 $ 24,451.85 $ 519,136.10
<br /> 26 1-Jan-42 $116,612.06 $ 95,846.62 $ 20,765.44 $ 423,289.48
<br /> 27 1-Jan-43 $116,612.06 $ 99,680.48 $ 16,931.58 $ 323,609.00
<br /> 28 1-Jan-44 $116,612.06 $ 103,667.70 $ 12,944.36 $ 219,941.30
<br /> 29 1-Jan-45 $116,612.06 $ 107,814.41 $ 8,797.65 $ 112,126.89
<br /> 30 1-Jan-46 $116,611.97 $ 112,126.89 $ 4,485.08 $ -
<br /> TOTALS $3,498,361.71 $2,016,459.59 $1,481,902.12 $0.00
<br /> Amort Crystal Lakes C150325 1111.xisx SSB 12/15/2015
<br />
|