|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Penrose Water District FINAL
<br /> Loan Contract Number C150237 CT2015-040
<br /> Principal $8,415,683.54
<br /> Interest Rate 3.25%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due October 1,2016
<br /> Payment Amount $443,352.66
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest BALANCE
<br /> No. Due Date Amount
<br /> $ 8,415,683.54
<br /> 1 1-Oct-16 $443,352.66 $ 169,842.94 $ 273,509.72 $ 8,245,840.60
<br /> 2 1-Oct-17 $443,352.66 $ 175,362.84 $ 267,989.82 $ 8,070,477.76
<br /> 3 1-Oct-18 $443,352.66 $ 181,062.13 $ 262,290.53 $ 7,889,415.63
<br /> 4 1-Oct-19 $443,352.66 $ 186,946.65 $ 256,406.01 $ 7,702,468.98
<br /> 5 1-Oct-20 $443,352.66 $ 193,022.42 $ 250,330.24 $ 7,509,446.56
<br /> 6 1-Oct-21 $443,352.66 $ 199,295.65 $ 244,057.01 $ 7,310,150.91
<br /> 7 1-Oct-22 $443,352.66 $ 205,772.76 $ 237,579.90 $ 7,104,378.15
<br /> 8 1-Oct-23 $443,352.66 $ 212,460.37 $ 230,892.29 $ 6,891,917.78
<br /> 9 1-Oct-24 $443,352.66 $ 219,365.33 $ 223,987.33 $ 6,672,552.45
<br /> 10 1-Oct-25 $443,352.66 $ 226,494.71 $ 216,857.95 $ 6,446,057.74
<br /> 11 1-Oct-26 $443,352.66 $ 233,855.78 $ 209,496.88 $ 6,212,201.96
<br /> 12 1-Oct-27 $443,352.66 $ 241,456.10 $ 201,896.56 $ 5,970,745.86
<br /> 13 1-Oct-28 $443,352.66 $ 249,303.42 $ 194,049.24 $ 5,721,442.44
<br /> 14 1-Oct-29 $443,352.66 $ 257,405.78 $ 185,946.88 $ 5,464,036.66
<br /> 15 1-Oct-30 $443,352.66 $ 265,771.47 $ 177,581.19 $ 5,198,265.19
<br /> 16 1-Oct-31 $443,352.66 $ 274,409.04 $ 168,943.62 $ 4,923,856.15
<br /> 17 1-Oct-32 $443,352.66 $ 283,327.34 $ 160,025.32 $ 4,640,528.81
<br /> 18 1-Oct-33 $443,352.66 $ 292,535.47 $ 150,817.19 $ 4,347,993.34
<br /> 19 1-Oct-34 $443,352.66 $ 302,042.88 $ 141,309.78 $ 4,045,950.46
<br /> 20 1-Oct-35 $443,352.66 $ 311,859.27 $ 131,493.39 $ 3,734,091.19
<br /> 21 1-Oct-36 $443,352.66 $ 321,994.70 $ 121,357.96 $ 3,412,096.49
<br /> 22 1-Oct-37 $443,352.66 $ 332,459.52 $ 110,893.14 $ 3,079,636.97
<br /> 23 1-Oct-38 $443,352.66 $ 343,264.46 $ 100,088.20 $ 2,736,372.51
<br /> 24 1-Oct-39 $443,352.66 $ 354,420.55 $ 88,932.11 $ 2,381,951.96
<br /> 25 1-Oct-40 $443,352.66 $ 365,939.22 $ 77,413.44 $ 2,016,012.74
<br /> 26 1-Oct-41 $443,352.66 $ 377,832.25 $ 65,520.41 $ 1,638,180.49
<br /> 27 1-Oct-42 $443,352.66 $ 390,111.79 $ 53,240.87 $ 1,248,068.70
<br /> 28 1-Oct-43 $443,352.66 $ 402,790.43 $ 40,562.23 $ 845,278.27
<br /> 29 1-Oct-44 $443,352.66 $ 415,881.12 $ 27,471.54 $ 429,397.15
<br /> 30 1-Oct-45 $443,352.56 $ 429,397.15 $ 13,955.41 $ -
<br /> TOTALS $13,300,579.701 $8,415,683.54 I $4,884,896.16 I $0.00
<br /> Amort Penrose C150237 1114.xlsx SSB 9/22/2015
<br />
|