Laserfiche WebLink
COLORADO WATER CONSERVATION BOARD <br /> LOAN REPAYMENT SCHEDULE <br /> Borrower Penrose Water District FINAL <br /> Loan Contract Number C150237 CT2015-040 <br /> Principal $8,615,683.54 <br /> Interest Rate 3.25% <br /> Frequency Annual <br /> Term(In Years) 30 <br /> First Payment Due October 1,2016 <br /> Payment Amount $453,889.00 <br /> Loan Annual Annual <br /> Principal <br /> Payment Payment Payment Principal Interest BALANCE <br /> No. Due Date Amount <br /> $ 8,615,683.54 <br /> 1 1-Oct-16 $453,889.00 $ 173,879.28 $ 280,009.72 $ 8,441,804.26 <br /> 2 1-Oct-17 $453,889.00 $ 179,530.36 $ 274,358.64 $ 8,262,273.90 <br /> 3 1-Oct-18 $453,889.00 $ 185,365.10 $ 268,523.90 $ 8,076,908.80 <br /> 4 1-Oct-19 $453,889.00 $ 191,389.46 $ 262,499.54 $ 7,885,519.34 <br /> 5 1-Oct-20 $453,889.00 $ 197,609.62 $ 256,279.38 $ 7,687,909.72 <br /> 6 1-Oct-21 $453,889.00 $ 204,031.93 $ 249,857.07 $ 7,483,877.79 <br /> 7 1-Oct-22 $453,889.00 $ 210,662.97 $ 243,226.03 $ 7,273,214.82 <br /> 8 1-Oct-23 $453,889.00 $ 217,509.52 $ 236,379.48 $ 7,055,705.30 <br /> 9 1-Oct-24 $453,889.00 $ 224,578.58 $ 229,310.42 $ 6,831,126.72 <br /> 10 1-Oct-25 $453,889.00 $ 231,877.38 $ 222,011.62 $ 6,599,249.34 <br /> 11 1-Oct-26 $453,889.00 $ 239,413.40 $ 214,475.60 $ 6,359,835.94 <br /> 12 1-Oct-27 $453,889.00 $ 247,194.33 $ 206,694.67 $ 6,112,641.61 <br /> 13 1-Oct-28 $453,889.00 $ 255,228.15 $ 198,660.85 $ 5,857,413.46 <br /> 14 1-Oct-29 $453,889.00 $ 263,523.06 $ 190,365.94 $ 5,593,890.40 <br /> 15 1-Oct-30 $453,889.00 $ 272,087.56 $ 181,801.44 $ 5,321,802.84 <br /> 16 1-Oct-31 $453,889.00 $ 280,930.41 $ 172,958.59 $ 5,040,872.43 <br /> 17 1-Oct-32 $453,889.00 $ 290,060.65 $ 163,828.35 $ 4,750,811.78 <br /> 18 1-Oct-33 $453,889.00 $ 299,487.62 $ 154,401.38 $ 4,451,324.16 <br /> 19 1-Oct-34 $453,889.00 $ 309,220.96 $ 144,668.04 $ 4,142,103.20 <br /> 20 1-Oct-35 $453,889.00 $ 319,270.65 $ 134,618.35 $ 3,822,832.55 <br /> 21 1-Oct-36 $453,889.00 $ 329,646.94 $ 124,242.06 $ 3,493,185.61 <br /> 22 1-Oct-37 $453,889.00 $ 340,360.47 $ 113,528.53 $ 3,152,825.14 <br /> 23 1-Oct-38 $453,889.00 $ 351,422.18 $ 102,466.82 $ 2,801,402.96 <br /> 24 1-Oct-39 $453,889.00 $ 362,843.40 $ 91,045.60 $ 2,438,559.56 <br /> 25 1-Oct-40 $453,889.00 $ 374,635.81 $ 79,253.19 $ 2,063,923.75 <br /> 26 1-Oct-41 $453,889.00 $ 386,811.48 $ 67,077.52 $ 1,677,112.27 <br /> 27 1-Oct-42 $453,889.00 $ 399,382.85 $ 54,506.15 $ 1,277,729.42 <br /> 28 1-Oct-43 $453,889.00 $ 412,362.79 $ 41,526.21 $ 865,366.63 <br /> 29 1-Oct-44 $453,889.00 $ 425,764.58 $ 28,124.42 $ 439,602.05 <br /> 30 1-Oct-45 $453,889.12 $ 439,602.05 $ 14,287.07 $ - <br /> TOTALS $13,616,670.121 $8,615,683.54 I $5,000,986.58 I $0.00 <br /> Amort Penrose C150237 1114.xlsx SSB 9/8/2015 <br />