|
City of St. AnthonyDebt Levy - Roads, Tax Abatement, Public Facilities802,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 2019 Stormwater/Trails or Croft & 32nd (each @1.4m) 2019 Levy Year60 61 62 63 642020 Stormwater/Trails & Skycroft, remaining Croft Drive2018 2019street 2020 Street 2021 2022Existing BondsFund2012 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$1,700,000 - 2003A (Refunding 2011A) 503 118,057 121,103 123,992 121,473 124,204 132,028 134,286 $1,790,000 - 2004A (Refunded in 2011B) 503 128,800 $1,695,000 - 2005A (Refunded in 2011B) 503 121,500 $2,485,000 - 2006A (Refunded in 2012A) 503 186,668 $2,050,000 - 2007A (Refunded in 2012A) 503 137,737 $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 $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 $1,645,000 - 2009B (2001B & 2002A) 503 196,995 192,401 187,808 193,714 183,608 106,150 $1,375,000 - 2010A 514 108,587 112,065 110,175 108,285 111,645 109,413 112,209 114,624 111,532 113,665 115,450 111,729 113,258 114,350 $1,940,000 - 2011A 516 141,991 138,684 140,626 142,411 138,789 140,416 141,886 142,871 138,434 139,248 139,537 139,642 139,183 138,526 137,266 $2,210,000 - 2011B (2004A and 2005A) 503 - 226,977 226,899 221,025 225,157 223,441 226,430 223,528 109,589 $9,495,000 - 2012A (2006A & 2007A) 503/518 - 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 $1,775,000 - 2013A 520 - - 118,685 118,930 119,176 119,120 119,063 118,523 117,984 117,082 115,939 119,864 118,133 116,402 119,133 116,476 119,070 - $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 $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 $1,455,000 - 2016A 526102,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 $2,600,000 - 2017A 528189,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 $2,705,000 - 2018A 530184,263 182,739 181,042 184,421 182,343 179,909 182,545 184,769 181,411 183,113 184,466 180,209 181,103 181,624 181,762 Total Levy 1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,296,800 2,177,566 2,071,885 1,860,565 1,688,536 1,513,214 1,325,448 1,213,648 1,067,995 939,586 822,143 661,724 480,506 375,398 181,762 - - - - - - - 2019 Road Improvements Bonds$1,400,000 - 2019A 2019A106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 106,110 2020-2027 Road Improvements Bonds$2,500,000 - 2020A 2020A192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 192,340 $2,132,800 - 2021A 2021A167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 167,306 $2,470,600 - 2022A 2022A196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 196,324 $2,861,300 - 2023A 2023A206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 206,455 $2,766,300 - 2024A 2024A244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 244,701 $2,565,700 - 2025A 2025A240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 240,479 $2,776,800 - 2026A 2026A235,758 235,758 235,758 235,758 235,758 235,758 235,758 235,758 235,758 235,758 235,758 235,758 235,758 235,758 $2,945,600 - 2027A 2027A261,505 261,505 261,505 261,505 261,505 261,505 261,505 261,505 261,505 261,505 261,505 261,505 261,505 $3,375,500 - 2028A 2028A176,856 176,856 176,856 176,856 176,856 176,856 176,856 176,856 176,856 176,856 176,856 176,856 2028-2031 Mill/Overlays, Sidewalks and Street Lighting$715,000 - 2028A 202869,589 69,589 69,589 69,589 69,589 69,589 69,589 69,589 69,589 69,589 69,589 69,589 $648,000 - 2029A 202950,485 50,485 50,485 50,485 50,485 50,485 50,485 50,485 50,485 50,485 50,485 $634,000 - 2030A 203059,628 59,628 59,628 59,628 59,628 59,628 59,628 59,628 59,628 59,628 $439,000 - 2031A 203129,431 29,431 29,431 29,431 29,431 29,431 29,431 29,431 29,431 Additional levy - - - - - - - - 106,110 298,450 465,756 662,081 868,535 1,113,236 1,353,715 1,589,473 1,850,978 2,097,422 2,147,907 2,207,535 2,236,966 2,236,966 2,236,966 2,130,856 1,938,516 1,771,210 1,574,885 1,368,431 1,123,730 Road levy before debt reduction1,500,755 1,577,184 1,791,659 1,939,225 2,130,768 2,154,706 2,236,431 2,296,800 2,283,676 2,370,335 2,326,321 2,350,617 2,381,750 2,438,684 2,567,363 2,657,468 2,790,563 2,919,565 2,809,631 2,688,041 2,612,364 2,418,728 2,236,966 2,130,856 1,938,516 1,771,210 1,574,885 1,368,431 1,123,730 Stormwater Utilty(25,000) (170,000) (150,000) (95,000) (85,000) (85,000) (85,000) (95,000) (105,000) - - - - - - - - - - - - - - - - MSA Advance(7,500) (25,000) (85,000) (168,000) (152,500) (140,000) (120,000) (3,688) Excess Bond Balance/Project Savings(115,000) (101,921) (92,500) (140,000) (140,000) (120,000) (162,500) (207,500) (120,000) Conduit Fee(15,079) Public Facilities/Abatement Excess(5,000) (35,000) (55,000) (60,000) (65,000) (70,000) (75,000) (80,000) Infrastructure Levy84,835 164,926 132,637 42,532 (90,563) (219,565) (109,631) 11,959 75,000 150,000 225,000 200,000 275,000 350,000 425,000 500,000 Road improvement levy1,500,755 1,577,184 1,776,580 1,791,725 1,828,847 1,792,206 1,778,431 1,859,300 1,873,676 1,932,835 1,948,821 2,041,929 2,466,585 2,603,610 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,612,364 2,493,728 2,386,966 2,355,856 2,138,516 2,046,210 1,924,885 1,793,431 1,623,730 % Increase in Road levy 5.09% 12.64% 0.85% 2.07% -2.00% -0.77% 4.55% 0.77% 3.16% 0.83% 4.78% 20.80% 5.56% 3.70% 0.00% 0.00% 0.00% 0.00% 0.00% -3.25% -4.54% -4.28% -1.30% -9.23% -4.32% -5.93% -6.83% -9.46%$ Increase in Road levy 76,429 199,396 15,145 37,122 (36,641) (13,775) 80,869 14,376 59,159 15,986 93,108 424,656 137,025 96,390 (0) 0 0 (0) (0) (87,636) (118,636) (106,762) (31,110) (217,340) (92,306) (121,324) (131,455) (169,701) TAX ABATEMENT (2009A/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 - - - - - - - - - - - - - - - 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 - - - - - - - - - - - - - - - - - 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 - - - - - - - - - - - - - - - FLATL LINE2,854,932Total levied debt after reduction 2,059,923 2,102,861 2,306,067 2,327,744 2,371,281 2,413,290 2,405,743 2,485,300 2,508,653 2,576,317 2,600,142 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,700,000 2,612,364 2,493,728 2,386,966 2,355,856 2,138,516 2,046,210 1,924,885 1,793,431 1,623,730 (0) 0 0 (0) 0 0 (0) (0) 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,922,800 2,918,653 3,013,817 2,977,642 3,008,688 2,615,165 2,535,074 2,567,363 2,657,468 2,790,563 2,919,565 2,809,631 2,688,041 2,612,364 2,418,728 2,236,966 2,130,856 1,938,516 1,771,210 1,574,885 1,368,431 1,123,730 % Increase in Debt Levied 2.08% 9.66% 0.94% 1.87% 1.77% -0.31% 3.31% 0.94% 2.70% 0.92% 3.84% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -3.25% -4.54% -4.28% -1.30% -9.23% -4.32% -5.93% -6.83% -9.46%% Increase in Debt Scheduled to be levied 2.08% 10.38% 6.64% 8.00% 3.84% 3.17% 2.06% -0.14% 3.26% -1.20% 1.04% -13.08% -3.06% 1.27% 3.51% 5.01% 4.62% -3.77% -4.33% -2.82% -7.41% -7.51% -4.74% -9.03% -8.63% -11.08% -13.11% -17.88%$ Increase in levied Debt 42,939 203,205 21,678 43,537 42,009 (7,547) 79,557 23,353 67,664 23,825 99,858 (0) (0) 0 0 0 0 (0) (0) (87,636) (118,636) (106,762) (31,110) (217,340) (92,306) (121,324) (131,455) (169,701) 1,000,000 1,100,000 1,200,000 1,300,000 1,400,000 1,500,000 1,600,000 1,700,000 1,800,000 1,900,000 2,000,000 2,100,000 2,200,000 2,300,000 2,400,000 2,500,000 2,600,000 2,700,000 2,800,000 2,900,000 3,000,000 3,100,000 3,200,0002012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035Total Levied Debt before reductionTotal Levied Debt after reductionC:\Users\nicole.miller\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.Outlook\09SQWM5X\2019 scenairo DEBT LEVY MODEL for mar ws_.xlsx3/22/2018
|