|
COLORADO WATER CONSERVATION BOARD
<br /> EMERGENCY LOAN REPAYMENT SCHEDULE
<br /> Borrower Consolidated Home Supply Ditch Final
<br /> and Reservoir Company
<br /> Loan Contract Number CT2015-010(C150375)
<br /> Principal $1,858,400.00 $1,745,603.68
<br /> Interest Rate 1.95% 1.95%
<br /> Frequency Annual Annual
<br /> Contract Execution Date January 1,2014 January 1,2014
<br /> Term(In Years) 30 27
<br /> First Payment Due January 1,2018
<br /> Payment Amount $89,185.54 $83,772.39
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 1,745,603.68
<br /> 1 1-Jan-15 $0.00 $ - $ - $ 1,745,603.68
<br /> 2 1-Jan-16 $0.00 $ - $ - $ 1,745,603.68
<br /> 3 1-Jan-17 $0.00 $ - $ - $ 1,745,603.68
<br /> 4 I-Jan-18 $83,772.39 $ 49,733.12 $ 34,039.27 $ 1,695,870.56
<br /> 5 1-Jan-19 $83,772.39 $ 50,702.91 $ 33,069.48 $ 1,645,167.65
<br /> 6 1-Jan-20 $83,772.39 $ 51,691.62 $ 32,080.77 $ 1,593,476.03
<br /> 7 1-Jan-21 $83,772.39 $ 52,699.61 $ 31,072.78 $ 1,540,776.42
<br /> 8 1-Jan-22 $83,772.39 $ 53,727.25 $ 30,045.14 $ 1,487,049.17
<br /> 9 1-Jan-23 $83,772.39 $ 54,774.93 $ 28,997.46 $ 1,432,274.24
<br /> 10 1-Jan-24 $83,772.39 $ 55,843.04 $ 27,929.35 $ 1,376,431.20
<br /> 11 1-Jan-25 $83,772.39 $ 56,931.98 $ 26,840.41 $ 1,319,499.22
<br /> 12 1-Jan-26 $83,772.39 $ 58,042.16 $ 25,730.23 $ 1,261,457.06
<br /> 13 1-Jan-27 $83,772.39 $ 59,173.98 $ 24,598.41 $ 1,202,283.08
<br /> 14 1-Jan-28 $83,772.39 $ 60,327.87 $ 23,444.52 $ 1,141,955.21
<br /> 15 1-Jan-29 $83,772.39 $ 61,504.26 $ 22,268.13 $ 1,080,450.95
<br /> 16 1-Jan-30 $83,772.39 $ 62,703.60 $ 21,068.79 $ 1,017,747.35
<br /> 17 1-Jan-31 $83,772.39 $ 63,926.32 $ 19,846.07 $ 953,821.03
<br /> 18 1-Jan-32 $83,772.39 $ 65,172.88 $ 18,599.51 $ 888,648.15
<br /> 19 1-Jan-33 $83,772.39 $ 66,443.75 $ 17,328.64 $ 822,204.40
<br /> 20 1-Jan-34 $83,772.39 $ 67,739.40 $ 16,032.99 $ 754,465.00
<br /> 21 1-Jan-35 $83,772.39 $ 69,060.32 $ 14,712.07 $ 685,404.68
<br /> 22 1-Jan-36 $83,772.39 $ 70,407.00 $ 13,365.39 $ 614,997.68
<br /> 23 1-Jan-37 $83,772.39 $ 71,779.94 $ 11,992.45 $ 543,217.74
<br /> 24 1-Jan-38 $83,772.39 $ 73,179.64 $ 10,592.75 $ 470,038.10
<br /> 25 1-Jan-39 $83,772.39 $ 74,606.65 $ 9,165.74 $ 395,431.45
<br /> 26 1-Jan-40 $83,772.39 $ 76,061.48 $ 7,710.91 $ 319,369.97
<br /> 27 1-Jan-41 $83,772.39 $ 77,544.68 $ 6,227.71 $ 241,825.29
<br /> 28 1-Jan-42 $83,772.39 $ 79,056.80 $ 4,715.59 $ 162,768.49
<br /> 29 1-Jan-43 $83,772.39 $ 80,598.40 $ 3,173.99 $ 82,170.09
<br /> 30 1-Jan-44 $83,772.41 $ 82,170.09 $ 1,602.32 $ -
<br /> TOTALS $2,261,854.55 $1,745,603.68 $516,250.87 $0.00
<br /> Amort Con Home Supply C150375 1013.xlsx SSB 12/29/2016
<br />
|