The URL can be used to link to this page

Home My WebLink About09/28/2023 - Meeting Materials Sa It La ke City Department of Public Utilities Financial Review Financial Dashboard (June 30, 2023-unaudited and July 31, 2023) September 28, 2023 . : Public Utilities Financial Dashboard As of June 30, 2023 - Unaudited p 250,000,000 Water Fund FY 23 Expense Detail ■ Personal Services 15.91% 200,000,000 O&M 150,000,000 ///,-2.83% Charges & Services Debt Services 100,000,000 ■ Capital Expenditures 50,000,000 29.34% 47.11% 0 Revenues Expenses ■ FY 21-22 FY 22-23 ■ FY 23 Bud YTD ■ FY 23 Bud 4.81% June 30, 2023 Change from FY22 Percent of Budget Operating Revenues $96,096,006 $16,934,191 92.03% Amount Percent Time Operating Expenses 69,765,098 1,655,960 82.00% Remaining Remaining Remaining Capital Expenditures 68,363,701 (10,756,366) 60.28% 2020 Bond Funds $22,056,584 28.54% 6.70% Total Expenses 138,128,799 (9,100,406) 69.59% 2022 Bond Funds $68,005,131 99.80% 66.70% June 30, 2023 Change from FY22 Percent Change (Included in Cash) Available Cash $98,481,536 ($17,706,301) -15.24% Accounts Receivable 5,581,832 616,875 12.42% PU II Financial Dashboard As of June 30, 2023 - Unaudited Sewer Fund FY 23 Expense Detail 500,000,000 2.55% 0.64%1 98% ■ Personal Services 450,000,000 I I / 6.05% O&M 400,000,000 — ■ Charges & Services 350,000,000 — ■ Debt Services 300,000,000 250,000,000 ■ Capital Expenditures 200,000,000 150,000,000 100,000,000 50,000,000 0 All INI 88.79% Revenues Expenses June 30, 2023 Change from FY22 Percent of Budget ■ FY 21-22 ■ FY22-23 FY23 Bud YTD ■ FY 23 Bud Operating Revenues $84,466,425 $26,055,537 124.05% Amount Percent Time Operating Expenses 21,372,687 1,469,132 77.09% Remaining Remaining Remaining Capital Expenditures 367,446,969 104,074,144 95.24% 2020 Bond Funds $0 0.00% 3.90% Total Expenses 388,819,656 105,543,276 94.02% 2022 Bond Funds $185,524,333 66.15% 66.70% June 30, 2023 Change from FY22 Percent Change (Included in Cash) Available Cash $204,952,636 ($94,367,979) -31.53% Accounts Receivable 2,834,467 (261,419) -8.44% P U Financial Dashboard As of June 30, 2023 - Unaudited Stormwater 30,000,000 FY 23 Expense Detail ■ Personal Services 25,000,000 19.47% O&M 20,000,000 1.33% Charges & Services Debt Services 15,000,000 Capital 10,000,000 17.53% Expenditures 5,000,000 54.41% - 7.26% 0 Revenues Expenses June 30, 2023 Change from FY22 Percent of Budget ■ FY21-22 FY22-23 FY23 Bud YTD FY 23 Bud Operating Revenues $14,651,393 $2,556,203 117.21% Operating Expenses 8,206,596 1,001,341 81.21% Amount Percent Time Capital Expenditures 11,648,948 1,913,432 87.59% Remaining Remaining Remaining Total Expenses 19,855,544 2,914,773 84.84% 2020 Bond Funds $6,165,206 42.37% 3.90% June 30, 2023 Change from FY22 Percent Change (Included in Cash) Available Cash $22,187,923 $1,024,257 4.84% Accounts Receivable 644,438 30,698 5.00% PublI Financial Dashboard As of June 30, 2023 - Unaudited Street Lighting FY 23 Expense Detail 7,000,000 3.70% 5.64% 0.00% ■ Personal Services 4.24% I 6,000,000 O&M Charges & Services 5,000,000 Debt Services 4,000,000 ■ Capital 3,000,000 Expenditures 2,000,000 1,000,000 86 42°/ 0 June 30, 2023 Change from FY22 Percent of Budget Revenues Expenses Operating Revenues $4,257,100 ($68,032) 99.53% Operating Expenses 4,201,078 640,214 126.18% ■ FY21-22 FY22-23 ■ FY23 Bud YTD FY 23 Bud Capital Expenditures 168,706 (318,424) 7.48% Total Expenses 4,369,784 321,790 78.23% June 30, 2023 Change from FY22 Percent Change Available Cash $5,361,175 ($189,946) -3.42% Accounts Receivable 135,313 (4,244) -3.04% PU I I, Financial Dashboard As of June 30, 2023 - Unaudited June 30, 2023 Change from FY22 Percent of Budget Operating Revenues $199,470,924 $45,477,899 105.38% Operating Expenses $103,545,459 $4,766,647 82.03% Capital Expenditures $447,628,324 $94,912,786 86.96% Total Expenses $551,173,783 $99,679,433 85.98% June 30, 2023 Change from FY22 Percent Change Available Cash $330,983,270 ($111,239,969) -25.15% Accounts Receivable $9,196,050 $381,910 4.33% Delinquent Billings 0.50% Amount Percent Remaining Time Remaining 2020 Bond Funds $28,221,790 14.24% 3.90% 2022 Bond Funds $253,529,464 72.73% 66.70% (Included in Cash) �u Lic Financial Dashboard As of July 31, 2023 p 200,000,000 Water Fund FY 24 Expense Detail 7.48% ■ Personal Services 12.69% O&M 150,000,000 i�,LLII Charges & Services 100,000,000 ■ Debt Services ■ Capital 50,000,000 15.11% Expenditures 60.36% 0 � Revenues Expenses 4.36% aA ■ FY 22-23 FY 23-24 ■ FY 24 Bud YTD ■ FY 24 Bud Amount Percent Time July 31, 2023 YTD Budget % of Budget Remaining Remaining Remaining Revenues $ 8,120,005.81 $ 13,008,851 62.42% 2020 Bond Funds $0 0.00% 1.10% Expenses 4,565,721.76 15,200,979 30.04% 2022 Bond Funds $68,005,131 99.80% 66.70% (Included in Cash) P U li Financial Dashboard As of July 31, 2023 Sewer Fund 350,000,000 FY 24 Expense Detail 300,000,000 0.34% ■ Personal Services 250,000,000 O&M 32.18% i Charges & Services 200,000,000 Debt Services 150,000,000 Capital 100,000,000 Expenditures 50,000,000 5.47% 53.38% 0 � 8.64% Revenues Expenses ■ FY 22-23 FY23-24 FY24 Bud YTD FY 24 Bud Amount Percent Time July 31, 2023 YTD Budget % of Budget Remaining Remaining Remaining Revenues $ 3,097,627.27 $ 24,161,769 12.82% 2020 Bond Funds $0 0.00% 1.10% Expenses 3,894,944.88 25,305,436 15.39% 2022 Bond Funds $185,524,333 66.15% 66.70% (Included in Cash) P U li Financial Dashboard As of July 31, 2023 Stormwater 25,000,000 FY 24 Expense Detail 0.57% ■ Personal Services 16.55% � 20,000,000 — O&M Charges & Services 15,000,000 Debt Services 52.28% m Capital 10,000,000 Expenditures 5,000,000 30.01% 0 � 0.59% Revenues Expenses ■ FY22-23 FY23-24 — FY24 Bud YTD FY 24 Bud Amount Percent Time July 31, 2023 YTD Budget % of Budget Remaining Remaining Remaining FRevenues $ 768,752.24 $ 1,655,495 46.44% 2020 Bond Funds $5,001,535 34.37% 1.10% Expenses 783,475.08 1,964,521 39.88% (Included in Cash) Pu Lic Financial Dashboard As of July 31, 2023 Street Lighting FY 24 Expense Detail 7,000,000 0.00% ■ Personal Services 9.72%� 15.57% 6,000,000 0.02 O&M Charges & Services 5,000,000 Debt Services 4,000,000 ■ Capital 3,000,000 Expenditures 2,000,000 1,000,000 74.69% 0 Revenues Expenses July 31, 2023 YTD Budget % of Budget ■ FY22-23 FY23-24 FY24 Bud YTD FY 24 Bud Revenues $ 191,641.67 $ 390,104 49.13% Expenses 165,947.14 507,224 32.72% Pu Lic Financial Dashboard July 31, 2023 July 31, 2023 YTD Budget % of Budget Revenues $ 12,178,026.99 $ 39,216,219 31.05% Expenses 9,410,088.86 42,978,160 21.90% Delinquent Billings 0.44% Amount Percent Remaining Time Remaining 2020 Bond Funds $5,001,535 2.52% 1.10% 2022 Bond Funds $253,529,464 72.73% 66.70% �u Li Updates Refining financial reporting in Workday • Bond issuance discussion • FY 2023 Audit in progress WIFIA updates Quarterly report submitted in July — Next report due October 31, 2023 P 115