|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Penrose Water District PRELIMINARY
<br /> Loan Contract Number C150237 CT 2015-040
<br /> Principal $9,763,670.00
<br /> Interest Rate 3.25%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due October 1,2016
<br /> Payment Amount $514,366.90
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest
<br /> No. Due Date Amount BALANCE
<br /> $ 9,763,670.00
<br /> 1 1-Oct-16 $514,366.90 $ 197,047.62 $ 317,319.28 $ 9,566,622.38
<br /> 2 1-Oct-17 $514,366.90 $ 203,451.67 $ 310,915.23 $ 9,363,170.71
<br /> 3 1-Oct-18 $514,366.90 $ 210,063.85 $ 304,303.05 $ 9,153,106.86
<br /> 4 1-Oct-19 $514,366.90 $ 216,890.93 $ 297,475.97 $ 8,936,215.93
<br /> 5 1-Oct-20 $514,366.90 $ 223,939.88 $ 290,427.02 $ 8,712,276.05
<br /> 6 1-Oct-21 $514,366.90 $ 231,217.93 $ 283,148.97 $ 8,481,058.12
<br /> 7 1-Oct-22 $514,366.90 $ 238,732.51 $ 275,634.39 $ 8,242,325.61
<br /> 8 1-Oct-23 $514,366.90 $ 246,491.32 $ 267,875.58 $ 7,995,834.29
<br /> 9 1-Oct-24 $514,366.90 $ 254,502.29 $ 259,864.61 $ 7,741,332.00
<br /> 10 1-Oct-25 $514,366.90 $ 262,773.61 $ 251,593.29 $ 7,478,558.39
<br /> 11 1-Oct-26 $514,366.90 $ 271,313.75 $ 243,053.15 $ 7,207,244.64
<br /> 12 1-Oct-27 $514,366.90 $ 280,131.45 $ 234,235.45 $ 6,927,113.19
<br /> 13 1-Oct-28 $514,366.90 $ 289,235.72 $ 225,131.18 $ 6,637,877.47
<br /> 14 1-Oct-29 $514,366.90 $ 298,635.88 $ 215,731.02 $ 6,339,241.59
<br /> 15 1-Oct-30 $514,366.90 $ 308,341.55 $ 206,025.35 $ 6,030,900.04
<br /> 16 1-Oct-31 $514,366.90 $ 318,362.65 $ 196,004.25 $ 5,712,537.39
<br /> 17 1-Oct-32 $514,366.90 $ 328,709.43 $ 185,657.47 $ 5,383,827.96
<br /> 18 1-Oct-33 $514,366.90 $ 339,392.49 $ 174,974.41 $ 5,044,435.47
<br /> 19 1-Oct-34 $514,366.90 $ 350,422.75 $ 163,944.15 $ 4,694,012.72
<br /> 20 1-Oct-35 $514,366.90 $ 361,811.49 $ 152,555.41 $ 4,332,201.23
<br /> 21 1-Oct-36 $514,366.90 $ 373,570.36 $ 140,796.54 $ 3,958,630.87
<br /> 22 1-Oct-37 $514,366.90 $ 385,711.40 $ 128,655.50 $ 3,572,919.47
<br /> 23 1-Oct-38 $514,366.90 $ 398,247.02 $ 116,119.88 $ 3,174,672.45
<br /> 24 1-Oct-39 $514,366.90 $ 411,190.05 $ 103,176.85 $ 2,763,482.40
<br /> 25 1-Oct-40 $514,366.90 $ 424,553.72 $ 89,813.18 $ 2,338,928.68
<br /> 26 1-Oct-41 $514,366.90 $ 438,351.72 $ 76,015.18 $ 1,900,576.96
<br /> 27 1-Oct-42 $514,366.90 $ 452,598.15 $ 61,768.75 $ 1,447,978.81
<br /> 28 1-Oct-43 $514,366.90 $ 467,307.59 $ 47,059.31 $ 980,671.22
<br /> 29 1-Oct-44 $514,366.90 $ 482,495.09 $ 31,871.81 $ 498,176.13
<br /> 30 1-Oct-45 $514,366.85 $ 498,176.13 $ 16,190.72 $ -
<br /> TOTALS $15,431,006.951 $9,763,670.00 I $5,667,336.95 I $0.00
<br /> Amort Penrose C150237 1114.xlsx SSB 11/14/2014
<br />
|