Loading...
HomeMy WebLinkAbout06/29/2023 - Meeting Materials (2) ■ ■ ■ ■ Public SLC PUBLIC UTILITIES Financial Review : Financial Dashboard(May 31, 2023) June 29, 2023 Public � r Utilities n Financial Dashboard i As of May 31, 2023 Water Fund FY 23 Expense Detail 250,000,000 ■ Personal Services 17.20% ■ O&M 200,000,000 2.87% ■ Charges & Services 150,000,000 Debt Services ■ Capital 100,000,000 Expenditures 45.57% 29.50% 50,000,000 0 4.87% Revenues Expenses May 31,2023 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY 22-23 ■ FY 23 Bud YTD FY 23 Bud [operating Revenues $83,609,999 $13,630,650 80.07% Operating Expenses 65,103,251 3,660,612 76.52% Amount Percent Time Capital Expenditures 59,856,376 (15,869,256) 52.78% Remaining Remaining Remaining Total Expenses 124,959,627 (12,208,644) 62.96% 2020 Bond Funds $23,562,636 30.49% 6.70% May 31,2023 Change from FY22 Percent Change 2022 Bond Funds $68,005,131 99.80% 69.40% Available Cash $102,523,699 $46,478,259 82.93% (Included in Cash) I Accounts Receivable 2,825,445 299,525 11.86% Public <: r utilities Financial Dashboard As of May 31, 2023 Sewer Fund FY23 Expense Detail 3.26%� 0,77�o ^2.37% 500,000,000 � / 7.31%■ Personal Services 450,000,000 ■ O&M 400,000,000 ■ Charges & Services 350,000,000 Debt Service 300,000,000 ■ Capital Expenditures 250,000,000 200,000,000 150,000,000 100,000,000 86.31% 50,000,000 ' 0 Revenues Expenses May 31,2023 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY22-23 ■ FY23 Bud YTD r FY 23 Bud Operating Revenues $77,432,658 $24,524,727 113.72% Operating Expenses 20,064,674 2,204,889 72.38% Amount Percent Time Capital Expenditures 271,046,681 9,924,430 70.25% Remaining Remaining Remaining Total Expenses 291,111,355 12,129,319 70.40% 2020 Bond Funds $0 0.00% 6.70% May 31,2023 Change from FY22 Percent Change 2022 Bond Funds $207,319,414 73.92% 69.40% Available Cash $225,325,791 $184,306,912 449.32% (Included in Cash) Accounts Receivable 3,371,350 1,020,079 43.38% Public <: r utilities Financial Dashboard As of May 31, 2023 Stormwater FY23 Expense Detail 30,000,000 23.18% 25,000,000 20,000,000 Personal Services _1.47%0 O&M 15,000,000 ■ Charges & Services 59.98/ �7.98/ Debt Services 10,000,000 ■ Capital Expenditures 5,000,000 7.38% 0 Revenues Expenses May 31,2023 Change from FY22 Percent of Budget ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD A FY 23 Bud Operating Revenues $13,335,130 $2,313,149 106.68% Operating Expenses 5,723,726 1,222,912 56.64% Capital Expenditures 10,519,962 (731,644) 79.10% Amount Percent Time Total Expenses 16,243,688 491,268 69.41% Remaining Remaining Remaining May 31,2023 Change from FY22 Percent Change 2020 Bond Funds $6,687,108 45.95% 6.70% Available Cash $22,558,854 $1,430,052 6.77% (Included in Cash) Accounts Receivable 454,124 (52,201) -10.31% Public � r Utilities n Financial Dashboard As of May 31, 2023 Street Lighting FY23 Expense Detail 97% 7,000,000 4.23% 4.02% 5. 0.00% ■ Personal Services 6,000,000 ■ O&M ■ Charges & Services 5,000,000 Debt Services 4,000,000 ■ Capital Expenditures 3,000,000 2,000,000 85.77% 1,000,000 0 May 31,2023 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $3,882,613 ($69,439) 90.77% ■ FY21-22 ■ FY22-23 ■ FY23 Bud YTD FY 23 Bud Operating Expenses 3,845,457 659,262 115.50% Capital Expenditures 168,706 (107,753) 7.48% Total Expenses 4,014,163 551,509 71.86% May 31,2023 Change from FY22 Percent Change Available Cash $5,394,139 ($204,219) -3.65% Accounts Receivable 95,890 (15,586) -13.98% Public f � utilities Financial Dashboard As of May 31, 2023 Total Public Utilities May 31, 2023 Change from FY22 Percent of Budget Operating Revenues $178,260,400 $40,399,087 94.17% Operating Expenses $94,737,108 $7,747,675 75.05% Capital Expenditures $341,591,725 ($6,784,223) 66.36% Total Expenses $436,328,833 $963,452 68.07% May 31, 2023 Change from FY22 Percent Change Available Cash $355,802,483 $232,011,004 187.42% Accounts Receivable $6,746,809 $1,251,817 22.78% Delinquent Billings 0.77% Amount Percent Remaining Time Remaining 2020 Bond Funds $30,249,743 15.26% 6.70% 2022 Bond Funds $275,324,545 78.98% 69.40% (Included in Cash) Public utilities Updates Budget items Approved June 13 Bond issuance early 2024 WIFIA updates Next quarterly report due July 31, 2023