Loading...
Item 1 (4) Buildings & Property CIP PacketCapital Improvement PlanCity of Otsego, MinnesotaPROJECTS BY FUNDING SOURCE2023 2032thruTotal2023 2024 2025 2026 2027Source2028 2029 2030 2031 2032 #439 - Building & Property Maintenan78,03578,035City Hall - HVAC Control SystemBLDG-2023-0345,00045,000City Hall - Carpet ReplacementBLDG-2024-0110,00010,000City Hall - PaintingBLDG-2024-0210,00010,000Prairie Center - SkylightBLDG-2025-0120,00020,000Prairie Center DoorsBLDG-2026-0240,00020,000 20,000Prairie Center WindowsBLDG-2027-0120,00020,000Prairie Center - Carpet ReplacementBLDG-2030-0250,00050,000Salt Shed Cover ReplacementBLDG-2031-0119,50019,500Prairie Center - Vinyl Floor ReplacementBLDG-2032-0160,00060,000Server System ReplacementIT-2025-0120,00020,000Security Camera SystemsIT-2027-0130,00030,000Automated Entry & Security SystemsIT-2027-02150,000150,000Audio/Visual Systems - Council ChambersIT-2029-0170,00070,000Server System ReplacementIT-2030-019 - Building & Property Maintenance Total622,53578,035 55,000 70,000 20,000 70,000 20,000 150,000 90,000 50,000 19,500Issuance of Bonds16,189,00016,189,000City Campus - Phase 1BLDG-2023-0119,380,00019,380,000City Campus - Phase 2BLDG-2026-017,600,0007,600,000City Campus - Phase 3BLDG-2030-01Issuance of Bonds Total43,169,00016,189,000 19,380,000 7,600,00016,267,035 55,000 70,000 19,400,000 70,00043,791,535GRAND TOTAL20,000 150,000 7,690,000 50,000 19,500City Buildings & Property CIP Packet - 1 City of OtsegoCity Buildings & Property MaintenanceCash Flow SummaryRevised: November 3, 2022 16.67% 14.29% 12.50% 11.11% 10.00% 9.09% 8.33%7.69%7.14%6.67%Forecast20222023202420252026202720282029203020312032CommentsRevenuesProperty Taxes30,000$               35,000$               40,000$               45,000$               50,000$              55,000$              60,000$              65,000$              70,000$              75,000$               80,000$               Investment Interest‐                            ‐                            ‐                            ‐                            ‐                           ‐                          ‐                          ‐                          ‐                          ‐                            ‐                           Total30,000                 35,000                 40,000                45,000                 50,000                55,000               60,000               65,000               70,000               75,000                 80,000                 ExpensesCapital Outlay (City Hall)29,490                 ‐                            ‐                            ‐                            ‐                           ‐                          ‐                          ‐                          ‐                          ‐                            ‐                           Capital Outlay (CIP)‐                            78,035                 55,000                10,000                 20,000                20,000               20,000               ‐                          20,000               50,000                 19,500                  2023‐2032 CIPCapital Outlay (IT CIP)‐                            ‐                            ‐                            60,000                 ‐                           50,000               ‐                           150,000             70,000               ‐                            ‐                            2023‐2032 CIPTotal29,490                 78,035                 55,000                70,000                 20,000                70,000               20,000               150,000             90,000               50,000                 19,500                 Cash Balance ‐ Beginning90,992                 91,502                 48,467                33,467                 8,467                   38,467               23,467               63,467               (21,533)              (41,533)                 (16,533)                Balance Sheet EffectsRevenues 30,000                  35,000                  40,000                 45,000                  50,000                 55,000                60,000                65,000                70,000                75,000                  80,000                 Expenditures (29,490)                 (78,035)                 (55,000)                 (70,000)                 (20,000)                (70,000)               (20,000)               (150,000)             (90,000)               (50,000)                 (19,500)                Cash Balance ‐ Ending 91,502$                48,467$                33,467$                8,467$                  38,467$               23,467$               63,467$               (21,533)$              (41,533)$              (16,533)$               43,967$               Projection ‐ Capital Improvement PlanY:\Budget\2023\Cash Flows\Capital Funds439-Buildings & PropertyCity Buildings & Property CIP Packet - 2 City of OtsegoFire Reserves FundCash Flow SummaryRevised: November 3, 2022Forecast2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 CommentsRevenuesProperty Taxes 200,000$              210,000$              220,000$              230,000$              240,000$             250,000$             260,000$             270,000$             280,000$             290,000$              300,000$              Levy for Capital Equipment & BuildingsInvestment Interest ‐                              ‐                              ‐                              ‐                              ‐                             ‐                            ‐                            ‐                            ‐                            ‐                             ‐                             Miscellaneous ‐                              ‐                              ‐                              ‐                              ‐                             ‐                            ‐                            ‐                            ‐                            ‐                             574,252                 Sale of Excess Property ‐ Odean & 75thTotal 200,000                 210,000                 220,000                 230,000                 240,000                250,000               260,000               270,000               280,000               290,000                874,252                ExpensesFire Study 4,133                     ‐                              ‐                              ‐                              ‐                             ‐                            ‐                            ‐                            ‐                            ‐                             ‐                              Emergency Services Evaluation StudyTotal4,133                    ‐                             ‐                             ‐                             ‐                            ‐                           ‐                           ‐                           ‐                           ‐                            ‐                             Cash Balance ‐ Beginning1,961,368             2,157,235             2,367,235             2,587,235             2,817,235            3,057,235           3,307,235           3,567,235           3,837,235           4,117,235            4,407,235            Balance Sheet EffectsRevenues 200,000                 210,000                 220,000                 230,000                 240,000                250,000               260,000               270,000               280,000               290,000                874,252                Expenditures (4,133)                    ‐                              ‐                              ‐                              ‐                             ‐                            ‐                            ‐                            ‐                            ‐                             ‐                             Cash Balance ‐ Ending2,157,235$           2,367,235$           2,587,235$           2,817,235$           3,057,235$          3,307,235$          3,567,235$          3,837,235$          4,117,235$          4,407,235$           5,281,487$          Projection ‐ Capital Improvement PlanY:\Budget\2023\Cash Flows\Capital Funds214-Fire ReserveCity Buildings & Property CIP Packet - 3 Capital Improvement PlanCity of Otsego, MinnesotaPROJECTS BY FUNDING SOURCE2023 2032thruTotal2023 2024 2025 2026 2027Source2028 2029 2030 2031 2032 #414 - Capital Improvements50,00050,000City Entrance SignageBLDG-2023-0251,63151,631CSAH 38 & CSAH 19 - Local ShareCSAH-2020-0458,51958,519CSAH 37 - Local ShareCSAH-2022-011,000,0001,000,000CR 137 - Local ShareCSAH-2024-01350,000350,000CSAH 19 & CSAH 39 IntersectionCSAH-2024-0260,00060,000TH 101 - Left Turn SignalsPW-2022-0150,00050,000CSAH 38 - Turn Lanes - Martin Farms Ave.PW-2023-0138,00038,000Signal Light PaintingPW-2026-0140,00040,000Signal Light PaintingPW-2028-01414 - Capital Improvements Total1,698,150270,150 1,350,000 38,000 40,000270,150 1,350,00038,0001,698,150GRAND TOTAL40,000City Buildings & Property CIP Packet - 4 City of OtsegoCapital Improvements FundCash Flow SummaryRevised: November 3, 2022Forecast2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 CommentsRevenuesProperty Taxes 1,175,590$           1,390,517$           ‐$                           ‐$                           ‐$                          ‐$                          ‐$                          ‐$                          ‐$                          ‐$                           ‐$                         Pending 2023 Tax LevyIntergovernmental ‐                             ‐                             297,000                ‐                             ‐                            ‐                           ‐                           ‐                           ‐                           ‐                             ‐                            County MOU / MNDOT GrantSpecial Assessments (Levied) 27,557                  26,791                  26,026                 25,260                  24,495                 6,945                   5,076                   4,915                   ‐                           ‐                             ‐                            Existing levied assessmentsInvestment Interest ‐                             ‐                             ‐                             ‐                             ‐                            ‐                           ‐                           ‐                           ‐                           ‐                             ‐                           Tax Abatement ‐ City 40,228                  87,744                  87,744                 87,744                  87,744                 87,744                87,744                87,744                87,744                87,744                  70,076                  Parkview Retail Abatements (City)Tax Abatement ‐ County 35,804                  97,252                  97,252                 97,252                  72,440                 ‐                           ‐                           ‐                           ‐                           ‐                             ‐                            Parkview Retail Abatements (County)Transfers In 1,266,290             ‐                             ‐                             ‐                             ‐                            ‐                           ‐                           ‐                           ‐                           ‐                             ‐                           Pending Fund Balance Policy TransferTotal 2,545,469             1,602,304             508,022                210,256                184,679               94,689                92,820                92,659                87,744               87,744                 70,076                 ExpensesCapital Outlay ‐ Public Works166,088               ‐                            ‐                            ‐                            ‐                           ‐                          ‐                          ‐                          ‐                          ‐                            ‐                           Capital Outlay (Streets CIP)‐                             110,000               ‐                            ‐                            38,000                ‐                          40,000               ‐                          ‐                          ‐                            ‐                            2023‐2032 CIPCapital Outlay (County CIP)‐                             110,150               1,350,000            ‐                            ‐                           ‐                          ‐                          ‐                          ‐                          ‐                            ‐                            2022‐2026 County CIP (No LOST Projects)Capital Outlay (Property CIP)‐                            50,000                 ‐                            ‐                            ‐                           ‐                          ‐                          ‐                          ‐                          ‐                            ‐                            2023‐2032 CIPTotal166,088               270,150               1,350,000            ‐                            38,000                ‐                          40,000               ‐                          ‐                          ‐                            ‐                           Cash Balance ‐ Beginning4,128,780            6,508,161            7,840,315            6,998,337            7,208,593           7,355,272          7,449,961          7,502,781          7,595,440          7,683,184            7,770,928            Balance Sheet EffectsRevenues2,545,469            1,602,304            508,022               210,256               184,679              94,689               92,820               92,659               87,744               87,744                 70,076                 Expenditures(166,088)              (270,150)              (1,350,000)           ‐                             (38,000)               ‐                          (40,000)              ‐                          ‐                          ‐                            ‐                           Cash Balance ‐ Ending6,508,161$          7,840,315$          6,998,337$          7,208,593$          7,355,272$         7,449,961$         7,502,781$         7,595,440$         7,683,184$         7,770,928$          7,841,004$          Projection ‐ Capital Improvement PlanY:\Budget\2023\Cash Flows\Capital Funds414-Capital Imp.City Buildings & Property CIP Packet - 5