Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Option 3 of the Draft 2022 Scandia City Budget & Utility Budget
9/1/2021CITY OF SCANDIA 9/1/2021 Financial Management Plan Option III: Bond Funding Inflation Assumptions 531,272 586,043 634,802 665,770 664,685 678,858 699,223 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Interest Earnings 1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50% Expenses 2.00%2.50%3.00%3.00%3.00%3.00%3.00%3.00% Actual Actual Adopted Preliminary Projected GENERAL FUND 2017 2018 2019 2020 2021 2022 2023 2024 REVENUE 1 General Property Tax-Current 1,556,278 1,358,056 1,409,921 1,553,879 1,381,700 1,583,000 1,621,127 1,673,026 2 Other taxes 17,000 24,500 24,990 25,490 3 Intergovernmental 107,716 105,857 67,105 72,885 62,900 64,200 65,484 66,794 4 Federal grant 311,080 5 Franchise fees 5,104 6 Licenses and Permits 366,902 300,274 150,876 151,164 108,400 149,500 152,490 155,540 7 Charges for Services 63,886 5,917 66,979 43,276 58,600 51,200 52,224 53,268 8 Fines & Forfeits 8,392 9,517 7,831 7,561 8,100 7,000 7,140 7,283 9 Interest Earnings 12,958 12,560 21,631 11,463 17,900 15,900 16,139 16,381 10 Miscellaneous Revenues 38,023 15,411 12,223 18,879 18,900 16,900 11 - - - 12 Total Revenue 2,154,155 1,807,592 1,736,566 2,175,291 1,673,500 1,912,200 1,939,593 1,997,781 EXPENSES 13 Current 14 General Government 566,215 521,457 514,691 535,026 609,320 611,620 629,969 648,868 15 Public Safety 334,787 361,381 408,622 323,316 435,090 435,090 448,143 461,587 16 Public Works 665,123 517,139 624,818 568,500 688,590 683,490 703,995 725,115 17 Park and Recreation 99,791 107,916 120,523 133,534 163,200 152,900 157,487 162,212 18 Applied to Federal Grant 198,919 19 Federal fund returned 31,088 20 Capital Outlay - 10,026 5,754 23,337 6,000 16,000 21 - - - - 22 - - - - - - - 23 - - - - - - 24 - - - - - - - 25 Total Expenses 1,665,916 1,517,919 1,674,408 1,813,720 1,902,200 1,899,100 1,939,593 1,997,781 26 Revenues Over / (Under) Expenses 488,239 289,673 62,158 361,571 (228,700) 13,100 - - OTHER FINANCING SOURCES / (USES) 27 Transfers In - - 28 Contingency 29 Sale of Fixed Assets - - - - 30 Bond Proceeds - - - - - - 31 Transfer in 1,440 32 Transfer out to General Capital (200,000) 33 Transfer out to Local Road Improvement (80,000) 34 Transfers Out (523,200) (423,500) (444,962) (3,000) - - 35 Total Other Sources / (Uses)(523,200) (423,500) (444,962) (3,000) (278,560) - - - 36 37 Prior Period Adjustments 38 Ending General Fund Balance (FB)1,715,008 1,581,181 1,198,377 1,694,699 1,187,439 1,200,539 1,200,539 1,200,539 39 Restricted - - - - - - - 40 Unassigned 1,715,008 1,581,181 1,198,377 1,694,699 1,187,439 1,200,539 1,200,539 1,200,539 9/1/2021CITY OF SCANDIA 9/1/2021 Financial Management Plan Option III: Bond Funding Inflation Assumptions 531,272 586,043 634,802 665,770 664,685 678,858 699,223 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Interest Earnings 1.00%1.25%1.50%1.50%1.50%1.50%1.50%1.50% Expenses 2.00%2.50%3.00%3.00%3.00%3.00%3.00%3.00% Actual Actual Adopted Preliminary Projected GENERAL FUND 2017 2018 2019 2020 2021 2022 2023 2024 41 Fund Balance as a % of Next Year's Expenditures (net of contingency)66.1%89.1%62.5%61.9%60.1%58.3% Actual Actual Adopted Preliminary Projected Levy by Type 2017 2018 2019 2020 2021 2022 2023 2024 41 General Fund Operating Tax Levy 1,545,600 1,349,820 1,342,592 1,484,700 1,381,700 1,583,000 1,621,127 1,673,026 42 Annual Increase -12.7%-0.5%10.6%-6.9%14.6%2.4%3.2% ANNUAL DEBT LEVIES BY BOND ISSUE-FUTURE 48 Total Annual Debt Levies - - - - - - - OTHER SPECIAL TAX LEVIES 49 Debt service 50 2013 Certificates 68,000 66,752 68,816 72,831 68,220 66,000 64,000 - 51 2015 Certificates 48,739 47,566 48,996 45,670 52 2017 Certificates 37,884 37,418 36,695 35,909 34,524 53 2018 GO Bonds 346,120 343,534 341,456 344,531 342,536 345,634 54 Local road improvement debt levy - - - - 55 Capital improvement debt levy - - - - 56 Park Improvement 30,000 10,000 20,000 40,000 60,000 57 Equipment Replacement 30,000 30,000 30,000 130,000 30,000 50,000 75,000 58 Local Road Improvement 560,533 725,050 378,930 381,516 438,539 350,000 350,000 400,000 62 General Capital Improvement 30,000 100,000 250,000 200,000 150,000 63 64 EDA 5,000 5,000 5,000 5,000 5,000 8,000 80,000 8,000 65 66 - 67 Total Other Special Levies 712,272 912,252 915,280 945,246 1,129,124 1,103,055 1,126,536 1,038,634 68 Total Tax Levy 2,257,872 2,262,072 2,257,872 2,429,946 2,510,824 2,686,055 2,747,663 2,711,660 69 Increase/(Decrease) in Total Tax Levy 0.19%-0.19%7.62%3.33%6.98%2.29%-1.31% 70 Less: Fiscal Disparities (112,010)(121,125)(132,815)(133,843)(123,890)(118,798)(124,163)(122,003) 71 Net Levy to Taxpayers 2,145,862 2,140,947 2,125,057 2,296,103 2,386,934 2,567,257 2,623,499 2,589,657 72 73 Existing Tax Base 6,023,919 6,230,838 6,723,403 7,460,384 7,911,011 8,140,985 8,466,624 8,635,956 84 New Net Tax Capacity 0 0 0 0 0 0 0 0 85 Total Net Tax Capacity 6,023,919 6,230,838 6,723,403 7,460,384 7,911,011 8,140,985 8,466,624 8,635,956 86 Tax Rate on Tax Capacity 35.622%34.361%31.607%30.777%30.172%31.535%30.986%29.987% 87 Tax Rate % Change -3.54%-8.01%-2.62%-1.97%4.52%-1.74%-3.23% 88 City Taxes on $297,800 Residential Homestead 1,022 1,002 1,024 1,112 1,126 1,229 1,260 1,246 89 $ Tax Increase/(Decrease)(20)$ 22$ 88$ 14$ 103$ 32$ (15)$ 90 % Tax Increase / (Decrease)-2.00%2.18%8.59%1.26%9.14%2.57%-1.16% 91 Existing Tax Base Inflation / (Deflation)0.0%0.0%0.0%1.0%2.0%4.0%4.0%2.0% 92 Total Tax Base Increase 3%8%11%6%3%4%2% 9/1/2021 720,200 741,806 764,060 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2025 2026 2027 2028 2029 2030 2031 1,726,546 1,831,737 1,863,651 1,942,340 2,002,859 2,065,264 2,084,613 26,000 26,520 27,050 27,591 28,143 28,706 29,280 68,130 69,492 70,882 72,300 73,746 75,221 76,725 158,651 161,824 165,060 168,361 171,729 175,163 178,666 54,334 55,421 56,529 57,660 58,813 59,989 61,189 7,428 7,577 7,729 7,883 8,041 8,202 8,366 16,626 16,876 17,129 17,386 17,647 17,911 18,180 - - - - - - - 2,057,714 2,169,446 2,208,029 2,293,520 2,360,975 2,430,455 2,457,018 668,334 688,384 709,035 730,306 752,215 774,782 798,025 475,435 489,698 504,389 519,520 535,106 551,159 567,694 746,868 769,274 792,352 816,123 840,606 865,825 891,799 167,078 172,090 177,253 182,571 188,048 193,689 199,500 - - - - - - - - - - - - - - - - - - - - - - - - - - - - 2,057,714 2,119,446 2,183,029 2,248,520 2,315,975 2,385,455 2,457,018 - 50,000 25,000 45,000 45,000 45,000 - - - - - - - - (50,000) (25,000) (45,000) (45,000) (45,000) - - - - - - - - - - - - - - - - - - (50,000) (25,000) (45,000) (45,000) (45,000) - 1,200,539 1,250,539 1,275,539 1,320,539 1,365,539 1,410,539 1,410,539 - - - - - - - 1,200,539 1,250,539 1,275,539 1,320,539 1,365,539 1,410,539 1,410,539 9/1/2021 720,200 741,806 764,060 2.00%2.00%2.00%2.00%2.00%2.00%2.00% 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 2025 2026 2027 2028 2029 2030 2031 56.6%57.3%56.7%57.0%57.2%57.4%57.4% 2025 2026 2027 2028 2029 2030 2031 1,726,546 1,831,737 1,863,651 1,942,340 2,002,859 2,065,264 2,084,613 3.2%6.1%1.7%4.2%3.1%3.1%0.9% - - - - - - - 343,166 340,541 343,009 345,161 341,749 343,429 344,794 59,370 156,120 235,279 296,848 395,321 395,321 395,321 96,750 96,750 96,750 96,750 162,717 162,717 162,717 70,000 70,000 70,000 70,000 70,000 70,000 70,000 115,000 100,000 100,000 100,000 75,000 75,000 75,000 300,000 200,000 200,000 200,000 200,000 200,000 200,000 85,000 85,000 50,000 50,000 50,000 50,000 50,000 8,000 8,000 8,000 12,000 12,000 12,000 12,000 1,077,286 1,056,411 1,103,039 1,170,759 1,306,787 1,308,467 1,309,832 2,803,832 2,888,148 2,966,689 3,113,099 3,309,646 3,373,731 3,394,445 3.40%3.01%2.72%4.94%6.31%1.94%0.61% (118,068)(120,049)(121,303)(122,245)(125,975)(131,467)(131,261) 2,685,764 2,768,100 2,845,387 2,990,854 3,183,671 3,242,264 3,263,184 8,808,675 8,984,849 9,164,546 9,347,837 9,534,794 9,725,490 9,920,000 0 0 0 0 0 0 0 8,808,675 8,984,849 9,164,546 9,347,837 9,534,794 9,725,490 9,920,000 30.490%30.809%31.048%31.995%33.390%33.338%32.895% 1.68%1.04%0.78%3.05%4.36%-0.16%-1.33% 1,292 1,332 1,369 1,438 1,531 1,560 1,570 46$ 40$ 37$ 70$ 93$ 28$ 10$ 3.71%3.07%2.78%5.11%6.45%1.85%0.65% 2.0%2.0%2.0%2.0%2.0%2.0%2.0% 2%2%2%2%2%2%2% Grand 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total Local Road Improvement - - - - 675,000 1,100,000 900,000 700,000 800,000 - 4,175,000 Park Capital - - - - - - - - - - Capital Improvement - - - 1,100,000 - - - 750,000 - - 1,850,000 Big Marine Sewer - - 300,000 675,000 - - 1,000,000 - - - 1,975,000 Equipment Replacement - - 815,000 - - - - - 300,000 - 815,000 Total - - 1,115,000 1,775,000 675,000 1,100,000 1,900,000 1,450,000 1,100,000 - 8,815,000 Gand 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Total Local Road Improvement 915,000 624,000 938,829 736,786 1,055,212 1,332,235 1,098,297 1,039,586 1,081,170 - 8,821,115 Park Capital 40,585 60,408 62,192 89,989 93,589 73,000 63,266 65,797 68,428 71,166 Capital Improvement 600,000 643,760 629,491 560,182 251,520 0 45,551 805,350 102,643 106,748 3,535,855 Big Marine Sewer 0 0 300,000 675,000 0 0 1,000,000 0 0 0 1,975,000 Equipment Replacement 52,500 302,640 574,330 67,492 0 0 0 0 273,714 0 996,961 Total 1,608,085 1,630,808 2,504,842 2,129,449 1,400,321 1,405,234 2,207,114 1,910,733 1,525,954 177,914 16,500,455 Bonding Summary Capital Outlay Summary CITY OF SCANDIA Financial Management Plan Capital Improvement Fund 401 4 CIP Inflation Factor 0.00%0.00%4.00% 2017 2018 2019 2020 2021 2022 Actual Projected Projected REVENUE 5 R 401-31000Property taxes 30,000 100,000 250,000 6 R 401-33422Intergovernmental 33,054 74,873 240,625 7 R 401-31000Capital Improvement Debt Levy 8 R 401-31951Special assessments 146 0 0 9 R 401-36210Investment Income 2,412 4,837 12,751 11,020 500 10 R 401-36250Refunds and Reimbursements 7,557 11 R Park Dedication Fees 12 R Rental and lease income 0 0 0 13 R Miscellaneous Revenue 7,492 21,500 0 14 Total Revenue 32,412 45,383 109,270 11,020 100,500 498,182 EXPENSES 15 Total Current 0 5,000 16 Debt service 0 0 17 Total Capital Projects 13,642 124,691 169,914 276,415 600,000 643,760 18 Total Expenses 13,642 124,691 174,914 276,415 600,000 643,760 19 Revenue Over / (Under) Expenses 18,770 (79,308)(65,644)(265,395)(499,500)(145,578) OTHER FINANCING SOURCES / (USES) 20 R 401-39310Bond Proceeds 0 21 R 401-39200Transfers In from General Fund 403,500 550,602 200,000 0 22 E 401-48000-720Transfers Out to Sewer Fund (100,000)(17,700) 23 E 401-48000-720Transfers Out- 24 Total Other Sources / (Uses)0 303,500 550,602 (17,700)200,000 0 25 Prior Period Adjustments 26 Ending Fund Balance 377,214 601,407 1,086,364 803,269 503,769 358,191CASH FLOW ANALYSIS 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2023 2024 2025 2026 2027 2028 2029 2030 2031 200,000 150,000 85,000 85,000 50,000 50,000 50,000 50,000 50,000 240,625 0 0 0 0 0 0 96,750 96,750 96,750 96,750 162,717 162,717 162,717 0 0 0 0 0 0 0 0 0 5,373 2,620 13,007 10,773 12,279 12,599 12,777 12,295 11,745 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 445,998 152,620 194,757 192,523 159,029 159,349 225,494 225,012 224,462 0 0 0 0 0 0 0 0 0 0 0 92,143 92,143 92,143 92,143 154,968 154,968 154,968 629,491 560,182 251,520 0 45,551 805,350 102,643 106,748 111,018 629,491 560,182 343,663 92,143 137,695 897,493 257,611 261,716 265,986 (183,493)(407,562)(148,905)100,380 21,335 (738,144)(32,118)(36,705)(41,525) 1,100,000 750,000 0 0 0 0 0 0 0 0 0 0 1,100,000 0 0 0 750,000 0 0 0 174,698 867,136 718,230 818,610 839,945 851,801 819,683 782,979 741,454 CITY OF SCANDIA Financial Management Plan Capital Improvement Fund 401 4 CIP Inflation Factor 0.00%0.00%4.00%CASH FLOW ANALYSISMultiple 2021 2019 2020 2021 2022 Capital Project Name Year?First Year Last Year Costs Projected Proposed 28 E 401-41000-530Broadband Expansion 2021 250,000 - 250,000 - 29 E 401-41000-530Broadband Expansion 2022 307,000 - - 319,280 30 E 401-41000-530Broadband Expansion 2023 307,000 - - - 31 E 401-41000-530Broadband Expansion 2024 250,000 - - - 32 E 401-45180-520Community Center HVAC Replacement 2022 30,000 - - 31,200 33 E 401-45180-520Community Center Front Door 2023 20,000 - - - 34 E 401-45180-520Community Center Upgrade 2021 15,000 - 15,000 - 35 E 401-45180-520Community Center Upgrade 2028 600,000 - - - 36 E 401-45180-520Annex Roof Replacement 2021 18,000 - 18,000 - 37 E 401-42200-530 Jaws of Life 2028 12,000 - - - 38 E 401-41000-520Financial Mgmt Plan/Develop Code Update 2021 45,000 - 45,000 - 39 E 401-42200-520 Back-up Generator for Fire Hall 2021 20,000 - 20,000 - 40 E 401-42200-520 2nd Fire Station 2025 180,000 - - - 41 E 401-42200-520 FD/PW Bldg Roof Replacement 2021 119,000 - 119,000 - 42 E 401-42200-520 Exhaust removal system 2024 48,000 - - - 43 E 401-42200-530Fire Department Radio Replacement 2021 117,000 - 117,000 - 44 E 401-42200-530 Warning Sirens 2024 20,000 - - - 45 E 401-42200-530 Thermo Cameras 2027 8,000 - - - 46 E 401-42200-530 UTV/Trailer 2027 28,000 - - - 47 E 401-41000-520 Arts & Heritage Center Amphitheater 2023 30,000 - - - 48 E 401-43000-520Cold Storage Building 2024 80,000 - - - 49 E 401-43000-530 Radio Replacement 2021 10,000 - 10,000 - 50 E 401-48000-435Bliss Additions Stormwater plan 2022 225,000 - - 234,000 51 E 401-48000-435Bliss Additions Stormwater plan 2023 225,000 - - - 52 E 401-48000-435Bliss Additions Stormwater plan 2024 100,000 - - - 53 E 401-48000-435Bliss Additions Stormwater plan 2025 35,000 - - - 54 E Layton Avenue N Segment Repair 47,000 - - - 55 E 401-45180-530Community Center Land Survey 2021 6,000 - 6,000 - 56 E 401-45180-530Community Center Playground Contribution 2022 57,000 - - 59,280 58 E 401-48000-435CIP placeholder Yes 2029 2031 75,000 - - - 90 Total Capital Projects 3,284,000 - - - - 600,000 643,760 PROJECTED NEW DEBT TERMS 91 Par Amount (Line 14)- - - - - - 92 Number of Years 15 15 15 15 93 Interest Rate 2.50%3.00%3.00%2.00% 94 New Debt Levy 0 0 0 0 0 0 Project Capital Project Outlay Option III 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2023 2024 2025 2026 2027 2028 2029 2030 2031 - - - - - - - - - - - - - - - - - - 332,051 - - - - - - - - - 281,216 - - - - - - - - - - - - - - - - 21,632 - - - - - - - - - - - - - - - - - - - - - - 789,559 - - - - - - - - - - - - - - - - - 15,791 - - - - - - - - - - - - - - - - - - - - - - - 210,575 - - - - - - - - - - - - - - - - 53,993 - - - - - - - - - - - - - - - - - 22,497 - - - - - - - - - - - 10,123 - - - - - - - - 35,429 - - - - 32,448 - - - - - - - - - 89,989 - - - - - - - - - - - - - - - - - - - - - - - - - 243,360 - - - - - - - - - 112,486 - - - - - - - - - 40,945 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 102,643 106,748 111,018 629,491 560,182 251,520 - 45,551 805,350 102,643 106,748 111,018 Per MA:JA As of Date:4/8/2021 - 1,100,000 - - - 750,000 - - - 15 15 15 15 15 15 15 15 15 2.50%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 0 0 96,750 96,750 96,750 96,750 162,717 162,717 162,717 CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund 404 4 CIP Inflation Factor 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Actual Budget Projected REVENUE 5 R 404-31000Property taxes 28,137 10,000 20,000 40,000 60,000 70,000 70,000 70,000 70,000 70,000 70,000 70,000 6 R 404-33422Intergovernmental 9,380 10,585 7 R 404-34730Charges for services 1,600 7,600 7,600 7,600 7,600 7,600 7,600 7,600 7,600 7,600 7,600 8 R 404-36210Investment Income 1,614 9 R 404-39101Sale of capital assets 1,890 1,471 1,319 1,048 869 996 1,271 1,512 1,717 1,885 10 R 404-34780Park Dedication Fees 6,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 11 R Rental and lease income 0 0 0 0 0 0 0 0 0 0 0 0 12 R Miscellaneous Revenue 802 0 0 0 0 0 0 0 0 0 0 13 Total Revenue 39,933 28,185 32,490 52,071 71,919 81,648 81,469 81,596 81,871 82,112 82,317 82,485 EXPENSES 14 Total Current 8,663 0 0 0 0 0 0 0 0 0 15 Debt service 0 0 0 0 0 0 0 0 0 0 0 0 16 Total Capital Projects 26,080 40,585 60,408 62,192 89,989 93,589 73,000 63,266 65,797 68,428 71,166 74,012 17 Total Expenses 34,743 40,585 60,408 62,192 89,989 93,589 73,000 63,266 65,797 68,428 71,166 74,012 18 Revenue Over / (Under) Expenses 5,190 (12,400)(27,918)(10,121)(18,070)(11,941)8,469 18,330 16,074 13,684 11,151 8,473 OTHER FINANCING SOURCES / (USES) 19 R Bond Proceeds 20 R 404-39203Transfers In 0 21 E 404-48000-720Transfers Out (1,440) 22 E 404-48000-720Transfers Out- 23 Total Other Sources / (Uses)0 (1,440)0 0 0 0 0 0 0 0 0 0 24 Prior Period Adjustments 25 Ending Fund Balance 139,825 125,985 98,067 87,946 69,876 57,935 66,405 84,735 100,809 114,493 125,644 134,117 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Project Name 26 27 E 404-48000-530Playground Equipment - Community Center Park - - - 62,192 - - - - - - - - 28 E 404-48000-530 Pleasure Rink Expansion - - - - 11,249 - - - - - - - 29 E 404-48000-520 Replacement of the boards at the the rink - - - - 56,243 - - - - - - - 30 E 404-48000-520 Lilleskogen Park Picnic Shelter - - 10,400 - - - - - - - - - 31 E 404-48000-530 Playground Equipment - Erickson ballfield - - 39,000 - - - - - - - - - 32 E 404-48000-530 Cycling & Trails - - - - - 35,096 - - - - - - 33 E 404-48000-530 Nature park trails - 10,000 - - - - - - - - - - 34 E 404-48000-530 Settlers Monument Improvements - 5,000 - - - - - - - - - - 35 E 404-48000-530 Lilleskogen Praire/Wetland Restoration Project - - 11,008 - - - - - - - - - 36 E 404-48000-530Lilleskogen Park Park Signage - 10,000 - - - - - - - - - - 37 E 404-48000-530 Lilleskogen Praire/Wetland Restoration Project - 10,585 - - - - - - - - - - 38 E 404-48000-530 Lilleskogen Praire/Wetland Restoration Project - - - - - - 12,167 - - - - - 38 E 404-48000-530 Park Planning - 5,000 - - - - - - - - - - 39 E 404-48000-530 Replacement ballfield for South Field - - - - 22,497 - - - - - - - 40 E 404-48000-530 CIP placeholder - - - - - 58,493 60,833 63,266 65,797 68,428 71,166 74,012 74 75 Total Capital Projects - 40,585 60,408 62,192 89,989 93,589 73,000 63,266 65,797 68,428 71,166 74,012 PROJECTED NEW DEBT TERMS Per MA:As of Date: 76 Par Amount (Line 14)- - - - - - - - - - - - 77 Number of Years 10 10 10 10 10 10 10 10 10 10 10 10 78 Interest Rate 3.00%3.00%2.00%2.50%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 79 New Debt Levy 0 0 0 0 0 0 0 0 0 0 0 0CASH FLOW ANALYSISCAPITAL OUTLAY - Option III CITY OF SCANDIA Financial Management Plan Equipment Replacement Fund 406 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Actual Budget Projected REVENUE 5 Property taxes 30,000 130,000 30,000 50,000 75,000 115,000 100,000 100,000 100,000 75,000 75,000 75,000 6 Intergovernmental 0 0 0 0 0 0 0 0 0 0 7 Sale of capital assets 10,000 7,000 50,000 35,000 0 0 0 0 0 0 0 8 Investment Income 2,000 1,000 1,015 1,030 1,045 1,061 1,077 1,093 1,109 1,126 1,143 1,160 9 Refunds and Reimbursements 10 Park Dedication Fees 11 Rental and lease income 0 0 0 0 0 0 0 0 0 0 0 0 12 Miscellaneous Revenue 0 0 0 0 0 0 0 0 0 0 13 Total Revenue 42,000 138,000 81,015 86,030 76,045 116,061 101,077 101,093 101,109 76,126 76,143 76,160 EXPENSES 14 Total Current 0 0 0 0 0 0 0 0 0 15 Debt service 0 0 0 0 90,731 90,731 90,731 90,731 90,731 90,731 125,009 125,009 16 Total Capital Projects 93,498 52,500 302,640 574,330 67,492 0 0 0 0 273,714 0 0 17 Total Expenses 93,498 52,500 302,640 574,330 158,223 90,731 90,731 90,731 90,731 364,445 125,009 125,009 18 Revenue Over / (Under) Expenses (51,498)85,500 (221,625)(488,300)(82,178)25,330 10,346 10,362 10,378 (288,319)(48,866)(48,849) OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 815,000 300,000 20 Transfers In 0 21 Transfers Out 22 Transfers Out- 23 Total Other Sources / (Uses)0 0 0 815,000 0 0 0 0 0 300,000 0 0 24 Prior Period Adjustments 25 Ending Fund Balance 182,688 268,188 46,563 373,263 291,085 316,415 326,761 337,123 347,501 359,182 310,316 261,468 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Project Name 26 27 Tanker 5178 Replacement - - - 270,400 - - - - - - - - 28 Grass Rig 5175 Replacement - - 62,400 - - - - - - - - - 29 Fire Boat - - 26,000 - - - - - - - - - 30 Bolins Lawnmower - 9,000 - - - - - - - - - - 31 Kubota F3990 Tractor Mower w/Broom & Blower (303-09)- - - - 50,619 - - - - - - - 32 Western Star Dump Truck/ Plow (Replace 201-17)- - - - - - - - - 273,714 - - 33 Tiger Ditch Rear Mower Replacement - - 16,640 - - - - - - - - - 34 Tiger Boom Mower Attachment Replacement - - 17,680 - - - - - - - - - 35 1999 JD-6410 Tractor Replacement (302-99)- - 138,320 - - - - - - - - - 36 Asphalt Patching Equipment Trailer (312)- - - - 16,873 - - - - - - - 37 Skid Loader and Trailer - - 41,600 - - - - - - - - - 38 2011 Mack Dump Truck/Plow Replacement (203-11)- - - 243,360 - - - - - - - - 39 Pickup w/Plow Replacement 2011 Ford F250 (103-11)- 43,500 - - - - - - - - - - 40 One-Ton F-550 Work Truck - - - 60,570 - - - - - - - - 41 - - - - - - - - - - - - 42 43 44 Total Capital Projects - 52,500 302,640 574,330 67,492 - - - - 273,714 - - CASH FLOW ANALYSISCapital Equipment Outlay - Option III CITY OF SCANDIA Financial Management Plan Local Road Improvement Fund 408 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Actual Budget Projected REVENUE 5 R 408-31000Property taxes 560,533 725,050 352,326 357,831 438,539 350,000 350,000 400,000 300,000 200,000 200,000 200,000 200,000 200,000 200,000 6 R 408-31000Debt levy 0 0 0 59,370 156,120 235,279 296,848 395,321 395,321 395,321 7 R 408-36100Special assessments 693 8 R 408-36210Investment Income 6,718 12,708 23,740 16,749 17,955 14,114 5,493 524 219 1,232 2,575 1,612 2,108 5,422 9 R 408-36250Refunds and Reimbursements 10 R Park Dedication Fees 11 R Rental and lease income 0 0 0 0 0 0 0 0 0 0 0 0 12 R Miscellaneous Revenue 0 0 0 0 0 0 0 0 0 0 13 Total Revenue 567,251 737,758 376,759 374,580 438,539 367,955 364,114 405,493 359,893 356,339 436,512 499,423 596,933 597,429 600,743 EXPENSES 14 Total Current 0 0 0 0 0 0 0 0 0 15 Debt service 0 0 0 0 0 0 56,542 148,686 224,076 282,712 376,497 376,497 16 Principal 17 Interest 77,339 18 Total Capital Projects 88,753 4,672,273 87,818 426,230 915,000 624,000 938,829 736,786 1,055,212 1,332,235 1,098,297 1,039,586 1,081,170 0 0 19 Total Expenses 88,753 4,749,612 87,818 426,230 915,000 624,000 938,829 736,786 1,055,212 1,388,777 1,246,983 1,263,662 1,363,882 376,497 376,497 20 Revenue Over / (Under) Expenses 478,498 (4,011,854)288,941 (51,650)(476,461)(256,045)(574,715)(331,293)(695,319)(1,032,438)(810,471)(764,239)(766,949)220,932 224,246 OTHER FINANCING SOURCES / (USES) 21 R Bond Proceeds 3,835,000 675,000 1,100,000 900,000 700,000 800,000 22 E 408-39310Bond premium 59,645 23 R 408-39203Transfers In 602,518 18,314 80,000 0 0 0 0 0 0 0 0 0 0 24 E 408-43100-720Transfers Out 25 E Transfers Out- 26 Total Other Sources / (Uses)602,518 3,912,959 0 0 80,000 0 0 0 675,000 1,100,000 900,000 700,000 800,000 0 0 27 Prior Period Adjustments 28 Ending Fund Balance 1,455,036 1,356,141 1,645,082 1,593,433 1,196,972 940,926 366,211 34,919 14,599 82,161 171,690 107,452 140,503 361,436 585,682CASH FLOW ANALYSIS Project Multiple 2021 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Capital Project Name Number Year?First Year Last Year Costs Projected 29 30 E 408-43100-530 2021 Local Road Improvement Project 2021 70,000 - 70,000 - - - - - - - - - - 31 E 408-43100-530 2021 Local Road Improvement Project 2021 845,000 - 845,000 - - - - - - - - - - 32 E 408-43100-530 2022 Local Road Improvement Project 2022 600,000 - - 624,000 - - - - - - - - - 33 E 408-43100-530 2023 Seal Coating Project 2023 183,000 - - - 197,933 - - - - - - - - 34 E 408-43100-530 Seal boring 2023 20,000 - - - 21,632 - - - - - - - - 35 E 408-43100-530 2023 Local Road Improvement Project 2023 665,000 - - - 719,264 - - - - - - - - 36 E 408-43100-530 2024 Local Road Improvement Project 2024 655,000 - - - - 736,786 - - - - - - - 37 E 408-43100-530 2025 Seal Coating Project 2025 252,000 - - - - - 294,804 - - - - - - 38 E 408-43100-530 2025 Local Road Improvement Project 2025 630,000 - - - - - 737,011 - - - - - - 39 E 408-43100-530 Seal boring 2025 20,000 - - - - - 23,397 - - - - - - 40 E 408-43100-530 2026 Seal Coating Project 2026 335,000 - - - - - - 407,579 - - - - - 41 E 408-43100-530 2026 street reconstruction 2026 760,000 - - - - - - 924,656 - - - - - 42 E 408-43100-530 2027 street reconstruction 2027 770,000 - - - - - - - 974,296 - - - - 43 E 408-43100-530 2027 seal coating and boring 2027 98,000 - - - - - - - 124,001 - - - - 44 E 408-43100-530 2028 street reconstruction 2028 790,000 - - - - - - - - 1,039,586 - - - 45 E 408-43100-530 2029 street reconstruction 2029 770,000 - - - - - - - - - 1,053,798 - - 46 E 408-43100-530 2029 seal coating and boring 2029 20,000 - - - - - - - - - 27,371 - - 47 - - - - - - - - - - - - 48 49 Total Capital Projects 7,483,000 - - - - 915,000 624,000 938,829 736,786 1,055,212 1,332,235 1,098,297 1,039,586 1,081,170 - - Project Local Road Project Outlay - Option III CITY OF SCANDIA Financial Management Plan - No State Bond Funding ScenarioBig Marine Lake Sewer Fund 602No State Bonding Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%Inflation on rates 15.00%15.50%25.00%25.00%10.00%10.00%10.00%27.00%27.00%27.00%2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%1.50%3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%4 CIP Inflation Factor 4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Actual Budget Proposed REVENUE 56 R 602-31951Charges for services $83,174.64 88,045 101,252 116,946 146,182 182,728 201,001 221,101 243,211 308,878 392,274 498,1897R602-36100Special assessments $6,844 200 0 0 0 0 0 0 08R602-33422Intergovernmental $47,202 0 0 0 0 0 0 0 0 0 09R602-36210Interest $903 700 1,823 8,341 2,567 1,799 1,589 499 (7,033)(9,546)(17,399)(20,365) 10 R 602-39200American Rescue Plan 441,89211R602-33422State bonding 01213Total Revenue 138,124 88,945 544,966 125,287 148,749 184,526 202,590 221,599 236,178 299,332 374,876 477,823 EXPENSES14Wages 19,886 23,000 27,500 28,050 28,611 29,183 29,767 30,362 30,969 31,588 32,220 32,86415Materials9493,700 3,700 3,774 3,849 3,926 4,005 4,085 4,167 4,250 4,335 4,42216Professional services 8,000 10,200 12,600 12,852 13,109 13,371 13,638 13,911 14,189 14,473 14,762 15,05717Repair and maintenance 31,200 716 21,350 21,777 22,213 22,657 23,110 23,572 24,043 24,524 25,014 25,514 18 Other 11,260 40,736 36,700 37,434 38,183 38,947 39,726 40,521 41,331 42,158 43,001 43,86119Depreciation49,700 42,643 52,200 53,244 54,309 55,395 56,503 57,633 58,786 59,962 61,161 62,3842021 Debt service 0 0 0 0 80,766 80,766 80,766 80,766 80,766 80,766 80,766 80,76622 23 Total Expenses 120,995 120,995 154,050 157,131 241,040 244,245 247,515 250,850 254,251 257,721 261,259 264,868 24 Revenue Over / (Under) Expenses 17,129 (32,050)390,916 (31,844)(92,292)(59,719)(44,926)(29,251)(18,073)41,610 113,617 212,955 OTHER FINANCING SOURCES / (USES) 25 R 602-39310Bond Proceeds 1,000,00026R602-39200Transfers In 0 0 0 0 0 0 0 0 0 0 027Purchase of capital assets (9,000)(38,000)(8,580)(1,406,351)(13,217)(9,652)(84,254)(530,484)(208,247)(625,093)(372,552)(20,353)28 E 602-43210-530Transfers Out-29 Total Other Sources / (Uses)(9,000)(38,000)(8,580)(406,351)(13,217)(9,652)(84,254)(530,484)(208,247)(625,093)(372,552)(20,353) 30 Change in balance sheet 31 Ending Cash 148,931 121,524 556,060 171,109 119,910 105,934 33,257 (468,845)(636,380)(1,159,900)(1,357,675)(1,102,689) Target Cash 48,176 88,925 60,524 133,749 148,025 145,541 221,246 668,600 347,510 765,526 514,177 161,978 Over (Under) Target 100,755 32,599 495,537 37,360 (28,116)(39,607)(187,989)(1,137,446)(983,889)(1,925,426)(1,871,852)(1,264,667) 2021 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031Capital Project Name First Year Costs3233E602-43210-530A/E Drainfield 750,000 - - - - - - - - - - - - 34 E 602-43210-530A/E Drainfield-engineering 50,000 - - - - - - - - - - - - 35 E - - - - - - - - - - - - 36 E 602-43210-530Bliss nitrate treatment equipment 2023 940,000 - - - 1,016,704 - - - - - - - - 37 E 602-43210-530Test well 2022 50,000 - - - - - - - - - - - - 38 E 602-43210-530LS 1 Control Panel 2027 10,000 - - - - - - - 12,653 - - - - 39 E 602-43210-530LS 2 Control Panel 2026 10,000 - - - - - - 12,167 - - - - - 40 E 602-43210-530LS 2 Control Panel 2031 1,500 - - - - - - - - - - - 2,220 41 E 602-43210-530LS #1 (Layton Ave)2022 500 - - 520 - - - - - - - - - 42 E 602-43210-530LS #1 (Layton Ave)2023 500 - - - 541 - - - - - - - - 43 E 602-43210-530LS #1 (Layton Ave)2024 2,500 - - - - 2,812 - - - - - - - 44 E 602-43210-530LS #1 (Layton Ave)2025 500 - - - - - 585 - - - - - - 45 E 602-43210-530LS #1 (Layton Ave)2026 500 - - - - - - 608 - - - - - 46 E 602-43210-530LS #1 (Layton Ave)2027 350,000 - - - - - - - 442,862 - - - - 47 E 602-43210-530LS #1 (Layton Ave)2028 500 - - - - - - - - 658 - - - 48 E 602-43210-530LS #1 (Layton Ave)2029 500 - - - - - - - - - 684 - - 49 E 602-43210-530LS #1 (Layton Ave)2030 500 - - - - - - - - - - 712 - 50 E 602-43210-530LS #1 (Layton Ave)2031 500 - - - - - - - - - - - 740 51 E 602-43210-530LS #2 (189th - Main Station)2022 500 - - 520 - - - - - - - - - 52 E 602-43210-530LS #2 (189th - Main Station)2023 2,500 - - - 2,704 - - - - - - - - 53 E 602-43210-530LS #2 (189th - Main Station)2024 500 - - - - 562 - - - - - - - 54 E 602-43210-530LS #2 (189th - Main Station)2025 500 - - - - - 585 - - - - - - 55 E 602-43210-530LS #2 (189th - Main Station)2023 350,000 - - - 378,560 - - - - - - - - 56 E 602-43210-530LS #2 (189th - Main Station)2027 500 - - - - - - - 633 - - - - 57 E 602-43210-530LS #2 (189th - Main Station)2028 500 - - - - - - - - 658 - - - 58 E 602-43210-530LS #2 (189th - Main Station)2029 500 - - - - - - - - - 684 - - 59 E 602-43210-530LS #2 (189th - Main Station)2030 500 - - - - - - - - - - 712 - 60 E 602-43210-530LS #2 (189th - Main Station)2031 2,500 - - - - - - - - - - - 3,701 61 E 602-43210-530LS #3 (Dosage Tanks)2022 500 - - 520 - - - - - - - - - 62 E 602-43210-530LS #3 (Dosage Tanks)2023 500 - - - 541 - - - - - - - - 63 E 602-43210-530LS #3 (Dosage Tanks)2024 500 - - - - 562 - - - - - - - 64 E 602-43210-530LS #3 (Dosage Tanks)2025 500 - - - - - 585 - - - - - - 65 E 602-43210-530LS #3 (Dosage Tanks)2026 2,500 - - - - - - 3,042 - - - - - 66 E 602-43210-530LS #3 (Dosage Tanks)2027 500 - - - - - - - 633 - - - - 67 E 602-43210-530LS #3 (Dosage Tanks)2028 500 - - - - - - - - 658 - - - 68 E 602-43210-530LS #3 (Dosage Tanks)2029 500 - - - - - - - - - 684 - - 69 E 602-43210-530LS #3 (Dosage Tanks)2030 70,000 - - - - - - - - - - 99,632 - 70 E 602-43210-530LS #3 (Dosage Tanks)2031 2,500 - - - - - - - - - - - 3,701 71 E 602-43210-530LS #4 (Dosage Tanks)2022 500 - - 520 - - - - - - - - - 72 E 602-43210-530LS #4 (Dosage Tanks)2023 500 - - - 541 - - - - - - - - 73 E 602-43210-530LS #4 (Dosage Tanks)2024 500 - - - - 562 - - - - - - - 74 E 602-43210-530LS #4 (Dosage Tanks)2025 500 - - - - - 585 - - - - - - 75 E 602-43210-530LS #4 (Dosage Tanks)2026 500 - - - - - - 608 - - - - - 76 E 602-43210-530LS #4 (Dosage Tanks)2027 2,500 - - - - - - - 3,163 - - - - 77 E 602-43210-530LS #4 (Dosage Tanks)2028 500 - - - - - - - - 658 - - - 78 E 602-43210-530LS #4 (Dosage Tanks)2029 500 - - - - - - - - - 684 - - 79 E 602-43210-530LS #4 (Dosage Tanks)2031 500 - - - - - - - - - - - 740 80 E 602-43210-530LS #4 (Dosage Tanks)2030 70,000 - - - - - - - - - - 99,632 - 81 E 602-43210-530Repairs 2022 2,500 - - 2,600 2,704 2,812 2,925 3,042 3,163 3,290 3,421 3,558 3,701 82 E 602-43210-530Forcemain 2022 500 - - 520 541 562 585 - - - - - - 83 E 602-43210-530Forcemain 2026 50,000 - - - - - - 60,833 63,266 - - - - 84 E 602-43210-530Forcemain 2028 500 - - - - - - 658 684 - - 85 E 602-43210-530Forcemain 2030 50,000 - - - - - - - - 71,166 - 86 E 602-43210-530Forcemain 2028 5,000 - - - - - - - - 6,580 - - - 87 E 602-43210-530Forcemain 2031 500 - - - - - - - - - 740 88 E 602-43210-530Conneciton metering 2028 120,000 - - - - - - - - 157,912 - - - 89 E 602-43210-530Connection meter equipment 2028 25,000 - - - - - - - - 32,898 - - - 90 E 602-43210-530A/E control panel 2029 50,000 - - - - - - - - - 68,428 - - 91 E 602-43210-530A/E LS 2022 1,000 - - 1,040 1,082 - - - - - - - - 92 E 602-43210-530A/E LS 2024 2,500 - - - - 2,812 - - - - - - - 93 E 602-43210-530A/E LS 2025 1,000 - - - - - 1,170 1,217 1,265 1,316 - - - 94 E 602-43210-530A/E LS 2029 350,000 - - - - - - - - - 478,999 - - 95 E 602-43210-530A/E LS 2030 1,000 - - - - - - - - - - 1,423 1,480 96 E 602-43210-530A/E repairs 2022 1,750 - - 1,820 1,893 1,969 2,047 2,129 2,214 2,303 2,395 2,491 2,590 97 E 602-43210-530A/E forcemain 2022 500 - - 520 541 562 585 608 633 658 - - - 98 E 602-43210-530A/E forcemain 2029 50,000 - - - - - - - - - 68,428 - - 99 E 602-43210-530A/E forcemain 2030 500 - - - - - - - - - - 712 740 100 E 602-43210-530A/E connection metering and software 2030 65,000 - - - - - - - - - - 92,515 - 110 Total Capital Projects 3,458,750 - - 8,580 1,406,351 13,217 9,652 84,254 530,484 208,247 625,093 372,552 20,353 PROJECTED NEW DEBT TERMS Per MA:JA As of Date:4/12/2021 111 Par Amount (Line 14)- - - 1,000,000 - - - - - - - - 112 Number of Years 15 15 20 15 15 15 15 15 15 15 15 15 113 Interest Rate 3.00%3.00%3.00%2.50%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% ##New Debt Levy 0 0 0 0 84,805 84,805 84,805 84,805 84,805 84,805 84,805 84,805CASH FLOW ANALYSISProject Projected Projected Big Marine Sewer Capital Outlay - Option III CITY OF SCANDIA Financial Management Plan Big Marine Lake Sewer Fund 602 Inflation Assumptions 1 Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00%2.00% Inflation on rates 10.00%10.00%15.00%15.00%15.00% 2 Interest Earnings 1.50%1.50%1.50%1.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00%3.00%3.00%3.00%3.00% 4 CIP Inflation Factor 4.00%4.00%4.00%4.00%4.00% 2020 2021 2022 2023 2024 2025 2026 Actual Budget Proposed Projected REVENUE 5 6 Charges for services $83,174.64 88,045 96,850 106,534 122,515 140,892 162,026 7 Special assessments $6,844 200 0 0 8 Intergovernmental $47,202 0 0 0 0 0 9 Interest $903 700 1,823 8,274 5,146 15,035 14,396 10 American Rescue Plan 441,892 11 State bonding 0 508,352 243,331 12 13 Total Revenue 138,124 88,945 540,564 623,161 127,661 155,927 419,753 EXPENSES 14 Wages 19,886 23,000 27,500 28,050 28,611 29,183 29,767 15 Materials 949 3,700 3,700 3,774 3,849 3,926 4,005 16 Professional services 8,000 10,200 12,600 12,852 13,109 13,371 13,638 17 Repair and maintenance 31,200 716 21,350 21,777 22,213 22,657 23,110 18 Other 11,260 40,736 36,700 37,434 38,183 38,947 39,726 19 Depreciation 49,700 42,643 52,200 53,244 54,309 55,395 56,503 20 21 Debt service 0 0 0 0 24,230 80,772 80,772 22 23 Total Expenses 120,995 120,995 154,050 157,131 184,504 244,251 247,521 24 Revenue Over / (Under) Expenses 17,129 (32,050)386,514 466,030 (56,843)(88,324)172,231 OTHER FINANCING SOURCES / (USES) 25 Bond Proceeds 300,000 675,000 26 Transfers In 0 0 0 0 0 0 27 Purchase of capital assets (9,000)(38,000)(8,627)(1,027,791)(13,217)(9,652)(510,082) 28 Transfers Out- 29 Total Other Sources / (Uses)(9,000)(38,000)(8,627)(727,791)661,783 (9,652)(510,082) 30 Change in balance sheet 31 Ending Cash 148,931 121,524 551,611 343,094 1,002,343 959,762 678,414 Target Cash 48,176 88,925 60,570 77,212 (526,969)145,547 647,080 Over (Under) Target 100,755 32,599 491,041 265,881 1,529,312 814,215 31,334 2021 2020 2021 2022 2023 2024 2025 2026 Capital Project Name First Year Costs 32 33 A/E Drainfield 2026 300,000 - - - - - - - 34 A/E Drainfield-engineering 2022 50,000 - - - - - - - 35 - - - - - - - 36 Bliss nitrate treatment equipment 2023 940,000 - - - 1,016,704 - - - 37 Test well 2022 50,000 - - - - - - - 38 LS 1 Control Panel 2027 10,000 - - - - - - - 39 LS 2 Control Panel 2026 10,000 - - - - - - 12,167 CASH FLOW ANALYSISCAPITAL PROJECTS & DEBT LEVYProject 2.00%2.00%2.00%2.00%2.00% 20.00%25.00%25.00%25.00%25.00% 1.50%1.50%1.50%1.50%1.50% 3.00%3.00%3.00%3.00%3.00% 4.00%4.00%4.00%4.00%4.00% 2027 2028 2029 2030 2031 194,431 243,038 303,798 379,747 474,684 0 0 0 0 0 0 0 0 0 0 10,176 17,390 13,984 5,151 1,078 204,607 260,428 317,782 384,899 475,763 30,362 30,969 31,588 32,220 32,864 4,085 4,167 4,250 4,335 4,422 13,911 14,189 14,473 14,762 15,057 23,572 24,043 24,524 25,014 25,514 40,521 41,331 42,158 43,001 43,861 57,633 58,786 59,962 61,161 62,384 80,772 164,539 164,539 164,539 164,539 250,856 338,024 341,494 345,032 348,641 (46,249)(77,596)(23,712)39,867 127,122 1,000,000 0 0 0 0 0 (530,484)(208,247)(625,093)(372,552)(20,353) 469,516 (208,247)(625,093)(372,552)(20,353) 1,159,313 932,257 343,413 71,889 241,042 (247,627)431,282 849,298 597,950 245,751 1,406,940 500,974 (505,885)(526,061)(4,709) 2027 2028 2029 2030 2031 - - - - - - - - - - - - - - - - - - - - - - - - - 12,653 - - - - - - - - - 40 LS 2 Control Panel 2031 1,500 - - - - - - - 41 LS #1 (Layton Ave)2022 500 - - 520 - - - - 42 LS #1 (Layton Ave)2023 500 - - - 541 - - - 43 LS #1 (Layton Ave)2024 2,500 - - - - 2,812 - - 44 LS #1 (Layton Ave)2025 500 - - - - - 585 - 45 LS #1 (Layton Ave)2026 500 - - - - - - 608 46 LS #1 (Layton Ave)2027 350,000 - - - - - - - 47 LS #1 (Layton Ave)2028 500 - - - - - - - 48 LS #1 (Layton Ave)2029 500 - - - - - - - 49 LS #1 (Layton Ave)2030 500 - - - - - - - 50 LS #1 (Layton Ave)2031 500 - - - - - - - 51 LS #2 (189th - Main Station)2022 500 - - 520 - - - - 52 LS #2 (189th - Main Station)2023 2,500 - - - 2,704 - - - 53 LS #2 (189th - Main Station)2024 500 - - - - 562 - - 54 LS #2 (189th - Main Station)2025 500 - - - - - 585 - 55 LS #2 (189th - Main Station)2026 350,000 - - - - - - 425,829 56 LS #2 (189th - Main Station)2027 500 - - - - - - - 57 LS #2 (189th - Main Station)2028 500 - - - - - - - 58 LS #2 (189th - Main Station)2029 500 - - - - - - - 59 LS #2 (189th - Main Station)2030 500 - - - - - - - 60 LS #2 (189th - Main Station)2031 2,500 - - - - - - - 61 LS #3 (Dosage Tanks)2022 500 - - 520 - - - - 62 LS #3 (Dosage Tanks)2023 500 - - - 541 - - - 63 LS #3 (Dosage Tanks)2024 500 - - - - 562 - - 64 LS #3 (Dosage Tanks)2025 500 - - - - - 585 - 65 LS #3 (Dosage Tanks)2026 2,500 - - - - - - 3,042 66 LS #3 (Dosage Tanks)2027 500 - - - - - - - 67 LS #3 (Dosage Tanks)2028 500 - - - - - - - 68 LS #3 (Dosage Tanks)2029 500 - - - - - - - 69 LS #3 (Dosage Tanks)2030 70,000 - - - - - - - 70 LS #3 (Dosage Tanks)2031 2,500 - - - - - - - 71 LS #4 (Dosage Tanks)2022 545 - - 567 - - - - 72 LS #4 (Dosage Tanks)2023 500 - - - 541 - - - 73 LS #4 (Dosage Tanks)2024 500 - - - - 562 - - 74 LS #4 (Dosage Tanks)2025 500 - - - - - 585 - 75 LS #4 (Dosage Tanks)2026 500 - - - - - - 608 76 LS #4 (Dosage Tanks)2027 2,500 - - - - - - - 77 LS #4 (Dosage Tanks)2028 500 - - - - - - - 78 LS #4 (Dosage Tanks)2029 500 - - - - - - - 79 LS #4 (Dosage Tanks)2031 500 - - - - - - - 80 LS #4 (Dosage Tanks)2030 70,000 - - - - - - - 81 Repairs 2022 2,500 - - 2,600 2,704 2,812 2,925 3,042 82 Forcemain 2022 500 - - 520 541 562 585 - 83 Forcemain 2026 50,000 - - - - - - 60,833 84 Forcemain 2028 500 - - - - - - - 85 Forcemain 2030 50,000 - - - - - - - 86 Forcemain 2028 5,000 - - - - - - - 87 Forcemain 2031 500 - - - - - - - 88 Conneciton metering 2028 120,000 - - - - - - - 89 Connection meter equipment 2028 25,000 - - - - - - - 90 A/E control panel 2029 50,000 - - - - - - - 91 A/E LS 2022 1,000 - - 1,040 1,082 - - - 92 A/E LS 2024 2,500 - - - - 2,812 - - 93 A/E LS 2025 1,000 - - - - - 1,170 1,217 94 A/E LS 2029 350,000 - - - - - - - 95 A/E LS 2030 1,000 - - - - - - - 96 A/E repairs 2022 1,750 - - 1,820 1,893 1,969 2,047 2,129 97 A/E forcemain 2022 500 - - 520 541 562 585 608 98 A/E forcemain 2029 50,000 - - - - - - - 99 A/E forcemain 2030 500 - - - - - - - 100 A/E connection metering and software 2030 65,000 - - - - - - - 110 Total Capital Projects 3,008,795 - - 8,627 1,027,791 13,217 9,652 510,082 CAPITAL PROJECTS & DEBT LEVY - - - - 2,220 - - - - - - - - - - - - - - - - - - - - - - - - - 442,862 - - - - - 658 - - - - - 684 - - - - - 712 - - - - - 740 - - - - - - - - - - - - - - - - - - - - - - - - - 633 - - - - - 658 - - - - - 684 - - - - - 712 - - - - - 3,701 - - - - - - - - - - - - - - - - - - - - - - - - - 633 - - - - - 658 - - - - - 684 - - - - - 99,632 - - - - - 3,701 - - - - - - - - - - - - - - - - - - - - - - - - - 3,163 - - - - - 658 - - - - - 684 - - - - - - 740 - - - 99,632 - 3,163 3,290 3,421 3,558 3,701 - - - - - 63,266 - - - - - 658 684 - - - - - 71,166 - - 6,580 - - - - - - - 740 - 157,912 - - - - 32,898 - - - - - 68,428 - - - - - - - - - - - - 1,265 1,316 - - - - - 478,999 - - - - - 1,423 1,480 2,214 2,303 2,395 2,491 2,590 633 658 - - - - - 68,428 - - - - - 712 740 - - - 92,515 - 530,484 208,247 625,093 372,552 20,353 City of Scandia DRAFT: September 1, 2021 Financial Management Plan Draft Projected Sewer Rates (9/1/2021) 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 10.00%10.00%15.00%15.00%15.00%20.00%25.00%25.00%25.00%25.00% Base Charge Annual 854.40 939.84 1,033.82 1,188.90 1,367.23 1,572.32 1,886.78 2,358.48 2,948.09 3,685.12 4,606.40 Quarterly 213.70 234.96 258.46 297.22 341.81 393.08 471.70 589.62 737.02 921.28 1,151.60 Increase Annual 85.44 93.98 155.07 178.33 205.08 314.46 471.70 589.62 737.02 921.28 Quarterly 21.26 23.50 38.77 44.58 51.27 78.62 117.92 147.40 184.26 230.32 Energy Adj Charge Annual 8.00 8.80 9.68 11.13 12.80 14.72 17.67 22.08 27.60 34.50 43.13 Quarterly 2.00 2.20 2.42 2.78 3.20 3.68 4.42 5.52 6.90 8.63 10.78 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 15.00%15.50%25.00%25.00%10.00%10.00%10.00%27.00%27.00%27.00% Base Charge Annual 854.40 982.56 1,134.86 1,418.57 1,773.21 1,950.54 2,145.59 2,360.15 2,997.39 3,806.68 4,834.49 Quarterly 213.70 245.64 283.71 354.64 443.30 487.63 536.40 590.04 749.35 951.67 1,208.62 Increase Annual 128.16 152.30 283.71 354.64 177.32 195.05 214.56 637.24 809.29 1,027.80 Quarterly 31.94 38.07 70.93 88.66 44.33 48.76 53.64 159.31 202.32 256.95 Energy Adj Charge Annual 8.00 9.20 10.63 13.28 16.60 18.26 20.09 22.10 28.07 35.64 45.27 Quarterly 2.00 2.30 2.66 3.32 4.15 4.57 5.02 5.52 7.02 8.91 11.32 Additional impact on users if no state bonding received 229.67 405.98 378.22 258.81 1.67 49.29 121.56 228.09 2021 2022 2023 2024 2025 2026 5.00%5.00%10.00%10.00%10.00% Base Charge Annual 349.99 367.49 385.86 424.45 466.90 513.58 Quarterly 87.50 91.88 96.47 106.12 116.73 128.40 Increase Annual 17.50 18.37 38.59 42.45 46.69 Quarterly 4.38 4.59 9.65 10.61 11.67 Volume Charge Annual 47.43 49.80 52.29 57.52 63.27 69.60 Uptown Sewer System Big Marine Sewer -State Bonding Received Big Marine Sewer No State Bonding CITY OF SCANDIA Financial Management Plan Uptown Sewer Fund 612 Inflation on rates 5.00% 2020 2021 2022 Budget Budget REVENUE 5 6 Charges for services 21,800 23,000 24,150 7 Special assessments 8 Intergovernmental 0 9 Interest 357 10 American Rescue Plan 11 0 0 0 12 0 13 Total Revenue 21,800 23,000 24,507 14 15 EXPENSES 16 Wages 8,850 10,000 10,700 17 Materials 375 300 500 18 Professional services 350 700 700 19 Repair and maintenance 3,300 3,500 3,300 20 Other 3,496 3,030 6,550 21 Depreciation 4,877 4,877 5,100 22 23 Debt service 0 0 0 24 25 Total Expenses 21,248 22,407 26,850 26 27 Revenue Over / (Under) Expenses 552 593 (2,343) 28 29 OTHER FINANCING SOURCES / (USES) 30 Bond Proceeds 31 Transfers In 0 0 32 Purchase of capital assets (1,200)(5,200)(2,600) 33 Advance to other fund 34 Transfers Out- 35 Total Other Sources / (Uses)(1,200)(5,200)(2,600) 36 Change in balance sheet 37 Ending Cash 23,561 23,831 23,988 2021 2020 2021 2022 Capital Project Name First Year Costs 38 39 LS 2022 1,000.00 - - 1,040 40 LS 2023 1,000.00 - - - 41 LS 2024 2,500.00 - - - 42 LS 2025 1,000.00 - - - 43 LS 2026 1,000.00 - - - 44 LS 2027 30,000.00 - - - 45 LS 2028 1,000.00 - - - 46 LS 2029 1,000.00 - - - 47 LS 2030 1,000.00 - - - 48 LS 2031 1,000.00 - - - 49 Control panel 2031 50,000.00 - - - 50 Drainfield LS 2022 500.00 - - 520 51 Drainfield LS 2023 2,500.00 - - - 52 Drainfield LS 2024 500.00 - - - 53 Drainfield LS 2025 500.00 - - - 54 Drainfield LS 2026 500.00 - - - 55 Drainfield LS 2027 500.00 - - - 56 Drainfield LS 2028 2,500.00 - - - 57 Drainfield LS 2029 500.00 - - - 58 Drainfield LS 2030 500.00 - - - 59 Drainfield LS 2031 500.00 - - - CASH FLOW ANALYSISProjected CAPITAL PROJECTS & DEBT LEVYProject 60 Blower replacement 2025 4,000.00 - - - 61 Blower replacement 2031 4,000.00 - - - 62 Pumping 2022 1,000.00 - - 1,040 63 Pumping 2023 1,000.00 - - - 64 Pumping 2024 1,000.00 - - - 65 Pumping 2025 1,000.00 - - - 66 Pumping 2026 1,000.00 - - - 67 Pumping 2027 1,000.00 - - - 68 Pumping 2028 1,000.00 - - - 69 Pumping 2029 1,000.00 - - - 70 Pumping 2030 1,000.00 - - - 71 Pumping 2031 1,000.00 - - - 72 Repairs 2031 50,000 - - - 73 Forcemain - - - 83 Drainfield Expansion 2023 500,000 - - - 84 Total Capital Projects 667,500 - - 2,600 CAPITAL PROJECTS & DEBT LEVY 5.00%10.00%10.00%10.00%10.00%15.00%15.00%15.00%25.00% 2023 2024 2025 2026 2027 2028 2029 2030 2031 25,358 27,893 30,683 33,751 37,126 42,695 49,099 56,464 70,580 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 360 6,343 5,592 4,819 4,142 2,946 2,318 1,806 1,387 441,000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 466,717 34,236 36,275 38,570 41,268 45,641 51,417 58,270 71,967 10,914 11,132 11,355 11,582 11,814 12,050 12,291 12,537 12,788 510 520 530 541 552 563 574 585 597 714 728 743 758 773 788 804 820 836 3,366 3,433 3,502 3,572 3,643 3,716 3,790 3,866 3,943 6,681 6,815 6,951 7,090 7,232 7,377 7,525 7,676 7,830 5,202 5,306 5,412 5,520 5,630 5,743 5,858 5,975 6,095 0 57,129 57,129 57,129 57,129 57,129 57,129 57,129 57,129 27,387 85,063 85,622 86,192 86,773 87,366 87,971 88,588 89,218 439,330 (50,827)(49,347)(47,622)(45,505)(41,725)(36,555)(30,319)(17,251) 500,000 175,000 0 0 0 0 0 0 0 0 0 (545,667)(4,499)(7,604)(3,042)(39,858)(5,922)(3,421)(3,558)(157,646) (45,667)(4,499)(7,604)(3,042)(39,858)(5,922)(3,421)(3,558)17,354 422,854 372,833 321,293 276,150 196,417 154,513 120,395 92,493 98,691 2023 2024 2025 2026 2027 2028 2029 2030 2031 - - - - - - - - - 1,082 - - - - - - - - - 2,812 - - - - - - - - - 1,170 - - - - - - - - - 1,217 - - - - - - - - - 37,960 - - - - - - - - - 1,316 - - - - - - - - - 1,369 - - - - - - - - - 1,423 - - - - - - - - - 1,480 - - - - - - - - 74,012 - - - - - - - - - 2,704 - - - - - - - - - 562 - - - - - - - - - 585 - - - - - - - - - 608 - - - - - - - - - 633 - - - - - - - - - 3,290 - - - - - - - - - 684 - - - - - - - - - 712 - - - - - - - - - 740 Projected - - 4,679 - - - - - - - - - - - - - - 5,921 - - - - - - - - - 1,082 - - - - - - - - - 1,125 - - - - - - - - - 1,170 - - - - - - - - - 1,217 - - - - - - - - - 1,265 - - - - - - - - - 1,316 - - - - - - - - - 1,369 - - - - - - - - - 1,423 - - - - - - - - - 1,480 - - - - - - - - 74,012 - - - - - - - - - 540,800 - - - - - - - - 545,667 4,499 7,604 3,042 39,858 5,922 3,421 3,558 157,646