[PPT] - Benton PUD credit Exposure by sector as of January gt, zotg I Bank PowerPoint Presentation

SLIDE 1

Benton PUD credit Exposure by sector as of January gt, zotg

I Bank 57,660

r IOU Affiliat e$L7,7!.6

. RTo SO

r lntegrated Oil & Gas Companies $0

I Marketer/Merchant S2,673,838

tou s90,780

r Muni/Coop 5360,942

tTo/o

3% -L%

8s% Benton's total exposure (principal and agent) ¡s 53,150,937

SLIDE 2

Benton PUD credit Exposure by sector as of December 31, 2018

I Bank s324,O52

tou s47,646

r Marketer/Merchant S1,464,555

RTO so

I lntegrated Oil & Gas Companies 582,893

r IOU Affiliate 566,620 r Muni/Coop 5324,964

t4%

L4% 4% 2% 3%

63% Benton's total exposure (principal and agent) ¡s S2,3L0,729

SLIDE 3 I

j

-Iit ^---

EnergyA.irf lror ity

American Electr¡c Power Serv¡ce Corporat¡on

WSPP 525,0ft0 Ar¡zona Public Service Company WSPP

4250,000 Av¡sta Corporat¡on

WSPP BP Energy Company ISDA WSPP

€it¡group Energy lnc,

|SDA ø Pwr Anx WSPP

c¡ty of Seattle, by and through its City L¡ght Dept 2,250,000

WSPP Clatskanie People's Utility Distr¡ct

L,265,625

WSPP CP Energy Marketing (USl lnc. WSPP EDF Trading North America, LLC ISDA w/ PwrAnx Emerald People's Ut¡l¡ty D¡strict Transm¡ssion 2,2sO,OOO Eugene Water & Electr¡c Eoard WSPP 2,250,000 Exelon Generat¡on Company, ILC ISDA WSPP Fort¡sBC Energy lnc. Gas EDI

450,000

Credit Exposure Report: Public Utility District No. 1 of Benton County, Washington

as ofJan 31,2019 525,000 s25,000 525,000

too% 2,250,000

2,250,000 2,250,000 r00% 562,500 562,500 562,500 ¿900,000 2,900,000 2,900,000 2,250,ON 2,250,000 2,250,000 2,250,000 2,250,o00 t,265,625 L,265,625 2,000,000 2,000,000 2,250,000 2,250,000 ¿250,000 2,250,000 ¿250,000 2,250,000 ¿2s0,000 2,250,OW 2,250,000 450,000 450,000 562,500 2,917,240 2,917,240 5,181,009 4,752,443 L00% ¿900,000 2,250,000 lotoÁ !0lYo 230%

zrt%

101%

tot%

é7,2401 lr7,24Ol

(428,s671 (334,3081 (2,t68,t341 (2,931,0091

2,250,000 L00% !,265,625 100% 2,000,000

LOO%

2,000,æo 2,2s0,000 2,250,000 2,2s0,000 z,zto,588 98%

(82,0331 (28,6s41 1so,o99

39,472 2,250,000 100% 2,250,000

t00%

2,274,504 2,274,sO4

00 00 (28,504)

.28,5041 450,000

roo%

Page 1 of4

SLIDE 4

_ì I A __

Energy;: ,,;l i, .¡ cqÉËiútt

Grant County Pubtlc Utitity Oistrict wo. Z WSPP

Credit Exposure Report: Public Utility District No. 1 of Benton County, Washington

as of Jan 31,2019

l¡EeclIld C¡Ê*

2,25o,OOO

eeiliü

€¡lþþnl ,totwc

¿250,000 7,250,000 750,000 7s0,000 2,250,000 2,250,000 100,000 100,000 100,000

2"250,OOO 2,250,OOO 2.2s0,000

%Arü¡tþ lftd

thrùls¡,

ffl $!tl Aäûtb

ErDoúüt€

Îo,|il Ërgü¡re

(43,320) ldaho Falls Power WSPP 750,000 ldaho Power Company 2,250,000 WSPP lGl Resources, lnc.

Gas

J. Aron & Company LLC

WSPP Macquar¡e Enerty, LLC ISDA w/ Pwr Anx

Morgan Stanley Capital Group lnc.

ISDA WSPP

Northwestern Corporation d/b/a Northwestern Ene 56¿500

WSPP PacifiCorp Transmiss¡on WSPP

Portland General Electic Company 2250,OOO

WSPP Powerex Corp. ISDA NAË58 WSPP Publ¡c Seru¡ce Company of Colorado

1,423,t25

WSPP Publ¡c Util¡ty D¡strict No. 1 of Chelan County, Washin 2,250,000 2,250,000 100% 7s0,000 100v" 2,250,OOO L00% ]"43,320 L430/" (43,320) 1000/. 2,150,000 2,150,000

¿150,000

2,,150,000 2,250,000 2,250,O00 2"2s0,000 562,500 562,500

¿2s0,000 2,250,000 2,2s0,000 2"2s0,000 2,250,000 4100,000 2,100,000 2,100,000 2,100,000 L,42t,L25 t,423,I25 2,250,000 2,250,000

2,2sO,O00

2,241,4t9 2,718,677 2",283,72r 2,250,000 2,250,000 3,037,279 3,776,770 3,037,279

t04% 1307,3781 (15,s16) 23r,474

(91,4191

t87,763

1468,6771.

(r,076,7701 2,250,000

Izt% L0t%

t00% 700% r45% L5t% I45%

(43s,ss6) (220,8841

2,250,000 562,s00 rcg% 2,zso,000

LOO%

U

2,100,000 (139,4901 (937,2791 7,423,I25 t00% WSPP 2,250,000 t00%

Pege 2 of4

SLIDE 5

ì1

lL

__ I r_ ,/

.1, _^*_

EnergyÂrriir<rr rl v Cñrllþr?årtt

t,tl'eærql

MN â¡araüy Cebrol Îd

Publ¡c Ut¡l¡ty D¡strict No. 1 ofCla.k County, Wash¡ngt 2,250,000 WSPP Public Ut¡lity District No. 1 of Cowlitz County, Washir ¿250,000 WSPP Public Utility Distr¡ct No. 1 of Franklin County, Washi 2,25O,OOO Transm¡ss¡on WSPP Publ¡c Util¡ty D¡str¡ct No. I ofGrays Harbor County, ì/ 2,250,000

U

4250,O00 2,250,000 2,703,125 2,203,t25 2,203,725 2,203,725

2,250,OOO

¿250,000 2,250,000 1,500,000 2,250,000 2,250,000 1,650 000 1,650,000 1,6s0.000 2,250,000 2,250,000 100,000 100,000 1,6AA,750 1,688,750 Transm¡ss¡on

WSPP Power Transm¡ssion WSPP Public Ut¡l¡ty DisÍict No, 1of Kl¡ckirat County, Washi 2,2O3,LZ' Publ¡c Utility D¡str¡ct No. l of Lewis County, Wash¡ng Public Utility District No. 1 of Snohomish County WSPP Publ¡c Ut¡lity District No. 2 of pacific County, Washinl Public Utility D¡strict No. 3 of Mason County WSPP Puget Sound Energy lnc. NAESB WSPP Sacramento Munic¡pal Ut¡lity D¡strict WSPP Shell Energy North Amer¡ca (Canãdal, hc. NAESB Shell Energy North Amer¡ca (US), L.P. 2,250,OO0

2,250,000 1,s00,000

2,250,0OO 1,650,000 2,250,000 100,000

U

ISDA 1,688,750 1,688,750 LOO%

Page 3 of4

Credit Exposure Report: Public Utility District No. l- of Benton County, Washington

as ofJan 31,2019

ClgüT

Ac[rtþ %Avrñ¡l¡þ Eileú

Uñöüed

mil

lohl

2,250,000 2,250,000 2,250,O0O 2,250,000 2,250,000 2,250,O00 2,250,000 2,250,000 2,250,000 2,250,O00 2,250,000 2,250,000 2,203,125 2,203,r25 2,203,725 1,,733,200 1,650,000 2,250,000 t00% 2,250,000

t00%

Erfours

ËrOæul¡

U

t, 100% 7000/.

toî% !00%

100% tooo/o

LOQÔ/O

105% 1000/. 2,250,000 t00% 2,248,859 700%

U

6 (83,200) 1,135

L,I4L

(83,2001 2,250,O00 LOO% 100,000 L00%

SLIDE 6

TtA*-

EnergyAtrtlror it;r

WSPP Tacoma Power Transmiss¡on WSPP Tenaska Market¡nt Ventures NAESB Tenaska Power Serv¡cGs Company Transmission WSPP The €nergy Ar¡tho¡ity, tnc. Acct RMA Tr¿nsm¡ss¡on

Credit Exposure Report: Public Utility District No. 1of Benton County, Washington

as ofJan 31,2019 1,688,750 1,688,7s0

ttrJ%

2,2s0,00{, ¿250,o{xt 2,Z50,OOO 2,250,000 3,58L250 3,581,250 L,787,250 \1aL,Z5O

r,1ar,z50

4(Xnün

4,000,000 4,000,000 2,2s0,000 2,250,000 t,78L,250 L,78L250 1,903,235 1,903,235 L00%

too% 3,s8L250

1,800,000 3,581,250 100% L,7aL25O 100% 100%

4(xD,000

48% 48% 2,037,700 56,003 3,062 2,04o,762 56,003

Page 4 o1 4

SLIDE 7

frffirn#

,#.ü,fi

FINANCIAL STATEMENTS

December 20f 8

(Unaudited)

Table of Contents

Monthly Financial Highlights Statement of Revenues, Expenses and Changes in Net Assets

Current Month Year-to-Date 2018 Monthly Activity Gomparative Balance Sheet Energy Statistical Data Current Month Year-to-Date kWh Sales - Monthly Activity Plant Additions and Retirements Current Month Year-to-Date Statement of Cash Flows Weather Statistics

Broadband Summary

Paqe

6-7

12 13 14 15 16 2 3

4

5

I I

10-11

Payroll Report

17

SLIDE 8

PUBLIC UTILITY DISTRICT NO.l OF BENTON COUT{TY STATEMENT OF REVENUES, EXPEI.ISES, AND CHANGE ll{ NET POSITION DECEMBER 2018

12131t18 OPERATING REVENUES Energy Sales - Retail City Occupation Taxes Bad Debt Expense Energy Secondary Market Sales Transmission of Power for Others Broadband Revenue Other Revenue

TOTAL OPERATING REVEilUES OPERATING EXPENSES Purchased Power Purchased Transmission & Ancillary Services Conservation Program Total Power Supply Transmission Operation & Maintenance Distr¡bution Operation & Maintenance Broadband Expense Customer Accounting, Collection & lnformation Administrative & General Subtotal before NESC Compliance / Public Safety NESC Compliance (Net Distr¡ct Expense) Subtotal before Taxes & Deprec¡ation Taxes Depreciation & Amortization Total Other Operating Expenses TOTAL OPERAT¡NG EXPENSES

PERAT|NG TNCOME (LOSS)

NONOPERATING REVENUES & EXPENSES lnterest lncome Other lncome Other Expense lnterest Expense Debt DiscounvPremium Amortization & Loss on Defeased Debt MtM Gain(Loss) on lnvestments TOTAL NONOPERATING REVENUES & EXPENSES

It{coME (LOSS} BEFORE CAPITAL CONTRIBUTIONS

CAPITAL COT.¡TRIBUTION S CHANGE IN NET POSITION 3,088,183

_930,919_

>200o/o _å139{!9_

45o/o

10,549,187 566,480

(1 7,000)

s,601,279 140,619 194,603

'118,344 10,8s7,411 603,930

(2't,625) 9',t3,472 77,907 222,756 128,794 12t31t17

10,76 t ,334 546,427 (17,000)

1 ,883,103

127,805

181 ,951

(5r,853) 7,144,110 1,073,570 (104,988) 8,',t12,692 (401) 550,700 58,683 275,618 432,072 1,316,672 1,316,672 1,150,038 877,'t98 3,343,908 11,456,600 1,975,r67 61,016 30,626 (242,632) 38,'t27 2,323 (110,540) 't,864,627 265,413 17,153,512 't0,792,',t't0 1,003,508 (78,561) 6,846,768 1,040,894 (618,757)

3o/o
64/o
21%

>200o/o 80o/o

'l3o/o
8o/o

58%

4o/o
87o/o

61o/o

107o/o
102o/o
23o/o
66%
75%
85o/o

>200%

80o/o
60/o
3o/o
45o/o

20o/o >200o/o

2%

4% 0% 197%

10o/o 7o/o

n/a 51%

7%
25%

44o/o 1620/o

104o/o

14%

38o/o
67%
73o/o

nla

63%

4%

5o/o
25o/o

24% 48%

84o/o

>200% nla 6%

'100/o

nla

108o/"

57o/"

37%

12,782,611

31o/"

13,431,767 28a/o

1',t,7',t7 ,057

(1,04e) (21,766) 66,707 171,004 143,583 7,268,905 't4,562 1,265,861 86,210 496,585 571,409 358,478

, 133,161

2,434,629 39,920 491,639 198,894 832,273 2,474,549 't,275,036 859,260 2,522,807 4,608,845 14,239,864 2,913,648 1't1,976 97,280 (258,182) 34,318 23,018 11,877,750

90¡1,894 45,865

34,235 (203,069) 37,365

'144o/o 184o/o

n/a 27%

8%

nla

110o/o

8,409 (85,604) 2,922,057 166,126 819,290 110,710

>200o/o 500/ PAGE 3 UNAUDITED STATEMENTS

SLIDE 9

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY STATEMENT OF REVENUES, EXPENSES, AND CHANGE IN NET POSITION 2()I8 MONTHLY ACTIVITY

June May Apríl

July Augu$t Septeñbår Octobêr Nôvombèr Decèñbèr

Îðtãl

January Februâry

March OPERATING REVENUES Energy Sales - Retail City Oæupat¡on Taxes Bad Debt Expense Energy Secondary Market Sales Transm¡ss¡on of Power for Others Broadband Revenue Other Electric Revenue TOTALOPERATING REVENUES OPERATING EXPENSES Purchased Power Purchased Transm¡ssion & Anc¡llary Seruiæs Conservat¡on Program Total Power Supply Transm¡ssion Operation & Ma¡nlenance Distribution Operat¡on & Maintenanæ Broadband Expense Customer Account¡ng, Collection & lnformation Admin¡stretive & General Subtotal before NESC Compl¡ance / Public Safety NESC Compl¡anæ (Net D¡strict Expense) Subtotal before Taxes & Deprec¡ation Taxes Depreciation & Amort¡zat¡on Total Other Operating Expenses TOTAL OPERATING EXPENSES

PERAïtNG TNCOME (LOSS)

NONOPERATING REVENUES & EXPENSES lnterest lnæme Other lnæme Other Expense lnterest Expensê Debt Discount & Expense Amort¡zat¡on MtM Ga¡n/(Loss) on lnvestments Loss ¡n Joint Ventures/Special Assessments TOTAL NONOPERATING REV/EXP tNcoME (LOSS) BEFORE CAPTTAL CONTR|BUI|ONS CAPITAL CONTRIBUTIONS CHANGE IN NET POSITION

$1 0,476,299

645,'t12 (19,000) 2,013,000 't40,137 188,237 Âô3 ,153 6,997,524 1,110,171 q5 sqq 5,734 835,848 67,753 410,400 q51 ??R 2,293,672 1,346,727 RI? ÂAR 12,657,341 1,389,557 68,157 29,299 (23s,205) 34,127 (27,'t35\ 1,262,A00 293.142 $9,084,270 544,905 (16,000) 1,503,757

1 1 0,045

182,621 7ã C7) 6,825,520 I,101,369

u7.157\ 7,919 424,941 63,993 314,792 1,970,162

1,145,833 818.195 11,813,922 (333,3s2) 98,752,924 504,574

(1 ô,000)

1,475,128 179,821 181,682 qa 2ai 6,757,720 1,098,218 íq1 aqt 10,464 959,209 92,802 350,727 6'12.'150 2,O13,223

1 ,091,666

Ârn q61

1 1,973,1 30

(801,76r ) $8,953,009 454,944 (16,000) 936,75ô 126,440 182,760

1t) ãÃA

6,517,218 1,O79,128

(22.506\

4,347 850,510 63,941 317,544 1,771,953

13 5)4

1,904,474

1 ,033,1 68

Att ^to

11,238,102 (478,145) $10,539,816 411,604 (18,000) 446,462 105,247 186,099 12ñ 45,4 5,704,402 1,'142,4A6

153 376ì 9,881

888,766 74,O40 414,740 604.110 1,995,537

t1 r9Õ

2,016,427 1,061,970 417.290 10,689,599 1,142,127 $1 1,889,677 447,327 (20,000) 380,094 84,919 '187,642

{ rì¿ 55R

$14,145,140 44O,674

(22,OOO\

2,470,554 50,548 188,763 .13r)715. 9,478,135 1,200,382

t3))ã\

20,691 874,242 73,537 367,263 Â9n qql 2,O20,366 a5 340 2,'105,706 1,301,035 F.16244 14,898,316 2,546,O78 90,741 29,271 (242,363\ 38,127 1,875 (a? 34q\ 2,463,729 188.435 $12,602,782 562,260

(22,OOO).

1,758,'tO2 75.294 188,369 7a )11 9,475,076 1,240,286 a3 106 1ô,951 729.964 62,492 424,843 10¿ Âô^ 1,628,856 157 163 1,786,019 1,375,908

ala 7q5

14,779,190 458,828 123,'t56 32,619 (23O,701t 34,127 12,300

t)4 499\

434,329 9ô.285 $8,630,256

481,OO7 (1 7,000)

1j22,547 174,255

189,004 I 05 6AA 6,923,557 1,'193,131 t19A 970\ 10,523 755,333 76,678 351,s70 lAA 7q? 1,580,857 (â7 743\ 1,5't3,1't4 1,104,564 â26 56í r 1,361,957 (672,200], $8,91 9,989 412,470

(1 5,000)

2,O28,577 188,508 69 567 7,774,683 1,098,005 IA5 271\ 7,45'l 746,174

1 1 4,390

349,718 53" Arì3 l,750,536 156 61 1

1,907 ,'147 948,'168

a)4)o3

12,516,935 (820,42e\ $9,487,434 462,863

(1 5,ooo)

4,842,458 166,792 192,162 145 o32 9,272,750 1,082,786 124 334 59,467 712,871

1 05,363

444,583 577.424 1,899,712 (27 524\ 1,872 j8A 1,O't2,924 430 213 14,195,199 1,086,542 $10,549,187 $124,O30,782

566,480 5,974,2'17 (17,000) (213,000)

5,601,279 24,618,7'12

140,619 1,450,552 194,603 2,250,450 114344

1 756 986

14,046,938 11,480,570 11,'171,369 '10,759,957 11,a31,726 13,074,217 17,444,394 15,238,018 10,689,757 I1,696,506 15,281,741 17,153,512 159,868,700 8,2U3,294 7,879,732 8,047,290 7,473,A40 6,793,512 7,347,600 10,675,291 10,798,468 7,917.718 8,837,417 10,479,A70 11,717,057 106,171,091

z,¿oo

33,099 (236,o741 34,127 (1,038) 75,813 29,288 (235,677') 34,127 9,623 33,071 (243,898) 34,127 (8,405) 103,480 33,847 (232,861',) 34,127 18,258 r3q í¿q\ 1,102,97A 89.777 6,051,145 1,272,183 94 r7t

1 '1,533 / oJ,cóþ

71,294 350,499 qR) )^q 1,741,127 14 415, 't,795,542 1,192,'133 8't3.316 11,'148,591 1,925,626 86,775 2q 274 (232,æe) 34,127 (733) l7q 3c5ì 1,8/'6,23'l 76.290

98,1 97

35,818 (231,369) 34,127 (755) tsq 942ì (732,182\ 238.883 119,404 29,272 (229,O9O\ 38,127 8,940 (33 347\ (e53,776) 75.946 't13,140 34,763 (224,006\ 38,'t27 15,U3 (22 333\ 1,064,209 484.603 1'11,976

97,2AO

(258,182) 34,318 23,O18 2,922,059 .166,126 1,'t44,102 446,902 (2,832,267) 453,711 5l,590 7,620,553 2,124,OO0 '1o,792,110 't,003,508 r78 561 I (1,049) (21,766) 66,707 't71,OO3 144 543 491,639 1,198,894 432273

1 4,23S,863

2,913,649

358,478 20,954,343

133.161 719.367 92,569,842 13,621,653 (20.403\ 163,951 8,925,668 936,988 4,267,683 6 660 052 21,673,710 '13,812,993 9.854.390 151.512,185 8,356,515

2,273,073 1,868,499 2,O25,3s2

20 59C 101.664

(1) 129\

44540a7 3934 190 3925840 3764262 3896.087 3.800.991 4.223.025 3.980.722 3.444.239 3.679.518 3.715329 2.522.806 45,341,093 n26.757\ I103.ô20ì

tqt A)^\

t90.107)

(436,e72) (884,587) (568,252) a.410

(735.962\

'1 18.937 3'1.961

263.6't4

$1.555.942 r$318.035r l$852.626) t$304.638r $1.192.755 $1.922.521 $2.652.1ô4 S530.614 tM93.299) ($777.830) $1.548.812 $3.088.185 9,744,554

PAGE 5 UNAUDITED STATEMENTS

SLIDE 10

PUBLIC UTILITY DISTRICT NO. I OF BENTON COUNTY COMPARATIVE STATEMENT OF NET POSITION LIABILITIES AND DEFERRED INFLOWS OF RESOURCES LIABILITIES Wanants Outstanding Accounts Payable Customer Deposits Accrued Taxes Payâble Other Cunent & Accrued L¡ab¡litiês Accrued lnterest Payable Revenue Bonds, Cunent Portion Total Current Liab¡l¡ties NONCURRENT LIABILITIES 2010 Bond lssue

201 I Bond lssue 2016 Bond lssue Unamortized Premium & Discount Pens¡on L¡abllity Defened Revenue BPA Prepay lncentive Credit Other Liabilities

Tolal Noncurrênt L¡abillties Total Liabilities DEFERRED INFLOWS OF RESOURCES Unamortized Ga¡n on Defeased Deþt Pension Defened lnflow Accumulated lncrease in Fair Value of Hedg¡ng Derivatives Total Deferred lnflows of Resources NET POSITION Net lnvestmenl ln Capital Assets Restricled for Dêbt Serv¡ce Unrestricted Total Net Pos¡tion TOTAL NET POSITION, LIABILITIES AND DEFERRED INFLOWS OF RESOURCES CURRENT RATIO: (Current Assets / Current Liabilities) WORKING CAPITAL: (Current Assets less Current Liab¡lities) 1l ,460,839 2,035,979 3,666,006 2,783,539 461,914 3,750,000 9,922,995 1,667,840 3,652,729 1,569,510 491,664 3,570,000 $0 1,537,844 368,139 13,277 1,214,029 (29,750) r80,000 24,158,277 20,874,738

1 7,345,000

16,565,000 19,425,000 4,336,311 9,884,887 473,595 I,733,533 2,685,029 3,283,539 16Vo (6,795,000) 3,045,000 (466,534) (3,032,326) 1,030,954 (r61,256) 2,551,021 17,345,000 9,770,000 22,470,000 3,869,778 6,852,561 1,504,549 1,572,277 5,236,050 68,620,2't4 72,448,355 t78.14',t1

5o/o
1olo

92,f75,491 31,212 2,930,226 2,539,134 93,323,093 1ò,38e 1,866,603

1,'140,955 3,205,398 12,823 1,063,623 1,398,1 79 5,500,572

74,961,846 1,107,865 57,829,865 3,025,947 2,4f 4,625

820/"

uA07,045

1,107,805 58,ô40,1 1 3 10,554,801 (810,248) r33,899,576 124,155,023

s,74,553

8o/o 5o/o

232.178.639 220,504,0ô3 11,674,576 3.30:1 56,527,292 PAGE 7

UNAUDITED STATEMENTS

3.75:1 s57,414,842

{$1,887,550)

3o/o

12t31t20.t7 lncrease(Decf€ase) Amount Perc€nt 12t31t2û14

SLIDE 11

PUBLIC UTILITY DISTRICT NO. I OF BENTON COUNTY ENERGY STATISTICAL DATA YEAR TO DATE

12t31t2018

1213112017

ENERGY SALES RETAIL - REVENUE Residential Small General Service Medium General Service Large Gene€l Service Large lndustrial Small lnigation Large lnigation Street L¡ghts Security Lights Unmetered Accounts B¡lled Revenues Before Taxes & Unb¡lled Revenue Unbilled Revenue Energy Sales Reteil Subtotal City Occupation Taxes Bad Debt Expênse (0.1€% ot retâ¡l sles) TOTAL SALES. REVENUE ENERGY SALES RETAIL . KWh Resident¡al Small General Serv¡ce Mêdium General Serv¡ce Large General Service Large lndustrial Small lnigation Large lnigation Street Lights Security Lights Unmetered Accounts TOTAL KWh BILLED NET POWER COST BPA Power Costs Slice Block Subtotal Other Power Purchases Frederickson Transmiss¡on Ancillary Conservation Program Gross Power Costs Less Secondary Market Sales-Energy Less Secondary Market Sales-Gas Less Transmission of Power for Olhers NET POWER COSTS NET POWER - KWh BPA Power Slice Block Subtotal Other Power Purchases Frederickson Gross Power k\/vh Less Secondary Market Sales Lêss Transm¡ssion Losses/lmbalance NET POWÊR. KWh COST PER MWh: (dollars, Gross Power Cost (average) Net Power Cost BPA Power Cost Secondary Market Sales AVERAGE ACTIVE SERVICE LOCATIONS: Residential Smâll General Sêrv¡ce Medium General Serv¡ce Large General Serv¡ce Large lndustrial Small lrigation Large lnigation Street L¡ghts Security Lights Unmetered Accounts TOTAL $124,330,782 125,00¡1,055

(300,000)

s124,030,782

124,704,055 5,974,217 6,059,000 AMW

697,107,108 79.6

711,413,915

124,864,377 14.3

125,408,261

183,124,A07 20.9

183,295,253

238,606,017 27.2

231,318,867

65,996,720 7.5

65,459,767 15,3't 1,533 1.7 14,646,887

409,298,945 46.7

406,203,968

2,537,281 0.3

2,530,204

1 ,027,609 0.1

1,088,180

2,974,868 0.3

3,031,134

1,740,849,265 198

59,461,050 9,187,800 12,994,708 15,053,200 3,438.2't8 1,O27,769 22,489,582 2rs,690 265,895 '198,870 $34,200,815 26,123,769 s34,560,346 25,914,558 62,861,290 9,341,570 12,932,746 't4,416,070 3,439,636 913,335 20,911,197 210,403 267,554 r94,801 $125,¡188,602 (600,000)

$ t24,888,602

6,141,835

(21 e,000)

___$139¡r_1d92_ 759,633,907 129,054,00ô

1 86,155,255

230,674,409 67,084,1 10 13,754,354 392,050,824 2,534,782 1,112,118 3,044,405

__lt9!r9g1I9_

$33,620,790 25.31 1.648 $58,932,438

1 0,993,954 1 3,098,ô21

1',t,209,072 1,996,101 544,381 $96,774,5ô7 (13,547,158) (99s,599) (r,284,535) $80,947,275 1,142,594,000 910.334.000 2,052,928,000 250,137,000 180,296,000 2,483,30f,000 (609,721,000) (26,100,000) 1,847,540,000 s38.97 s43.81 $28.71 922.22 60,642,323 9,244,866 13,O71,777 r4,769,503 3,440,903 979,641 22,175,O12 213,541 267,297 199,192

2o/o
'lo/o
'lo/o

2o/o Qo/o 5o/o 1o/o Oo/o

1o/o

Oo/o

1o/o

0o/o

1o/o
1o/o
9o/o
1%
5o/o
2o/o

Oo/o

4%

Oo/o 'l3o/o 8o/o 2o/o

'lo/o

2o/o

1olo
50o/o
1Yo
3o/o
11/o

$60,324,584 16,507,865 15,737,394 11,222,158 2,399,494 (20,403) AMW 81.2 14.3 20.9 26.4 7.5 1.7 46.4 0.3 0.1 0.3 199.1 AMW 132.3 102.4 234.7 34.2 21.7 290.6 (81.6) (3.6) 205.4 AMW 86.7 14.7 21.3 26.3 7.7

'1.ô 44.8

0.3 0.1 0.3 203.8 AMW 130.4 103.9

2U.4

28.6 20.6 283.5 (6e.ô) (3.0) 210.9

2o/o 3o/o 2o/o

50%

20o/o 0o/o 20o/o

104%

1Qo/o 18o/o

>200%

13o/o

1%
2o/o
1o/o
2o/o
12o/o
23o/o
4Yo
8o/o

14o/o

3o/o
2o/o

Oo/o Qo/o 3o/o 1o/o 5o/o 1o/o 0o/o

60/o
2o/o
%
1o/o

1o/o Oo/o 29o/o 28o/o 2o/o 60/o 1íYo 7o/o

6o/o

nla

22o/o

1%
3o/o

0o/o

2o/o
260/o
27o/o
6%
22o/o
60/o

0o/o 15o/o 0o/o 1o/o 20o/o

8o/o
3o/o
20k

3o/o

2o/o

11o/o 4o/o 0o/o

8%
2â/o

$60,474,904 '12,824,641 12,249,032 11,012,230 2,255,782 137,519

1

$106,171,092 (16,015,954) (8,ô02,761) 1,124,834,000 896,879,000 $98,954,108 (17,115,236) 1,159,271,201 896,879,785 AMW 128.4 102.4 2,021,713,0O0 220,164,000 138,924,000 2,056,f50,986 299,516,591 190,250,000 230.8 25.1 15.9 2,380,801 ,000 271.8

(558,160,000) (63.7)

2,545,917,577 (714,738,244) $44.59 $44.68 $29.84 $28.69 $38.87 $44.82 $29.41 $23.95

14o/o 2o/o 4o/o 29o/o 2o/o 0o/o 3o/o 1o/o

0%

20/o

2o/o

0%

3o/o
2o/o

1olo

43,870 4,977 782 160 557 430

I

1,943 44,550

4,972 803 162 5 546 437

1,888

372 378

-------h¡ji-

53,744

Page I

SLIDE 12 PUBTIC UilUTY OISTRICT NO. 1 OF BENTON COUNTY KWH SALES MONTHLY ACTIVITY N

lune May

July August Sèptembêr J¿lì!¿rv February March

Apnl Street Ughts

?ot4 z0r5

2076

20t7

2QL8

securlty l¡ghts 20t4 2015 2016 20L7 2018 229,425 22s,624 225,O24 zLt,349 zLL,046 103,678 Lt4,45L Lt3,273 100,963 85,Ltz 247,686 249,106 257,O45

25A,915 242,804 L44,328,006 133,037,008 L42,581,083 169,666,306

t44,683,688 229,425 225,624 224,87a zLL,Z53 zLL,337 103,678 tr4,40a 113,196 100,920 90,490 247,516 249,L06

257,O45 253,9r"5 254,873

t39,35L,728

119,751.,958

t2t,827,338

L48,622,7L2 119,563,310 229,5t5 225,624 224,87a zLr,Z53 zLL,?43 t03,420 LL4,O73 LL3,239 91,650 90,L44 247,5L6 249,L06 257,O45 253,7L5 2.55,?32 119,621.,60r.

rLo,!44,332

LO7,768,165

t25,87L,ßr

!2r,242,4L7 229,5r5 2?s,672 224,494 zLL,253

2tr3ro

103,377 113,696 113,180 91,545 89,927 247,516 248,9r9 257,O45 253,7L5 255,332 L32,966,557 130,700,305

L3932r,!67

115,839,710 1?'2,756,L63 225,O70 225,672 2!L,235 zLr,253 2!L,370 103,334 1L3,53L 101,382

9t,424

85,656 248,246 248,9L9 257,O45 253,7t5 245,684 156,510,614 149,509,655 ¡.52,658,059 142,450,672 156,2LO,t77 224,939 225,672 21L,187 21L,253

2Lt,3tO ro3,248

1.13,488 LOL,425 9L,134 84,9s3 248,246

248,9t9 257,O45 253,715 245,684 r90,932,770 207,957,270 185,130,994 19r,745,5t7 t87,7t4,77t 225,064 224,880 2Lr,187 21]-,253 ztL,3L0

LQ3,476 113,488 101,382

90,742 84,383 248,246 248,9r9 258,34t 253,7L5 245,6U 210,931,831 220,335,637 19t,997,4r3 2L5,480,429 2L2,098,72r 225,640 224,880 2u,L87 zLr,253 zLr,634 t!4,673 tL3,445 101,409 90,860 a4,206 249,LO6 254,930 2s9,637 253,7L5 245,745 L89,823,925 Lgs,2L2,205 L85,956,623 194,580,364 195,724,064 225,574 224,928

2tt,r87

21r,253 211,650 714,494 Lt3,402 101,366 90,850 83,941 249,tO6 254,845 259,637 2s?,7L5 245,945 143,575,799 142,367,t58 L37,070,775 L39,239,635 t37,602,515 225,5t4 225,024 2tL,t87 2Lt,238 2r1,640 L14,494 113,359 TOL,I94 90,827 83,334 249,tO6 255,749 254,365 253,7t5 245,945 120,458,98s 114,881,885 LO1,008,620 !r0,223,374 1o8,626,599 225,298 22s,024 zLL,349

ztt,t25

21t,640 tL4,4M 113,359 101,108 90,504 82,782 249,LO6

257,O45 254,365 253,926 245,945

LO ,869,238 98,467,807 97,479,643 ro7,o50,475 to1,295,oo7 225,586 725,024

zlr349

2t1.,046

2Lr,75t

L74,430 113,309 101,108 .90,659 82,68L 249,]106 257,O45 254,365 252,929 245,945 L28,011,343 12s,6s6,509 125,277,997 t24,327,545 r27,33L,833 2,720,505 2,7O3,648 2,589,142 2,s34,782 2,537,28L t,296,696 1,364,009 L,263,262 L,7L2,LLg t,o27,609 2,980,502 3,022,608 3,082,980 3,044,405 2,974,868 L,781,322,397 !,738,O2t,729 1,694,O77,877 1,785,098,170 L,740,849,265 Unmetered

20t4

20L5

20t6

2017 20L8 Total 2014 20L5 20L6 20t7 2018 PAGE 11

SLIDE 13

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY CAPITAL ADDITIONS AND RETIREMENTS YEARTO DATE

ADDITIONS RETIREÍIIIENTE

BALANCE 1?i31n018 EALANCE

1A3lt2017

INTANGIBLE PLANT: Organizations Franchises & Consents Miscellaneous & lntangible Plant TOTAL GENERATION PLANT: Land & Land Rights Structures & lmprovements Fuel Holders & Accessories Other Electr¡c Generation Accessory Electric Equipment M¡scellaneous Power Plant Equipment TOTAL TRANSMISSION PLANT: Land & Land Rights Clearing Land & Right Of Ways Transmission Station Equipment Towers & Fixtures Poles & Fixtures Overhead Conductor & Devices TOTAL DISTRIBUTION PLANT: Land & Land Rights Structures & lmprovements Station Equipment Poles, Towers & Fixtures Overhead Conductor & Devices Underground Conduit Underground Conductor & Devices Line Transformers Services-Overhead Services-Underground Meters Security Lighting Street Lighting SCADA System TOTAL GENERAL PLANT: Land & Land Rights Structures & lmprovements lnformation Systems & Technology Transportation Equipment Stores Equipment Tools, Shop & Garage Equipment Laboratory Equipment Communication Equipment Broadband Equipment Miscellaneous Equipment Other Capitalized Costs TOTAL TOTAL ELECTRIC PLANT ACCOUNTS PLANT HELD FOR FUTURE USE CONSTRUCT¡ON WORK IN PROGRESS $28,379 10,022 29,078 $o $o $28,379 10,022 29,078

$67,479

67,479 1,141,911 1,141,911 770,459 770,459 1,912,370 1,912,370

156,400

25,544

832,047

256,175

4,805,562 192,890

4,998,452

3,933,872 116,185

4,050,057

10,009,600 309,075

10,318,675

1,724,870 295,502 39,953,634 20,332,146 13,124,843 35,430,647 45,792,475 30,227,694 2,824,284 19,863,334 9,957,318 866,250 760,352 2.437.476 38,057 815,679 1,391,503 938,637 2,239,744 2,824,669 1,835,795 115,990 789,609 454,852 13,711 21,380 33,203 (317,330) (166,ee4) (15,s4s) (123,276) (225,856) (6,055) (14,e36) (12,1971 (520) 1,762,927 295,502 40,769,313 21,406,319 13,896,486 37,654,846 48,493,868 31,837,633 2,934,219 20,638,007 10,412,170 867,764 781,212 2,470,679

223,590,82s 11,512,829 (882,709) 234,220,945

1,'t30,759

1,130,759

18,522,269 217,626

18,739,895

8,917,609 778,796

(408,113) 9,288,292

7,738,544 608,662

8,347,206

54,108

484,'198 3,041

487,239

489,135

2,436,522 99,041 (6,902) 2,528,661 20,695,799 961,291

21,657,090

1,141,835

11,845,428 165,860

(348,974\ 11,662,314 73,456,206 2,834,317 (763,989) 75,526,534

309,036,480 14,656,221 (1,646,698) 322,046,003

388,589

388,589

4,599,287 2,3',12,472

6,911,759

314,024,356 16,968,693

Amended TOTAL CAPITAL

PAGE 13

($1.646.698) $329.346.35r

SLIDE 14

rature

BO

70

OU

850 E40

r 30
^^
¿u

10

Jan Feb March April May June July Aug Sept Oct Nov

Dec

Normal a201A d2O17 '

Average Temperature

Year Jan Feb Merch

April Mav June July Aug Sept Oct Nov

Dec Annual Histor¡cal Avg 33.4 38.2 46.5 53.4 62.1 69.6 77.1 75.8 66.4

53. I

40.5

31.1 53.9 2018 37.7 38.6 45.8 53.8 68.7 69.8 80.6 76.4 65.4 52.4 39.6 36.2 55.4 2017 21.6 32.4 46.8 52.0 63.0 71 .1 80.4 79.4 67.6 51 .9 41.2 30.6 53.2 5-yr Avg 31.1 38.8 48.0 55.3 64.7 72.5 80.4 78.2 67.4 55.4 40.9 31.3 55.3

PUBLIC UTILITY DISTRICT NO. I OF BENTON COUNTY WEATHER STATISTICS December 31, 2018

Average Precipitation

Year Jan Feb March

April

May June

July Aug Sept Oct Nov

Dec Annual H¡storical Avg 0.94 0.70 0.57 0.55 0.51 0.51 0.23 0.18 0.31 0.49 0.95 1.20 7.14 2018

1 .10

0.35 0.35 1.25 0.81

.23

0.01 0.93 0.75 0.65 6.43 2017 1.43 1.78 0.79 0.98 0.37 0.23 0.06 0.29 0.72 1.45 0.50 8.60 5-yr Avg 0.82 0.74 0.77

.42

0.78 0.47 0.07 0.24 0-20 0.95 0.67 0.80 6.93

Each point on th¡s graph represents the tolal number of CDDS for ihe preced¡ng 3Gday period, i.e., the cumulative CDDS that are billed on November 15 occuned between October 15 - November 14.

Cooling Degree Days (CDDs) for Each Day of Billing Cycle

800 700 600 500 400 300 200 100

n

2017
2018
ô
5-Yr Avg

Jan Feb Mar Apr May Jun Jul Aug Sep

Oct

Nov Dec

Cooling Degree Days by Month

Year Jan Feb March

April

May June July Aug Sept Oct Nov Dec Total 2018

b 141 165 485 356 68 1,221 2017 77 203 475 445 147 1,347 5-yr Avg b 82 244 477 410 119 7 '1,345

Cumulative CDDs in Billing Gycle

201 I

19 1,997 4,305

9,442 15,375

6.1 63

550 37,851 2017 542 3,886 1't,414 15,181 9,561 1,173 4't,757 5-yr Avg 76

1 ,150

4,641 11,694 14,248 8,233 1,595 52

4 t ,689

Heating Degree Days (HDDs) for Each Day of Billing Cycle

g,

1,400

1,200 1,000 800 600 400 200

i

2017

,

2919

.

s-Yr Avg

Jan Feb Mar Apr May

Jun

Jul Aug Sep Oct Nov Dec

Year Jan Feb March

April

Mav June July Aug Sept Oct Nov Dec Totel

20't8 843 740 593 344 25 20 2 60 391 761 889 4,668 2017 1,347

912

565 386 137 t3 72 404

716 1,064 5,618

5-yr Avg

1,050 738 524 296

91 17

48 303 723 1,044 4,834

Cumulative HDDs in Bill

2018 31,408 20,959

24,003 14,655

5,',!41 729

219

11

569 7,040 16,205 27,404 148,343 2017 40,813 33,085 24,376 14,293 8,683 1,812 173 629 7,059 17.530 27,119 175,572

5-yr Avg

33J37 26,520

20,875 12,274 6.093 1.546 271 459 4,798 14,829 28,597 149,399

PAGE 15

SLIDE 15

f .r:¡.rrttd'

Lat.ra I uit

Payroll Report

Pa

Period December23,2018

* All Paid Leove includes personal leave, holidays, short-term dßability, L&1,

jury duty pay, and military leave pay. ** There vere no changes fi'om lhe original budget to lhe amended budget.

.,,r,p,4.0

Headcount D¡rectorate Department

¿v1ö Amended Budget** 2018 Actual

uver (unoeq Actual to Budget Executive Administration General Manager

Human Resources Communications & Governmental Affairs 4.00 3.75 2.00 3.00 3.75 2.00 (1.00)

Customer Programs & Services Customer Service

Key Accounts

r 5.00

3.00 15.00 3.00 Finance & Business Services Director of F¡nance Treasury & Risk Management Accounting Contracts & Purchasing 2.00 3.00 6.00 3.00 2.00 3.00 6.00 3.00 Engineering

. Engineering

Customer Engineering Power Management Energy Programs 6.00 9.50 5.00 5.00 6.00 9.00 5.00 5.00 (0.50) Operations Operations

Supt. Of Transmission & Distribution
Supi. of Operations

Meter Shop Transformer Shop Automotive Shop Warehouse Prosser Branch lT lnfrastructure lT Applications

Total Positions

6.00 32.00 2.00 5.00 6.00 4.00 7.00 4.00 7.00 11.00 6.00 29.00 2.00 5.00 6.00 4.00 7.00 4.00 7.00 11.00 (3.00)

151.25 í,4,e.75

{4.50}

Contin ent Posit¡ons

2018 Actual YTD 2018 % YTD to 12t23t2018 Position Summer lntern Student Worker lntern Department AssistanVLA Operations Engineering Warehouse IT Operations Prosser Branch Customer Service 2,134 467 757 283 350 1,087 124 69 2 2,080 SR On-Call/LA - Prosser On-Call - Kennewick 103% 90% 2,080 520 52% 110% 24 113 7

1O9Yo 7

T YTD Full Time 2018 Amended Budqet Original Labor Tvpe 2018 Budqet

YTD Actual % Spent

As of 1V31/2018 Regular Overiime $13,590,557 663.1 61

ç13,425,793 $13,21 9,153

813.161 789.675

98.5%

97.1o/" Less: Mutual Aid 7 trOvertime lAll Pa¡d Leave' ERegular

2018 Labor

100% 12t23t18

2.9n/o

7s%

50o/o 25o/o

98.2% Total

0o/o

Pay Period Ending YTD 2018 Annual 2017

PAGE 17

SLIDE 16

Deposit

Dollæ æDepos¡t Count

Electric Gredit & Collections Dashboard December 2018

7,600 7.400 7,200 7,000 6.800 6.600 6.400 6.200 6,000 5,800 5,600 5,400

$60.000 $s0.000 $40.000 $30.000 $20,000 $10,000 $0

D¡sconnects Disconnects - This graph presents the total number of accounts d¡sconnected by month for comparative years. Account Balances at Pre Collèct Depos¡t Summary - This graph presents the total depos¡t value and number of accounts with a

deposit. Excludes large inigator, power counterparties and broadband deposits, but ¡ncludes EIL

deposits that were collected beg¡nning in 201 8. Urgent Notices 9,000 8,000 7,000 6,000 5,000 4,000 3,000 2,000 1,000

+€-2016 +2017 -a-2018

Deposlt Summary

B
$1.800.000

$r.750.000 $1,700,000 $r,650,000 $1.ô00.000 $1.550.000 $1.500.000 $1.450.000 $1.400.000 $1.350,0o0 $1,300,000 $r,250.000

700 600 500 400 300 200 100

\ù \ts \ù .b ^6,€ \6 \6 \6 $ ¡ s \S \6 \$ 9(*9{ øu( 9d¡o{ 9"{ :o" ¡o{."V 9d¡9{ *,t{ 9c¡ø{ 4'{

Jan Feb ¡¡ar Apr May Jun Jul Aug Sep Oct Nov

Dec

*2016 +2017 *2018

a

Urgent Not¡ces - This graph presents the total number of urgent notices issued by month for comparative years. Urgent notices are sent to customers as a fnal request prior to oulbound IVR calls. Outbound IVR Calls - This graph represents the total number of outbound IVR €lls by month. IVR calls are sent to customers who have not made payment by the 35th day of the billing period. Outbound lnteractice Voice Response (lVR) Câlls

6,000 5,000 4,000 3,000 2,000 1,000

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nw

Dec

+2017 +2018

I

l

\a.27

I Accouht Balances at Pre Collect - This graph presènts the balânces tumed over to the collection agency by month for comparat¡ve years. Net write offs

$1 80,000

$160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $0

q-2016

.+"-2017 +2018

Jan Feb lvlar Apr May ¡n ùl Aug Sep Od Nov

Dec

Jan Feb ¡rer Apr l\4ây Jun Jul Aug Sep Oct Nov Dec Jan Feb lvar Apr lilay Jun Jul Aug Sep Oct Nov Dec

*Netwrite Offs - This graph presents nel wite offs by month for æmpaEt¡ve yeaß. Net write offs

are equal to gross write offs less collect¡on agèncy payments.

\

Y

\ //\l\ )É2€l..

^'.

I

-¿/

ô-"*"-'

t_*

SLIDE 17

Electric Credit & Collections Dashboard December 2018

Net Write Offs to Operat¡ng Revenue

0.80%

0.7QVo 0.6070

0.50% 0.40% 0.307o 0.20%

.10%

0.0070

A

v

/1

/ì t\,

I

\ù \ù \ù \6 \çr \çl \6 \6

\6

P( olê{ øø{ 9( "¡o{ øu{ 9s ço{ uø{

$ ^1 ,1 ,1r ,1S 1r g* ñg{ E{ g( ga{ aøv"

*Net Write-Offs to Operating Revenue - This graph presents the ratio of net write-offs to operating revenue (excluding Sales for Resale) for the cunent month and past 1 2 months. Write Off Comparison Collect¡on Agency Payments

$8,000 $7,000 $6,000 $5,000 $4,000 $3,000 $2,000 $1,000 $0

Collect¡on Agency Payments - This graph presents payments from the collection agency as a percent

f write offs for the current month and thê avêrage monthly gross payments for the past 12 months.

YTD Write Off Comparison $400,000 $350,000 $300,000 $250,000 $200,000 $1s0,000 $100,000 $s0,000 $o

600/o 500/o 4Oø/o 3Oo/o 2Oo/a

'to%

%

E

B
õ

È

rù ù rù ù'9'9'þ'9

$ \b \6 \6 $ $ ô (\ \s \s \$ \s

3>( vó' g" od 3>( *at ¡s\ od O( ra* g* oo* gc v-qt ;s* oo* O( *é g* oo-

$400,000 $350,000 $300,000 $250,000 $200,000

$ 1 50,000

$100,000 $50,000 $o

! Payments tr Net Write Offs

$77,272 $69,781 $6s,687

I

cY 2014 cY 2015 cY 2016 cY 2017

YTD 2018

cY 2014 cY 2015 cY 20í6 cY 2017 YTD 2018 Write Offs - This graph presents collect¡on agency payments and net write offs. The combined total of both stacks of the bar represents gross write offs.

¡^^.r'

/l l'

\...\ ¡^.À\

^ -\t ...'.ra {*\JJ

r/^f *\.-^^*7

Y

\*.lrii*/

+

Payments - Roìlíng Twelve l\ronth Average

+

/o Agency Payments to Gross Write Offs

$65,687

I

$67,785

969,78r

rPayments trNet \ rtite Offs

s77,272

*ln January 2018 approximately $170k was written off. The large write off was due to the delay in sending customers to collections during the conversion from Peoplesoft to NISC.