F3 — original pdf

Backup

Financial Status Report – December 2019 March 11, 2020 Christina Romero, Financial Mgr III, Financial Management Financial Status Report – December 2019 Revenues Revenue – Budget vs. Actual Year-to-Date in Millions Revenue & Requirements Summary Year-to-Date in Millions Total Revenues & Transfers $141.32 $150.11 Total Program Operating Req. $61.47 $66.02 Total Other Requirements $5.70 $5.03 Total Debt Service Transfers Out $38.15 $40.00 $36.81 $36.85 Allotment Actual Water Services • $8.58M (12.5%) above projections Wastewater Services • $0.84M (1.3%) above projections Total Revenues • $8.79M (6.2%) above projections 2 2 Financial Status Report – December 2019 Billed Water Revenue by Month Water Service Revenue Monthly Actuals v. Budget ) $ ( s r a l l o D f o s n o i l l i M 40 35 30 25 20 15 10 5 0 Nov Oct 25.52 22.74 20.34 20.46 18.25 19.38 21.17 22.42 24.73 29.39 32.51 31.53 Mar Apr May Sep Aug Dec Feb Jan Jun Jul Budget Actual Variance % Var 32.25 24.30 20.64 6.73 1.56 0.30 26.4% 6.9% 1.5% FY'19-Actual 20.48 18.89 17.34 17.66 17.48 17.21 20.04 20.48 22.66 25.01 32.99 36.84 3 Financial Status Report – December 2019 Water Revenue by Class Revenue by Customer Class Year-to-Date Water Service Revenue s r a l l o D f o s n o i l l i M 40 30 20 10 0 Budget Actual Variance % Var Residential Multifamily Commercial 18.76 27.33 14.64 Large Vol. Wholesale 2.56 5.31 33.45 6.12 22.4% 15.15 0.51 3.5% 20.29 1.53 8.2% 5.54 0.23 4.3% 2.76 0.20 7.8% Total 68.60 77.19 8.59 12.5% 4 Financial Status Report – December 2019 Rainfall by Month (Inches) Monthly Rainfall Actual vs. Normal i n a R f o s e h c n I 6 5 4 3 2 1 - Normal Actual Oct 4.40 2.53 Nov 2.88 0.62 Dec 2.39 0.78 Jan 2.20 0 Feb 1.72 0 Mar 2.82 0 Apr 2.26 0 May 4.84 0 Jun 3.23 0 Jul 2.31 0 Aug 2.33 0 Sep 2.97 0 National Weather Service data collected at Austin - Camp Mabry compared to 20-year averages In December 2019, 0.78 inches of rain fell, 1.61 inches below normal for the month. Generally, as rainfall increases significantly, water pumpage decreases and wastewater influent increases due to inflow and infiltration. Conversely, as rainfall decreases significantly, water pumpage increases and wastewater influent decreases. 5 Financial Status Report – December 2019 Total Requirements by Type Total Requirements by Type FY 2019-20 in Millions Debt Service $40.00 27.0% Operating Req. $66.02 44.6% Transfer to GF $11.87 8.0% Other Transfers $8.26 5.6% Other Req. $5.03 3.4% Transfer to CIP $16.72 11.3% Total = $147.90 million • Total YTD Requirements - $5.77M more than budgeted • YTD Program Operating Requirements - $4.55M or 7.4% more than budgeted • Debt Service Requirements - $1.85M or 4.8% more than budgeted 6 Financial Status Report – December 2019 Program Operating and Other Requirement Expenses Program Operating and Other Requirement Expenses Monthly Budget vs. Actual ) $ ( s r a l l o D f o s n o i l l i M 35 30 25 20 15 10 5 0 Oct Nov Dec Jan 18.99 Feb 19.17 Mar 19.14 Apr 18.77 May 23.04 Jun 20.12 Jul 18.86 Aug 19.92 Sep 19.14 20.89 17.87 3.02 Budget Actual Variance % Var FY'19-Actual 20.22 21.18 22.47 -1.29 14.5% -22.4% -6.1% 19.44 25.10 30.72 -5.62 24.18 The combined Program Operating and Other Requirements of $76.06 million were $3.89 million, or 5.8% above the budget allotment 18.18 17.34 17.43 17.71 21.28 18.15 17.64 17.45 20.32 7 Financial Status Report – December 2019 Fund Summary Beginning Balance $ 197.90 $ 197.96 $ 0.06 FY2019-20 Budget YTD Actual Differ- ence $ $ $ $ $ $ 68.61 64.85 0.57 0.50 3.63 3.16 141.32 5.70 38.15 36.81 142.13 77.19 65.69 0.67 0.55 3.23 2.78 150.11 5.03 40.00 36.85 147.90 8.58 0.84 0.10 0.05 (0.40) (0.38) 8.79 0.67 (1.85) (0.04) (5.77) $ $ $ Water Services Wastewater Services Reclaimed Services Reserve Fund Surcharge Other Revenues Transfers In Total Revenues & Transfers Total Other Requirements Total Debt Service Transfers Out Total Revenue Requirements Total Program Operating Req. $ 61.47 $ 66.02 $ (4.55) Ending Balance $ 197.09 $ 200.17 $ 3.08 8 Financial Status Report – December 2019 Capital Recovery Fee Collections Capital Recovery Fee Collections CRF Collections by Month ) $ ( s r a l l o D f o s n o i l l i M 3.5 3.0 2.5 2.0 1.5 1.0 0.5 0.0 Oct Water FY'20 Actual 3.11 FY'19 Actual 1.55 Nov Dec 2.09 2.07 1.77 1.77 Jan Feb Mar Apr May Jun Jul Aug 2.00 1.61 2.54 2.10 1.94 2.65 1.79 3.32 Oct Wastewater FY'20 Actual 1.15 FY'19 Actual 0.58 Nov Dec 0.71 0.77 0.65 0.68 Jan Feb Mar Apr May Jun Jul Aug 0.78 0.61 0.95 0.82 0.61 0.95 0.73 1.16 Sep YTD 7.27 3.32 26.35 Sep YTD 2.63 9.75 1.24 Combined FY'20 Actual FY'19 Actual Oct 4.26 2.13 Nov Dec 2.80 2.84 2.42 2.45 Jan 0.00 2.78 Feb Mar 0.00 0.00 2.22 3.50 Apr May 0.00 0.00 2.92 2.55 Jun 0.00 3.60 Jul 0.00 2.52 Aug 0.00 4.48 Sep YTD 0.00 9.89 4.55 36.11 During December 2019, Austin Water collected $3.51 million in Capital Recovery Fees (CRF) and interest, with $2.09 million and $0.71 million for Wastewater. For the fiscal year, Austin Water has collected $9.89 million in CRFs. 9 Financial Status Report – December 2019 Austin Water Fee Waivers Fee Waivers by Month ) $ ( s r a l l o D f o s d n a s u o h T 1,400 1,200 1,000 800 600 400 200 0 Nov Affordable Housing Annexation Council Developer Agreements Government Other Waivers Total Note: Combined water and wastewaters fee waivers 0.00 418.40 39.00 63.00 1,363.47 Oct 843.07 191.91 0.00 29.20 64.55 84.60 370.26 Dec 30.70 0.00 360.00 0.00 7.60 398.30 Jan Feb Mar Apr May Jun Jul Aug Sep YTD 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,065.68 - 807.60 103.55 155.20 2,132.03 10 Questions? 11