|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Pisgah Reservoir and Ditch FINAL
<br /> Company
<br /> Loan Contract Number CT2015-027(C150341)
<br /> Principal $1,172,261.00 $990,176.11
<br /> Interest Rate 1.75% 1.75%
<br /> Frequency Annual Annual
<br /> Term(In Years) 30 30
<br /> First Payment Due October 1,2017
<br /> Payment Amount $50,559.33 $42,706.05
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 990,176.11
<br /> 1 1-Oct-17 $42,706.05 $ 25,377.97 $ 17,328.08 $ 964,798.14
<br /> 2 1-Oct-18 $42,706.05 $ 25,822.08 $ 16,883.97 $ 938,976.06
<br /> 3 1-Oct-19 $42,706.05 $ 26,273.97 $ 16,432.08 $ 912,702.09
<br /> 4 1-Oct-20 $42,706.05 $ 26,733.76 $ 15,972.29 $ 885,968.33
<br /> 5 1-Oct-21 $42,706.05 $ 27,201.60 $ 15,504.45 $ 858,766.73
<br /> 6 1-Oct-22 $42,706.05 $ 27,677.63 $ 15,028.42 $ 831,089.10
<br /> 7 1-Oct-23 $42,706.05 $ 28,161.99 $ 14,544.06 $ 802,927.11
<br /> 8 1-Oct-24 $42,706.05 $ 28,654.83 $ 14,051.22 $ 774,272.28
<br /> 9 1-Oct-25 $42,706.05 $ 29,156.29 $ 13,549.76 $ 745,115.99
<br /> 10 1-Oct-26 $42,706.05 $ 29,666.52 $ 13,039.53 $ 715,449.47
<br /> 11 1-Oct-27 $42,706.05 $ 30,185.68 $ 12,520.37 $ 685,263.79
<br /> 12 1-Oct-28 $42,706.05 $ 30,713.93 $ 11,992.12 $ 654,549.86
<br /> 13 1-Oct-29 $42,706.05 $ 31,251.43 $ 11,454.62 $ 623,298.43
<br /> 14 1-Oct-30 $42,706.05 $ 31,798.33 $ 10,907.72 $ 591,500.10
<br /> 15 1-Oct-31 $42,706.05 $ 32,354.80 $ 10,351.25 $ 559,145.30
<br /> 16 1-Oct-32 $42,706.05 $ 32,921.01 $ 9,785.04 $ 526,224.29
<br /> 17 1-Oct-33 $42,706.05 $ 33,497.12 $ 9,208.93 $ 492,727.17
<br /> 18 I-Oct-34 $42,706.05 $ 34,083.32 $ 8,622.73 $ 458,643.85
<br /> 19 1-Oct-35 $42,706.05 $ 34,679.78 $ 8,026.27 $ 423,964.07
<br /> 20 1-Oct-36 $42,706.05 $ 35,286.68 $ 7,419.37 $ 388,677.39
<br /> 21 1-Oct-37 $42,706.05 $ 35,904.20 $ 6,801.85 $ 352,773.19
<br /> 22 1-Oct-38 $42,706.05 $ 36,532.52 $ 6,173.53 $ 316,240.67
<br /> 23 1-Oct-39 $42,706.05 $ 37,171.84 $ 5,534.21 $ 279,068.83
<br /> 24 1-Oct-40 $42,706.05 $ 37,822.35 $ 4,883.70 $ 241,246.48
<br /> 25 1-Oct-41 $42,706.05 $ 38,484.24 $ 4,221.81 $ 202,762.24
<br /> 26 1-Oct-42 $42,706.05 $ 39,157.71 $ 3,548.34 $ 163,604.53
<br /> 27 1-Oct-43 $42,706.05 $ 39,842.97 $ 2,863.08 $ 123,761.56
<br /> 28 1-Oct-44 $42,706.05 $ 40,540.22 $ 2,165.83 $ 83,221.34
<br /> 29 1-Oct-45 $42,706.05 $ 41,249.68 $ 1,456.37 $ 41,971.66
<br /> 30 1-Oct-46 $42,706.16 $ 41,971.66 $ 734.50 $ -
<br /> TOTALS $1,281,181.61 $990,176.11 $291,005.50 $0.00
<br /> Amort Pisgah Res C150341 1112.xlsx SSB 12/13/2016
<br />
|