|
COLORADO WATER CONSERVATION BOARD
<br /> EMERGENCY LOAN REPAYMENT SCHEDULE
<br /> Borrower Highland Ditch Company FINAL
<br /> Loan Contract Number CT2015-023(C150369)
<br /> Principal $1,999,800.00 $1,477,756.28
<br /> Interest Rate 1.95% 1.95%
<br /> Frequency Annual Annual
<br /> Contract Execution Date December 1,2013 December 1,2013
<br /> Term(In Years) 30 27
<br /> First Payment Due December 1,2017
<br /> Payment Amount $95,971.40 $70,918.26
<br /> Loan Annual Annual
<br /> Payment Payment Payment Principal Interest Principal
<br /> No. Due Date Amount BALANCE
<br /> $ 1,477,756.28
<br /> 1 1-Dec-14 $0.00 $ - $ - $ 1,477,756.28
<br /> 2 1-Dec-15 $0.00 $ - $ - $ 1,477,756.28
<br /> 3 1-Dec-16 $0.00 $ - $ - $ 1,477,756.28
<br /> 4 1-Dec-17 $70,918.26 $ 42,102.01 $ 28,816.25 $ 1,435,654.27
<br /> 5 1-Dec-18 $70,918.26 $ 42,923.00 $ 27,995.26 $ 1,392,731.27
<br /> 6 1-Dec-19 $70,918.26 $ 43,760.00 $ 27,158.26 $ 1,348,971.27
<br /> 7 1-Dec-20 $70,918.26 $ 44,613.32 $ 26,304.94 $ 1,304,357.95
<br /> 8 1-Dec-21 $70,918.26 $ 45,483.28 $ 25,434.98 $ 1,258,874.67
<br /> 9 1-Dec-22 $70,918.26 $ 46,370.20 $ 24,548.06 $ 1,212,504.47
<br /> 10 1-Dec-23 $70,918.26 $ 47,274.42 $ 23,643.84 $ 1,165,230.05
<br /> 11 1-Dec-24 $70,918.26 $ 48,196.27 $ 22,721.99 $ 1,117,033.78
<br /> 12 1-Dec-25 $70,918.26 $ 49,136.10 $ 21,782.16 $ 1,067,897.68
<br /> 13 1-Dec-26 $70,918.26 $ 50,094.26 $ 20,824.00 $ 1,017,803.42
<br /> 14 1-Dec-27 $70,918.26 $ 51,071.09 $ 19,847.17 $ 966,732.33
<br /> 15 1-Dec-28 $70,918.26 $ 52,066.98 $ 18,851.28 $ 914,665.35
<br /> 16 1-Dec-29 $70,918.26 $ 53,082.29 $ 17,835.97 $ 861,583.06
<br /> 17 1-Dec-30 $70,918.26 $ 54,117.39 $ 16,800.87 $ 807,465.67
<br /> 18 1-Dec-31 $70,918.26 $ 55,172.68 $ 15,745.58 $ 752,292.99
<br /> 19 1-Dec-32 $70,918.26 $ 56,248.55 $ 14,669.71 $ 696,044.44
<br /> 20 1-Dec-33 $70,918.26 $ 57,345.39 $ 13,572.87 $ 638,699.05
<br /> 21 1-Dec-34 $70,918.26 $ 58,463.63 $ 12,454.63 $ 580,235.42
<br /> 22 1-Dec-35 $70,918.26 $ 59,603.67 $ 11,314.59 $ 520,631.75
<br /> 23 1-Dec-36 $70,918.26 $ 60,765.94 $ 10,152.32 $ 459,865.81
<br /> 24 1-Dec-37 $70,918.26 $ 61,950.88 $ 8,967.38 $ 397,914.93
<br /> 25 1-Dec-38 $70,918.26 $ 63,158.92 $ 7,759.34 $ 334,756.01
<br /> 26 1-Dec-39 $70,918.26 $ 64,390.52 $ 6,527.74 $ 270,365.49
<br /> 27 1-Dec-40 $70,918.26 $ 65,646.13 $ 5,272.13 $ 204,719.36
<br /> 28 1-Dec-41 $70,918.26 $ 66,926.23 $ 3,992.03 $ 137,793.13
<br /> 29 1-Dec-42 $70,918.26 $ 68,231.29 $ 2,686.97 $ 69,561.84
<br /> 30 1-Dec-43 $70,918.30 $ 69,561.84 $ 1,356.46 $ -
<br /> TOTALS $1,914,793.06 $1,477,756.28 $437,036.78 $0.00
<br /> Amort Highland Ditch C150369 1013.xlsx SSB 11/18/2016
<br />
|