Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6b. 401 CIP Fund
Inflation Assumptions 1 Revenue (Non-property tax) 0.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2 Interest Earnings 0.00% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3.50% 3 Expenses 0.00% 4 CIP Inflation Factor 0.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2022 2023 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 ACTUAL ACTUAL Projected REVENUE 5 Property taxes 217,336 293,791 215,000 215,000 223,600 232,544 241,846 251,520 261,580 272,044 282,925 6 Intergovernmental - - - - - - - - 7 Capital Improvement Debt Levy - - - - - - - - 8 Special assessments - - - - - - - - - - - 9 Investment Income 3,126 2,300 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 3,000 10 Refunds and Reimbursements 11 Park Dedication Fees 12 Rental and lease income - - - - - - - - - - - 13 Miscellaneous Revenue - - - - - - - - - - 14 Total Revenue 220,462 296,091 218,000 218,000 226,600 235,544 244,846 254,520 264,580 275,044 285,925 EXPENSES 15 Total Current - - - - - - - - - - - 16 Payables internet - - - - - - - - - - - 17 Debt service - - - - - - - - - - - 18 Total Capital Projects 296,733 257,225 377,548 528,001 185,072 389,185 230,000 112,072 208,135 169,859 618,083 19 Total Expenses 296,733 257,225 377,548 528,001 185,072 389,185 230,000 112,072 208,135 169,859 618,083 20 Revenue Over / (Under) Expenses (76,271) 38,866 (159,548) (310,001) 41,528 (153,641) 14,846 142,447 56,446 105,184 (332,158) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 22 Transfers In - 8,000 - - - - - - - - - 23 Transfers Out to Sewer Fund (2,640) 24 Transfers Out- 25 Total Other Sources / (Uses) - 5,360 - - - - - - - - - 26 accounts payable 27 Prior Period Adjustments 28 Ending Fund Balance 564,735 608,961 449,413 139,412 180,940 27,299 42,145 184,592 241,038 346,222 299,989 CITY OF SCANDIA CITY OF SCANDIA Capital Improvement Plan Capital Improvement Plan Capital Improvement Fund 401 Capital Improvement Fund 401 CASH FLOW ANALYSIS 2022 2023 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 Capital Project Name Year ACTUAL ACTUAL PROJECTED 29 12,000 30 Broadband Development Grants to MIDCO 2022 236,700 31 Development Code Update 2022 5,771 32 Community Center Improvements-Doors & security 2022 16,609 33 Council Chambers remodel 2022 5,103 7,476 34 Gateway Trail 2025 250,000 35 Broadband Development Grants to MIDCO 2023 12,750 119,500 150,000 150,000 36 County Ped & Bicycle Accomodations 2023 50,000 37 Wall Panel Joint Replacement Fire Hall-leaking 2023 16,250 38 Council Chambers remodel 2023 12,309 39 Security Improvements CCTV for Park 2024 14,000 40 Bliss Additions Stormwater plan 2023 160,000 139,185 41 new Exhaust removal system for truck bays 2024 58,399 42 new Warning Sirens 2025 31,633 43 Arts & Heritage Center Amphitheater 2027 - 44 Arts & Heritage Center Sidewalk and Walkways 2027 250,000 45 CC AC Condenser Replacement 2025 37,960 46 Gateway Trail 2025 47 Fire/PW Potable Well Pump (2000) Replacement 2026 11,699 48 2010 Fire Radios Replace 3 unspupported radios 2030 17,548 24,016 49 2010 Homatro Cutter Twin Line R-1(Jaws of Life)2030 40,945 56,036 50 2015 Lucas CPR Device-replacement 2030 17,548 24,016 51 Cold Storage Building 2030 112,072 52 Additional Comm Cent Elec Locks 2030 17,548 24,016 53 Large Hall and Heritage Room Carpeting 2030 80,052 54 2000 Station Bay floor epoxy coating-maintenance 2031 21,900 31,171 55 2010 Washer/Extractor-replacement 2031 9,125 12,988 56 2012 UTV & Trailer replacement-off road rescue 2031 42,583 60,609 57 2017 Thermal Imaging Cameras (1of3) find hot spots 2031 9,733 13,853 58 Zoll Monitor/Defib 2031 51,239 59 Second Fire Station 2032 230,000 337,136 60 Community Center Design & Planning 2032 280,947 61 Air Containment Unit 2033 62 Community Center Improvements-Front Office + Equip Room 50,000 63 CIP placeholder - SERVER REPLACEMENT 2035 7,800 Total Capital Projects 296,733 7,476 198,059 377,548 528,001 185,072 389,185 230,000 112,072 208,135 169,859 618,083 PROJECTED NEW DEBT TERMS Updated KHM As of Date:6/27/2023 1 Par Amount (Line 14) - - - - - - - - - - - 2 Number of Years 15 15 15 15 15 15 15 15 15 15 15 3 Interest Rate 0 0 0 0 0 0 0 0 0 0 0 4 New Debt Levy - - - - - - - - - - - Capital Project OutlayCapital Project OutlayProject