Attachment 2 - City of Mesa Utility Fund Cash Flow Projections

Cash +$10M 31/32 FY Forecast $9,257,249 $7,282,910 $10,705,768 ($1,285,440) $1,840,407 ($147,034) $27,653,860 $167,767,392 $195,421,252 24.0% 3.50% 5.00% 7.00% 8.00% 5.00% 5.50% 5.50% $3.00 $5.00 $1.00 $3.00
Cash +$10M 30/31 FY Forecast $8,290,426 $7,593,925 $9,893,037 ($1,369,446) $1,141,125 ($201,698) $25,347,369 $142,420,023 $167,767,392 21.9% 3.50% 5.00% 7.00% 8.00% 5.00% 5.50% 5.50% $3.00 $5.00 $1.00 $3.00
Cash +$5M 29/30 FY Forecast $10,087,066 $4,816,543 $5,258,107 ($1,269,674) $361,173 ($168,212) $19,085,004 $123,335,020 $142,420,023 19.6% 3.50% 5.00% 7.00% 8.00% 5.00% 5.50% 5.50% $3.00 $5.00 $1.00 $3.00
28/29 FY Forecast $11,317,938 $587,564 $5,372,359 ($854,339) $448,895 ($137,173) $16,735,244 $106,599,776 $123,335,020 17.9% 3.50% 5.00% 7.50% 8.50% 5.50% 5.50% 5.50% $3.00 $5.00 $1.00 $3.00
27/28 FY Forecast $4,650,774 ($4,067,116) $2,357,854 ($968,075) ($3,287,572) ($142,690) ($1,456,824) $108,056,600 $106,599,776 16.5% 3.50% 13.00% 7.50% 8.50% 5.50% 5.50% 5.50% $3.00 $5.00 $1.00 $3.00 5 of
Projections 1 Page
Flow 26/27 FY Projected ($2,872,881) ($5,668,273) $210,001 ($613,600) ($2,995,696) ($160,312) ($12,100,760) $120,157,360 $108,056,600 17.5% 3.50% 13.00% 7.50% 8.50% 5.50% 6.00% 6.00% $2.00 $5.00 $1.50 $3.00
Cash
Fund 25/26 FY Estimate $5,460,861 ($3,781,233) $655,139 $4,060,522 ($5,312,726) ($345,087) $737,476 $119,419,884 $120,157,360 20.6% 2.50% 20.00% 7.50% 8.50% 5.50% 5.50% 5.50% $1.00 $5.00 $0.00 $3.00
Utility
Mesa charge
of USES Percent* usage) charge svc - charge
City - AND Balance Balance Expenditures 1 (Tier (usage) Residential Non-Residential Residential Commercial svc - charge svc -
2 COOLING SOURCES Balance Year's Rolloff Residential Non-Residential svc -
Attachment 9/8/2026 WASTE GAS NET Reserve Reserve Reserve Fiscal Next Residential Commercial WASTE WASTE WASTE Residential Non-Residential
of WATER WASTEWATER SOLID ELECTRIC NATURAL DISTRICT TOTAL Beginning Ending Ending of % a WATER WATER WASTEWATER WASTEWATER SOLID SOLID SOLID ELECTRIC ELECTRIC GAS GAS
As *As

Cash +$10M 31/32 FY Forecast $742,869,185 $51,791,198 $794,660,383 $264,980,265 $51,791,198 $316,771,463 $346,785 $220,475,914 $198,072,958 $15,862,390 $14,488,677 $988,337 $767,006,523 $27,653,860 $167,767,392 $195,421,252 24.0%
Cash +$10M 30/31 FY Forecast $700,245,007 $50,811,494 $751,056,501 $256,211,083 $50,811,494 $307,022,577 $448,208 $207,724,005 $182,373,802 $14,990,981 $12,161,223 $988,337 $725,709,132 $25,347,369 $142,420,023 $167,767,392 21.9%
Cash +$5M 29/30 FY Forecast $659,436,817 $48,910,359 $708,347,176 $249,957,024 $48,910,359 $298,867,383 $331,302 $195,513,783 $170,717,711 $14,137,441 $8,706,217 $988,337 $689,262,173 $19,085,004 $123,335,020 $142,420,023 19.6%
28/29 FY Forecast $619,829,926 $44,795,442 $664,625,368 $244,749,285 $44,795,442 $289,544,727 $313,744 $183,758,900 $159,515,066 $13,263,618 $505,733 $988,337 $647,890,124 $16,735,244 $106,599,776 $123,335,020 17.9%
Projections 27/28 FY Forecast $574,310,684 $43,065,925 $617,376,609 $237,711,461 $43,065,925 $280,777,386 $409,360 $170,436,529 $151,516,765 $12,319,242 $2,527,005 $847,146 $618,833,433 ($1,456,824) $108,056,600 $106,599,776 16.5% 5 of 2
Page
Flow 26/27 FY Projected $530,817,031 $38,988,637 $569,805,668 $230,066,261 $38,988,637 $269,054,898 $2,294,509 $157,995,931 $139,134,266 $11,368,463 $1,352,409 $705,954 $581,906,429 ($12,100,760) $120,157,360 $108,056,600 17.5%
Cash
Fund 25/26 FY Estimate $495,300,800 $38,852,952 $534,153,752 $204,927,035 $33,957,225 $238,884,260 $805,166 $147,042,095 $131,756,953 $10,655,881 $3,707,157 $564,764 $533,416,276 $737,476 $119,419,884 $120,157,360 20.6%
Utility
Mesa
of City Revenues Expenditures Transfers Percent* Expenditures
- 2 Expenditures Subtotal Transfer Transfer Infrastructure Uses Balance Balance Balance Year's
Attachment 9/8/2026 Funding of Revenues EECAF/PNGCAF Sources Funding Operating EECAF/PNGCAF Expenditure Costs Project Fund General Service Lifecycle/ Transfer Capital Transfers Uses and Sources Reserve Reserve Reserve Fiscal Next
TOTAL of As Sources Total of Uses Debt Other Total Net Beginning Ending Ending of % a *As

Cash 31/32 Forecast $142,645,941 $178,775,338 $9,250,165 $330,671,444 $107,345,587 $0 $98,128,534 $97,728,145 $6,613,429 $11,225,544 $372,957 $321,414,196 $9,257,249 31/32 Forecast $98,735,422 $87,120,519 $5,593,503 $191,449,444 $56,716,870 $0 $56,293,799 $67,138,163 $3,828,989 $97,530 $91,183 $184,166,534 $7,282,910
+$10M FY FY
Cash 30/31 Forecast $137,276,797 $166,974,180 $9,058,013 $313,308,990 $103,962,816 $0 $92,928,525 $90,748,475 $6,266,180 $10,739,611 $372,957 $305,018,564 $8,290,426 30/31 Forecast $91,843,060 $80,184,456 $5,473,432 $177,500,948 $53,851,493 $0 $52,135,231 $60,187,778 $3,550,019 $91,319 $91,183 $169,907,023 $7,593,925
+$10M FY FY
Cash 29/30 Forecast $132,072,435 $155,563,751 $8,873,471 $296,509,656 $100,973,758 $0 $87,897,284 $86,116,105 $5,930,193 $5,132,293 $372,957 $286,422,591 $10,087,066 29/30 Forecast $85,382,454 $73,725,288 $5,358,044 $164,465,785 $52,590,720 $0 $48,249,645 $55,348,294 $3,289,316 $80,083 $91,183 $159,649,241 $4,816,543
+$5M FY FY
28/29 Forecast $126,826,813 $144,805,667 $8,700,565 $280,333,045 $98,337,028 $0 $83,106,274 $81,369,352 $5,606,661 $222,835 $372,957 $269,015,106 $11,317,938 28/29 Forecast $78,995,568 $67,465,994 $5,249,977 $151,711,540 $51,066,425 $0 $44,446,733 $52,340,983 $3,034,231 $144,422 $91,183 $151,123,976 $587,564
FY FY
27/28 Forecast $120,813,416 $129,343,959 $8,530,943 $258,688,318 $94,479,319 $0 $76,647,853 $76,494,892 $5,173,766 $922,037 $319,677 $254,037,544 $4,650,774 27/28 Forecast $72,565,599 $61,556,730 $4,658,043 $138,780,373 $49,338,834 $0 $40,736,078 $49,062,131 $2,775,607 $856,681 $78,157 $142,847,488 ($4,067,116) 5
Projections FY FY of 3 Page
Flow 26/27 Projected $115,199,895 $113,499,823 $8,567,008 $237,266,727 $91,542,055 $205,742 $70,523,339 $72,245,964 $4,745,335 $610,774 $266,398 $240,139,607 ($2,872,881) 26/27 Projected $66,806,673 $56,307,810 $3,608,746 $126,723,228 $47,309,255 $176,978 $37,424,468 $44,303,670 $2,534,465 $577,535 $65,130 $132,391,501 ($5,668,273)
Cash FY FY
Fund 25/26 Estimate $110,413,201 $97,378,682 $13,428,043 $221,219,926 $77,957,329 $30,331 $65,787,026 $67,167,958 $4,424,399 $178,904 $213,118 $215,759,065 $5,460,861 25/26 Estimate $64,913,314 $51,760,012 $4,567,765 $121,241,091 $42,664,976 $20,318 $35,879,651 $42,965,118 $2,424,822 $1,015,335 $52,104 $125,022,324 ($3,781,233)
Utility FY FY
Mesa
of Revenues Transfers Revenues Transfers
City - 2 Revenues Rate Expenditures Transfer Transfer Infrastructure Uses Revenues Rate Expenditures Transfer Transfer Infrastructure Uses
Funding of Rate Non-Residential Revenues Sources Funding Costs Fund Service Transfer Transfers and Funding of Rate Non-Residential Revenues Sources Funding Costs Fund Service Transfer Transfers and
Attachment WATER Sources Residential Other Total of Uses Operating Project General Debt Lifecycle/ Capital Other Uses Total Sources WASTEWATER Sources Residential Other Total of Uses Operating Project General Debt Lifecycle/ Capital Other Uses Total Sources
Net Net

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

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