Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
07-18-22 FCA
C IT Y C O UNC I L/F INANC I AL C O M M IS S IO N M E E T I NG City Hall Council Chambers J uly 18, 2022 AGE NDA 1.Call to Order - 6:30 p.m. The City Council requests that attendees turn off cell phones and pagers during the meeting. A copy of the full City C ounc il packet is available to the public . The packet ring binder is loc ated at the entrance of the council chambers. 2.Approval of Agenda 3.Overview/Introductions 4.Capital Improvements Plan 2023-2037 a.Capital Improvement Plans 5.Individual Capital P rojects F unds a.Individual F unds Capital I mprovement Fund Municipal S tate Aid F und S treet Reconstruction Fund S pecial A ssessment Fund Overview of Utility Funds 6.Adjournment 7. 8.Adjourn 7/14/2022 1 Capital Improvement Plan 2023 – 2037 2023 Capital Project Budgets City Council/Financial Commission Joint Work Session, July 18, 2022 Angela Holm, Finance Director, Elizabeth Heyman, Public Works Director Agenda •Introduction •Capital Improvement Plan •Individual Capital Project Funds •Capital Improvements Fund •Municipal State Aid (MSA) Fund •Street Reconstruction Fund •Special Assessment Construction Fund •Utility Funds (Water, Sewer, Storm, Street Light) 2 7/14/2022 2 What is the CIP? •Capital Improvement Plan (CIP) •Future intent of City capital projects over the next 15 years •Developed by prioritizing a list of capital projects based on anticipated year needed and based on anticipated funding opportunities •Fluidity is expected •Focus on the first 3‐4 years •2023 projects will be incorporated in the requested 2023 budget 3 What is the CIP? •Capital Improvement Plan (CIP) •Public Utilities •Street Improvements •Park & Trail Improvements •Capital Maintenance Building Program (CMBP) •Various Funding Sources •Utility fees, special assessments, franchise fees, Municipal Street Construction Aid, a portion of Local Government Aid, liquor operations, etc. 4 7/14/2022 3 CIP Themes •Setting a plan for future Park and CMBP improvements •Reset coming out of COVID and civil unrest •Community centered + financing strategy •Continuing our ongoing investments in street and utility infrastructure •Right fix, right time •Coordinating CIP projects with Opportunity Site 5 New Projects 6 Project Year Total Project Cost Park Capital Planning Study 2023 $300,000 Capital Maintenance Building Plan (CMBP) Evaluation Study 2023 $150,000 Hazardous Tree Management and Reforestation 2023‐2033 $150,000 per year 7/14/2022 4 Major Projects 7 Project Year Total Project Cost Notes Knox, James and 54th Ave. Area Improvements 2023 $1,170,000 Orchard Lane East Improvements 2024 $11,870,000 Scoping work needed 65th Avenue Trunk Storm Sewer Rehabilitation 2024 $1,687,000 Storm Drainage Utility Funds Orchard Lane West Area Improvements 2025 $10,010,000 Scoping work needed Humboldt Avenue (CR 57) Reconstruction (53rd to 57th)2025 $4,860,000 Hennepin County project –local share placeholder 69th Ave (CSAH 130) Reconstruction (Unity to Brooklyn Blvd)2026 $6,500,000 Hennepin County project –local share placeholder TH 252/66th Interchange and 70th Pedestrian Overpass 2026 $35,000,000 MnDOT project –local share placeholder Inflation 8 •6% inflation assumption for 2023 projects •Consistent with 2022 project costs •Consistent with cost index trends (Engineering News Record) •Steel item are higher than 6% •Reassess again in next year’s budget cycle 7/14/2022 5 Capital Improvements Funding Policy •General Fund transfer of audited year‐end unassigned fund balance above 52% of next year’s General Fund operating budget •Liquor operations transfer of audited year‐end Liquor Fund unrestricted cash balance than exceeds 2 months of next year’s operating budget and one year of budgeted capital improvement needs (modified from 3.5 months on July 8, 2019) •Local Government Aid (LGA) received in the amount of $650,000 or half of the amount received by the City (whichever is greater) •Other outside sources of revenues (i.e. grant funds) 9 Capital Improvements Fund – Cash Flow Analysis 10 7/14/2022 6 Capital Improvements Fund – Cash Flow Analysis 11 MSA Fund – Cash Flow Analysis 12 7/14/2022 7 MSA Fund – Cash Flow Analysis 13 Street Reconstruction Fund – Cash Flow Analysis 14 7/14/2022 8 Street Reconstruction Fund – Cash Flow Analysis 15 Special Assessments Fund – Cash Flow Analysis 16 7/14/2022 9 Special Assessments Fund – Cash Flow Analysis 17 2023 Utility Projects ($3.5 Million) 18 7/14/2022 10 CIP Impact on Utility Funds •Cash flows show the impact of the CIP Plan on Utility Funds •Details will be further covered in the review of Utility Funds budgets and rates 19 Water Fund – Cash Flow Analysis 20 7/14/2022 11 21 Water Fund – Cash Flow Analysis * Minimum Targeted balance = 3 months of operations, following year debt service and 10 year average internal funded capital) 22 Sanitary Sewer Fund – Cash Flow Analysis 7/14/2022 12 23 Sanitary Sewer Fund – Cash Flow Analysis * Minimum Targeted balance = 3 months of operations, following year debt service and 10 year average internal funded capital) 24 Storm Drainage Fund – Cash Flow Analysis 7/14/2022 13 25 Storm Drainage Fund – Cash Flow Analysis * Minimum Targeted balance = 3 months of operations, following year debt service and 10 year average internal funded capital) 26 Comparative Cities’ Utility Rates 7/14/2022 14 27 Comparative Cities’ Utility Rates 28 Street Light Fund – Cash Flow Analysis 7/14/2022 15 29 Street Light Fund – Cash Flow Analysis * Minimum Targeted balance = 3 months of operations, following year debt service and 10 year average internal funded capital) Anticipated Debt Service •Anticipated bond issues based on our capital investment needs are as follows: •Street Reconstruction (Levy, Assessments) •Water (User Fees) •Sanitary Sewer (User Fees) •Storm Sewer (User Fees) 30 7/14/2022 16 Anticipated Debt Issues 31 2022 – 2023 Summary •$4.56 million in debt issuances over the next two years (Neighborhood Construction Program is driving factor) We currently do not project bonding in 2023. •Financial Impact: Property Tax Levy •2023 – 8.81% increase in tax levy for debt service •2024 – (7.05%) decrease in tax levy for debt service •2025 ‐25.73 %increase in tax levy for debt service Quarterly utility bill (typical resident) •2022 ‐$197.99 •2023 ‐$210.09 ($12.10 quarterly increase) •2023 ‐$219.89 ($9.80 quarterly increase) 32 7/14/2022 17 Questions? 33 Table 2 Capital Improvement Program (2023 - 2037) July 13, 2022 Special Street MSA Storm Drainage Sanitary Sewer Water Street Light Capital Projects Total Project Project Assessments Reconst. Fund Fund Utility Utility Utility Utility Funds Cost Tracking Notes CIP 2023-2037 2023 50th Avenue Improvements (France Ave to Drew Ave) $50,000 $140,000 $40,000 $20,000 $160,000 $410,000 Increase cost due to trail rehabilitation 51st Avenue Improvements (west of France Avenue) $90,000 $180,000 $70,000 $10,000 $10,000 $20,000 $380,000 Knox, James and 54th Ave. Area Improvements $250,000 $540,000 $250,000 $30,000 $100,000 $1,170,000 Miscellaneous Park Parking Lot Mill and Overlay $567,000 $567,000 Carryover from 2022 West River Rd, Arboretum, Freeway, Palmer Lake & Northport Trail Replacements $581,000 $581,000 Carryover from 2022 Hazardous Tree Management and Reforestation $150,000 $150,000 New Evergreen Park Score Board Improvements $149,000 $149,000 Irrigation Systems Controller Replacements $50,000 $50,000 New Park Capital Planning Study $300,000 $300,000 New Park Playground Equipment Replacement $455,000 $455,000 Lift Station No. 9 Rehabilitation $717,000 $717,000 Opportunity Site Area: Could move years pending master plan, cost increase due to material pricing Lift Station No. 9 Force Main Replacement $395,000 $395,000 Opportunity Site Area: Could move years pending master plan, cost increase due to material pricing Freeway and Highway Utility Crossing Replacement $215,000 $476,000 $691,000 Carryover from 2022, cost increase due to material pricing I94/Dupont Ave Water Main Crossing Replacement $436,000 $436,000 Carryover from 2022, cost increase due to material pricing Water Treatment Plant Redundant Water Main Connection $422,000 $422,000 Carryover from 2022, cost increase due to material pricing Well Nos. 4 and 9; Water Treatment Plant HSP No. 2 $147,000 $147,000 Capital Maintenance Building Plan (CMBP) Evaluation Study $150,000 $150,000 New CMBP: CC, CH, Fire, PW, Police - Expansion Joint Caulking $125,000 $125,000 Carryover from 2022 CMBP: Fire, Police - Carpet & Paint $220,000 $220,000 New CMBP: West Fire - Rooftop Unit Replacement $63,000 $63,000 CMBP: Police - Parking Lot Mill & Overlay $117,000 $117,000 2023 Subtotal $390,000 $860,000 $360,000 $1,387,000 $1,751,000 $20,000 $2,927,000 $7,695,000 2024 Orchard Lane East Improvements $1,380,000 $3,580,000 $950,000 $1,990,000 $3,820,000 $150,000 $11,870,000 Could consider splitting the project up in the future due to size Traffic Sig Sys Rehab (Shingle Creek Pkwy/Summit) $145,000 $434,000 $579,000 Previously 2023, cost increase due to material pricing, Opportunity Site Area: Could move years pending master plan Traffic Sig Sys Rehab. (Shingle Creek Pkwy/John Martin) $145,000 $434,000 $579,000 Previously 2023, cost increase due to material pricing, Opportunity Site Area: Could move years pending master plan Earle Brown/Opportunity Area Street Light Replacement $391,000 $391,000 Previously 2023, cost increase due to material pricing, Opportunity Site Area: Could move years pending master plan Hazardous Tree Management and Reforestation $150,000 $150,000 New Evergreen, Firehouse & Northport Park Security Improvements $253,000 $253,000 Previously 2023 Park Playground Equipment Replacement $313,000 $313,000 Lift Station No. 5 Rehabilitation $333,000 $333,000 Previously 2023, cost increase due to material pricing Well Nos. 6 and 8; Water Treatment Plant HSP No. 4 $196,000 $196,000 Changed HSP number 65th Avenue Trunk Storm Sewer Rehabilitation $1,687,000 $1,687,000 Previously 2023 61st & Perry Avenues Storm Sewer Improvement $196,000 $196,000 Previously 2023 CMBP: City Hall/CC Addition - Roof Replacement $441,000 $441,000 CMBP: City Hall - Community Development Office Remodel $276,000 $276,000 Previously 2023 CMBP: East/West Fire - Roof Replacement $409,000 $409,000 Previously 2023 CMBP: Police - Generator/Transfer Replacement $197,000 $197,000 Carryover from 2022 CMBP: PW Garage - Roof Replacement $540,000 $540,000 Carryover from 2022 CMBP: Public Works - Lighting System Upgrade $109,000 $109,000 Previously 2023 2024 Subtotal $1,380,000 $3,870,000 $868,000 $2,833,000 $2,323,000 $4,016,000 $541,000 $2,688,000 $18,519,000 2025 Humboldt Avenue (CR 57) Reconstruction (53rd to 57th) $360,000 $2,355,000 $195,000 $560,000 $670,000 $20,000 $700,000 (A) $4,860,000 Previously 2025 (HC requested change), HC has $700,000 in HC CIP, Revised water to be 100% replacement from 75% Orchard Lane West Area Improvements $1,990,000 $4,200,000 $1,160,000 $2,290,000 $180,000 $190,000 $10,010,000 Could consider splitting the project up in the future due to size 53rd and Xerxes Avenue Improvements $80,000 $470,000 $130,000 $50,000 $730,000 Revised assessment type from Full Reconstruction to Partial Reconstruction Traffic Sig Sys Rehab.(Shingle Creek Pkwy/Brookdale Sq) $197,000 $400,000 $597,000 Opportunity Site Area: Could move years pending master plan, cost increase due to material pricing, Basketball Courts Pavement Replacements $148,000 $148,000 Centennial Park Improvements $145,000 $145,000 Previously 2023 Centennial Park Softball Field Improvements $614,000 $614,000 Previously 2024 Hazardous Tree Management and Reforestation $150,000 $150,000 New Storm Water Pond 17-001 Rehab $154,000 $154,000 Storm Water Pond 48-001 Rehab $347,000 $347,000 Previously 2023 Well Nos. 2 and 3; Water Treatment Plant HSP (BW) $202,000 $202,000 Changed HSP number CMBP: Civic Center - Cooling Replace (Chillers/condensers) $141,000 $141,000 Carryover from 2022 CMBP: Civic Center - Air Handlers #4, #5 Replace $77,000 $77,000 Previously 2023 CMBP: East/West Fire - Parking Lot Mill & Overlay $128,000 $128,000 CMBP: Police - Roof Replacement $291,000 $291,000 2025 Subtotal $2,430,000 $7,222,000 $400,000 $1,986,000 $2,850,000 $1,052,000 $260,000 $2,394,000 $18,594,000 NOTES:(A) Anticipated Hennepin County ($700k) funding share - Humboldt Ave is a county road (CR 57) G:\Budget\2023 Budget\Council Presentations\CIP 7-18\220713_DRAFT_2023-2037 CIP Table 2 Page | 6 Table 2 Capital Improvement Program (2023 - 2037) July 13, 2022 Special Street MSA Storm Drainage Sanitary Sewer Water Street Light Capital Projects Total Project Project Assessments Reconst. Fund Fund Utility Utility Utility Utility Funds Cost Tracking Notes CIP 2023-2037 2026 Meadowlark Gardens Area Improvements $540,000 $880,000 $610,000 $470,000 $110,000 $370,000 $110,000 $3,090,000 67th Avenue and James Avenue Mill and Overlay $200,000 $100,000 $120,000 $10,000 $70,000 $20,000 $520,000 68th Avenue and Lee Avenue Mill and Overlay $130,000 $110,000 $100,000 $10,000 $80,000 $20,000 $450,000 John Martin Drive Mill and Overlay $130,000 $260,000 $40,000 $10,000 $50,000 $50,000 $540,000 St. Alphonses Area Mill and Overlay $390,000 $270,000 $260,000 $40,000 $160,000 $40,000 $1,160,000 69th Ave (CSAH 130) Reconstruction (Unity to Brooklyn Blvd)$838,000 $140,000 $800,000 $1,010,000 $10,000 $3,912,000 (B)$6,710,000 Not in current HC CIP: Place hold for potential Brooklyn Center cost share TH 252/66th Interchange and 70th Pedestrian Overpass $35,000,000 (C) $35,000,000 Could move years pending TH 252 Hazardous Tree Management and Reforestation $150,000 $150,000 New Hockey Rink Rehabilitation/Replacements $329,000 $329,000 Irrigation Systems Rehabilitation/Replacements $148,000 $148,000 Storm Water Ponds 41-001, 41-002 & 53-001 Rehab $155,000 $155,000 Lift Station Nos. 3 Rehabilitation $333,000 $333,000 cost increase due to material pricing Well No. 5 and Water Treatment Plant HSP No. 3 $114,000 $114,000 Changed HSP number CMBP: Community Center - Water Slide Skylight $60,000 $60,000 CMBP: Public Works Cold - Roof Replacement $128,000 $128,000 CMBP: Public Works Salt - Roof Replacement $61,000 $61,000 2026 Subtotal $1,390,000 $2,198,000 $870,000 $1,285,000 $1,313,000 $1,854,000 $250,000 $39,788,000 $48,948,000 NOTES:(B) Hennepin County funding estimated at 80% for street and storm costs and 20% City funding NOTES: 2027 Earle Brown Drive Area Improvements $690,000 $980,000 $490,000 $140,000 $20,000 $20,000 $2,340,000 Humboldt Avenue Mill and Overlay (65th to 69th) $120,000 $610,000 $80,000 $30,000 $20,000 $10,000 $870,000 Could move years pending TH 252 Humboldt Avenue Improvements (69th to 73rd) $170,000 $650,000 $130,000 $450,000 $240,000 $30,000 $1,670,000 Could move years pending TH 252 Hazardous Tree Management and Reforestation $150,000 $150,000 New Park Name Sign Replacements $79,000 $79,000 Previously 2025 Softball/Baseball Fence Replacement $67,000 $67,000 69th Avenue Trail Reconstruction $227,000 $227,000 69th Avenue Landscape Rehabilitation $152,000 $152,000 Well No. 10 and Water Treatment Plant HSP No. 1 $117,000 $117,000 CMBP: West Fire - Generator/Transfer Replacement $200,000 $200,000 CMBP: Police - Condenser Jail $70,000 $70,000 2027 Subtotal $980,000 $980,000 $1,750,000 $350,000 $500,000 $397,000 $40,000 $945,000 $5,942,000 2028 Garden City Central Area Mill and Overlay $730,000 $2,000,000 $320,000 $1,110,000 $420,000 $120,000 $4,700,000 Shingle Creek Pkwy and Xerxes Ave Mill and Overlay $560,000 $1,140,000 $300,000 $30,000 $500,000 $80,000 $2,610,000 65th/66th Avenue and Camden Avenue Mill and Overlay $120,000 $290,000 $700,000 $180,000 $310,000 $20,000 $1,620,000 Could move years pending TH 252 73rd Avenue Mill and Overlay (Humboldt to Camden) $30,000 $90,000 $130,000 $75,000 $20,000 $10,000 $325,000 (D) $680,000 Could move years pending TH 252 Hazardous Tree Management and Reforestation $150,000 $150,000 New Park Trail and Parking Lot Lighting Improvements $420,000 $420,000 Water Meter Full System Replacement $562,000 $1,686,000 $2,248,000 Well No. 7 and Water Treatment Plant HSP No. 2 $121,000 $121,000 Emergency Responder Radio Replacement (Police/Fire/PW)$600,000 $600,000 2028 Subtotal $1,440,000 $2,380,000 $2,290,000 $1,665,000 $1,342,000 $2,457,000 $80,000 $1,495,000 $13,149,000 NOTES:(D) 50% Cost sharing of street & storm with City of Brooklyn Park ($295k) per 1999 agreement 2029 Garden City North Area Mill and Overlay $620,000 $2,680,000 $2,850,000 $810,000 $680,000 $7,640,000 Retaining Wall Replacement (miscellaneous locations) $132,000 $132,000 Hazardous Tree Management and Reforestation $150,000 $150,000 New Storm Water Ponds 11-001, 59-003, 60-003, 63-001, 63-002 & 64-001 Rehab $116,000 $116,000 Lift Station Nos. 7 and 10 Rehabilitation $1,152,000 $1,152,000 Well Nos. 4 and 9 and Water Treatment Plant HSP No. 4 $227,000 $227,000 Changed HSP number CMBP: City Hall - Ribbon Window Replacement $94,000 $94,000 CMBP: Community Center - Ribbon Window Replacement $112,000 $112,000 2029 Subtotal $620,000 $2,680,000 $2,966,000 $1,962,000 $907,000 $488,000 $9,623,000 2030 Garden City South Area Mill and Overlay $500,000 $2,600,000 $1,100,000 $1,510,000 $820,000 $1,910,000 $10,000 $8,450,000 Hazardous Tree Management and Reforestation $150,000 $150,000 New Sanitary Sewer Lining (Miss. River Trunk N. of I-694 to 70th/Willow) $1,700,000 $1,700,000 Lift No. 2 Forcemain Lining (Under I-94) $280,000 $280,000 Well Nos. 6 and 8; Water Treatment Plant HSP (BW) $230,000 $230,000 Changed HSP number CMBP: City Hall - Main Switch Gear Replacement $297,000 $297,000 CMBP: Community Center - Carpet Replacement $76,000 $76,000 2030 Subtotal $500,000 $2,600,000 $1,100,000 $1,510,000 $2,800,000 $2,140,000 $10,000 $523,000 $11,183,000 (C) Provisional project: funding estimated outside source ($29,500,000) and City Capital Improvements Fund ($5,500,000) G:\Budget\2023 Budget\Council Presentations\CIP 7-18\220713_DRAFT_2023-2037 CIP Table 2 Page | 7 Table 2 Capital Improvement Program (2023 - 2037) July 13, 2022 Special Street MSA Storm Drainage Sanitary Sewer Water Street Light Capital Projects Total Project Project Assessments Reconst. Fund Fund Utility Utility Utility Utility Funds Cost Tracking Notes CIP 2023-2037 2031 Southwest Area Mill and Overlay $570,000 $1,440,000 $1,260,000 $1,120,000 $570,000 $1,350,000 $60,000 $6,370,000 Hazardous Tree Management and Reforestation $150,000 $150,000 New Park Bleacher Replacement $69,000 $69,000 Storm Water Pond 57-004, 57-005 & 70-002 Rehab $70,000 $70,000 Lift Station No. 1 Generator Replacement $230,000 $230,000 Well Nos. 2 and 3 and Water Treatment Plant HSP No. 3 $234,000 $234,000 CMBP: City Hall - Brick Veneer Restoration $148,000 $148,000 CMBP: Community Center - Brick Veneer Restoration $231,000 $231,000 2031 Subtotal $570,000 $1,440,000 $1,260,000 $1,190,000 $800,000 $1,584,000 $60,000 $598,000 $7,502,000 2032 Happy Hollow Mill and Overlay $310,000 $1,350,000 $360,000 $880,000 $220,000 $410,000 $50,000 $3,580,000 Southeast Alleys Improvements $1,370,000 $10,000 $1,380,000 Hazardous Tree Management and Reforestation $150,000 $150,000 New Park Bleacher Replacement $92,000 $92,000 Brooklyn Blvd Street Light Replacement (65th to BP Border) $990,000 $990,000 Storm Water Pond 12-002, 12-003, 12-004, 12-005 & 18-001 Rehab $644,000 $644,000 Well No. 5 and Water Treatment Plant HSP No. 1 $130,000 $130,000 CMBP: East Fire - Epoxy Floor Replacement $56,000 $56,000 CMBP: West Fire - Epoxy Floor Replacement $76,000 $76,000 CMBP: Public Works - Exterior Paint $120,000 $120,000 CMBP: Public Works - Make Up Air (2) Replacement $188,000 $188,000 2032 Subtotal $1,680,000 $1,350,000 $360,000 $1,524,000 $220,000 $540,000 $60,000 $1,672,000 $7,406,000 2033 Northport Area Mill and Overlay $370,000 $1,110,000 $650,000 $660,000 $130,000 $60,000 $2,980,000 Traffic Sig Sys Rehab.(65th Avenue/Dupont Ave) $712,000 $712,000 TH 252 Impacts?: Could move years pending TH 252 recommended improvements Traffic Sig Sys Rehab.(66th Ave/Camden Ave) $356,000 $356,000 $712,000 TH 252 Impacts?: Could move years pending TH 252 recommended improvements Hazardous Tree Management and Reforestation $150,000 $150,000 New Evergreen Park Football/Soccer Field Improvements $151,000 $151,000 Well No. 10 and Water Treatment Plant HSP No. 2 $132,000 $132,000 Self Contained Breathing Apparatus (SCBA) Replacement (Fire) $612,500 $612,500 CMBP: Public Works - Main Switch Gear Replacement $263,000 $263,000 CMBP: Public Works - Generator/Transfer Replacement $205,000 $205,000 2033 Subtotal $370,000 $1,466,000 $1,718,000 $660,000 $130,000 $192,000 $1,381,500 $5,917,500 2034 Lions Park South Mill and Overlay $400,000 $1,640,000 $820,000 $120,000 $60,000 $3,040,000 73rd Avenue (Penn to Humboldt) Mill and Overlay $40,000 $180,000 $90,000 $140,000 $220,000 $310,000 (E) $980,000 Need to coordinate with City of Brooklyn Park Well No. 7 and Water Treatment Plant HSP No. 4 $134,000 $134,000 Changed HSP number CMBP: Public Works - Make Up Air (2) Replacement $113,000 $113,000 CMBP: East/West Fire - Overhead Door Replacements $253,000 $253,000 CMBP: Community Center - Sauna Reconstruction $115,000 $115,000 2034 Subtotal $440,000 $1,820,000 $910,000 $260,000 $414,000 $791,000 $4,635,000 NOTES:(E) 50% Cost sharing of street & storm with City of Brooklyn Park ($285k) per 2004 agreement 2035 Centerbrook Area Mill and Overlay $290,000 $1,360,000 $630,000 $80,000 $50,000 $2,410,000 Shingle Creek Pkwy/Summit Dr/Earle Brown Mill and Overlay $500,000 $510,000 $2,560,000 $520,000 $510,000 $1,280,000 $5,880,000 Well Nos. 4 and 9 and Water Treatment Plant HSP (BW) $248,000 $248,000 Changed HSP number CMBP: Community Center - RTU #1 & #2 $322,000 $322,000 2035 Subtotal $790,000 $1,870,000 $2,560,000 $1,150,000 $590,000 $1,578,000 $322,000 $8,860,000 2036 Freeway Blvd Area Improvements $770,000 $1,760,000 $3,290,000 $300,000 $580,000 $980,000 $7,680,000 Riverwood Area Improvements $1,110,000 $4,093,000 $1,750,000 $1,600,000 $1,740,000 $177,000 (F) $10,470,000 Storm Water Pond 46-001, 50-001, 52-001, 60-001 & 63-006 Rehab $627,000 $627,000 Well Nos. 6 and 8 and Water Treatment Plant HSP No. 3 $252,000 $252,000 Changed HSP number 2036 Subtotal $1,880,000 $5,853,000 $3,290,000 $2,677,000 $2,180,000 $2,972,000 $177,000 $19,029,000 2037 Twin Lake North Area Improvements $550,000 $2,400,000 $1,180,000 $160,000 $1,800,000 $6,090,000 New Xerxes and Northway Area Improvements $1,560,000 $1,320,000 $2,150,000 $440,000 $1,080,000 $1,680,000 $8,230,000 New Well Nos. 6 and 8 and Water Treatment Plant HSP No. 1 $256,000 $256,000 New 2037 Subtotal $2,110,000 $3,720,000 $2,150,000 $1,620,000 $1,240,000 $3,736,000 $14,576,000 TOTALS $16,970,000 $40,309,000 $18,616,000 $22,686,000 $19,897,000 $25,590,000 $1,321,000 $56,189,500 $201,578,500 G:\Budget\2023 Budget\Council Presentations\CIP 7-18\220713_DRAFT_2023-2037 CIP Table 2 Page | 8 City of Brooklyn Center Capital Improvements Fund Cash Flows Analysis Revised: 7-5-22 Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Revenues Property Taxes -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Special Assessments - - - - - - - - - - - - - - - - - Intergovernmental (LGA) 1,141,915$ 1,186,376$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ 1,261,030$ Investment Earnings (3,962) 6,400 39,041 6,440 - - - 1,847 2,597 20,983 39,078 56,178 54,781 58,444 72,505 72,505 95,020 Miscellaneous - - - - - - - - - - - - - - - - - External Funding Sources 7,047,220 4,302,277 - - 700,000 33,292,000 - - - - - - - - - - - Bond Proceeds - - - - - 5,500,000 - - - - - - - - - - - Transfers In - - - - - - - - - - - - - - - - - Debt Service Tax Levy - - - - - - 644,768 644,768 644,768 644,768 644,768 644,768 644,768 644,768 644,768 644,768 - Transfers (General) - - 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 100,000 Transfers (Liquor) - 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 175,000 Total 8,185,173 5,670,053 1,575,071 1,542,470 2,236,030 40,328,030 2,180,798 2,182,645 2,183,395 2,201,781 2,219,876 2,236,976 2,235,579 2,239,242 2,253,303 2,253,303 1,631,050 Expenditures Personal Services - - - - - - - - - - - - - - - - - Supplies - - - - - - - - - - - - - - - - - Other Services & Charges - - - - - - - - - - - - - - - - - Capital Outlay 6,381,314 6,353,321 3,438,008 2,688,000 2,394,000 39,878,000 945,000 1,495,000 488,000 523,000 598,000 1,672,000 1,381,500 791,000 322,000 177,000 - Debt Service Projected - - - - - - 644,768 644,768 644,768 644,768 644,768 644,768 644,768 644,768 644,768 644,768 - Transfers - - - - - - - - - - - - - - - - - Total 6,381,314 6,353,321 3,438,008 2,688,000 2,394,000 39,878,000 1,589,768 2,139,768 1,132,768 1,167,768 1,242,768 2,316,768 2,026,268 1,435,768 966,768 821,768 - Cash Balance - Beginning 1,110,319 2,914,178 2,230,910 367,973 (777,557) (935,527) (485,497) 105,533 148,410 1,199,037 2,233,050 3,210,158 3,130,366 3,339,677 4,143,151 4,143,151 5,574,686 Changes in Accruals - Revenues 8,185,173 5,670,053 1,575,071 1,542,470 2,236,030 40,328,030 2,180,798 2,182,645 2,183,395 2,201,781 2,219,876 2,236,976 2,235,579 2,239,242 2,253,303 2,253,303 1,631,050 Expenditures (6,381,314) (6,353,321) (3,438,008) (2,688,000) (2,394,000) (39,878,000) (1,589,768) (2,139,768) (1,132,768) (1,167,768) (1,242,768) (2,316,768) (2,026,268) (1,435,768) (966,768) (821,768) - Cash Balance - Ending 2,914,178$ 2,230,910$ 367,973$ (777,557)$ (935,527)$ (485,497)$ 105,533$ 148,410$ 1,199,037$ 2,233,050$ 3,210,158$ 3,130,366$ 3,339,677$ 4,143,151$ 5,429,686$ 5,574,686$ 7,205,736$ Notes: 1. Cash flow based on the projects listed in the City's proposed 15-year Capital Improvement Plan (Updated June 2021). 2. General Fund transfer is an estimate of audited year-end General Fund Unassigned Fund Balance above 52% of the next year's General Fund operating budget. 3. Liquor transfer is an estimate of audited year-end Liquor Fund unrestricted cash balance that exceeds 2 months of the next year's operating budget and one year of budgeted capital improvement needs. 4. Local Government Aid (LGA) received in the amount of $650,000 or half of the amount received by the City if greater. 5. See Capital Project Carryforward workpaper for detail of projected 2022 capital spending (5,000,000) - 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 35,000,000 40,000,000 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Capital Improvements Fund City Funded Capital Outlay External Funded Capital Outlay Cash Balance - Ending City of Brooklyn Center Municipal State Aid (MSA) Fund Cash Flows Analysis Revised: 7-4-21 Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Revenues Intergovernmental (Maintenance)338,656$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ 391,010$ Intergovernmental (Construction)1,015,969 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 1,173,028 Investment Earnings (7,622) 34,232 39,350 58,558 64,921 79,585 86,281 77,694 59,506 81,076 83,772 83,716 99,410 91,612 91,612 91,612 113,743 Total 1,347,003 1,598,270 1,603,388 1,622,596 1,628,959 1,643,623 1,650,319 1,641,732 1,623,544 1,645,114 1,647,810 1,647,754 1,663,448 1,655,650 1,655,650 1,655,650 1,677,781 Expenditures Supplies 69,198 77,000 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 156,404 Other Services & Charges 139,838 200,000 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 234,606 Capital Outlay 1,854,232 1,028,818 114,764 868,000 400,000 870,000 1,750,000 2,290,000 - 1,100,000 1,260,000 360,000 1,718,000 - 2,560,000 3,290,000 2,150,000 Total 2,063,268 1,305,818 505,774 1,259,010 791,010 1,261,010 2,141,010 2,681,010 391,010 1,491,010 1,651,010 751,010 2,109,010 391,010 2,951,010 3,681,010 2,541,010 Cash Balance - Beginning 3,108,623 1,956,116 2,248,568 3,346,182 3,709,768 4,547,717 4,930,330 4,439,639 3,400,361 4,632,895 4,786,999 4,783,799 5,680,543 5,234,981 5,234,981 6,499,621 4,474,261 Changes in Accruals (436,242) - - - - Revenues 1,347,003 1,598,270 1,603,388 1,622,596 1,628,959 1,643,623 1,650,319 1,641,732 1,623,544 1,645,114 1,647,810 1,647,754 1,663,448 1,655,650 1,655,650 1,655,650 1,677,781 Expenditures (2,063,268) (1,305,818) (505,774) (1,259,010) (791,010) (1,261,010) (2,141,010) (2,681,010) (391,010) (1,491,010) (1,651,010) (751,010) (2,109,010) (391,010) (2,951,010) (3,681,010) (2,541,010) Cash Balance - Ending 1,956,116$ 2,248,568$ 3,346,182$ 3,709,768$ 4,547,717$ 4,930,330$ 4,439,639$ 3,400,361$ 4,632,895$ 4,786,999$ 4,783,799$ 5,680,543$ 5,234,981$ 6,499,621$ 3,939,621$ 4,474,261$ 3,611,032$ Notes: 1. See Capital Project Carryforward workpaper for detail of projected 2022 capital spending 2. Potential use of available cash for City portion of 252 in 2026. - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 2021 2022 2023 2024 2025 2026 2027 2029 2030 2031 2032 2033 2034 2035 2036 2037 MSA Fund Expenditures Cash Balance - Ending City of Brooklyn Center Special Assessments Construction Fund Cash Flows Analysis Revised: 7-5-22 Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Revenues Special Assessments 489,600$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Special Assessments (Projected Existing) - 326,594 313,769 301,584 229,307 220,728 141,741 122,865 118,453 - - - - - - - - Special Assessments (Projected Prepaids)- 183,150 169,383 345,000 607,500 347,500 245,000 360,000 155,000 125,000 142,500 420,000 92,500 110,000 197,500 470,000 527,500 Special Assessments (Projected New) - - 76,923 145,866 286,536 533,315 663,605 746,675 875,104 913,114 936,663 966,063 1,055,358 1,008,390 1,114,410 1,199,760 1,057,200 Charges for Services 1,650 - - - - - - - - - - - - - - - - Investment Earnings - 8,700 26,261 22,723 53,772 59,878 44,807 35,751 21,622 20,179 18,878 17,048 1,131 5,634 5,634 5,634 8,475 Bond Proceeds 1,320,192 900,000 - 2,450,000 2,000,000 - - - - - - - - - - - - Total 1,811,442 1,418,444 586,336 3,265,174 3,177,115 1,161,422 1,095,153 1,265,291 1,170,180 1,058,293 1,098,041 1,403,111 1,148,989 1,124,024 1,317,544 1,675,394 1,593,175 Expenditures Other Services & Charges 22,228 - - - - - - - - - - - - - - - - Capital Outlay 2,802,631 732,600 677,533 1,380,000 2,430,000 1,390,000 980,000 1,440,000 620,000 500,000 570,000 1,680,000 370,000 440,000 790,000 1,880,000 2,110,000 Debt Service (Projected) - - 110,962 110,962 398,177 632,638 632,638 632,638 632,638 632,638 632,638 632,638 521,676 521,676 234,461 - - Total 2,824,859 732,600 788,495 1,490,962 2,828,177 2,022,638 1,612,638 2,072,638 1,252,638 1,132,638 1,202,638 2,312,638 891,676 961,676 1,024,461 1,880,000 2,110,000 Cash Balance - Beginning 1,579,756 814,779 1,500,623 1,298,463 3,072,675 3,421,614 2,560,398 2,042,913 1,235,567 1,153,109 1,078,764 974,168 64,641 321,954 484,302 777,385 572,779 Changes in Accruals 248,440 - - - - - - - - - - - - - - - - Revenues 1,811,442 1,418,444 586,336 3,265,174 3,177,115 1,161,422 1,095,153 1,265,291 1,170,180 1,058,293 1,098,041 1,403,111 1,148,989 1,124,024 1,317,544 1,675,394 1,593,175 Expenditures (2,824,859) (732,600) (788,495) (1,490,962) (2,828,177) (2,022,638) (1,612,638) (2,072,638) (1,252,638) (1,132,638) (1,202,638) (2,312,638) (891,676) (961,676) (1,024,461) (1,880,000) (2,110,000) Cash Balance - Ending 814,779$ 1,500,623$ 1,298,463$ 3,072,675$ 3,421,614$ 2,560,398$ 2,042,913$ 1,235,567$ 1,153,109$ 1,078,764$ 974,168$ 64,641$ 321,954$ 484,302$ 777,385$ 572,779$ 55,954$ Notes: 1) Prepaids estimated at 25% of new assessments, which is equal to capital outlay for the given year. 2. See Capital Project Carryforward workpaper for detail of projected 2020 capital spending - 500,000 1,000,000 1,500,000 2,000,000 2,500,000 3,000,000 3,500,000 4,000,000 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Special Assessments Reconstruction Fund Expenditures Cash Balance - Ending City of Brooklyn Center Street Reconstruction Fund Cash Flows Analysis Revised: 7-4-21 Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Revenues Franchise Fees 748,209$ 750,000$ 773,000$ 773,000$ 773,000$ 796,000$ 796,000$ 796,000$ 820,000$ 820,000$ 820,000$ 820,000$ 820,000$ 820,000$ 820,000$ 820,000$ 820,000$ Investment Earnings (18,104) 51,100 96,306 89,743 104,841 43,693 20,378 17,515 31,751 34,757 49,715 39,735 31,155 20,396 3,253 3,253 - Future Bonds - Levies - - 152,400 152,400 600,312 934,419 934,419 934,419 1,213,428 1,447,889 1,752,688 1,752,688 1,600,289 1,600,289 1,152,376 818,269 1,263,745 Bond Proceeds 2,031,065 1,300,000 - 3,870,000 2,850,000 - - 2,380,000 2,000,000 2,600,000 - - - - - 5,000,000 - Total 2,761,170 2,101,100 1,021,706 4,885,143 4,328,154 1,774,113 1,750,797 4,127,934 4,065,179 4,902,646 2,622,403 2,612,423 2,451,444 2,440,684 1,975,628 6,641,521 2,083,745 Expenditures Capital Outlay 2,836,378 1,492,721 1,244,341 3,870,000 7,222,000 2,172,000 980,000 2,380,000 2,680,000 2,600,000 1,440,000 1,350,000 1,466,000 1,820,000 1,870,000 5,853,000 3,720,000 Debt Service (Projected)- - 152,400 152,400 600,312 934,419 934,419 934,419 1,213,428 1,447,889 1,752,688 1,752,688 1,600,289 1,600,289 1,152,376 818,269 1,263,745 Bond Issue Costs - - - - - - - - - - - - - - - - - Total 2,836,378 1,492,721 1,396,741 4,022,400 7,822,312 3,106,419 1,914,419 3,314,419 3,893,428 4,047,889 3,192,688 3,102,688 3,066,289 3,420,289 3,022,376 6,671,269 4,983,745 Cash Balance - Beginning 5,089,944 4,894,836 5,503,215 5,128,180 5,990,923 2,496,764 1,164,457 1,000,835 1,814,350 1,986,101 2,840,858 2,270,573 1,780,308 1,165,463 185,859 (860,888) (890,636) Changes in Accruals (119,900) - - - - - - - - - - - - - - - - Revenues 2,761,170 2,101,100 1,021,706 4,885,143 4,328,154 1,774,113 1,750,797 4,127,934 4,065,179 4,902,646 2,622,403 2,612,423 2,451,444 2,440,684 1,975,628 6,641,521 2,083,745 Expenditures (2,836,378) (1,492,721) (1,396,741) (4,022,400) (7,822,312) (3,106,419) (1,914,419) (3,314,419) (3,893,428) (4,047,889) (3,192,688) (3,102,688) (3,066,289) (3,420,289) (3,022,376) (6,671,269) (4,983,745) Cash Balance - Ending 4,894,836$ 5,503,215$ 5,128,180$ 5,990,923$ 2,496,764$ 1,164,457$ 1,000,835$ 1,814,350$ 1,986,101$ 2,840,858$ 2,270,573$ 1,780,308$ 1,165,463$ 185,859$ (860,888)$ (890,636)$ (3,790,636)$ Existing Levies 1,454,502 1,449,995 1,268,423 1,252,786 1,102,033 1,087,438 845,772 634,060 370,943 148,299 - - - - - - - Projected Levies - - 152,400 152,400 600,312 934,419 934,419 934,419 1,213,428 1,447,889 1,752,688 1,752,688 1,600,289 1,600,289 1,152,376 818,269 1,263,745 Total Tax levy for bonds 1,454,502 1,449,995 1,420,823 1,405,186 1,702,345 2,021,857 1,780,191 1,568,479 1,584,371 1,596,188 1,752,688 1,752,688 1,600,289 1,600,289 1,152,376 818,269 1,263,745 Notes: 1. Franchise fees include projected increases of 3.0% for 2020, 3.0% for 2023, 3.0% for 2026, and 3.0% for 2029 2. See Capital Project Carryforward workpaper for detail of projected 2020 capital spending (6,000,000) (4,000,000) (2,000,000) - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Street Reconstruction Fund Expenditures Cash Balance - Ending City of Brooklyn Center Water Utility Cash Flows Rate Change - Proposed 5.00%9.00%7.00%7.00%7.00%3.00%3.00%2.00%2.00%0.00%0.00%0.00%0.00%0.00%0.00% Average Residential Fee (18,000 Gallons / Per Qtr.)69.82$ 76.07$ 81.36$ 87.10$ 93.12$ 95.98$ 98.86$ 100.79$ 102.73$ 102.73$ 102.73$ 102.73$ 102.73$ 102.73$ 102.73$ Per Quarter Change 3.35$ 6.25$ 5.29$ 5.74$ 6.02$ 2.86$ 2.88$ 1.93$ 1.94$ -$ -$ -$ -$ -$ -$ Base Charge 17.44$ 19.01$ 20.34$ 21.76$ 23.28$ 23.98$ 24.70$ 25.19$ 25.69$ 25.69$ 25.69$ 25.69$ 25.69$ 25.69$ 25.69$ Consumption Charge (0-30)2.91$ 3.17$ 3.39$ 3.63$ 3.88$ 4.00$ 4.12$ 4.20$ 4.28$ 4.28$ 4.28$ 4.28$ 4.28$ 4.28$ 4.28$ Consumption Charge (30-60)3.62$ 3.95$ 4.23$ 4.53$ 4.85$ 5.00$ 5.15$ 5.25$ 5.36$ 5.36$ 5.36$ 5.36$ 5.36$ 5.36$ 5.36$ Consumption Charge (60+)5.41$ 5.90$ 6.31$ 6.75$ 7.22$ 7.44$ 7.66$ 7.81$ 7.97$ 7.97$ 7.97$ 7.97$ 7.97$ 7.97$ 7.97$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,610,129$ 5,025,041$ 5,376,793$ 5,753,169$ 6,155,891$ 6,340,568$ 6,530,785$ 6,661,400$ 6,794,628$ 6,794,628$ 6,794,628$ 6,794,628$ 6,794,628$ 6,794,628$ 6,794,628$ Investment Earnings (11,465) 32,600 23,801 9,217 14,553 26,150 15,627 19,127 20,497 23,780 18,693 20,602 33,117 51,828 68,166 Nonoperating 70,026 - - - - - - - - - - - - - - Bond Proceeds (GO)1,929,083 1,500,000 - 3,820,000 1,650,000 - - 1,600,000 - - - - - - - Total 6,597,773 6,557,641 5,400,594 9,582,386 7,820,444 6,366,718 6,546,412 8,280,527 6,815,125 6,818,409 6,813,321 6,815,230 6,827,746 6,846,457 6,862,794 Expenditures Personal Servcies 658,369 662,277 682,145 702,610 723,688 745,399 767,761 790,793 814,517 838,953 864,121 890,045 916,746 944,249 972,576 Supplies 305,369 388,910 396,688 404,622 412,714 420,969 429,388 437,976 446,735 455,670 464,783 474,079 483,561 493,232 503,097 Other Services & Charges 887,879 643,234 656,099 669,221 682,605 696,257 710,182 724,386 738,874 753,651 768,724 784,099 799,781 815,776 832,092 Insurance 53,447 56,122 57,244 58,389 59,557 60,748 61,963 63,202 64,467 65,756 67,071 68,412 69,781 71,176 72,600 Utilities 256,178 236,900 241,638 246,471 251,400 256,428 261,557 266,788 272,124 277,566 283,117 288,780 294,555 300,446 306,455 Depreciation 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 Capital Outlay (CIP)2,552,583 1,738,841 2,116,888 4,016,000 1,052,000 1,824,000 397,000 2,457,000 907,000 2,140,000 1,584,000 540,000 192,000 414,000 1,578,000 Debt Service (Existing)1,157,641 1,405,464 1,545,037 1,566,998 1,552,978 1,542,084 1,540,090 1,398,112 1,028,553 674,789 392,138 202,000 - - - Debt Service (PFA)1,140,310 1,140,390 1,140,370 1,140,250 1,141,030 1,140,700 1,140,270 1,140,740 1,141,100 1,140,350 1,140,350 1,140,350 1,140,350 1,140,350 1,140,350 Debt Service (Projected)- - 184,936 184,936 655,908 849,338 849,338 849,338 1,036,907 1,036,907 1,036,907 1,036,907 851,971 851,971 380,999 Nonoperating - - - - - - - - Transfers Out - - - - - - - - Total 8,909,529 8,169,891 8,918,799 10,887,250 8,429,633 9,433,676 8,055,302 10,026,089 8,348,029 9,281,395 8,498,965 7,322,425 6,646,497 6,928,953 7,683,922 Cash Balance - Beginning 3,135,562 2,359,055 2,644,558 1,024,107 1,616,996 2,905,560 1,736,355 2,125,217 2,277,409 2,642,258 2,077,025 2,289,135 3,679,693 5,758,695 7,573,951 Changes in Accruals (362,504) - - - - - - - - - - - - - - Revenues 6,597,773 6,557,641 5,400,594 9,582,386 7,820,444 6,366,718 6,546,412 8,280,527 6,815,125 6,818,409 6,813,321 6,815,230 6,827,746 6,846,457 6,862,794 Expenditures (8,909,529) (8,169,891) (8,918,799) (10,887,250) (8,429,633) (9,433,676) (8,055,302) (10,026,089) (8,348,029) (9,281,395) (8,498,965) (7,322,425) (6,646,497) (6,928,953) (7,683,922) Noncash - Depreciation 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 1,897,753 Cash Balance - Ending 2,359,055$ 2,644,558$ 1,024,107$ 1,616,996$ 2,905,560$ 1,736,355$ 2,125,217$ 2,277,409$ 2,642,258$ 2,077,025$ 2,289,135$ 3,679,693$ 5,758,695$ 7,573,951$ 8,650,576$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 9,000,000 10,000,000 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance - Ending Minimum Targeted Balance* City of Brooklyn Center Sanitary Sewer Utility Cash Flows Rate Change 5.00%5.00%3.00%3.00%3.00%3.00%3.00%3.00%2.00%2.00%2.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.93.59$ 98.27$ 101.22$ 104.26$ 107.39$ 110.61$ 113.93$ 117.34$ 119.69$ 122.08$ 122.08$ 117.34$ 119.69$ 122.08$ 122.08$ Per Quarter Change 4.46$ 4.68$ 2.95$ 3.04$ 3.13$ 3.22$ 3.32$ 3.42$ 2.35$ 2.39$ 2.39$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,680,679$ 5,000,000$ 5,150,000$ 5,304,500$ 5,463,635$ 5,627,544$ 5,796,370$ 5,970,261$ 6,089,667$ 6,211,460$ 6,335,689$ 6,335,689$ 6,335,689$ 6,335,689$ 6,335,689$ Investment Earnings 15,254 47,000 37,295 29,689 31,939 31,728 23,745 25,244 21,218 20,628 27,420 29,262 37,947 47,391 54,936 Nonoperating 1,100 - - - - - - - - - - - - - - Bond Proceeds 1,421,407 600,000 - 1,900,000 2,290,000 - - - 810,000 2,520,000 - - - - - Total 6,118,440 5,647,000 5,187,295 7,234,189 7,785,574 5,659,272 5,820,115 5,995,506 6,920,885 8,752,088 6,363,109 6,364,951 6,373,637 6,383,080 6,390,626 Expenditures Personal Services 242,910 250,197 257,703 265,434 273,397 281,599 290,047 298,749 307,711 316,942 326,451 336,244 346,332 356,722 367,423 Supplies 30,210 31,116 31,739 32,373 33,021 33,681 34,355 35,042 35,743 36,458 37,551 38,678 39,838 41,033 42,264 Other Services & Charges 2,987,690 3,077,321 3,138,867 3,201,644 3,265,677 3,330,991 3,397,611 3,465,563 3,534,874 3,605,572 3,677,683 3,751,237 3,826,261 3,902,787 3,980,842 Insurance 22,207 22,873 23,331 23,797 24,273 24,759 25,254 25,759 26,274 26,800 27,604 28,432 29,285 30,163 31,068 Utilities 34,630 35,669 36,382 37,110 37,852 38,609 39,381 40,169 40,972 41,792 43,046 44,337 45,667 47,037 48,448 Depreciation 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 Capital Outlay 2,438,339 1,484,451 1,464,588 2,323,000 2,850,000 1,283,000 500,000 1,342,000 1,962,000 2,800,000 800,000 220,000 130,000 260,000 590,000 Debt Service (Existing)764,485 910,599 1,005,807 1,026,854 1,016,645 963,015 776,354 645,010 488,260 484,399 265,169 - - - - Debt Service (Projected)- - 73,975 73,975 308,227 590,564 590,564 590,564 590,564 685,520 980,941 980,941 906,967 906,967 672,714 Total 7,551,390 6,843,145 7,063,311 8,015,107 8,840,012 7,577,137 6,684,485 7,473,774 8,017,317 9,028,401 7,189,363 6,430,788 6,355,269 6,575,628 6,763,679 Cash Balance - Beginning 4,878,097 4,309,130 4,143,903 3,298,807 3,548,808 3,525,289 2,638,343 2,804,893 2,357,543 2,292,029 3,046,635 3,251,300 4,216,382 5,265,669 6,104,041 Changes in Accruals (166,936) - - - - - - - - - - - - - - Revenues 6,118,440 5,647,000 5,187,295 7,234,189 7,785,574 5,659,272 5,820,115 5,995,506 6,920,885 8,752,088 6,363,109 6,364,951 6,373,637 6,383,080 6,390,626 Expenditures (7,551,390) (6,843,145) (7,063,311) (8,015,107) (8,840,012) (7,577,137) (6,684,485) (7,473,774) (8,017,317) (9,028,401) (7,189,363) (6,430,788) (6,355,269) (6,575,628) (6,763,679) Noncash - Depreciation 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 1,030,919 Cash Balance - Ending 4,309,130$ 4,143,903$ 3,298,807$ 3,548,808$ 3,525,289$ 2,638,343$ 2,804,893$ 2,357,543$ 2,292,029$ 3,046,635$ 3,251,300$ 4,216,382$ 5,265,669$ 6,104,041$ 6,761,906$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 8,000,000 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Capital outlay Cash Balance (ending)Minimum Targeted Balance* City of Brooklyn Center Storm Water Utility Cash Flows 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Rate Change 3.00% 7.00% 7.00% 7.00% 7.00% 7.00% 3.00% 3.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% 2.00% Residential - Flat Fee / Per Qtr.15.98$ 17.10$ 18.30$ 19.58$ 20.95$ 22.42$ 23.09$ 23.78$ 24.26$ 24.74$ 25.24$ 25.74$ 26.26$ 26.78$ 27.32$ 27.86$ 28.42$ Per Quarter Change 0.47$ 1.12$ 1.20$ 1.28$ 1.37$ 1.47$ 0.67$ 0.69$ 0.48$ 0.49$ 0.49$ 1.48$ 1.51$ 1.54$ 1.58$ 1.61$ 1.64$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Revenues Operating 1,742,704$ 1,864,694$ 1,995,222$ 2,134,888$ 2,284,330$ 2,444,233$ 2,517,560$ 2,593,087$ 2,644,949$ 2,697,848$ 2,751,804$ 2,806,841$ 2,862,977$ 2,920,237$ 2,978,642$ 3,038,215$ 3,098,979$ Investment Earnings 15,722 43,200 78,317 78,243 55,303 50,589 38,486 43,149 27,995 38,223 54,223 50,802 41,992 49,232 52,754 54,663 32,868 Intergovernmental 50,000 - - - - - - - - - - - - - - - - Nonoperating - - - - - - - - - - - - - - - - - Bond Proceeds 2,230,629 260,000 - 920,000 1,130,000 - - - 2,740,000 1,320,000 - - - - - - - Total 4,039,055 2,167,894 2,073,540 3,133,131 3,469,633 2,494,822 2,556,046 2,636,235 5,412,944 4,056,070 2,806,027 2,857,643 2,904,969 2,969,469 3,031,396 3,092,877 3,131,847 Expenditures Personal Servcies 328,245 350,577 361,094 371,927 383,085 394,578 406,415 418,607 431,165 444,100 457,423 471,146 485,281 499,839 514,834 530,279 546,188 Supplies 27,703 53,600 54,672 55,765 56,881 58,018 59,179 60,362 61,570 62,801 64,057 65,338 66,645 67,978 69,337 70,724 72,139 Other Services & Charges 502,701 434,841 443,538 452,409 461,457 470,686 480,100 489,702 499,496 509,486 519,675 530,069 540,670 551,484 562,513 573,763 585,239 Insurance 2,874 3,018 3,078 3,140 3,203 3,267 3,332 3,399 3,467 3,536 3,607 3,679 3,753 3,828 3,904 3,982 4,062 Utilities 1,843 5,000 5,100 5,202 5,306 5,412 5,520 5,631 5,743 5,858 5,975 6,095 6,217 6,341 6,468 6,597 6,729 Depreciation 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 Capital Outlay 1,902,483 1,318,856 501,181 2,833,000 1,986,000 1,281,000 350,000 1,665,000 2,966,000 1,510,000 1,190,000 1,524,000 660,000 910,000 1,150,000 2,677,000 1,620,000 Debt Service (existing) 475,663 525,470 677,050 690,500 697,575 688,675 700,275 574,625 576,275 - - - - - - - - Debt Service (projected) - - 32,056 32,056 145,483 284,802 284,802 284,802 284,802 606,014 760,758 760,758 728,702 728,702 615,275 475,956 475,956 Total 4,685,704 4,135,554 3,521,961 5,888,191 5,183,182 4,630,630 3,733,815 4,946,320 6,272,710 4,585,987 4,445,688 4,805,277 3,935,459 4,212,363 4,366,523 5,782,494 4,754,504 Cash Balance - Beginning 4,119,635 4,998,747 4,475,279 4,471,049 3,160,182 2,890,825 2,199,210 2,465,633 1,599,741 2,184,167 3,098,443 2,902,974 2,399,532 2,813,234 3,014,531 3,123,595 1,878,171 Changes in Accruals 81,569 - - - - - - - - - - - - - - - - Revenues 4,039,055 2,167,894 2,073,540 3,133,131 3,469,633 2,494,822 2,556,046 2,636,235 5,412,944 4,056,070 2,806,027 2,857,643 2,904,969 2,969,469 3,031,396 3,092,877 3,131,847 Expenditures (4,685,704) (4,135,554) (3,521,961) (5,888,191) (5,183,182) (4,630,630) (3,733,815) (4,946,320) (6,272,710) (4,585,987) (4,445,688) (4,805,277) (3,935,459) (4,212,363) (4,366,523) (5,782,494) (4,754,504) Noncash - Depreciation 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 1,444,192 Cash Balance - Ending 4,998,747$ 4,475,279$ 4,471,049$ 3,160,182$ 2,890,825$ 2,199,210$ 2,465,633$ 1,599,741$ 2,184,167$ 3,098,443$ 2,902,974$ 2,399,532$ 2,813,234$ 3,014,531$ 3,123,595$ 1,878,171$ 1,699,706$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Capital outlay Cash Balance - Ending Minimum Targeted Balance* City of Brooklyn Center Street Light Utility Fund Rate Analysis Rate Change 0.00%0.00%5.00%5.00%5.00%5.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.6.55$ 6.55$ 6.88$ 7.22$ 7.58$ 7.96$ 7.96$ 7.96$ 7.96$ 7.96$ 7.96$ 7.96$ 7.96$ 7.96$ 7.96$ Per Quarter Change -$ -$ 0.33$ 0.34$ 0.36$ 0.38$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 448,957$ 460,000$ 483,000$ 507,150$ 532,508$ 559,133$ 559,133$ 559,133$ 559,133$ 559,133$ 559,133$ 559,133$ 559,133$ 559,133$ 559,133$ Investment Earnings (2,894) 8,200 7,851 8,023 1,861 839 323 3,354 5,617 9,196 12,537 14,932 17,238 20,501 23,685 Nonoperating - - - - - - - - - - - - - - - Total 446,063 468,200 490,851 515,173 534,369 559,971 559,455 562,487 564,750 568,329 571,670 574,065 576,371 579,634 582,818 Expenditures Supplies 10 8,030 8,191 8,354 8,522 8,692 8,866 9,043 9,224 9,408 9,597 9,789 9,984 10,184 10,388 Other Services & Charges 102,590 104,642 106,735 108,869 111,047 113,268 115,533 117,844 120,201 122,605 125,057 127,558 130,109 132,711 135,365 Insurance 885 930 949 968 987 1,007 1,027 1,047 1,068 1,090 1,111 1,134 1,156 1,179 1,203 Utilities 185,253 200,000 204,000 208,080 212,242 216,486 220,816 225,232 229,737 234,332 239,019 243,799 248,675 253,648 258,721 Depreciation 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 Capital Outlay 553,500 501,450 161,181 541,000 260,000 250,000 40,000 80,000 - 10,000 60,000 60,000 - - - Transfers Out - - - - - - - - - - - - - - - Total 943,353 916,167 582,170 968,386 693,912 690,568 487,357 534,282 461,345 478,549 535,898 543,394 491,039 498,838 506,792 Cash Balance - Beginning 1,152,977 795,499 448,647 458,444 106,345 47,917 18,436 191,649 320,970 525,490 716,384 853,270 985,057 1,171,504 1,353,415 Changes in Accruals 38,697 - - - - - - - - - - - - - - Revenues 446,063 468,200 490,851 515,173 534,369 559,971 559,455 562,487 564,750 568,329 571,670 574,065 576,371 579,634 582,818 Expenditures (943,353) (916,167) (582,170) (968,386) (693,912) (690,568) (487,357) (534,282) (461,345) (478,549) (535,898) (543,394) (491,039) (498,838) (506,792) Noncash - Depreciation 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 101,115 Cash Balance - Ending 795,499$ 448,647$ 458,444$ 106,345$ 47,917$ 18,436$ 191,649$ 320,970$ 525,490$ 716,384$ 853,270$ 985,057$ 1,171,504$ 1,353,415$ 1,530,555$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 2,000,000 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 Capital outlay Cash Balance - Ending Minimum Targeted Balance* City of Brooklyn Center Recycling Fund Rate Analysis Rate Change 0.00%0.00%1.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00%2.00% Residential - Flat Fee / Per Qtr.11.98$ 11.98$ 12.10$ 12.34$ 12.59$ 12.84$ 13.09$ 13.36$ 13.62$ 13.90$ 14.17$ 14.46$ Per Quarter Change -$ -$ 0.12$ 0.24$ 0.25$ 0.25$ 0.26$ 0.26$ 0.27$ 0.27$ 0.28$ 0.28$ Actual Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 Revenues Operating 394,495$ 393,347$ 398,440$ 406,409$ 414,537$ 422,828$ 431,284$ 439,910$ 448,708$ 457,682$ 466,836$ 476,173$ Investment Earnings 4,809 (459) 1,600 3,296 3,271 3,245 3,216 3,185 3,152 3,118 3,081 3,041 Total 399,304 392,888 400,040 409,705 417,808 426,072 434,500 443,095 451,861 460,800 469,917 479,214 Expenditures Supplies 405 10 - - - - - - - - - - Other Services & Charges 394,117 401,643 405,659 409,716 417,910 426,269 434,794 443,490 452,360 461,407 470,635 480,048 Insurance 1,880 1,404 1,404 1,418 1,432 1,447 1,461 1,476 1,490 1,505 1,520 1,536 Total 396,402 403,057 407,063 411,134 419,343 427,715 436,255 444,965 453,850 462,912 472,155 481,583 Cash Balance - Beginning 200,047 205,558 195,389 188,366 186,937 185,403 183,760 182,005 180,134 178,145 176,033 173,794 Changes in Accruals 2,609 - - - - - - - - - - - Revenues 399,304 392,888 400,040 409,705 417,808 426,072 434,500 443,095 451,861 460,800 469,917 479,214 Expenditures (396,402) (403,057) (407,063) (411,134) (419,343) (427,715) (436,255) (444,965) (453,850) (462,912) (472,155) (481,583) Noncash - Depreciation - - - - - - - - - - - - Cash Balance - Ending 205,558$ 195,389$ 188,366$ 186,937$ 185,403$ 183,760$ 182,005$ 180,134$ 178,145$ 176,033$ 173,794$ 171,425$ $- $50,000 $100,000 $150,000 $200,000 $250,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Recycling Fund Utility Cash Balance - Ending