|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower The Greeley and Loveland Final
<br /> Irrigation Company
<br /> Loan Contract Number CT 2015-022 (C150362) RE2016-554
<br /> Principal $3,745,080.00
<br /> Interest Rate 2.15%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due July 1,2017
<br /> Payment Amount $170,686.09
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 3,745,080.00
<br /> l 1-Jul-17 $170,686.09 $ 90,166.87 $ 80,519.22 $ 3,654,913.13
<br /> 2 1-Jul-18 $170,686.09 $ 92,105.46 $ 78,580.63 $ 3,562,807.67
<br /> 3 1-Jul-19 $170,686.09 $ 94,085.73 $ 76,600.36 $ 3,468,721.94
<br /> 4 1-Jul-20 $170,686.09 $ 96,108.57 $ 74,577.52 $ 3,372,613.37
<br /> 5 1-Jul-21 $170,686.09 $ 98,174.90 $ 72,511.19 $ 3,274,438.47
<br /> 6 1-Jul-22 $170,686.09 $ 100,285.66 $ 70,400.43 $ 3,174,152.81
<br /> 7 1-Jul-23 $170,686.09 $ 102,441.80 $ 68,244.29 $ 3,071,711.01
<br /> 8 1-Jul-24 $170,686.09 $ 104,644.30 $ 66,041.79 $ 2,967,066.71
<br /> 9 1-Jul-25 $170,686.09 $ 106,894.16 $ 63,791.93 $ 2,860,172.55
<br /> 10 1-Jul-26 $170,686.09 $ 109,192.38 $ 61,493.71 $ 2,750,980.17
<br /> 11 1-Jul-27 $170,686.09 $ 111,540.02 $ 59,146.07 $ 2,639,440.15
<br /> 12 1-Jul-28 $170,686.09 $ 113,938.13 $ 56,747.96 $ 2,525,502.02
<br /> 13 1-Jul-29 $170,686.09 $ 116,387.80 $ 54,298.29 $ 2,409,114.22
<br /> 14 1-Jul-30 $170,686.09 $ 118,890.13 $ 51,795.96 $ 2,290,224.09
<br /> 15 1-Jul-31 $170,686.09 $ 121,446.27 $ 49,239.82 $ 2,168,777.82
<br /> 16 1-Jul-32 $170,686.09 $ 124,057.37 $ 46,628.72 $ 2,044,720.45
<br /> 17 1-Jul-33 $170,686.09 $ 126,724.60 $ 43,961.49 $ 1,917,995.85
<br /> 18 1-Jul-34 $170,686.09 $ 129,449.18 $ 41,236.91 $ 1,788,546.67
<br /> 19 1-Jul-35 $170,686.09 $ 132,232.34 $ 38,453.75 $ 1,656,314.33
<br /> 20 1-Jul-36 $170,686.09 $ 135,075.33 $ 35,610.76 $ 1,521,239.00
<br /> 21 1-Jul-37 $170,686.09 $ 137,979.45 $ 32,706.64 $ 1,383,259.55
<br /> 22 1-Jul-38 $170,686.09 $ 140,946.01 $ 29,740.08 $ 1,242,313.54
<br /> 23 1-Jul-39 $170,686.09 $ 143,976.35 $ 26,709.74 $ 1,098,337.19
<br /> 24 1-Jul-40 $170,686.09 $ 147,071.84 $ 23,614.25 $ 951,265.35
<br /> 25 1-Jul-41 $170,686.09 $ 150,233.88 $ 20,452.21 $ 801,031.47
<br /> 26 1-Jul-42 $170,686.09 $ 153,463.91 $ 17,222.18 $ 647,567.56
<br /> 27 1-Jul-43 $170,686.09 $ 156,763.39 $ 13,922.70 $ 490,804.17
<br /> 28 1-Jul-44 $170,686.09 $ 160,133.80 $ 10,552.29 $ 330,670.37
<br /> 29 1-Jul-45 $170,686.09 $ 163,576.68 $ 7,109.41 $ 167,093.69
<br /> 30 1-Jul-46 $170,686.20 $ 167,093.69 $ 3,592.51 $ -
<br /> TOTALS $5,120,582.81 $3,745,080.00 $1,375,502.81 $0.00
<br /> Amort Greeley C150362 1013.xlsx SSB 7/6/2016
<br />
|