|
COLORADO NATER CONSERVATIONBOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Julesburg Irrigation District Final
<br /> Loan Contract Number CT2017-904
<br /> Principal $203,616.00
<br /> Interest Rate 1.70%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due March 1,2018
<br /> Payment Amount $8,720.72
<br /> Loan Annual Annual Principal
<br /> Payment Payment Dire Payment Principal Interest BALANCE
<br /> No. Date Amount
<br /> $ 203,616.00
<br /> 1 1-Mar-18 $8,720.72 $ 5,259.25 $ 3,461.47 $ 198,356.75
<br /> 2 1-Mar-19 $8,720.72 $ 5,348.66 $ 3,372.06 $ 193,008.09
<br /> 3 1-Mar-20 $8,720.72 $ 5,439.58 $ . 3,281.14 $ 187,568.51
<br /> 4 1-Mar-21 $8,720.72 $ 5,532.06 $ 3,188.66 $ 182,036.45
<br /> 5 1-Mar-22 $8,720.72 $ 5,626.10 $ 3,094.62 $ 176,410.35
<br /> 6 1-Mar-23 $8,720.72 $ 5,721.74 $ 2,998.98 $ 170,688.61
<br /> 7 1-Mar-24 $8,720.72 $ 5,819.01 $ 2,901.71 $ 164,869.60
<br /> 8 1-Mar-25 $8,720.72 $ 5,917.94 $ 2,802.78 $ 158,951.66
<br /> 9 1-Mar-26 $8,720.72 $ 6,018.54 $ 2,702.18 $ 152,933.12
<br /> 10 1-Mar-27 $8,720.72 $ 6,120.86 $ 2,599.86 $ 146,812.26
<br /> 11 1-Mar-28 $8,720.72 $ 6,224.91 $ 2,495.81 $ 140,587.35
<br /> 12 1-Mar-29 $8,720.72 $ 6,330.74 $ 2,389.98 $ 134,256.61
<br /> 13 1-Mar-30 $8,720.72 $ 6,438.36 $ 2,282.36 $ 127,818.25
<br /> 14 1-Mar-31 $8,720.72 $ 6,547.81 $ 2,172.91 $ 121,270.44
<br /> 15 1-Mar-32 $8,720.72 $ 6,659.12 $ 2,061.60 $ 114,611.32
<br /> 16 1-Mar-33 $8,720.72 $ 6,772.33 $ 1,948.39 $ 107,838.99
<br /> 17 1-Mar-34 $8,720.72 $ 6,887.46 $ 1,833.26 $ 100,951.53
<br /> 18 1-Mar-35 $8,720.72 $ 7,004.54 $ 1,716.18 $ 93,946.99
<br /> 19 1-Mar-36 $8,720.72 $ 7,123.62 $ 1,597.10 $ 86,823.37
<br /> 20 1-Mar-37 $8,720.72 $ 7,244.72 $ 1,476.00 $ 79,578.65
<br /> 21 1-Mar-38 $8,720.72 $ 7,367.88 $ 1,352.84 $ 72,210.77
<br /> 22 1-Mar-39 $8,720.72 $ 7,493.14 $ 1,227.58 $ 64,717.63
<br /> 23 1-Mar-40 $8,720.72 $ 7,620.52 $ 1,100.20 $ 57,097.11
<br /> 24 1-Mar-41 $8,720.72 $ 7,750.07 $ 970.65 $ 49,347.04
<br /> 25 1-Mar-42 $8,720.72 $ 7,881.82 $ 838.90 $ 41,465.22
<br /> 26 1-Mar-43 $8,720.72 $ 8,015.81 $ 704.91 $ 33,449.41
<br /> 27 1-Mar-44 $8,720.72 $ 8,152.08 $ 568.64 $ 25,297.33
<br /> 28 1-Mar-45 $8,720.72 $ 8,290.67 $ 430.05 $ 17,006.66
<br /> 29 1-Mar-46 $8,720.72 $ 8,431.61 $ 289.11 $ 8,575.05
<br /> 30 1-Mar-47 $8,720.83 $ 8,575.05 $ 145.78 $ -
<br /> TOTALS $261,621.71 $203,616.00 $58,005.71 $0.00
<br /> SSB 12/17/01
<br /> AmortJulesburgCT20179040516.xlsx 2/27/2017
<br />
|