| 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) | 30.42% | |||||||||||
13 | ||||||||||||||||||||||
14 | 2025 | 446,588,455 | 0.201 | 2026 | 633,933 | 870,714 | 616,500 | 12,679 | 2,133,825 | 889,906 | - | 889,906 | 1,243,919 | 69.19% | ||||||||
15 | 2026 | 459,986,109 | 0.340 | 2027 | 1,243,919 | 1,517,034 | 24,878 | 2,785,831 | 871,406 | 926,500 | 1,797,906 | 987,925 | 55.19% | |||||||||
16 | 2027 | 473,785,692 | 0.340 | 2028 | 987,925 | 1,562,545 | 19,758 | 2,570,229 | 867,344 | 922,550 | 1,789,894 | 780,335 | 44.09% | |||||||||
17 | 2028 | 487,999,263 | 0.340 | 2029 | 780,335 | 1,609,422 | 144,000 | 15,607 | 2,549,363 | 846,875 | 923,150 | 1,770,025 | 779,338 | 39.84% | ||||||||
18 | 2029 | 502,639,241 | 0.340 | 2030 | 779,338 | 1,657,704 | 15,587 | 2,452,629 | 825,750 | 923,075 | 207,102 | 1,955,927 | 496,702 | 30.42% | ||||||||
19 | 2030 | 517,718,418 | 0.340 | 2031 | 496,702 | 1,707,435 | 9,934 | 2,214,071 | 503,500 | 922,325 | 207,102 | 1,632,927 | 581,144 | 35.85% | ||||||||
20 | 2031 | 533,249,970 | 0.340 | 2032 | 581,144 | 1,758,658 | 220,500 | 11,623 | 2,571,925 | 488,000 | 925,900 | 207,102 | 1,621,002 | 950,923 | 53.72% | |||||||
21 | 2032 | 549,247,469 | 0.340 | 2033 | 950,923 | 1,811,418 | 19,018 | 2,781,360 | 322,500 | 923,575 | 207,102 | 317,125 | 1,770,303 | 1,011,057 | 57.45% | |||||||
22 | 2033 | 565,724,893 | 0.340 | 2034 | 1,011,057 | 1,865,761 | 20,221 | 2,897,039 | 310,000 | 925,575 | 207,102 | 317,125 | 1,759,803 | 1,137,236 | 65.04% | |||||||
23 | 2034 | 582,696,640 | 0.340 | 2035 | 1,137,236 | 1,921,734 | 288,000 | 22,745 | 3,369,714 | 302,500 | 921,675 | 207,102 | 317,125 | 1,748,403 | 1,621,312 | 75.22% | ||||||
24 | 2035 | 600,177,540 | 0.340 | 2036 | 1,621,312 | 1,979,386 | 32,426 | 3,633,123 | 295,000 | 922,100 | 207,102 | 317,125 | 414,205 | 2,155,532 | 1,477,591 | 68.64% | ||||||
25 | 2036 | 618,182,866 | 0.340 | 2037 | 1,477,591 | 2,038,767 | 29,552 | 3,545,910 | 287,500 | 926,625 | 207,102 | 317,125 | 414,205 | 2,152,557 | 1,393,353 | 65.00% | ||||||
26 | 2037 | 636,728,352 | 0.340 | 2038 | 1,393,353 | 2,099,930 | 27,867 | 3,521,150 | 280,000 | 925,025 | 207,102 | 317,125 | 414,205 | 2,143,457 | 1,377,693 | 64.65% | ||||||
27 | 2038 | 655,830,202 | 0.340 | 2039 | 1,377,693 | 2,162,928 | 27,554 | 3,568,175 | 270,000 | 922,525 | 207,102 | 317,125 | 414,205 | 2,130,957 | 1,437,218 | 67.71% | ||||||
28 | 2039 | 675,505,108 | 0.340 | 2040 | 1,437,218 | 2,227,816 | 832,500 | 28,744 | 4,526,278 | 260,000 | 924,125 | 207,102 | 317,125 | 414,205 | 2,122,557 | 2,403,721 | 78.54% | |||||
29 | 2040 | 695,770,262 | 0.390 | 2041 | 2,403,721 | 2,632,099 | 48,074 | 5,083,894 | 924,600 | 207,102 | 317,125 | 414,205 | 1,197,310 | 3,060,342 | 2,023,552 | 66.14% | ||||||
30 | 2041 | 716,643,369 | 0.390 | 2042 | 2,023,552 | 2,711,062 | 40,471 | 4,775,085 | 923,950 | 207,102 | 317,125 | 414,205 | 1,197,310 | 3,059,692 | 1,715,392 | 56.10% | ||||||
31 | 2042 | 738,142,670 | 0.390 | 2043 | 1,715,392 | 2,792,394 | 34,308 | 4,542,094 | 922,175 | 207,102 | 317,125 | 414,205 | 1,197,310 | 3,057,917 | 1,484,177 | 48.50% | ||||||
32 | 2043 | 760,286,951 | 0.390 | 2044 | 1,484,177 | 2,876,166 | 29,684 | 4,390,026 | 924,275 | 207,102 | 317,125 | 414,205 | 1,197,310 | 3,060,017 | 1,330,009 | 43.45% | ||||||
33 | 2044 | 783,095,559 | 0.390 | 2045 | 1,330,009 | 2,962,450 | 261,000 | 26,600 | 4,580,059 | 925,025 | 207,102 | 317,125 | 414,205 | 1,197,310 | 3,060,767 | 1,519,292 | 44.22% | |||||
34 | 2045 | 806,588,426 | 0.400 | 2046 | 1,519,292 | 3,129,563 | 30,386 | 4,679,241 | 924,425 | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 3,435,540 | 1,243,701 | 36.22% | |||||
35 | 2046 | 830,786,079 | 0.400 | 2047 | 1,243,701 | 3,223,450 | 24,874 | 4,492,025 | 922,475 | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 3,433,590 | 1,058,435 | 30.81% | |||||
36 | 2047 | 855,709,661 | 0.400 | 2048 | 1,058,435 | 3,320,153 | 21,169 | 4,399,757 | 924,175 | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 3,435,290 | 964,467 | 28.07% | |||||
37 | 2048 | 881,380,951 | 0.400 | 2049 | 964,467 | 3,419,758 | 19,289 | 4,403,514 | 924,300 | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 3,435,415 | 968,099 | 28.19% | |||||
38 | 2049 | 907,822,379 | 0.400 | 2050 | 968,099 | 3,522,351 | 279,000 | 19,362 | 4,788,812 | 922,850 | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 3,433,965 | 1,354,847 | 35.31% | ||||
39 | 2050 | 935,057,051 | 0.400 | 2051 | 1,354,847 | 3,628,021 | 27,097 | 5,009,965 | 924,825 | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 3,837,201 | 1,172,764 | 40.27% | ||||
40 | 2051 | 963,108,762 | 0.300 | 2052 | 1,172,764 | 2,802,646 | 23,455 | 3,998,866 | - | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,912,376 | 1,086,490 | 37.31% | ||||
41 | 2052 | 992,002,025 | 0.300 | 2053 | 1,086,490 | 2,886,726 | 21,730 | 3,994,946 | - | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,912,376 | 1,082,570 | 37.17% | ||||
42 | 2053 | 1,021,762,086 | 0.300 | 2054 | 1,082,570 | 2,973,328 | 21,651 | 4,077,549 | - | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,912,376 | 1,165,174 | 40.01% | ||||
43 | 2054 | 1,052,414,948 | 0.300 | 2055 | 1,165,174 | 3,062,527 | 23,303 | 4,251,004 | - | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,912,376 | 1,338,629 | 45.96% | ||||
44 | 2055 | 1,083,987,397 | 0.300 | 2056 | 1,338,629 | 3,154,403 | 26,773 | 4,519,805 | - | 207,102 | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,912,376 | 1,607,429 | 59.42% | ||||
45 | 2056 | 1,116,507,019 | 0.300 | 2057 | 1,607,429 | 3,249,035 | 32,149 | 4,888,613 | - | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,705,273 | 2,183,339 | 80.71% | |||||
46 | 2057 | 1,150,002,229 | 0.190 | 2058 | 2,183,339 | 2,119,454 | 43,667 | 4,346,460 | - | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,705,273 | 1,641,187 | 60.67% | |||||
47 | 2058 | 1,184,502,296 | 0.190 | 2059 | 1,641,187 | 2,183,038 | 32,824 | 3,857,048 | - | 317,125 | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,705,273 | 1,151,775 | 48.23% | |||||
48 | 2059 | 1,220,037,365 | 0.190 | 2060 | 1,151,775 | 2,248,529 | 23,035 | 3,423,339 | - | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,388,148 | 1,035,191 | 43.35% | ||||||
49 | 2060 | 1,256,638,486 | 0.190 | 2061 | 1,035,191 | 2,315,985 | 20,704 | 3,371,879 | - | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,388,148 | 983,731 | 41.19% | ||||||
50 | 2061 | 1,294,337,641 | 0.190 | 2062 | 983,731 | 2,385,464 | 19,675 | 3,388,870 | - | 414,205 | 1,197,310 | 375,373 | 401,261 | 2,388,148 | 1,000,722 | 50.70% | ||||||
51 | 2062 | 1,333,167,770 | 0.140 | 2063 | 1,000,722 | 1,810,442 | 20,014 | 2,831,178 | - | 1,197,310 | 375,373 | 401,261 | 1,973,944 | 857,235 | 43.43% | |||||||
52 | 2063 | 1,373,162,803 | 0.140 | 2064 | 857,235 | 1,864,755 | 17,145 | 2,739,135 | - | 1,197,310 | 375,373 | 401,261 | 1,973,944 | 765,191 | 38.76% | |||||||
53 | 2064 | 1,414,357,687 | 0.140 | 2065 | 765,191 | 1,920,698 | 15,304 | 2,701,193 | - | 1,197,310 | 375,373 | 401,261 | 1,973,944 | 727,249 | 36.84% | |||||||
54 | 2065 | 1,456,788,418 | 0.140 | 2066 | 727,249 | 1,978,319 | 14,545 | 2,720,113 | - | 1,197,310 | 375,373 | 401,261 | 1,973,944 | 746,169 | 37.80% | |||||||
55 | 2066 | 1,500,492,070 | 0.130 | 2067 | 746,169 | 1,892,121 | 14,923 | 2,653,213 | - | 1,197,310 | 375,373 | 401,261 | 1,973,944 | 679,269 | 87.46% | |||||||
56 | 2067 | 1,545,506,832 | 0.045 | 2068 | 679,269 | 674,614 | 13,585 | 1,367,468 | - | 375,373 | 401,261 | 776,634 | 590,835 | 76.08% | ||||||||
57 | 2068 | 1,591,872,037 | 0.045 | 2069 | 590,835 | 694,852 | 11,817 | 1,297,504 | - | 375,373 | 401,261 | 776,634 | 520,870 | 67.07% | ||||||||
58 | 2069 | 1,639,628,198 | 0.045 | 2070 | 520,870 | 715,698 | 10,417 | 1,246,985 | - | 375,373 | 401,261 | 776,634 | 470,352 | 60.56% | ||||||||
59 | 2070 | 1,688,817,044 | 0.045 | 2071 | 470,352 | 737,169 | 9,407 | 1,216,928 | - | 375,373 | 401,261 | 776,634 | 440,294 | 56.69% | ||||||||
60 | 2071 | 1,739,481,556 | 0.040 | 2072 | 440,294 | 674,919 | 8,806 | 1,124,019 | - | 375,373 | 401,261 | 776,634 | 347,385 | 86.57% | ||||||||
61 | 2072 | 1,791,666,002 | 0.020 | 2073 | 347,385 | 347,583 | 6,948 | 701,916 | - | 401,261 | 401,261 | 300,655 | 74.93% | |||||||||
62 | 2073 | 1,845,415,982 | 0.020 | 2074 | 300,655 | 358,011 | 6,013 | 664,679 | - | 401,261 | 401,261 | 263,419 | 65.65% | |||||||||
63 | 2074 | 1,900,778,462 | 0.020 | 2075 | 263,419 | 368,751 | 5,268 | 637,438 | - | 401,261 | 401,261 | 236,177 | 58.86% | |||||||||
64 | 2075 | 1,957,801,816 | 0.020 | 2076 | 236,177 | 379,814 | 4,724 | 620,714 | - | 401,261 | 401,261 | 219,454 | 54.69% | |||||||||
65 | 2076 | 2,016,535,870 | 0.020 | 2077 | 219,454 | 391,208 | 4,389 | 615,051 | - | 401,261 | 401,261 | 213,790 | ||||||||||
66 | ||||||||||||||||||||||
67 | Total | 47,118,435 | 2,362,500 | 552,590 | 7,620,281 | 23,097,800 | 5,591,761 | 8,562,385 | 11,183,523 | 32,327,371 | 10,135,068 | 10,834,038 | 109,352,227 | |||||||||
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 4.50% | 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.4000 | ||||||||||||||||||||
76 | M&O | $0.2210 | ||||||||||||||||||||
77 | Total | $0.6210 | Average Tax Bill * | $621 | ||||||||||||||||||
78 | * Based on a $100,000 home | Estimated Increase | $199 | |||||||||||||||||||
79 | ||||||||||||||||||||||
80 | ||||||||||||||||||||||
81 | ||||||||||||||||||||||
82 | ||||||||||||||||||||||
83 | ||||||||||||||||||||||
84 | ||||||||||||||||||||||
85 | ||||||||||||||||||||||
86 | ||||||||||||||||||||||
87 | ||||||||||||||||||||||
88 | ||||||||||||||||||||||
89 | ||||||||||||||||||||||
90 | ||||||||||||||||||||||
91 | ||||||||||||||||||||||
92 | ||||||||||||||||||||||
93 | ||||||||||||||||||||||
94 | ||||||||||||||||||||||
95 | ||||||||||||||||||||||
96 | ||||||||||||||||||||||
97 | ||||||||||||||||||||||
98 | ||||||||||||||||||||||
99 | ||||||||||||||||||||||
100 | ||||||||||||||||||||||