WS - C - Tiffin Capital Planning - GO Debt Book - September 2023

Page 5 General Obligation Debt Summary ‐ With 4 GO Financings Total General Obligation Debt Revenue Sources Annual Paying Sewer Water Special Fiscal Year Principal Interest Debt Fiscal Total LOST TIF RUT Other Debt Service Levy Taxable Valuation Agent Utility Utility Assessment Payment 2023 ‐ 2024 2,165,000 468,878 2,633,878 2,800 2,636,678 ‐ 109,200 ‐ 1,561,512 210,750 ‐ ‐ 755,216 2.23926 337,260,594 2024 ‐ 2025 2,325,000 520,184 2,845,184 2,800 2,847,984 ‐ 111,500 50,000 1,569,972 216,325 ‐ 79,400 820,787 2.25342 364,241,442 2025 ‐ 2026 2,440,000 751,234 3,191,234 2,800 3,194,034 ‐ 114,600 300,000 1,573,837 237,835 ‐ 82,600 885,162 2.25014 393,380,757 2026 ‐ 2027 2,640,000 963,635 3,603,635 2,800 3,606,435 ‐ 112,600 300,000 1,569,448 233,705 ‐ 424,350 966,332 2.27452 424,851,217 2027 ‐ 2028 2,480,000 921,118 3,401,118 2,800 3,403,918 ‐ 110,600 300,000 1,594,447 229,575 ‐ 83,600 1,085,696 2.36618 458,839,315 2028 ‐ 2029 2,170,000 1,220,580 3,390,580 2,200 3,392,780 ‐ 113,600 300,000 1,500,133 235,220 ‐ 81,400 1,162,427 2.34575 495,546,460 2029 ‐ 2030 2,175,000 1,150,113 3,325,113 2,200 3,327,313 ‐ 111,500 300,000 1,431,957 235,618 ‐ 79,200 1,169,038 2.18434 535,190,177 2030 ‐ 2031 2,355,000 1,079,135 3,434,135 2,200 3,436,335 ‐ 114,400 300,000 1,380,021 235,668 ‐ 82,000 1,324,247 2.29106 578,005,391 2031 ‐ 2032 2,245,000 998,865 3,243,865 1,600 3,245,465 ‐ 112,200 300,000 1,145,772 235,618 ‐ 79,600 1,372,276 2.19829 624,245,822 2032 ‐ 2033 2,135,000 912,480 3,047,480 1,600 3,049,080 ‐ ‐ 300,000 1,057,625 235,410 ‐ 82,200 1,373,846 2.03779 674,185,488 2033 ‐ 2034 1,785,000 825,350 2,610,350 1,100 2,611,450 ‐ ‐ 300,000 777,400 234,880 ‐ 79,600 1,219,570 1.67496 728,120,327 2034 ‐ 2035 1,775,000 748,250 2,523,250 1,100 2,524,350 ‐ ‐ 300,000 779,000 239,850 ‐ 82,000 1,123,500 1.42872 786,369,953 2035 ‐ 2036 1,575,000 670,325 2,245,325 600 2,245,925 ‐ ‐ 300,000 600,000 133,725 ‐ 84,200 1,128,000 1.32818 849,279,549 2036 ‐ 2037 1,645,000 594,125 2,239,125 600 2,239,725 ‐ ‐ 300,000 600,000 134,525 ‐ 81,200 1,124,000 1.22544 917,221,913 2037 ‐ 2038 1,725,000 514,500 2,239,500 600 2,240,100 ‐ ‐ 300,000 600,000 135,150 ‐ 83,200 1,121,750 1.13239 990,599,666 2038 ‐ 2039 1,600,000 431,000 2,031,000 ‐ 2,031,000 ‐ ‐ 300,000 600,000 ‐ ‐ ‐ 1,131,000 1.05716 1,069,847,640 2039 ‐ 2040 1,670,000 351,000 2,021,000 ‐ 2,021,000 ‐ ‐ 300,000 600,000 ‐ ‐ ‐ 1,121,000 0.97020 1,155,435,451 2040 ‐ 2041 1,240,000 267,500 1,507,500 ‐ 1,507,500 ‐ ‐ 300,000 600,000 ‐ ‐ ‐ 607,500 0.48683 1,247,870,287 2041 ‐ 2042 1,305,000 205,500 1,510,500 ‐ 1,510,500 ‐ ‐ 300,000 600,000 ‐ ‐ ‐ 610,500 0.45299 1,347,699,910 2042 ‐ 2043 1,365,000 140,250 1,505,250 ‐ 1,505,250 ‐ ‐ 300,000 600,000 ‐ ‐ ‐ 605,250 0.41583 1,455,515,903 2043 ‐ 2044 1,440,000 72,000 1,512,000 ‐ 1,512,000 ‐ ‐ 300,000 600,000 ‐ ‐ ‐ 612,000 0.38932 1,571,957,175 Total 40,255,000 13,806,021 54,061,021 27,800 54,088,821 1,010,200 5,750,000 21,341,124 3,183,853 ‐ 1,484,550 21,319,095 ***Assumes an annual 8.00% growth taxable valuation based on average growth of 14.01% between fiscal 2013 to 2024 Prepared by Northland Securities, Inc. 9/29/2023