Loading...
7.d CIP Fund 406Inflation 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.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%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%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% 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Actual Budget Projected REVENUE 5 Property taxes 130,000 87,800 - 125,000 130,000 135,200 140,608 146,232 152,082 158,165 164,491 171,071 177,914 6 Debt service levy 0 - 78,779 189,562 232,644 269,572 269,572 343,427 343,427 343,427 343,427 7 Intergovernmental 0 - - - - - - - - - - - - 8 Sale of capital assets 42,038 35,000 - - - - - - - - - 9 Investment Income 657 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 0 11 Park Dedication Fees 0 12 Rental and lease income 0 - - - - - - - - - - - - 13 Miscellaneous Revenue 0 - 176,000 14 Total Revenue 172,695 88,815 212,030 126,045 209,840 325,839 374,345 416,913 422,779 502,735 509,078 515,675 522,536 EXPENSES 15 Total Current - - - - - - - - - - - 16 Debt service - - - 75,028 180,535 221,566 256,735 256,735 327,073 327,073 327,073 327,073 17 Total Capital Projects 40,073 198,500 213,750 951,356 984,871 350,000 607,353 57,901 550,165 449,767 91,775 - - 18 Total Expenses 40,073 198,500 213,750 951,356 1,059,899 530,535 828,919 314,636 806,900 776,840 418,848 327,073 327,073 19 Revenue Over / (Under) Expenses 132,622 (109,685) (1,720) (825,311) (850,059) (204,696) (454,574) 102,277 (384,120) (274,105) 90,230 188,602 195,463 OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 0 640,000 900,000 350,000 300,000 600,000 - 21 Transfers In 0 22 Transfers Out 0 23 Transfers Out- 0 24 Total Other Sources / (Uses)0 - - 640,000 900,000 350,000 300,000 - 600,000 - - - - 25 Prior Period Adjustments 328 26 Ending Fund Balance 316,433 206,748 205,028 19,717 69,658 214,962 60,388 162,665 378,545 104,440 194,670 383,271 578,734 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 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 Capital Project Name First Year Last Year Costs Budget Budget Projected 27 312-08 Asphalt Patching Equipment Trailer (2008) 2025 39000 45,624 28 2000 Engine 1 - 5176 Replacement 2025 650000 850,000 29 2003 Tanker 5178 Tender 2 Replacement 2024 292000 425,000 30 201-14 Mack Single Axle w/Plow (2014) 2026 275000 350,000 31 202-17 Western Star Single Axle Truck/Plow (2017) 2029 350000 478,999 32 203-11 Mack Dump Truck/Plow Replacement (2011) 2023 325000 325,000 33 301-98 John Deere Motor Grader (1998) 2027 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 90,000 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 84,356 41 1995 Utility 1misc purpose truck - replacement 2023 86500 86,500 42 2003 Boat & Trailer - water rescues 2023 38000 38,000 43 303-17 Kubota F39000 Mower w/Broom & Blower (2017) 2023 65000 73,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 27,000 48 PJ Skid Trailer 14,000 lbs (2012) 2025 17000 19,888 49 Rescue 5179 Replacement 2030 225000 320,245 50 Utility Trailer 3,500 lbs (1998)2025 8000 9,359 52 Total Capital Projects 3,514,750 - 198,500 213,750 951,356 984,871 350,000 607,353 57,901 550,165 449,767 91,775 - - PROJECTED NEW DEBT TERMS KHM As of Date:6/27/2023 53 Par Amount (Line 14)- - - 640,000 900,000 350,000 300,000 - 600,000 - - - - 54 Number of Years 10 10 10 10 10 10 10 10 10 10 10 10 10 55 Interest Rate 3.00%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 0 78,779 189,562 232,644 269,572 269,572 343,427 343,427 343,427 343,427 Ca p i t a l E q u i p m e n t O u t l a y Project