SLIDE 1
CWLP FINANCIAL PRESENTATION FY2021 Quarter 1 Financial Update
Data Through May 31, 2020
SLIDE 2 CASH SH P POSI SITI TION - MAY F FY202 021 1
El Electric F Fund nd Worki king C ng Cash: h: $ 45 m $ 45 million
: $ 28.6 million
: $ 16.4 million
- Up $12.1 million from May FY2020
- Days o
- f Cash
Cash: 93 93 da days ys
Moody’s ’s Days o
Cash: : 150 150 da days ys
- Includes Restricted ERIRF of $21.5M
ELECTRIC FUND - FINANCES
SLIDE 3
ELECTRIC FUND CASH BY MONTH
60 DAYS CASH = $29.1 MILLION
SLIDE 4
ELECTRIC FUND DAYS OF CASH
SLIDE 5 ELECTRIC FUND REVENUE BUDGET
THROUGH MAY FY2021
- Retail Electric Revenues
- Budget To Date
$ 41.5 million
$ 39.0 million
- Variance ($ 2.5 million) ~ (6.0%)
- Wholesale Electric Revenues
- Budget To Date
$ 6.0 million
$ 2.7 million
- Variance ($ 3.3 million) ~ (55%)
- Total Electric Operating Revenues are $6 Million or 12.4% Under Budget
SLIDE 6
ELECTRIC FUND REVENUE COMPARISON
SLIDE 7 ELECTRIC FUND EXPENSE BUDGET
NON-BOND EXPENSES THROUGH MAY FY2021
$ 56.8 million
$ 43.6 million
($ 13.2) million ~ (23.2%)
SLIDE 8
ELECTRIC FUND EXPENSE COMPARISON
SLIDE 9
ELECTRIC FUND DEBT COVERAGE RATIO HISTORY YEAR END
SLIDE 10 ELECTRIC FUND DEBT COVERAGE RATIO
AS S OF MAY F FY2021
Net et Reven enues es Availa ilable le F For Debt S Servic ice $11 $11,8 ,842, 42,67 674 Debt ebt S Ser ervi vice $9, $9,146, 46,006 006 Debt ebt S Ser ervi vice Co Cover erage (Year E End 1.25x .25x) 1.29x .29x Debt ebt S Ser ervi vice Co Cover erage (Incl cluding P PILOT) 1.06x .06x
* The quarterly calculation is for internal tracking
- nly. Debt Coverage Ratio is based upon a full 12
months.
SLIDE 11
ELECTRIC FUND DEBT COVERAGE RATIO BY MONTH WITH PILOT INCLUDED
SLIDE 12
ENVIRONMENTAL AND REGULATORY INITIATIVES AND REBATE FUND (ERIRF)
SLIDE 13 CASH P POS OSIT ITIO ION - MA MAY F FY2021
Water er F Fund W d Working C Cash sh: $5.4 5.4 milli illion
: $ 0.1 million
: $ 7.3 million
tric F Fund : ($ 2.0) m million
- Down $1.35 million from May FY2020
- Days of
s of cash sh: 83 83 days
s Days s of
Cash sh: 54 4 days
WATER FUND - FINANCES
SLIDE 14
WATER FUND CASH BY MONTH
60 DAYS CASH = $3.8 MILLION
SLIDE 15 WATER FUND DAYS OF CASH
*Prior to FY2017, built up high cash balances due to all planned rate increases being implemented while able to delay second bond issuance for Water Works Infrastructure Improvements Projects.
SLIDE 16 WATER FUND REVENUES AND EXPENSES
TH THROUGH MAY F MAY FY20 Y2021
ater R Reve venues
To Date Date $ 7.4 m millio llion
Actual T To Date Date $ 6.2 m millio llion
enue V ue Variance ($ 1.2) m millio llion n ~ (16.5%) %)
Wate ter N Non-Bond nd Ex Expens nses
dget et T To
$ $ 8.8 m 8.8 million
ual T To Da Date $ $ 6.8 m 6.8 million
xpense Var Variance ($ $ 2.0) 2.0) m million ~ ~ (22 22.6% 6%)
SLIDE 17
WATER FUND REVENUE COMPARISON
SLIDE 18
WATER FUND EXPENSE COMPARISON
SLIDE 19
WATER FUND DEBT COVERAGE RATIO HISTORY YEAR END
SLIDE 20 AS O OF F MA MAY F FY20 Y2021
WATER FUND DEBT COVERAGE RATIO
Net et Reven enues es Availa ilable le F For Debt ebt S Ser ervi vice $ 1 $ 1,865, ,865,94 942 Debt ebt S Ser ervi vice $ 1 $ 1,5 ,540, 40,010 Debt ebt S Ser ervi vice Co Cover erage (Y
(Year E End d 1.25x)
1.2 .21x 1x Debt ebt S Ser ervi vice Co Cover erage (After A
Auxil iliary y Service ces) s)
0.99x 0.99x
* The quarterly calculation is for internal tracking only. Debt Coverage Ratio is based upon a full 12 months.
SLIDE 21
WATER FUND DEBT COVERAGE RATIO BY MONTH AFTER AUXILIARY SERVICES
SLIDE 22 CWLP LABOR BUDGET
LABOR COSTS THROUGH MAY FY2021
(INCLUDING IMRF and FICA)
- Water Fund
- Budget To Date
$ 3.1 million
$ 2.8 million
$ 0.3 million ~ 9%
- Electric Fund
- Budget To Date
$ 12.5 million
$ 11.0 million
$ 1.5 million ~ 11.8%
- CWLP TOTAL LABOR COSTS ARE $1.8 MILLION OR 11.3% UNDER BUDGET
SLIDE 23 600 customers added to Level Pay or Payment Plan 1,700 eliminated past due or reduced bill to <$100 Total Past Due reduced by $817,000 Disconnections Suspended through July 31
- Additional notices (mail, web, online ads) of bill assistance
- ptions and payment plans; customer counseling.
Bill Assistance & Financial Resources
- LIHEAP applications reopen July 27
- CWLP.com For More Resources; helpillinoisfamilies.com
- myCWLP.com; 789-2030; cwlp.customer@cwlp.com
- Energy Services Office @CWLP.com or 789-2070
FINANCIAL ASSISTANCE-COVID 19
SLIDE 24
CWLP FINANCIAL PRESENTATION
Ques estio tions