Loading...
07. 401 CIP FundInflation 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 235,000 - 75,000 78,000 81,120 84,365 87,739 91,249 94,899 6 Intergovernmental - - - - - - - - 7 Capital Improvement Debt Levy - - - - - - - - 8 Special assessments - - - - - - - - - - - 9 Investment Income 3,126 2,300 1,500 1,000 1,000 1,000 1,000 1,000 1,000 1,000 1,000 10 Refunds and Reimbursements 11 Park Dedication Fees 12 Rental and lease income - - - - - - - - - - - 13 Miscellaneous Revenue - - - - - - - - - - 14 Total Revenue 220,462 296,091 236,500 1,000 76,000 79,000 82,120 85,365 88,739 92,249 95,899 EXPENSES 15 Total Current - - - - - - - - - - - 16 Payables internet - - - - - - - - - - - 17 Debt service - - - - - - - - - - - 18 Total Capital Projects 296,733 198,059 287,548 235,001 645,072 247,185 - 112,072 208,135 169,859 618,083 19 Total Expenses 296,733 198,059 287,548 235,001 645,072 247,185 - 112,072 208,135 169,859 618,083 20 Revenue Over / (Under) Expenses (76,271) 98,032 (51,048) (234,001) (569,072) (168,185) 82,120 (26,707) (119,395) (77,610) (522,184) OTHER FINANCING SOURCES / (USES) 21 Bond Proceeds 22 Transfers In - 8,000 - - - - - - - - - 23 Transfers Out to Sewer Fund (2,640) 24 Transfers Out- 250,000 25 Total Other Sources / (Uses) - 5,360 250,000 - - - - - - - - 26 accounts payable 27 Prior Period Adjustments 28 Ending Fund Balance 564,735 782,892 981,844 747,843 178,771 10,586 92,706 65,999 (53,396) (131,007) (557,292) CASH FLOW ANALYSISCITY OF SCANDIA CITY OF SCANDIA Capital Improvement Plan Capital Improvement Plan Capital Improvement Fund 401 Capital Improvement Fund 401 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 15,000 160,000 35 Broadband Development Grants to MIDCO 2023 12,750 119,500 92,000 300,000 108,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 220,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 0 44 Arts & Heritage Center Sidewalk and Walkways 2027 45 CC AC Condenser Replacement 2025 37,960 46 Lobbying 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 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 287,548 235,001 645,072 247,185 - 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