Legislative Council

BOND FORCAST five year 2020 2021 11 12 2019 (1).xlsx TOWN OF NEWTOWN 2020-2021 CIP FIVE YEAR FORECAST - USING BOS / BOE COMBINED PROPOSED PLANS FINANCE DIRECTOR PROPOSED BONDED AMOUNTS current yr 2020-21 TO 2024-25 CIP 2019-2020 2020 - 2021 2021- 2022 2022 - 2023 2023 - 2024 2024 - 2025 Current Planned Forecasted Forecasted Forecasted Forecasted Forecasted Total Est. Fiscal Debt 2020 Bond 2021 Bond 2022 Bond 2023 Bond 2024 Bond 2025 Bond Debt Service Debt Years Service Issue Issue Issue Issue Issue Issue Fiscal Year Forcasted Service 8% 9% 10% Ending Schedule (02/15/2020) (02/15/2021) (02/15/2022) (02/15/2023) (02/15/2024) (02/15/2025) Total Debt General Fund as a % of of of of Total Budget Budget Budget Budget Budget PRINCIPAL AMOUNT>>>> 11,705,000 8,220,000 13,205,000 8,290,000 8,680,000 2,000,000 40,395,000 FIVE YEAR BORROWING AMOUNT 06/30/2020 9,249,118 9,249,118 - 120,283,913 7.69% 9,622,713 10,825,552 12,028,391 06/30/2021 8,827,925 774,560 9,602,485 774,560 122,689,591 7.83% 9,815,167 11,042,063 12,268,959 06/30/2022 8,748,055 941,760 279,480 9,969,295 1,221,240 125,143,383 7.97% 10,011,471 11,262,904 12,514,338 06/30/2023 7,766,967 923,200 709,480 1,135,380 10,535,027 2,768,060 127,646,251 8.25% 10,211,700 11,488,163 12,764,625 06/30/2024 7,963,393 904,640 694,860 1,111,620 730,020 10,904,533 3,441,140 130,199,176 8.38% 10,415,934 11,717,926 13,019,918 06/30/2025 7,128,153 886,080 680,240 1,087,860 714,250 782,200 11,278,783 4,150,630 132,803,159 8.49% 10,624,253 11,952,284 13,280,316 06/30/2026 6,532,572 912,520 665,620 1,064,100 698,480 764,800 184,000 10,822,092 4,289,520 135,459,222 7.99% 10,836,738 12,191,330 13,545,922 06/30/2027 5,887,982 892,520 661,000 1,040,340 682,710 747,400 179,800 10,091,752 4,203,770 138,168,407 7.30% 11,053,473 12,435,157 13,816,841 06/30/2028 4,990,397 872,520 646,040 1,021,580 666,940 730,000 175,600 9,103,077 4,112,680 140,931,775 6.46% 11,274,542 12,683,860 14,093,178 06/30/2029 4,179,677 857,520 631,080 992,640 651,170 712,600 171,400 8,196,087 4,016,410 143,750,411 5.70% 11,500,033 12,937,537 14,375,041 06/30/2030 4,005,202 837,360 616,120 968,880 635,400 695,200 167,200 7,925,362 3,920,160 146,625,419 5.41% 11,730,034 13,196,288 14,662,542 $500,000 premium applied. Increase in Annual Debt Service: Current Year Planned Bond Issue: 353,367 3.8% 366,810 3.8% CIP Yr Project Amount 565,732 5.7% 2019-20 capital road program 1,000,000 369,506 3.5% bridge replacement program 400,000 374,250 3.4% new police facility 6,800,000 (456,691) -4.0% hawley boiler & lighting 744,000 high school boilers & lighting 2,238,000 2017-18 hawley school roof 23,000 prior high school addition 500,000 11,705,000 11/22/2019  BOND FORCAST five year 2020 2021 11 12 2019 (1).xlsx TOWN OF NEWTOWN 2020- 21 TO 2024-25 CIP EFFECT ON FUTURE DEBT SERVICE $18,000,000 $16,000,000 $14,000,000 $12,000,000 Debt Service $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 $0 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Fiscal Year Current Debt Service Forcasted Debt Service 8% of Budget 9% of Budget 10% of Budget 11/22/2019  BOND FORCAST five year 2020 2021 11 12 2019 (1).xlsx DATA INPUT: ASSUMED BUDGET GROWTH (COMBINATION GRAND LIST & TAX INCREASE): FISCAL YR GROWTH (%) 06/30/2021 2.00% 06/30/2022 2.00% 06/30/2023 2.00% Estimated 06/30/2024 2.00% Debt Service Difference 06/30/2025 2.00% 06/30/2026 2.00% 06/30/2027 2.00% 06/30/2028 2.00% 9,249,118 2,779,273 06/30/2029 2.00% 9,602,485 2,666,474 06/30/2030 2.00% 9,969,295 2,545,043 10,535,027 2,229,598 ASSUMED AVERAGE BOND INTEREST RATE: 10,904,533 2,115,385 (02/15/2020) 3.20% 11,278,783 2,001,533 (02/15/2021) 3.40% 10,822,092 2,723,830 (02/15/2022) 3.60% 10,091,752 3,725,089 (02/15/2023) 3.80% 9,103,077 4,990,101 (02/15/2024) 4.00% 8,196,087 6,178,954 (02/15/2025) 4.20% 7,925,362 6,737,180 AMOUNT TO BE BONDED: 2020 - 2021 8,220,000 2021- 2022 13,205,000 2022 - 2023 8,290,000 2023 - 2024 8,680,000 2024 - 2025 2,000,000 a look into the future (8%): 2022 - 2023 4,000,000 2023 - 2024 10,000,000 2024 - 2025 8,000,000 2025 - 2026 8,000,000 2026 - 2027 10,000,000 40,395,000 11/22/2019