|
COLORADO WATER CONSERVAHON BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Town of Ridgway FINAL
<br /> Loan Contract Number C150340
<br /> Principal $606,000.00
<br /> Interest Rate 3.00%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due January 1,2017
<br /> Payment Amount $30,917.67
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 606,000.00
<br /> 1 1-Jan-17 $30,917.67 $ 12,737.67 $ 18,180.00 $ 593,262.33
<br /> 2 1-Jan-18 $30,917.67 $ 13,119.80 $ 17,797.87 $ 580,142.53
<br /> 3 1-Jan-19 $30,917.67 $ 13,513.39 $ 17,404.28 $ 566,629.14
<br /> 4 1-Jan-20 $30,917.67 $ 13,918.80 $ 16,998.87 $ 552,710.34
<br /> 5 1-Jan-21 $30,917.67 $ 14,336.36 $ 16,581.31 $ 538,373.98
<br /> 6 1-Jan-22 $30,917.67 $ 14,766.45 $ 16,151.22 $ 523,607.53
<br /> 7 1-Jan-23 $30,917.67 $ 15,209.44 $ 15,708.23 $ 508,398.09
<br /> 8 1-Jan-24 $30,917.67 $ 15,665.73 $ 15,251.94 $ 492,732.36
<br /> 9 1-Jan-25 $30,917.67 $ 16,135.70 $ 14,781.97 $ 476,596.66
<br /> 10 1-Jan-26 $30,917.67 $ 16,619.77 $ 14,297.90 $ 459,976.89
<br /> 11 1-Jan-27 $30,917.67 $ 17,118.36 $ 13,799.31 $ 442,858.53
<br /> 12 1-Jan-28 $30,917.67 $ 17,631.91 $ 13,285.76 $ 425,226.62
<br /> 13 1-Jan-29 $30,917.67 $ 18,160.87 $ 12,756.80 $ 407,065.75
<br /> 14 1-Jan-30 $30,917.67 $ 18,705.70 $ 12,211.97 $ 388,360.05
<br /> 15 1-Jan-31 $30,917.67 $ 19,266.87 $ 11,650.80 $ 369,093.18
<br /> 16 1-Jan-32 $30,917.67 $ 19,844.87 $ 11,072.80 $ 349,248.31
<br /> 17 1-Jan-33 $30,917.67 $ 20,440.22 $ 10,477.45 $ 328,808.09
<br /> 18 1-Jan-34 $30,917.67 $ 21,053.43 $ 9,864.24 $ 307,754.66
<br /> 19 1-Jan-35 $30,917.67 $ 21,685.03 $ 9,232.64 $ 286,069.63
<br /> 20 1-Jan-36 $30,917.67 $ 22,335.58 $ 8,582.09 $ 263,734.05
<br /> 21 1-Jan-37 $30,917.67 $ 23,005.65 $ 7,912.02 $ 240,728.40
<br /> 22 1-Jan-38 $30,917.67 $ 23,695.82 $ 7,221.85 $ 217,032.58
<br /> 23 1-Jan-39 $30,917.67 $ 24,406.69 $ 6,510.98 $ 192,625.89
<br /> 24 1-Jan-40 $30,917.67 $ 25,138.89 $ 5,778.78 $ 167,487.00
<br /> 25 1-Jan-41 $30,917.67 $ 25,893.06 $ 5,024.61 $ 141,593.94
<br /> 26 1-Jan-42 $30,917.67 $ 26,669.85 $ 4,247.82 $ 114,924.09
<br /> 27 1-Jan-43 $30,917.67 $ 27,469.95 $ 3,447.72 $ 87,454.14
<br /> 28 1-Jan-44 $30,917.67 $ 28,294.05 $ 2,623.62 $ 59,160.09
<br /> 29 1-Jan-45 $30,917.67 $ 29,142.87 $ 1,774.80 $ 30,017.22
<br /> 30 1-Jan-46 $30,917.74 $ 30,017.22 $ 900.52 $ -
<br /> TOTALS $927,530.17 $606,000.00 $321,530.17 $0.00
<br /> Amort Ridgway C150340 1112.xlsx SSB 2/3/2016
<br />
|