Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
10.28.2024 UC RM Packet
AGENDA Utility Commission Regular Meeting Monday, October 28, 2024 5:30 PM Conference Room, City Hall 1. CALL TO ORDER 2. ADDITIONS OR CORRECTIONS TO AGENDA 3. AUDIENCE INPUT 4. APPROVAL OF MINUTES a. September 23, 2024, Utility Commission Meeting Minutes 5. PUBLIC HEARINGS 6. OLD BUSINESS 7. NEW BUSINESS a. 2025 Utility Rate Recommendations 8. EXECUTIVE DIRECTOR’S REPORT a. Well Pumping Report b. Action Item / Issues list c. Set Next Meeting Agenda – November 25, 2024 9. ADJOURNMENT Page 1 of 23 ROSEMOUNT UTILITY COMMISSION REGULAR MEETING PROCEEDINGS SEPTEMBER 23, 2024 CALL TO ORDER Pursuant to due call and notice thereof, a regular meeting of the Utility Commission was held on Monday, September 23, 2024, at 7:00 PM in Rosemount Council Chambers, 2875 145th Street West. Chairperson Johnson called the meeting to order with Commissioners Demuth and Miller. Staff present included the following: Administrative Services Director Malecha, Public Works Director Egger, and Recording Secretary Simonson. Mayor Weisensel arrived at 7:09 PM. ADDITIONS OR CORRECTIONS TO AGENDA None. AUDIENCE INPUT None. APPROVAL OF MINUTES 4.a. June 24, 2024, Utility Commission Meeting Minutes Motion by Demuth Second by Miller Motion to approve the June 24, 2024, Utility Commission meeting minutes. Ayes: 3. Nays: None. Motion Carried. PUBLIC HEARINGS None. OLD BUSINESS 6.a. Manganese Monitoring Update Director Egger presented the results of the first round of sampling that took place in August to the commission. Sampling results analyzed by the city equipment consistently produced results with higher levels than the MVTL sample results. This is likely due to MVTL having more sophisticated equipment than the city's testing unit. The results so far appear to show levels are lower the further away from the wells the sample is taken from. Going forward, operations staff will note which wells were running and which wells had the highest output at the time of sampling. Additionally, staff will test samples for hardness. NEW BUSINESS 7.a. Kick-off to Review of 2025 Utility Rate Review Director Egger presented an overview of estimated operational and capital improvement expenses for the near term and future years relating to water, sanitary sewer, storm water and street lighting funds. Director Malecha provided a preliminary review of the proposed utility billing rate adjustments for 2025. She noted that a comparison of 2024 rates for other metro cities in the county placed Page 2 of 23 Rosemount in the middle. It was also emphasized that the streetlight fund needs to be increased to cover ongoing maintenance and repair costs, as it is currently underfunded. Commissioners requested that staff prepare layperson-friendly talking points to assist in discussions with residents. The Commissioners will make a final recommendation to the City Council at the October or November meeting. EXECUTIVE DIRECTOR’S REPORT 8.a. Well Pumping Report The well pumping record shows that water usage is lower this year than last year at this time by at least 150,000,000 gallons. The lower water usage is likely due to the higher precipitation rates we had early in the season, which was also good for groundwater recharge. Operations staff stated that the rotation of wells has more to do with balancing out the demand for chemical additives at each wellhead as well as wear factors on equipment. It was noted that Well 12 was taken offline for a couple of days for maintenance work. 8.b. Action Item / Issues list None. 8.c. Set Next Meeting Agenda – October 28, 2024 Commissioners indicated that a Manganese update is not needed for the October meeting as the second round of sampling results will not be available at the time of the meeting. ADJOURNMENT There being no further business to come before the City Council at the regular council meeting and upon a motion by Demuth and a second by Miller the meeting was adjourned at 8:27 p.m. Respectfully submitted, Amy Simonson Recording Secretary Page 3 of 23 EXECUTIVE SUMMARY Utility Commission Regular Meeting: October 28, 2024 AGENDA ITEM: 2025 Utility Rate Recommendations AGENDA SECTION: NEW BUSINESS PREPARED BY: Nick Egger, Public Works Director AGENDA NO. 7.a. ATTACHMENTS: Utility Rate Comparissons, Impact Analysis Summary, Model Worksheets, CIPs, and Capital Reserves Charts APPROVED BY: NAE RECOMMENDED ACTION: Endorse proposed 2025 Utility Rate Adjustments for City Council Consideration BACKGROUND Staff has completed 2025 operational budget proposals, as well as near and long-term capital improvement planning and large expense forecasting for each of the four utility categories (Water, Sanitary Sewer, Storm Sewer, Street Lighting) based on the best information available along with project planning and development forecasting. In short, for 2025 staff is recommending increases to each rate category as shown below. The primary drivers for these changes are listed for each rate category. • Water Consumption - 5.0% o Energy (electricity & gas - well houses, vehicle fuel), fleet maintenance (attributable to utility operations vehicles), personnel expenses, and construction costs for repairs and replacement work are all rising with changes in the market • Sanitary Wastewater Discharge - 6.0% o There will be about a 5% increase in wastewater processing charges from the Metropolitan Council due to the City's increasing share of overall wastewater flow to the MCES treatment plant system (from $1.81M in 2024 to $1.89M in 2024). This is largest single expense within the sanitary sewer budget. o Energy (electricity - lift stations, vehicle fuel), fleet maintenance (attributable to utility operations vehicles), personnel expenses, and construction costs for repairs and replacement work are all rising with changes in the market. • Storm Sewer Drainage - 5.0% o Energy (electricity - lift stations, vehicle fuel), fleet maintenance (attributable to utility operations vehicles), personnel expenses, and construction costs for repairs and replacement work are all rising with changes in the market • Street Lighting - 5.0% o Electricity costs, and the overall inventory of street lights throughout the City have been increasing with development and intensification of the street network. Page 4 of 23 o The City must also begin setting aside funds for ongoing and future repairs, replacements, and efficiency upgrades to City-owned lighting systems as the inventory ages. o The City may end up being required to take over ownership and operation of several hundred street lights in the downtown area from Xcel Energy, as the current 25-year rate period the City pays to Xcel to operate and maintain these lights, is coming to an end and Xcel will no longer support these functions. This transition will require some level of capital investment from the City to install metering equipment, as well as future ongoing repair and replacement to these lights whenever an issue is encountered (i.e. pole replacements, lighting element replacements, underground wiring repairs). The City has not had an opportunity to get a full picture of what we would face yet for near term and long term expenses and details will emerge over the next year. Attached for the Commission's information are several items, starting with a summary comparing Rosemount's 2024 and proposed 2025 quarterly utility charges for an average residential consumer with eight other nearby communities. Also attached is an impact analysis summary for median rate payers has been attached to provide a sample quarterly bill for Low, Median, and High Residential Properties as well as for a Median Commercial property from 2025-2034 (projected based on set rate change percentages, which are subject to change with future rate analysis/review). The 2025 compound total quarterly bill increases would be 7.1% for the low volume use properties, 6.9% for median-use residential properties, 6.7% for the high use property, and 7.5% for the commercial property example. Lastly, attached are workbook excerpts for the operational funds for each utility, as well as the same for the trunk funds for the water, sanitary sewer, and storm sewer utilities. Each fund worksheet contains major revenue and expense tabulations from recent years as well as projections for the next 10 years based on an assumed rate change for each fund. Many of the figures within each sheet are derived from historical revenue and expense activity (recent past), as well as from the Capital Improvement Plans (CIPs - also attached), and from the prepared 2025 proposed public works department budget. Staff from Finance, Public Works, and Administration will review this information, and have the live spreadsheet available during the upcoming meeting as the Commission discusses proposed utility rate adjustments for 2025, and will be prepared to show alternative calculation options if the Commission requests. RECOMMENDATION Staff is recommending that the Commission adopt a motion to endorse increases to the utility rates as discussed above. Page 5 of 23 City of Rosemount Utility Rate Study 2024 Update City Water Sewer Storm Water Street Lights Total 22,000 gallons 11,000 gallons 1 REU Cottage Grove $36.30 $61.32 $18.84 $17.55 $134.01 Hastings 50.52 70.89 22.41 - 143.82 Lakeville 51.91 70.30 14.79 10.12 147.12 Farmington 58.84 57.63 25.25 7.11 148.83 Rosemount (existing rates) 56.91 66.77 20.24 6.58 150.50 Eagan 64.33 59.25 24.72 8.64 156.94 Burnsville 58.32 71.42 23.37 8.85 161.96 Inver Grove Heights 79.16 79.57 12.42 - 171.15 Apple Valley 65.17 72.98 32.94 7.50 178.59 2024 Quarterly Utility Charges Cottage Grove Hastings Lakeville Farmington Rosemount (existing rates) Eagan Burnsville Inver Grove Heights Apple Valley $- $20.00 $40.00 $60.00 $80.00 $100.00 $120.00 $140.00 $160.00 $180.00 $200.00 Comparable Communities 2024 Quarterly Utility Charges Water Sewer Storm Water Street Lights Page 6 of 23 City of Rosemount Utility Rate Study 2024 Update Existing 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 Residential Property - Low User Water 4 ,000 Gallons $18.37 $19.28 $20.25 $21.25 $22.32 $23.42 $24.60 $25.85 $27.13 $28.49 $29.91 Sewer 6 ,000 Gallons 36.42 39.70 43.27 46.30 49.08 51.53 53.59 55.74 57.97 60.28 62.70 Storm Water 20.24 21.25 22.31 23.43 24.60 25.83 27.12 28.48 29.90 31.40 32.97 Street Light 6.58 7.17 7.82 8.36 8.87 9.31 9.68 10.07 10.47 10.89 11.33 Total Utility Bill $81.61 $87.40 $93.65 $99.35 $104.87 $110.09 $115.00 $120.14 $125.48 $131.06 $136.91 $ Increase $5.79 $6.25 $5.69 $5.52 $5.22 $4.90 $5.14 $5.34 $5.58 $5.85 % Increase 7.1% 7.1% 6.1% 5.6% 5.0% 4.5% 4.5% 4.4% 4.5% 4.5% Residential Property - Median User Water 22 ,000 Gallons $56.91 $59.74 $62.71 $65.81 $69.16 $72.54 $76.18 $80.07 $84.09 $88.27 $92.69 Sewer 11 ,000 Gallons 66.77 72.78 79.33 84.88 89.98 94.47 98.25 102.18 106.27 110.52 114.94 Storm Water 20.24 21.25 22.31 23.43 24.60 25.83 27.12 28.48 29.90 31.40 32.97 Street Light 6.58 7.17 7.82 8.36 8.87 9.31 9.68 10.07 10.47 10.89 11.33 Total Utility Bill $150.50 $160.94 $172.17 $182.49 $192.61 $202.15 $211.24 $220.80 $230.74 $241.08 $251.93 $ Increase $10.44 $11.23 $10.31 $10.12 $9.54 $9.08 $9.56 $9.94 $10.34 $10.85 % Increase 6.9% 7.0% 6.0% 5.5% 5.0% 4.5% 4.5% 4.5% 4.5% 4.5% Residential Property - High User Water 64 ,000 Gallons $300.85 $316.08 $331.61 $348.05 $365.52 $383.82 $403.16 $423.53 $444.97 $467.21 $490.57 Sewer 35 ,000 Gallons 212.45 231.57 252.41 270.08 286.29 300.60 312.62 325.13 338.13 351.66 365.73 Storm Water 20.24 21.25 22.31 23.43 24.60 25.83 27.12 28.48 29.90 31.40 32.97 Street Light 6.58 7.17 7.82 8.36 8.87 9.31 9.68 10.07 10.47 10.89 11.33 Total Utility Bill $540.12 $576.07 $614.15 $649.93 $685.28 $719.56 $752.59 $787.21 $823.48 $861.16 $900.60 $ Increase $35.95 $38.08 $35.77 $35.35 $34.28 $33.02 $34.62 $36.27 $37.68 $39.44 % Increase 6.7% 6.6% 5.8% 5.4% 5.0% 4.6% 4.6% 4.6% 4.6% 4.6% Commercial Property 1.5" Meter Water 68 ,000 Gallons $190.03 $199.63 $209.34 $219.84 $231.14 $242.56 $254.79 $267.84 $281.03 $295.05 $309.80 Sewer 71 ,000 Gallons 430.97 469.76 512.04 547.88 580.75 609.79 634.18 659.55 685.93 713.37 741.90 Storm Water 93.75 98.44 103.36 108.53 113.96 119.66 125.64 131.92 138.52 145.45 152.72 Street Light 12.68 13.82 15.07 16.12 17.09 17.94 18.66 19.41 20.18 20.99 21.83 Total Utility Bill $727.43 $781.65 $839.81 $892.37 $942.94 $989.95 $1,033.27 $1,078.72 $1,125.66 $1,174.86 $1,226.25 $ Increase $54.22 $58.15 $52.56 $50.57 $47.01 $43.32 $45.45 $46.95 $49.20 $51.39 % Increase 7.5% 7.4% 6.3% 5.7% 5.0% 4.4% 4.4% 4.4% 4.4% 4.4% Proposed Quarterly Bills Impact Analysis on Median Rate Payers Page 7 of 23 City of Rosemount Utility Rate Study 2024 Update Previous Study 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% Budget Feb-20 Feb-21 Feb-22 Feb-23 Feb-24 Feb-25 Feb-26 Feb-27 Feb-28 Feb-29 Feb-30 Feb-31 Feb-32 Feb-33 Feb-34 Aug-20 Aug-21 Aug-22 Aug-23 Aug-24 Aug-25 Aug-26 Aug-27 Aug-28 Aug-29 Aug-30 Aug-31 Aug-32 Aug-33 Aug-34 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 1 Rates Inflation 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 2 Investment Income 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 3 Expense growth - operating 3.00%5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 4 Expense growth - personnel 3.00%4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 5 Expense growth - MCES 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 6 5.00% 7 Beginning net assets 42,507,528 44,100,021 46,553,810 51,371,011 55,534,431 56,062,110 57,977,800 60,082,678 62,393,192 64,930,118 67,702,781 70,728,435 74,025,216 77,609,829 81,500,134 8 Operating Revenues 9 Water revenues 2,595,738 3,139,785 3,228,213 3,739,439 1,998,833 4,227,225 4,423,307 4,628,149 4,845,197 5,073,030 5,313,295 5,565,759 5,830,743 6,106,621 6,397,483 10 Sanitary sewer revenues 11 Storm sewer revenues 12 Street light revenues 13 Other income (350)0 111 0 14 Revenue due to growth 119,710 191,270 268,200 357,124 449,382 551,540 663,808 784,660 917,118 1,059,835 15 SAC / WAC charges 16 Total Operating Revenues 2,595,388 3,139,785 3,228,324 3,739,439 1,998,833 4,346,935 4,614,577 4,896,349 5,202,321 5,522,412 5,864,835 6,229,567 6,615,403 7,023,739 7,457,318 17 Operating Expenses 18 Personnel services 514,293 499,657 616,477 578,098 610,010 601,222 625,270 650,281 676,293 703,344 731,478 760,737 791,167 822,813 855,726 19 Other services and charges 360,340 506,201 280,655 428,464 377,409 445,603 467,883 491,277 515,841 541,633 568,715 597,151 627,008 658,359 691,276 20 Supplies 216,901 233,078 255,227 426,409 432,870 443,465 465,639 488,921 513,367 539,035 565,987 594,286 624,000 655,200 687,960 21 Repair and maintenance 140,462 21,051 44,467 40,107 119,312 41,712 43,797 45,987 48,286 50,701 53,236 55,898 58,693 61,627 64,708 22 Utilities 207,694 246,814 248,693 242,482 159,553 252,181 264,790 278,030 291,931 306,528 321,854 337,947 354,844 372,586 391,215 23 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 MCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 Service charges 1,211 1,531 1,534 400,894 0 416,930 437,776 459,665 482,648 506,781 532,120 558,726 586,662 615,995 646,795 27 Depreciation 894,215 886,317 876,072 931,416 0 0 0 0 0 0 0 0 0 0 0 28 Total Operating Expenses 2,335,116 2,394,649 2,323,125 3,047,870 1,699,155 2,201,112 2,305,156 2,414,161 2,528,366 2,648,021 2,773,389 2,904,744 3,042,374 3,186,581 3,337,681 29 Net Operations 260,273 745,136 905,199 691,569 299,678 2,145,822 2,309,422 2,482,189 2,673,955 2,874,390 3,091,446 3,324,823 3,573,029 3,837,159 4,119,636 30 Non operating revenues (expenses) 31 Investment Income (Loss) 269,436 (34,489) (627,271)1,069,794 678,263 678,263 678,263 678,263 678,263 678,263 678,263 678,263 678,263 678,263 678,263 32 Intergovernmental 6,302 3,348 11,489 15,467 5,351 5,618 5,899 6,194 6,504 6,829 7,170 7,529 7,905 8,300 8,715 33 Interest on existing debt 0 0 0 0 0 (491,025) (485,025) (472,725) (459,675) (447,050)(434,925) (422,175) (408,800) (394,800) (380,175) 34 Refunds and reimbursements 0 0 3,805 0 0 0 0 0 0 0 0 0 0 0 0 35 Charges for Services and Rents & Royalties 219,132 231,518 226,255 236,821 288,285 302,700 317,835 333,727 350,413 367,934 386,331 405,648 425,930 447,227 469,588 36 Capital contribution 800,373 1,462,407 4,241,056 3,040,213 0 0 0 0 0 0 0 0 0 0 0 37 Special assessments - Existing 60,146 66,473 76,480 99,248 62,652 80,734 84,770 89,009 93,459 98,132 103,039 108,191 113,601 119,281 125,245 38 Transfers in (378)203,688 (9,110)113,099 2,586 2,716 2,852 2,995 3,145 3,302 3,467 3,640 3,822 4,013 4,214 39 Transfers out (39,338) (202,168) (384) (1,097,724) (809,138)(809,138) (809,138) (809,138) (809,138) (809,138)(809,138) (809,138) (809,138) (809,138) (809,138) 40 Integovermental 41 42 Total non operating revenue (expenses)1,315,674 1,730,777 3,922,319 3,476,918 228,000 (230,132) (204,543) (171,674) (137,028) (101,727) (65,792) (28,041)11,584 53,147 96,713 43 Net increase (decrease) in resources 1,575,946 2,475,913 4,827,518 4,168,488 527,678 1,915,690 2,104,878 2,310,514 2,536,926 2,772,663 3,025,654 3,296,782 3,584,613 3,890,305 4,216,349 44 Change in accounting principle 16,546 (22,123) (10,317) (5,067) 45 Ending net assets 44,100,021 46,553,810 51,371,011 55,534,431 56,062,110 57,977,800 60,082,678 62,393,192 64,930,118 67,702,781 70,728,435 74,025,216 77,609,829 81,500,134 85,716,483 WATER FUND Actual Projected Operating_Cash_Flow Page 8 of 23 City of Rosemount Utility Rate Study 2024 Update Previous Study 6% 4% 4% 3% 3% 2% 2% 2% 2% 2% Budget Feb-20 Feb-21 Feb-22 Feb-23 Feb-24 Feb-25 Feb-26 Feb-27 Feb-28 Feb-29 Feb-30 Feb-31 Feb-32 Feb-33 Feb-34 Aug-20 Aug-21 Aug-22 Aug-23 Aug-24 Aug-25 Aug-26 Aug-27 Aug-28 Aug-29 Aug-30 Aug-31 Aug-32 Aug-33 Aug-34 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 1 Rates Inflation 9.00% 9.00% 7.00% 6.00% 5.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2 Investment Income 5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 3 Expense growth - operating 3.00%5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 4 Expense growth - personnel 3.00%4.00% 4.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 5 Expense growth - MCES 6.00% 6.00% 6.00% 6.00% 6.00%6.00% 6.00% 6.00% 6.00% 6.00% 6 5.00% 7 Beginning net assets 27,332,854 27,688,258 28,439,904 30,274,232 35,226,829 34,532,810 34,120,128 33,957,888 33,995,823 34,203,548 34,539,058 34,960,232 35,470,596 36,073,759 36,773,326 8 Operating Revenues 9 Water revenues 10 Sanitary sewer revenues 2,446,188 2,581,563 2,747,738 2,856,605 2,672,347 3,384,613 3,687,456 3,944,200 4,179,670 4,387,669 4,562,388 4,744,096 4,933,073 5,129,608 5,334,005 11 Storm sewer revenues 12 Street light revenues 13 Other income 14 Revenue due to growth 159,126 263,883 367,225 470,271 569,314 670,694 779,266 895,474 1,019,702 1,152,434 15 SAC / WAC charges 16 Total Operating Revenues 2,446,188 2,581,563 2,747,738 2,856,605 2,672,347 3,543,739 3,951,339 4,311,425 4,649,941 4,956,983 5,233,082 5,523,362 5,828,547 6,149,310 6,486,439 17 Operating Expenses 18 Personnel services 501,692 503,045 617,500 578,011 610,010 601,131 625,176 650,184 676,191 703,239 731,368 760,623 791,048 822,690 855,597 19 Other services and charges 395,961 214,142 172,066 164,698 315,013 171,286 179,850 188,843 198,285 208,199 218,609 229,539 241,016 253,067 265,721 20 Supplies 17,585 10,307 37,467 9,787 41,487 10,179 10,688 11,222 11,783 12,372 12,991 13,640 14,322 15,039 15,790 21 Repair and maintenance 27,736 176,277 53,482 16,870 3,305 17,544 18,422 19,343 20,310 21,325 22,391 23,511 24,687 25,921 27,217 22 Utilities 24,417 17,660 18,249 17,157 14,744 17,843 18,735 19,672 20,656 21,688 22,773 23,912 25,107 26,362 27,681 23 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 MCES 1,386,562 1,311,672 1,546,939 1,653,332 2,034,003 1,894,346 2,008,007 2,128,487 2,256,196 2,391,568 2,535,062 2,687,166 2,848,396 3,019,300 3,200,458 26 Service charges 117 437 440 405,451 0 421,669 442,753 464,891 488,135 512,542 538,169 565,077 593,331 622,998 654,148 27 Depreciation 944,022 960,190 968,473 989,339 0 0 0 0 0 0 0 0 0 0 0 28 Total Operating Expenses 3,298,092 3,193,730 3,414,615 3,834,645 3,018,563 3,133,999 3,303,631 3,482,641 3,671,556 3,870,934 4,081,364 4,303,469 4,537,908 4,785,376 5,046,611 29 Net Operations (851,904) (612,167) (666,877) (978,040) (346,216)409,740 647,708 828,784 978,385 1,086,050 1,151,719 1,219,894 1,290,639 1,363,934 1,439,827 30 Non operating revenues (expenses) 31 Investment Income (Loss) 19,111 589 3,034 309,216 359,522 359,522 359,522 359,522 359,522 359,522 359,522 359,522 359,522 359,522 359,522 32 Intergovernmental 926 593 1,990 40 803 844 886 930 977 1,026 1,077 1,131 1,188 1,247 1,309 33 Interest on existing debt 0 0 0 0 0 (491,025) (485,025) (472,725) (459,675) (447,050)(434,925) (422,175) (408,800) (394,800) (380,175) 34 Refunds and reimbursements 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 Charges for Services and Rents & Royalties 11,753 11,890 27,870 44,616 36,231 38,043 39,945 41,942 44,039 46,241 48,553 50,981 53,530 56,207 59,017 36 Capital contribution 1,111,678 1,396,128 2,390,703 6,718,729 0 0 0 0 0 0 0 0 0 0 0 37 Special assessments - Existing 79,677 78,136 88,282 105,437 76,065 90,619 95,149 99,906 104,901 110,146 115,653 121,436 127,508 133,883 140,577 38 Transfers in 0 (43,488) (4,410)16,247 0 0 0 0 0 0 0 0 0 0 0 39 Transfers out (38,025) (75,561) (1,587) (1,258,718) (820,425) (820,425) (820,425) (820,425) (820,425) (820,425) (820,425) (820,425) (820,425) (820,425) (820,425) 40 Integovermental 41 42 Total non operating revenue (expenses)1,185,120 1,368,287 2,505,882 5,935,567 (347,803) (822,422) (809,948) (790,850) (770,661) (750,540) (730,545) (709,530) (687,477) (664,366) (640,175) 43 Net increase (decrease) in resources 333,217 756,120 1,839,005 4,957,527 (694,019) (412,682) (162,239)37,934 207,725 335,510 421,174 510,364 603,162 699,568 799,653 44 Change in accounting principle 22,188 (4,474) (4,676) (4,931) 45 Ending net assets 27,688,258 28,439,904 30,274,232 35,226,829 34,532,810 34,120,128 33,957,888 33,995,823 34,203,548 34,539,058 34,960,232 35,470,596 36,073,759 36,773,326 37,572,979 SANITARY SEWER FUND Actual Projected Operating_Cash_Flow Page 9 of 23 City of Rosemount Utility Rate Study 2024 Update Previous Study 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% Budget Feb-20 Feb-21 Feb-22 Feb-23 Feb-24 Feb-25 Feb-26 Feb-27 Feb-28 Feb-29 Feb-30 Feb-31 Feb-32 Feb-33 Feb-34 Aug-20 Aug-21 Aug-22 Aug-23 Aug-24 Aug-25 Aug-26 Aug-27 Aug-28 Aug-29 Aug-30 Aug-31 Aug-32 Aug-33 Aug-34 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 1 Rates Inflation 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 2 Investment Income 1.00%5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 3 Expense growth - operating 3.00%5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 4 Expense growth - personnel 3.00%4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 4.00% 5 Expense growth - MCES 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 6 5.00% 7 Beginning net assets 39,084,947 40,215,643 42,272,481 48,309,110 52,707,905 53,704,491 55,008,344 56,385,584 57,838,083 59,370,950 60,990,026 62,700,897 64,509,199 66,420,748 68,442,116 8 Operating Revenues 9 Water revenues 10 Sanitary sewer revenues 11 Storm sewer revenues 1,425,808 1,471,817 1,523,880 1,711,336 1,585,955 1,865,473 1,958,746 2,056,684 2,159,518 2,267,494 2,380,868 2,499,912 2,624,907 2,756,153 2,893,960 12 Street light revenues 13 Other income 0 14 Revenue due to growth 27,917 43,904 60,231 78,469 98,871 120,997 144,974 170,900 199,191 229,949 15 SAC / WAC charges 16 Total Operating Revenues 1,425,808 1,471,817 1,523,880 1,711,336 1,585,955 1,893,390 2,002,650 2,116,915 2,237,987 2,366,365 2,501,865 2,644,886 2,795,807 2,955,344 3,123,909 17 Operating Expenses 18 Personnel services 568,585 553,557 571,873 566,154 546,668 588,800 612,352 636,846 662,320 688,813 716,365 745,020 774,821 805,813 838,046 19 Other services and charges 445,783 426,774 166,377 178,967 160,104 186,126 195,432 205,204 215,464 226,237 237,549 249,427 261,898 274,993 288,742 20 Supplies 21,370 8,807 6,403 7,348 11,623 7,642 8,024 8,425 8,846 9,289 9,753 10,241 10,753 11,290 11,855 21 Repair and maintenance 22,030 110,458 109,278 (98)33,305 (102) (107) (113) (119) (124) (131) (137) (144) (151) (159) 22 Utilities 10,929 4,465 4,833 3,959 3,848 4,117 4,323 4,540 4,767 5,005 5,255 5,518 5,794 6,083 6,388 23 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 MCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 Service charges 117 437 440 91,901 0 95,577 100,356 105,374 110,643 116,175 121,984 128,083 134,487 141,211 148,272 27 Depreciation 771,573 813,384 838,180 918,337 0 0 0 0 0 0 0 0 0 0 0 28 Total Operating Expenses 1,840,388 1,917,882 1,697,385 1,766,568 755,546 882,160 920,380 960,276 1,001,921 1,045,394 1,090,776 1,138,151 1,187,608 1,239,240 1,293,144 29 Net Operations (414,580) (446,064) (173,504) (55,233)830,409 1,011,229 1,082,270 1,156,639 1,236,066 1,320,971 1,411,090 1,506,735 1,608,199 1,716,104 1,830,765 30 Non operating revenues (expenses) 31 Investment Income (Loss) 164,656 14,996 (206,542)375,052 277,061 277,061 277,061 277,061 277,061 277,061 277,061 277,061 277,061 277,061 277,061 32 Intergovernmental 839 574 34,612 39 4,529 4,755 4,993 5,243 5,505 5,780 6,069 6,372 6,691 7,026 7,377 33 Interest on existing debt 0 0 0 0 0 122,775 121,275 118,125 114,825 111,675 108,675 105,550 102,175 98,675 95,050 34 Refunds and reimbursements 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 Charges for Services and Rents & Royalties 14,203 11,890 27,870 44,616 36,231 38,043 39,945 41,942 44,039 46,241 48,553 50,981 53,530 56,207 59,017 36 Capital contribution 1,481,035 2,563,806 6,459,230 3,989,721 0 0 0 0 0 0 0 0 0 0 0 37 Special assessments - Existing 24,830 25,864 35,059 34,069 30,150 31,664 33,247 34,909 36,654 38,487 40,411 42,432 44,554 46,782 49,121 38 Transfers in 81,291 33,263 24,406 51,240 2,370 2,488 2,612 2,743 2,880 3,024 3,175 3,334 3,501 3,676 3,860 39 Transfers out (243,765) (127,073) (159,827) (35,779) (184,163)(184,163) (184,163) (184,163) (184,163) (184,163) (184,163) (184,163) (184,163) (184,163) (184,163) 40 Integovermental 41 42 Total non operating revenue (expenses)1,523,088 2,523,320 6,214,809 4,458,958 166,178 292,623 294,970 295,860 296,801 298,105 299,781 301,567 303,349 305,264 307,323 43 Net increase (decrease) in resources 1,108,508 2,077,255 6,041,305 4,403,726 996,586 1,303,853 1,377,240 1,452,499 1,532,867 1,619,076 1,710,871 1,808,302 1,911,549 2,021,368 2,138,089 44 Change in accounting principle 22,188 (20,417) (4,676) (4,931) 45 Ending net assets 40,215,643 42,272,481 48,309,110 52,707,905 53,704,491 55,008,344 56,385,584 57,838,083 59,370,950 60,990,026 62,700,897 64,509,199 66,420,748 68,442,116 70,580,204 STORM WATER FUND Actual Projected Operating_Cash_Flow Page 10 of 23 City of Rosemount Utility Rate Study 2024 Update Previous Study 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% Budget Feb-20 Feb-21 Feb-22 Feb-23 Feb-24 Feb-25 Feb-26 Feb-27 Feb-28 Feb-29 Feb-30 Feb-31 Feb-32 Feb-33 Feb-34 Aug-20 Aug-21 Aug-22 Aug-23 Aug-24 Aug-25 Aug-26 Aug-27 Aug-28 Aug-29 Aug-30 Aug-31 Aug-32 Aug-33 Aug-34 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 1 Rates Inflation 9.00% 9.00% 7.00% 6.00% 5.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2 Investment Income 1.00%5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 3 Expense growth - operating 3.00%5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 4 Expense growth - personnel 3.00%4.00% 4.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 5 Expense growth - MCES 0.00% 0.00% 0.00% 0.00% 0.00%0.00% 0.00% 0.00% 0.00% 0.00% 6 5.00% 7 Beginning net assets 0 57,069 93,087 121,755 148,473 222,166 324,667 443,574 574,486 715,095 862,542 1,013,445 1,167,827 1,325,708 1,487,101 8 Operating Revenues 9 Water revenues 10 Sanitary sewer revenues 11 Storm sewer revenues 12 Street light revenues 227,546 210,730 216,720 233,370 221,055 286,827 312,641 334,526 354,598 372,328 387,221 402,710 418,818 435,571 452,994 13 Other income 14 Revenue due to growth 0 0 0 0 0 0 0 0 0 0 15 SAC / WAC charges 16 Total Operating Revenues 227,546 210,730 216,720 233,370 221,055 286,827 312,641 334,526 354,598 372,328 387,221 402,710 418,818 435,571 452,994 17 Operating Expenses 18 Personnel services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Other services and charges 7,888 8,631 11,391 16,874 39,764 17,549 18,426 19,348 20,315 21,331 22,397 23,517 24,693 25,928 27,224 20 Supplies 1,602 674 0 126 0 131 137 144 152 159 167 175 184 193 203 21 Repair and maintenance 0 4,714 26,873 1,873 0 1,948 2,046 2,148 2,256 2,368 2,487 2,611 2,742 2,879 3,023 22 Utilities 183,624 192,098 219,738 218,530 166,653 227,271 238,634 250,566 263,094 276,249 290,062 304,565 319,793 335,783 352,572 23 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 MCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 Service charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27 Depreciation 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 28 Total Operating Expenses 193,113 206,116 258,002 237,403 206,416 246,899 259,244 272,206 285,817 300,107 315,113 330,868 347,412 364,782 383,022 29 Net Operations 34,432 4,613 (41,282) (4,033)14,639 39,928 53,397 62,320 68,781 72,220 72,108 71,841 71,406 70,788 69,972 30 Non operating revenues (expenses) 31 Investment Income (Loss) 9 20 1,978 3,674 3,863 3,863 3,863 3,863 3,863 3,863 3,863 3,863 3,863 3,863 3,863 32 Intergovernmental 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33 Interest on existing debt 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34 Refunds and reimbursements 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 Charges for Services and Rents & Royalties 19,008 24,912 60,480 18,000 48,600 51,030 53,582 56,261 59,074 62,028 65,129 68,385 71,804 75,394 79,164 36 Capital contribution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 Special assessments - Existing 3,620 6,473 7,492 9,077 6,591 7,681 8,065 8,468 8,891 9,336 9,803 10,293 10,808 11,348 11,915 38 Transfers in 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 39 Transfers out 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 40 Integovermental 41 42 Total non operating revenue (expenses)22,637 31,404 69,951 30,751 59,054 62,573 65,510 68,592 71,828 75,227 78,795 82,541 86,475 90,605 94,942 43 Net increase (decrease) in resources 57,069 36,018 28,668 26,717 73,693 102,501 118,907 130,912 140,609 147,447 150,903 154,382 157,881 161,393 164,914 44 Change in accounting principle 45 Ending net assets 57,069 93,087 121,755 148,473 222,166 324,667 443,574 574,486 715,095 862,542 1,013,445 1,167,827 1,325,708 1,487,101 1,652,014 Actual Projected STREET LIGHT FUND Operating_Cash_Flow Page 11 of 23 City of Rosemount Utility Rate Study 2024 Update Previous Study 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% Budget 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 1 Rates Inflation 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 2 Investment Income 5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 3 Expense growth - operating 3.00%5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 4 Expense growth - personnel 3.00%4.00% 4.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 5 Expense growth - MCES 0.00% 0.00% 0.00% 0.00% 0.00%0.00% 0.00% 0.00% 0.00% 0.00% 6 5.00% 7 Beginning net assets 3,842,002 4,621,487 5,947,076 7,829,287 10,081,152 13,172,261 14,626,575 16,103,664 17,584,727 19,121,242 20,630,695 22,159,837 23,702,875 25,258,984 26,831,077 8 Operating Revenues 9 Water revenues 10 Sanitary sewer revenues 11 Storm sewer revenues 12 Street light revenues 13 Developer Agreement Charges 895,961 884,537 1,857,888 719,151 1,759,676 300,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 300,000 14 Storm Water Ponding Revenues 15 SAC / WAC charges 727,204 836,111 538,950 1,444,665 858,740 695,772 704,741 693,725 735,945 697,509 705,538 707,491 708,042 710,905 705,897 16 Total Operating Revenues 1,623,165 1,720,648 2,396,838 2,163,816 2,618,416 995,772 1,004,741 993,725 1,035,945 997,509 1,005,538 1,007,491 1,008,042 1,010,905 1,005,897 17 Operating Expenses 18 Personnel services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Other services and charges 1,000 1,000 1,000 1,000 1,000 1,050 1,103 1,158 1,216 1,276 1,340 1,407 1,477 1,551 1,629 20 Supplies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Repair and maintenance 0 0 152 0 0 0 0 0 0 0 0 0 0 0 0 22 Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 23 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 MCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 Service charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27 Depreciation 24,700 24,700 24,682 24,683 0 0 0 0 0 0 0 0 0 0 0 28 Total Operating Expenses 25,700 25,700 25,834 25,683 1,000 1,050 1,103 1,158 1,216 1,276 1,340 1,407 1,477 1,551 1,629 29 Net Operations 1,597,466 1,694,948 2,371,003 2,138,133 2,617,416 994,722 1,003,639 992,567 1,034,729 996,233 1,004,198 1,006,084 1,006,565 1,009,354 1,004,268 30 Non operating revenues (expenses) 31 Investment Income (Loss) 23,849 (12,042) (140,692)321,210 379,290 379,290 379,290 379,290 379,290 379,290 379,290 379,290 379,290 379,290 379,290 32 Intergovernmental 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33 Interest on existing debt 0 0 0 0 0 (62,834) (56,131) (48,600) (43,200) (40,050) (37,025) (34,150) (31,150) (28,025) (24,650) 34 Refunds and reimbursements 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 Charges for Services and Rents & Royalties 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36 Capital contribution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 Special assessments - Existing 9,186 25,442 19,698 1,498 3,063 15,546 16,323 17,139 17,996 18,896 19,841 20,833 21,875 22,969 24,117 38 Transfers in 0 7,313 0 227,746 121,513 127,589 133,968 140,666 147,699 155,084 162,838 170,980 179,529 188,505 197,930 39 Transfers out (851,016) (390,072) (367,798) (436,722) (30,174)0 0 0 0 0 0 0 0 0 0 40 Integovermental 41 42 Total non operating revenue (expenses)(817,981) (369,360) (488,792)113,732 473,694 459,592 473,450 488,495 501,785 513,220 524,944 536,953 549,544 562,739 576,687 43 Net increase (decrease) in resources 779,485 1,325,589 1,882,212 2,251,865 3,091,109 1,454,314 1,477,089 1,481,063 1,536,515 1,509,453 1,529,142 1,543,037 1,556,109 1,572,093 1,580,956 44 Change in accounting principle 45 Ending net assets 4,621,487 5,947,076 7,829,287 10,081,152 13,172,261 14,626,575 16,103,664 17,584,727 19,121,242 20,630,695 22,159,837 23,702,875 25,258,984 26,831,077 28,412,033 WATER TRUNK FUND Actual Projected Trunk_Cash_Flow Page 12 of 23 City of Rosemount Utility Rate Study 2024 Update Previous Study 6% 4% 4% 3% 3% 2% 2% 2% 2% 2% Budget 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 1 Rates Inflation 9.00% 9.00% 7.00% 6.00% 5.00% 4.00% 4.00% 4.00% 4.00% 4.00% 2 Investment Income 5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 3 Expense growth - operating 3.00%5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 4 Expense growth - personnel 3.00%4.00% 4.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 5 Expense growth - MCES 6.00% 6.00% 6.00% 6.00% 6.00%6.00% 6.00% 6.00% 6.00% 6.00% 6 5.00% 7 Beginning net assets 7,473,716 7,803,115 8,351,597 8,036,106 10,288,858 11,280,237 11,553,973 11,828,290 12,104,837 12,384,787 12,668,289 12,955,163 13,245,359 13,418,997 13,692,200 8 Operating Revenues 9 Water revenues 10 Sanitary sewer revenues 11 Storm sewer revenues 12 Street light revenues 13 Developer Agreement Charges 125,763 136,640 214,354 120,168 370,061 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 40,000 14 Storm Water Ponding Revenues 0 0 0 0 0 0 0 0 0 0 0 15 SAC / WAC charges 421,196 487,659 465,104 1,465,787 571,807 240,000 240,000 240,000 240,000 240,000 240,000 240,000 120,000 216,000 211,200 16 Total Operating Revenues 546,959 624,299 679,457 1,585,955 941,868 280,000 280,000 280,000 280,000 280,000 280,000 280,000 160,000 256,000 251,200 17 Operating Expenses 18 Personnel services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Other services and charges 1,000 1,000 1,000 1,000 1,000 1,050 1,103 1,158 1,216 1,276 1,340 1,407 1,477 1,551 1,629 20 Supplies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Repair and maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 23 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 MCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 Service charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27 Depreciation 10,102 10,102 10,096 10,097 0 0 0 0 0 0 0 0 0 0 0 28 Total Operating Expenses 11,102 11,102 11,096 11,097 1,000 1,050 1,103 1,158 1,216 1,276 1,340 1,407 1,477 1,551 1,629 29 Net Operations 535,857 613,197 668,361 1,574,858 940,868 278,950 278,898 278,842 278,784 278,724 278,660 278,593 158,523 254,449 249,571 30 Non operating revenues (expenses) 31 Investment Income (Loss) 142,814 11,790 (281,869)418,128 50,511 50,511 50,511 50,511 50,511 50,511 50,511 50,511 50,511 50,511 50,511 32 Intergovernmental 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33 Interest on existing debt 0 0 0 0 0 (55,925) (55,300) (53,025) (49,575) (45,975)(42,550) (39,175) (35,675) (32,050) (28,175) 34 Refunds and reimbursements 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 Charges for Services and Rents & Royalties 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36 Capital contribution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 Special assessments - Existing 1,661 401 113 85 0 199 209 219 230 242 254 267 280 294 309 38 Transfers in 0 5,756 0 259,681 0 0 0 0 0 0 0 0 0 0 0 39 Transfers out (350,933) (73,771) (702,096)0 0 0 0 0 0 0 0 0 0 0 0 40 Integovermental 41 42 Total non operating revenue (expenses)(206,458) (55,824) (983,852)677,894 50,511 (5,215) (4,580) (2,295)1,166 4,778 8,215 11,603 15,116 18,755 22,645 43 Net increase (decrease) in resources 329,399 557,373 (315,490)2,252,752 991,379 273,735 274,317 276,547 279,950 283,501 286,875 290,196 173,638 273,203 272,216 44 Change in accounting principle (8,892) 45 Ending net assets 7,803,115 8,351,597 8,036,106 10,288,858 11,280,237 11,553,973 11,828,290 12,104,837 12,384,787 12,668,289 12,955,163 13,245,359 13,418,997 13,692,200 13,964,416 SANITARY SEWER TRUNK FUND Actual Projected Trunk_Cash_Flow Page 13 of 23 City of Rosemount Utility Rate Study 2024 Update Previous Study 5% 5% 5% 5% 5% 5% 5% 5% 5% 5% Budget 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 1 Rates Inflation 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 2 Investment Income 1.00%5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 3 Expense growth - operating 3.00%5.00% 5.00% 5.00% 5.00% 5.00%5.00% 5.00% 5.00% 5.00% 5.00% 4 Expense growth - personnel 3.00%4.00% 4.00% 4.00% 4.00% 4.00%4.00% 4.00% 4.00% 4.00% 4.00% 5 Expense growth - MCES 0.00% 0.00% 0.00% 0.00% 0.00%0.00% 0.00% 0.00% 0.00% 0.00% 6 5.00% 7 Beginning net assets 5,844,790 6,766,857 6,949,777 8,488,450 9,787,137 11,870,625 11,147,809 10,443,961 9,633,557 8,788,885 7,934,411 7,037,053 6,099,253 5,118,858 4,095,555 8 Operating Revenues 9 Water revenues 10 Sanitary sewer revenues 11 Storm sewer revenues 12 Street light revenues 13 Developer Agreement Charges 828,776 916,770 1,725,538 697,465 1,865,033 280,000 280,000 280,000 280,000 280,000 280,000 280,000 280,000 280,000 280,000 14 Storm Water Ponding Revenues 36,777 0 0 0 0 0 0 0 0 0 0 15 SAC / WAC charges 199,014 346,411 389,861 533,065 1,327,514 124,740 174,790 100,870 100,870 127,050 121,947 121,173 120,232 121,058 121,442 16 Total Operating Revenues 1,064,566 1,263,181 2,115,399 1,230,530 3,192,547 404,740 454,790 380,870 380,870 407,050 401,947 401,173 400,232 401,058 401,442 17 Operating Expenses 18 Personnel services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 19 Other services and charges 1,000 1,000 1,000 1,000 638,898 670,843 704,385 739,605 776,585 815,414 856,185 898,994 943,944 991,141 1,040,698 20 Supplies 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 21 Repair and maintenance 51,621 0 0 0 0 0 0 0 0 0 0 0 0 0 0 22 Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 23 Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24 Professional Services 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 25 MCES 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 26 Service charges 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27 Depreciation 26,171 26,171 26,154 26,154 0 0 0 0 0 0 0 0 0 0 0 28 Total Operating Expenses 78,792 27,171 27,154 27,154 638,898 670,843 704,385 739,605 776,585 815,414 856,185 898,994 943,944 991,141 1,040,698 29 Net Operations 985,774 1,236,009 2,088,245 1,203,376 2,553,648 (266,103) (249,595) (358,735) (395,715) (408,364)(454,238) (497,821) (543,712) (590,083) (639,256) 30 Non operating revenues (expenses) 31 Investment Income (Loss) 100,063 (3,552) (252,204)395,706 69,366 69,366 69,366 69,366 69,366 69,366 69,366 69,366 69,366 69,366 69,366 32 Intergovernmental 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 33 Interest on existing debt 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34 Refunds and reimbursements 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 35 Charges for Services and Rents & Royalties 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 36 Capital contribution 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 37 Special assessments - Existing 90,022 21,853 28,242 2,466 5,581 17,520 18,396 19,316 20,282 21,296 22,361 23,479 24,653 25,886 27,180 38 Transfers in 0 12,774 0 821,006 30,174 31,682 33,266 34,929 36,675 38,509 40,434 42,456 44,579 46,808 49,148 39 Transfers out (253,791) (1,084,165) (325,611) (1,123,865) (575,281) (575,281) (575,281) (575,281) (575,281) (575,281) (575,281) (575,281) (575,281) (575,281) (575,281) 40 Integovermental 41 42 Total non operating revenue (expenses)(63,706) (1,053,090) (549,572)95,312 (470,160) (456,712) (454,253) (451,670) (448,958) (446,110) (443,120) (439,980) (436,683) (433,221) (429,587) 43 Net increase (decrease) in resources 922,068 182,920 1,538,673 1,298,688 2,083,488 (722,815) (703,848) (810,404) (844,673) (854,474) (897,357) (937,801) (980,394) (1,023,304) (1,068,843) 44 Change in accounting principle 45 Ending net assets 6,766,857 6,949,777 8,488,450 9,787,137 11,870,625 11,147,809 10,443,961 9,633,557 8,788,885 7,934,411 7,037,053 6,099,253 5,118,858 4,095,555 3,026,712 STORM WATER TRUNK FUND Actual Projected Trunk_Cash_Flow Page 14 of 23 City of Rosemount Utility Rate Study 2024 Update Inflation Rate 3% Year Inflation Begins 2024 Project Multiple Costs Inflate Capital Project Number Year? First Year Last Year 2024 Y/N 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Well 16 Yes 2018 2027 250,000 N 250,000 250,000 250,000 250,000 - - - - - - - - - Lease Program Yes 2018 2031 37,250 Y 37,250 38,368 39,519 40,704 41,925 43,183 44,478 45,813 - - - - - CSAH 42 & Blaine Ave Trunk WM & PRV Relocation No 2024 2,311,000 N 2,311,000 - - - - - - - - - - - - Aspen Avenue Extenstion No 2024 175,000 N 175,000 - - - - - - - - - - - - PMP - O'Leary's Hills A/B No 2024 96,000 N 96,000 - - - - - - - - - - - - Well 17 Yes 2025 2034 275,000 N - 275,000 275,000 275,000 275,000 275,000 275,000 275,000 275,000 275,000 275,000 - - Highway 3 Roundabout Watermain Relocation No 2025 175,000 N - 175,000 - - - - - - - - - - - PMP - Motz, Rosemount Hills A/B (2025 SIP) No 2025 335,000 N - 335,000 - - - - - - - - - - - PMP - Biscayne Pt A/Shannon Pond E/Geronime Pond No 2026 60,000 N - - 60,000 - - - - - - - - - - PMP - Bloomfield A/B No 2027 60,000 N - - - 60,000 - - - - - - - - - Water Treatment Plant Yes 2028 2043 3,320,000 N - - - - 3,320,000 3,320,000 3,320,000 3,320,000 3,320,000 3,320,000 3,320,000 3,320,000 3,320,000 CSAH 42 & Blaine Water Tower 2MG Storage Yes 2028 2042 480,000 N - - - - 480,000 480,000 480,000 480,000 480,000 480,000 480,000 480,000 480,000 PMP - Carrollton A, Evermoor A/C, Connemara Crossings, Bloomfield C No 2028 65,000 N - - - - 65,000 - - - - - - - - PMP - Rsmt Business Park, Rahns A/B, Bloomfield D, Marian Terrace No 2029 65,000 N - - - - - 65,000 - - - - - - - Generator (replace #8057) No 2030 50,000 N - - - - - - 50,000 - - - - - - Generator (replace #8059) No 2030 50,000 N - - - - - - 50,000 - - - - - - - - - - - - - - - - - - - PD/PW Campus No 2024 11,132,000 11,132,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Capital Projects 14,001,250 1,073,368 624,519 625,704 4,181,925 4,183,183 4,219,478 4,120,813 4,075,000 4,075,000 4,075,000 3,800,000 3,800,000 Bonding Amount - Trunk - - - - - - - - - - - - - Bonding Amount - Operating - - - - - - - - - - - - - Trunk 2,561,000 525,000 525,000 525,000 1,585,000 1,585,000 1,585,000 1,585,000 1,585,000 1,585,000 1,585,000 1,310,000 1,310,000 Operating 11,440,250 548,368 99,519 100,704 2,596,925 2,598,183 2,634,478 2,535,813 2,490,000 2,490,000 2,490,000 2,490,000 2,490,000 Project WATER FUND CIP Page 15 of 23 City of Rosemount Utility Rate Study 2024 Update Inflation Rate 3% Year Inflation Begins 2024 Project Multiple Costs Inflate Capital Project Number Year? First Year Last Year 2024 Y/N 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Lease Program Yes 2018 2031 37,250 Y 37,250 38,368 39,519 40,704 41,925 43,183 44,478 45,813 - - - - - Site Lighting Installations - Lift Stations No 2023 45,000 N - - - - - - - - - - - - - PMP - O'Leary's Hills A/B (2024 SIP) No 2024 42,000 N 42,000 - - - - - - - - - - - - Aspen Avenue Extension No 2024 135,000 N 135,000 - - - - - - - - - - - - Large Diameter Sanitary Sewer Cleaning No 2025 80,000 N - 80,000 - - - - - - - - - - - PMP - Motz, Rosemount Hills A/B (2025 SIP) No 2025 430,000 N - 430,000 - - - - - - - - - - - Boulder Trail Lift Station (in conjunction with Rosemount Middle School) Yes 2025 2034 200,000 N - 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 - - Jetter (Replace #8445) No 2026 132,500 N - - 132,500 - - - - - - - - - - PMP - Biscayne Pt A/Shannon Pond E/Geronime Pond No 2026 65,000 N - - 65,000 - - - - - - - - - - PMP - Bloomfield A/B No 2027 65,000 N - - - 65,000 - - - - - - - - - Blaine Ave Upgrades - Sanitary Sewer No 2027 1,250,000 N - - - 1,250,000 - - - - - - - - - Sewer Lining Program Yes 2027 2028 225,000 N - - - 225,000 225,000 - - - - - - - - PMP - Carrollton A, Evermoor A/C, Connemara Crossings, Bloomfield C No 2028 175,000 N - - - - 175,000 - - - - - - - - PMP - Rsmt Business Park, Rahns A/B, Bloomfield D, Marian Terrace No 2029 200,000 N - - - - - 200,000 - - - - - - - Generator (replace #8057) No 2030 50,000 N - - - - - - 50,000 - - - - - - Generator (replace #8059) No 2030 50,000 N - - - - - - 50,000 - - - - - - - - 500,000 - - - - - - - - - - PD/PW Campus No 2024 11,120,000 11,120,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Capital Projects 11,297,000 710,000 897,500 1,740,000 600,000 400,000 300,000 200,000 200,000 200,000 200,000 - - Bonded projects - Trunk - - - Bonded projects - Operating - - - Trunk - 200,000 200,000 1,450,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 - - Operating 11,297,000 510,000 197,500 290,000 400,000 200,000 100,000 - - - - - - Project SANITARY SEWER FUND CIP Page 16 of 23 City of Rosemount Utility Rate Study 2024 Update Inflation Rate 3% Year Inflation Begins 2024 Project Multiple Costs Inflate Capital Project Number Year? First Year Last Year 2024 Y/N 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 Lease Program Yes 2018 2031 24,850 Y 24,850 25,596 26,363 27,154 27,969 28,808 29,672 30,562 - - - - - Culvert Replacement & Neighborhood Drainage Mod - 124th Street No 2023 75,000 N - - - - - - - - - - - - - Stormwater Improvement Program Yes 2023 2031 200,000 N 200,000 200,000 200,000 200,000 200,000 200,000 200,000 200,000 - - - - - Jay Simon Addition - Stormwater Upgrades No 2023 515,000 N - - - - - - - - - - - - - Evermoor Parkway to Danube Trail Culvert No 2024 5,000 N 5,000 - - - - - - - - - - - - PMP - O'Leary's Hills A/B (2024 SIP) No 2024 103,000 N 103,000 - - - - - - - - - - - - Aspen Avenue Extension No 2024 57,000 N 57,000 - - - - - - - - - - - - PMP - Motz, Rosemount Hills A/B (2025 SIP) No 2025 130,000 N - 130,000 - - - - - - - - - - - PMP - Biscayne Pt A/Shannon Pond E/Geronime Pond No 2026 175,000 N - - 175,000 - - - - - - - - - - Jetter (Replace #8445) No 2026 132,500 N - - 132,500 - - - - - - - - - - PMP - Oak Ridge No 2026 50,000 N - - 50,000 - - - - - - - - - - PMP - Bloomfield A/B No 2027 75,000 N - - - 75,000 - - - - - - - - - Dump Single (replace #8437) No 2027 110,000 N - - - 110,000 - - - - - - - - - Blaine Ave Upgrades No 2027 500,000 N - - - 500,000 - - - - - - - - - Bobcat (replace #8420) No 2028 35,000 N - - - - 35,000 - - - - - - - - PMP - Carrollton A, Evermoor A/C, Connemara Crossings, Bloomfield C No 2028 65,000 N - - - - 65,000 - - - - - - - - PMP - Rsmt Business Park, Rahns A/B, Bloomfield D, Marian Terrace No 2029 65,000 N - - - - - 65,000 - - - - - - - Generator (replace #8057) No 2030 50,000 N - - - - - - 50,000 - - - - - - Generator (replace #8059) No 2030 50,000 N - - - - - - 50,000 - - - - - - Pipe to the River (placeholder) - - - - - - - - - - - - - - - - - - - - - - - - - - PD/PW Campus No 2024 2,690,000 2,690,000 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Capital Projects 3,055,000 330,000 557,500 885,000 300,000 265,000 300,000 200,000 - - - - - Bonded projects - Trunk - - - - - - - - - - - - Bonded projects - Operating - - - - - - - - - - - - - Trunk 5,000 - - 500,000 - - - - - - - - - Operating 3,050,000 330,000 557,500 385,000 300,000 265,000 300,000 200,000 - - - - - Project STORM WATER FUND CIP Page 17 of 23 City of Rosemount Utility Rate Study 2024 Update Inflation Rate 3% Year Inflation Begins 2024 Project Multiple Costs Inflate Capital Project Number Year? First Year Last Year 2024 Y/N 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Total Capital Projects - - - - - - - - - - - - - Bonded projects - - - - - - - - - - - Project STREET LIGHTS FUND CIP Page 18 of 23 City of Rosemount Utility Rate Study 2024 Update 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 Water Fund Capital Cash Reserves Targeted Working Capital Actual Working Capital Page 19 of 23 City of Rosemount Utility Rate Study 2024 Update 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 0 2,000,000 4,000,000 6,000,000 8,000,000 10,000,000 12,000,000 14,000,000 16,000,000 Sewer Fund Capital Cash Reserves Targeted Working Capital Actual Working Capital Page 20 of 23 City of Rosemount Utility Rate Study 2024 Update 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 0 5,000,000 10,000,000 15,000,000 20,000,000 25,000,000 30,000,000 Storm Water Fund Capital Cash Reserves Targeted Working Capital Actual Working Capital Page 21 of 23 City of Rosemount Utility Rate Study 2024 Update 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 0 200,000 400,000 600,000 800,000 1,000,000 1,200,000 1,400,000 1,600,000 1,800,000 Street Light Fund Capital Cash Reserves Targeted Working Capital Actual Working Capital Page 22 of 23 GPM 1,200 1,235 1,600 1,500 1,500 1,500 2,000 500 500 2023 Well 7 Well 8 Well 9 Well 12 Well 14 Well 15 Well 16 Rural 1 Rural 2 2024 Total 2023 Total % Change 2023 2024 Diff Jan 0 0 0 17,166,000 1,052,000 25,843,000 0 2,620,000 2,461,000 49,142,000 44,173,000 11.2% 2.25 0.13 -2.12 Feb 0 15,000 16,606,000 73,000 0 114,000 18,910,000 2,472,000 2,387,000 40,577,000 42,162,000 -3.8% 2.38 0.65 -1.73 Mar 0 0 1,953,000 15,206,000 23,484,000 0 2,231,000 2,518,000 2,449,000 47,841,000 47,112,000 1.5% 2.72 2.51 -0.21 Q1 Total 0 15,000 18,559,000 32,445,000 24,536,000 25,957,000 21,141,000 7,610,000 7,297,000 137,560,000 133,447,000 3.1%7.35 3.29 -4.06 Apr 3,000 21,814,000 792,000 78,000 112,000 27,480,000 216,000 2,580,000 2,916,000 55,991,000 46,373,000 20.7% 2.39 4.19 1.80 May 0 35,153,000 1,848,000 8,863,000 42,627,000 2,570,000 3,889,000 1,652,000 4,668,000 101,270,000 110,781,000 -8.6% 1.62 5.81 4.19 Jun 0 3,372,000 29,922,000 4,838,000 1,883,000 10,411,000 34,736,000 2,607,000 2,738,000 90,507,000 162,212,500 -44.2% 0.93 7.27 6.34 Q2 Total 3,000 60,339,000 32,562,000 13,779,000 44,622,000 40,461,000 38,841,000 6,839,000 10,322,000 247,768,000 359,517,000 -31.1%4.94 17.27 12.33 Jul 504,000 38,591,000 8,475,000 13,024,000 12,672,000 41,238,000 20,103,000 4,945,000 5,032,000 144,584,000 168,701,000 -14.3% 2.57 5.61 3.04 Aug 727,000 6,338,000 37,460,000 9,199,000 49,513,000 5,665,000 9,392,000 4,584,000 4,987,000 127,865,000 182,711,000 -30.0% 2.29 5.37 3.08 Sep 1,607,000 39,092,000 11,575,000 13,785,000 12,139,000 31,348,000 37,108,000 2,935,000 3,443,000 153,032,000 151,939,000 0.7% 5.72 0.06 -5.66 Q3 Total 2,838,000 84,021,000 57,510,000 36,008,000 74,324,000 78,251,000 66,603,000 12,464,000 13,462,000 425,481,000 503,351,000 -15.5%10.58 11.04 0.46 Oct 0 87,864,000 -100.0% 4.50 -4.50 Nov 0 46,602,000 -100.0% 0.04 -0.04 Dec 0 50,371,000 -100.0% 2.28 -2.28 Q4 Total 0 0 00 00000 0153,856,000 -100.0%6.82 0.00 -6.82 Total 2,841,000 144,375,000 108,631,000 82,232,000 143,482,000 144,669,000 126,585,000 26,913,000 31,081,000 810,809,000 1,150,171,000 -29.5%29.69 31.60 1.91 Average/Mo 315,667 16,041,667 12,070,111 9,136,889 15,942,444 16,074,333 14,065,000 2,990,333 3,579,000 90,215,444 101,790,826 -11.4% Average/Day 7,784 395,548 297,619 225,293 393,101 396,353 346,808 73,734 85,153 2,221,395 3,335,118 -33.4% 810,809,000 956,164,500 -15.2% 29.69 31.60 1.91 2024 Well Pumping Record Precipitation Year To-Date Page 23 of 23