Loading...
HomeMy WebLinkAbout01/28/2021 - Meeting Materials ■ ■ ■ ■ Public SLC PUBLIC UTILITIES Financial Review : Financial Dashboard(November 30, 2020 and December 31, 2020) January 28, 2021 Public � � utilities Financial Dashboard As of November 30, 2020 Water Fund FY 21 Expense Detail 140,000,000 13.31 ■ Personal Services 120,000,000 2.23% ■ O&M 100,000,000 ■ Charges &Services ■ Debt Services 80,000,000 21.45% 60,000,000 ■ Capital Expenditures 40,000,000 20,000,000 1.84% 0 61.17% Revenues Expenses FY 19-20 ■ FY 20-21 ■ FY 21 Bud YTD FY 21 Bud November 30,2020 Change from FY20 Percent of Budget Operating Revenues $51,091,454 $4,419,870 68.01% Operating Expenses 27,843,013 1,861,419 38.78% Capital Expenditures 46,044,131 17,790,059 89.15% Amount Percent Time Total Expenses 73,887,144 19,651,478 59.85% Remaining Remaining Remaining November 30,2020 Change from FY20 Percent Change 2020 Bond Funds $72,692,419 94.07% 90.00% Available Cash $120,829,576 $72,626,746 150.67% (Included in Cash) Accounts Receivable 3,402,396 (228,213) -6.29% Public <: r utilities Financial Dashboard As of November 30, 2020 Sewer Fund FY21 Expense Detail 250,000,000 2.46%� 0.34 r1.35% 2 77% i I / Personal Services 200,000,000 - O&M Charges & Services 150,000,000 ■ Debt Service ■ Capital Expenditures 100,000,000 50,000,000 il 0 . 93.08% Revenues Expenses November 30,2020 Change from FY20 Percent of Budget ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD ■ FY 21 Bud Operating Revenues $21,206,392 $1,783,886 41.09% Operating Expenses 7,390,031 274,222 32.25% Capital Expenditures 165,844,949 83,175,512 93.69% Amount Percent Time Total Expenses 173,234,980 83,449,734 86.65% Remaining Remaining Remaining November 30, 2020 Change from FY20 Percent Change 2020 Bond Funds $77,570,149 72.92% 90.00% Available Cash $99,696,019 $46,303,425 86.72% (Included in Cash) Accounts Receivable 2,752,278 (535,654) -16.29% Public f utilities Financial Dashboard As of November 30, 2020 Stormwater FY21 Expense Detail 20,000,000 18,000,000 17.46% 16,000,000 14,000,000 57.05% � ,1.69% ■ personal Services 12,000,000 ■ O&M 10,000,000 4" ■ Charges & Services 8,000,000 15.870%Debt Services 6,000,000 ■ Capital Expenditures 4,000,000 7 93% 2,000,000 0 Revenues Expenses November 30,2020 Change from FY20 Percent of Budget Operating Revenues $4,245,615 ($336,943) 42.45% ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD FY 21 Bud Operating Expenses 2,642,595 323,894 32.33% Capital Expenditures 4,305,045 (1,708,998) 51.71% Amount Percent Time Total Expenses 6,947,640 (1,385,104) 42.11% Remaining Remaining Remaining November 30,2020 Change from FY20 Percent Change 2020 Bond Funds $12,464,827 85.66% 90.00% Available Cash $19,627,648 $13,266,020 208.53% (Included in cash) Accounts Receivable 511,056 (244,340) -32.35% Public <: r utilities Financial Dashboard As of November 30, 2020 Street Lighting FY21 Expense Detail 6,000,000 7 55% 4.70% 10.55% �0.00% ■ Personal Services 5,000,000 ■ O&M ■ Charges & Services 4,000,000 Debt Services ■ Capital Expenditures 3,000,000 2,000,000 77.20% 1,000,000 0 Revenues Expenses November 30,2020 Change from FY20 Percent of Budget Operating Revenues $1,551,089 ($100,003) 36.59% ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD L FY 21 Bud Operating Expenses 937,237 (200,341) 35.64% Capital Expenditures 50,151 (265,490) 2.24% Total Expenses 987,388 (465,831) 20.28% November 30, 2020 Change from FY20 Percent Change Available Cash $6,522,023 $944,667 16.94% Accounts Receivable 177,956 (74,676) -29.56% Public f � utilities Financial Dashboard As of November 30, 2020 Total Public utilities November 30, 2020 Change from FY20 Percent of Budget Operating Revenues $78,094,550 $5,766,810 55.39% Operating Expenses $38,812,876 $2,259,194 36.78% Capital Expenditures $216,244,276 $98,991,083 90.39% Total Expenses $255,057,152 $101,250,277 73.98% November 30, 2020 Change from FY20 Percent Change Available Cash $246,675,266 $133,140,858 117.27% Accounts Receivable $6,843,686 ($1,082,883) -13.66% Delinquent Billings 2.31% Amount Percent Remaining Time Remaining 2020 Bond Funds $162,727,395 82.10% 90.00% (Included in Cash) Public � � utilities Financial Dashboard As of December 31, 2020 Water Fund FY 21 Expense Detail 160,000,000 12.11% ■ Personal Services 140,000,000 1.98% ■ O&M 120,000,000 ■ Charges &Services 100,000,000 19.35%■ Debt Services 80,000,000 ■ Capital 60,000,000 Expenditures 40,000,000 1.76% 20,000,000 0 Revenues Expenses 64.80% FY 19-20 ■ FY 20-21 ■ FY 21 Bud YTD FY 21 Bud December 31, 2020 Change from FY20 Percent of Budget Operating Revenues $54,538,521 $4,672,333 72.60% Operating Expenses 33,036,854 2,177,580 46.01% Capital Expenditures 64,012,763 33,331,432 123.95% Amount Percent Time Total Expenses 97,049,617 35,509,012 78.62% Remaining Remaining Remaining December 31, 2020 Change from FY20 Percent Change 2020 Bond Funds $72,425,409 93.73% 87.10% Available Cash $115,924,384 $71,446,098 160.63% (Included in Cash) Accounts Receivable 2,171,028 (7,463) -0.34% Public <: r utilities Financial Dashboard As of December 31, 2020 Sewer Fund FY21 Expense Detail 250,000,000 2.88%� 0.41 io r1.72% \ / 3.31% Personal Services 200,000,000 — O&M Charges & Services 150,000,000 ■ Debt Service ■ Capital Expenditures 100,000,000 50,000,000 / . 91.68%J 0 Revenues Expenses December 31,2020 Change from FY20 Percent of Budget ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD ■ FY 21 Bud Operating Revenues $25,083,807 $2,086,367 48.60% Operating Expenses 9,119,865 318,394 39.80% Capital Expenditures 166,863,983 77,247,313 94.27% Amount Percent Time Total Expenses 175,983,848 77,565,707 88.02% Remaining Remaining Remaining December 31,2020 Change from FY20 Percent Change 2020 Bond Funds $74,824,930 70.34% 87.10% Available Cash $107,245,181 $50,945,287 90.49% (Included in Cash) Accounts Receivable 2,106,206 58,377 2.85% Public <: r Utilities Financial Dashboard As of December 31, 2020 Stormwater FY21 Expense Detail 25,000,000 17.56% 20,000,000 55.91% �1.55% ■ Personal Services 15,000,000 / ■ O&M ■ Charges & Services 10,000,000 I 16.75 Debt Services ■ Capital Expenditures 5,000,000 108.23%. 0 Revenues Expenses December 31,2020 Change from FY20 Percent of Budget ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD ■ FY 21 Bud Operating Revenues $5,173,203 ($259,971) 51.73% Operating Expenses 3,195,923 354,066 39.10% Capital Expenditures 4,982,145 (1,705,654) 59.85% Amount Percent Time Total Expenses 8,178,068 (1,351,588) 49.57% Remaining Remaining Remaining December 31, 2020 Change from FY20 Percent Change 2020 Bond Funds $12,461,404 85.64% 87.10% Available Cash $19,982,784 $13,217,761 195.38% (Included in Cash) Accounts Receivable 429,809 (151,573) -26.07% Public <: r utilities Financial Dashboard As of December 31, 2020 Street Lighting FY21 Expense Detail 6,000,000 15.17% 7.16% 0.00% ■ Personal Services 5,000,000 ■ O&M 5.12 ■ Charges & Services 4,000,000 Debt Services ■ Capital Expenditures 3,000,000 2,000,000 72.56% 1,000,000 0 Revenues Expenses December 31,2020 Change from FY20 Percent of Budget Operating Revenues $1,903,373 ($117,688) 44.90% ■ FY19-20 ■ FY20-21 ■ FY21 Bud YTD L FY 21 Bud Operating Expenses 1,507,632 221,722 57.33% Capital Expenditures 286,819 (28,822) 12.80% Total Expenses 1,794,451 192,900 36.85% December 31, 2020 Change from FY20 Percent Change Available Cash $6,088,751 $252,170 4.32% Accounts Receivable 147,736 (58,625) -28.41% Public f � utilities Financial Dashboard As of December 31 Y2020 Total Public utilities December 31, 2020 Change from FY20 Percent of Budget Operating Revenues $86,698,904 $6,381,041 61.50% Operating Expenses $46,860,274 $3,071,762 44.41% Capital Expenditures $236,145,710 $108,844,269 98.71% Total Expenses $283,005,984 $111,916,031 82.09% December 31, 2020 Change from FY20 Percent Change Available Cash $249,241,100 $135,861,316 119.83% Accounts Receivable $4,854,779 ($159,284) -3.18% Delinquent Billings 4.50% Amount Percent Remaining Time Remaining 2020 Bond Funds $159,711,744 80.58% 87.10% (Included in Cash) Public r utilities Updates Budget planning for FY2022 Budget subcommittee meetings every other week — Utilize projected FY 2022 budget as a guide Analyzing customer usage by class to assist in projecting FY 2022 revenues • Evaluating and prioritizing projects to develop financing strategies - Submitted initial WIFIA quarterly construction report