Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07. 2025 Draft Preliminary Budget
Staff Report Date of Meeting: August 7, 2024 For: Honorable Mayor and Council From: Kyle Morell, City Administrator Subject: 2025 Preliminary Budget Discussion Background: Staff is presenting the preliminary 2025 budget for the Council to review. The Capital Investment Committee met three times to review the CIP funds and discuss future projects. Their recommendations have been included in the CIP fund budgets. The General Fund budget was prepared using past revenue and expense practices and a six-month review of 2024 spending as guides for future revenue and expense projections. Staff prepared a 2025 Preliminary Budget presentation outlining the recommendations of the CIP Committee, detailed the 2025 revenues and expenses for each CIP fund, and outlined the assumptions made in assembling the preliminary budget. The individual CIP Fund documents and a Summary Budget document that shows the complete levy picture and the proposed 2024 tax rate are also included. Discussion: The CIP Fund documents have been updated to reflect the discussion of the CIP Committee. The 2025 Preliminary Budget, Budget Presentation, CIP Fund Documents, and Summary Budget are presented for Council review. Recommendation: No action is required from the Council at this time. The budget has been presented for review and comment. The 2025 Budget Calendar calls for a second review of the 2025 budget at the September Work Session unless the Council needs to meet before then to continue its budget discussion. At their regular meeting on September 19, 2024, the council will vote on a 2025 preliminary budget. Attachments: 2025 Preliminary Budget Presentation 2025 Preliminary Budget CIP Fund 401 CIP Fund 404 CIP Fund 406 CIP Fund 408 Summary Budget 2025 Preliminary Budget August 7, 2024 Discussion Items Capital Improvement Committee Recommendations. Review of CIP and budget impacts Brief Introduction to the proposed 2025 General Fund Budget Council is encouraged to ask questions, offer comments, and suggest changes at anytime Capital Investment Committee Recommendations Establish consistent annual levy-supported cash contributions to all Capital Improvement Funds Increase levy amount in 408 Road Improvement Fund by 10% from the proposed 2024 amount ($400,000 to $440,000) Utilize additional road rating technology to rate roads in 2025 Create a public input plan to engage the public in discussion about the appropriate amount of money for annual road maintenance Capital Investment Committee Recommendations cont. Consider a change to driveway culvert policy, returning ownership and maintenance to residents Consider adopting additional development fees, including seal coating and stormwater fees Issue equipment certificates for public works and fire department vehicle purchases 2025 Capital Improvement Fund – 401 General Fund Beginning Fund Balance includes a $150,000 transfer out to 404 Park CIP to support the Tennis County project in 2024 $85,000 tax levy to support recommended projects Six projects totaling $ 323,041 Fund Balance will be used to make up the shortage Ending Fund Balance of $449,826 $686,867 Beginning Fund Balance Revenue $85,000 Levy $1,000 Interest $86,000 Total Expenses $15,0002025 LCCMR – Gateway Trail $92,000Broadband $17,548 Fire Dept Radios $40,945Jaws of Life $17,548Lucas CPR Device $140,000Cold Storage Building $323,041 Total ($237,041)Revenue Over/(Under)Expenses $449,826 Ending Fund Balance 2025 Capital Improvement Fund – 404 Park Fund 2024 - Transfer of $125,000 in Unassigned Fund Balance and a Transfer from 401 of $150,000 will provide a one-time revenue increase for 2024/2025 projects $40,000 tax levy to support recommended projects One project totaling $ 300,000 Ending Fund Balance of $13,058 $272,993 Beginning Fund Balance Revenue $40,000 Levy $66 Interest $40,066Total Expenses $300,000Tennis Court Improvements $300,000Total ($259,934)Revenue Over/(Under)Expenses $13,058 Ending Fund Balance 2025 Capital Improvement Fund – 406 Equipment Fund $130,000 tax levy to support recommended projects One purchase of $286,787 Equipment Certificate issued for $200,000 New debt levy of approximately $23,446, starting in 2025 until 2035 Ending Fund Balance of $75,235 $26,272Beginning Fund Balance Revenue $130,000 Levy $1,061 Interest $131,061 Total Expenses $286,787 2003 Tanker 2 Replacement $286,787 Total ($57,252)Revenue Over/(Under)Expenses Other $200,000Bond Proceeds $75,235Ending Fund Balance 2025 Capital Improvement Fund – 408 Street Improvement Fund $440,000 tax levy to support recommended projects One street reconstruction project totaling $ 700,000 Ending Fund Balance of $383,307 $351,295 Beginning Fund Balance Revenue $440,000 Levy $12,295 Interest $380,447 Total Expenses $700,0002025 Local Road Improvement $700,000Total $31,742Revenue Over/(Under)Expenses $383,037 Ending Fund Balance 2025 Preliminary Budget - Revenues The General Fund levy is projected to be $1,893,907, a $27,989 increase over 2024, or a 1.5% increase. Licenses and Permits have been increased slightly to reflect fees collected from new cannabis registrations. Interest earning has been increased to reflect the increased rates available to the City’s money market account. Total General Fund Revenue is $2,383,667. This is a 2.47% increase over 2024. 2025 Preliminary Budget - Expenses All personnel wages have been increased by 3.5% in accordance with the negotiated union wage increase. Council wages have been increased, estimated to be at 3.5%. The actual increase is based on the 12-month CPI from November 2023 to November 2024 Budget includes a full-time treasurer. Fire Department wages have been increased to reflect actual wages paid Public Works include $200,000 for contractual road maintenance and repair. This is in addition to the CIP projects 2025 Preliminary Budget - Expenses The following percentage increases are assumptions. Actual numbers will not be available until later in the year. All Health and Dental Insurance line items have been increased by 10% Property and Workers Comp Insurance line items have been increased by 10%. Bolton & Menk services have been increased by 5% Policing services have been increased by 5.91% per 2025 Agreement Total expenses are $2,382,017. This is a 4.16% increase over 2024 General Fund Budget Summary Difference20252024 $57,554$2,383,677$2,326,123Total General Fund Revenue $95,196$2,382,017$2,286,822Total General Fund Expenses ($37,642)$1,659$39,301Revenues Over / (Under) Expenses (1.7%)57.3%59.0%Estimated Fund Balance* *Shows an estimated percentage of next year’s projected expenses Tax Levy Summary Difference20252024 $27,989$1,893,907$1,865,918General Fund Levy $455,894$801,527$345,634Debt Service Levy ($90,300)$695000$785,300CIP Funds Levy $0$0$5,300EDA Levy $393,582$3,390,434$2,996,852Total Levy ($13,435)($121,291)*($107,857)Less Fiscal Disparities $380,148$3,269,143$2,888,995Total Net Levy *3-year Average Tax Rate Summary Difference20252024 ($141,014)$10,706,234$10,847,248Estimated Tax Capacity $380,148$3,269,143$2,888,995Net Levy 3.902%30.535%26.663%Tax Rate Looking Forward Staff will continue to update projected numbers with actual numbers when they come in. Multiple budget documents can be prepared to show various scenarios if Council wishes to evaluate multiple levy and spending options. Next budget discussion is scheduled for the Council Work Session on September 4, 2024. Unless Council wishes to call a Special Meeting beforehand. 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 EXHIBIT A 80 Users BLISS SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal 2,887$ -$ -$ 2,652$ -$ 602-43210-31952 SA Penalties & Interest 624$ 579$ 403$ 420$ 102$ 400$ 602-43210-33422 Other State Grants & Aids 25$ 74$ 20$ -$ -$ -$ 602-43210-34401 Sewer User Fees 98,531$ 106,717$ 139,546$ 125,230$ 46,351$ 124,895$ 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 8,000$ -$ -$ -$ 602-43210-36100 Special Assessments -$ -$ 47$ -$ 602-43210-36102 Penalties & Interest 183$ -$ 72$ -$ 602-43210-36210 Interest Income 181$ 301$ 1,380$ 210$ -$ 200$ 602-43210-36250 Misc. Refund -$ -$ -$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ -$ Total Bliss Sewer Fund Revenues 107,361$ 118,557$ 149,532$ 125,860$ 49,224$ 125,495$ Expenditures BLISS SEWER FUND EXPENDITURES E 602-43210-101 Regular Wages & Salaries602-43210-101 Regular Wages & Salaries 11,014$ 21,714$ 20,576$ 17,458$ 10,886$ 18,119$ E 602-43210-120 Pension Expense602-43210-120 Pension Expense (1,438)$ (693)$ 7,430$ -$ -$ -$ E 602-43210-121 PERA Coord. Employer Contribu.602-43210-121 PERA Coord. Employer Contribu. 806$ 1,629$ 1,542$ 1,309$ 815$ 1,359$ E 602-43210-122 FICA Employer Contribution602-43210-122 FICA Employer Contribution 684$ 1,284$ 1,216$ 1,082$ 631$ 1,123$ E 602-43210-126 MEDICARE Employer Contribution602-43210-126 MEDICARE Employer Contribution 156$ 299$ 284$ 253$ 162$ 263$ E 602-43210-131 Employer Paid Health602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ E 602-43210-210 Operating Supplies602-43210-151 Worker s Comp Insurance Prem 422$ 1,215$ 736$ 525$ 783$ 800$ E 602-43210-240 Small Tools and Minor Equip602-43210-200 Office Supplies 109$ 128$ 48$ 91$ 102$ 200$ E 602-43210-303 Engineering Fees602-43210-210 Operating Supplies 558$ 680$ 1,823$ 700$ 19$ 1,000$ E 602-43210-304 Legal Services602-43210-240 Small Tools and Minor Equip -$ 217$ -$ 420$ -$ 500$ E 602-43210-308 Other Professional Services602-43210-303 Engineering Fees 13,277$ (1,538)$ 1,409$ 8,880$ 68,017$ 12,000$ E 602-43210-309 Software Support & Maintenance602-43210-304 Legal Services -$ 6,000$ 18$ -$ -$ E 602-43210-317 Employee Training602-43210-308 Other Professional Services 3,376$ 5,814$ 7,773$ 3,500$ 13,565$ 6,000$ E 602-43210-321 Telephone602-43210-309 Software Support & Maintenance 716$ 756$ 529$ 910$ -$ 1,200$ E 602-43210-322 Postage 602-43210-317 Employee Training 868$ 925$ 336$ 980$ 598$ 1,400$ E 602-43210-331 Travel Expenses602-43210-321 Telephone 2,413$ 1,751$ 2,656$ 1,750$ 1,194$ 1,750$ E 602-43210-334 Licenses & Permits602-43210-322 Postage -$ 200$ 200$ 420$ -$ 500$ E 602-43210-361 Liability/Property Ins602-43210-331 Travel Expenses 8$ 158$ 633$ 525$ 78$ 750$ Page 1 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 EXHIBIT A E 602-43210-381 Utilities-Electric & Gas602-43210-334 Licenses & Permits 1,180$ 824$ 729$ 1,400$ 505$ 1,500$ E 602-43210-385 Sewer Pumping & Maintenance602-43210-361 Liability/Property Ins 1,039$ 1,003$ 3,449$ 764$ 2,383$ -$ E 602-43210-386 Operation & Maintenance602-43210-381 Utilities-Electric & Gas 1,862$ 3,473$ 3,936$ 2,100$ 563$ 2,750$ E 602-43210-404 Repair Machinery/Equipment602-43210-385 Sewer Pumping & Maintenance 5,364$ 11,410$ 4,695$ 14,000$ 1,245$ 15,000$ E 602-43210-413 Equipment Rental602-43210-386 Operation & Maintenance 1,574$ 2,888$ 2,639$ 3,500$ -$ 3,500$ E 602-43210-420 Depreciation Expense602-43210-404 Repair Machinery/Equipment 4,375$ 5,857$ 12,101$ 11,200$ 795$ 12,000$ E 602-43210-438 Misc. Contractual602-43210-413 Equipment Rental -$ -$ -$ 700$ -$ 700$ E 602-43210-439 Refunds Issued602-43210-420 Depreciation Expense 48,667$ 50,174$ 50,428$ 40,600$ -$ 41,000$ E 602-43210-530 Capital Impr Other Than Bldgs602-43210-438 Misc. Contractual 3,775$ 2,550$ 2,660$ 7,000$ 765$ 7,000$ E 602-43210-720 Operating Transfers602-43210-439 Refunds Issued -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 3,278$ (8,448)$ 6,930$ -$ 7,000$ 602-43210-720 Operating Transfers 17,584$ -$ Total Bliss Sewer Fund Expenditures 100,803$ 121,995$ 119,398$ 126,997$ 120,692$ 137,414$ Page 2 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 EXHIBIT A 9 Users UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 1$ -$ -$ -$ 612-43210-34401 Sewer User Fees 15,132$ 17,442$ 22,166$ 22,400$ 4,868$ 23,213$ 612-43210-34402 Sewer Connection Fee -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 326$ 50$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ Total Uptown Sewer Fund Revenues 15,203$ 17,526$ 22,493$ 22,450$ 4,868$ 23,263$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 3,673$ 9,282$ 8,559$ 10,725$ 4,371$ 11,134$ 612-43210-120 Pension Expense (630)$ 1,164$ 3,619$ -$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 259$ 697$ 642$ 804$ 327$ 835$ 612-43210-122 FICA Employer Contribution 219$ 550$ 505$ 665$ 253$ 690$ 612-43210-126 MEDICARE Employer Contribution 50$ 126$ 118$ 156$ 65$ 161$ 612-43210-151 Worker s Comp Insurance Prem 218$ 304$ 316$ 300$ 522$ 550$ 612-43210-200 Office Supplies 4$ -$ -$ 100$ -$ 100$ 612-43210-210 Operating Supplies -$ 500$ 320$ 500$ -$ 500$ 612-43210-221 Equipment Parts -$ -$ -$ 500$ -$ 500$ 612-43210-303 Engineering Fees 7,272$ -$ -$ 630$ -$ 1,000$ 612-43210-308 Other Professional Services 192$ 884$ 733$ 750$ 310$ 900$ 612-43210-309 Software Support & Maintenance 80$ 84$ 84$ 84$ -$ 100$ 612-43210-317 Employee Training 275$ -$ -$ 200$ 1,138$ 200$ 612-43210-319 Other Services -$ -$ -$ 1,500$ -$ 1,500$ 612-43210-322 Postage 18$ -$ -$ -$ -$ 100$ 612-43210-334 Licenses & Permits 209$ 217$ 247$ 250$ 231$ 250$ 612-43210-361 Liability/Property Ins 283$ 334$ 478$ 351$ 464$ -$ 612-43210-381 Utilities-Electric & Gas 522$ 697$ 863$ 1,000$ 265$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance (260)$ 327$ 1,800$ 1,500$ -$ 1,500$ 612-43210-386 Operation & Maintenance -$ 462$ -$ 1,000$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment 767$ 465$ -$ 2,000$ -$ 2,000$ Page 3 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 EXHIBIT A 612-43210-420 Depreciation Expense 4,876$ 4,877$ 4,876$ 4,900$ -$ 5,000$ 612-43210-438 Misc. Contractual 100$ 548$ 140$ 1,500$ 449$ 1,500$ 612-43210-530 Capital Impr Other Than Bldgs 1,456$ -$ -$ 9,900$ 9,900$ 612-43210-570 Office Equipment -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ 2,640$ -$ Total Uptown Sewer Fund Expenditures 19,582$ 21,516$ 23,299$ 41,955$ 8,394$ 40,921$ Page 4 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 EXHIBIT A 33 Users ANDERSON-ERICKSON SEWER FUND REVENUES Revenues 624-43210-31951 Special Assessments Principal 2,887$ -$ -$ 624-43210-31952 SA Penalties & Interest 624$ 579$ 180$ 200$ 624-43210-33422 Other State Grants & Aids 25$ 74$ -$ -$ 624-43210-34401 Sewer User Fees 98,531$ 106,717$ 53,670$ 21,150$ 50,599$ 624-43210-34402 Sewer Connection Fee 8,000$ 8,000$ -$ -$ -$ 624-43210-36100 Special Assessments -$ -$ 624-43210-36102 Penalties & Interest -$ 30$ -$ 624-43210-36210 Interest Income 181$ 301$ 90$ 100$ 624-43210-36250 Misc. Refund -$ -$ 624-43210-39200 Interfund Tranfers In -$ 17,584$ -$ Total Anderson-Erickson Sewer Fund Revenues 107,361$ 118,557$ -$ 53,940$ 38,764$ 50,899$ Expenditures ANDERSON-ERICKSON SEWER FUND EXPENDITURES 624-43210-101 Regular Wages & Salaries -$ 7,482$ -$ 7,765$ 624-43210-121 PERA Coord. Employer Contribu. -$ 561$ -$ 582$ 624-43210-122 FICA Employer Contribution -$ 464$ -$ 481$ 624-43210-126 MEDICARE Employer Contribution -$ 108$ -$ 113$ 624-43210-151 Worker s Comp Insurance Prem -$ 225$ -$ -$ 624-43210-200 Office Supplies -$ 39$ -$ $200 624-43210-210 Operating Supplies -$ 300$ -$ $300 624-43210-240 Small Tools and Minor Equip -$ 180$ 44$ $200 624-43210-303 Engineering Fees 320$ -$ -$ $4,000 624-43210-304 Legal Services -$ -$ -$ $0 624-43210-308 Other Professional Services -$ 1,500$ -$ $1,500 624-43210-309 Software Support & Maintenance -$ 390$ 310$ $400 624-43210-317 Employee Training 227$ 420$ -$ $400 624-43210-321 Telephone -$ 750$ 109$ $750 624-43210-322 Postage 253$ 180$ 425$ $200 624-43210-331 Travel Expenses 80$ 225$ -$ $225 624-43210-334 Licenses & Permits -$ 600$ 78$ $750 Page 5 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 EXHIBIT A 624-43210-361 Liability/Property Ins -$ -$ 231$ $254 624-43210-381 Utilities-Electric & Gas -$ 900$ 985$ $1,000 624-43210-385 Sewer Pumping & Maintenance 43$ 6,000$ 283$ $6,000 624-43210-386 Operation & Maintenance -$ 1,500$ -$ $1,500 624-43210-404 Repair Machinery/Equipment -$ 4,800$ -$ $4,000 624-43210-413 Equipment Rental 408$ 300$ 230$ $300 624-43210-420 Depreciation Expense -$ 17,400$ -$ $5,000 624-43210-438 Misc. Contractual -$ 3,000$ -$ $4,000 624-43210-439 Refunds Issued -$ 4,368$ $3,000 624-43210-530 Capital Impr Other Than Bldgs 2,990$ 2,970$ $3,000 624-43210-570 Office Equipment -$ -$ 624-43210-720 Operating Transfers -$ -$ Total Anderson-Erickson Sewer Fund Expenditures -$ -$ 4,320$ 50,294$ 7,064$ 45,921$ Page 6 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 80 Users BLISS SEWER FUND REVENUES Revenues 602-43210-31951 Special Assessments Principal 2,887$ -$ -$ 2,652$ -$ 602-43210-31952 SA Penalties & Interest 624$ 579$ 403$ 420$ 102$ 400$ 602-43210-33422 Other State Grants & Aids 25$ 74$ 20$ -$ -$ -$ 602-43210-34401 Sewer User Fees 98,531$ 106,717$ 139,546$ 125,230$ 46,351$ 124,895$ 2.5% increase 602-43210-34402 Sewer Connection Fee 8,000$ 8,000$ 8,000$ -$ -$ -$ 602-43210-36100 Special Assessments -$ -$ 47$ -$ 602-43210-36102 Penalties & Interest 183$ -$ 72$ -$ 602-43210-36210 Interest Income 181$ 301$ 1,380$ 210$ -$ 200$ 602-43210-36250 Misc. Refund -$ -$ -$ -$ 602-43210-39200 Interfund Tranfers In -$ -$ -$ -$ Total Bliss Sewer Fund Revenues 107,361$ 118,557$ 149,532$ 125,860$ 49,224$ 125,495$ Expenditures BLISS SEWER FUND EXPENDITURES E 602-43210-101 Regular Wages & Salaries602-43210-101 Regular Wages & Salaries 11,014$ 21,714$ 20,576$ 17,458$ 10,886$ 18,119$ E 602-43210-120 Pension Expense602-43210-120 Pension Expense (1,438)$ (693)$ 7,430$ -$ -$ -$ E 602-43210-121 PERA Coord. Employer Contribu.602-43210-121 PERA Coord. Employer Contribu. 806$ 1,629$ 1,542$ 1,309$ 815$ 1,359$ E 602-43210-122 FICA Employer Contribution602-43210-122 FICA Employer Contribution 684$ 1,284$ 1,216$ 1,082$ 631$ 1,123$ E 602-43210-126 MEDICARE Employer Contribution602-43210-126 MEDICARE Employer Contribution 156$ 299$ 284$ 253$ 162$ 263$ E 602-43210-131 Employer Paid Health602-43210-131 Employer Paid Health -$ -$ -$ -$ -$ -$ E 602-43210-210 Operating Supplies602-43210-151 Worker s Comp Insurance Prem 422$ 1,215$ 736$ 525$ 783$ 800$ E 602-43210-240 Small Tools and Minor Equip602-43210-200 Office Supplies 109$ 128$ 48$ 91$ 102$ 200$ E 602-43210-303 Engineering Fees602-43210-210 Operating Supplies 558$ 680$ 1,823$ 700$ 19$ 1,000$ Daily use items, hardwares, misc. items E 602-43210-304 Legal Services602-43210-240 Small Tools and Minor Equip -$ 217$ -$ 420$ -$ 500$ Hand tools, septic/water sample tools E 602-43210-308 Other Professional Services602-43210-303 Engineering Fees 13,277$ (1,538)$ 1,409$ 8,880$ 68,017$ 12,000$ 5% increase E 602-43210-309 Software Support & Maintenance602-43210-304 Legal Services -$ 6,000$ 18$ -$ -$ E 602-43210-317 Employee Training602-43210-308 Other Professional Services 3,376$ 5,814$ 7,773$ 3,500$ 13,565$ 6,000$ Water/Wastewater analytical testing E 602-43210-321 Telephone602-43210-309 Software Support & Maintenance 716$ 756$ 529$ 910$ -$ 1,200$ SCADA E 602-43210-322 Postage 602-43210-317 Employee Training 868$ 925$ 336$ 980$ 598$ 1,400$ Wastewater training E 602-43210-331 Travel Expenses602-43210-321 Telephone 2,413$ 1,751$ 2,656$ 1,750$ 1,194$ 1,750$ SCADA dialers E 602-43210-334 Licenses & Permits602-43210-322 Postage -$ 200$ 200$ 420$ -$ 500$ E 602-43210-361 Liability/Property Ins602-43210-331 Travel Expenses 8$ 158$ 633$ 525$ 78$ 750$ Page 7 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A E 602-43210-381 Utilities-Electric & Gas602-43210-334 Licenses & Permits 1,180$ 824$ 729$ 1,400$ 505$ 1,500$ Wastewater Certification/Permit Renewal E 602-43210-385 Sewer Pumping & Maintenance602-43210-361 Liability/Property Ins 1,039$ 1,003$ 3,449$ 764$ 2,383$ -$ 5% increase E 602-43210-386 Operation & Maintenance602-43210-381 Utilities-Electric & Gas 1,862$ 3,473$ 3,936$ 2,100$ 563$ 2,750$ E 602-43210-404 Repair Machinery/Equipment602-43210-385 Sewer Pumping & Maintenance 5,364$ 11,410$ 4,695$ 14,000$ 1,245$ 15,000$ Residential holding tank pumping E 602-43210-413 Equipment Rental602-43210-386 Operation & Maintenance 1,574$ 2,888$ 2,639$ 3,500$ -$ 3,500$ E 602-43210-420 Depreciation Expense602-43210-404 Repair Machinery/Equipment 4,375$ 5,857$ 12,101$ 11,200$ 795$ 12,000$ Pump and control repair/replacement E 602-43210-438 Misc. Contractual602-43210-413 Equipment Rental -$ -$ -$ 700$ -$ 700$ E 602-43210-439 Refunds Issued602-43210-420 Depreciation Expense 48,667$ 50,174$ 50,428$ 40,600$ -$ 41,000$ approximate E 602-43210-530 Capital Impr Other Than Bldgs602-43210-438 Misc. Contractual 3,775$ 2,550$ 2,660$ 7,000$ 765$ 7,000$ Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing E 602-43210-720 Operating Transfers602-43210-439 Refunds Issued -$ -$ -$ -$ 602-43210-530 Capital Impr Other Than Bldgs 3,278$ (8,448)$ 6,930$ -$ 7,000$ Pump replacement 602-43210-720 Operating Transfers 17,584$ -$ Total Bliss Sewer Fund Expenditures 100,803$ 121,995$ 119,398$ 126,997$ 120,692$ 137,414$ Page 8 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 9 Users UPTOWN SEWER FUND REVENUES Revenues 612-43210-33422 Other State Grants & Aids 7$ 29$ 1$ -$ -$ -$ 612-43210-34401 Sewer User Fees 15,132$ 17,442$ 22,166$ 22,400$ 4,868$ 23,213$ 2.5% increase 612-43210-34402 Sewer Connection Fee -$ -$ -$ 612-43210-36210 Interest Income 64$ 55$ 326$ 50$ -$ 50.00$ 612-43210-36250 Misc. Refund -$ -$ -$ 612-43210-39203 Transfer from Other Funds -$ -$ -$ Total Uptown Sewer Fund Revenues 15,203$ 17,526$ 22,493$ 22,450$ 4,868$ 23,263$ UPTOWN SEWER FUND EXPENDITURES Expenditures 612-43210-101 Regular Wages & Salaries 3,673$ 9,282$ 8,559$ 10,725$ 4,371$ 11,134$ 612-43210-120 Pension Expense (630)$ 1,164$ 3,619$ -$ -$ -$ 612-43210-121 PERA Coord. Employer Contribu. 259$ 697$ 642$ 804$ 327$ 835$ 612-43210-122 FICA Employer Contribution 219$ 550$ 505$ 665$ 253$ 690$ 612-43210-126 MEDICARE Employer Contribution 50$ 126$ 118$ 156$ 65$ 161$ 612-43210-151 Worker s Comp Insurance Prem 218$ 304$ 316$ 300$ 522$ 550$ 612-43210-200 Office Supplies 4$ -$ -$ 100$ -$ 100$ billing 612-43210-210 Operating Supplies -$ 500$ 320$ 500$ -$ 500$ Daily use items, hardwares, misc. items 612-43210-221 Equipment Parts -$ -$ -$ 500$ -$ 500$ 612-43210-303 Engineering Fees 7,272$ -$ -$ 630$ -$ 1,000$ 5% increase 612-43210-308 Other Professional Services 192$ 884$ 733$ 750$ 310$ 900$ Wastewater Analytical testing 612-43210-309 Software Support & Maintenance 80$ 84$ 84$ 84$ -$ 100$ 612-43210-317 Employee Training 275$ -$ -$ 200$ 1,138$ 200$ 612-43210-319 Other Services -$ -$ -$ 1,500$ -$ 1,500$ 612-43210-322 Postage 18$ -$ -$ -$ -$ 100$ 612-43210-334 Licenses & Permits 209$ 217$ 247$ 250$ 231$ 250$ 612-43210-361 Liability/Property Ins 283$ 334$ 478$ 351$ 464$ -$ 5% increase 612-43210-381 Utilities-Electric & Gas 522$ 697$ 863$ 1,000$ 265$ 1,500$ 612-43210-385 Sewer Pumping & Maintenance (260)$ 327$ 1,800$ 1,500$ -$ 1,500$ 612-43210-386 Operation & Maintenance -$ 462$ -$ 1,000$ -$ 1,000$ 612-43210-404 Repair Machinery/Equipment 767$ 465$ -$ 2,000$ -$ 2,000$ Page 9 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 612-43210-420 Depreciation Expense 4,876$ 4,877$ 4,876$ 4,900$ -$ 5,000$ 612-43210-438 Misc. Contractual 100$ 548$ 140$ 1,500$ 449$ 1,500$ Lift Station Inspection/Pump Testing 612-43210-530 Capital Impr Other Than Bldgs 1,456$ -$ -$ 9,900$ 9,900$ Pump Replacement 612-43210-570 Office Equipment -$ -$ -$ -$ 612-43210-720 Operating Transfers -$ -$ 2,640$ -$ Total Uptown Sewer Fund Expenditures 19,582$ 21,516$ 23,299$ 41,955$ 8,394$ 40,921$ Page 10 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 33 Users ANDERSON-ERICKSON SEWER FUND REVENUES Revenues 624-43210-31951 Special Assessments Principal 2,887$ -$ -$ 624-43210-31952 SA Penalties & Interest 624$ 579$ 180$ 200$ 624-43210-33422 Other State Grants & Aids 25$ 74$ -$ -$ 624-43210-34401 Sewer User Fees 98,531$ 106,717$ 53,670$ 21,150$ 50,599$ 2.5% increase 624-43210-34402 Sewer Connection Fee 8,000$ 8,000$ -$ -$ -$ 624-43210-36100 Special Assessments -$ -$ 624-43210-36102 Penalties & Interest -$ 30$ -$ 624-43210-36210 Interest Income 181$ 301$ 90$ 100$ 624-43210-36250 Misc. Refund -$ -$ 624-43210-39200 Interfund Tranfers In -$ 17,584$ -$ Total Anderson-Erickson Sewer Fund Revenues 107,361$ 118,557$ -$ 53,940$ 38,764$ 50,899$ Expenditures ANDERSON-ERICKSON SEWER FUND EXPENDITURES 624-43210-101 Regular Wages & Salaries -$ 7,482$ -$ 7,765$ 624-43210-121 PERA Coord. Employer Contribu. -$ 561$ -$ 582$ 624-43210-122 FICA Employer Contribution -$ 464$ -$ 481$ 624-43210-126 MEDICARE Employer Contribution -$ 108$ -$ 113$ 624-43210-151 Worker s Comp Insurance Prem -$ 225$ -$ -$ 624-43210-200 Office Supplies -$ 39$ -$ $200 624-43210-210 Operating Supplies -$ 300$ -$ $300 Daily use items, hardwares, misc. items 624-43210-240 Small Tools and Minor Equip -$ 180$ 44$ $200 Hand tools, septic/water sample tools 624-43210-303 Engineering Fees 320$ -$ -$ $4,000 5% increase 624-43210-304 Legal Services -$ -$ -$ $0 624-43210-308 Other Professional Services -$ 1,500$ -$ $1,500 Water/Wastewater analytical testing 624-43210-309 Software Support & Maintenance -$ 390$ 310$ $400 SCADA 624-43210-317 Employee Training 227$ 420$ -$ $400 Wastewater training 624-43210-321 Telephone -$ 750$ 109$ $750 SCADA dialers 624-43210-322 Postage 253$ 180$ 425$ $200 624-43210-331 Travel Expenses 80$ 225$ -$ $225 624-43210-334 Licenses & Permits -$ 600$ 78$ $750 Wastewater Certification/Permit Renewal Page 11 of 12 8/2/2024 City of Scandia 2025 Proposed Budget 2021 2022 2023 2024 Budget 7/31/2024 2025 Actual Actual Actual Approved YTD Actual Budget-1 Comments EXHIBIT A 624-43210-361 Liability/Property Ins -$ -$ 231$ $254 10% increase 624-43210-381 Utilities-Electric & Gas -$ 900$ 985$ $1,000 624-43210-385 Sewer Pumping & Maintenance 43$ 6,000$ 283$ $6,000 Residential holding tank pumping 624-43210-386 Operation & Maintenance -$ 1,500$ -$ $1,500 624-43210-404 Repair Machinery/Equipment -$ 4,800$ -$ $4,000 Pump and control repair/replacement 624-43210-413 Equipment Rental 408$ 300$ 230$ $300 624-43210-420 Depreciation Expense -$ 17,400$ -$ $5,000 approximate 624-43210-438 Misc. Contractual -$ 3,000$ -$ $4,000 Emergency or additional holding tank pumping and maintenance, Lift station inspection/pump testing 624-43210-439 Refunds Issued -$ 4,368$ $3,000 624-43210-530 Capital Impr Other Than Bldgs 2,990$ 2,970$ $3,000 Pump replacement 624-43210-570 Office Equipment -$ -$ 624-43210-720 Operating Transfers -$ -$ Total Anderson-Erickson Sewer Fund Expenditures -$ -$ 4,320$ 50,294$ 7,064$ 45,921$ Page 12 of 12 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 Interest Earnings 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3 Expenses 4 CIP Inflation Factor 4.00% 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 2032 Actual Approved Projected REVENUE 5 Property taxes 293,791 235,000 85,000 100,000 104,000 108,160 112,486 116,986 121,665 126,532 6 Intergovernmental - - - - - - - 7 Capital Improvement Debt Levy - - - - - - - - 8 Special assessments - - - - - - - - - - 9 Investment Income 2,300 1,500 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 10 Refunds and Reimbursements 11 Park Dedication Fees 12 Rental and lease income - - - - - - - - - - 13 Miscellaneous Revenue - - - - - - - - - - 14 Total Revenue 296,091 236,500 86,000 101,000 105,000 109,160 113,486 117,986 122,665 127,532 EXPENSES 15 Total Current - - - - - - - - - - 16 Payables internet - - - - - - - - - - 17 Debt service - - - - - - - - - - 18 Total Capital Projects 198,059 182,525 323,041 530,457 14,000 193,399 31,633 128,083 109,251 618,083 19 Total Expenses 198,059 182,525 323,041 530,457 14,000 193,399 31,633 128,083 109,251 618,083 20 Revenue Over / (Under) Expenses 98,032 53,975 (237,041) (429,457) 91,000 (84,239) 81,853 (10,097) 13,415 (490,552) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 22 Transfers In 8,000 - - - - - - - - - 23 Transfers Out to Sewer Fund (2,640) 24 Transfers Out- (150,000) 25 Total Other Sources / (Uses) 5,360 (150,000) - - - - - - - - 26 accounts payable 27 Prior Period Adjustments 28 Ending Fund Balance 782,892 686,867 449,826 20,369 111,369 27,130 108,984 98,887 112,301 (250,718) CA S H F L O W A N A L Y S I S CITY OF SCANDIA CITY OF SCANDIA Capital Improvement Plan Capital Improvement Plan Capital Improvement Fund 401 Capital Improvement Fund 401 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Year Actual Approved Projected 29 30 Broadband Development Grants to MIDCO 2022 31 Development Code Update 2022 32 Community Center Improvements-Doors & security 2022 33 Council Chambers remodel 2022 34 Gateway Trail 2025 15,000 160,000 35 Broadband Development Grants to MIDCO 2023 119,500 92,000 300,000 36 County Ped & Bicycle Accomodations 2023 50,000 37 Wall Panel Joint Replacement Fire Hall-leaking 2023 16,250 38 Council Chambers remodel 2023 12,309 39 Security Improvements CCTV for Park 2024 14,000 40 Bliss Additions Stormwater plan 2023 122,525 135,000 41 new Exhaust removal system for truck bays 2024 58,399 42 new Warning Sirens 2025 31,633 43 Arts & Heritage Center Amphitheater 2027 44 Arts & Heritage Center Sidewalk and Walkways 2027 45 CC AC Condenser Replacement 2025 46 Lobbying 2025 47 Fire/PW Potable Well Pump (2000) Replacement 2026 11,699 48 2010 Fire Radios Replace 3 unspupported radios 2030 17,548 24,016 49 2010 Homatro Cutter Twin Line R-1(Jaws of Life)2030 40,945 56,036 50 2015 Lucas CPR Device-replacement 2030 17,548 24,016 51 Cold Storage Building 2030 140,000 52 Additional Comm Cent Elec Locks 2030 18,000 24,016 53 Large Hall and Heritage Room Carpeting 2030 54 2000 Station Bay floor epoxy coating-maintenance 2031 21,900 31,171 55 2010 Washer/Extractor-replacement 2031 9,125 12,988 56 2017 Thermal Imaging Cameras (1of3) find hot spots 2031 9,733 13,853 57 Zoll Monitor/Defib 2031 51,239 58 Second Fire Station 2032 337,136 59 Community Center Design & Planning 2032 280,947 60 Air Containment Unit 2033 61 Community Center Improvements-Front Office + Equip Room 60,000 62 CIP placeholder - SERVER REPLACEMENT 2035 Total Capital Projects 198,059 182,525 323,041 530,457 14,000 193,399 31,633 128,083 109,251 618,083 PROJECTED NEW DEBT TERMS Updated KHM As of Date:6/27/2023 1 Par Amount (Line 14) - - - - - - - - - - 2 Number of Years 15 15 15 15 15 15 15 15 15 15 3 Interest Rate 0 0 0 0 0 0 0 0 0 0 4 New Debt Levy - - - - - - - - - - Ca p i t a l P r o j e c t O u t l a y Ca p i t a l P r o j e c t O u t l a y Project CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund Inflation Assumptions 4 CIP Inflation Factor 0.00% 2.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 2032 Proposed REVENUE 5 Property taxes 20,000 60,000 40,000 40,000 50,000 50,000 50,000 50,000 50,000 50,000 6 Intergovernmental 112,500 7 Charges for services 8 Investment Income 66 66 66 66 66 66 66 66 66 66 9 Sale of capital assets 10 Park Dedication Fees 24,000 24,000 - - - - - - - - 11 Rental and lease income - - - - - - - - - - Transfer from General Fund 150,000 125,000 12 Miscellaneous Revenue 8,068 13 Total Revenue 314,634 209,066 40,066 40,066 50,066 50,066 50,066 50,066 50,066 50,066 EXPENSES 14 Total Current 15 Debt service 16 Total Capital Projects 333,739 150,000 300,000 25,000 16,010 60,000 - 17 Total Expenses 333,739 150,000 300,000 25,000 16,010 - - - 60,000 - 18 Revenue Over / (Under) Expenses (19,105) 59,066 (259,934) 15,066 34,055 50,066 50,066 50,066 (9,934) 50,066 OTHER FINANCING SOURCES / (USES) 19 Bond Proceeds 20 Transfers In 150,000 21 Transfers Out 8,000 22 Transfers Out- 22 Total Other Sources / (Uses) 8,000 150,000 - - - - - - - - 23 Prior Period Adjustments 24 Ending Fund Balance 63,927 272,993 13,058 28,124 62,179 112,244 162,310 212,375 202,441 252,506 CITY OF SCANDIA Financial Management Plan Park Capital Improvement Fund 404 CA S H F L O W A N A L Y S I S 2021 2016 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Year Costs Proposed 25 25 Park Planning 2022 15000 4,500 26 Community Center Park-concrete, grill, table, benches 2022 112500 27 Playground Equipment - Community Center Park 2022 122500 180,319 28 Lilleskogen Park Picnic Shelter 2024 43700 29 Gateway Trail Improvements @ Annex 2024 0 25,000 30 Hay Lake Park - sign 2023 8653 1,500 31 Park signage at Orwell Park (Liten)2023 8653 800 32 Replace rink boards 2024 134984 146,620 33 Lilleskogen Praire/Wetland Restoration Project 2025 12878 34 Nature park trails 2025 42700 35 Playground Equipment - Erickson ballfield 2028 66682 100,000 36 Tennis Court/Pickle Ball - repaint 2024 60533 150,000 300,000 37 Expanded Pleasure Rink 2027 12653 16,010 38 Hay Lake Park Shelter water & doors 2027 101226 128,083 39 New Ballfield to Replace South Ball Field 2027 44286 56,036 40 Settlers MonutPossible Reloc/Imp 2027 37960 60,000 41 CIP Place Holder 2031 50000 42 Total Capital Projects 874,908 - 333,739 150,000 300,000 25,000 16,010 228,083 56,036 - 60,000 - PROJECTED NEW DEBT TERMS 43 Par Amount (Line 19) - - - - - - - - - - - 44 Number of Years 10 10 10 10 10 10 10 10 10 10 10 45 Interest Rate 2.50% 3.00% 3.00% 3.00% 3.00%3.00% 3.00% 3.00% 3.00% 3.00% 46 New Debt Levy 0 0 0 0 0 0 0 0 0 0 0 CA P I T A L O U T L A Y Project CA P I T A L O U T L A Y 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 0.00%0.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Budget Projected REVENUE 5 Property taxes 87,800 - 110,000 130,000 135,200 140,608 146,232 152,082 158,165 164,491 171,071 177,914 6 Debt service levy - 98,474 123,092 123,092 123,092 153,865 178,483 215,411 289,266 215,411 7 Intergovernmental - - - - - - - - - - - - 8 Sale of capital assets 19,500 - - - - - - - - - 9 Investment Income 1,015 1,030 1,045 1,061 1,077 1,093 1,109 1,126 1,143 1,160 1,177 1,195 10 Refunds and Reimbursements 11 Park Dedication Fees 12 Rental and lease income - - - - - - - - - - - - 13 Miscellaneous Revenue - 176,000 14 Total Revenue 88,815 196,530 111,045 229,535 259,369 264,793 270,433 307,073 337,791 381,063 461,514 394,520 EXPENSES - Paid in debt service fund 15 Total Current - - - - - - - - - - - 16 Debt service - - - 93,784 117,231 117,231 117,231 146,538 169,984 205,153 275,492 205,153 17 Total Capital Projects 198,500 101,967 1,523,083 286,787 132,583 25,000 457,901 486,166 449,767 759,737 - - 18 Total Expenses 198,500 101,967 1,523,083 380,571 249,814 142,231 575,132 632,704 619,751 964,891 275,492 205,153 19 Revenue Over / (Under) Expenses (109,685) 94,563 (1,412,038) (151,037) 9,556 122,563 (304,698) (325,631) (281,959) (583,828) 186,023 189,367 OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 800,000 200,000 - 250,000 200,000 300,000 600,000 - 21 Transfers In 337,000 22 Transfers Out 23 Transfers Out- 24 Total Other Sources / (Uses)- - 1,137,000 200,000 - - 250,000 200,000 300,000 600,000 - - 25 Prior Period Adjustments 26 Ending Fund Balance 206,748 301,310 26,272 75,235 84,791 207,354 152,655 27,024 45,065 61,237 247,260 436,626 CITY OF SCANDIA Capital Improvement Plan Equipment Replacement Fund 406 CA S H F L O W A N A L Y S I S 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Capital Project Name First Year Last Year Costs Budget Projected 27 312-08 Asphalt Patching Equipment Trailer (2008)2025 39000 25,000 28 2000 Engine 1 - 5176 Replacement 2026 650000 806,000 29 2003 Tanker 5178 Tender 2 Replacement 2025 292000 10,000 100,879 286,787 30 201-14 Mack Single Axle w/Plow (2014)2029 275000 415,000 31 202-17 Western Star Single Axle Truck/Plow (2017)2028 350000 400,000 32 203-11 Mack Dump Truck/Plow Replacement (2011)2023 325000 335,000 33 301-98 John Deere Motor Grader (1998)2031 480000 607,353 34 302-22 JD-6410 Tractor w/flail attachments (2022)2022 198500 198,500 35 308-12 New Holland Skid Steer (2012)2024 65000 60,368 36 Motor Grader 2022 0 37 Wall Panel Joint Replacement Fire Hall-leaking 2023 16250 16,250 37 101-18 Chev 1/2 ton pickup (2018)2028 44000 57,901 38 102-19 Dodge 3500 SRW w/plow (2019)2029 52000 71,166 39 103-21 Dodge 2500 w/plow (2021)2031 62000 91,775 40 104-13 Ford F550 w/sander, plow mount, compressor 2024 75000 96,527 41 1995 Utility 1misc purpose truck - replacement 2023 86500 63,202 42 2003 Boat & Trailer - water rescues 2023 38000 12,717 38,152 43 303-17 Kubota F39000 Mower w/Broom & Blower (2017)2023 65000 63,000 44 303-17 Kubota F39000 Mower w/Broom & Blower (2017)2030 75000 106,748 45 304-21 Kubota UTV (2021)2030 16000 22,773 46 Addition Vehicle (truck for addl FT or PT staff)2025 50500 60,000 47 Equipment Attachments (fit skid, loader, tractor)2024 10000 22,956 48 PJ Skid Trailer 14,000 lbs (2012)2025 17000 20,000 49 Rescue 5179 Replacement 2030 225000 320,245 50 Utility Trailer 3,500 lbs (1998)2025 8000 10,000 51 2012 UTV & Trailer replacement off road rescue 2031 - - - - 42,583 - - - - 60,609 - - 52 Total Capital Projects 3,514,750 198,500 101,967 1,523,083 286,787 132,583 25,000 457,901 486,166 449,767 759,737 - - PROJECTED NEW DEBT TERMS KHM As of Date:6/27/2023 53 Par Amount (Line 14)- - 800,000 200,000 - - 250,000 200,000 300,000 600,000 - - 54 Number of Years 10 10 10 10 1,023 10 10 10 10 10 10 10 55 Interest Rate 2.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00%3.00% 56 New Debt Levy 0 0 0 98,474 123,092 123,092 123,092 153,865 178,483 215,411 289,266 215,411 Ca p i t a l E q u i p m e n t O u t l a y Project CITY OF SCANDIA CAPITAL IMPROVEMENT 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 Interest Earnings 1.50%3.50%3.50%3.50%3.50%3.50%1.50%1.50%1.50% 3 Expenses 3.00%3.00%3.00% 4 CIP Inflation Factor 0.00%4.00%4.00%4.00%4.00%4.00%3.00%4.00%4.00% 2022 2023 2024 2025 2026 2027 2028 2029 2030 Actual Projected REVENUE 5 Property taxes 216,860 212,012 375,000 440,000 457,600 475,904 494,940 514,738 535,327 6 Debt levy - 2018 GO Bond - 343,166 340,541 343,009 345,161 341,749 343,429 Debt levy - 2024 GO Bond 359,888 362,828 360,098 357,158 359,258 355,688 7 Special assessments 8 Investment Income 4,655 12,115 5,447 12,295 16,794 10,938 3,317 13,735 5,876 9 Refunds and Reimbursements 10 Intergovermental 17,744 11 Rental and lease income - - - - - - - - - 12 Miscellaneous Revenue - - - - - - - - - 13 Total Revenue 239,259 224,127 380,447 1,155,349 1,177,762 1,189,948 1,200,575 1,229,479 1,240,320 EXPENSES 14 Total Current 15 Debt service 16 2018 GO Bond 326,825 324,325 326,675 328,725 325,475 327,075 17 2024 GO Bond 342,750 345,550 342,950 340,150 342,150 18 Total Capital Projects 595,069 815,000 3,940,745 700,000 678,000 609,120 1,834,365 1,087,739 591,249 19 Total Expenses 595,069 815,000 3,940,745 1,026,825 1,345,075 1,281,345 2,506,040 1,753,364 1,260,474 20 Revenue Over / (Under) Expenses (355,810) (590,873) (3,560,298) 128,524 (167,313) (91,397) (1,305,465) (523,885) (20,154) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 3,755,973 2,000,000 22 Bond premium 23 Transfers In 24 Transfers Out 25 Transfers Out- 25 Total Other Sources / (Uses)- - 3,755,973 - - 2,000,000 - 26 Prior Period Adjustments 27 Ending Fund Balance 896,739 155,620 351,295 479,819 312,506 221,109 915,644 391,759 371,605 CITY OF SCANDIA Financial Management Plan Local Road Improvement Fund 408 CA S H F L O W A N A L Y S I S Project Multiple 2022 2022 2023 2024 2025 2026 2027 2028 2029 2030 Capital Project Name Number Year?First Year Last Year Costs Actual Proposed Est. 28 28 Soil Borings for 2024 & 2025 PW-061 2023 20000 25,000 29 Soil Borings for 2026 & 2027 PW-062 2025 20000 25,000 30 Soil Borings for 2028 & 2029 PW-069 2027 20000 28,000 31 Engineering Fees PW-070 100000 100,000 75,000 78,000 81,120 84,365 87,739 91,249 32 2022 Local Road Improvement Project PW-043 2022 707200 707,200 33 2023 Local Road Improvement Project PW-043 2023 671745 671,745 34 2023 Seal Coat & Crack Filling Project PW-050 2023 168374 168,374 2024 Seal Coat & Crack Filling PW-2024 455,000 35 2024 Local Road Improvement Project PW-056 2024 2755745 3,385,745 36 2025 Local Road Improvement Project PW-053 2025 540000 600,000 37 2025 Seal Coat & Crack Filling PW-052 2025 252000 38 2026 Local Road Improvement Project PW-035 2027 870000 600,000 39 2026 Seal Coat & Crack Filling Project PW-051 2027 335000 40 2027 Local Road Improvement Project PW-057 2028 900000 500,000 41 2027 Seal Coat & Crack Filling PW-060 2028 78000 42 2028 Local Road Improvement Project PW-036 2029 1000000 1,750,000 43 2029 Local Road Improvement Project PW-060 2030 860000 - 1,000,000 44 2030 Local Road Improvement Project PW-072 2031 880000 - 500,000 45 2031 Local Road Improvement Project PW-073 2032 1000000 - 46 Total Capital Projects 11,178,064 - 707,200 865,119 3,940,745 700,000 678,000 609,120 1,834,365 1,087,739 591,249 PROJECTED NEW DEBT TERMS 47 Par Amount (Line 14)- - - 3,635,000 - - 2,000,000 - 48 Number of Years 9 15 15 15 15 15 15 15 15 10 49 Interest Rate 2.00%2.50%3.87%5.00%5.00%5.00%5.00%5.00%5.00% 50 New Debt Levy 0 0 0 0 340,170 340,170 340,170 340,170 542,488 542,488 Lo c a l R o a d P r o j e c t O u t l a y Project CITY OF SCANDIA SUMMARY BUDGET 6/20/2023 Inflation Assumptions 810,813 800,388 833,706 858,717 884,479 Revenue (Non-property tax) 1.00% 1.00% 1.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Interest Earnings 3.25% 3.25% 3.25% 3.25% 3.00% 3.00% 3.00% 3.00% 3.00% Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% Budgeted Budgeted Projected Projected Projected Projected Projected Projected Projected GENERAL FUND 2023 2024 2025 2026 2027 2028 2029 2030 2031 REVENUE 1 General Property Tax-Current 1,865,918 1,865,918 1,893,907 1,969,663 2,028,753 2,089,616 2,152,304 2,216,873 2,283,379 2 Other taxes 149,697 134,357 133,357 136,024 138,745 141,520 144,350 147,237 150,182 3 Intergovernmental 61,000 71,674 69,000 70,380 71,788 73,223 74,688 76,182 77,705 4 Grants 11,700 5 Franchise fees - 6 Licenses and Permits 161,100 179,100 183,100 186,762 190,497 194,307 198,193 202,157 206,200 7 Charges for Services 53,000 57,074 58,813 59,989 61,189 62,413 63,661 64,934 66,233 8 Fines & Forfeits 7,400 7,000 6,000 6,180 6,365 6,556 6,753 6,956 7,164 9 Interest Earnings 12,100 30,000 30,900 31,827 32,782 33,765 34,778 35,822 10 Miscellaneous Revenues 9,900 11,000 9,500 9,785 10,079 10,381 10,692 11,013 11,343 11 - - - - - - - - - 12 Total Revenue 2,331,815 2,326,123 2,383,677 2,469,683 2,539,242 2,610,797 2,684,407 2,760,130 2,838,029 EXPENSES 13 Current 14 General Government 754,700 714,744 736,967 759,076 781,848 805,303 829,462 854,346 879,977 15 Public Safety 504,399 547,807 592,074 609,836 628,131 646,975 666,384 686,376 706,967 16 Public Works 732,450 815,044 840,735 865,957 891,936 918,694 946,255 974,643 1,003,882 17 Park and Recreation 175,060 209,226 212,242 218,609 225,167 231,922 238,880 246,046 253,428 18 Applied to Federal Grant 19 Federal fund returned 20 Capital Outlay 150,000 21 22 23 24 25 Total Expenses 2,316,609 2,286,822 2,382,017 2,453,478 2,527,082 2,602,895 2,680,982 2,761,411 2,844,253 26 Revenues Over / (Under) Expenses 15,206 39,301 1,659 16,205 12,160 7,903 3,425 (1,281) (6,225) 38 Ending General Fund Balance (FB) 1,364,993 1,404,294 1,405,953 1,422,159 1,434,319 1,442,221 1,445,647 1,444,365 1,438,141 39 Restricted - - - - - - - - - 40 Unassigned 1,364,993 1,404,294 1,405,953 1,422,159 1,434,319 1,442,221 1,445,647 1,444,365 1,438,141 41 Fund Balance as a % of Next Year's Expenditures (net of contingency) 59.7% 59.0% 57.3% 56.3% 55.1% 53.8% 52.4% 50.8% #DIV/0! Projected Levy by Type 2023 2024 2025 2026 2027 2028 2029 2030 2031 41 General Fund Operating Tax Levy 1,865,918 1,865,918 1,893,907 1,969,663 2,028,753 2,089,616 2,152,304 2,216,873 2,283,379 42 Annual Increase 16.1% 0.0% 1.5% 4.0% 3.0% 3.0% 3.0% 3.0% 3.0% ANNUAL DEBT LEVIES BY BOND ISSUE-FUTURE 43 44 BONDS ISSUED 3,635,000 45 EQUIPMENT CERTIFICATES 800,000 200,000 - - 250,000 200,000 300,000 600,000 46 47 48 Total Annual Debt Issuance - 4,435,000 200,000 - - 250,000 200,000 300,000 600,000 OTHER SPECIAL TAX LEVIES 49 Debt service 50 2025 Certificates 64,000 51 2024 Certificates 52 2024 GO Bonds 359,888 362,828 360,098 357,158 359,258 355,688 357,158 53 2018 GO Bonds 342,536 345,634 343,166 340,541 343,009 345,161 341,749 343,429 344,794 54 Capital Improvement Debt Levy 55 Equipment Replacement Debt Levy - 98,474 123,092 123,092 123,092 153,865 178,483 215,411 56 Local road improvement Debt Levy 57 Total Annual Debt Levies 406,536 345,634 801,527 826,461 826,198 825,411 854,871 877,600 917,362 ANNUAL CAPITAL PROJECTS LEVIES 58 Capital Improvement 293,791 235,000 85,000 100,000 104,000 108,160 112,486 116,986 121,665 59 Park Improvement 20,000 60,000 40,000 40,000 50,000 50,000 50,000 50,000 50,000 60 Equipment Replacement - 110,000 130,000 135,200 140,608 146,232 152,082 158,165 164,491 61 Local Road Improvement 212,012 375,000 440,000 457,600 475,904 494,940 514,738 535,327 556,740 62 63 EDA 5,300 5,300 64 65 Total Other Special Levies 531,103 785,300 695,000 732,800 770,512 799,332 829,306 860,478 892,897 66 67 Total Tax Levy 2,803,557 2,996,852 3,390,434 3,528,924 3,625,463 3,714,359 3,836,481 3,954,951 4,093,639 68 Increase/(Decrease) in Total Tax Levy 7.70% 6.89% 13.13% 4.08% 2.74% 2.45% 3.29% 3.09% 3.51% 69 Less: Fiscal Disparities (123,279) (107,857) (121,292) (120,225) (124,117) (126,228) (128,076) (131,058) (133,802) 70 Net Levy to Taxpayers 2,680,278 2,888,995 3,269,143 3,408,698 3,501,347 3,588,131 3,708,405 3,823,892 3,959,837 71 72 Existing Tax Base 10,129,722 10,847,248 10,706,234 10,813,296 10,921,429 11,030,643 11,140,949 11,252,358 11,364,882 82 21.52% 7.08% -1.30% 83 New Net Tax Capacity 0 0 0 0 0 0 0 0 0 84 Total Net Tax Capacity 10,129,722 10,847,248 10,706,234 10,813,296 10,921,429 11,030,643 11,140,949 11,252,358 11,364,882 85 Tax Rate on Tax Capacity 26.460% 26.633% 30.535% 31.523% 32.059% 32.529% 33.286% 33.983% 34.843% 86 Tax Rate % Change -10.72% 0.66% 14.65% 3.24% 1.70% 1.46% 2.33% 2.09% 2.53%