|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Roxborough Water and FINAL
<br /> Sanitation District
<br /> Loan Contract Number C150346
<br /> Principal $18,538,550.00
<br /> Interest Rate 3.25%
<br /> Frequency Annual
<br /> Term(In Years) 30
<br /> First Payment Due December 1,2015
<br /> Payment Amount $976,642.64
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest
<br /> No. Due Date Amount BALANCE
<br /> $ 18,538,550.00
<br /> 1 1-Dec-15 $976,642.64 $ 374,139.76 $ 602,502.88 $ 18,164,410.24
<br /> 2 1-Dec-16 $976,642.64 $ 386,299.31 $ 590,343.33 $ 17,778,110.93
<br /> 3 1-Dec-17 $976,642.64 $ 398,854.03 $ 577,788.61 $ 17,379,256.90
<br /> 4 1-Dec-18 $976,642.64 $ 411,816.79 $ 564,825.85 $ 16,967,440.11
<br /> 5 1-Dec-19 $976,642.64 $ 425,200.84 $ 551,441.80 $ 16,542,239.27
<br /> 6 1-Dec-20 $976,642.64 $ 439,019.86 $ 537,622.78 $ 16,103,219.41
<br /> 7 1-Dec-21 $976,642.64 $ 453,288.01 $ 523,354.63 $ 15,649,931.40
<br /> 8 1-Dec-22 $976,642.64 $ 468,019.87 $ 508,622.77 $ 15,181,911.53
<br /> 9 1-Dec-23 $976,642.64 $ 483,230.52 $ 493,412.12 $ 14,698,681.01
<br /> 10 1-Dec-24 $976,642.64 $ 498,935.51 $ 477,707.13 $ 14,199,745.50
<br /> 11 1-Dec-25 $976,642.64 $ 515,150.91 $ 461,491.73 $ 13,684,594.59
<br /> 12 1-Dec-26 $976,642.64 $ 531,893.32 $ 444,749.32 $ 13,152,701.27
<br /> 13 1-Dec-27 $976,642.64 $ 549,179.85 $ 427,462.79 $ 12,603,521.42
<br /> 14 1-Dec-28 $976,642.64 $ 567,028.19 $ 409,614.45 $ 12,036,493.23
<br /> 15 1-Dec-29 $976,642.64 $ 585,456.61 $ 391,186.03 $ 11,451,036.62
<br /> 16 1-Dec-30 $976,642.64 $ 604,483.95 $ 372,158.69 $ 10,846,552.67
<br /> 17 1-Dec-31 $976,642.64 $ 624,129.68 $ 352,512.96 $ 10,222,422.99
<br /> 18 1-Dec-32 $976,642.64 $ 644,413.89 $ 332,228.75 $ 9,578,009.10
<br /> 19 1-Dec-33 $976,642.64 $ 665,357.34 $ 311,285.30 $ 8,912,651.76
<br /> 20 1-Dec-34 $976,642.64 $ 686,981.46 $ 289,661.18 $ 8,225,670.30
<br /> 21 1-Dec-35 $976,642.64 $ 709,308.36 $ 267,334.28 $ 7,516,361.94
<br /> 22 1-Dec-36 $976,642.64 $ 732,360.88 $ 244,281.76 $ 6,784,001.06
<br /> 23 1-Dec-37 $976,642.64 $ 756,162.61 $ 220,480.03 $ 6,027,838.45
<br /> 24 1-Dec-38 $976,642.64 $ 780,737.89 $ 195,904.75 $ 5,247,100.56
<br /> 25 1-Dec-39 $976,642.64 $ 806,111.87 $ 170,530.77 $ 4,440,988.69
<br /> 26 1-Dec-40 $976,642.64 $ 832,310.51 $ 144,332.13 $ 3,608,678.18
<br /> 27 1-Dec-41 $976,642.64 $ 859,360.60 $ 117,282.04 $ 2,749,317.58
<br /> 28 1-Dec-42 $976,642.64 $ 887,289.82 $ 89,352.82 $ 1,862,027.76
<br /> 29 1-Dec-43 $976,642.64 $ 916,126.74 $ 60,515.90 $ 945,901.02
<br /> 30 1-Dec-44 $976,642.80 $ 945,901.02 $ 30,741.78 $ -
<br /> TOTALS $29,299,279.361 $18,538,550.001 $10,760,729.36 1 $0.00
<br /> Amort Roxborough C150346 0213.xlsx SSB 12/1/2014
<br />
|