|
ATTACHMENT 2
<br />City of St. Anthony
<br />Debt Levy - Roads, Tax Abatement, Public Facilities 802,382 897,435 902,685 918,015 916,965 920,850 929,565 937,755 950,670 729,039 565,647 142,865 138,581 139,547 140,033
<br />2023 Levy Year 60 61 62 63 64
<br />2018 2019street 2020 Street 2021 2022
<br />Existing Bonds Fund 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040
<br />$1,700,000 - 2003A (Refunding 2011A) 503 118,057 121,103 123,992 121,473 124,204 132,028 134,286
<br />$1,305,000 - 2008A (2014C) 365 175,652 177,319 178,526 169,602 170,021 172,436 169,496 171,806 168,761 170,966 172,673 173,040
<br />$2,630,000 - 2009A (Refunded in 2017A) 512 184,768 185,450 185,975 186,343 186,553 186,605 172,921 179,549 180,612 181,518 187,516 187,949 182,974
<br />$1,645,000 - 2009B (2001B & 2002A) 503 196,995 192,401 187,808 193,714 183,608 106,150
<br />$1,375,000 - 2010A (Refunded in 2019A)514 108,587 112,065 110,175 108,285 111,645 109,413 112,209 114,624 103,271 110,587 112,233 108,419 109,854 111,080
<br />$1,940,000 - 2011A (Refunded in 2019A)516 141,991 138,684 140,626 142,411 138,789 140,416 141,886 142,871 125,653 121,883 123,363 124,633 125,694 126,544 121,934
<br />$2,210,000 - 2011B (2004A and 2005A) 503 250,300 226,977 226,899 221,025 225,157 223,441 226,430 223,537 109,589
<br />$9,495,000 - 2012A (2006A & 2007A) 503/518 324,405 423,185 518,973 519,813 530,693 520,758 520,968 526,218 531,153 535,773 306,356 141,358 142,865 138,581 139,547 140,033
<br />$1,775,000 - 2013B (Refunding 2021A) 520 - - 118,685 118,930 119,176 119,120 119,063 118,523 117,984 117,082 112,438 115,914 114,036 112,157 115,529 108,296 111,667
<br />$2,230,000 - 2014A 522 - - - 157,629 155,848 159,318 157,433 155,548 153,663 157,028 154,896 151,488 153,330 155,015 151,292 152,820 154,190 154,914
<br />$2,580,000 - 2015A 524 - - - - 185,075 182,847 185,869 183,537 186,454 184,016 186,829 184,286 186,993 183,886 186,029 182,331 183,884 184,819 185,111
<br />$1,455,000 - 2016A 526 102,173 106,135 104,742 103,349 101,956 105,813 104,315 102,817 106,568 104,965 103,362 107,009 105,025 103,042 105,757
<br />$2,600,000 - 2017A 528 189,734 191,592 193,296 189,591 191,136 192,523 193,753 189,575 190,647 191,562 192,320 192,919 193,362 193,646 193,774
<br />$2,610,000 - 2018A 530 179,849 180,959 181,859 177,298 177,998 178,467 178,737 178,797 180,484 176,764 178,294 179,666 180,382 180,927 181,302
<br />$1,145,000 - 2019A 532 103,950 101,430 104,160 101,430 103,950 101,010 103,320 100,170 103,058 100,537 103,268 100,590 103,162 100,328 102,742
<br />$3,000,000 - 2020A 534 235,830 237,644 232,600 232,806 232,856 232,747 237,731 237,150 236,412 232,471 233,780 234,984 236,083 237,077 232,715 (13,145)
<br />$2,165,000 - 2021A 538 155,495 158,508 156,165 153,823 151,481 159,639 157,087 154,535 157,233 156,186 93,397 92,398 91,398 90,199 94,250
<br />$2,390,000 - 2022A 2022A - 186,473 184,615 187,844 185,551 188,340 185,588 182,665 184,818 191,911 188,042 158,882 160,309 156,288 157,487 158,373 - - -
<br /> Total Levy 1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,292,395 2,258,694 2,389,519 2,327,849 2,340,934 2,168,319 1,977,677 1,861,839 1,744,768 1,608,717 1,490,120 1,338,971 1,162,252 994,286 768,993 591,526 479,202 238,592 158,373 - - -
<br />2023 Road Improvements Bonds
<br />2023 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
<br />2024-2037 Road Improvements Bonds
<br />$2,665,640 - 2024A 2024A 191,915 191,915 191,915 191,915 191,915 191,915 191,915 191,915 191,915 191,915 146,861 146,861 146,861 146,861 146,861 # NUMBERS FROM 2023 STREET COSTS AND DEBT PMT CALC'S DEBTY 323 LEVY FOLDER
<br />$2,412,260 - 2025A 2025A 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 193,715 149,271 149,271 149,271 149,271
<br />2026 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
<br />$2,493,630 - 2027A 2027A 211,950 211,950 211,950 211,950 211,950 211,950 211,950 211,950 211,950 211,950 178,444 178,444 178,444
<br />980K REDUCTION IN BORROWING (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (82,661) (69,593) (69,593) (69,593)
<br />$3,353,680- 2028A 2028A 284,944 284,944 284,944 284,944 284,944 284,944 284,944 284,944 284,944 284,944 249,697 249,697
<br />2029 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
<br />$2,932,410 - 2030A 2030A 245,043 245,043 245,043 245,043 245,043 245,043 245,043 245,043 245,043 245,043
<br />$5,009,920 - 2031A 2031A 383,777 383,777 383,777 383,777 383,777 383,777 383,777 383,777 383,777
<br />2.1M REDUCTION IN BORROWING (157,349) (157,349) (157,349) (157,349) (157,349) (157,349) (157,349) (157,349) (157,349)
<br />2032 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
<br />$3,780,100 - 2033A 2033A 292,361 292,361 292,361 292,361 292,361 292,361 292,361
<br />923K REDUCTION IN BORROWING (70,167) (70,167) (70,167) (70,167) (70,167) (70,167) (70,167)
<br />$3,591,600 - 2034A 2034A 277,608 277,608 277,608 277,608 277,608 277,608
<br />1.55M REDUCTION IN BORROWING (119,372) (119,371) (119,371) (119,371) (119,371) (119,371)
<br />2035 - OFF YEAR $0.00 $0.00 $0.00 $0.00 $0.00
<br />$2,751,130- 2036A 2036A 256,344 256,344 256,344 256,344
<br />2.25M REDUCTION IN BORROWING (210,202) (210,202) (210,202) (210,202)
<br />$3,030,60 - 2037A 2037A 243,179 243,179 243,179
<br />2038 - OFF YEAR $0.00 $0.00
<br />Additional levy - - - - - - - - - - - - - 191,915 385,630 385,630 514,920 799,864 799,864 1,044,907 1,271,335 1,271,335 1,493,529 1,606,712 1,606,712 1,608,410 1,831,150 1,795,904 1,649,042
<br />Road levy before debt reduction 1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,292,395 2,258,694 2,389,519 2,327,849 2,340,934 2,168,319 2,169,592 2,247,469 2,130,398 2,123,636 2,289,984 2,138,835 2,207,159 2,265,621 2,040,328 2,085,055 2,085,914 1,845,304 1,766,783 1,831,150 1,795,904 1,649,042
<br />Stormwater Utilty (25,000) (170,000) (150,000) (95,000) (85,000) - - - - - - - - - - - - - - - - - - - - - -
<br />MSA Advance (7,500) (25,000) (85,000) (168,000) (152,500) - (41,729) (1,374) - - - - - - - - - - - - - - - - - -
<br />Excess Bond Balance (115,000) (101,921) (92,500) (140,000) (140,009) (215,310) (354,300) (340,615) (351,824) - - - - - - - - - - - - - - - - -
<br />Conduit Fee/Refunding & Project savings (15,079) (116,180) (79,792) - - - - - - - - - - - - - - - - - -
<br />Water / Sewer bonds retired - - (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000) (140,000)
<br />Public Facilities/Abatement Excess (5,000) (35,000) (55,000) (60,000) (75,000) (70,000) (150,000) (160,000) (65,000) - - - - - - - - - - - - - - - -
<br />Infrastructure Levy - - - - - -
<br />Road improvement levy 1,500,755 1,577,184 1,776,580 1,791,725 1,828,847 1,792,206 1,778,431 1,854,886 1,852,204 1,843,699 1,835,860 1,829,110 2,103,319 2,029,592 2,107,469 1,990,398 1,983,636 2,149,984 1,998,835 2,067,159 2,125,621 1,900,328 1,945,055 1,945,914 1,705,304 1,626,783 1,691,150 1,655,904 1,509,042
<br />% Change in Road levy 5.09% 12.64% 0.85% 2.07% -2.00% -0.77% 4.30% -0.14% -0.46% -0.43% -0.37% 14.99% -3.51% 3.84% -5.56% -0.34% 8.39% -7.03% 3.42% 2.83% -10.60% 2.35% 0.04% -12.36% -4.60% 3.96% -2.08% -8.87%
<br />$ Change in Road levy 76,429 199,396 15,145 37,122 (36,641) (13,775) 76,455 (2,682) (8,505) (7,839) (6,750) 274,210 (73,728) 77,877 (117,071) (6,762) 166,348 (151,149) 68,324 58,462 (225,293) 44,727 859 (240,610) (78,521) 64,367 (35,246) (146,861)
<br />TAX ABATEMENT (2016B/2017A) 149,395 146,480 151,025 153,148 155,112 224,877 227,430 222,653 228,375 228,585 228,638 233,782 233,415 96,390 - - - - - - - - - - - - - - -
<br />PUBLIC FACILITIES (Refunded 2012A) 409,773 379,197 378,462 382,872 387,322 396,207 399,882 403,347 406,602 414,897 422,683 424,289 - - - - - - - - - - - - - - - - -
<br />559,168 525,677 529,487 536,020 542,434 621,084 627,312 626,000 634,977 643,482 651,321 658,071 233,415 96,390 - - - - - - - - - - - - - - -
<br />FLATL LINE 2,854,932
<br />Total debt levied after reduction 2,059,923 2,102,861 2,306,067 2,327,744 2,371,281 2,413,290 2,405,743 2,480,886 2,487,181 2,487,181 2,487,181 2,487,181 2,336,734 2,125,982 2,107,469 1,990,398 1,983,636 2,149,984 1,998,835 2,067,159 2,125,621 1,900,328 1,945,055 1,945,914 1,705,304 1,626,783 1,691,150 1,655,904 1,509,042
<br />2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040
<br />Total levied debt before reduction 2,059,923 2,102,861 2,321,146 2,475,244 2,673,202 2,775,790 2,863,743 2,918,395 2,893,671 3,033,001 2,979,170 2,999,005 2,401,734 2,265,982 2,247,469 2,130,398 2,123,636 2,289,984 2,138,835 2,207,159 2,265,621 2,040,328 2,085,055 2,085,914 1,845,304 1,766,783 1,831,150 1,795,904 1,649,042
<br />% Change in Debt Levied 2.08% 9.66% 0.94% 1.87% 1.77% -0.31% 3.12% 0.25% 0.00% 0.00% 0.00% -6.05% -9.02% -0.87% -5.56% -0.34% 8.39% -7.03% 3.42% 2.83% -10.60% 2.35% 0.04% -12.36% -4.60% 3.96% -2.08% -8.87%
<br />% Change in Debt Scheduled to be levied 2.08% 10.38% 6.64% 8.00% 3.84% 3.17% 1.91% -0.85% 4.82% -1.77% 0.67% -19.92% -5.65% -0.82% -5.21% -0.32% 7.83% -6.60% 3.19% 2.65% -9.94% 2.19% 0.04% -11.54% -4.26% 3.64% -1.92% -8.18%
<br />$ Change in Debt Levied 42,939 203,205 21,678 43,537 42,009 (7,547) 75,143 6,295 (0) 0 (0) (150,446)(210,753) (18,513) (117,071) (6,762) 166,348 (151,149) 68,324 58,462 (225,293) 44,727 859 (240,610) (78,521) 64,367 (35,246) (146,861)
<br />EXHBIT A
<br /> 1,500,000
<br /> 1,600,000
<br /> 1,700,000
<br /> 1,800,000
<br /> 1,900,000
<br /> 2,000,000
<br /> 2,100,000
<br /> 2,200,000
<br /> 2,300,000
<br /> 2,400,000
<br /> 2,500,000
<br /> 2,600,000
<br /> 2,700,000
<br /> 2,800,000
<br /> 2,900,000
<br /> 3,000,000
<br /> 3,100,000
<br />2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037
<br />Total Debt Levied before reduction
<br />Phase II
<br />Transition Point
<br />Modifed the pace of
<br />improvements, transition Debt
<br />Levy to Infrastrucure Levy
<br />Total Debt Levied after reduction
<br />Z:\Budget 2023\3 22 22 debt levy ws\2023 debt levy kv.xlsx 4/1/2022
|