Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
2)f. Sources and Uses of Funds 08-05-22
Capital Improvement Program City of Scandia, Minnesota SOURCES AND USES OF FUNDS FY '23 FY '27thru 401 Capital Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 845,402 616,802 1,237,777 1,499,388 1,528,623Beginning Balance Revenues and Other Fund Sources Revenue 0 0 (96,750) (96,750) (96,750)(Less) Debt Service Payment 0 1,100,000 0 0 0Bond Proceeds 0 0 96,750 96,750 96,750Debt Service Levy 2,300 14,268 23,583 27,576 28,083Investment Income 420,100 185,000 472,000 85,000 50,000Property Tax Levy 422,400 1,299,268 495,583 112,576 78,083Total 1,267,802 1,916,070 1,733,360 1,611,964 1,606,706Total Funds Available 422,400 1,299,268 495,583 112,576 78,083Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Administration (432,000) (281,216) 0 0 0Broadband Development Grants to MIDCO A-008 (432,000) (281,216) 0 0 0Total Community Center 0 0 (58,493) 0 0Large Hall and Heritage Room Carpeting CC=016 (40,000) 0 0 0 0Council Chambers remodel CC-013 (14,000) 0 0 0 0Security Improvements CCTV for Park CC-014 0 (33,746) 0 0 0CC AC Condenser Replacement CC-015 0 0 (17,548) 0 0Additional Comm Cent Elec Locks CC-017 0 0 0 0 (189,798)Community Center Design & Planning CC-018 (54,000) (33,746) (76,041) 0 (189,798)Total Fire 0 0 (17,548) 0 02010 Fire Radios Replace 3 unspupported radios F-003 0 (28,122) 0 0 0new Warning Sirens F-009 0 0 0 0 (227,757)Second Fire Station F-016 0 0 (17,548) 0 02015 Lucas CPR Device-replacement F-027 0 (53,993) 0 0 0new Exhaust removal system for truck bays F-032 0 0 0 (42,583) 02012 UTV & Trailer replacement-off road rescue F-033 0 0 0 (9,733) 02017 Thermal Imaging Cameras (1of3) find hot spots F-034 0 0 (40,945) 0 02010 Homatro Cutter Twin Line R-1(Jaws of Life)F-037 Friday, August 5, 2022Page 1DRAFT for 2021-2030 7/29/2022 401 Capital Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 (65,000) 0 0 0 0Wall Panel Joint Replacement Fire Hall-leaking F-039 0 0 0 (21,900) 02000 Station Bay floor epoxy coating-maintenance F-041 0 0 0 (9,125) 02010 Washer/Extractor-replacement F-042 (65,000) (82,115) (76,041) (83,341) (227,757)Total Parks and Recreation 0 (33,746) 0 0 0Arts & Heritage Center Amphitheater PR-052 0 (123,735) 0 0 0Arts & Heritage Center Sidewalk and Walkways PR-065 0 (157,481) 0 0 0Total Public Works 0 0 (81,890) 0 0Cold Storage Building PW-047 0 0 (81,890) 0 0Total Stormwater (100,000) (123,735) 0 0 0Bliss Additions Stormwater plan SW-003 (100,000) (123,735) 0 0 0Total (651,000) (678,293) (233,972) (83,341) (417,555)Total Expenditures and Uses 616,802 1,237,777 1,499,388 1,528,623 1,189,151Ending Balance (228,600) 620,975 261,611 29,235 (339,472)Change in Fund Balance Friday, August 5, 2022Page 2DRAFT for 2021-2030 7/29/2022 404 Park Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 148,216 105,835 13,851 (22,531) (10,064)Beginning Balance Revenues and Other Fund Sources Revenue 66 0 0 0 0Investment Income 3,000 3,000 3,000 3,000 3,000Park Dedication Fees 40,000 40,000 70,000 70,000 70,000Property Tax Levy 43,066 43,000 73,000 73,000 73,000Total 191,282 148,835 86,851 50,469 62,936Total Funds Available 43,066 43,000 73,000 73,000 73,000Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Parks and Recreation 0 0 (66,682) 0 0Playground Equipment - Erickson ballfield PR-044 (32,448) 0 0 0 0Gateway Trail Improvements @ Annex PR-045 0 0 (42,700) 0 0Nature park trails PR-048 0 0 0 0 (101,226)Hay Lake Park Shelter water & doors PR-050 (8,653) 0 0 0 0Hay Lake Park - sign PR-054 (35,693) 0 0 0 0Lilleskogen Park Picnic Shelter PR-055 0 0 0 0 (12,653)Expanded Pleasure Rink PR-058 0 0 0 0 (44,286)New Ballfield to Replace South Ball Field PR-059 0 (134,984) 0 0 0Replace rink boards PR-061 (8,653) 0 0 0 0Park signage at Orwell Park (Liten)PR-063 0 0 0 (60,533) 0Tennis Court/Pickle Ball - repaint PR-064 0 0 0 0 (37,960)Settlers MonutPossible Reloc/Imp PR-066 (85,447) (134,984) (109,382) (60,533) (196,125)Total (85,447) (134,984) (109,382) (60,533) (196,125)Total Expenditures and Uses 105,835 13,851 (22,531) (10,064) (133,189)Ending Balance (42,381) (91,984) (36,382) 12,467 (123,125)Change in Fund Balance Friday, August 5, 2022Page 3DRAFT for 2021-2030 7/29/2022 406 Equipment Replacement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 316,433 784,440 794,119 12,397 (280,253)Beginning Balance Revenues and Other Fund Sources Revenue 0 (133,592) (133,592) (133,592) (133,592)(Less) Debt Service Payment 1,200,000 0 0 0 0Bond Proceeds 0 140,271 140,271 140,271 140,271Debt Service Levy 50,000 144,000 145,000 100,000 100,000Property Tax Levy 35,000 0 0 0 0Sale of Capital Assets 1,285,000 150,679 151,679 106,679 106,679Total 1,601,433 935,119 945,798 119,076 (173,574)Total Funds Available 1,285,000 150,679 151,679 106,679 106,679Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Fire 0 0 0 (10,000) 0Fire/PW Potable Well Pump (2000) Replacement F-008 (292,465) 0 0 0 02003 Tanker 5178 Tender 2 Replacement F-014 0 0 (818,901) 0 02000 Engine 1 - 5176 Replacement F-015 (38,000) 0 0 0 02003 Boat & Trailer - water rescues F-028 (86,528) 0 0 0 01995 Utility 1misc purpose truck - replacement F-040 (416,993) 0 (818,901) (10,000) 0Total Public Works 0 (65,000) 0 0 0303-17 Kubota F39000 Mower w/Broom & Blower (2017) PW-005 0 0 (39,000) 0 0312-08 Asphalt Patching Equipment Trailer (2008)PW-012 0 (65,000) 0 0 0308-12 New Holland Skit Steer (2012)PW-015 0 0 0 0 (480,000)301-98 John Deere Motor Grader (1998)PW-016 (325,000) 0 0 0 0203-11 Mack Dump Truck/Plow Replacement (2011) PW-017 (75,000) 0 0 0 0104-13 Ford F550 w/sander, plow mount, compressor PW-022 0 0 0 (389,329) 0201-14 Mack Single Axle w/Plow (2014)PW-063 0 0 (8,000) 0 0Utility Trailer 3,500 lbs (1998)PW-065 0 0 (17,000) 0 0PJ Skid Trailer 14,000 lbs (2012)PW-066 0 (11,000) 0 0 0Equipment Attachments (fit skid, loader, tractor)PW-067 0 0 (50,500) 0 0Addition Vehicle (truck for addl FT or PT staff)PW-068 (400,000) (141,000) (114,500) (389,329) (480,000)Total (816,993) (141,000) (933,401) (399,329) (480,000)Total Expenditures and Uses Friday, August 5, 2022Page 4DRAFT for 2021-2030 7/29/2022 406 Equipment Replacement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 784,440 794,119 12,397 (280,253) (653,574)Ending Balance 468,007 9,679 (781,722) (292,650) (373,321)Change in Fund Balance Friday, August 5, 2022Page 5DRAFT for 2021-2030 7/29/2022 408 Local Road Improvement Fund Source FY '23 FY '24 FY '25 FY '26 FY '27 1,278,399 665,882 2,635,480 2,448,766 1,452,143Beginning Balance Revenues and Other Fund Sources Revenue 0 0 (167,533) (167,533) (167,533)(less) Debt Service Payment 0 2,000,000 0 0 2,000,000Bond Proceeds 0 175,910 175,910 175,910 351,820Debt Service Levy 12,115 8,688 40,306 0 0Interest Income 350,000 600,000 600,000 200,000 200,000Property Tax Levy 362,115 2,784,598 648,683 208,377 2,384,287Total 1,640,514 3,450,480 3,284,163 2,657,143 3,836,430Total Funds Available 362,115 2,784,598 648,683 208,377 2,384,287Total Revenues and Other Fund Sources Expenditures and Uses Capital Projects & Equipment Public Works (21,632) 0 (23,397) 0 0Seal Boring PW-056 (21,632) 0 (23,397) 0 0Total Road Projects 0 (815,000) 0 0 02024 Local Road Improvement Project PW-034 0 0 0 (870,000) 02026 Local Road Improvement Project PW-035 (750,000) 0 0 0 02023 Local Road Improvement Project PW-043 (183,000) 0 0 0 02023 Seal Coat & Crack Filling Project PW-050 0 0 0 (335,000) 02026 Seal Coat & Crack Filling Project PW-051 0 0 (252,000) 0 02025 Seal Coat & Crack Filling PW-052 0 0 (540,000) 0 02025 Local Road Improvement Project PW-053 0 0 0 0 (900,000)2027 Local Road Improvement Project PW-057 0 0 0 0 (78,000)2027 Seal Coat & Crack Filling PW-058 (20,000) 0 0 0 0Soil Borings for 2024 & 2025 PW-061 0 0 (20,000) 0 0Soil Borings for 2026 & 2027 PW-062 0 0 0 0 (20,000)Soil Borings for 2028 & 2029 PW-069 (953,000) (815,000) (812,000) (1,205,000) (998,000)Total (974,632) (815,000) (835,397) (1,205,000) (998,000)Total Expenditures and Uses 665,882 2,635,480 2,448,766 1,452,143 2,838,430Ending Balance (612,517) 1,969,598 (186,714) (996,623) 1,386,287Change in Fund Balance Friday, August 5, 2022Page 6DRAFT for 2021-2030 7/29/2022