|
COLORADO WATER CONSERVATION BOARD
<br /> EMERGENCY LOAN REPAYMENT SCHEDULE
<br /> Borrower Big Elk Meadows Association Preliminary
<br /> Loan Contract Number C150391
<br /> Principal $1,515,000.00
<br /> Interest Rate 2.75%
<br /> Frequency Annual
<br /> Payment Initiation Date March 1,2014
<br /> Term(In Years) 30
<br /> First Payment Due March 1,2018
<br /> Payment Amount $80,231.01 Based on 27 Years
<br /> Loan Annual Annual
<br /> Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 1,515,000.00
<br /> 1 1-Mar-15 $0.00 $ - $ - $ 1,515,000.00
<br /> 2 1-Mar-16 $0.00 $ - $ - $ 1,515,000.00
<br /> 3 1-Mar-17 $0.00 $ - $ - $ 1,515,000.00
<br /> 4 1-Mar-18 $80,231.01 $ 38,568.51 $ 41,662.50 $ 1,476,431.49
<br /> 5 1-Mar-19 $80,231.01 $ 39,629.14 $ 40,601.87 $ 1,436,802.35
<br /> 6 1-Mar-20 $80,231.01 $ 40,718.95 $ 39,512.06 $ 1,396,083.40
<br /> 7 1-Mar-21 $80,231.01 $ 41,838.72 $ 38,392.29 $ 1,354,244.68
<br /> 8 1-Mar-22 $80,231.01 $ 42,989.28 $ 37,241.73 $ 1,311,255.40
<br /> 9 1-Mar-23 $80,231.01 $ 44,171.49 $ 36,059.52 $ 1,267,083.91
<br /> 10 1-Mar-24 $80,231.01 $ 45,386.20 $ 34,844.81 $ 1,221,697.71
<br /> 11 1-Mar-25 $80,231.01 $ 46,634.32 $ 33,596.69 $ 1,175,063.39
<br /> 12 1-Mar-26 $80,231.01 $ 47,916.77 $ 32,314.24 $ 1,127,146.62
<br /> 13 1-Mar-27 $80,231.01 $ 49,234.48 $ 30,996.53 $ 1,077,912.14
<br /> 14 1-Mar-28 $80,231.01 $ 50,588.43 $ 29,642.58 $ 1,027,323.71
<br /> 15 1-Mar-29 $80,231.01 $ 51,979.61 $ 28,251.40 $ 975,344.10
<br /> 16 1-Mar-30 $80,231.01 $ 53,409.05 $ 26,821.96 $ 921,935.05
<br /> 17 1-Mar-31 $80,231.01 $ 54,877.80 $ 25,353.21 $ 867,057.25
<br /> 18 1-Mar-32 $80,231.01 $ 56,386.94 $ 23,844.07 $ 810,670.31
<br /> 19 1-Mar-33 $80,231.01 $ 57,937.58 $ 22,293.43 $ 752,732.73
<br /> 20 1-Mar-34 $80,231.01 $ 59,530.86 $ 20,700.15 $ 693,201.87
<br /> 21 1-Mar-35 $80,231.01 $ 61,167.96 $ 19,063.05 $ 632,033.91
<br /> 22 1-Mar-36 $80,231.01 $ 62,850.08 $ 17,380.93 $ 569,183.83
<br /> 23 1-Mar-37 $80,231.01 $ 64,578.45 $ 15,652.56 $ 504,605.38
<br /> 24 1-Mar-38 $80,231.01 $ 66,354.36 $ 13,876.65 $ 438,251.02
<br /> 25 1-Mar-39 $80,231.01 $ 68,179.11 $ 12,051.90 $ 370,071.91
<br /> 26 1-Mar-40 $80,231.01 $ 70,054.03 $ 10,176.98 $ 300,017.88
<br /> 27 1-Mar-41 $80,231.01 $ 71,980.52 $ 8,250.49 $ 228,037.36
<br /> 28 1-Mar-42 $80,231.01 $ 73,959.98 $ 6,271.03 $ 154,077.38
<br /> 29 1-Mar-43 $80,231.01 $ 75,993.88 $ 4,237.13 $ 78,083.50
<br /> 30 1-Mar-44 $80,230.80 $ 78,083.50 $ 2,147.30 $ -
<br /> TOTALS $2,166,237.06 $1,515,000.00 $651,237.06
<br /> Amort Big Elk C150391 0114.xlsx SSB 5/16/2014
<br />
|