|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Lower Poudre Augmentation FINAL
<br /> Company
<br /> Loan Contract Number CT 2015-171
<br /> Principal $1,163,015.00
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due November 1,2016
<br /> Payment Amount $50,160.55
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 1,163,015.00
<br /> 1 1-Nov-16 $50,160.55 $ 29,807.79 $ 20,352.76 $ 1,133,207.21
<br /> 2 1-Nov-17 $50,160.55 $ 30,329.42 $ 19,831.13 $ 1,102,877.79
<br /> 3 1-Nov-18 $50,160.55 $ 30,860.19 $ 19,300.36 $ 1,072,017.60
<br /> 4 1-Nov-19 $50,160.55 $ 31,400.24 $ 18,760.31 $ 1,040,617.36
<br /> 5 1-Nov-20 $50,160.55 $ 31,949.75 $ 18,210.80 $ 1,008,667.61
<br /> 6 1-Nov-21 $50,160.55 $ 32,508.87 $ 17,651.68 $ 976,158.74
<br /> 7 1-Nov-22 $50,160.55 $ 33,077.77 $ 17,082.78 $ 943,080.97
<br /> 8 1-Nov-23 $50,160.55 $ 33,656.63 $ 16,503.92 $ 909,424.34
<br /> 9 1-Nov-24 $50,160.55 $ 34,245.62 $ 15,914.93 $ 875,178.72
<br /> 10 1-Nov-25 $50,160.55 $ 34,844.92 $ 15,315.63 $ 840,333.80
<br /> 11 1-Nov-26 $50,160.55 $ 35,454.71 $ 14,705.84 $ 804,879.09
<br /> 12 1-Nov-27 $50,160.55 $ 36,075.17 $ 14,085.38 $ 768,803.92
<br /> 13 1-Nov-28 $50,160.55 $ 36,706.48 $ 13,454.07 $ 732,097.44
<br /> 14 1-Nov-29 $50,160.55 $ 37,348.84 $ 12,811.71 $ 694,748.60
<br /> 15 1-Nov-30 $50,160.55 $ 38,002.45 $ 12,158.10 $ 656,746.15
<br /> 16 1-Nov-31 $50,160.55 $ 38,667.49 $ 11,493.06 $ 618,078.66
<br /> 17 1-Nov-32 $50,160.55 $ 39,344.17 $ 10,816.38 $ 578,734.49
<br /> 18 1-Nov-33 $50,160.55 $ 40,032.70 $ 10,127.85 $ 538,701.79
<br /> 19 1-Nov-34 $50,160.55 $ 40,733.27 $ 9,427.28 $ 497,968.52
<br /> 20 1-Nov-35 $50,160.55 $ 41,446.10 $ 8,714.45 $ 456,522.42
<br /> 21 1-Nov-36 $50,160.55 $ 42,171.41 $ 7,989.14 $ 414,351.01
<br /> 22 1-Nov-37 $50,160.55 $ 42,909.41 $ 7,251.14 $ 371,441.60
<br /> 23 1-Nov-38 $50,160.55 $ 43,660.32 $ 6,500.23 $ 327,781.28
<br /> 24 1-Nov-39 $50,160.55 $ 44,424.38 $ 5,736.17 $ 283,356.90
<br /> 25 1-Nov-40 $50,160.55 $ 45,201.80 $ 4,958.75 $ 238,155.10
<br /> 26 1-Nov-41 $50,160.55 $ 45,992.84 $ 4,167.71 $ 192,162.26
<br /> 27 1-Nov-42 $50,160.55 $ 46,797.71 $ 3,362.84 $ 145,364.55
<br /> 28 1-Nov-43 $50,160.55 $ 47,616.67 $ 2,543.88 $ 97,747.88
<br /> 29 1-Nov-44 $50,160.55 $ 48,449.96 $ 1,710.59 $ 49,297.92
<br /> 30 1-Nov-45 $50,160.63 $ 49,297.92 $ 862.71 $ -
<br /> TOTALS ( $1,504,816.58 I $1,163,015.00 I $341,801.58 I $0.00 I
<br /> AmortLowerPoudreAug05I5.xlsx SSB 10/28/2015
<br />
|