Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07a. 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 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 114,400 118,976 123,735 128,684 133,832 139,185 144,752 150,543 156,564 6 Debt service levy - 43,082 92,319 178,483 215,411 215,411 295,421 295,421 295,421 295,421 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 158,543 212,372 303,311 345,204 350,369 435,749 441,333 447,140 453,180 EXPENSES 15 Total Current - - - - - - - - - - - 16 Debt service - - - 41,031 87,923 169,984 205,153 205,153 281,353 281,353 281,353 281,353 17 Total Capital Projects 198,500 208,750 526,356 524,871 850,000 478,999 57,901 446,166 449,767 699,128 - - 18 Total Expenses 198,500 208,750 526,356 565,902 937,923 648,983 263,054 651,319 731,120 980,481 281,353 281,353 19 Revenue Over / (Under) Expenses (109,685) (12,220) (415,311) (407,358) (725,551) (345,672) 82,150 (300,950) (295,371) (539,148) 165,787 171,827 OTHER FINANCING SOURCES / (USES) 20 Bond Proceeds 350,000 400,000 700,000 300,000 650,000 - 21 Transfers In 22 Transfers Out 23 Transfers Out- 24 Total Other Sources / (Uses)- - 350,000 400,000 700,000 300,000 - 650,000 - - - - 25 Prior Period Adjustments 26 Ending Fund Balance 206,748 194,528 129,217 121,858 96,307 50,636 132,786 481,836 186,465 (352,683)(186,896)(15,069) CITY OF SCANDIA Capital Improvement Plan Equipment Replacement Fund 406 CASH FLOW ANALYSIS 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 45,624 28 2000 Engine 1 - 5176 Replacement 2026 650000 850,000 29 2003 Tanker 5178 Tender 2 Replacement 2025 292000 10,000 390,000 30 201-14 Mack Single Axle w/Plow (2014) 2029 275000 375,000 31 202-17 Western Star Single Axle Truck/Plow (2017) 2027 350000 478,999 32 203-11 Mack Dump Truck/Plow Replacement (2011) 2023 325000 325,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 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 68,500 42 2003 Boat & Trailer - water rescues 2023 38000 51,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 208,750 526,356 524,871 850,000 478,999 57,901 446,166 449,767 699,128 - - PROJECTED NEW DEBT TERMS KHM As of Date:6/27/2023 53 Par Amount (Line 14)- - 350,000 400,000 700,000 300,000 - 650,000 - - - - 54 Number of Years 10 10 10 10 10 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 43,082 92,319 178,483 215,411 215,411 295,421 295,421 295,421 295,421Capital Equipment OutlayProject