|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Farmers Pawnee Canal Final
<br /> Company
<br /> Loan Contract Number CT 2015-132 (C150394)
<br /> Principal $2,067,470.00
<br /> Interest Rate 1.75%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due September 1,2017
<br /> Payment Amount $89,169.47
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 2,067,470.00
<br /> 1 1-Sep-17 $89,169.47 $ 52,988.74 $ 36,180.73 $ 2,014,481.26
<br /> 2 1-Sep-18 $89,169.47 $ 53,916.05 $ 35,253.42 $ 1,960,565.21
<br /> 3 1-Sep-19 $89,169.47 $ 54,859.58 $ 34,309.89 $ 1,905,705.63
<br /> 4 1-Sep-20 $89,169.47 $ 55,819.62 $ 33,349.85 $ 1,849,886.01
<br /> 5 1-Sep-21 $89,169.47 $ 56,796.46 $ 32,373.01 $ 1,793,089.55
<br /> 6 1-Sep-22 $89,169.47 $ 57,790.40 $ 31,379.07 $ 1,735,299.15
<br /> 7 1-Sep-23 $89,169.47 $ 58,801.73 $ 30,367.74 $ 1,676,497.42
<br /> 8 1-Sep-24 $89,169.47 $ 59,830.77 $ 29,338.70 $ 1,616,666.65
<br /> 9 1-Sep-25 $89,169.47 $ 60,877.80 $ 28,291.67 $ 1,555,788.85
<br /> 10 1-Sep-26 $89,169.47 $ 61,943.17 $ 27,226.30 $ 1,493,845.68
<br /> 11 1-Sep-27 $89,169.47 $ 63,027.17 $ 26,142.30 $ 1,430,818.51
<br /> 12 1-Sep-28 $89,169.47 $ 64,130.15 $ 25,039.32 $ 1,366,688.36
<br /> 13 1-Sep-29 $89,169.47 $ 65,252.42 $ 23,917.05 $ 1,301,435.94
<br /> 14 1-Sep-30 $89,169.47 $ 66,394.34 $ 22,775.13 $ 1,235,041.60
<br /> 15 1-Sep-31 $89,169.47 $ 67,556.24 $ 21,613.23 $ 1,167,485.36
<br /> 16 1-Sep-32 $89,169.47 $ 68,738.48 $ 20,430.99 $ 1,098,746.88
<br /> 17 1-Sep-33 $89,169.47 $ 69,941.40 $ 19,228.07 $ 1,028,805.48
<br /> 18 1-Sep-34 $89,169.47 $ 71,165.37 $ 18,004.10 $ 957,640.11
<br /> 19 1-Sep-35 $89,169.47 $ 72,410.77 $ 16,758.70 $ 885,229.34
<br /> 20 1-Sep-36 $89,169.47 $ 73,677.96 $ 15,491.51 $ 811,551.38
<br /> 21 1-Sep-37 $89,169.47 $ 74,967.32 $ 14,202.15 $ 736,584.06
<br /> 22 1-Sep-38 $89,169.47 $ 76,279.25 $ 12,890.22 $ 660,304.81
<br /> 23 1-Sep-39 $89,169.47 $ 77,614.14 $ 11,555.33 $ 582,690.67
<br /> 24 1-Sep-40 $89,169.47 $ 78,972.38 $ 10,197.09 $ 503,718.29
<br /> 25 1-Sep-41 $89,169.47 $ 80,354.40 $ 8,815.07 $ 423,363.89
<br /> 26 1-Sep-42 $89,169.47 $ 81,760.60 $ 7,408.87 $ 341,603.29
<br /> 27 1-Sep-43 $89,169.47 $ 83,191.41 $ 5,978.06 $ 258,411.88
<br /> 28 1-Sep-44 $89,169.47 $ 84,647.26 $ 4,522.21 $ 173,764.62
<br /> 29 1-Sep-45 $89,169.47 $ 86,128.59 $ 3,040.88 $ 87,636.03
<br /> 30 1-Sep-46 $89,169.66 $ 87,636.03 $ 1,533.63 $ -
<br /> TOTALS $2,675,084.29 $2,067,470.00 $607,614.29 $0.00 7
<br /> Amort Farmers Pawnee C150394 0514.xlsx SSB 10/18/2016
<br />
|