| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE | AF | AG | AH | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2009 Refinanced Irrigation Bond | 2006 Sales and Franchise Tax Bond (Building) original bond | 2015 Refi of 2006 Bldg Bond | 2007Sales and Franchise Tax Bond (Parks) | Combined Payments and Balance | Total Debt by Year (start of calendar year) | |||||||||||||||||||||||||||||
2 | Year | Principal | Rate | Interest | PI | Balance | Principal | Rate | Interest | PI | Balance | Principal | Rate | Interest | PI | Balance | Principal | Rate | Interest | Total | Balance | Principal | Interest | Total | Balance | Irrigation | Building | Parks | Total | ||||||
3 | $4,310,000 | original amount | $6,000,000 | original amount | $3,970,000 | original amount | $7,315,000 | original amount | |||||||||||||||||||||||||||
4 | 2007 | $0 | $195,000 | 4.25% | $250,529 | $445,529 | $6,000,000 | $0 | 4.50% | $220,531 | $220,531 | $7,315,000 | $195,000 | $471,060 | $666,060 | $13,315,000 | $6,000,000 | $7,315,000 | $13,315,000 | ||||||||||||||||
5 | 2008 | $0 | $200,000 | 4.25% | $242,135 | $442,135 | $5,805,000 | $225,000 | 4.50% | $309,981 | $534,981 | $7,315,000 | $425,000 | $552,116 | $977,116 | $13,120,000 | $5,805,000 | $7,315,000 | $13,120,000 | ||||||||||||||||
6 | 2009 | $0 | $0 | $0 | $4,310,000 | $210,000 | 4.25% | $233,423 | $443,423 | $5,605,000 | $230,000 | 4.50% | $299,744 | $529,744 | $7,090,000 | $440,000 | $533,167 | $973,167 | $17,005,000 | $4,310,000 | $5,605,000 | $7,090,000 | $17,005,000 | ||||||||||||
7 | 2010 | $255,000 | 2.75% | $172,549 | $427,549 | $4,310,000 | $220,000 | 4.25% | $224,285 | $444,285 | $5,395,000 | $240,000 | 4.50% | $289,169 | $529,169 | $6,860,000 | $715,000 | $686,003 | $1,401,003 | $16,565,000 | $4,310,000 | $5,395,000 | $6,860,000 | $16,565,000 | |||||||||||
8 | 2011 | $280,000 | 2.75% | $146,744 | $426,744 | $4,055,000 | $230,000 | 4.25% | $214,723 | $444,723 | $5,175,000 | $250,000 | 4.50% | $278,144 | $528,144 | $6,620,000 | $760,000 | $639,611 | $1,399,611 | $15,850,000 | $4,055,000 | $5,175,000 | $6,620,000 | $15,850,000 | |||||||||||
9 | 2012 | $290,000 | 2.75% | $139,044 | $429,044 | $3,775,000 | $240,000 | 4.25% | $204,735 | $444,735 | $4,945,000 | $260,000 | 4.50% | $266,669 | $526,669 | $6,370,000 | $790,000 | $610,448 | $1,400,448 | $15,090,000 | $3,775,000 | $4,945,000 | $6,370,000 | $15,090,000 | |||||||||||
10 | 2013 | $300,000 | 3.00% | $131,069 | $431,069 | $3,485,000 | $250,000 | 4.25% | $194,323 | $444,323 | $4,705,000 | $275,000 | 4.50% | $254,631 | $529,631 | $6,110,000 | $825,000 | $580,023 | $1,405,023 | $14,300,000 | $3,485,000 | $4,705,000 | $6,110,000 | $14,300,000 | |||||||||||
11 | 2014 | $305,000 | 3.13% | $122,069 | $427,069 | $3,185,000 | $260,000 | 4.25% | $183,485 | $443,485 | $4,455,000 | $285,000 | 4.50% | $242,031 | $527,031 | $5,835,000 | $850,000 | $547,585 | $1,397,585 | $13,475,000 | $3,185,000 | $4,455,000 | $5,835,000 | $13,475,000 | |||||||||||
12 | 2015 | $315,000 | 3.25% | $112,538 | $427,538 | $2,880,000 | $270,000 | 0.00% | $0 | $270,000 | $550,000 | $0 | $56,341 | $56,341 | $3,970,000 | $300,000 | 4.50% | $228,869 | $528,869 | $5,550,000 | $885,000 | $397,748 | $1,282,748 | $12,950,000 | $2,880,000 | $4,520,000 | $5,550,000 | $12,950,000 | |||||||
13 | 2016 | $325,000 | 3.75% | $102,300 | $427,300 | $2,565,000 | $280,000 | 0.00% | $0 | $280,000 | $280,000 | $45,000 | 1.000% | $91,777 | $136,777 | $3,970,000 | $320,000 | 4.50% | $214,919 | $534,919 | $5,250,000 | $970,000 | $408,996 | $1,378,996 | $12,065,000 | $2,565,000 | $4,250,000 | $5,250,000 | $12,065,000 | ||||||
14 | 2017 | $340,000 | 4.00% | $90,113 | $430,113 | $2,240,000 | $0 | 4.00% | $0 | $0 | $0 | $354,000 | 1.200% | $91,327 | $445,327 | $3,925,000 | $330,000 | 5.25% | $199,056 | $529,056 | $4,930,000 | $1,024,000 | $380,496 | $1,404,496 | $11,095,000 | $2,240,000 | $3,925,000 | $4,930,000 | $11,095,000 | ||||||
15 | 2018 | $350,000 | 4.00% | $76,513 | $426,513 | $1,900,000 | 4.05% | $0 | $0 | $356,000 | 1.300% | $87,078 | $443,078 | $3,571,000 | $350,000 | 4.00% | $183,394 | $533,394 | $4,600,000 | $1,056,000 | $346,985 | $1,402,985 | $10,071,000 | $1,900,000 | $3,571,000 | $4,600,000 | $10,071,000 | ||||||||
16 | 2019 | $365,000 | 4.00% | $62,513 | $427,513 | $1,550,000 | 4.10% | $0 | $0 | $364,000 | 1.500% | $82,451 | $446,451 | $3,215,000 | $360,000 | 4.00% | $169,194 | $529,194 | $4,250,000 | $1,089,000 | $314,158 | $1,403,158 | $9,015,000 | $1,550,000 | $3,215,000 | $4,250,000 | $9,015,000 | ||||||||
17 | 2020 | $380,000 | 4.00% | $47,913 | $427,913 | $1,185,000 | 4.15% | $0 | $0 | $371,000 | 1.850% | $76,990 | $447,990 | $2,851,000 | $375,000 | 4.05% | $154,400 | $529,400 | $3,890,000 | $1,126,000 | $279,303 | $1,405,303 | $7,926,000 | $1,185,000 | $2,851,000 | $3,890,000 | $7,926,000 | ||||||||
18 | 2021 | $395,000 | 4.00% | $32,713 | $427,713 | $805,000 | 4.30% | $0 | $0 | $384,000 | 2.150% | $70,128 | $454,128 | $2,480,000 | $385,000 | 4.05% | $139,010 | $524,010 | $3,515,000 | $1,164,000 | $241,851 | $1,405,851 | $6,800,000 | $805,000 | $2,480,000 | $3,515,000 | $6,800,000 | ||||||||
19 | 2022 | $410,000 | 4.13% | $16,913 | $426,913 | $410,000 | 4.30% | $0 | $0 | $398,000 | 2.500% | $61,872 | $459,872 | $2,096,000 | $395,000 | 4.13% | $123,067 | $518,067 | $3,130,000 | $1,203,000 | $201,852 | $1,404,852 | $5,636,000 | $410,000 | $2,096,000 | $3,130,000 | $5,636,000 | ||||||||
20 | 2023 | $0 | $0 | 4.30% | $0 | $0 | $397,000 | 2.750% | $51,922 | $448,922 | $1,698,000 | $425,000 | 4.15% | $106,101 | $531,101 | $2,735,000 | $822,000 | $158,023 | $980,023 | $4,433,000 | $1,698,000 | $2,735,000 | $4,433,000 | ||||||||||||
21 | 2024 | $0 | $0 | 4.35% | $0 | $0 | $422,000 | 3.000% | $41,004 | $463,004 | $1,301,000 | $430,000 | 4.15% | $88,360 | $518,360 | $2,310,000 | $852,000 | $129,364 | $981,364 | $3,611,000 | $1,301,000 | $2,310,000 | $3,611,000 | ||||||||||||
22 | 2025 | $0 | $0 | 4.35% | $0 | $0 | $442,000 | 3.150% | $28,344 | $470,344 | $879,000 | $445,000 | 4.20% | $70,093 | $515,093 | $1,880,000 | $887,000 | $98,437 | $985,437 | $2,759,000 | $879,000 | $1,880,000 | $2,759,000 | ||||||||||||
23 | 2026 | $0 | $0 | 4.35% | $0 | $0 | $437,000 | 3.300% | $14,421 | $451,421 | $437,000 | $480,000 | 4.20% | $50,668 | $530,668 | $1,435,000 | $917,000 | $65,089 | $982,089 | $1,872,000 | $437,000 | $1,435,000 | $1,872,000 | ||||||||||||
24 | 2027 | $955,000 | 4.25% | $20,294 | $975,294 | $955,000 | $955,000 | $20,294 | $975,294 | $955,000 | $955,000 | $955,000 | |||||||||||||||||||||||
25 | 2028 | $0 | $0 | $0 | $0 | $0 | |||||||||||||||||||||||||||||
26 | |||||||||||||||||||||||||||||||||||
27 | Total Int to Maturity | $1,252,991 | Total Int to Maturity | $1,747,638 | Total Int to Maturity | $753,653 | Total Int to Maturity | $3,908,325 | $7,662,607 | ||||||||||||||||||||||||||
28 | Early payoff savings | $160,052 | Early payoff savings | $0 | Early payoff savings | Early payoff savings | $1,104,581 | $1,264,633 | |||||||||||||||||||||||||||
29 | pay this bond off early | ||||||||||||||||||||||||||||||||||
30 | Date early payoff can start. For example, in the case of the Park bond following the last payment in calendar year 2017 we can begin early payments. Hence, I've indicated that the bond can be paid of beginning in 2018. Although technically, it is really late 2017. | ||||||||||||||||||||||||||||||||||
31 | Principal | Interest | Total | Balance | Irrigation | Building | Parks | Total | |||||||||||||||||||||||||||
32 | 2009 | $440,000 | $533,167 | $973,167 | $17,005,000 | 2009 | $4,310,000 | $5,605,000 | $7,090,000 | $17,005,000 | |||||||||||||||||||||||||
33 | 2010 | $715,000 | $686,003 | $1,401,003 | $16,565,000 | 2010 | $4,310,000 | $5,395,000 | $6,860,000 | $16,565,000 | |||||||||||||||||||||||||
34 | 2011 | $760,000 | $639,611 | $1,399,611 | $15,850,000 | 2011 | $4,055,000 | $5,175,000 | $6,620,000 | $15,850,000 | |||||||||||||||||||||||||
35 | 2012 | $790,000 | $610,448 | $1,400,448 | $15,090,000 | 2012 | $3,775,000 | $4,945,000 | $6,370,000 | $15,090,000 | |||||||||||||||||||||||||
36 | 2013 | $825,000 | $580,023 | $1,405,023 | $14,300,000 | 2013 | $3,485,000 | $4,705,000 | $6,110,000 | $14,300,000 | |||||||||||||||||||||||||
37 | 2014 | $850,000 | $547,585 | $1,397,585 | $13,475,000 | 2014 | $3,185,000 | $4,455,000 | $5,835,000 | $13,475,000 | |||||||||||||||||||||||||
38 | 2015 | $885,000 | $397,748 | $1,282,748 | $12,950,000 | 2015 | $2,880,000 | $4,520,000 | $5,550,000 | $12,950,000 | |||||||||||||||||||||||||
39 | 2016 | $970,000 | $408,996 | $1,378,996 | $12,065,000 | 2016 | $2,565,000 | $4,250,000 | $5,250,000 | $12,065,000 | |||||||||||||||||||||||||
40 | 2017 | $1,024,000 | $380,496 | $1,404,496 | $11,095,000 | 2017 | $2,240,000 | $3,925,000 | $4,930,000 | $11,095,000 | |||||||||||||||||||||||||
41 | 2018 | $1,056,000 | $346,985 | $1,402,985 | $10,071,000 | 2018 | $1,900,000 | $3,571,000 | $4,600,000 | $10,071,000 | |||||||||||||||||||||||||
42 | 2019 | $1,089,000 | $314,158 | $1,403,158 | $9,015,000 | 2019 | $1,550,000 | $3,215,000 | $4,250,000 | $9,015,000 | |||||||||||||||||||||||||
43 | 2020 | $1,126,000 | $279,303 | $1,405,303 | $7,926,000 | 2020 | $1,185,000 | $2,851,000 | $3,890,000 | $7,926,000 | |||||||||||||||||||||||||
44 | 2021 | $1,164,000 | $241,851 | $1,405,851 | $6,800,000 | 2021 | $805,000 | $2,480,000 | $3,515,000 | $6,800,000 | |||||||||||||||||||||||||
45 | 2022 | $1,203,000 | $201,852 | $1,404,852 | $5,636,000 | 2022 | $410,000 | $2,096,000 | $3,130,000 | $5,636,000 | |||||||||||||||||||||||||
46 | 2023 | $822,000 | $158,023 | $980,023 | $4,433,000 | 2023 | $1,698,000 | $2,735,000 | $4,433,000 | ||||||||||||||||||||||||||
47 | 2024 | $852,000 | $129,364 | $981,364 | $3,611,000 | 2024 | $1,301,000 | $2,310,000 | $3,611,000 | ||||||||||||||||||||||||||
48 | 2025 | $887,000 | $98,437 | $985,437 | $2,759,000 | 2025 | $879,000 | $1,880,000 | $2,759,000 | ||||||||||||||||||||||||||
49 | 2026 | $917,000 | $65,089 | $982,089 | $1,872,000 | 2026 | $437,000 | $1,435,000 | $1,872,000 | ||||||||||||||||||||||||||
50 | 2027 | $955,000 | $20,294 | $975,294 | $955,000 | 2027 | $955,000 | $955,000 | |||||||||||||||||||||||||||
51 | 2028 | $0 | $0 | $0 | $0 | 2028 | $0 | ||||||||||||||||||||||||||||