Loading...
FUND 408 - 2021 TO 2025CITY OF SCANDIA Financial Management PlanLocalRoadImprovementFund408 Inflation Assumptions1Revenue (Non-property tax)2.00%2.00%2.00%2.00%2.00%2.00% 2Interest Earnings1.50%1.50%1.50%1.50%1.50%1.50% 3Expenses3.00%3.00%3.00%3.00%3.00%3.00% 4CIP Inflation Factor4.00%4.00%4.00%4.00%4.00% 202120222023202420252026BudgetBudgetProposedREVENUE5RPropertytaxes438,539 216,860 350,000 400,000 300,000 200,000408-310006RDebt levy0065,087133,252221,207408-310007RSpecial assessments408-361008RInvestment Income19,61312,6884,04611,13112,664408-362109RRefunds and Reimbursements408-3625010RInterfund Operating Transfer80,000408-2920311RRental and lease income00000012RMiscellaneousRevenue0000013TotalRevenue518,539236,473362,688469,132444,383433,870 EXPENSES14Total Current000015Debtservice000061,987126,90616Principal17Interest18TotalCapitalProjects845,000707,200938,829736,7861,055,2121,332,23519TotalExpenses845,000707,200938,829736,7861,117,2001,459,141 20Revenue Over / (Under) Expenses(326,461)(470,727)(576,141)(267,653)(672,817)(1,025,271) CASH FLOW ANALYSIS OTHER FINANCING SOURCES / (USES) 21RBond Proceeds 740,000775,0001,000,00022E408-39310Bond premium23RTransfers In80,00000000408-3920324E408-43100-720Transfers Out25ETransfersOut- 26Total Other Sources / (Uses)80,00000740,000775,0001,000,000 27Prior Period AdjustmentsEndingFund Balance1,316,587845,860269,719742,066844,249818,97828 ProjectMultipleProject2021202120222023202420252026CapitalProjectNameNumberYear?First YearCostsBudgetBudgetProposed292021LocalRoadImprovementProject30E408-43100-5302021 70,000 70,000 - - - - - 2021 Local Road Improvement Project31E408-43100-5302021 845,000 845,000 - - - - - 2022 Local Road Improvement Project32E408-43100-5302022 680,000 - 707,200 - - - - 2023 Seal Coating Project33E408-43100-5302023 183,000 - - 197,933 - - - Sealboring34E408-43100-5302023 20,000 - - 21,632 - - - 2023 Local Road Improvement Project35E408-43100-5302023 665,000 - - 719,264 - - - 2024 Local Road Improvement Project36E408-43100-5302024 655,000 - - - 736,786 - - 2025 Seal Coating Project37E408-43100-5302025 252,000 - - - - 294,804 - 2025 Local Road Improvement Project38E408-43100-5302025 630,000 - - - - 737,011 - Sealboring39E408-43100-5302025 20,000 - - - - 23,397 - 2026 Seal Coating Project40E408-43100-5302026 335,000 - - - - - 407,5792026streetreconstruction41E408-43100-5302026 760,000 - - - - - 924,6562027streetreconstruction42E408-43100-5302027 770,000 - - - - - - 2027 seal coating and boring43E408-43100-5302027 98,000 - - - - - - 2028 street reconstruction44E408-43100-5302028 790,000 - - - - - - 2029 street reconstruction45E408-43100-5302029 770,000 - - - - - - Local Road Project Outlay - Option III2029sealcoatingandboring46E408-43100-5302029 20,000 - - - - - - 47 - - - - - - 4849Total Capital Projects 7,563,000 915,000 707,200 938,829 736,786 1,055,212 1,332,235