|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Northern Colorado Water FINAL
<br /> Conservancy District
<br /> Loan Contract Number CT 2015-140 (C150396)
<br /> Principal $5,135,183.00
<br /> Interest Rate 2.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due October 1,2017
<br /> Payment Amount $229,285.52
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 5,135,183.00
<br /> 1 1-Oct-17 $229,285.52 $ 126,581.86 $ 102,703.66 $ 5,008,601.14
<br /> 2 1-Oct-18 $229,285.52 $ 129,113.50 $ 100,172.02 $ 4,879,487.64
<br /> 3 1-Oct-19 $229,285.52 $ 131,695.77 $ 97,589.75 $ 4,747,791.87
<br /> 4 1-Oct-20 $229,285.52 $ 134,329.68 $ 94,955.84 $ 4,613,462.19
<br /> 5 1-Oct-21 $229,285.52 $ 137,016.28 $ 92,269.24 $ 4,476,445.91
<br /> 6 1-Oct-22 $229,285.52 $ 139,756.60 $ 89,528.92 $ 4,336,689.31
<br /> 7 1-Oct-23 $229,285.52 $ 142,551.73 $ 86,733.79 $ 4,194,137.58
<br /> 8 1-Oct-24 $229,285.52 $ 145,402.77 $ 83,882.75 $ 4,048,734.81
<br /> 9 1-Oct-25 $229,285.52 $ 148,310.82 $ 80,974.70 $ 3,900,423.99
<br /> 10 1-Oct-26 $229,285.52 $ 151,277.04 $ 78,008.48 $ 3,749,146.95
<br /> 11 1-Oct-27 $229,285.52 $ 154,302.58 $ 74,982.94 $ 3,594,844.37
<br /> 12 1-Oct-28 $229,285.52 $ 157,388.63 $ 71,896.89 $ 3,437,455.74
<br /> 13 1-Oct-29 $229,285.52 $ 160,536.41 $ 68,749.11 $ 3,276,919.33
<br /> 14 1-Oct-30 $229,285.52 $ 163,747.13 $ 65,538.39 $ 3,113,172.20
<br /> 15 1-Oct-31 $229,285.52 $ 167,022.08 $ 62,263.44 $ 2,946,150.12
<br /> 16 1-Oct-32 $229,285.52 $ 170,362.52 $ 58,923.00 $ 2,775,787.60
<br /> 17 1-Oct-33 $229,285.52 $ 173,769.77 $ 55,515.75 $ 2,602,017.83
<br /> 18 1-Oct-34 $229,285.52 $ 177,245.16 $ 52,040.36 $ 2,424,772.67
<br /> 19 1-Oct-35 $229,285.52 $ 180,790.07 $ 48,495.45 $ 2,243,982.60
<br /> 20 1-Oct-36 $229,285.52 $ 184,405.87 $ 44,879.65 $ 2,059,576.73
<br /> 21 1-Oct-37 $229,285.52 $ 188,093.99 $ 41,191.53 $ 1,871,482.74
<br /> 22 1-Oct-38 $229,285.52 $ 191,855.87 $ 37,429.65 $ 1,679,626.87
<br /> 23 1-Oct-39 $229,285.52 $ 195,692.98 $ 33,592.54 $ 1,483,933.89
<br /> 24 1-Oct-40 $229,285.52 $ 199,606.84 $ 29,678.68 $ 1,284,327.05
<br /> 25 1-Oct-41 $229,285.52 $ 203,598.98 $ 25,686.54 $ 1,080,728.07
<br /> 26 1-Oct-42 $229,285.52 $ 207,670.96 $ 21,614.56 $ 873,057.11
<br /> 27 1-Oct-43 $229,285.52 $ 211,824.38 $ 17,461.14 $ 661,232.73
<br /> 28 1-Oct-44 $229,285.52 $ 216,060.87 $ 13,224.65 $ 445,171.86
<br /> 29 1-Oct-45 $229,285.52 $ 220,382.08 $ 8,903.44 $ 224,789.78
<br /> 30 1-Oct-46 $229,285.58 $ 224,789.78 $ 4,495.80 $ -
<br /> TOTALS $6,878,565.66 $5,135,183.00 $1,743,382.66 $0.00
<br /> Northern C150396 0514.xlsx SSB 9/28/2016
<br />
|