Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
6. 401 CIP Fund Spreadsheet - Updated
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 200,000 208,000 216,320 224,973 233,972 243,331 253,064 263,186 273,714 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 203,000 211,000 219,320 227,973 236,972 246,331 256,064 266,186 276,714 EXPENSES 15 Total Current - - - - - - - - - - - 16 Payables internet - - - - - - - - - - - 17 Debt service - - - - - - - - - - - 18 Total Capital Projects 296,733 257,225 327,548 518,001 185,072 389,185 230,000 112,072 208,135 169,859 618,083 19 Total Expenses 296,733 257,225 327,548 518,001 185,072 389,185 230,000 112,072 208,135 169,859 618,083 20 Revenue Over / (Under) Expenses (76,271) 38,866 (124,548) (307,001) 34,248 (161,212) 6,972 134,258 47,929 96,327 (341,370) 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 479,053 172,052 206,300 45,088 52,060 186,318 234,247 330,574 265,918 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 100,000 100,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 50,000 63 CIP placeholder - SERVER REPLACEMENT 2035 7,800 Total Capital Projects 296,733 7,476 198,059 327,548 518,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