Five Year Financial Forecast

City of El Mirage — Regular Meeting (2022-04-19)

View PDF Item 8 Meeting page

Extracted text (via pymupdf) 7912 characters
111
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
42,739,500
40,218,000
69,132,500
51,197,050
32,129,550
42,739,500
Revenues (1)
28,755,000
29,402,000
30,064,000
30,740,000
31,432,000
150,393,000
Expenditures (2)
38,087,500
32,320,000
34,740,000
37,320,000
37,440,000
179,907,500
Bond Proceeds
0
30,762,000
0
0
0
30,762,000
Capital
3,396,000
742,000
1,916,000
15,749,000
3,216,000
25,019,000
Transfers In/(Out)
10,207,000
1,812,500
(11,343,450)
3,261,500
2,471,500
6,409,050
Subtotal
40,218,000
69,132,500
51,197,050
32,129,550
25,377,050
25,377,050
Reserve
14,000,000
14,000,000
14,000,000
14,000,000
14,000,000
14,000,000
Ending Balance (EB)
26,218,000
55,132,500
37,197,050
18,129,550
11,377,050
11,377,050
131
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
821,500
130,000
0
0
0
821,500
Revenues (1)
2,450,000
2,505,000
2,561,000
2,619,000
2,678,000
12,813,000
Expenditures (2)
1,563,500
1,620,000
1,680,000
1,740,000
1,800,000
8,403,500
Capital
2,401,000
1,543,000
1,400,000
1,440,000
1,575,000
8,359,000
Transfers In/(Out)
823,000
528,000
519,000
561,000
697,000
3,128,000
Subtotal
130,000
0
0
0
0
0
Reserve
0
0
0
0
0
0
Ending Balance
130,000
0
0
0
0
0
511
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
10,081,500
7,332,500
3,515,500
2,823,000
2,717,500
10,081,500
Revenues (1)
9,510,000
10,162,500
10,198,000
10,233,500
10,269,000
50,373,000
Bond Proceeds
0
0
0
0
0
0
Expenditures (2)
6,005,500
6,079,000
5,650,000
5,832,000
6,171,500
29,738,000
Debt Service
1,797,500
1,806,000
1,693,000
973,000
973,000
7,242,500
Capital
1,554,000
3,133,500
581,500
563,000
1,675,000
7,507,000
Transfers In/(Out)
(2,902,000)
(2,961,000)
(2,966,000)
(2,971,000)
(2,976,500)
(14,776,500)
Subtotal
7,332,500
3,515,500
2,823,000
2,717,500
1,190,500
1,190,500
Reserve
3,220,500
3,268,500
3,164,000
3,210,000
3,295,000
3,295,000
Ending Balance
4,112,000
247,000
(341,000)
(492,500)
(2,104,500)
(2,104,500)
FIVE YEAR FUNDING PROJECTIONS FOR CAPITAL IMPROVEMENT PLAN
General Fund
HURF
Water

FIVE YEAR FUNDING PROJECTIONS FOR CAPITAL IMPROVEMENT PLAN
541
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
9,206,500
7,943,500
6,934,000
7,298,500
(2,477,000)
9,206,500
Revenues (1)
3,295,000
3,316,000
3,329,500
3,343,000
3,357,000
16,640,500
Bond Proceeds
0
0
0
0
0
0
Expenditures (2)
1,867,500
1,813,500
1,887,000
1,963,500
2,044,000
9,575,500
Debt Service
25,500
25,500
25,500
25,500
25,500
127,500
Capital
1,959,000
          
1,708,500
          
200,000
              
10,200,000
        
250,000
              
14,317,500
Transfers In/(Out)
(706,000)
(778,000)
(852,500)
(929,500)
(1,009,000)
(4,275,000)
Subtotal
7,943,500
6,934,000
7,298,500
(2,477,000)
(2,448,500)
(2,448,500)
Reserve
1,972,000
1,990,500
2,031,500
2,074,500
2,118,500
2,118,500
Ending Balance
5,971,500
4,943,500
5,267,000
(4,551,500)
(4,567,000)
(4,567,000)
591
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
1,053,000
899,500
946,000
944,500
893,000
1,053,000
Revenues (1)
2,000,000
2,288,000
2,297,500
2,306,500
2,316,000
11,208,000
Bond Proceeds
0
0
0
0
0
0
Expenditures (2)
1,796,500
1,884,500
1,942,000
2,001,000
2,061,500
9,685,500
Debt Service
0
0
0
0
0
0
Capital
0
0
0
0
0
0
Transfers In/(Out)
(357,000)
(357,000)
(357,000)
(357,000)
(357,000)
(1,785,000)
Subtotal
899,500
946,000
944,500
893,000
790,500
790,500
Reserve
359,500
368,500
378,000
387,500
397,500
397,500
Ending Balance
540,000
577,500
566,500
505,500
393,000
393,000
114
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
208,500
0
0
0
0
208,500
Revenues (1)
365,000
373,000
381,000
390,000
399,000
1,908,000
Expenditures (2)
1,121,500
1,155,000
1,190,000
1,226,000
1,263,000
5,955,500
Capital
7,000
728,000
13,890,950
0
0
14,625,950
Transfers In/(Out)
555,000
1,510,000
14,699,950
836,000
864,000
18,464,950
Subtotal
0
0
0
0
0
0
Reserve
0
0
0
0
0
Ending Balance
0
0
0
0
0
0
Municipal Court
Sewer
Sanitation

FIVE YEAR FUNDING PROJECTIONS FOR CAPITAL IMPROVEMENT PLAN
121
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
989,500
435,500
371,500
308,500
246,500
989,500
Revenues (1)
45,000
46,000
47,000
48,000
49,000
235,000
Expenditures (2)
42,000
110,000
110,000
110,000
120,000
492,000
Capital
557,000
0
0
0
0
557,000
Transfers In/(Out)
0
Subtotal
435,500
371,500
308,500
246,500
175,500
175,500
Reserve
0
0
0
0
0
0
Ending Balance
435,500
371,500
308,500
246,500
175,500
175,500
148
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
0
0
0
0
0
0
Revenues (1)
1,100,000
350,000
350,000
350,000
350,000
2,500,000
Expenditures (2)
0
0
0
0
0
0
Capital
1,100,000
350,000
350,000
350,000
350,000
2,500,000
Transfers In/(Out)
0
0
0
0
0
0
Subtotal
0
0
0
0
0
0
Reserve
0
0
0
0
0
0
Ending Balance
0
0
0
0
0
0
161
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
445,000
439,500
414,500
389,500
364,500
445,000
Revenues (1)
2,030,000
1,875,000
1,875,000
1,875,000
1,875,000
9,530,000
Expenditures (2)
2,135,500
2,000,000
2,000,000
2,000,000
2,000,000
10,135,500
Capital
0
0
0
0
0
Transfers In/(Out)
100,000
100,000
100,000
100,000
100,000
500,000
Subtotal
439,500
414,500
389,500
364,500
339,500
339,500
Reserve
203,000
187,500
187,500
187,500
187,500
187,500
Ending Balance
236,500
227,000
202,000
177,000
152,000
152,000
156
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
15,023,000
6,185,500
5,685,500
3,185,500
15,023,000
Revenues (1)
5,010,000
0
0
0
5,010,000
Bond Proceeds
0
0
0
0
0
Expenditures (2)
0
500,000
2,500,000
2,474,500
5,474,500
Debt Service
0
0
0
0
0
Capital
13,847,500
0
0
0
13,847,500
Transfers In/(Out)
0
0
0
(711,000)
(711,000)
Subtotal
6,185,500
5,685,500
3,185,500
0
0
Ending Balance
6,185,500
5,685,500
3,185,500
0
0
Capital Streets
Municipal Court Enhancement
CDBG
Debt Service

FIVE YEAR FUNDING PROJECTIONS FOR CAPITAL IMPROVEMENT PLAN
141
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
160,500
30,500
0
0
0
160,500
Revenues (1)
95,000
95,000
95,000
95,000
95,000
475,000
Expenditures (2)
225,000
225,000
225,000
225,000
225,000
1,125,000
Capital
0
Transfers In/(Out)
0
99,500
130,000
130,000
130,000
489,500
Subtotal
30,500
0
0
0
0
0
Reserve
0
0
0
0
0
0
Ending Balance
30,500
0
0
0
0
0
128
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
86,500
24,000
0
0
0
86,500
Revenues (1)
20,000
20,000
20,000
20,000
20,000
100,000
Expenditures (2)
82,500
90,000
90,000
100,000
100,000
462,500
Capital
0
0
0
0
0
0
Transfers In/(Out)
0
46,000
70,000
80,000
80,000
276,000
Subtotal
24,000
0
0
0
0
0
Reserve
0
0
0
0
0
Ending Balance
24,000
0
0
0
0
0
149
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
11,766,000
342,500
0
0
0
11,766,000
Revenues (1)
11,360,000
9,777,500
10,250,000
10,000,000
10,000,000
51,387,500
Expenditures (2)
21,986,500
10,000,000
10,000,000
10,000,000
10,000,000
61,986,500
Capital
797,000
120,000
250,000
1,167,000
Transfers In/(Out)
0
0
0
0
0
0
Subtotal
342,500
0
0
0
0
0
Reserve
0
0
0
0
0
Ending Balance
342,500
0
0
0
0
0
Citywide Total
FY22-23
FY23-24
FY24-25
FY25-26
FY26-27
5 YR Summary
Beginning Balance
92,581,000
63,981,000
86,999,500
66,146,550
33,874,050
92,581,000
Revenues (1)
66,035,000
60,210,000
61,468,000
62,020,000
62,840,000
312,573,000
Expenditures (2)
74,913,500
57,797,000
62,014,000
64,992,000
63,225,000
322,941,500
Debt Service
1,823,000
1,831,500
1,718,500
998,500
998,500
7,370,000
Bond Proceeds
0
30,762,000
0
0
0
30,762,000
Capital
25,618,500
8,325,000
18,588,450
28,302,000
7,066,000
87,899,950
Transfers In/(Out)
7,720,000
0
0
0
0
7,720,000
Subtotal
63,981,000
86,999,500
66,146,550
33,874,050
25,424,550
25,424,550
Reserve
19,755,000
19,815,000
19,761,000
19,859,500
19,998,500
19,998,500
Ending Balance
44,226,000
67,184,500
46,385,550
14,014,550
5,426,050
5,426,050
Special Projects
Dial-A-Ride (LTAF)
Police Towing