Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
ITEM 4 Other
OTHER - 1 City of Otsego, Minnesota Capital Improvement Plan 2020 thru 2029 PROJECTS BY FUNDING SOURCE Source # Priority 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 414 - Capital Improvements 1 Roundabout Landscaping BLDG -2020-02 nla 57,540 57,540 Server System Replacement IT -2020-01 nla 50,000 50,000 CSAH 38 & CSAH 19 - Local Share STREET -20-04 nla 532,653 532,653 CSAH 39 & CSAH 42 - Local Share STREET -20-05 nla 1,800,634 1,800,634 Parkview Avenue &88th Street STREET -20-06 nla 791,171 791,171 Signal Light Painting STREET -21-05 nla 33,330 33,330 CSAH 37 - Local Share STREET -22-03 nla 87,338 87,338 Signal Light Painting STREET -23-03 nla 30,060 30,060 414 - Capital Improvements Total 3,231,998 33,330 87,338 30,060 3,382,726 GRAND TOTAL 3,231,998 33,330 87,338 30,060 3,382,726 Tuesday, October 22, 2019 City of Otsego OTHER - 2 Capital Improvements Fund Cash Flow Summary V 0 Revised: October 22, 2019 Expenses Capital Outlay - General Forecast I - - - - - - - - - Capital Outlay - Public Safety Projection - Capital Improvement Plan - - - - - - - - - Capital Outlay - Public Works 7,500 - - - - - - 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Comments Revenues Capital Outlay (County CIP) - 2,333,287 - 87,338 - - - - - - DRAFT 2020-2029 CIP Capital Outlay (Property CIP) - 57,540 - - - - - - - - - DRAFT 2020-2029 CIP Development Incentives 465,027 - 108,691 - - - Property Taxes $ 355,000 $ 316,000 $ - $ - $ - $ - $ - $ - $ - $ - $ - Intergovernmental - - - - - - - - - - - Special Assessments - - - - - - - Special Assessments (Levied) 49,094 47,342 26,998 26,268 25,538 24,808 24,078 23,348 5,834 5,076 4,915 Existing levied assessments Investment Interest - - - - - - - - - - - Interfund Loan Payments - - - 34,196 34,196 34,196 34,196 34,196 34,196 34,196 34,196 Parkview Retail Abatements (City) County Abatement Payments - - - 41,984 41,984 41,984 41,984 41,984 41,984 41,984 41,984 Parkview Retail Abatements (County) Sales of Capital Assets - - - - - - - - - - - Miscellaneous - - - - - - - - Transfers In 971,726 - - - - - - - - - - Total 1,375,820 363,342 26,998 102,448 101,718 100,988 100,258 99,528 82,014 81,256 81,095 Expenses Capital Outlay - General 6,017 - - - - - - - - - Capital Outlay - Public Safety - - - - - - - - - - Capital Outlay - Public Works 7,500 - - - - - - Capital Outlay- Parks - - - - - - - - - - - Capital Outlay (IT CIP) - 50,000 - - - - - - - DRAFT 2020-2029 CIP Capital Outlay (Streets CIP) - 791,171 33,330 - 30,060 - - - - - DRAFT 2020-2029 CIP Capital Outlay (County CIP) - 2,333,287 - 87,338 - - - - - - DRAFT 2020-2029 CIP Capital Outlay (Property CIP) - 57,540 - - - - - - - - - DRAFT 2020-2029 CIP Development Incentives 465,027 - 108,691 - - - - - - Waterfront East Incentives Transfers Out - - - - - - - - - - Transfer - Create New Fund #439 Total 568,544 3,231,998 142,021 87,338 30,060 - - - Cash Balance - Beginning 2,150,384 2,957,660 89,004 (26,019) (10,909) 60,749 161,737 261,995 361,523 443,537 524,793 Balance Sheet Effects Revenues 1,375,820 363,342 26,998 102,448 101,718 100,988 100,258 99,528 82,014 81,256 81,095 Expenditures (568,544) (3,231,998) (142,021) (87,338) (30,060) - - - - - - Cash Balance - Ending $ 2,957,660 $ 89,004 $ (26,019) $ (10,909) $ 60,749 $ 161,737 $ 261,995 $ 361,523 $ 443,537 $ 524,793 $ 605,888 X:\Budget\2020\Cash Flows\Capital Funds 414 -Capital Imp. OTHER - 3 City of Otsego, Minnesota Capital Improvement Plan 2020 thru 2029 PROJECTS BY FUNDING SOURCE Source # Priority 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Total 439 - Building & Property Maintenan 1 Public Works Building - Trench Drain BLDG -2020-01 n/a 32,100 32,100 Repairs ADA Transition Plan BLDG -2020-03 n/a 13,600 13,600 City Hall - Carpet Replacement BLDG -2021-01 n/a 14,276 14,276 Security Camera Systems 1T-2027-01 n/a 20,000 20,000 Automated Entry & Security Systems 1T-2027-02 n/a 30,000 30,000 Audio/Visual Systems - Council 1T-2029-01 nla 150,000 150,000 Chambers ) - Building & Property Maintenance Total 45,700 14,276 50,000 150,000 259,976 Unfunded Public Works Building Expansion BLDG -2023-01 n/a 3,500,000 3,500,000 Unfunded Total 3,500,000 3,500,000 GRAND TOTAL 45,700 14,276 3,500,000 50,000 150,000 3,759,976 Tuesday, October 22, 2019 City of Otsego City Buildings & Property Maintenance Cash Flow Summary V Revised: October 22, 2019 25.00% 20.00% 16.67% 14.29% 12.50% 11.11% 10.00% 9.09% 8.33% Forecast Projection - Capital Improvement Plan 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 Revenues Property Taxes Investment Interest Miscellaneous Transfers In Total Expenses Supplies Other Charges & Services Capital Outlay Capital Outlay (CIP) Transfers Out Total Cash Balance - Beginning Balance Sheet Effects Revenues Expenditures Cash Balance - Ending OTHER - 4 Comments $ - $ 20,000 $ 25,000 $ 30,000 $ 35,000 $ 40,000 $ 45,000 $ 50,000 $ 55,000 $ 60,000 $ 65,000 - - - - - - - - - - Transfer - Initial Fund Startup 90,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 67,075 - - - - - - - - - - LED Lights / Prairie Center Carpet - 45,700 14,276 - - - 50,000 - 150,000 DRAFT 2020-2029 CIP 67,075 45,700 14,276 - - - - 50,000 - 150,000 22,925 (2,775) 7,949 37,949 72,949 112,949 157,949 207,949 212,949 272,949 90,000 20,000 25,000 30,000 35,000 40,000 45,000 50,000 55,000 60,000 65,000 (67,075) (45,700) (14,276) - - - - - (50,000) - (150,000) $ 22,925 $ (2,775) $ 7,949 $ 37,949 $ 72,949 $ 112,949 $ 157,949 $ 207,949 $ 212,949 $ 272,949 $ 187,949 X:\Budget\2020\Cash Flows\Capital Funds 439 -Buildings & Property