Loading...
05. CIP Worksheets1 CITY OF SCANDIA 2 Summary Budget 3 12/31/2024 4 5 Inflation Assumptions 804,673 829,090 853,963 879,582 6 Revenue (Non-property tax) 2.00% 2.00%2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50%1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00%3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor (from last june) 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 11 GENERAL FUND 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 12 Actual Approved Projected 13 REVENUE 14 General Property Tax-Current 1,865,918 1,893,907 1,941,255 1,989,786 2,039,531 2,090,519 2,142,782 2,196,352 2,251,261 2,307,543 15 Other taxes 134,357 149,179 152,163 155,206 158,310 161,476 164,706 168,000 171,360 174,787 16 Intergovernmental 83,919 69,000 70,380 71,788 73,224 74,688 76,182 77,706 79,260 80,845 17 Grants - - - - - - - - - - 18 Franchise fees - - - - - - - - - - 19 Licenses and Permits 179,100 183,100 186,762 190,497 194,307 198,193 202,157 206,200 210,324 214,530 20 Charges for Services 57,074 58,813 59,989 61,189 62,413 63,661 64,934 66,233 67,558 68,909 21 Fines & Forfeits 7,000 6,000 6,120 6,242 6,367 6,494 6,624 6,756 6,891 7,029 22 Interest Earnings 30,000 30,450 30,907 31,371 31,842 32,320 32,805 33,297 33,796 23 Miscellaneous Revenues 11,000 9,500 9,690 9,884 10,082 10,284 10,490 10,700 10,914 11,132 24 - - - - - - - - - - 25 Total Revenue 2,338,368 2,399,499 2,456,809 2,515,499 2,575,605 2,637,157 2,700,195 2,764,752 2,830,865 2,898,571 26 27 EXPENSES 28 Current 29 General Government 714,744 743,567 765,874 788,850 812,516 836,891 861,998 887,858 914,494 941,929 30 Public Safety 560,051 592,625 610,404 628,716 647,577 667,004 687,014 707,624 728,853 750,719 31 Public Works 815,044 821,200 845,836 871,211 897,347 924,267 951,995 980,555 1,009,972 1,040,271 32 Park and Recreation 209,226 211,437 217,780 224,313 231,042 237,973 245,112 252,465 260,039 267,840 33 Applied to Federal Grant - - - - - - - - - - 34 Federal fund returned - - - - - - - - - - 35 Capital Outlay - - - - - - - - - - 36 - - - - - - - - - - 37 Total Expenses 2,299,065 2,368,829 2,439,894 2,513,090 2,588,482 2,666,135 2,746,119 2,828,502 2,913,358 3,000,759 38 39 Revenues Over / (Under) Expenses 39,303 30,670 16,915 2,409 (12,877) (28,978) (45,924) (63,750) (82,493) (102,188) 40 41 OTHER FINANCING SOURCES / (USES) 42 Transfers In - - - - - - - - - - 43 Contingency - - - - - - - - - - 44 Sale of Fixed Assets - - - - - - - - - - 45 Bond Proceeds - - - - - - - - - - 46 Transfer in - - - - - - - - - - 47 Transfer out to General Capital - - - - - - - - - - 48 Transfer out to Local Road Improvement - - - - - - - - - - 49 Transfers Out - - - - - - - - - - 50 Total Other Sources / (Uses)- - - - - - - - - - 51 52 Prior Period Adjustments 53 Ending General Fund Balance (FB)1,404,296 1,434,966 1,451,881 1,454,290 1,441,413 1,412,435 1,366,511 1,302,761 1,220,268 1,118,080 54 Restricted - - - - - - - - - - 55 Unassigned 1,404,296 1,434,966 1,451,881 1,454,290 1,441,413 1,412,435 1,366,511 1,302,761 1,220,268 1,118,080 56 Fund Balance as a % of Next Year's Expenditures (net of contingency) 59.3% 58.8% 57.8% 56.2% 54.1% 51.4% 48.3% 44.7% 40.7% 36.2% 57 1 CITY OF SCANDIA 2 Summary Budget 3 12/31/2024 4 5 Inflation Assumptions 804,673 829,090 853,963 879,582 6 Revenue (Non-property tax) 2.00% 2.00%2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50%1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00%3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor (from last june) 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 58 Levy by Type 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 59 Approved Projected 60 General Fund Operating Tax Levy 1,865,918 1,893,907 1,941,255 1,989,786 2,039,531 2,090,519 2,142,782 2,196,352 2,251,261 2,307,543 61 Annual Increase 0.00% 1.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 62 63 ANNUAL DEBT LEVIES BY BOND ISSUE-FUTURE 64 65 Capital Improvement Bond Proceeds - - - - - - - - - - 66 Park Improvement Bond Proceeds - - - - - - - - - - 67 Equipment Replacement Bond Proceeds 340,000 300,000 - 250,000 - 250,000 300,000 - 350,000 - 68 Local Road Improvement Bond Proceeds 3,974,972 - - - - - - - - - 69 70 Total Annual Debt Issuance 4,314,972 300,000 - 250,000 - 250,000 300,000 - 350,000 - 71 72 OTHER SPECIAL TAX LEVIES 73 74 Capital Improvement Debt Levy - - - - - - - - - - 75 Park Improvement Debt Levy - - - - - - - - - - 76 Equipment Replacement Debt Levy - 38,997 68,331 67,377 91,711 90,758 115,095 144,476 143,510 177,950 77 Local Road Improvement Debt Levy 345,634 455,290 528,369 583,106 652,319 701,006 699,116 701,951 704,051 699,713 78 Total Annual Debt Levy 345,634 494,287 596,700 650,483 744,030 791,764 814,211 846,427 847,561 877,663 79 80 ANNUAL CAPITAL PROJECTS LEVIES 81 Capital Improvement Projects Levy 235,000 125,000 150,000 153,750 157,594 161,534 165,572 169,711 173,954 178,303 82 Park Improvement Projects Levy 60,000 40,000 41,000 42,025 43,076 44,153 45,257 46,388 47,548 48,737 83 Equipment Replacement Projects Levy 110,000 125,000 128,125 131,328 134,611 137,976 141,425 144,961 148,585 152,300 84 Local Road Improvement Projects Levy 375,000 440,000 451,000 462,275 473,832 485,678 497,820 510,266 523,023 536,099 85 Economic Devlopment Authority Levy 5,300 - 86 87 Total Other Special Levy 785,300 730,000 770,125 789,378 809,113 829,341 850,074 871,326 893,110 915,439 88 89 Total Tax Levy 2,996,852 3,118,194 3,308,080 3,429,647 3,592,674 3,711,624 3,807,067 3,914,105 3,991,932 4,100,645 90 Increase/(Decrease) in Total Tax Levy 6.89%4.05%6.09%3.67%4.75%3.31%2.57%2.81%1.99%2.72% 91 Less: Fiscal Disparities (107,857)(123,679)(109,591)(113,646)(117,822)(123,466)(127,492)(130,740)(134,428)(137,062) 92 Net Levy to Taxpayers 2,888,995 2,994,515 3,198,489 3,316,001 3,474,852 3,588,158 3,679,575 3,783,365 3,857,504 3,963,583 93 Levy % Change 7.79% 3.65% 0 0 0 0 0 0 0 0 94 Existing Tax Base 10,818,416 10,758,518 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 95 96 Tax Base % Change 6.80% -0.55% 3.00% 0 0 0 0 0 0 0 97 New Net Tax Capacity 0 0 0 0 0 0 0 0 0 0 98 Total Net Tax Capacity 10,818,416 10,758,518 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 11,081,274 99 100 Tax Rate on Tax Capacity 26.704%27.834%28.864%29.924%31.358%32.380%33.205%34.142%34.811%35.768% 101 Tax Rate % Change 0.93% 4.23% 3.70% 3.67% 4.79% 3.26% 2.55% 2.82% 1.96% 2.75% 102 Average Tax Rate since 2017 30.313% -2.95% 103 104 Existing Estimated Tax Base Inflation / (Deflation) 2.0% -1.3% 3.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Capital Improvement Fund 401 5 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 11 2024 2025 2026 2027 2028 2029 2030 2031 2032 12 Actual Approved Projected 13 REVENUE 14 Property taxes 235,000 125,000 150,000 153,750 157,594 161,534 165,572 169,711 173,954 15 Intergovernmental - - - - - - - - - 16 Charges for services - - - - - - - - - 17 Special assessments - - - - - - - - - 18 Investment Income 1,500 1,000 1,015 1,030 1,045 1,061 1,077 1,093 1,109 19 Sale of capital assets - - - - - - - - - 20 Refunds and Reimbursements - - - - - - - - - 21 Park Dedication Fees - - - - - - - - - 22 Rental and lease income - - - - - - - - - 23 Transfer from General Fund - - - - - - - - - 24 Miscellaneous Revenue - - - - - - - - - 25 Total Revenue 236,500 126,000 151,015 154,780 158,639 162,595 166,649 170,804 175,063 26 27 EXPENSES 28 Total Current - - - - - - - - - 29 Payables internet - - - - - - - - - 30 Total Capital Projects 312,525 229,041 611,432 160,125 193,399 31,633 358,084 159,251 618,083 31 Total Expenses 312,525 229,041 611,432 160,125 193,399 31,633 358,084 159,251 618,083 32 33 Revenue Over / (Under) Expenses (76,025) (103,041) (460,417) (5,345) (34,760) 130,962 (191,435) 11,553 (443,020) 34 35 OTHER FINANCING SOURCES / (USES) 36 Bond Proceeds - - - - - - - - - 37 Bond premium - - - - - - - - - 38 Transfers In - - - - - - - - - 39 Transfers Out (150,000) - - - - - - - - 40 Total Other Sources / (Uses)(150,000) - - - - - - - - 41 adjustment to make numbers match - - - - - - - - - 42 Prior Period Adjustments - - - - - - - - - 43 Ending Fund Balance 556,867 453,826 (6,591) (11,936) (46,696) 84,266 (107,169) (95,616) (538,636) 44CASH FLOW ANALYSIS 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Capital Improvement Fund 401 5 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 45 2024 2025 2026 2027 2028 2029 2030 2031 2032 46 Priority Project#Capital Project Name Actual Approved Projected 47 n/a Community Center Kitchen Floor 25,000 48 2 A-008 Broadband Development Grants to MIDCO 92,000 300,000 49 n/a Community Center Hall Floor 25,000 50 Communty Center Ceiling Tiles 25,000 51 2 CC-010 Community Center Improvements-Doors & security 52 CC-013 Community Center Hall HVAC Upgrades 50,000 53 2 A-012 County Ped & Bicycle Accomodations 54 2 CC-013 Council Chambers remodel 55 1 F-039 Wall Panel Joint Replacement Fire Hall-leaking 56 2 PW-047 Cold Storage Building 130,000 31,000 57 3 SW-003 Bliss Additions Stormwater plan 122,525 135,000 58 1 Community Center Roof Replacement 60,000 100,000 59 3 F-003 2010 Fire Radios Replace 3 unspupported radios 17,548 24,016 60 4 F-027 2015 Lucas CPR Device-replacement 17,548 24,016 61 3 F-037 2010 Homatro Cutter Twin Line R-1(Jaws of Life) 40,945 56,036 62 2 SW-003 Gateway Trail 30,000 230,000 63 n/a CC-017 Additional Comm Cent Elec Locks 18,000 24,016 64 1 F-008 Fire/PW Potable Well Pump (2000) Replacement 11,699 65 4 F-034 2017 Thermal Imaging Cameras (1of3) find hot spots 9,733 13,853 66 2 CC-014 Security Improvements CCTV for Park 14,000 67 2 F-041 2000 Station Bay floor epoxy coating-maintenance 20,000 31,171 68 2 F-042 2010 Washer/Extractor-replacement 9,125 12,988 69 n/a F-009 new Warning Sirens 31,633 70 n/a F-032 new Exhaust removal system for truck bays 58,399 71 Salt Storage Building Expansion 100,000 72 3 F-038 Zoll Monitor/Defib 51,239 73 2 CC-018 Community Center Design & Planning 280,947 74 2 F-016 Second Fire Station 337,136 75 Warming House Roof Replacement 30,000 76 Warming House ADA Updates 50,000 77 n/a F-035 Air Containment Unit 78 Thermal Camera FLIR K65, E-1 7,000 7,000 79 PW/Fire Air Compressor 10,000 80 PW Vehicle Pressure Washer 10,000 81 CIP placeholder - SERVER REPLACEMENT 82 Total Capital Projects 312,525 229,041 611,432 160,125 193,399 31,633 358,084 159,251 618,083 CAPITAL IMPROVEMENT CAPITAL OUTLAY 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Park Improvement Fund 404 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 11 2024 2025 2026 2027 2028 2029 2030 2031 2032 12 Actual Approved Projected 13 REVENUE 14 Property taxes 60,000 40,000 41,000 42,025 43,076 44,153 45,257 46,388 47,548 15 Intergovernmental - - - - - - - - - 16 Charges for services - - - - - - - - - 17 Special Assessments - - - - - - - - - 18 Investment Income 66 66 67 68 69 70 71 72 73 19 Sale of capital assets - - - - - - - - - 20 Refunds and Reimbursements - - - - - - - - - 21 Park Dedication Fees 24,000 - - - - - - - - 22 Rental and lease income - - - - - - - - - 23 Transfer from General Fund 125,000 - - - - - - - - 24 Miscellaneous Revenue - - - - - - - - - 25 Total Revenue 209,066 40,066 41,067 42,093 43,145 44,223 45,328 46,460 47,621 26 27 EXPENSES 28 Total Current - - - - - - - - - 29 Payables internet - - - - - - - - - 30 Total Capital Projects 335,000 115,000 25,000 14,674 200,000 40,000 117,391 - - 31 Total Expenses 335,000 115,000 25,000 14,674 200,000 40,000 117,391 - - 32 33 Revenue Over / (Under) Expenses (125,934) (74,934) 16,067 27,419 (156,855) 4,223 (72,063) 46,460 47,621 34 35 OTHER FINANCING SOURCES / (USES) 36 Bond Proceeds - - - - - - - - - 37 Bond premium - - - - - - - - - 38 Transfers In 150,000 - - - - - - - - 39 Transfers Out - - - - - - - - - 40 Total Other Sources / (Uses)150,000 - - - - - - - - 41 adjustment to make numbers match - - - - - - - - - 42 Prior Period Adjustments - - - - - - - - - 43 Ending Fund Balance 87,993 13,059 29,126 56,545 (100,310) (96,087) (168,150) (121,690) (74,069) 44CASH FLOW ANALYSIS 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Park Improvement Fund 404 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 45 2024 2025 2026 2027 2028 2029 2030 2031 2032 46 Priority Project #Capital Project Name Actual Approved Projected 47 48 PR-043 Community Center Park-concrete, grill, table, benches 49 PR-048 Lilleskogen Praire/Wetland Restoration Project 50 PR-054 Lilleskogen Park Picnic Shelter 51 PR-060 Park Planning 52 PR-055 Hay Lake Park - sign 53 PR-057 Playground Equipment - Community Center Park 54 PR-057 Replace rink boards 55 PR-061 Park signage at Orwell Park (Liten) 56 PR-058 Tennis Court/Pickle Ball - repaint 335,000 115,000 57 PR-063 Gateway Trail Improvements @ Annex 25,000 58 PR-066 Expanded Pleasure Rink 14,674 59 PR-064 Playground Equipment - Erickson ballfield 100,000 60 PR-050 Ballfield Reconstruction - Erickson ballfield 40,000 61 PR-059 Hay Lake Park Shelter water & doors 117,391 62 Wayne Erickson Pavillion/Storage 100,000 63 PR-044 Nature park trails 64 65 CIP Place Holder 66 Total Capital Projects 335,000 115,000 25,000 14,674 200,000 40,000 117,391 - - PARK IMPROVEMENT CAPITAL OUTLAY 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Equipment Replacement Fund 406 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 7.17% 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 11 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 12 Actual Approved Projected 13 REVENUE 14 Property taxes - 110,000 125,000 128,125 131,328 134,611 137,976 141,425 144,961 148,585 15 Intergovernmental - - - - - - - - - - 16 Charges for services - - - - - - - - - - 17 Special assessments - - - - - - - - - - 18 Investment Income 1,030 1,045 1,061 1,077 1,093 1,109 1,126 1,143 1,160 1,177 19 Sale of capital assets 19,500 45,219 70,900 - - - - - - 20 Refunds and Reimbursements - - - - - - - - - - 21 Park Dedication Fees - - - - - - - - - - 22 Rental and lease income - - - - - - - - - - 23 Transfer from General Fund - - - - - - - - - - 24 Miscellaneous Revenue 176,000 - - - - - - - - - 25 Total Revenue 196,530 156,264 196,961 129,202 132,421 135,720 139,102 142,568 146,121 149,762 26 27 EXPENSES - Paid in debt service fund 28 Total Current - - - - - - - - - - 29 Payables internet - - - - - - - - - - 30 Total Capital Projects 101,967 527,721 592,296 72,583 425,000 104,000 467,000 356,000 297,609 - 31 Total Expenses 101,967 527,721 592,296 72,583 425,000 104,000 467,000 356,000 297,609 - 32 33 Revenue Over / (Under) Expenses 94,563 (371,457) (395,335) 56,619 (292,579) 31,720 (327,898) (213,432) (151,488) 149,762 34 35 OTHER FINANCING SOURCES / (USES) 36 Bond Proceeds - 340,000 300,000 - 250,000 - 250,000 300,000 - 350,000 37 Bond premium - - - - - - - - - - 38 Transfers In - - - - - - - - - 39 Transfers Out - - - - - - - - - - 40 Total Other Sources / (Uses) - 340,000 300,000 - 250,000 - 250,000 300,000 - 350,000 41 adjustment to make numbers match (153,690) - 1,857 - - - - - - - 42 Prior Period Adjustments - - - - - - - - - - 43 Ending Fund Balance 147,621 116,164 22,686 79,305 36,726 68,446 (9,452) 77,116 (74,372) 425,390 44CASH FLOW ANALYSIS 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Equipment Replacement Fund 406 4 5 Inflation Assumptions 6 Revenue (Non-property tax) 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 7.17% 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 45 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 46 Priority Project #Capital Project Name Actual Approved Projected 47 PW-014 John Deere 6130M (2021) tractor w/ attachments 48 PW-009 2003 Tanker 5178 Tender 2 Replacement 10,000 101,987 286,787 49 PW-017 Wall Panel Joint Replacement Fire Hall-leaking 16,250 50 Fire 2003 Boat & Trailer - water rescues 12,717 38,192 51 52 Fire 2000 Engine 1 - 5176 Replacement 142,789 53 PW-015 New Holland 325 Skid Steer (2024) 60,368 54 PW-021 Ford F550 Dump Truck (2024) 100,312 55 Fire F150 Chief Vehicle 61,117 56 PW-028 Equipment Attachments (fit skid, loader, tractor) 22,956 57 PW-012 203-11 Mack Dump Truck/Plow Replacement (2011) 305,509 58 PW-027 Addition Vehicle (truck for addl FT or PT staff) 60,000 59 PW-029 PJ Skid Trailer 14,000 lbs (2012) 20,000 60 PW-031 Utility Trailer 3,500 lbs (1998) 10,000 61 Fire 2012 UTV & Trailer replacement off road rescue 42,583 60,609 62 PW-007 312-08 Asphalt Patching Equipment Trailer (2008) 25,000 63 PW-011 202-17 Western Star Single Axle Truck/Plow (2017) 400,000 64 PW-018 101-18 Chev 1/2 ton pickup (2018) 44,000 65 PW-010 201-14 Mack Single Axle w/Plow (2014) 415,000 66 PW-019 102-19 Dodge 3500 SRW w/plow (2019) 52,000 67 PW-025 John Deere 1575 w/ broom and blower 63,000 115,000 68 PW-026 304-21 Kubota UTV (2021) 16,000 69 Fire Rescue 5179 Replacement 225,000 70 PW-020 103-21 Dodge 2500 w/plow (2021) 62,000 71 John Deere 324L Loader 175,000 72 73 adjustment to make numbers match 74 75 76 77 78 79 80 81 101,967 527,721 592,296 72,583 425,000 104,000 467,000 356,000 297,609 - EQUIPMENT REPLACEMENT CAPITAL OUTLAY 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Local Road Improvement Fund 408 4 5 Inflation Assumptions 6 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% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 11 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 12 Actual Approved Projected 13 REVENUE 14 Property taxes 375,000 440,000 451,000 462,275 473,832 485,678 497,820 510,266 523,023 536,099 750,000 15 Intergovermental 63,082 92,350 94,197 96,081 98,003 99,963 101,962 104,001 106,081 108,203 110,367 16 Charges for services - - - - - - - - - - - 17 Special assessments - - - - - - - - - - - 18 Investment Income 2,334 10,000 10,150 10,302 10,457 10,614 10,773 10,935 11,099 11,265 11,434 19 Sale of capital assets - - - - - - - - - - - 20 Refunds and Reimbursements - - - - - - - - - - - 21 Park Dedication Fees - - - - - - - - - - - 22 Rental and lease income - - - - - - - - - - - 23 Transfer from General Fund - - - - - - - - - - - 24 Miscellaneous Revenue - - - - - - - - - - - 25 Total Revenue 440,416 542,350 555,347 568,658 582,292 596,255 610,555 625,202 640,203 655,567 871,801 26 27 EXPENSES 28 Total Current - - - - - - - - - - - 29 Payables internet - - - - - - - - - - - 30 Total Capital Projects 3,840,745 610,000 550,000 800,000 650,000 - 1,100,000 600,000 600,000 4,000,000 750,000 31 Total Expenses 3,840,745 610,000 550,000 800,000 650,000 - 1,100,000 600,000 600,000 4,000,000 750,000 32 33 Revenue Over / (Under) Expenses (3,400,329) (67,650) 5,347 (231,342) (67,708) 596,255 (489,445) 25,202 40,203 (3,344,433) 121,801 34 35 OTHER FINANCING SOURCES / (USES) 36 Bond Proceeds 3,862,403 - - - - - - - 3,000,000 - 37 Bond premium - - - - - - - - - - - 38 Transfers In - - - - - - - - - - - 39 Transfers Out - - - - - - - - - - - 40 Total Other Sources / (Uses) 3,862,403 - - - - - - - - 3,000,000 - 41 adjustment to make numbers match 9,253 - - - - - - - - - 42 Prior Period Adjustments - - - - - - - - - - - 43 Ending Fund Balance 626,946 559,296 564,643 333,301 265,593 861,848 372,403 397,605 437,808 93,375 215,176 44 CASH FLOW ANALYSIS 1 CITY OF SCANDIA 2 Capital Improvement Plan 3 Local Road Improvement Fund 408 4 5 Inflation Assumptions 6 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% 7 Interest Earnings 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 1.50% 8 Expenses 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 3.00% 9 CIP Inflation Factor 6.26% 3.30% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 10 45 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 46 Priority Project #Capital Project Name Actual Approved Projected 47 48 PW-061 Soil Borings for 2024 & 2025 49 PW-062 Soil Borings for 2026 & 2027 50 PW-069 Soil Borings for 2028 & 2029 51 Soil Borings for 2030 & 2031 52 PW-070 Engineering Fees 53 PW-043 2022 Local Road Improvement Project 600,000 54 PW-043 2023 Local Road Improvement Project 4,000,000 55 PW-056 2024 Local Road Improvement Project 3,385,745 750,000 56 PW-053 2025 Local Road Improvement Project 610,000 57 PW-035 2026 Local Road Improvement Project 550,000 58 PW-057 2027 Local Road Improvement Project 800,000 59 PW-036 2028 Local Road Improvement Project 650,000 60 PW-060 2029 Local Road Improvement Project - 61 PW-072 2030 Local Road Improvement Project 1,100,000 62 PW-073 2031 Local Road Improvement Project 600,000 63 PW-050 2023 Seal Coat & Crack Filling Project 64 PW-2024 Seal Coat & Crack Filling Project 455,000 65 PW-052 2025 Seal Coat & Crack Filling Project 66 PW-051 2026 Seal Coat & Crack Filling Project 67 PW-060 2027 Seal Coat & Crack Filling Project 68 2028 Seal Coat & Crack Filling Project 69 2029 Seal Coat & Crack Filling Project 70 2030 Seal Coat & Crack Filling Project 71 2031 Seal Coat & Crack Filling Project 72 73 74 75 76 77 Total Capital Projects 3,840,745 610,000 550,000 800,000 650,000 - 1,100,000 600,000 600,000 4,000,000 750,000 LOCAL ROAD IMPROVEMENT CAPITAL OUTLAY