|
COLORADO WATER CONSERVATION BOARD
<br /> EMERGENCY LOAN REPAYMENT SCHEDULE
<br /> Borrower Church Ditch Water Authority FINAL
<br /> Loan Contract Number CT2015-014(C150377)
<br /> Principal $606,000.00 $230,950.54
<br /> Interest Rate 2.85% 2.85%
<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 $32,479.96 $12,378.32
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 230,950.54
<br /> 1 1-Dec-14 $0.00 $ - $ - $ 230,950.54
<br /> 2 1-Dec-15 $0.00 $ - $ - $ 230,950.54
<br /> 3 1-Dec-16 $0.00 $ - $ - $ 230,950.54
<br /> 4 1-Dec-17 $12,378.32 $ 5,796.23 $ 6,582.09 $ 225,154.31
<br /> 5 1-Dec-18 $12,378.32 $ 5,961.42 $ 6,416.90 $ 219,192.89
<br /> 6 1-Dec-19 $12,378.32 $ 6,131.32 $ 6,247.00 $ 213,061.57
<br /> 7 1-Dec-20 $12,378.32 $ 6,306.07 $ 6,072.25 $ 206,755.50
<br /> 8 1-Dec-21 $12,378.32 $ 6,485.79 $ 5,892.53 $ 200,269.71
<br /> 9 1-Dec-22 $12,378.32 $ 6,670.63 $ 5,707.69 $ 193,599.08
<br /> 10 1-Dec-23 $12,378.32 $ 6,860.75 $ 5,517.57 $ 186,738.33
<br /> 11 1-Dec-24 $12,378.32 $ 7,056.28 $ 5,322.04 $ 179,682.05
<br /> 12 1-Dec-25 $12,378.32 $ 7,257.38 $ 5,120.94 $ 172,424.67
<br /> 13 1-Dec-26 $12,378.32 $ 7,464.22 $ 4,914.10 $ 164,960.45
<br /> 14 1-Dec-27 $12,378.32 $ 7,676.95 $ 4,701.37 $ 157,283.50
<br /> 15 1-Dec-28 $12,378.32 $ 7,895.74 $ 4,482.58 $ 149,387.76
<br /> 16 1-Dec-29 $12,378.32 $ 8,120.77 $ 4,257.55 $ 141,266.99
<br /> 17 1-Dec-30 $12,378.32 $ 8,352.21 $ 4,026.11 $ 132,914.78
<br /> 18 1-Dec-31 $12,378.32 $ 8,590.25 $ 3,788.07 $ 124,324.53
<br /> 19 1-Dec-32 $12,378.32 $ 8,835.07 $ 3,543.25 $ 115,489.46
<br /> 20 1-Dec-33 $12,378.32 $ 9,086.87 $ 3,291.45 $ 106,402.59
<br /> 21 1-Dec-34 $12,378.32 $ 9,345.85 $ 3,032.47 $ 97,056.74
<br /> 22 1-Dec-35 $12,378.32 $ 9,612.20 $ 2,766.12 $ 87,444.54
<br /> 23 1-Dec-36 $12,378.32 $ 9,886.15 $ 2,492.17 $ 77,558.39
<br /> 24 1-Dec-37 $12,378.32 $ 10,167.91 $ 2,210.41 $ 67,390.48
<br /> 25 1-Dec-38 $12,378.32 $ 10,457.69 $ 1,920.63 $ 56,932.79
<br /> 26 1-Dec-39 $12,378.32 $ 10,755.74 $ 1,622.58 $ 46,177.05
<br /> 27 1-Dec-40 $12,378.32 $ 11,062.27 $ 1,316.05 $ 35,114.78
<br /> 28 1-Dec-41 $12,378.32 $ 11,377.55 $ 1,000.77 $ 23,737.23
<br /> 29 1-Dec-42 $12,378.32 $ 11,701.81 $ 676.51 $ 12,035.42
<br /> 30 1-Dec-43 $12,378.43 $ 12,035.42 $ 343.01 $ -
<br /> TOTALS $334,214.75 $230,950.54 $103,264.21 $0.00
<br /> Amort Church Ditch C150377 1013.xlsx SSB 11/18/2016
<br />
|