|
COLORADO WATER CONSERVATION BOARD
<br /> LOAN REPAYMENT SCHEDULE
<br /> Borrower Petrocco Family Limited FINAL
<br /> Partnership,LLLP
<br /> Loan Contract Number C150363 CT2015-001
<br /> Principal $840,825.00
<br /> Interest Rate 1.50%
<br /> Frequency Annual
<br /> Term(In Years) 20
<br /> First Payment Due October 1,2015
<br /> Payment Amount $48,974.47
<br /> Loan Annual Annual Principal
<br /> Payment Payment Payment Principal Interest
<br /> No. Due Date Amount BALANCE
<br /> $ 840,825.00
<br /> 1 1-Oct-15 $48,974.47 $ 36,362.09 $ 12,612.38 $ 804,462.91
<br /> 2 1-Oct-16 $48,974.47 $ 36,907.53 $ 12,066.94 $ 767,555.38
<br /> 3 1-Oct-17 $48,974.47 $ 37,461.14 $ 11,513.33 $ 730,094.24
<br /> 4 1-Oct-18 $48,974.47 $ 38,023.06 $ 10,951.41 $ 692,071.18
<br /> 5 1-Oct-19 $48,974.47 $ 38,593.40 $ 10,381.07 $ 653,477.78
<br /> 6 1-Oct-20 $48,974.47 $ 39,172.30 $ 9,802.17 $ 614,305.48
<br /> 7 1-Oct-21 $48,974.47 $ 39,759.89 $ 9,214.58 $ 574,545.59
<br /> 8 1-Oct-22 $48,974.47 $ 40,356.29 $ 8,618.18 $ 534,189.30
<br /> 9 1-Oct-23 $48,974.47 $ 40,961.63 $ 8,012.84 $ 493,227.67
<br /> 10 1-Oct-24 $48,974.47 $ 41,576.05 $ 7,398.42 $ 451,651.62
<br /> 11 1-Oct-25 $48,974.47 $ 42,199.70 $ 6,774.77 $ 409,451.92
<br /> 12 1-Oct-26 $48,974.47 $ 42,832.69 $ 6,141.78 $ 366,619.23
<br /> 13 1-Oct-27 $48,974.47 $ 43,475.18 $ 5,499.29 $ 323,144.05
<br /> 14 1-Oct-28 $48,974.47 $ 44,127.31 $ 4,847.16 $ 279,016.74
<br /> 15 1-Oct-29 $48,974.47 $ 44,789.22 $ 4,185.25 $ 234,227.52
<br /> 16 1-Oct-30 $48,974.47 $ 45,461.06 $ 3,513.41 $ 188,766.46
<br /> 17 1-Oct-31 $48,974.47 $ 46,142.97 $ 2,831.50 $ 142,623.49
<br /> 18 1-Oct-32 $48,974.47 $ 46,835.12 $ 2,139.35 $ 95,788.37
<br /> 19 1-Oct-33 $48,974.47 $ 47,537.64 $ 1,436.83 $ 48,250.73
<br /> 20 1-Oct-34 $48,974.49 $ 48,250.73 $ 723.76 $ -
<br /> TOTALS $979,489.42 I $840,825.00 I $138,664.42 I $0.00
<br /> Amort Petrocco C150363 1013.xlsx SSB 10/2/2014
<br />
|