Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11.a5 406 CIP Fund
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.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 - 110,000 110,000 114,400 118,976 123,735 128,684 133,832 139,185 144,752 150,543 6 Debt service levy 0 - 80,010 190,793 240,029 276,957 276,957 356,967 356,967 356,967 356,967 7 Intergovernmental 0 - - - - - - - - - - - - 8 Sale of capital assets 42,038 - - - - - - - - - 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 177,030 111,045 191,071 306,270 360,098 401,801 406,768 491,942 497,312 502,896 508,704 EXPENSES 15 Total Current - - - - - - - - - - - 16 Debt service - - - 76,200 181,707 228,599 263,769 263,769 339,968 339,968 339,968 339,968 17 Total Capital Projects 40,073 198,500 203,750 951,356 984,871 350,000 607,353 57,901 550,165 449,767 91,775 - - 18 Total Expenses 40,073 198,500 203,750 951,356 1,061,071 531,707 835,952 321,670 813,933 789,735 431,744 339,968 339,968 19 Revenue Over / (Under) Expenses 132,622 (109,685) (26,720) (840,311) (870,000) (225,438) (475,854) 80,131 (407,166) (297,793) 65,568 162,928 168,736 OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 0 650,000 900,000 400,000 300,000 650,000 - 21 Transfers In 0 22 Transfers Out 0 23 Transfers Out- 0 24 Total Other Sources / (Uses)0 - - 650,000 900,000 400,000 300,000 - 650,000 - - - - 25 Prior Period Adjustments 328 26 Ending Fund Balance 316,433 206,748 180,028 (10,283)19,717 194,279 18,425 98,556 341,391 43,597 109,166 272,094 440,830 CITY OF SCANDIA Capital Improvement Plan Equipment Replacement Fund 406 CASH FLOW ANALYSIS 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 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 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 203,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)- - - 650,000 900,000 400,000 300,000 - 650,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 80,010 190,793 240,029 276,957 276,957 356,967 356,967 356,967 356,967Capital Equipment OutlayProject