|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> { Borrower Fort Lyon Canal Company Final
<br /> Loan Contract Number CT2016-1987
<br /> Principal $1,629,130.00 $1,542,496.10
<br /> Interest Rate 1.75% 1.75%
<br /> Frequency Annual Annual
<br /> Term(In Years) 30 28
<br /> First Payment Due April 1,2017
<br /> Payment Amount $70,263.98 $70,263.98
<br /> Loan Annual Annual Principal
<br /> Payment No. Payment Payment Principal Interest BALANCE
<br /> Due Date Amount
<br /> $ 1,629,130.00
<br /> Adjustment 1-Apr-16 $86,633.90 $ 86,633.90 $ - $ 1,542,496.10
<br /> 1 1-Apr-17 $70,263.98 $ 43,270.30 $ 26,993.68 $ 1,499,225.80
<br /> 2 1-Apr-18 $70,263.98 $ 44,027.53 $ 26,236.45 $ 1,455,198.27
<br /> 3 1-Apr-19 $70,263.98 $ 44,798.01 $ 25,465.97 $ 1,410,400.26
<br /> 4 1-Apr-20 $70,263.98 $ 45,581.98 $ 24,682.00 $ 1,364,818.28
<br /> 5 1-Apr-21 $70,263.98 $ 46,379.66 $ 23,884.32 $ 1,318,438.62
<br /> 6 1-Apr-22 $70,263.98 $ 47,191.30 $ 23,072.68 $ 1,271,247.32
<br /> 7 1-Apr-23 $70,263.98 $ 48,017.15 $ 22,246.83 $ 1,223,230.17
<br /> 8 1-Apr-24 $70,263.98 $ 48,857.45 $ 21,406.53 $ 1,174,372.72
<br /> 9 1-Apr-25 $70,263.98 $ 49,712.46 $ 20,551.52 $ 1,124,660.26
<br /> 10 1-Apr-26 $70,263.98 $ 50,582.43 $ 19,681.55 $ 1,074,077.83
<br /> 11 1-Apr-27 $70,263.98 $ 51,467.62 $ 18,796.36 $ 1,022,610.21
<br /> 12 1-Apr-28 $70,263.98 $ 52,368.30 $ 17,895.68 $ 970,241.91
<br /> 13 1-Apr-29 $70,263.98 $ 53,284.75 $ 16,979.23 $ 916,957.16
<br /> 14 1-Apr-30 $70,263.98 $ 54,217.23 $ 16,046.75 $ 862,739.93
<br /> 15 1-Apr-31 $70,263.98 $ 55,166.03 $ 15,097.95 $ 807,573.90
<br /> 16 1-Apr-32 $70,263.98 $ 56,131.44 $ 14,132.54 $ 751,442.46
<br /> 17 1-Apr-33 $70,263.98 $ 57,113.74 $ 13,150.24 $ 694,328.72
<br /> 18 1-Apr-34 $70,263.98 $ 58,113.23 $ 12,150.75 $ 636,215.49
<br /> 19 1-Apr-35 $70,263.98 $ 59,130.21 $ 11,133.77 $ 577,085.28
<br /> 20 1-Apr-36 $70,263.98 $ 60,164.99 $ 10,098.99 $ 516,920.29
<br /> 21 1-Apr-37 $70,263.98 $ 61,217.87 $ 9,046.11 $ 455,702.42
<br /> 22 1-Apr-38 $70,263.98 $ 62,289.19 $ 7,974.79 $ 393,413.23
<br /> 23 1-Apr-39 $70,263.98 $ 63,379.25 $ 6,884.73 $ 330,033.98
<br /> 24 1-Apr-40 $70,263.98 $ 64,488.39 $ 5,775.59 $ 265,545.59
<br /> 25 1-Apr-41 $70,263.98 $ 65,616.93 $ 4,647.05 $ 199,928.66
<br /> 26 1-Apr-42 $70,263.98 $ 66,765.23 $ 3,498.75 $ 133,163.43
<br /> 27 1-Apr-43 $70,263.98 $ 67,933.62 $ 2,330.36 $ 65,229.81
<br /> 28 1-Apr-44 $66,371.33 $ 65,229.81 $ 1,141.52 $ -
<br /> 29 1-Apr-45 $0.00 $ - $ - $ -
<br /> 30 1-Apr-46 $0.00 $ - $ - $ -
<br /> }
<br /> TOTALS $2,050,132.69 $1,629,130.00 $421,002.69 1 $0.00
<br /> AmortFortLyonCT2016I987I015.xlsx SSB 4/8/2016
<br />
|