Loading...
HomeMy WebLinkAbout2021 07-07 CCPV I RT UA L meeting being conducted by electronic means in accordance with Minnesota S tatutes, section 13D.021 P ublic portion available for connection via telephone Dial: 1-312-626- 6799 Meeting I D: 95813772525# Passcode: 174117# J uly 7, 2021 AGE NDA 1.Call to Order 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.Roll Call 3.Approval of Agenda 4.Capital Improvement P lan 2022-2036 5.Individual Capital P rojects F unds a.Capital Improvement F unds b.M unicipal State Aid F unds c.Street Reconstruction Fund d.Special Assessments F und e.Overview of Utility Funds 6.Adjournment Table 2 Capital Improvement Program (2022 - 2036) June 22, 2021 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 2022-2036 2022 Woodbine Area Improvements $930,000 $2,310,000 $200,000 $940,000 $1,870,000 $3,080,000 $110,000 $9,440,000 Revised assessment type from Full Reconstruction to Partial Reconstruction Brooklyn Blvd City North Entrance Sign Rehab $135,000 $135,000 Carryover from 2021 Miscellaneous Park Parking Lot Mill and Overlay $550,000 $550,000 West River Rd, Arboretum, Freeway, Palmer Lake & Northport Trail Replacements $548,000 $548,000 Park Playground Equipment Replacement $605,000 $605,000 Per CARS park list/costs Storm Water Ponds 12-001, 12-006 & 57-003 Rehab $124,000 $124,000 Freeway and Highway Utility Crossing Replacement $194,000 $393,000 $587,000 Lift Station No. 4 Rehabilitation $259,000 $259,000 I94/Dupont Ave Water Main Crossing Replacement $364,000 $364,000 Water Treatment Plant Redundant Water Main Connection $352,000 $352,000 Well No. 7 and Water Treatment Plant HSP No. 1 $160,000 $160,000 CMBP: All - Fire Alarm/Annunciator Replacement $63,000 $63,000 CMBP: CC, CH, Fire, PW, Police - Expansion Joint Caulking $100,000 $100,000 CMBP: CH, PW, Fire, Police - Carpet & Paint $210,000 $210,000 Combine 2021 and 2022 projects CMBP: Civic Center - Cooling Replace (Chillers/condensers) $125,000 $125,000 CMBP: Police - All Condenser & Liebert Unit $95,000 $95,000 added Liebert unit CMBP: Police - Generator/Transfer Replacement $180,000 $180,000 Previously 2028 CMBP: PW Garage - Roof Replacement $494,000 $494,000 Carryover from 2021 2022 Subtotal $930,000 $2,310,000 $200,000 $1,064,000 $2,323,000 $4,349,000 $110,000 $3,105,000 $14,391,000 2023 50th Avenue Improvements (France Ave to Drew Ave) $50,000 $100,000 $40,000 $20,000 $160,000 $370,000 51st Avenue Improvements (west of France Avenue) $100,000 $120,000 $70,000 $10,000 $10,000 $20,000 $330,000 Revised assessment type from Full Reconstruction to Partial Reconstruction Knox, James and 54th Ave. Area Improvements $270,000 $500,000 $240,000 $20,000 $100,000 $1,130,000 Revised assessment type from Full Reconstruction to Partial Reconstruction Traffic Sig Sys Rehab (Shingle Creek Pkwy/Summit) $106,000 $317,000 $423,000 Previously 2022, Opportunity Site Area: Could move years pending master plan Increase due to signal cabinet and ADA improvements Traffic Sig Sys Rehab. (Shingle Creek Pkwy/John Martin) $106,000 $317,000 $423,000 Previously 2022, Opportunity Site Area: Could move years pending master plan Earle Brown/Opportunity Area Street Light Replacement $261,000 $261,000 Opportunity Site Area: Could move years pending master plan Centennial Park Improvements $133,000 $133,000 Carryover from 2018 Evergreen Park Score Board Improvements $144,000 $144,000 Evergreen, Firehouse & Northport Park Security Improvements $239,000 $239,000 Park Playground Equipment Replacement $443,000 $443,000 Per CARS park list/costs Lift Station No. 5 Rehabilitation $251,000 $251,000 Lift Station No. 9 Rehabilitation $606,000 $606,000 Previously 2022, Opportunity Site Area: Could move years pending master plan Lift Station No. 9 Force Main Replacement $333,000 $333,000 Previously 2022, Opportunity Site Area: Could move years pending master plan Well Nos. 4 and 9; Water Treatment Plant HSP No. 2 $185,000 $185,000 65th Avenue Trunk Storm Sewer Rehabilitation $1,591,000 $1,591,000 61st & Perry Avenues Storm Sewer Improvement $185,000 $185,000 Carryover from 2021, move to align with pond project Storm Water Pond 48-001 Rehab $318,000 $318,000 CMBP: City Hall - Community Development Office Remodel $260,000 $260,000 Carryover from 2021: Could move years pending Opportunity Site master plan CMBP: Civic Center - Air Handlers #4, #5 Replace $71,000 $71,000 CMBP: East/West Fire - Roof Replacement $386,000 $386,000 CMBP: West Fire - Rooftop Unit Replacement $61,000 $61,000 CMBP: Police - Parking Lot Mill & Overlay $114,000 $114,000 CMBP: Public Works - Lighting System Upgrade $102,000 $102,000 2023 Subtotal $420,000 $932,000 $634,000 $2,444,000 $1,240,000 $455,000 $281,000 $1,953,000 $8,359,000 2024 Orchard Lane East Improvements $1,410,000 $3,420,000 $920,000 $1,930,000 $3,720,000 $150,000 $11,550,000 Could consider splitting the project up in the future due to size Revised assessment type from Full Reconstruction to Partial Reconstruction Humboldt Avenue (CR 57) Reconstruction (53rd to 57th)$340,000 $1,835,000 $155,000 $510,000 $460,000 $20,000 $700,000 (A)$4,020,000 HC has $700,000 in HC CIP Centennial Park Softball Field Improvements $579,000 $579,000 Park Playground Equipment Replacement $304,000 $304,000 CARS park list/costs (Freeway,Lions,Evergreen) Well Nos. 6 and 8; Water Treatment Plant HSP No. 3 $191,000 $191,000 CMBP: City Hall/CC Addition - Roof Replacement $429,000 $429,000 2024 Subtotal $1,750,000 $5,255,000 $1,075,000 $2,440,000 $4,371,000 $170,000 $2,012,000 $17,073,000 NOTES:(A) Anticipated Hennepin County ($700k) funding share - Humboldt Ave is a county road (CR 57) 2025 Orchard Lane West Area Improvements $2,040,000 $3,980,000 $1,130,000 $2,230,000 $180,000 $190,000 $9,750,000 Could consider splitting the project up in the future due to size Revised assessment type from Full Reconstruction to Partial Reconstruction 53rd and Xerxes Avenue Improvements $80,000 $460,000 $120,000 $60,000 $720,000 No cost participation by City of Minneapolis per 1970 agreement Revised assessment type from Full Reconstruction to Partial Reconstruction 69th Ave (CSAH 130) Reconstruction (Unity to Brooklyn Blvd)$794,000 $132,000 $750,000 $950,000 $10,000 $3,704,000 (B)$6,340,000 Not in current HC CIP: Place hold for potential Brooklyn Center cost share Traffic Sig Sys Rehab.(Shingle Creek Pkwy/Brookdale Sq) $148,000 $301,000 $449,000 Opportunity Site Area: Could move years pending master plan Park Name Sign Replacements $72,000 $72,000 Basketball Courts Pavement Replacements $144,000 $144,000 Storm Water Pond 17-001 Rehab $150,000 $150,000 Well Nos. 2 and 3; Water Treatment Plant HSP No. 4 $197,000 $197,000 CMBP: East/West Fire - Parking Lot Mill & Overlay $125,000 $125,000 CMBP: Police - Roof Replacement $283,000 $283,000 2025 Subtotal $2,120,000 $5,382,000 $301,000 $1,532,000 $2,980,000 $1,327,000 $260,000 $4,328,000 $18,230,000 NOTES:(B) Hennepin County funding estimated at 80% for street and storm costs and 20% City funding C:\Users\asplinter\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\DX48WVXK\210629_DRAFT_2022-2036 CIP Table 2_v2 Page | 6 Table 2 Capital Improvement Program (2022 - 2036) June 22, 2021 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 2022-2036 2026 Meadowlark Gardens Area Improvements $540,000 $850,000 $590,000 $470,000 $120,000 $360,000 $120,000 $3,050,000 Revised assessment type from Full Reconstruction to Partial Reconstruction 67th Avenue and James Avenue Mill and Overlay $200,000 $90,000 $120,000 $10,000 $70,000 $20,000 $510,000 68th Avenue and Lee Avenue Mill and Overlay $130,000 $100,000 $100,000 $10,000 $70,000 $20,000 $430,000 John Martin Drive Mill and Overlay $140,000 $220,000 $40,000 $10,000 $50,000 $60,000 $520,000 St. Alphonses Area Mill and Overlay $410,000 $230,000 $250,000 $30,000 $160,000 $50,000 $1,130,000 TH 252/66th Interchange and 70th Pedestrian Overpass $35,000,000 (C) $35,000,000 Previously 2025 Hockey Rink Rehabilitation/Replacements $327,000 $327,000 Irrigation Systems Rehabilitation/Replacements $143,000 $143,000 Storm Water Ponds 41-001, 41-002 & 53-001 Rehab $152,000 $152,000 Lift Station Nos. 3 Rehabilitation $281,000 $281,000 Discuss moving to 2024 for consistency in equipment Well No. 5 and Water Treatment Plant HSP (BW) $110,000 $110,000 CMBP: Community Center - Water Slide Skylight $58,000 $58,000 CMBP: Public Works Cold - Roof Replacement $124,000 $124,000 CMBP: Public Works Salt - Roof Replacement $59,000 $59,000 2026 Subtotal $1,420,000 $1,270,000 $810,000 $1,132,000 $461,000 $820,000 $270,000 $35,711,000 $41,894,000 NOTES: 2027 Earle Brown Drive Area Improvements $690,000 $950,000 $470,000 $140,000 $20,000 $20,000 $2,290,000 Humboldt Avenue Mill and Overlay (65th to 69th) $130,000 $580,000 $80,000 $20,000 $20,000 $10,000 $840,000 Could move years pending TH 252 Humboldt Avenue Improvements (69th to 73rd) $180,000 $610,000 $130,000 $440,000 $240,000 $40,000 $1,640,000 Revised assessment type from Full Reconstruction to Partial Reconstruction Softball/Baseball Fence Replacement $65,000 $65,000 69th Avenue Trail Reconstruction $220,000 $220,000 69th Avenue Landscape Rehabilitation $148,000 $148,000 Well No. 10 and Water Treatment Plant HSP No. 1 $114,000 $114,000 CMBP: West Fire - Generator/Transfer Replacement $194,000 $194,000 CMBP: Police - Condenser Jail $68,000 $68,000 2027 Subtotal $1,000,000 $950,000 $1,660,000 $350,000 $480,000 $394,000 $50,000 $695,000 $5,579,000 2028 Garden City Central Area Mill and Overlay $730,000 $1,880,000 $300,000 $1,080,000 $420,000 $110,000 $4,520,000 Shingle Creek Pkwy and Xerxes Ave Mill and Overlay $560,000 $1,080,000 $290,000 $40,000 $470,000 $80,000 $2,520,000 65th/66th Avenue and Camden Avenue Mill and Overlay $110,000 $280,000 $660,000 $170,000 $320,000 $20,000 $1,560,000 Could move years pending TH 252 73rd Avenue Mill and Overlay (Humboldt to Camden) $40,000 $80,000 $120,000 $70,000 $20,000 $10,000 $310,000 (D) $650,000 Could move years pending TH 252 Park Trail and Parking Lot Lighting Improvements $408,000 $408,000 Water Meter Full System Replacement $562,000 $1,686,000 $2,248,000 Well No. 7 and Water Treatment Plant HSP No. 2 $117,000 $117,000 Emergency Responder Radio Replacement (Police/Fire/PW)$600,000 $600,000 2028 Subtotal $1,440,000 $2,240,000 $2,160,000 $1,610,000 $1,362,000 $2,413,000 $80,000 $1,318,000 $12,623,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,500,000 $2,840,000 $760,000 $640,000 $7,360,000 Retaining Wall Replacement (miscellaneous locations) $126,000 $126,000 Storm Water Ponds 11-001, 59-003, 60-003, 63-001, 63-002 & 64-001 Rehab $112,000 $112,000 Lift Station Nos. 7 and 10 Rehabilitation $1,103,000 $1,103,000 Discuss moving LS 7 to 2026 and LS 10 to 2025 for consistency in equipment Well Nos. 4 and 9 and Water Treatment Plant HSP No. 3 $218,000 $218,000 CMBP: City Hall - Ribbon Window Replacement $90,000 $90,000 CMBP: Community Center - Ribbon Window Replacement $108,000 $108,000 2029 Subtotal $620,000 $2,500,000 $2,952,000 $1,863,000 $858,000 $324,000 $9,117,000 2030 Garden City South Area Mill and Overlay $490,000 $2,440,000 $1,040,000 $1,430,000 $820,000 $1,810,000 $10,000 $8,040,000 Sanitary Sewer Lining (Miss. River Trunk N. of I-694 to 70th/Willow) $1,629,000 $1,629,000 Lift No. 2 Forcemain Lining (Under I-94) $268,000 $268,000 Well Nos. 6 and 8; Water Treatment Plant HSP No. 4 $221,000 $221,000 CMBP: City Hall - Main Switch Gear Replacement $285,000 $285,000 CMBP: Community Center - Carpet Replacement $73,000 $73,000 2030 Subtotal $490,000 $2,440,000 $1,040,000 $1,430,000 $2,717,000 $2,031,000 $10,000 $358,000 $10,516,000 2031 Southwest Area Mill and Overlay $560,000 $1,300,000 $1,160,000 $1,060,000 $570,000 $1,280,000 $60,000 $5,990,000 Park Bleacher Replacement $67,000 $67,000 Storm Water Pond 57-004, 57-005 & 70-002 Rehab $69,000 $69,000 Lift Station No. 1 Generator Replacement $221,000 $221,000 Well Nos. 2 and 3 and Water Treatment Plant HSP (BW) $225,000 $225,000 CMBP: City Hall - Brick Veneer Restoration $142,000 $142,000 CMBP: Community Center - Brick Veneer Restoration $221,000 $221,000 2031 Subtotal $560,000 $1,300,000 $1,160,000 $1,129,000 $791,000 $1,505,000 $60,000 $430,000 $6,935,000 (C) Provisional project: funding estimated outside source ($29,500,000) and City Capital Improvements Fund ($5,500,000) C:\Users\asplinter\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\DX48WVXK\210629_DRAFT_2022-2036 CIP Table 2_v2 Page | 7 Table 2 Capital Improvement Program (2022 - 2036) June 22, 2021 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 2022-2036 2032 Happy Hollow Mill and Overlay $310,000 $1,140,000 $310,000 $830,000 $220,000 $390,000 $50,000 $3,250,000 Southeast Alleys Improvements $1,320,000 $10,000 $1,330,000 Park Bleacher Replacement $88,000 $88,000 Brooklyn Blvd Street Light Replacement (65th to BP Border) $948,000 $948,000 Storm Water Pond 12-002, 12-003, 12-004, 12-005 & 18-001 Rehab $616,000 $616,000 Well No. 5 and Water Treatment Plant HSP No. 1 $124,000 $124,000 CMBP: East Fire - Epoxy Floor Replacement $53,000 $53,000 CMBP: West Fire - Epoxy Floor Replacement $72,000 $72,000 CMBP: Public Works - Exterior Paint $115,000 $115,000 CMBP: Public Works - Make Up Air (2) Replacement $180,000 $180,000 2032 Subtotal $1,630,000 $1,140,000 $310,000 $1,446,000 $220,000 $514,000 $60,000 $1,456,000 $6,776,000 2033 Northport Area Mill and Overlay $370,000 $1,030,000 $610,000 $620,000 $120,000 $70,000 $2,820,000 Traffic Sig Sys Rehab.(65th Avenue/Dupont Ave) $529,000 $529,000 TH 252 Impacts?: Could move years pending TH 252 recommended improvements Traffic Sig Sys Rehab.(66th Ave/Camden Ave) $264,000 $264,000 $528,000 TH 252 Impacts?: Could move years pending TH 252 recommended improvements Evergreen Park Football/Soccer Field Improvements $145,000 $145,000 Well No. 10 and Water Treatment Plant HSP No. 2 $126,000 $126,000 Self Contained Breathing Apparatus (SCBA) Replacement (Fire) $612,500 $612,500 CMBP: Public Works - Main Switch Gear Replacement $252,000 $252,000 CMBP: Public Works - Generator/Transfer Replacement $197,000 $197,000 2033 Subtotal $370,000 $1,294,000 $1,403,000 $620,000 $120,000 $196,000 $1,206,500 $5,209,500 2034 Lions Park South Mill and Overlay $380,000 $1,550,000 $780,000 $110,000 $70,000 $2,890,000 73rd Avenue (Penn to Humboldt) Mill and Overlay $40,000 $170,000 $85,000 $130,000 $210,000 $295,000 (E) $930,000 Need to coordinate with City of Brooklyn Park Well No. 7 and Water Treatment Plant HSP No. 3 $128,000 $128,000 CMBP: Public Works - Make Up Air (2) Replacement $108,000 $108,000 CMBP: East/West Fire - Overhead Door Replacements $242,000 $242,000 CMBP: Community Center - Sauna Reconstruction $110,000 $110,000 2034 Subtotal $420,000 $1,720,000 $865,000 $240,000 $408,000 $755,000 $4,408,000 NOTES:(E) 50% Cost sharing of street & storm with City of Brooklyn Park ($285k) per 2004 agreement 2035 Centerbrook Area Mill and Overlay $280,000 $1,280,000 $590,000 $80,000 $50,000 $2,280,000 Shingle Creek Pkwy/Summit Dr/Earle Brown Mill and Overlay $500,000 $480,000 $2,390,000 $490,000 $510,000 $1,210,000 $5,580,000 Well Nos. 4 and 9 and Water Treatment Plant HSP No. 4 $239,000 $239,000 CMBP: Community Center - RTU #1 & #2 $308,000 $308,000 2035 Subtotal $780,000 $1,760,000 $2,390,000 $1,080,000 $590,000 $1,499,000 $308,000 $8,407,000 2036 Freeway Blvd Area Improvements $760,000 $1,680,000 $3,140,000 $290,000 $560,000 $900,000 $7,330,000 New Riverwood Area Improvements $1,110,000 $3,813,000 $1,670,000 $1,530,000 $1,600,000 $167,000 (F) $9,890,000 New Storm Water Pond 46-001, 50-001, 52-001, 60-001 & 63-006 Rehab $600,000 $600,000 New Well Nos. 6 and 8 and Water Treatment Plant HSP (BW)$242,000 $242,000 New 2035 Subtotal $1,870,000 $5,493,000 $3,140,000 $2,560,000 $2,090,000 $2,742,000 $167,000 $18,062,000 NOTES:(F) 50% Cost sharing of 73rd Avenue street improvements with City of Brooklyn Park ($167k) TOTALS $15,820,000 $35,986,000 $15,208,000 $21,289,000 $19,917,000 $23,882,000 $1,351,000 $54,126,500 $187,579,500 C:\Users\asplinter\AppData\Local\Microsoft\Windows\INetCache\Content.Outlook\DX48WVXK\210629_DRAFT_2022-2036 CIP Table 2_v2 Page | 8 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 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Revenues Intergovernmental (Maintenance) 160,000$ 175,000$ 180,000$ 185,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ 190,000$ Intergovernmental (Construction) 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 1,252,471 Investment Earnings 72,176 51,359 30,931 48,696 60,371 83,346 101,455 110,974 105,784 91,753 115,277 121,013 124,749 143,425 143,301 143,301 167,727 Total 1,484,647 1,478,830 1,463,402 1,486,167 1,502,842 1,525,817 1,543,926 1,553,445 1,548,255 1,534,224 1,557,748 1,563,484 1,567,220 1,585,896 1,585,772 1,585,772 1,610,198 Expenditures Supplies 62,993 70,000 72,000 74,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 76,000 Other Services & Charges 42,841 105,000 108,000 111,000 114,000 114,000 114,000 114,000 114,000 114,000 114,000 114,000 114,000 114,000 114,000 114,000 114,000 Capital Outlay 564 1,962,494 268,284 634,000 - 301,000 810,000 1,660,000 2,160,000 - 1,040,000 1,160,000 310,000 1,403,000 - 2,390,000 3,140,000 Total 106,398 2,137,494 448,284 819,000 190,000 491,000 1,000,000 1,850,000 2,350,000 190,000 1,230,000 1,350,000 500,000 1,593,000 190,000 2,580,000 3,330,000 Cash Balance - Beginning 2,984,961 3,108,623 1,767,484 2,782,602 3,449,769 4,762,611 5,797,428 6,341,354 6,044,799 5,243,054 6,587,278 6,915,026 7,128,510 8,195,730 8,188,626 8,188,626 7,194,398 Changes in Accruals (1,254,587) (682,475) - - - - Revenues 1,484,647 1,478,830 1,463,402 1,486,167 1,502,842 1,525,817 1,543,926 1,553,445 1,548,255 1,534,224 1,557,748 1,563,484 1,567,220 1,585,896 1,585,772 1,585,772 1,610,198 Expenditures (106,398) (2,137,494) (448,284) (819,000) (190,000) (491,000) (1,000,000) (1,850,000) (2,350,000) (190,000) (1,230,000) (1,350,000) (500,000) (1,593,000) (190,000) (2,580,000) (3,330,000) Cash Balance - Ending 3,108,623$ 1,767,484$ 2,782,602$ 3,449,769$ 4,762,611$ 5,797,428$ 6,341,354$ 6,044,799$ 5,243,054$ 6,587,278$ 6,915,026$ 7,128,510$ 8,195,730$ 8,188,626$ 9,584,398$ 7,194,398$ 5,474,596$ 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. - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2029 2030 2031 2032 2033 2034 2035 2036 MSA Fund Expenditures Cash Balance - Ending City of Brooklyn Center Street Reconstruction Fund Cash Flows Analysis Revised: 7-4-21 Actual Budget Budget Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Revenues Franchise Fees 738,213$ 740,000$ 740,000$ 762,000$ 762,000$ 762,000$ 785,000$ 785,000$ 785,000$ 809,000$ 809,000$ 809,000$ 809,000$ 809,000$ 809,000$ 809,000$ 809,000$ Investment Earnings 175,021 95,058 60,836 67,850 66,063 80,554 50,989 43,393 41,265 55,725 62,108 77,352 70,113 65,548 58,207 43,283 27,398 Future Bonds - Levies - - 231,479 455,390 455,390 1,063,602 1,397,709 1,397,709 1,397,709 1,660,305 1,894,766 2,180,809 1,949,329 1,725,419 1,725,419 1,117,207 783,100 Bond Proceeds 2,036,687 2,000,000 1,910,000 - 5,255,000 2,850,000 - - 2,240,000 2,000,000 2,440,000 - - - - - 3,800,000 Total 2,949,921 2,835,058 2,942,315 1,285,240 6,538,453 4,756,156 2,233,697 2,226,102 4,463,974 4,525,030 5,205,874 3,067,161 2,828,442 2,599,967 2,592,626 1,969,490 5,419,498 Expenditures Capital Outlay 4,227,779 4,448,670 2,310,000 932,000 5,255,000 5,382,000 1,270,000 950,000 2,240,000 2,500,000 2,440,000 1,300,000 1,140,000 1,294,000 1,720,000 1,760,000 5,493,000 Debt Service (Projected)- - 231,479 455,390 455,390 1,063,602 1,397,709 1,397,709 1,397,709 1,660,305 1,894,766 2,180,809 1,949,329 1,725,419 1,725,419 1,117,207 783,100 Bond Issue Costs 34,857 - - - - - - - - - - - - - - - - Total 4,262,636 4,448,670 2,541,479 1,387,390 5,710,390 6,445,602 2,667,709 2,347,709 3,637,709 4,160,305 4,334,766 3,480,809 3,089,329 3,019,419 3,445,419 2,877,207 6,276,100 Cash Balance - Beginning 6,264,909 5,089,944 3,476,332 3,877,168 3,775,018 4,603,081 2,913,635 2,479,623 2,358,017 3,184,282 3,549,007 4,420,115 4,006,467 3,745,580 3,326,128 2,473,335 1,565,618 Changes in Accruals 137,750 - - - - - - - - - - - - - - - - Revenues 2,949,921 2,835,058 2,942,315 1,285,240 6,538,453 4,756,156 2,233,697 2,226,102 4,463,974 4,525,030 5,205,874 3,067,161 2,828,442 2,599,967 2,592,626 1,969,490 5,419,498 Expenditures (4,262,636) (4,448,670) (2,541,479) (1,387,390) (5,710,390) (6,445,602) (2,667,709) (2,347,709) (3,637,709) (4,160,305) (4,334,766) (3,480,809) (3,089,329) (3,019,419) (3,445,419) (2,877,207) (6,276,100) Cash Balance - Ending 5,089,944$ 3,476,332$ 3,877,168$ 3,775,018$ 4,603,081$ 2,913,635$ 2,479,623$ 2,358,017$ 3,184,282$ 3,549,007$ 4,420,115$ 4,006,467$ 3,745,580$ 3,326,128$ 2,473,335$ 1,565,618$ 709,016$ Existing Levies 1,409,746 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 - - 231,479 455,390 455,390 1,063,602 1,397,709 1,397,709 1,397,709 1,660,305 1,894,766 2,180,809 1,949,329 1,725,419 1,725,419 1,117,207 783,100 Total Tax levy for bonds 1,409,746 1,454,502 1,681,474 1,723,813 1,708,176 2,165,635 2,485,147 2,243,481 2,031,769 2,031,248 2,043,065 2,180,809 1,949,329 1,725,419 1,725,419 1,117,207 783,100 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 - 1,000,000 2,000,000 3,000,000 4,000,000 5,000,000 6,000,000 7,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Street Reconstruction Fund Expenditures Cash Balance - Ending City of Brooklyn Center Water Utility Cash Flows Revised: 6-30-21 Prior Projected Change 9.00%9.00%9.00%9.00%5.00%3.00%3.00%2.00%0.00%0.00%-2.00%-3.00%-5.00%-5.00%-5.00%-5.00% Rate Change - Proposed 7.00%5.00%9.00%9.00%9.00%7.00%7.00%7.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.)66.47$ 69.82$ 76.07$ 83.00$ 90.44$ 96.70$ 103.43$ 110.64$ 112.81$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ Per Quarter Change 4.33$ 3.35$ 6.25$ 6.93$ 7.44$ 6.26$ 6.73$ 7.21$ 2.17$ 2.18$ -$ -$ -$ -$ -$ -$ Base Charge 16.61$ 17.44$ 19.01$ 20.72$ 22.58$ 24.16$ 25.85$ 27.66$ 28.21$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ Consumption Charge (0-30)2.77$ 2.91$ 3.17$ 3.46$ 3.77$ 4.03$ 4.31$ 4.61$ 4.70$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ Consumption Charge (30-60)3.45$ 3.62$ 3.95$ 4.31$ 4.70$ 5.03$ 5.38$ 5.76$ 5.88$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ Consumption Charge (60+)5.15$ 5.41$ 5.90$ 6.43$ 7.01$ 7.50$ 8.03$ 8.59$ 8.76$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,206,283$ 4,513,482$ 4,919,695$ 5,362,468$ 5,845,090$ 6,254,246$ 6,692,044$ 7,160,487$ 7,303,696$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ Investment Earnings 87,134 32,600 32,600 12,249 8,358 11,392 15,895 13,469 18,587 22,076 27,623 25,321 29,739 46,264 69,192 89,840 Nonoperating 74,034 - - - - - - - - - - - - - - - Bond Proceeds (GO) 1,825,604 1,900,000 3,800,000 - 4,260,000 1,500,000 - - 1,600,000 - - - - - - - Total 6,193,055 6,446,082 8,752,295 5,374,716 10,113,448 7,765,639 6,707,939 7,173,955 8,922,283 7,471,846 7,477,393 7,475,091 7,479,510 7,496,034 7,518,963 7,539,610 Expenditures Personal Servcies 610,323 648,502 667,957 687,996 708,636 729,895 751,792 774,345 797,576 821,503 846,148 871,532 897,678 924,609 952,347 980,917 Supplies 316,795 340,510 347,320 354,267 361,352 368,579 375,951 383,470 391,139 398,962 406,941 415,080 423,381 431,849 440,486 449,296 Other Services & Charges 932,051 809,531 825,722 842,236 859,081 876,262 893,788 911,663 929,897 948,495 967,464 986,814 1,006,550 1,026,681 1,047,215 1,068,159 Insurance 45,435 56,810 57,946 59,105 60,287 61,493 62,723 63,977 65,257 66,562 67,893 69,251 70,636 72,049 73,490 74,960 Utilities 219,288 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 312,585 Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Capital Outlay (CIP) 2,515,184 3,084,574 4,539,724 455,000 4,371,000 1,327,000 820,000 394,000 2,413,000 858,000 2,031,000 1,505,000 514,000 196,000 408,000 1,499,000 Capital Outlay (Other) - 100,000 - - - - - - - - - - - - - - Debt Service (Existing) 1,079,960 1,157,641 1,357,612 1,361,887 1,364,548 1,351,828 1,342,434 1,342,140 1,196,262 827,178 474,039 191,188 - - - - Debt Service (PFA) 1,140,130 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) - - 219,905 659,716 659,716 1,152,768 1,328,613 1,328,613 1,328,613 1,516,182 1,516,182 1,516,182 1,296,277 856,466 856,466 363,415 Total 8,659,284 9,374,778 11,198,214 7,607,048 11,576,270 9,065,282 8,777,556 8,405,267 10,334,607 8,655,547 9,533,135 8,784,177 7,443,428 6,748,450 7,024,809 7,688,681 Cash Balance - Beginning 3,844,265 3,135,562 2,006,866 1,360,947 928,616 1,265,794 1,766,150 1,496,532 2,065,221 2,452,898 3,069,197 2,813,455 3,304,370 5,140,452 7,688,036 9,982,190 Changes in Accruals (42,591) - - - - - - - - - - - - - - - Revenues 6,193,055 6,446,082 8,752,295 5,374,716 10,113,448 7,765,639 6,707,939 7,173,955 8,922,283 7,471,846 7,477,393 7,475,091 7,479,510 7,496,034 7,518,963 7,539,610 Expenditures (8,659,284) (9,374,778) (11,198,214) (7,607,048) (11,576,270) (9,065,282) (8,777,556) (8,405,267) (10,334,607) (8,655,547) (9,533,135) (8,784,177) (7,443,428) (6,748,450) (7,024,809) (7,688,681) Noncash - Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Cash Balance - Ending 3,135,562$ 2,006,866$ 1,360,947$ 928,616$ 1,265,794$ 1,766,150$ 1,496,532$ 2,065,221$ 2,452,898$ 3,069,197$ 2,813,455$ 3,304,370$ 5,140,452$ 7,688,036$ 9,982,190$ 11,633,119$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 City of Brooklyn Center Sanitary Sewer Utility Cash Flows Revised: 6-30-21 5.00%5.00%5.00%5.00%2.00%2.00%2.00%2.00%2.00%1.00%0.00%0.00%0.00%0.00%0.00%0.00% Rate Change 5.00%5.00%5.00%5.00%3.00%2.00%2.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.89.14$ 93.59$ 98.27$ 103.19$ 106.28$ 108.41$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ Per Quarter Change 4.24$ 4.46$ 4.68$ 4.91$ 3.10$ 2.13$ 2.17$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,662,342$ 4,895,459$ 5,140,232$ 5,397,244$ 5,559,161$ 5,670,344$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ Investment Earnings 152,855 42,600 32,984 30,592 25,157 23,830 23,951 23,168 23,170 20,638 8,715 8,976 4,640 7,091 11,262 13,548 Nonoperating 8,693 - - - - - - - - - - - - - - - Bond Proceeds 1,118,107 1,400,000 1,600,000 - 1,580,000 2,420,000 - - 550,000 - 2,300,000 - - - - - Total 5,941,997 6,338,059 6,773,217 5,427,836 7,164,318 8,114,174 5,807,702 5,806,919 6,356,921 5,804,389 8,092,466 5,792,728 5,788,391 5,790,842 5,795,013 5,797,299 Expenditures Personal Services 270,334 271,719 279,871 288,267 296,915 305,822 314,997 324,447 334,180 344,205 354,532 365,168 376,123 387,406 399,029 410,999 Supplies 26,058 58,475 59,645 60,837 62,054 63,295 64,561 65,852 67,169 68,513 69,883 71,980 74,139 76,363 78,654 81,014 Other Services & Charges 3,034,503 3,042,607 3,103,459 3,165,528 3,228,839 3,293,416 3,359,284 3,426,470 3,494,999 3,564,899 3,636,197 3,708,921 3,783,099 3,858,761 3,935,937 4,014,655 Insurance 21,115 25,371 25,878 26,396 26,924 27,462 28,012 28,572 29,143 29,726 30,321 31,230 32,167 33,132 34,126 35,150 Utilities 36,689 39,100 39,882 40,680 41,493 42,323 43,170 44,033 44,914 45,812 46,728 48,130 49,574 51,061 52,593 54,171 Depreciation 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 Capital Outlay 3,678,642 3,370,488 2,492,900 1,240,000 2,440,000 2,980,000 461,000 480,000 1,362,000 1,863,000 2,717,000 791,000 220,000 120,000 240,000 590,000 Debt Service (Existing)617,889 743,451 875,364 871,657 876,904 866,395 817,565 630,804 498,910 341,135 336,399 115,719 - - - - Debt Service (Projected)- - 162,036 338,322 338,714 521,985 806,097 806,522 806,959 871,884 872,346 1,142,450 980,901 800,674 800,674 617,805 Total 8,663,091 8,529,073 8,016,895 7,009,548 8,289,704 9,078,560 6,872,546 6,784,560 7,616,135 8,107,036 9,041,266 7,252,458 6,493,864 6,305,259 6,518,873 6,781,655 Cash Balance - Beginning 6,569,127 4,878,097 3,664,944 3,399,126 2,795,275 2,647,750 2,661,225 2,574,243 2,574,463 2,293,110 968,324 997,385 515,516 787,904 1,251,348 1,505,350 Changes in Accruals 52,203 - - - - - - - - - - - - - - - Revenues 5,941,997 6,338,059 6,773,217 5,427,836 7,164,318 8,114,174 5,807,702 5,806,919 6,356,921 5,804,389 8,092,466 5,792,728 5,788,391 5,790,842 5,795,013 5,797,299 Expenditures (8,663,091) (8,529,073) (8,016,895) (7,009,548) (8,289,704) (9,078,560) (6,872,546) (6,784,560) (7,616,135) (8,107,036) (9,041,266) (7,252,458) (6,493,864) (6,305,259) (6,518,873) (6,781,655) Noncash - Depreciation 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 Cash Balance - Ending 4,878,097$ 3,664,944$ 3,399,126$ 2,795,275$ 2,647,750$ 2,661,225$ 2,574,243$ 2,574,463$ 2,293,110$ 968,324$ 997,385$ 515,516$ 787,904$ 1,251,348$ 1,505,350$ 1,498,855$ 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 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance (ending) City of Brooklyn Center Storm Water Utility Cash Flows Revised: 6-30-21 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%3.00%7.00%7.00%7.00%7.00%7.00%7.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.52$ 15.98$ 17.10$ 18.30$ 19.58$ 20.95$ 22.42$ 23.99$ 24.47$ 24.95$ 25.45$ 25.96$ 25.45$ 25.96$ 26.48$ 25.96$ 26.48$ Per Quarter Change 0.45$ 0.47$ 1.12$ 1.20$ 1.28$ 1.37$ 1.47$ 1.57$ 0.48$ 0.49$ 0.50$ 0.51$ 0.50$ 0.51$ 0.52$ 0.51$ 0.52$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Revenues Operating 1,691,946$ 1,742,704$ 1,864,694$ 1,995,222$ 2,134,888$ 2,284,330$ 2,444,233$ 2,615,329$ 2,667,636$ 2,720,989$ 2,775,408$ 2,830,917$ 2,887,535$ 2,945,286$ 3,004,191$ 3,064,275$ 3,125,561$ Investment Earnings 138,112 49,800 66,304 57,025 20,512 25,582 26,693 15,255 19,734 5,000 14,936 27,726 20,733 13,066 22,174 27,712 32,039 Intergovernmental 24,896 305,000 - - - - - - - - - - - - - - - Nonoperating - - - - - - - - - - - - - - - - - Bond Proceeds - 2,200,000 940,000 - 920,000 1,130,000 - - - 2,740,000 1,320,000 - - - - - - Total 1,854,954 4,297,504 2,870,997 2,052,248 3,075,400 3,439,912 2,470,926 2,630,584 2,687,370 5,465,989 4,110,345 2,858,643 2,908,268 2,958,352 3,026,366 3,091,988 3,157,600 Expenditures Personal Servcies 324,114 349,501 359,986 370,786 381,909 393,366 405,167 417,322 429,842 442,737 456,020 469,700 483,791 498,305 513,254 528,652 544,511 Supplies 13,541 49,100 50,082 51,084 52,105 53,147 54,210 55,295 56,400 57,528 58,679 59,853 61,050 62,271 63,516 64,786 66,082 Other Services & Charges 529,352 419,377 427,765 436,320 445,046 453,947 463,026 472,287 481,732 491,367 501,194 511,218 521,443 531,871 542,509 553,359 564,426 Insurance 2,759 3,427 3,496 3,565 3,637 3,709 3,784 3,859 3,937 4,015 4,096 4,177 4,261 4,346 4,433 4,522 4,612 Utilities 2,800 3,800 3,876 3,954 4,033 4,113 4,196 4,279 4,365 4,452 4,541 4,632 4,725 4,819 4,916 5,014 5,114 Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Capital Outlay 2,378,098 3,359,623 1,831,207 2,444,000 1,075,000 1,532,000 1,132,000 350,000 1,610,000 2,952,000 1,430,000 1,129,000 1,446,000 620,000 865,000 1,080,000 2,560,000 Debt Service (existing) 351,397 443,525 470,150 465,600 460,550 464,825 458,425 467,825 339,325 342,350 - - - - - - - Debt Service (projected) - - 254,627 363,423 363,423 471,275 603,745 603,745 603,745 603,745 924,957 1,079,701 825,074 716,278 716,278 608,426 475,956 Total 5,033,811 6,078,353 4,851,188 5,588,731 4,235,703 4,826,384 4,574,553 3,824,613 4,979,347 6,348,196 4,829,487 4,708,282 4,796,343 3,887,891 4,159,906 4,294,759 5,670,702 Cash Balance - Beginning 5,887,664 4,119,635 3,788,787 3,258,596 1,172,113 1,461,810 1,525,338 871,711 1,127,682 285,706 853,499 1,584,357 1,184,718 746,642 1,267,103 1,583,563 1,830,791 Changes in Accruals (20,922) - - - - - - - - - - - - - - - - Revenues 1,854,954 4,297,504 2,870,997 2,052,248 3,075,400 3,439,912 2,470,926 2,630,584 2,687,370 5,465,989 4,110,345 2,858,643 2,908,268 2,958,352 3,026,366 3,091,988 3,157,600 Expenditures (5,033,811) (6,078,353) (4,851,188) (5,588,731) (4,235,703) (4,826,384) (4,574,553) (3,824,613) (4,979,347) (6,348,196) (4,829,487) (4,708,282) (4,796,343) (3,887,891) (4,159,906) (4,294,759) (5,670,702) Noncash - Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Cash Balance - Ending 4,119,635$ 3,788,787$ 3,258,596$ 1,172,113$ 1,461,810$ 1,525,338$ 871,711$ 1,127,682$ 285,706$ 853,499$ 1,584,357$ 1,184,718$ 746,642$ 1,267,103$ 1,583,563$ 1,830,791$ 767,689$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted 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 4,500,000 5,000,000 2020 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 Water Utility Cash Flows Revised: 6-30-21 Prior Projected Change 9.00%9.00%9.00%9.00%5.00%3.00%3.00%2.00%0.00%0.00%-2.00%-3.00%-5.00%-5.00%-5.00%-5.00% Rate Change - Proposed 7.00%5.00%9.00%9.00%9.00%7.00%7.00%7.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.)66.47$ 69.82$ 76.07$ 83.00$ 90.44$ 96.70$ 103.43$ 110.64$ 112.81$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ 114.99$ Per Quarter Change 4.33$ 3.35$ 6.25$ 6.93$ 7.44$ 6.26$ 6.73$ 7.21$ 2.17$ 2.18$ -$ -$ -$ -$ -$ -$ Base Charge 16.61$ 17.44$ 19.01$ 20.72$ 22.58$ 24.16$ 25.85$ 27.66$ 28.21$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ 28.77$ Consumption Charge (0-30)2.77$ 2.91$ 3.17$ 3.46$ 3.77$ 4.03$ 4.31$ 4.61$ 4.70$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ 4.79$ Consumption Charge (30-60)3.45$ 3.62$ 3.95$ 4.31$ 4.70$ 5.03$ 5.38$ 5.76$ 5.88$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ 6.00$ Consumption Charge (60+)5.15$ 5.41$ 5.90$ 6.43$ 7.01$ 7.50$ 8.03$ 8.59$ 8.76$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ 8.94$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,206,283$ 4,513,482$ 4,919,695$ 5,362,468$ 5,845,090$ 6,254,246$ 6,692,044$ 7,160,487$ 7,303,696$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ 7,449,770$ Investment Earnings 87,134 32,600 32,600 12,249 8,358 11,392 15,895 13,469 18,587 22,076 27,623 25,321 29,739 46,264 69,192 89,840 Nonoperating 74,034 - - - - - - - - - - - - - - - Bond Proceeds (GO) 1,825,604 1,900,000 3,800,000 - 4,260,000 1,500,000 - - 1,600,000 - - - - - - - Total 6,193,055 6,446,082 8,752,295 5,374,716 10,113,448 7,765,639 6,707,939 7,173,955 8,922,283 7,471,846 7,477,393 7,475,091 7,479,510 7,496,034 7,518,963 7,539,610 Expenditures Personal Servcies 610,323 648,502 667,957 687,996 708,636 729,895 751,792 774,345 797,576 821,503 846,148 871,532 897,678 924,609 952,347 980,917 Supplies 316,795 340,510 347,320 354,267 361,352 368,579 375,951 383,470 391,139 398,962 406,941 415,080 423,381 431,849 440,486 449,296 Other Services & Charges 932,051 809,531 825,722 842,236 859,081 876,262 893,788 911,663 929,897 948,495 967,464 986,814 1,006,550 1,026,681 1,047,215 1,068,159 Insurance 45,435 56,810 57,946 59,105 60,287 61,493 62,723 63,977 65,257 66,562 67,893 69,251 70,636 72,049 73,490 74,960 Utilities 219,288 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 312,585 Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Capital Outlay (CIP) 2,515,184 3,084,574 4,539,724 455,000 4,371,000 1,327,000 820,000 394,000 2,413,000 858,000 2,031,000 1,505,000 514,000 196,000 408,000 1,499,000 Capital Outlay (Other) - 100,000 - - - - - - - - - - - - - - Debt Service (Existing) 1,079,960 1,157,641 1,357,612 1,361,887 1,364,548 1,351,828 1,342,434 1,342,140 1,196,262 827,178 474,039 191,188 - - - - Debt Service (PFA) 1,140,130 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) - - 219,905 659,716 659,716 1,152,768 1,328,613 1,328,613 1,328,613 1,516,182 1,516,182 1,516,182 1,296,277 856,466 856,466 363,415 Total 8,659,284 9,374,778 11,198,214 7,607,048 11,576,270 9,065,282 8,777,556 8,405,267 10,334,607 8,655,547 9,533,135 8,784,177 7,443,428 6,748,450 7,024,809 7,688,681 Cash Balance - Beginning 3,844,265 3,135,562 2,006,866 1,360,947 928,616 1,265,794 1,766,150 1,496,532 2,065,221 2,452,898 3,069,197 2,813,455 3,304,370 5,140,452 7,688,036 9,982,190 Changes in Accruals (42,591) - - - - - - - - - - - - - - - Revenues 6,193,055 6,446,082 8,752,295 5,374,716 10,113,448 7,765,639 6,707,939 7,173,955 8,922,283 7,471,846 7,477,393 7,475,091 7,479,510 7,496,034 7,518,963 7,539,610 Expenditures (8,659,284) (9,374,778) (11,198,214) (7,607,048) (11,576,270) (9,065,282) (8,777,556) (8,405,267) (10,334,607) (8,655,547) (9,533,135) (8,784,177) (7,443,428) (6,748,450) (7,024,809) (7,688,681) Noncash - Depreciation 1,800,118 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 1,800,000 Cash Balance - Ending 3,135,562$ 2,006,866$ 1,360,947$ 928,616$ 1,265,794$ 1,766,150$ 1,496,532$ 2,065,221$ 2,452,898$ 3,069,197$ 2,813,455$ 3,304,370$ 5,140,452$ 7,688,036$ 9,982,190$ 11,633,119$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted capital spending - 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 City of Brooklyn Center Sanitary Sewer Utility Cash Flows Revised: 6-30-21 5.00%5.00%5.00%5.00%2.00%2.00%2.00%2.00%2.00%1.00%0.00%0.00%0.00%0.00%0.00%0.00% Rate Change 5.00%5.00%5.00%5.00%3.00%2.00%2.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00% Residential - Flat Fee / Per Qtr.89.14$ 93.59$ 98.27$ 103.19$ 106.28$ 108.41$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ 110.58$ Per Quarter Change 4.24$ 4.46$ 4.68$ 4.91$ 3.10$ 2.13$ 2.17$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 4,662,342$ 4,895,459$ 5,140,232$ 5,397,244$ 5,559,161$ 5,670,344$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ 5,783,751$ Investment Earnings 152,855 42,600 32,984 30,592 25,157 23,830 23,951 23,168 23,170 20,638 8,715 8,976 4,640 7,091 11,262 13,548 Nonoperating 8,693 - - - - - - - - - - - - - - - Bond Proceeds 1,118,107 1,400,000 1,600,000 - 1,580,000 2,420,000 - - 550,000 - 2,300,000 - - - - - Total 5,941,997 6,338,059 6,773,217 5,427,836 7,164,318 8,114,174 5,807,702 5,806,919 6,356,921 5,804,389 8,092,466 5,792,728 5,788,391 5,790,842 5,795,013 5,797,299 Expenditures Personal Services 270,334 271,719 279,871 288,267 296,915 305,822 314,997 324,447 334,180 344,205 354,532 365,168 376,123 387,406 399,029 410,999 Supplies 26,058 58,475 59,645 60,837 62,054 63,295 64,561 65,852 67,169 68,513 69,883 71,980 74,139 76,363 78,654 81,014 Other Services & Charges 3,034,503 3,042,607 3,103,459 3,165,528 3,228,839 3,293,416 3,359,284 3,426,470 3,494,999 3,564,899 3,636,197 3,708,921 3,783,099 3,858,761 3,935,937 4,014,655 Insurance 21,115 25,371 25,878 26,396 26,924 27,462 28,012 28,572 29,143 29,726 30,321 31,230 32,167 33,132 34,126 35,150 Utilities 36,689 39,100 39,882 40,680 41,493 42,323 43,170 44,033 44,914 45,812 46,728 48,130 49,574 51,061 52,593 54,171 Depreciation 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 Capital Outlay 3,678,642 3,370,488 2,492,900 1,240,000 2,440,000 2,980,000 461,000 480,000 1,362,000 1,863,000 2,717,000 791,000 220,000 120,000 240,000 590,000 Debt Service (Existing)617,889 743,451 875,364 871,657 876,904 866,395 817,565 630,804 498,910 341,135 336,399 115,719 - - - - Debt Service (Projected)- - 162,036 338,322 338,714 521,985 806,097 806,522 806,959 871,884 872,346 1,142,450 980,901 800,674 800,674 617,805 Total 8,663,091 8,529,073 8,016,895 7,009,548 8,289,704 9,078,560 6,872,546 6,784,560 7,616,135 8,107,036 9,041,266 7,252,458 6,493,864 6,305,259 6,518,873 6,781,655 Cash Balance - Beginning 6,569,127 4,878,097 3,664,944 3,399,126 2,795,275 2,647,750 2,661,225 2,574,243 2,574,463 2,293,110 968,324 997,385 515,516 787,904 1,251,348 1,505,350 Changes in Accruals 52,203 - - - - - - - - - - - - - - - Revenues 5,941,997 6,338,059 6,773,217 5,427,836 7,164,318 8,114,174 5,807,702 5,806,919 6,356,921 5,804,389 8,092,466 5,792,728 5,788,391 5,790,842 5,795,013 5,797,299 Expenditures (8,663,091) (8,529,073) (8,016,895) (7,009,548) (8,289,704) (9,078,560) (6,872,546) (6,784,560) (7,616,135) (8,107,036) (9,041,266) (7,252,458) (6,493,864) (6,305,259) (6,518,873) (6,781,655) Noncash - Depreciation 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 977,861 Cash Balance - Ending 4,878,097$ 3,664,944$ 3,399,126$ 2,795,275$ 2,647,750$ 2,661,225$ 2,574,243$ 2,574,463$ 2,293,110$ 968,324$ 997,385$ 515,516$ 787,904$ 1,251,348$ 1,505,350$ 1,498,855$ 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 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance (ending) City of Brooklyn Center Storm Water Utility Cash Flows Revised: 6-30-21 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%3.00%7.00%7.00%7.00%7.00%7.00%7.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.52$ 15.98$ 17.10$ 18.30$ 19.58$ 20.95$ 22.42$ 23.99$ 24.47$ 24.95$ 25.45$ 25.96$ 25.45$ 25.96$ 26.48$ 25.96$ 26.48$ Per Quarter Change 0.45$ 0.47$ 1.12$ 1.20$ 1.28$ 1.37$ 1.47$ 1.57$ 0.48$ 0.49$ 0.50$ 0.51$ 0.50$ 0.51$ 0.52$ 0.51$ 0.52$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Revenues Operating 1,691,946$ 1,742,704$ 1,864,694$ 1,995,222$ 2,134,888$ 2,284,330$ 2,444,233$ 2,615,329$ 2,667,636$ 2,720,989$ 2,775,408$ 2,830,917$ 2,887,535$ 2,945,286$ 3,004,191$ 3,064,275$ 3,125,561$ Investment Earnings 138,112 49,800 66,304 57,025 20,512 25,582 26,693 15,255 19,734 5,000 14,936 27,726 20,733 13,066 22,174 27,712 32,039 Intergovernmental 24,896 305,000 - - - - - - - - - - - - - - - Nonoperating - - - - - - - - - - - - - - - - - Bond Proceeds - 2,200,000 940,000 - 920,000 1,130,000 - - - 2,740,000 1,320,000 - - - - - - Total 1,854,954 4,297,504 2,870,997 2,052,248 3,075,400 3,439,912 2,470,926 2,630,584 2,687,370 5,465,989 4,110,345 2,858,643 2,908,268 2,958,352 3,026,366 3,091,988 3,157,600 Expenditures Personal Servcies 324,114 349,501 359,986 370,786 381,909 393,366 405,167 417,322 429,842 442,737 456,020 469,700 483,791 498,305 513,254 528,652 544,511 Supplies 13,541 49,100 50,082 51,084 52,105 53,147 54,210 55,295 56,400 57,528 58,679 59,853 61,050 62,271 63,516 64,786 66,082 Other Services & Charges 529,352 419,377 427,765 436,320 445,046 453,947 463,026 472,287 481,732 491,367 501,194 511,218 521,443 531,871 542,509 553,359 564,426 Insurance 2,759 3,427 3,496 3,565 3,637 3,709 3,784 3,859 3,937 4,015 4,096 4,177 4,261 4,346 4,433 4,522 4,612 Utilities 2,800 3,800 3,876 3,954 4,033 4,113 4,196 4,279 4,365 4,452 4,541 4,632 4,725 4,819 4,916 5,014 5,114 Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Capital Outlay 2,378,098 3,359,623 1,831,207 2,444,000 1,075,000 1,532,000 1,132,000 350,000 1,610,000 2,952,000 1,430,000 1,129,000 1,446,000 620,000 865,000 1,080,000 2,560,000 Debt Service (existing) 351,397 443,525 470,150 465,600 460,550 464,825 458,425 467,825 339,325 342,350 - - - - - - - Debt Service (projected) - - 254,627 363,423 363,423 471,275 603,745 603,745 603,745 603,745 924,957 1,079,701 825,074 716,278 716,278 608,426 475,956 Total 5,033,811 6,078,353 4,851,188 5,588,731 4,235,703 4,826,384 4,574,553 3,824,613 4,979,347 6,348,196 4,829,487 4,708,282 4,796,343 3,887,891 4,159,906 4,294,759 5,670,702 Cash Balance - Beginning 5,887,664 4,119,635 3,788,787 3,258,596 1,172,113 1,461,810 1,525,338 871,711 1,127,682 285,706 853,499 1,584,357 1,184,718 746,642 1,267,103 1,583,563 1,830,791 Changes in Accruals (20,922) - - - - - - - - - - - - - - - - Revenues 1,854,954 4,297,504 2,870,997 2,052,248 3,075,400 3,439,912 2,470,926 2,630,584 2,687,370 5,465,989 4,110,345 2,858,643 2,908,268 2,958,352 3,026,366 3,091,988 3,157,600 Expenditures (5,033,811) (6,078,353) (4,851,188) (5,588,731) (4,235,703) (4,826,384) (4,574,553) (3,824,613) (4,979,347) (6,348,196) (4,829,487) (4,708,282) (4,796,343) (3,887,891) (4,159,906) (4,294,759) (5,670,702) Noncash - Depreciation 1,431,750 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 1,450,000 Cash Balance - Ending 4,119,635$ 3,788,787$ 3,258,596$ 1,172,113$ 1,461,810$ 1,525,338$ 871,711$ 1,127,682$ 285,706$ 853,499$ 1,584,357$ 1,184,718$ 746,642$ 1,267,103$ 1,583,563$ 1,830,791$ 767,689$ Notes: See Capital Project Carryover Budget for detail of 2022 budgeted 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 4,500,000 5,000,000 2020 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 Water Sewer Storm Total White Bear Lake 49.16$ 104.19$ 5.00$ 158.35$ Brooklyn Center - 2021 69.82 93.59 15.52 178.93 Brooklyn Center - 2022 76.07 98.27 15.98 190.32 Fridley 70.72 115.60 9.85 196.17 Roseville 96.64 89.36 14.25 200.25 Maplewood 101.17 79.89 27.25 208.31 Shoreview 83.49 99.65 32.30 215.44 Richfield 90.19 108.54 20.35 219.08 Golden Valley 134.90 91.36 25.00 251.26 Crystal 152.94 104.19 20.15 277.28 New Hope 158.85 144.13 25.08 328.06 * White Bear Lake does not operate a storm water utility The above chart illustrates a combined quarterly bill for Water, Sewer and Storm Utilities at a usage of 18,000 gallons. Please note that the City of White Bear Lake does not operate a Storm Utility. CITY OF BROOKLYN CENTER TOTAL WATER, SEWER, AND STORM UTILITY BILL COMPARISON AS OF 6/30/21 BASED ON QUARTERLY BILLING CYCLE, ASSUMING 18,000 GALLONS USAGE COMBINED WATER, SEWER AND STORM RATE COMPARISON  $‐  $50.00  $100.00  $150.00  $200.00  $250.00  $300.00  $350.00 White Bear Lake Brooklyn Center ‐ 2021 Brooklyn Center ‐ 2022 Fridley Roseville Maplewood Shoreview Richfield Golden Valley Crystal New Hope 2020 Residential Quarterly total Water, Sewer, and Storm Utility Bill (18,000 gallons) City of Brooklyn Center Street Light Utility Fund Rate Analysis Revised: 6-30-21 Rate Change 0.00%0.00%0.00%0.00%5.00%5.00%0.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.55$ 6.55$ 6.88$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ 7.22$ Per Quarter Change -$ -$ -$ -$ 0.33$ 0.34$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ Actual Projected Budgeted Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected Projected 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 Revenues Operating 449,286$ 449,286$ 449,286$ 449,286$ 471,750$ 495,338$ 495,338$ 495,338$ 495,338$ 495,338$ 495,338$ 495,338$ 495,338$ 495,338$ 495,338$ 495,338$ Investment Earnings 25,587 8,500 12,538 5,520 3,365 3,403 2,174 640 2,819 4,399 7,292 9,943 11,646 13,257 15,822 18,305 Nonoperating - - - - - - - - - - - - - - - - Total 474,873 457,786 461,824 454,806 475,115 498,741 497,512 495,978 498,157 499,737 502,629 505,281 506,984 508,595 511,160 513,643 Expenditures Supplies 481 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 10,595 Other Services & Charges 52,520 71,610 73,042 74,503 75,993 77,513 79,063 80,644 82,257 83,903 85,581 87,292 89,038 90,819 92,635 94,488 Insurance 1,132 1,808 1,844 1,881 1,919 1,957 1,996 2,036 2,077 2,118 2,161 2,204 2,248 2,293 2,339 2,386 Utilities 182,385 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 263,896 269,174 Depreciation 70,101 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Capital Outlay 54,430 608,871 571,662 281,000 170,000 260,000 270,000 50,000 80,000 - 10,000 60,000 60,000 - - - Transfers Out - - - - - - - - - - - - - - - - Total 361,049 974,319 942,819 657,980 552,920 648,978 665,158 451,461 487,890 414,448 431,137 487,960 494,919 442,017 449,257 456,643 Cash Balance - Beginning 917,936 1,152,977 716,444 315,449 192,275 194,471 124,234 36,588 161,105 251,372 416,661 568,154 665,475 757,540 904,117 1,046,020 Changes in Accruals 51,116 - - - - - - - - - - - - - - - Revenues 474,873 457,786 461,824 454,806 475,115 498,741 497,512 495,978 498,157 499,737 502,629 505,281 506,984 508,595 511,160 513,643 Expenditures (361,049) (974,319) (942,819) (657,980) (552,920) (648,978) (665,158) (451,461) (487,890) (414,448) (431,137) (487,960) (494,919) (442,017) (449,257) (456,643) Noncash - Depreciation 70,101 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 80,000 Cash Balance - Ending 1,152,977$ 716,444$ 315,449$ 192,275$ 194,471$ 124,234$ 36,588$ 161,105$ 251,372$ 416,661$ 568,154$ 665,475$ 757,540$ 904,117$ 1,046,020$ 1,183,020$ 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 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Capital outlay Cash Balance - Ending Minimum Targeted Balance* Capital Improvement Plan 2022 –2036 2022 Capital Project Budgets October 8, 2018 Review City Council/Financial Commission Joint Work Session, July 7, 2021 Mark Ebensteiner, Finance 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 Introduction •Capital Improvement Plan (CIP) •Non-binding document of future intent of City capital projects over the next 15 years •By design, the CIP is fluid because future priorities can change dramatically based on current circumstances •Developed by prioritizing a list of capital projects based on anticipated year needed and based on anticipated funding opportunities •2022 projects will be incorporated in the requested 2022 budget 3 Introduction •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 2022 Capital Improvement Plan 5 2023 Capital Improvement Plan 6 2021 Capital Improvements Fund 7 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) 8 Capital Improvements Fund –Cash Flow Analysis 9 Capital Improvements Fund –Cash Flow Analysis 10 Potential Community Center Expansion Grant 11 •Legislature has historically funded as much as 50% of Community Center Projects for Cities that can justify the need. •May be an opportunity to receive as much as 75% contribution toward a $60 Million Community Center expansion project in 2025. •City would need to fund the other $15 million dollars through bonding with an estimated tax effect between $850,000 and $1.1 Million depending on terms which would equate to 4.0 to 5.5% increase in overall tax levy. MSA Fund –Cash Flow Analysis 12 MSA Fund –Cash Flow Analysis 13 Street Reconstruction Fund –Cash Flow Analysis 14 Street Reconstruction Fund –Cash Flow Analysis 15 Special Assessments Fund –Cash Flow Analysis 16 Special Assessments Fund –Cash Flow Analysis 17 2021 Utility Projects ($12.1 Million) 18 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 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 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 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 27 Comparative Cities’ Utility Rates 28 Street Light Fund – Cash Flow Analysis 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 Anticipated Debt Issues 31 2021 –2023 Summary •$17.05 million in debt issuances over the next two years (Neighborhood Construction Program is driving factor, but also Brooklyn Blvd. Phase II) We currently do not project bonding in 2023. •Financial Impact: Property Tax Levy •2022 –16.51% increase in tax levy for debt service •2023 –11.90% increase in tax levy for debt service •2024 -(7.12%) decrease in tax levy for debt service Quarterly utility bill (typical resident) •2021 -$185.95 •2022 -$197.99 ($12.05 quarterly increase) •2023 -$211.04 ($13.04 quarterly increase) 32 Questions? 33