| A | B | C | D | E | F | G | H | I | J | N | O | P | Q | R | S | T | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | #ERROR! | |||||||||||||||||||||
2 | #ERROR! | |||||||||||||||||||||
3 | ||||||||||||||||||||||
4 | #ERROR! | |||||||||||||||||||||
5 | Assuming 3% Inflation in Assessed Valuation and Bonds Sold Over the Next 25 Years | |||||||||||||||||||||
6 | ||||||||||||||||||||||
7 | 13,700,000 | 3,200,000 | 4,900,000 | 6,400,000 | 18,500,000 | 5,800,000 | 6,200,000 | |||||||||||||||
8 | Proj | Series 2026 | Series 2029 | Series 2032 | Series 2035 | Series 2040 | Series 2045 | Series 2050 | % of Next | |||||||||||||
9 | Projected | Debt | Beginning | Tax | Interest | Total | Outstanding | BI #1 | BI #2 | BI #3 | BI #4 | BI #5 | BI #6 | BI #7 | Total | Ending | Year's | |||||
10 | Tax | Assessed | Tax | Cldr | Fund | Collections | Capitalized | Income | Funds | Debt | Debt | Debt | Debt | Debt | Debt | Debt | Debt | Debt | Fund | Debt | ||
11 | Year | Valuation | Rate | Year | Balance | 97.0% | Interest | 2.0% | Available | Service | Service | Service | Service | Service | Service | Service | Service | Service | Balance | Service | ||
12 | (d) | (a) | (b) | (c) | (c) | (c) | (c) | (c) | (c) | (c) | 27.80% | |||||||||||
13 | ||||||||||||||||||||||
14 | 2025 | 446,588,455 | 0.201 | 2026 | 633,933 | 870,714 | 308,250 | 12,679 | 1,825,575 | 889,906 | - | 889,906 | 935,669 | 58.68% | ||||||||
15 | 2026 | 459,986,109 | 0.310 | 2027 | 935,669 | 1,383,178 | 18,713 | 2,337,561 | 871,406 | 723,250 | 1,594,656 | 742,904 | 46.69% | |||||||||
16 | 2027 | 473,785,692 | 0.310 | 2028 | 742,904 | 1,424,674 | 14,858 | 2,182,436 | 867,344 | 723,913 | 1,591,256 | 591,180 | 37.63% | |||||||||
17 | 2028 | 487,999,263 | 0.310 | 2029 | 591,180 | 1,467,414 | 72,000 | 11,824 | 2,142,417 | 846,875 | 724,350 | 1,571,225 | 571,192 | 33.41% | ||||||||
18 | 2029 | 502,639,241 | 0.310 | 2030 | 571,192 | 1,511,436 | 11,424 | 2,094,052 | 825,750 | 724,563 | 159,430 | 1,709,743 | 384,310 | 27.80% | ||||||||
19 | 2030 | 517,718,418 | 0.310 | 2031 | 384,310 | 1,556,779 | 7,686 | 1,948,775 | 503,500 | 719,550 | 159,430 | 1,382,480 | 566,295 | 41.28% | ||||||||
20 | 2031 | 533,249,970 | 0.310 | 2032 | 566,295 | 1,603,483 | 110,250 | 11,326 | 2,291,354 | 488,000 | 724,425 | 159,430 | 1,371,855 | 919,499 | 63.41% | |||||||
21 | 2032 | 549,247,469 | 0.280 | 2033 | 919,499 | 1,491,756 | 18,390 | 2,429,645 | 322,500 | 723,963 | 159,430 | 244,127 | 1,450,020 | 979,625 | 68.18% | |||||||
22 | 2033 | 565,724,893 | 0.280 | 2034 | 979,625 | 1,536,509 | 19,592 | 2,535,726 | 310,000 | 723,275 | 159,430 | 244,127 | 1,436,832 | 1,098,894 | 76.93% | |||||||
23 | 2034 | 582,696,640 | 0.280 | 2035 | 1,098,894 | 1,582,604 | 144,000 | 21,978 | 2,847,476 | 302,500 | 722,363 | 159,430 | 244,127 | 1,428,420 | 1,419,056 | 81.62% | ||||||
24 | 2035 | 600,177,540 | 0.280 | 2036 | 1,419,056 | 1,630,082 | 28,381 | 3,077,520 | 295,000 | 721,225 | 159,430 | 244,127 | 318,860 | 1,738,642 | 1,338,877 | 77.40% | ||||||
25 | 2036 | 618,182,866 | 0.280 | 2037 | 1,338,877 | 1,678,985 | 26,778 | 3,044,640 | 287,500 | 719,863 | 159,430 | 244,127 | 318,860 | 1,729,780 | 1,314,860 | 76.19% | ||||||
26 | 2037 | 636,728,352 | 0.280 | 2038 | 1,314,860 | 1,729,354 | 26,297 | 3,070,511 | 280,000 | 723,275 | 159,430 | 244,127 | 318,860 | 1,725,692 | 1,344,819 | 78.47% | ||||||
27 | 2038 | 655,830,202 | 0.280 | 2039 | 1,344,819 | 1,781,235 | 26,896 | 3,152,950 | 270,000 | 721,350 | 159,430 | 244,127 | 318,860 | 1,713,767 | 1,439,183 | 84.33% | ||||||
28 | 2039 | 675,505,108 | 0.280 | 2040 | 1,439,183 | 1,834,672 | 416,250 | 28,784 | 3,718,889 | 260,000 | 724,200 | 159,430 | 244,127 | 318,860 | 1,706,617 | 2,012,271 | 85.06% | |||||
29 | 2040 | 695,770,262 | 0.310 | 2041 | 2,012,271 | 2,092,181 | 40,245 | 4,144,698 | 721,713 | 159,430 | 244,127 | 318,860 | 921,705 | 2,365,834 | 1,778,864 | 75.12% | ||||||
30 | 2041 | 716,643,369 | 0.310 | 2042 | 1,778,864 | 2,154,947 | 35,577 | 3,969,387 | 724,000 | 159,430 | 244,127 | 318,860 | 921,705 | 2,368,122 | 1,601,265 | 67.70% | ||||||
31 | 2042 | 738,142,670 | 0.310 | 2043 | 1,601,265 | 2,219,595 | 32,025 | 3,852,886 | 720,950 | 159,430 | 244,127 | 318,860 | 921,705 | 2,365,072 | 1,487,814 | 62.86% | ||||||
32 | 2043 | 760,286,951 | 0.310 | 2044 | 1,487,814 | 2,286,183 | 29,756 | 3,803,753 | 722,675 | 159,430 | 244,127 | 318,860 | 921,705 | 2,366,797 | 1,436,956 | 60.68% | ||||||
33 | 2044 | 783,095,559 | 0.310 | 2045 | 1,436,956 | 2,354,768 | 130,500 | 28,739 | 3,950,963 | 724,063 | 159,430 | 244,127 | 318,860 | 921,705 | 2,368,184 | 1,582,779 | 59.66% | |||||
34 | 2045 | 806,588,426 | 0.310 | 2046 | 1,582,779 | 2,425,411 | 31,656 | 4,039,846 | 720,113 | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 2,653,201 | 1,386,645 | 52.25% | |||||
35 | 2046 | 830,786,079 | 0.310 | 2047 | 1,386,645 | 2,498,174 | 27,733 | 3,912,551 | 720,938 | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 2,654,026 | 1,258,525 | 47.41% | |||||
36 | 2047 | 855,709,661 | 0.310 | 2048 | 1,258,525 | 2,573,119 | 25,170 | 3,856,814 | 721,425 | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 2,654,514 | 1,202,301 | 45.29% | |||||
37 | 2048 | 881,380,951 | 0.310 | 2049 | 1,202,301 | 2,650,313 | 24,046 | 3,876,659 | 721,575 | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 2,654,664 | 1,221,995 | 46.04% | |||||
38 | 2049 | 907,822,379 | 0.310 | 2050 | 1,221,995 | 2,729,822 | 139,500 | 24,440 | 4,115,757 | 721,388 | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 2,654,476 | 1,461,281 | 49.32% | ||||
39 | 2050 | 935,057,051 | 0.240 | 2051 | 1,461,281 | 2,176,813 | 29,226 | 3,667,319 | 720,863 | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,962,847 | 704,472 | 31.42% | ||||
40 | 2051 | 963,108,762 | 0.240 | 2052 | 704,472 | 2,242,117 | 14,089 | 2,960,679 | - | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,241,984 | 718,694 | 32.06% | ||||
41 | 2052 | 992,002,025 | 0.240 | 2053 | 718,694 | 2,309,381 | 14,374 | 3,042,449 | - | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,241,984 | 800,464 | 35.70% | ||||
42 | 2053 | 1,021,762,086 | 0.240 | 2054 | 800,464 | 2,378,662 | 16,009 | 3,195,136 | - | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,241,984 | 953,151 | 42.51% | ||||
43 | 2054 | 1,052,414,948 | 0.240 | 2055 | 953,151 | 2,450,022 | 19,063 | 3,422,236 | - | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,241,984 | 1,180,252 | 52.64% | ||||
44 | 2055 | 1,083,987,397 | 0.240 | 2056 | 1,180,252 | 2,523,523 | 23,605 | 3,727,380 | - | 159,430 | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,241,984 | 1,485,395 | 71.33% | ||||
45 | 2056 | 1,116,507,019 | 0.200 | 2057 | 1,485,395 | 2,166,024 | 29,708 | 3,681,127 | - | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,082,554 | 1,598,572 | 76.76% | |||||
46 | 2057 | 1,150,002,229 | 0.150 | 2058 | 1,598,572 | 1,673,253 | 31,971 | 3,303,797 | - | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,082,554 | 1,221,242 | 58.64% | |||||
47 | 2058 | 1,184,502,296 | 0.150 | 2059 | 1,221,242 | 1,723,451 | 24,425 | 2,969,118 | - | 244,127 | 318,860 | 921,705 | 288,967 | 308,896 | 2,082,554 | 886,564 | 48.22% | |||||
48 | 2059 | 1,220,037,365 | 0.150 | 2060 | 886,564 | 1,775,154 | 17,731 | 2,679,449 | - | 318,860 | 921,705 | 288,967 | 308,896 | 1,838,427 | 841,022 | 45.75% | ||||||
49 | 2060 | 1,256,638,486 | 0.150 | 2061 | 841,022 | 1,828,409 | 16,820 | 2,686,251 | - | 318,860 | 921,705 | 288,967 | 308,896 | 1,838,427 | 847,824 | 46.12% | ||||||
50 | 2061 | 1,294,337,641 | 0.150 | 2062 | 847,824 | 1,883,261 | 16,956 | 2,748,042 | - | 318,860 | 921,705 | 288,967 | 308,896 | 1,838,427 | 909,615 | 59.86% | ||||||
51 | 2062 | 1,333,167,770 | 0.115 | 2063 | 909,615 | 1,487,149 | 18,192 | 2,414,956 | - | 921,705 | 288,967 | 308,896 | 1,519,567 | 895,388 | 58.92% | |||||||
52 | 2063 | 1,373,162,803 | 0.115 | 2064 | 895,388 | 1,531,763 | 17,908 | 2,445,059 | - | 921,705 | 288,967 | 308,896 | 1,519,567 | 925,492 | 60.90% | |||||||
53 | 2064 | 1,414,357,687 | 0.115 | 2065 | 925,492 | 1,577,716 | 18,510 | 2,521,718 | - | 921,705 | 288,967 | 308,896 | 1,519,567 | 1,002,150 | 65.95% | |||||||
54 | 2065 | 1,456,788,418 | 0.115 | 2066 | 1,002,150 | 1,625,047 | 20,043 | 2,647,241 | - | 921,705 | 288,967 | 308,896 | 1,519,567 | 1,127,674 | 74.21% | |||||||
55 | 2066 | 1,500,492,070 | 0.040 | 2067 | 1,127,674 | 582,191 | 22,553 | 1,732,418 | - | 921,705 | 288,967 | 308,896 | 1,519,567 | 212,851 | 35.60% | |||||||
56 | 2067 | 1,545,506,832 | 0.040 | 2068 | 212,851 | 599,657 | 4,257 | 816,764 | - | 288,967 | 308,896 | 597,863 | 218,902 | 36.61% | ||||||||
57 | 2068 | 1,591,872,037 | 0.040 | 2069 | 218,902 | 617,646 | 4,378 | 840,926 | - | 288,967 | 308,896 | 597,863 | 243,064 | 40.66% | ||||||||
58 | 2069 | 1,639,628,198 | 0.040 | 2070 | 243,064 | 636,176 | 4,861 | 884,101 | - | 288,967 | 308,896 | 597,863 | 286,238 | 47.88% | ||||||||
59 | 2070 | 1,688,817,044 | 0.040 | 2071 | 286,238 | 655,261 | 5,725 | 947,224 | - | 288,967 | 308,896 | 597,863 | 349,362 | 58.44% | ||||||||
60 | 2071 | 1,739,481,556 | 0.030 | 2072 | 349,362 | 506,189 | 6,987 | 862,538 | - | 288,967 | 308,896 | 597,863 | 264,675 | 85.68% | ||||||||
61 | 2072 | 1,791,666,002 | 0.015 | 2073 | 264,675 | 260,687 | 5,294 | 530,656 | - | 308,896 | 308,896 | 221,761 | 71.79% | |||||||||
62 | 2073 | 1,845,415,982 | 0.015 | 2074 | 221,761 | 268,508 | 4,435 | 494,704 | - | 308,896 | 308,896 | 185,808 | 60.15% | |||||||||
63 | 2074 | 1,900,778,462 | 0.015 | 2075 | 185,808 | 276,563 | 3,716 | 466,088 | - | 308,896 | 308,896 | 157,192 | 50.89% | |||||||||
64 | 2075 | 1,957,801,816 | 0.015 | 2076 | 157,192 | 284,860 | 3,144 | 445,196 | - | 308,896 | 308,896 | 136,300 | 44.13% | |||||||||
65 | 2076 | 2,016,535,870 | 0.015 | 2077 | 136,300 | 293,406 | 2,726 | 432,432 | - | 308,896 | 308,896 | 123,537 | ||||||||||
66 | ||||||||||||||||||||||
67 | Total | 39,114,133 | 1,181,250 | 511,338 | 7,620,281 | 18,059,263 | 4,304,610 | 6,591,434 | 8,609,220 | 24,886,028 | 7,802,106 | 8,340,182 | 86,213,125 | |||||||||
68 | ||||||||||||||||||||||
69 | (a) | Debt service fund balance as of 11/19/25 | Adopted 2025 Tax Rate: | |||||||||||||||||||
70 | (b) | Represents one year of capitalized interest on the Bonds | Debt | $0.2010 | ||||||||||||||||||
71 | (c) | Assumes an interest rate on the Bonds of 2.25% | M&O | $0.2210 | ||||||||||||||||||
72 | (d) | 2025 certified value | Total | $0.4220 | Average Tax Bill * | $422 | ||||||||||||||||
73 | ||||||||||||||||||||||
74 | Estimated Tax Rate (if all bonds sold): | |||||||||||||||||||||
75 | Debt | $0.3100 | ||||||||||||||||||||
76 | M&O | $0.2210 | ||||||||||||||||||||
77 | Total | $0.5310 | Average Tax Bill * | $531 | ||||||||||||||||||
78 | * Based on a $100,000 home | Estimated Increase | $109 | |||||||||||||||||||
79 | ||||||||||||||||||||||
80 | ||||||||||||||||||||||
81 | ||||||||||||||||||||||
82 | ||||||||||||||||||||||
83 | ||||||||||||||||||||||
84 | ||||||||||||||||||||||
85 | ||||||||||||||||||||||
86 | ||||||||||||||||||||||
87 | ||||||||||||||||||||||
88 | ||||||||||||||||||||||
89 | ||||||||||||||||||||||
90 | ||||||||||||||||||||||
91 | ||||||||||||||||||||||
92 | ||||||||||||||||||||||
93 | ||||||||||||||||||||||
94 | ||||||||||||||||||||||
95 | ||||||||||||||||||||||
96 | ||||||||||||||||||||||
97 | ||||||||||||||||||||||
98 | ||||||||||||||||||||||
99 | ||||||||||||||||||||||
100 | ||||||||||||||||||||||