HomeMy WebLinkAbout16 Power Point 2020 YE Financial Review v6
April 7, 2021 12/22/2022 Half nd 2020 2-Budget Performance Review 16ITEM #
BACKGROUND 4/7/2021-2020 Year End Financial Report 22/22/2022 BACKGROUNDBACKGROUNDprepared and adopted. This report includes this information.that were not anticipated at the time the
budget was needs that have occurred since the adoption of the budget variance from planned expenditures and any projects or budget performance review a description of any significant
annual -District Code further requires accompanying the semi•and FY21 Board Approved Budget.expenditures. This is the second of four reviews for the FY20 revenues and expenditures
compared to actual revenues and annual review of the budgeted -District Code requires a semi•The FY20 and FY21 Budget was adopted November 6, 2019.•BACKGROUND
INFORMATION 4/7/2021-2020 Year End Financial Report 32/22/2022 DISTRICT OVERVIEWDISTRICT OVERVIEWDirectors73 Employees | 5 Board •$48 Million Annual Budget•Total Net Position–•ResourcesTotal
Assets and Deferred Outflows of –$184 Million •California / Town of TruckeeCounty, 46 square miles of service territory, primarily in Nevada •The District was established in 1927.
93 Years Young! •INFORMATION
INFORMATION$ amounts as of 12/31/2020 and for 2020, as applicabledollar values are estimates or averages and vary over time-Non highelevation 7370’ service low 5745’ service elevation
mgd| 144.8 gpm10,250 production capacitypotable water # miles of pipeline47 pressure zonesstations25 pumping 32 active storage tanks (9.4mg)3 inactive water wellspotable-non| 3 potable
water 10 13 active water wells100% Underground water sources Diamond Level (March 2021)RP3 Award from APPAProcurementRenewable Power 65% RPSunderground miles 98 135 miles overhead233
Miles of Distribution Lineselectric utilityenergy producing, distribution -dependent, non-transmission Assets (NBV)Total Capital Revenues$14.0 million customersof water to 1,328 MGCustomers13,300
Water Assets (NBV)Total Capital Revenues$29.5 million customersMwh159 Customers14,200 Electric 4/7/2021-2020 Year End Financial Report 42/22/2022 DISTRICT UTILITIES OVERVIEWDISTRICT
UTILITIES OVERVIEW INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 52/22/2022 2020 Budget Overview2020 Budget Overview INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 62/22/2022 2020 Budget Overview2020 Budget Overview INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 72/22/2022 2020 Budget Overview2020 Budget Overview INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 82/22/2022 2020 Budget Overview2020 Budget Overview INFORMATION
INFORMATION NA$ 2,108$ 2,108$ 0NET BASIC CASH FLOW8%29352381IncomeInvestmentNA in reservesmore(3,520)(890)2,630USE (ADD)all other net Reserve Funds 47%3,563(3,212)(6,775)Capital Expenditures0%01,4
001,400AB32 Reserve Funds use0%0(621)(621)ServiceDebt70%2,0945,0792,985NETOperating4%979(22,948)(23,927)ExpensesOperating4%1,115$ 28,027$ 26,912 Operating RevenuePercentage-Variance
to Budget Amount-Variance to Budget ACTUALBUDGET thousands$ELECTRIC 4/7/2021-2020 Year End Financial Report 92/22/2022 Cash Flow Items–2020 Actual versus Budget Summary Cash Flow Items–2020
Actual versus Budget Summary INFORMATION
INFORMATION 2020 for 2019 activity.increased pole replacement activity in 2020 and billings in JPA Pole Contacts revenue of $597K, up $418K or 233%; June-Commercial down 1%, pandemic
impact in Aprdriven by pandemic.half of the year due primarily to increase in occupancy nd 2Jun, more than offset by increased energy use -dip in Aprenergy demand, slight to Residential
up 6% to Budget due Budgetto 4.1% Total Revenue up favorably Dollars in Thousands 2020 Actual2020 Budget var to BudgetOperating Revenues 30,000 25,000 20,000 15,000 10,000 5,000 -28,027
1,115 26,912 4/7/2021-2020 Year End Financial Report 102/22/2022 Operating Revenues-ELECTRIC Operating Revenues-ELECTRIC INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 112/22/2022 Operating Expenses–ELECTRIC Operating Expenses–ELECTRIC informationRefer to Purchased Power agenda topic for additional
•relief funds.coviddollars for new costs, reallocated from Conservation budget to provide Includes absorbing incremental $150,000 in Stampede power •purchased | 13% favorable costMWh1%
increase in •$1,501,987 or 12% favorable to Budget•$11,285,537 Purchased Power•INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 122/22/2022 Operating Expenses–ELECTRIC Operating Expenses–ELECTRIC by the increase in Payroll Direct costs9%, driven primarily or
$299,000 was over budget 3.6m of $Overhead •ratification in Jan’2020Budget expectation of 3% and $41,000 in bonus payments with MOU turnover costs, due to approved rate of pay increases
greater than when excludingroll Direct of $3.5m was over budget $161,000 or 6% Pay•2020 Budget $1,000,000 2020 Actual $1,391,963•effortsto Wildfire Mitigation 500,000 $Added •the
additional Wildfire costs%, despite under budget $144,000 or 3were Vendor expenses of $4.5m •Budgetto 5% unfavorable or $522,363 •(excluding Purchased Power)$11,662,230 all other operating
expenses •INFORMATION
INFORMATION efforts not reflected on MapNov/Dec secondary wire trim projects13 crane required tree removal 47 Joint Pole projects175/86% action taken204 hazard tree service orders, 4/7/2021-2020
Year End Financial Report 132/22/2022 2020 Wildfire Mitigation Efforts (red planned, green completed)2020 Wildfire Mitigation Efforts (red planned, green completed)INFORMATION
INFORMATION NA96$ 96$ 0NET BASIC CASH FLOW27%27127100IncomeInvestmentNA more in reserves(138)228366USE (ADD)all other net Reserve Funds 4%90(2,323)(2,413)Capital Expenditures0%0899899and
DL Surcharge0%0(3,243)(3,243)ServiceDebt3%1174,4084,291NETOperating%193(9,599)(9,506)ExpensesOperating2%210$ 14,007$ 13,797Operating RevenuePercentage-Variance to Budget Amount-Variance
to Budget ACTUALBUDGET thousands$WATER 4/7/2021-2020 Year End Financial Report 142/22/2022 Cash Flow Items–2020 Actual versus Budget Summary Cash Flow Items–2020 Actual versus Budget
Summary INFORMATION
INFORMATION Commercial up 5% (12% of revenue Mix)Residential up 1% to BudgetBudgetto 1.5% Total Revenue up favorably Dollars in Thousands 2020 Actual2020 Budget var to BudgetOperating
Revenues 16,000 14,000 12,000 10,000 8,000 6,000 4,000 2,000 -14,007 210 13,797 4/7/2021-2020 Year End Financial Report 152/22/2022 Operating Revenues-WATER Operating Revenues-WATER
INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 162/22/2022 Operating Expenses–WATER Operating Expenses–WATER 507,000 was on Budget$Water Rent Expense to Electric of •variety of
factors7%, driven by a or $168,000 budget under was $2.3m of Overhead •Jan’2020MOU ratification in portion with % and $30,000 in bonus payments water 3Budget expectation of , due to
approved rate of pay increases greater than turnover costsexcluding roll Direct of $2.7m was over budget $124,000 or 6%, Pay•2%or $67,000 under budget 4.1m were Vendor expenses of $•Budgetto
1% unfavorable or $93,071 •$9,598,55 operating expense•INFORMATION
INFORMATION na/ 2,204 na/ 96 na/ 2,108 2,204962,108NET BASIC CASH FLOW2 / 0%27 / 27%29 / 8%479127352IncomeInvestment more in reserves 3,658 -more in reserves 138 -more in reserves 3,520
-2371,127890-TO.ADD-FROM.USE all other net Reserve Funds 3,653 / 40%%/ 4903,563 / 47%5,535-2,323-3,212-Capital Expenditures0 / 0%%/ 000 / 0%1,4001,400for Horse Butte-AB32 Reserve
Funds0 / 0%%/ 000 / 0%3,864-3,243-621-ServiceDebt2,211 / 3%%/ 31172,094 / 70%9,4874,4085,079NETOperating886 / 3%%/ 193979 / 4%32,546-9,598-22,948-ExpensesOperating1,325 / 3%2%/ 2101,115
/ 4%42,03414,00728,027Operating RevenueBudgetTotal Variance to BudgetWaterBudgetElectricTotalWaterElectricthousands$4/7/2021-2020 Year End Financial Report 172/22/2022 Cash Flow Items–2020
Actual versus Budget Summary Cash Flow Items–2020 Actual versus Budget Summary INFORMATION
MS2
Slide 17
MS2 informational 1pager , not go go over in presentation
Michael Salmon, 3/17/2021
INFORMATION ELECTRIC PandemicQ2 due to the cautiously paused in Capital Expenditure be expended.by BOD for amount to projects are approved Budget, >$15k not in Approved a project timing
is If Approved Budget. planned amount in 2020 Budget is the $ 3,563$ 3,212$ 6,775Total-Electric246334580OPOtherAll4450445VRElectric–Vehicle Replacements404222626OPElectric-IT Projects
448485933OPLine ExtensionsDistribution Repl. &673289962OPElectric SCADA4500450BRAsphalt/Drainage for Back 40District Building Paint and 172378550BRWarehouse Lighting ProjectsRemodel,
Elevator and Upstairs534436970FFTruckee Substation Control(267)672405OP(EMP)Muh.Rebuild-ChamNorthwoods3000300OP$100K MV Subs., $50K Glenshire Subs.-c Master Plan(EMP)Electri$ 158$396$
554OPPole Change OutsVariance Actual2020Budget2020 ELECTRICCAPITAL 4/7/2021-2020 Year End Financial Report 182/22/2022 CAPITAL EXPENDITURESCAPITAL EXPENDITURES INFORMATION
INFORMATION PandemicQ2 due to the cautiously paused in Capital Expenditure be expended.by BOD for amount to projects are approved Budget, >$15k not in Approved a project timing is If
Approved Budget. planned amount in 2020 Budget is the WATER$ 90$ 2,323$ 2,413Total-Water(51)510OPOtherAll13822160VRWater–Vehicle Replacements(36)180144OPWater–IT Projects(651)651OP)yrs(timing
b/w Water Meters/MTUs(28)28OP.ReplcMartis Woods41041OPWell #1 Rehab.Southside(18)6143OP.ReplacmWater Production Meter 60060OPWell RehabilitationFiberboard1020102OPGlenshire Drive Discharge
Assembly1140114OPWater8025105OPValve RehabilitationControl(119)764645OP.(timing b/w years)ReplcWater SCADA$ 458$ 541$ 999OPFacilities Metering ImprovementsVariance Actual2020Budget2020
WaterCAPITAL 4/7/2021-2020 Year End Financial Report 192/22/2022 CAPITAL EXPENDITURESCAPITAL EXPENDITURES INFORMATION
INFORMATION refunding opportunity st IE 1, 11/15/2025date on or after any 2015 COPs are callable on 60% Electric 40% WaterDebt Service Split: Sidefund 2625(23)48$155 | 4.6% | ends
Oct.2022‘2003 Dark Fiber Loan Electric 8014,111(692)4,803$12,733 | 2.34% | ends Jan.2026Water 2006 SRF Loan 306151(294)445 Ended Mar.2021$5,250 | 3.2% | 55 SDWLWater Prop 685664(667)1,331$3,2
66 | 1.54% | 2016 COPsWater 1,03711,260(565)11,845 4% | ends 2035–$14,580 | 2.0% 2015 COPsWater$ 1,035$ 1,578($ 978)$ 2,556$5,589 | 2.47% | ends Jun.2022Sidefund2016 CalPERS Interest+
Principal2020 Pmts.BalancePrincipal12/31/2020 PaymentsPrincipal2020BalancePrincipal12/31/2019 4/7/2021-2020 Year End Financial Report 202/22/2022 DISTRICT DEBT OBLIGATIONSDISTRICT
DEBT OBLIGATIONS INFORMATION
INFORMATION Debt Split: 60% Electric 40% WaterSidefund 4/7/2021-2020 Year End Financial Report 212/22/2022 DEBT SERVICE DEBT SERVICE INFORMATION
INFORMATION 22 4/7/2021-2020 Year End Financial Report 2/22/2022 charging. POB debt service instead of UAL Payment annually.is CalPERSResearching Pension Obligation Bonds (POB) option,
which has potential savings to the 7% •$909,000-2021 $655,000-2019 1,044,000–$795,000 2022 -2020 $526,000-2018 annual–UAL Payment CalPERS•Of the UAL, 99% of balance is Classic,
1% PEPRA•Pension Unfunded Actuarial Liability (UAL) 6/30/2019 $14.1 million, 75% Funded•off of this loan in 2021 instead of through maturity in 2026, ~200,000 savings-Researching early
pay•term investment $1.7m in March 2021-maturity of long–Water SRF Loan •Facility Fees balance is $1.8 million•There is no Capital Reserve Fund for Water•Budget 2021 is $2.0m expenditureYear
CIP Plan averages $7m per year in capital expenditures, whereas Budget 2020 was $2.4m and -10•2.72-2.41 2020 -1.25. 2019 Requirement is COP DS Coverage •Water Debt Service obligation
drops by $1m in 2022, from 3.1m to 2.1m•Electric has a very small amount of Debt Service obligation and none after 2023•DEBT SERVICE COMMENTS DEBT SERVICE COMMENTS INFORMATION
INFORMATION plan assumptions (2.75% per year)District’s control) and compensation increases above performance of investments (impacts out of the -Due to PERS assumption changes and under-a
growth rate of 15.1% CAGR \[2020 71% Funded\]–has grown from $6.945M in 2014 to $14.023M in 2019 Miscellaneous Plan (Classic) -UALCaLPERSDistrict’s payment is ~$15,000 per yearUAL
Pension (PEPRA) $1,071,000–2022 $ 909,000-2021 $ 795,000-2020 $ 655,000-2019 $ 526,000-2018 UAL Contribution amount:) Pension (Classic6yr CAGR 9%$1.6m 1yr change 12% -6/20/2020
-$1.4m-6/30/2019 -$0.9m -6/30/2014 -the year ending:Pension Contributions, District, for = 14.0m Net Pension Liability(43.6m) Fiduciary Net Position$57.6m Total Pension Liability$14.0m
1yr change 8.9% 6yr CAGR 14.5%-6/20/2020 -$12.9m-6/30/2019 -$6.2m -6/30/2014 -Net Pension Liability, as of:4/7/2021-2020 Year End Financial Report 232/22/2022 PENSIONPENSION
INFORMATION
INFORMATION by the Districthigher pension payments equate to higher UAL and CalPERSLower 5.5% 30yr 8.0%yr20 8.5% yr5yr 6.3% 10 20:-returns through 2019returns. Average rate of
funded by investment pension benefits are CaLPERS2020: 55% of earnings is greater than the POB interest rate.CalPERSPV Savings as long as savings, and % funded statusPOBs increase
budget predictability, cash flow interest charge on UAL.CalPERSdown 7% POBs are essentially borrowing at ~4.5% to pay Discount Rate.CalPERSstructure and generate savings to the 7% potential
solution to normalize payment Pension Obligation Bonds (POBs) is one Refunding a portion of the UAL by issuance of 4/7/2021-2020 Year End Financial Report 242/22/2022 PENSIONPENSION
INFORMATION
INFORMATION 4/7/2021-2020 Year End Financial Report 252/22/2022 CUSTOMER ACCOUNTS RECEIVABLECUSTOMER ACCOUNTS RECEIVABLE INFORMATION
INFORMATION$37,000-12/31/2020 $13,000-12/31/2019 YE Allowance for Bad Debt:4/7/2021-2020 Year End Financial Report 262/22/2022 CUSTOMER ACCOUNTS RECEIVABLECUSTOMER ACCOUNTS RECEIVABLE
INFORMATION
INFORMATION assistance, outcome TBDspecific financial -There are multiple active Legislation bills for utility-Board approved (4/2020) up to $330,000-319 customers, $98,634-Total Pandemic
to Date -33 customers, $13,875–2021 YTD -286 customers, $84,759–2020 -pandemic loss of income:Bill credits provided to primary residential customers showing evidence of 4/7/2021-2020
Year End Financial Report 272/22/2022 CUSTOMER PANDEMIC RELIEF–CUSTOMER ACCOUNTS RECEIVABLE CUSTOMER PANDEMIC RELIEF–CUSTOMER ACCOUNTS RECEIVABLE INFORMATION
INFORMATION related to Debt Service or otherTo left reserves exclude Restricted Reserves $1,618,447to Operating General Fund Water District Code. Recommend transfer the DSC is not defined
in current General Fund Operating Reserve, Water DSC Operating Reserve to b)investment income (no withdrawals)increased funding other than increased last few years with no purchased
power costs have Fund Operating to Rate Reserve; $490,000 from General -Electric a)2021:Recommended Reserve transfers in definitionElectric Goal Discuss ($2,954)$ 7,962$ 5,008Total($2,581)$
27,869$ 25,288nananaAB322071,4001,607nanana(456)6,3945,938(694)800106LiabilitiesDeferred 862,0002,08617325198Vehicle223403626(2,384)2,3840Capital(2,071)5,7083,6371,618 Not in 1,618OperatingDSCnanana
($1,667)$ 4,753$ 3,086(Operating)Fund General570)($$ 11,964$ 11,394VarianceGoalBalance12/31/2020VarianceGoalBalance12/31/2020 WATER thousands ELECTRIC 28 4/7/2021-2020 Year End Financial
Report 2/22/2022 RESERVESRESERVES INFORMATION
INFORMATION 2.8MBudget $2.3M Forecast $–Pension costs . dmore than 100% offset (+20%/$35k) if vacancies run through June of 2021.Vacancy of positions in 2021, particularly Water Director
and IT Director, will offset above fully, with .% variance, equates to approximately $165,000 in gross wages and $230,000 including Overheads2.0Actual 2020 ~6.0% + Actual 2021 2.0%
= 8.0%Budget 2020 3.0% + Budget 2021 3.0% = 6.0%Budget versus Actual 2020 & 2021, impact on 2021–Rate of pay changes . cannual cost* Conservative, based on 2020 trend; subject to numerous
variables and very early in year to forecast Budget $12.9m Forecast* $12.5m –Purchased Power –Electric .bBudget 1.0m Forecast Need of $1.5m–Wildfire mitigation -Electric .a:BudgetApproved2021the
tovariancespresentwhichmattersfinancialnotablefollowingtheidentifiedhavewe,2019offalllateinBudget2021theapprovedDistricttheSince.Budgettoperformance2020addressesfarthuspresentationofmajorityThe
4/7/2021-2020 Year End Financial Report 292/22/2022 NOTABLE FINANCIAL MATTERS–NOTABLE FINANCIAL MATTERS–INFORMATION
INFORMATION discussion item at a future Board meetingBoard Personnel Changes incremental to 2021 Budget that will be Board approved/acted on in 2021; a .kincremental efforts on Initiatives
are not in 2021 Budget–Strategic Plan .jUtility Physical Security Plan $39,000, a new regulatory requirement in Electric.ipayment assistance, bad debt. $TBDcovid–Pandemic . h~$130,000
/ 10 years = $13,000 per year expense-Town of Truckee Fueling Station g2. LAIF/PCIF-non–other investments Staff to recommend in May the addition of Investment Broker to enable investment
in )Budget $492,000 Forecast $402,000, shortfall of $90,000 (electric–Income Investment g. $16,000–Employee Housing JPA . fof $770,000, primarily for capital expenditures funding of
capital improvement plan2021 approximate incremental funding in –2021 Rate increase of 3% Budget, 9% Approved –Water . e 4/7/2021-2020 Year End Financial Report 302/22/2022 NOTABLE
FINANCIAL MATTERS–NOTABLE FINANCIAL MATTERS–INFORMATION
INFORMATION May Staff is actively planning 2021 Capital Expenditures, and recommend a subject Board Workshop in 1.236MReplacement 2021 Project for a total of $Water Forecast of $3.1M
compares to Rate Study total of $3.0M in fall 2020, and includes District Pipeline 150kestimated $2.0M and Upgrade Electrical Panel for Main Building (to support Remodel) at estimated
$Electric Forecast includes Building Projects, which is primarily comprised of Main Building Remodel at ForecastAbove includes IT project split proportionately between E/W of $794,000
Budget and Budget 2021 $2,009,000 Forecast $3,100,000–Water Budget 2021 $6,505,000 Forecast $6,505,000-Electric 2021–L. Capital 4/7/2021-2020 Year End Financial Report 312/22/2022
NOTABLE FINANCIAL MATTERS–NOTABLE FINANCIAL MATTERS–INFORMATION
INFORMATION 2-2 Nov-1 Oct-18/19 cycle, 5 meetings: Sep1-2 Nov-1 Oct-1 Sep-Augmeetings: 20/21 cycle, 5 1-1 Nov-1 Oct-1 Sep-Above
draft cycle 4 meetings: AugBudget Approval-Public Hearing/Action •Nov Public Hearing Notice••Oct•Sep•Aug Strategic Planning•Staff Planning•Jul Strategic Planning•Staff Planning•May
June 32 4/7/2021-2020 Year End Financial Report 2/22/2022 TENTATIVE DRAFT-FY 2022 and FY 2023 BUDGET TIMELINE TENTATIVE DRAFT-FY 2022 and FY 2023 BUDGET TIMELINE INFORMATION
FISCAL IMPACT 4/7/2021-2020 Year End Financial Report 332/22/2022 FISCAL IMPACTFISCAL IMPACT required.staff’s review of District Code, however the transfers are not The recommended transfer
of funds is recommended, based on •2020 financial performance of the District.There is no direct financial impact related to this report on the •FISCAL IMPACT
RECOMMENDATION 4/7/2021-2020 Year End Financial Report 342/22/2022 RECOMMENDATIONRECOMMENDATIONthe DSC Operating Reserve Accounts going forward12/31/2020 plus investment income year
to date 2021) and cease utilizing Water General Fund Operating Reserve ($1,618,447 balance as of All amounts in the Water DSC Operating Reserve accounts to the –2b $490,000 from Electric
General Fund to Electric Rate Reserve–2a Authorize the following fund transfers between reserve accounts:2.by independent auditors, Moss AdamsAccept this report, subject to completion
of standard annual financial audit 1.RECOMMENDATION