|
COLORADO WATER CONSERVATIONBOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Lower Poudre Augmentation
<br /> Borrower Company FINAL
<br /> Loan Contract Number CT 2016-2005 RE2016-378
<br /> Principal $454,500.00
<br /> Interest Rate 1.85%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due March 1,2017
<br /> Payment Amount $19,877.23
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> BALANCE
<br /> No. Due Date Amount
<br /> $ 454,500.00
<br /> 1 1-Mar-17 $19,877.23 $ 11,468.98 $ 8,408.25 $ 443,031.02
<br /> 2 1-Mar-18 $19,877.23 $ 11,681.16 $ 8,196.07 $ 431,349.86
<br /> 3 1-Mar-19 $19,877.23 $ 11,897.26 $ 7,979.97 $ 419,452.60
<br /> 4 1-Mar-20 $19,877.23 $ 12,117.36 $ 7,759.87 $ 407,335.24
<br /> 5 1-Mar-21 $19,877.23 $ 12,341.53 $ 7,535.70 $ 394,993.71
<br /> 6 1-Mar-22 $19,877.23 $ 12,569.85 $ 7,307.38 $ 382,423.86
<br /> 7 1-Mar-23 $19,877.23 $ 12,802.39 $ 7,074.84 $ 369,621.47
<br /> 8 1-Mar-24 $19,877.23 $ 13,039.23 $ 6,838.00 $ 356,582.24
<br /> 9 1-Mar-25 $19,877.23 $ 13,280.46 $ 6,596.77 $ 343,301.78
<br /> 10 1-Mar-26 $19,877.23 $ 13,526.15 $ 6,351.08 $ 329,775.63
<br /> 11 1-Mar-27 $19,877.23 $ 13,776.38 $ 6,100.85 $ 315,999.25
<br /> 12 1-Mar-28 $19,877.23 $ 14,031.24 $ 5,845.99 $ 301,968.01
<br /> 13 1-Mar-29 $19,877.23 $ 14,290.82 $ 5,586.41 $ 287,677.19
<br /> 14 1-Mar-30 $19,877.23 $ 14,555.20 $ 5,322.03 $ 273,121.99
<br /> 15 1-Mar-31 $19,877.23 $ 14,824.47 $ 5,052.76 $ 258,297.52
<br /> 16 1-Mar-32 $19,877.23 $ 15,098.73 $ 4,778.50 $ 243,198.79
<br /> 17 1-Mar-33 $19,877.23 $ 15,378.05 $ 4,499.18 $ 227,820.74
<br /> 18 1-Mar-34 $19,877.23 $ 15,662.55 $ 4,214.68 $ 212,158.19
<br /> 19 1-Mar-35 $19,877.23 $ 15,952.30 $ 3,924.93 $ 196,205.89
<br /> 20 1-Mar-36 $19,877.23 $ 16,247.42 $ 3,629.81 $ 179,958.47
<br /> 21 1-Mar-37 $19,877.23 $ 16,548.00 $ 3,329.23 $ 163,410.47
<br /> 22 1-Mar-38 $19,877.23 $ 16,854.14 $ 3,023.09 $ 146,556.33
<br /> 23 1-Mar-39 $19,877.23 $ 17,165.94 $ 2,711.29 $ 129,390.39
<br /> 24 1-Mar40 $19,877.23 $ 17,483.51 $ 2,393.72 $ 111,906.88
<br /> 25 1-Mar-41 $19,877.23 $ 17,806.95 $ 2,070.28 $ 94,099.93
<br /> 26 1-Mar-42 $19,877.23 $ 18,136.38 $ 1,740.85 $ 75,963.55
<br /> 27 1-Mar-43 $19,877.23 $ 18,471.90 $ 1,405.33 $ 57,491.65
<br /> 28 1-Mar-44 $19,877.23 $ 18,813.63 $ 1,063.60 $ 38,678.02
<br /> 29 1-Mar-45 $19,877.23 $ 19,161.69 $ 715.54 $ 19,516.33
<br /> 30 1-Mar-46 $19,877.38 $ 19,516.33 $ 361.05 $ -
<br /> TOTALS $596,317.05 $454,500.00 $141,817.05 $0.00
<br /> AmortLowerPoudreCT201620051015.xlsx SSB 2/13/2017
<br />
|