Attachment 2 - City of Mesa Utility Fund Cash Flow Projections

Attachment 2 - City of Mesa Utility Fund Cash Flow Projections
+$5M Cash
+$10M Cash
+$10M Cash
As of 8/13/2026
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
WATER
$5,460,861
($2,808,934)
$4,953,991
$11,889,343
$10,952,159
$9,474,267
$10,787,493
WASTEWATER
($3,781,233)
($5,668,273)
($4,067,116)
$587,564
$4,816,543
$7,593,925
$7,282,910
SOLID WASTE
$655,139
$210,001
$2,357,854
$5,372,359
$5,258,107
$9,893,037
$10,705,768
ELECTRIC
$4,060,522
($613,600)
($968,075)
($854,339)
($1,269,674)
($1,369,446)
($1,285,440)
NATURAL GAS
($5,312,726)
($2,995,696)
($3,287,572)
$448,895
$361,173
$1,141,125
$1,840,407
DISTRICT COOLING
($345,087)
($160,312)
($142,690)
($137,173)
($168,212)
($201,698)
($147,034)
TOTAL NET SOURCES AND USES
$737,476
($12,036,813)
($1,153,607)
$17,306,648
$19,950,097
$26,531,209
$29,184,104
Beginning Reserve Balance
$119,419,884
$120,157,360
$108,120,547
$106,966,940
$124,273,588
$144,223,685
$170,754,894
Ending Reserve Balance
$120,157,360
$108,120,547
$106,966,940
$124,273,588
$144,223,685
$170,754,894
$199,938,999
Ending Reserve Balance Percent*
20.6%
17.5%
16.5%
18.0%
19.9%
22.2%
24.6%
*As a % of Next Fiscal Year's Expenditures
WATER Residential (Tier 1 usage)
2.50%
3.50%
3.50%
3.50%
3.50%
3.50%
3.50%
WATER Commercial (usage)
20.00%
13.00%
13.00%
5.00%
5.00%
5.00%
5.00%
WASTEWATER Residential
7.50%
7.50%
7.50%
7.50%
7.00%
7.00%
7.00%
WASTEWATER Non-Residential
8.50%
8.50%
8.50%
8.50%
8.00%
8.00%
8.00%
SOLID WASTE Residential
5.50%
5.50%
5.50%
5.50%
5.00%
5.00%
5.00%
SOLID WASTE Commercial
5.50%
6.00%
5.50%
5.50%
5.50%
5.50%
5.50%
SOLID WASTE Rolloff
5.50%
6.00%
5.50%
5.50%
5.50%
5.50%
5.50%
ELECTRIC Residential - svc charge
$1.00
$2.00
$3.00
$3.00
$3.00
$3.00
$3.00
ELECTRIC Non-Residential - svc charge
$5.00
$5.00
$5.00
$5.00
$5.00
$5.00
$5.00
GAS Residential - svc charge
$0.00
$1.50
$1.00
$1.00
$1.00
$1.00
$1.00
GAS Non-Residential - svc charge
$3.00
$3.00
$3.00
$3.00
$3.00
$3.00
$3.00
Page 1 of 5

Attachment 2 - City of Mesa Utility Fund Cash Flow Projections
+$5M Cash
+$10M Cash
+$10M Cash
TOTAL
As of 8/13/2026
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
Sources of Funding
       Revenues
$495,300,800
$530,911,071
$574,791,981
$620,736,917
$660,809,981
$702,124,119
$745,298,145
       EECAF/PNGCAF Revenues
$38,852,952
$38,988,637
$43,065,925
$44,795,442
$48,910,359
$50,811,494
$51,791,198
Total Sources
$534,153,752
$569,899,708
$617,857,906
$665,532,359
$709,720,340
$752,935,613
$797,089,343
Uses of Funding
       Operating Expenditures
$204,927,035
$230,066,261
$237,735,526
$244,794,634
$250,025,682
$256,305,039
$265,101,713
       EECAF/PNGCAF Expenditures
$33,957,225
$38,988,637
$43,065,925
$44,795,442
$48,910,359
$50,811,494
$51,791,198
    Expenditure Subtotal
$238,884,260
$269,054,898
$280,801,451
$289,590,076
$298,936,041
$307,116,533
$316,892,911
       Project Costs
$805,166
$2,294,509
$409,360
$313,744
$331,302
$448,208
$346,785
       General Fund Transfer
$147,042,095
$158,024,143
$170,580,918
$184,030,997
$195,925,732
$208,287,738
$221,204,602
       Debt Service Transfer
$131,756,953
$139,134,266
$151,516,765
$159,515,066
$170,717,711
$182,373,802
$198,072,958
       Lifecycle/ Infrastructure Transfers
$10,655,881
$11,370,343
$12,328,868
$13,281,757
$14,164,904
$15,028,563
$15,910,969
       Capital Transfer
$3,707,157
$1,352,409
$2,527,005
$505,733
$8,706,217
$12,161,223
$14,488,677
       Other Transfers
$564,764
$705,954
$847,146
$988,337
$988,337
$988,337
$988,337
Total Uses
$533,416,276
$581,936,522
$619,011,513
$648,225,711
$689,770,243
$726,404,404
$767,905,238
Net Sources and Uses
$737,476
($12,036,813)
($1,153,607)
$17,306,648
$19,950,097
$26,531,209
$29,184,104
Beginning Reserve Balance
$119,419,884
$120,157,360
$108,120,547
$106,966,940
$124,273,588
$144,223,685
$170,754,894
Ending Reserve Balance
$120,157,360
$108,120,547
$106,966,940
$124,273,588
$144,223,685
$170,754,894
$199,938,999
Ending Reserve Balance Percent*
20.6%
17.5%
16.5%
18.0%
19.9%
22.2%
24.6%
*As a % of Next Fiscal Year's Expenditures
Page 2 of 5

Attachment 2 - City of Mesa Utility Fund Cash Flow Projections
+$5M Cash
+$10M Cash
+$10M Cash
WATER
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
Sources of Funding
     Residential Rate Revenues
$110,413,201
$115,273,185
$121,187,945
$127,531,256
$133,137,526
$138,732,571
$144,524,178
     Non-Residential Rate Revenues
$97,378,682
$113,520,574
$129,450,727
$145,008,215
$155,871,823
$167,397,517
$179,326,061
   Other Revenues
$13,428,043
$8,567,008
$8,530,943
$8,700,565
$8,873,471
$9,058,013
$9,250,165
Total Sources
$221,219,926
$237,360,767
$259,169,615
$281,240,035
$297,882,820
$315,188,102
$333,100,404
Uses of Funding
   Operating Expenditures
$77,957,329
$91,542,055
$94,503,384
$98,382,378
$101,042,417
$104,056,772
$107,467,035
     Project Costs
$30,331
$205,742
$0
$0
$0
$0
$0
     General Fund Transfer
$65,787,026
$70,551,551
$76,792,242
$83,378,371
$88,309,233
$93,492,259
$98,857,222
     Debt Service Transfer
$67,167,958
$72,245,964
$76,494,892
$81,369,352
$86,116,105
$90,748,475
$97,728,145
     Lifecycle/ Infrastructure Transfers
$4,424,399
$4,747,215
$5,183,392
$5,624,801
$5,957,656
$6,303,762
$6,662,008
     Capital Transfer
$178,904
$610,774
$922,037
$222,835
$5,132,293
$10,739,611
$11,225,544
Other Transfers
$213,118
$266,398
$319,677
$372,957
$372,957
$372,957
$372,957
Total Uses
$215,759,065
$240,169,700
$254,215,624
$269,350,693
$286,930,661
$305,713,835
$322,312,911
Net Sources and Uses
$5,460,861
($2,808,934)
$4,953,991
$11,889,343
$10,952,159
$9,474,267
$10,787,493
WASTEWATER
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
Sources of Funding
     Residential Rate Revenues
$64,913,314
$66,806,673
$72,565,599
$78,995,568
$85,382,454
$91,843,060
$98,735,422
     Non-Residential Rate Revenues
$51,760,012
$56,307,810
$61,556,730
$67,465,994
$73,725,288
$80,184,456
$87,120,519
  Other Revenues
$4,567,765
$3,608,746
$4,658,043
$5,249,977
$5,358,044
$5,473,432
$5,593,503
Total Sources
$121,241,091
$126,723,228
$138,780,373
$151,711,540
$164,465,785
$177,500,948
$191,449,444
Uses of Funding
   Operating Expenditures
$42,664,976
$47,309,255
$49,338,834
$51,066,425
$52,590,720
$53,851,493
$56,716,870
     Project Costs
$20,318
$176,978
$0
$0
$0
$0
$0
     General Fund Transfer
$35,879,651
$37,424,468
$40,736,078
$44,446,733
$48,249,645
$52,135,231
$56,293,799
     Debt Service Transfer
$42,965,118
$44,303,670
$49,062,131
$52,340,983
$55,348,294
$60,187,778
$67,138,163
     Lifecycle/ Infrastructure Transfers
$2,424,822
$2,534,465
$2,775,607
$3,034,231
$3,289,316
$3,550,019
$3,828,989
     Capital Transfer
$1,015,335
$577,535
$856,681
$144,422
$80,083
$91,319
$97,530
Other Transfers
$52,104
$65,130
$78,157
$91,183
$91,183
$91,183
$91,183
Total Uses
$125,022,324
$132,391,501
$142,847,488
$151,123,976
$159,649,241
$169,907,023
$184,166,534
Net Sources and Uses
($3,781,233)
($5,668,273)
($4,067,116)
$587,564
$4,816,543
$7,593,925
$7,282,910
Page 3 of 5

Attachment 2 - City of Mesa Utility Fund Cash Flow Projections
+$5M Cash
+$10M Cash
+$10M Cash
SOLID WASTE
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
Sources of Funding
Revenues
$81,572,363
$87,289,950
$92,329,613
$98,002,184
$103,608,315
$109,443,784
$115,523,947
Uses of Funding
     Operating Expenditures
$51,802,017
$57,376,154
$59,180,760
$60,116,782
$60,680,949
$61,846,300
$63,415,193
     Project Costs
$325,001
$1,082,816
$409,360
$313,744
$331,302
$448,208
$346,785
     General Fund Transfer
$24,471,709
$26,186,985
$27,698,884
$29,400,655
$31,082,494
$32,833,135
$34,657,184
     Debt Service Transfer
$636,276
$486,147
$545,655
$525,777
$514,181
$729,130
$747,981
     Lifecycle/ Infrastructure Transfers
$1,631,447
$1,745,799
$1,846,592
$1,960,044
$2,072,166
$2,188,876
$2,310,479
     Capital Transfer
$1,949,879
$75,929
$139,165
$136,256
$3,492,548
$1,328,531
$3,163,991
Other Transfers
$100,895
$126,119
$151,343
$176,567
$176,567
$176,567
$176,567
Total Uses
$80,917,224
$87,079,950
$89,971,759
$92,629,825
$98,350,208
$99,550,747
$104,818,180
Net Sources and Uses
$655,139
$210,001
$2,357,854
$5,372,359
$5,258,107
$9,893,037
$10,705,768
ELECTRIC
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
Sources of Funding
     Revenues
$23,809,004
$22,630,903
$23,871,174
$25,374,983
$26,726,919
$28,053,322
$29,398,678
     EECAF Revenues
$26,875,553
$23,107,536
$24,066,144
$25,136,527
$25,651,647
$26,274,790
$27,148,903
Total Sources
$50,684,557
$45,738,439
$47,937,318
$50,511,510
$52,378,566
$54,328,112
$56,547,581
-$1,966,788
-$1,312,882
$50,511,510
$52,378,423
Uses of Funding
     Operating Expenditures
$9,983,288
$10,113,970
$10,474,304
$10,591,967
$10,781,763
$11,039,537
$11,335,760
     EECAF Expenditures
$23,657,244
$23,107,536
$24,066,144
$25,136,527
$25,651,647
$26,274,790
$27,148,903
   Expenditure Subtotal
$33,640,532
$33,221,506
$34,540,448
$35,728,494
$36,433,410
$37,314,327
$38,484,663
     Project Costs
$316,848
$436,567
$0
$0
$0
$0
$0
     General Fund Transfer
$6,666,185
$6,789,271
$7,161,352
$7,541,480
$7,929,993
$8,327,279
$8,729,138
     Debt Service Transfer
$4,904,574
$4,845,151
$5,831,817
$6,941,785
$8,093,407
$8,825,532
$9,344,410
     Lifecycle/ Infrastructure Transfers
$1,013,691
$914,769
$958,746
$1,010,230
$1,047,571
$1,086,562
$1,130,952
     Capital Transfer
$0
$42,019
$289,722
$0
$0
$0
$0
     Other Transfers
$82,205
$102,756
$123,308
$143,859
$143,859
$143,859
$143,859
Total Uses
$46,624,035
$46,352,039
$48,905,393
$51,365,848
$53,648,240
$55,697,558
$57,833,021
Net Sources and Uses
$4,060,522
($613,600)
($968,075)
($854,339)
($1,269,674)
($1,369,446)
($1,285,440)
Page 4 of 5

Attachment 2 - City of Mesa Utility Fund Cash Flow Projections
+$5M Cash
+$10M Cash
+$10M Cash
NATURAL GAS
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
Sources of Funding
     Revenues
$46,098,697
$55,523,680
$59,226,704
$62,963,687
$66,651,027
$70,430,524
$74,284,770
     PNGCAF Revenues
$11,977,399
$15,881,101
$18,999,781
$19,658,915
$23,258,712
$24,536,704
$24,642,295
Total Sources
$58,076,096
$71,404,781
$78,226,485
$82,622,602
$89,909,739
$94,967,228
$98,927,065
Uses of Funding
   Operating Expenditures
$21,333,694
$22,597,830
$23,107,856
$23,491,737
$23,731,082
$24,256,542
$24,943,552
   PNGCAF Expenditures
$10,299,981
$15,881,101
$18,999,781
$19,658,915
$23,258,712
$24,536,704
$24,642,295
  Expenditure Subtotal
$31,633,675
$38,478,931
$42,107,637
$43,150,652
$46,989,794
$48,793,246
$49,585,847
     Project Costs
$112,595
$392,406
$0
$0
$0
$0
$0
     General Fund Transfer
$13,829,609
$16,657,104
$17,768,011
$18,830,412
$19,911,831
$21,047,603
$22,204,988
     Debt Service Transfer
$16,083,028
$17,253,333
$19,582,270
$18,337,169
$20,645,723
$21,882,887
$23,114,259
     Lifecycle/ Infrastructure Transfers
$1,161,522
$1,428,096
$1,564,530
$1,652,452
$1,798,195
$1,899,345
$1,978,541
     Capital Transfer
$452,380
$45,591
$317,588
$0
$0
$0
$0
Other Transfers
$116,013
$145,016
$174,020
$203,023
$203,023
$203,023
$203,023
Total Uses
$63,388,822
$74,400,477
$81,514,057
$82,173,708
$89,548,566
$93,826,103
$97,086,658
Net Sources and Uses
($5,312,726)
($2,995,696)
($3,287,572)
$448,895
$361,173
$1,141,125
$1,840,407
DISTRICT COOLING
FY 25/26
FY 26/27
FY 27/28
FY 28/29
FY 29/30
FY 30/31
FY 31/32
Estimate
Projected
Forecast
Forecast
Forecast
Forecast
Forecast
Sources of Funding
Revenues
$1,359,719
$1,382,543
$1,414,502
$1,444,488
$1,475,116
$1,507,440
$1,540,902
Uses of Funding
     Operating Expenditures
$1,185,731
$1,126,996
$1,130,388
$1,145,345
$1,198,751
$1,254,396
$1,223,304
  General Fund Transfer
$407,916
$414,763
$424,351
$433,346
$442,535
$452,232
$462,271
     Project Costs
$73
$0
$0
$0
$0
$0
$0
     Capital Transfer
$110,659
$561
$1,811
$2,221
$1,293
$1,762
$1,612
     Other Transfers
$428
$535
$642
$749
$749
$749
$749
Total Uses
$1,704,806
$1,542,855
$1,557,192
$1,581,661
$1,643,327
$1,709,138
$1,687,936
Net Sources and Uses
($345,087)
($160,312)
($142,690)
($137,173)
($168,212)
($201,698)
($147,034)
Page 5 of 5