Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
7. 401 CIP Fund Spreadsheet
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 300,000 312,000 324,480 337,459 350,958 364,996 379,596 394,780 410,571 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 303,000 315,000 327,480 340,459 353,958 367,996 382,596 397,780 413,571 EXPENSES 15 Total Current - - - - - - - - - - - 16 Payables internet - - - - - - - - - - - 17 Debt service - - - - - - - - - - - 18 Total Capital Projects 296,733 257,225 457,548 668,001 185,072 389,185 230,000 112,072 208,135 169,859 618,083 19 Total Expenses 296,733 257,225 457,548 668,001 185,072 389,185 230,000 112,072 208,135 169,859 618,083 20 Revenue Over / (Under) Expenses (76,271) 38,866 (154,548) (353,001) 142,408 (48,726) 123,958 255,924 174,461 227,920 (204,513) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 22 Transfers In - - - - - - - - - - - 23 Transfers Out to Sewer Fund 24 Transfers Out- 25 Total Other Sources / (Uses) - - - - - - - - - - - 26 accounts payable 27 Prior Period Adjustments 28 Ending Fund Balance 564,735 603,601 449,053 96,052 238,460 189,734 313,692 569,616 744,077 971,997 1,181,055 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 250,000 250,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 40,000 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 30,000 63 CIP placeholder - SERVER REPLACEMENT 2035 7,800 Total Capital Projects 296,733 7,476 198,059 457,548 668,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