|
COLORADO WATER CONSERVATION BOARD
<br /> CK#1219
<br /> LOAN REPAYMENT SCHEDULE $13509.46
<br /> 07.11.19
<br /> Dixon Canon Ditch and
<br /> Borrower Final
<br /> Reservoir Company J
<br /> Loan Contract Number CT 2017-914 RE 2018-644
<br /> Principal $280,881.00
<br /> Interest Rate 2.55%
<br /> Frequency Annual
<br /> Term (In Years) 30
<br /> First Payment Due July 1, 2019
<br /> Payment Amount $13,509.46
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 280,881.00
<br /> 1 1-Jut-19 $13,509.46 $ 6,346.99 $ 7,162.47 $ 274,534.01 *APPLY$2781 TO 4400 FOR FEE
<br /> 2 1-Jul-20 $13,509.46 $ 6,508.84 $ 7,000.62 $ 268,025.17
<br /> 3 1-Jul-21 $13,509.46 $ 6,674.82 $ 6,834.64 $ 261,350.35
<br /> 4 1-Jul-22 $13,509.46 $ 6,845.03 $ 6,664.43 $ 254,505.32
<br /> 5 1-Jul-23 $13,509.46 $ 7,019.57 $ 6,489.89 $ 247,485.75
<br /> 6 1-Jul-24 $13,509.46 $ 7,198.57 $ 6,310.89 $ 240,287.18
<br /> 7 1-Jul-25 $13,509.46 $ 7,382.14 $ 6,127.32 $ 232,905.04
<br /> 8 1-Jul-26 $13,509.46 $ 7,570.38 $ 5,939.08 $ 225,334.66
<br /> 9 1-Jul-27 $13,509.46 $ 7,763.43 $ 5,746.03 $ 217,571.23
<br /> 10 1-Jul-28 $13,509.46 $ 7,961.39 $ 5,548.07 $ 209,609.84
<br /> 11 1-Jul-29 $13,509.46 $ 8,164.41 $ 5,345.05 $ 201,445.43
<br /> 12 1-Jul-30 $13,509.46 $ 8,372.60 $ 5,136.86 $ 193,072.83
<br /> 13 1-Jul-31 $13,509.46 $ 8,586.10 $ 4,923.36 $ 184,486.73
<br /> 14 1-Jut-32 $13,509.46 $ 8,805.05 $ 4,704.41 $ 175,681.68
<br /> 15 1-Jul-33 $13,509.46 $ 9,029.58 $ 4,479.88 $ 166,652.10
<br /> 16 1-Jul-34 $13,509.46 $ 9,259.83 $ 4,249.63 $ 157,392.27
<br /> 17 1-Jul-35 $13,509.46 $ 9,495.96 $ 4,013.50 $ 147,896.31
<br /> 18 1-Jul-36 $13,509.46 $ 9,738.10 $ 3,771.36 $ 138,158.21
<br /> 19 1-Jul-37 $13,509.46 $ 9,986.43 $ 3,523.03 $ 128,171.78
<br /> 20 1-Jul-38 $13,509.46 $ 10,241.08 $ 3,268.38 $ 117,930.70
<br /> 21 1-Jul-39 $13,509.46 $ 10,502.23 $ 3,007.23 $ 107,428.47
<br /> 22 1-Jul-40 $13,509.46 $ 10,770.03 $ 2,739.43 $ 96,658.44
<br /> 23 1-Jul-41 $13,509.46 $ 11,044.67 $ 2,464.79 $ 85,613.77
<br /> 24 1-Jul-42 $13,509.46 $ 11,326.31 $ 2,183.15 $ 74,287.46
<br /> 25 1-Jul-43 $13,509.46 $ 11,615.13 $ 1,894.33 $ 62,672.33
<br /> 26 1-Jul-44 $13,509.46 $ 11,911.32 $ 1,598.14 $ 50,761.01
<br /> 27 1-Jul-45 $13,509.46 $ 12,215.05 $ 1,294.41 $ 38,545.96
<br /> 28 1-Jul-46 $13,509.46 $ 12,526.54 $ 982.92 $ 26,019.42
<br /> 29 1-Jul-47 $13,509.46 $ 12,845.96 $ 663.50 $ 13,173.46
<br /> 30 1-Jul-48 $13,509.38 $ 13,173.46 $ 335.92 $ -
<br /> TOTALS $405,283.72 $280,881.00 $124,402.72 $0.00
<br /> AmortDixonCanonDitchCT20160516.xtsx LCM 7/11/2019
<br />
|