|
CK#3946
<br /> COLORADO WATER CONSERVATION BOARD $82,648.31
<br /> 7.8.19
<br /> AMORTIZATION SCHEDULE
<br /> Farmers Extension Ditch
<br /> Borrower Company Et Highland Lake
<br /> Lateral
<br /> Loan Contract Number C153409 RE2016-129
<br /> Principal $177,500.00
<br /> Interest Rate 3.00%
<br /> Frequency Annual
<br /> Term(In Years) 40
<br /> First Payment Due August 1, 1985
<br /> Payment Amount $7,678.65
<br /> Loan Payment Annual Principal
<br /> Payment Payment Due Date Amount Principal Interest BALANCE
<br /> $ 177,500.00
<br /> 1 1-Aug-86 $7,678.65 $ 2,354.25 $ 5,324.40 $ 175,145.75
<br /> 2 1-Aug-87 $7,678.65 $ 2,424.87 $ 5,253.78 $ 172,720.88
<br /> 3 1-Aug-88 $7,678.65 $ 2,497.61 $ 5,181.04 $ 170,223.27
<br /> 4 1-Aug-89 $7,678.65 $ 2,572.53 $ 5,106.12 $ 167,650.74
<br /> 5 1-Dec-90 $7,678.65 $ 2,649.70 $ 5,028.95 $ 165,001.04
<br /> 6 7-Jul-92 $7,678.65 $ 2,729.18 $ 4,949.47 $ 162,271.86
<br /> 7 1-Jun-93 $7,678.65 $ 2,811.05 $ 4,867.60 $ 159,460.81
<br /> 8 1-Jun-94 $7,678.65 $ 2,895.37 $ 4,783.28 $ 156,565.44
<br /> 9 1-Jun-95 $7,678.65 $ 2,982.22 $ 4,696.43 $ 153,583.22
<br /> 10 1-Jun-96 $7,678.65 $ 3,071.68 $ 4,606.97 $ 150,511.54
<br /> 11 1-Jun-97 $7,678.65 $ 3,163.82 $ 4,514.83 $ 147,347.72
<br /> 12 1-Jun-98 $7,678.65 $ 3,258.72 $ 4,419.93 $ 144,089.00
<br /> 13 1-Jun-99 $7,678.65 $ 3,356.47 $ 4,322.18 $ 140,732.53
<br /> 14 1-Jul-00 $7,678.65 $ 3,457.15 $ 4,221.50 $ 137,275.38
<br /> 15 1-Jul-01 $7,678.65 $ 3,560.86 $ 4,117.79 $ 133,714.52
<br /> 16 1-Jul-02 $7,678.65 $ 3,667.67 $ 4,010.98 $ 130,046.85
<br /> 17 1-Jul-03 $7,678.65 $ 3,777.69 $ 3,900.96 $ 126,269.16
<br /> 18 1-Jul-04 $7,678.65 $ 3,891.00 $ 3,787.65 $ 122,378.16
<br /> 19 1-Jul-05 $7,678.65 $ 4,007.72 $ 3,670.93 $ 118,370.44
<br /> 20 1-Jul-06 $7,678.65 $ 4,127.94 $ 3,550.71 $ 114,242.50
<br /> 21 1-Jul-07 $7,678.65 $ 4,251.76 $ 3,426.89 $ 109,990.74
<br /> 22 1-Jul-08 $7,678.65 $ 4,379.30 $ 3,299.35 $ 105,611.44
<br /> 23 1-Jul-09 $7,678.65 $ 4,510.67 $ 3,167.98 $ 101,100.77
<br /> 24 1-Jul-10 $7,678.65 $ 4,645.97 $ 3,032.68 $ 96,454.80
<br /> 25 1-Jul-11 $7,678.65 $ 4,785.33 $ 2,893.32 $ 91,669.47
<br /> 26 1-Jul-12 $7,678.65 $ 4,928.88 $ 2,749.77 $ 86,740.59
<br /> 27 1-Jul-13 $7,678.65 $ 5,076.73 $ 2,601.92 $ 81,663.86
<br /> 28 1-Jul-14 $7,678.65 $ 5,229.01 $ 2,449.64 $ 76,434.85
<br /> 29 1-Jul-15 $7,678.65 $ 5,385.86 $ 2,292.79 $ 71,048.99
<br /> 30 1-Jul-16 $7,678.65 $ 5,547.42 $ 2,131.23 $ 65,50157
<br /> 31 1-Jul-17 $7,678.65 $ 5,713.83 $ 1,964.82 $ 59,787.74
<br /> 32 1-Jul-18 $7,678.65 $ 5,885.22 $ 1,793.43 $ 53,902.52
<br /> 33 1-Jul-19 $7,678.65 $ 6,061.76 $ 1,616.89 $ 47,840.76
<br /> 34 1-Jul-20 $7,678.65 $ 6,243.59 $ 1,435.06 $ 41,597.17
<br /> 35 1-Jul-21 $7,678.65 $ 6,430.88 $ 1,247.77 $ 35,166.29
<br /> 36 1-Jul-22 $7,678.65 $ 6,623.78 $ 1,054.87 $ 28,542.51
<br /> 37 1-Jul-23 $7,678.65 $ 6,822.47 $ 856.18 $ 21,720.04
<br /> 38 1-Jul-24 $7,678.65 $ 7,027.12 $ 65t53 $ 14,692.92
<br /> 39 1-Jul-25 $7,678.65 $ 7,237.91 $ 440.74 $ 7,455.01
<br /> 40 1-Jul-26 $7,678.65 $ 7,455.01 $ 223.64 $ 0.00
<br /> TOTALS $307,146.00 $177,500.00 $129,646.00 $0.00
<br /> Amort Farmers C153409.xls LCM[Date]
<br />
|