BffiTOT FINANCIAL STATEMENTS November 2018 (llnaudited) Table of - - PDF document

SLIDE 1

BffiTOT

FINANCIAL STATEMENTS

November 2018

(llnaudited) Table of Contents Itllonthly Financial Highlights

Statement of Revenues, Expenses and Changes in Net Assets

Current Month Year-to-Date 2018 Monthly Activity

Comparative 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 2

u¡a

#.a.0

.*

*¿ffi;

.¡(sà&-{f .:.

• :-:5ê!t-

^ì

Is$ed.il¿: l2iSlilE

Financial llighlights

November 2018

Reta¡l Rêvenues

> Novembeis tempeÉture was 1 .3 degrees under the 5-year average and heat¡ng degree days

were '1 2olo above the five year average, retail revenues were 4 percent above budgèt estimates ¡n part to October be¡ng ælder than average.

> Retail revenues year to date are less thanl 7o under amendod budget amounts.

Net Power Expênsê

> Higherthannormalwatêrflow¡nthefirsthalfoftheyearresuttedinexcessgenerationând

¡ncreased secondary market sales, the second half has seen lower than nomal water flow but h¡gher power ând secondary market pr¡ces. Power and gas swaps netted the Distr¡ct about 9350k in November.

> The Sl¡ce True-up ¡s approx¡matety $660k > BPA announced the Sp¡ll Surcharge for 2018 which w¡ll result in an additional $200k ¡n power

expense

> Net Power Expense ¡s prcjec{ed to æme ¡n about $0.7M above amended þudget by the end of

the year Net Marg¡n/Net lncome

> Net mãrgìn and net ¡ncome are tracking about or above budget.

Cap¡tal

> Capitalexpendituresare$15Mofthe$lSMbudget.Actualexpend¡turesforyear€ndareexpectedto

underrun the budget.

O&i¡ Expense

> November's O&M expense was 1olo âbove budget > O&M Expense ¡s sl¡ghUy under the amended budget year to date primar¡ly as a result of labor bêing

under budget wh¡le increased jo¡nt use compl¡ance for publ¡c safety, and ¡nsurance assessment payments ¡s balanc¡ng the underrun.

Retail Revenues Net Power Expense

November Y'D

(¡erl(thder)

NoEmbèt

at{d! Po¡È. (ilÞq aRaÈ[&var¡Êr

lncome/Net Margin YTD Over/{Underl Budget+ 5963

¡lst lvbrgin

Nst (in thousandsf

Foctors afiecting Revenues

5% ú/o

NmmberHDD YTDHoD

Days &

• ver s-year
• æ/.

Ytt tEGlt t¡ün{rlbt

Bil¡ed toad Over/{Underl

¡lürèrùrr

Yto Price v.

t

Fdr:f.ors dÍlecting Net Power Expense Water Flow Projection % of Normal ¡an-Jut Runoff FoEGlt Sl¡ce Generation Over/(Under) Budgetr {in aMWl {0) (5) YTD

Nmmbot

L7% Market Sales Budget* ($) Nryâmbêt YTD Other Statisti6 Days Cash On Hand - Current Days Cash On Hand - Year-End Forecast* Debt Service Coverage - Year-End Forecest Fixed Charge Coverage - Year-End Forecast Active Seß¡ce Locat¡ons YTD lncrease in Active Seruice Locatlons New Seru¡ce Connections - November YTD lncrease in New seruice Connections iDependent upoñ cåpiÞl spendinS 138 3. 54073 65% s28 43% 6so/.

• &M

Cap¡taf (s¿000) Novembêt VTD WD

(3i,ro:¡

l,¡dembet

Snp

15.01M 4.53M 4.69M 2.39rvr 0.49M 1.07rM 0.51M 1.09M 0.24M O&M Expense before NESC Compliance and Capital the amended !07%

• o/o

0.2 1.2 0.8 7t% 80% 2A,ZOr8. the Commiss¡on on 0.4 0.6

úú.rüNliú&¡Ðlû nFefiú

qùrtlt0¡¡tl

2

SLIDE 3

PUBLIC UTILITY DISTRICT NO,I OF BE}ITON COUNTY STATEMEi¡T OF REVENUES, EXPENSES, AilD CHANGE IN NET POSITIOiT NOVEilIBER 20,t8 11t30t18 OPERATIi¡G REVEN¡UES Energy Sales - Retail City Occupation Taxes Bad Debt Expense Energy Secondary Market Sales Transmission of Power for Others Broadband Revenue Other Revenue TOTAL OPERATIi{G REVEiIUES OPERATIi¡G EXPET{SES Purchased Power Purchased Transmission & Ancillary Services Conservation Program Total Power Supply Transmission Operat¡on & Maintenance Distribution Operation & Maintenance Broadband Expense Customer Accounting, Collection & lnformation Administrative & General Subtotal before NESC Compliance / Public Safety NESC Compliance (Net District Expense) Subtotal beforê Taxes & Depreciation Taxes Depreciation & Amortization Total Other Operating Expenses TOTAL OPERATIT{G EXPENSES

• PERATING ¡i¡COfltE (LOSS)

Ì{OilOPERAÏilG REVET{UES & EXPET{SES

lnterest lncome Other lncome Other Expense lnterest Expense Debt DiscounUPremium Amortizat¡on & Loss on Defeased Debt MtM Gain/(Loss) on lnvestments TOTAL N¡OilOPERATING REVEÌ{UES & EXPEI{SES INGOME (LOSS) BEFORE CAPTTAL CO?{TR|BUT|OI{S CAPITAL COilTRIBUTIONS CHANGE IN NET POSITION

(¡199,375)

110,740

>-200o/o >200o/o

1

{388'6351 >-200o/o

9,487,434 462,863 (15,ooo) 4,842,458 166,792 192J62 145,032

9,1 53,146

477,459 (18,379) 1,057,860 77,907 195,492 128,794

4o/o '3o/o

• 18o/o

>20Ûo/o 114o/o

• 2o/o

13o/o

11t30t17 9,199,759 464,402 (15,000) 1,552,873 144,468 181,718 81,679

3o/o 0o/o

.0%

>200o/o

1 5o/o 60/o 78o/o

40%

1o/o

• 34o/o

>-200o/o >200o/o 15,281,711

9,272,750 1,082,786 125.233 6,464,956 1,037,375 220,104

43o/o 4o/o 434/o 364/o >2$0o/o

• 7o/o

7%

10o/o

• 2o/o

1o/o

• 169%
• 2o/o
• 1o/o
• 1o/o
• 2o/o

23o/o 147o/o 2o/o

nla 15%

2o/o

nla

• 71o/o

11,072,278 38%

11,609,899 32%

6,617,680 1,073,362

1 90,400

7,881,442 33a/o

59,467 712,871 105,363 443,684 577,428 1,898,812 (27,524) 10,480,770 7,722,436 't2,074 770,605 98,221 403,387 586,626 7,158 904,901 41,754 393,737 633,754 >200o/o

• 21o/o

152o/o 13o/o

• 9o/o

4o/o

nla

• 6o/o

1o/o

4o/o

• 3%

21%

>-200o/o

98%

11o/o

nla

• 5o/o
• 8o/o
• 149o/o
• 81%

1,870,914 39,920 1,981,304 1,871,289 1,012,928 830,213

1 ,910,834 1 ,021,743

839,802

1,981 ,304 1,003,974 861,943

3,714,429 3,772,380 3,847.221 l¿f,195,199 1,086,512 113,140 34,763 (224,006) 38,127 15,643 11,49¡r,8f 6

1122,537t,

45,865 34,235

(1 94,302)

37,365

>-2OOo/"

11,728,663 (118,764) 57,017 3't,346 (234,816) 41,348 ß2,080) 122,3311 (76,837) t137.185t 1,064,208 484,603 (255,949! 146,558

I

>-200%

PAGE 3 UNAUDITED STATEMENTS

ACTUAL ACTUAL AMENDED BUDGET PCT VAR PCT VAR

SLIDE 4

PUBLIC UTILITY DI$TRICT I{O.1 OF BENTOi¡ COUT{TY STATEMENT OF REVENUES, EXPEiISES, Ai¡D CHANGE IT{ NET POSITION YEAR TO DATE 11t30t't8 OPERATIi¡G REVENUES Energy Sales - Retail City Occupation Taxes Bad Debt Expense Energy Secondary Market Sales ïransmission of Power for Others Broadband Revenue Other Revenue TOTAL OPERATING REVEiIUES OPER^AÏN¡G EXPEI¡SES Purchased Power Purchased Transmission & Ancillary Services Conservation Program Total Power Supply ïransmission Operat¡on & Maintenance Distribution Operation & Maintenance Broadbarid Expense Customer Account¡ng, Collection & lnformation Adm¡nistrative & General Subtotal oefore ÑESC Comptiance / pubtic Safety NESC Compliance (Net District Expense) Subtotal before Taxes & Depreciat¡on Taxes DeÞrec¡at¡on & Amortization Total Other Operating Expenses TOTAL OPERATII¡G EXPEI{SES

• PERAT|t{c tr{coilE (Loss)

NOI{OPERATING REVENUES & EXPENSES lnterest lncome Other lncome Other Expense lnterest Expense Debt Discount/Premium Amortization & Loss on Defeased Debt MtM Gain/(Loss) on lnvestments TOTAL NONOPERAT¡NG REVEiIUES & EXPENSES

ili¡coME (LOSS) BEFORE CAP|TAL CONTRTBUTTONS

CAPITAL CONTRIBUTIOI¡S CHANGE IT{ T{ET POSITION TOTAL NET POSITIOi¡, BEGINÌIII{G OF YEAR TOTAL NET POSITION, END OF YEAR 113,481,595 5,407.738 (196,000) 19,017,433 1,309,932 2,055,847 't,638,642

't 13,846,645

5,455,070 (213,375) 16,201,764

1 ,108,823

2,107,568 1,469,709 114,127,256 5,595,409 (202,000) 12,659,652 1,156,731 1,982,548 1,390,787

0o/o

• 1o/o
• 8o/o

17o/o 'l8o/o

• 2%

11o/o

• 1o/o
• 3o/o
• 3o/o

50o/o 13o/o 4o/o 18ø/o

lo/" 112,715,188

81 ,777,731

12,618,145 59,524 139,976,205 78,701,809 '12,227,118 756,276 136,7r0,383 7s,880,902 12,131,603 650,269 88,662,774 199,821 9,248,647 786,004 3,459,479 6,749,525 20,443,476 20,443,476 12,868,856 9,300,377 42,612,709 131,275,183 5,43¡t,900 544,647 53't,447 (2,667,374) 454,833 (35,452) 4,263,001 1,725,229 5,988,230

1 16,035,853

122,024,083

2o/o 4o/o 3o/o '92o/o 3o/o 8o/o

4%

• 91o/o

7o/o

94,455,400 165,000 8,947,435 870,282 4,095,313 6,516,470 91,685,203 178,339 8,877,958 852,204 4,028,834

'7o/o 1o/o

2%

2o/o

4o/o

• 'lo/o

1 1o/o 0o/o

0%

• 2o/o
• 1o/o

2%

5o/o 37o/o 2o/o

nla

2o/o

1%

nla

• 260/o
• 17o/o
• 3o/o

11o/o 18o/o

• 3o/o

1o/o

nla

4o/o

• 2o/o
• 3o/o

0o/o 60/o

ïalo 90%

• 34o/o

nla

• 3o/o
• 8To
• 181o/o
• 360/o

10To 13o/o 11o/o

• 2Yo

4o/o 096 20,594,499 586,206

21,180,704 12,614,099 9,022,'t16 42,816,920 20,746,431 527,381 21,273,812 12,627,564 9,195,822 43,097,598 137,272,320 5,4¡f2,868 1,032,126 349,623 (2,574,085) 419,393 28,573 Í44.3711 131,782,801 5,193,404 754,135 341,835 (2,517,ô91) 416,345 {1.005.376t (1,171,899t 4,698,496 1,957,874 4,r88,028 1,505,r16

5,693,1¡14

12o/o 30o/o 17o/o 0o/o 0.1o/o

121.1 55,023

124,155,023 129,848,167

130.81 1,394

PAGE 4 UNAUDITED STATEMENTS

AClUAL

ACTU.AL AMENÐED BUDGET PCT VAR PCT VAR

SLIDE 5

PUBLIC UTILITY DISTRICT I{O, I OF BETITOII COUIITY STATETEIIT OF REVEXUES, EXPETISES, AT{D CHATIGE I]I ilET POSITIOI{ 2OI8 TOÍ{THLY ACTIVITY

OPERATING REVENUES Energy Sales - Retail City Occrpat¡on Taxes Bad Debt Expense Energy Secondary Market Sales Transmiss¡on of Power for Otheß Broadband Revenue Other Eleciric Revenue TOTALOPERATING REVENUES OPERATING EXPENSES Purchased Power Purchased Transmission & Ancillary Services Conservat¡on Program Total Power Supply Transmiss¡on Operation & Ma¡ntenance D¡stribution Operat¡on & Mâintenance BroadÞand Expense Customer Account¡ng, Collect¡on & lnformation Adminiskative & GeneEl Subtotal before NESC Compl¡ance / Pubtic Safety NESC Compllance (Net Districl Expense) Suþtotal before Taxes & Deprec¡al¡on

ïaxes

Deprec¡at¡on & Amortizâtion Total Other Operat¡ng Expenses TOTAL OPERATING EXPENSES

• PERATTNG TNCOME (LOSS)

NONOPERATNG REVENUES & EXPENSES lnterest lncome Other lncome Other Expense lnterest Expense Debt D¡sæunt & Expense Amortiation MtM Gairì/(Loss) on lnvesùnents Loss in Joint Ventures/Special Assessments TOTAL NONOPERATING REVIEXP rNcoME (LOSS) BEFORE CAP|TAL CONTRTBUTTONS CAPITAL CONTRIBUTIONS CHANGE IN NET POSITION

2,273,073 1,868,499 2,025,352 1 ,771 ,953

20,59s 1q1,664 (12,129) 136,521

14,046,938 11,r+80,570 11,171,369 10,759,957 11,831,726 13,074,217 17,444,394 15,238,018 10,689,757 11,696,506 15,2A1,741

$10,476,299 645,'t12 (19,000) 2,013,O00 140,137 188,237 603,153 6,997,524 1,110,17'l 95,599 5,734 835,848 67,753 410,400 953,338 2,293,672 1,346,727 813,688 12,657,381 1,389,557 68,157 29,299 (235,2o5) 34127 (27,135) $9,084,270 544,905 (16,000) 1,503,757 110,045 '182,621 70.972 6,825,520 'I ,101,369

(47,157\ 7,919 424,941 ô3,993 314,792 656.854 't,970,162 1,145,833 818,195 11,813,922 (333,352) 62,266 33,099 (236,O74) 34,127

f,038)

98,752p24 504,574 (16,000) 1,475,128 179,821 181,682 93.240 6,757,720 1,098,218 191,352 10,Æ4 959,209 92,æ2 350,727 612.150 2,O13,223 1,091,666 820,951 $8,953,009 454,944 (r6,000) 936,756 126,440 182,760

122.O4A $10,539,816 411,604 (18,000) 486,¡162 105,2A7 186,099 120.454

5,704Í02

1,142,486 (53.376) 9,881 888,766 78,UO 414,740 604.1 1 0 I,995,537 2',1,290 2,016,827 1,061,970 817,290 10,689,599

1j42j27

$r 1,889,677 447,327 (20,000) 380,094 84,919

187,U2 104.558 6,05r,145 1,272,183 24.272

t 1 ,533 765,536

71,294 350,499 5A2.265 1,741,127 14,415 1,795,*2 1,'t92,133 813,316

I 1,148,591 1,925,626 8ô,775 29,274 (232,838)

34J27 (733) 1,8/.6,231 76,?90 $14,145,140 44O,674 (22,Ooo) 2,470,554 50,548 188,763

'130 715 9,474,135 'I,200,382

ß.226\

20,691 878,2A2 73,537 367,263 680.5S3 2,020,366 85,340 2,105,706 1,301,035 816,284 14,898,316 2,546,074 90,74'l 29,271 (242,363) 34J27 1,875 2,463,729 188,435 $12,602,782 562,260

(22,úO) 1,754JO2 75,294

188,369

7A/1

9,475,076 1,240,286 83.106 1ô,951 729,964 62,492 424,A43 3S4 606 1,628,856

157j63

1 ,786,019 1,375,908 818.795 14,779,190 458,828 123,15ô 32,ô19 (23O,7O't) 34127 12,300

04.499\ 4U,329

96,285 s8.630.256 4A1,OO7 (17,ooo) 1,'122,&7 174,255 189,004 105 6AR 6,923,557 1,193,131 t198.970) 10,523 755,333 76,678 351,570 386 753 1,580,857 (67,743\ 1,s13,114 1,104,564 826.56.1 11 ,361 ,957 (672,2O0) $8,919,989 412,470 (f5,000) 2,O24,577 92,395 '188,508 âq 567 7,774,683 1,098,005 t34.803) 7,451 746,174 114,390 349,250 532 803 1.750.068 156,6't 1 1,906,679 948,168 824.203 12,5'16,935 (820,429',) $9,487,434 462,863 (15,000) 4,842,454 166,792 192¡.62 1¿.5 ñA' s1 13,481,596 5,407,740 (196,000) 19,017,435 '1,309,933 2,O55,847

I ã346¿t

142,715,193 81,777 ,730 12.61A.145 59.524 94,455,399 165,001 8,947,434 470,243 4,O95,312 6 516.47'l 20,594,501 58ô,20ô 21,180,707 12,614,',tæ 9.O22.116 42 A16923 '137,272,322 5,M2,871 '1,032,127 349,621 (2,574,O82',) 4'19,397 28,573 /.744.364\ 4,698,507 1,957,473

4,203,294 7 ,A79,732 I,U7,29O 7,473,840 6,793,512 7,347,600 10,675,291 10,798,/168 7,917,71A 8,837,885 10,480,769

6,517,21A 1,079,128

(22.506\

4347 850,510 63,941 317,&4 535.571 1,W4,474 1,033,168 422,620 9,272,750 1,082,786 125.233 59,467 712,A7'l 105,363 443,644 877 424

1 ,898,813 (27,524\ '1,871,289 1,O12,928 a30.213 14,195,r99 1,086,542

4,454,087 3.934.190 3.925.840 3.764.262 3.896.087 3-800.991 4.223.025 3.9AO722 34/,423e 367eo50

2714430

11 ,973,130 11 ,23A,102

(801,76r) (478,145) (126,75n (103,620) (82,826) (90,107) (39.149) C/9.395) (82.349)

75,813 29,28A (235,677) 34,127 9,623 90,998 33,071 (243,898) 34127 (8,¿ro5) 103,480

33,U7

(232,861) 34,127 14,258 1,102,978 49,777 98,197 35,818 (231,369) 34,127 (7ss) 159.982ì (732,182) 238,883 119,404 29,272 (229,090) 34J27 8,940 (33.347\ (853,776) 75,946 '113,140 34,763 (224,006) 38,127 't5,643 Q2.333\

1,262,400 (36,972) (884,587) (568,252) 293,142 rA,937 3't,961

263,614 1,064,209 484,603

$1,555,942 ($318,035) (S852,626) ($304,638) $1,192.755 81.922.52't S2.652.164 $530.614 (M93.299) l$777.8301 $1.5/t8.812

PAGE 5 UNAUDITED STATEMENTS

s0

$6.656.380

SLIDE 6 ASSETS CURRENT ASSETS Cash & Cash Equ¡valenls Unresticted Cash & Cash Equ¡valents Restricted Construclion Account lnveslments Designated Debt Service Reserve Fund Ðesignated Power Market Voltly Oesignalsd Special Capital Rsv Deslgnated Customer Deposits Accounts Receivable, net BPA Prèpay Rèceivâblê Accrued lnterest Receivable \/vholesale Pow€r Rece¡vable Accrued Unbillod Revenue lnventory Matêrials & Supplies Prepaid Expenses & Option Prem¡ums Total CuÛent Assets NONCURRENT ASSETS Restricted Bond Reservê Fund Other Recs¡vables Prelim¡nâry Surveys BPA Prepay Receivable Defened Purchased Power Costs Utilfty Plant Land and lnlang¡ble Plant Electrlc Plant ¡n Service Construct¡on Work in Progress Accumulatèd Depreciat¡on Net Util¡ty Plant Total Noncurrent Assets Total Assets DEFERRED OUTFLOWS OF RESOURCES Unamortized Loss on Defeased Debt Pension Defered Outflow Accumulated Decrease in Fair Value of Hedging Dorivatives Total DeferÞd Outflows of Regources TOTAL ASSETS & DEFERRED OUTFLOWS OF RESOURCES PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY COMPARATIVE STATEMENT OF NET POSITION ASSETS AND DEFERRED OUTFLOWS OF RESOURCES 24,335,167 10,645,098 2,612,152 3,850,000

.

12,511,793 r,600,000 7,315,389 600,000 169,1 17 1,805,482 3,800,000 5,476,431 379,622 75,10A,252 19,431,592 1 1,870,780 3,032,152 3,300,000 16,863,084 1,400,000 8,081,56r 600,000 46,001 1,393,287 3,600,000 5,543,982 417,705 $4,903,575 (1,225,683) (420,000) 550,000 (4,351,290) 200,000 (786,172) 123,116 412,195 200,000 (ô7,551 ) (38.083) r,107,865 97,007 124,338 5,300,000 5,610,622 75,580,114 1,107,865 97,387 50,491 5,900,000 6,171,012 13,32ô,755 3,493,187 315,230,249 3,744,755

(479,892) -1%

(380) 73,847 (600,000) (560,391)

(486,923) A%

12,239,832 3,530,230 318,464,934 5,838,000 (196.351.108) n97.500 ,711)

37,U3

3,234,685 2,093,245 1,149.603 131,482,056 143,721,887 124.967,480 6,514,576 5,427,852 5o/o 4o/o 2% 2't8,822,139 (30,402) 1,429,022 536,409

.

1,935,030 213,874,379 (17,2s7)

2,0i9,756

¿f86,5ô3 4,947,760

(13,r05) (5e0,734) 49.U6 2,ß9,022 (553,992) .169 210,363,401 4.393.708 2% PAGE 6 UNAUDITED STATEMENTS

1 1t3gl2tt18 I 1l30t?lr1ì Inr:reaserlDe¡;rêãsel

Ar¡ìo¡ilil

Pertpnt

SLIDE 7 LIABILITIES CURRENT LIABILITIES Wanants Outstanding Accounts Payable Customer Depos¡ts Accrued Taxes Payaþlê Other Cunent & Accrued L¡ab¡l¡ties Accrued lnterest Payable Revenue Bonds, Cunent Portion Total Current L¡abilities NONCURRENT LIABILITIES 2010 Bond lssue 2011 Bond lssue 2016 Bond lssue Unamortized Prem¡um & Discount Pension Liability Defered Revenue BPA Prepay lncentlvs Credit Other Liabil¡t¡es Tota¡ Noncurrent Liaþ¡lit¡es Total Liab¡lities DEFERRED INFLOWS OF RESOURCES Pension Defenêd lnflow NET POSITION Net lnvestment in Cap¡tal Assets Restricted for Debt Service Unrestr¡cted Total Net Position TOTAL NET POSITION, LIABILITIES AND DEFERRED INFLOWS OF RESOURCES CURRENT RATIO: (Current Assets / Currênt Liabilit¡es) WORKING CAPITAL: (Current Assets less Current Liab¡lities) PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY COMPARATIVE STATEMENT OF NET POSITION L¡ABILITIES AND DEFERRED INFLOWS OF RESOURCËS 8,944,536 2,028,939 2,915,1't3 2,817,538 230,957 3,750,000 20,ô87,082 8,324,061 1,645,150 3,303,957 2,670,337 214,493 $0 620,475 383,789 (388,844) 147,201 16,494 705,000 17,345,000 9,770,000 22,470,000 3,904,906 9,884,887 1,039,637 1 ,585,715 987,392 19,202,998 17,345,000 1 7,090,000 19,425.000 4,375,530 '13,019,386 567,455 1,746,971 934,761 1,484,084 8o/o (7,320,000) 3,045,000 (47O,624) (3,r34,499) 472,182 (1 61 ,256) 52.631 66,987,536 74,504,103 ß,241.5671

• 10o/o

ôo/o 87,674,618 1,866,603 404,554 93,707,101 (1,757,,183) 1,620,930 18,010 2,271,157 245,673 386,544 632,217 Accumulated lncrsase in Faif Value of Hedg¡ng Derivatives

Total Deferred lnflÕws of Resources 1,638,940 n/a 74,211,748 1,107,8ô5 55,491,780 63,669,652

1,1 07,865 57,246,566 130,811,393 122,024,083 10,542,096 (1,754,786) 8,787,310 216,363,401 4,393.768 7olo 2o/o

_____2nl57J6s

3.63:l 54,413,169 PAGE 7 UNAUDITED STA'TEMENTS 3.94:l $56,377,146

($1,e63,976) -3%

1 113rJt2(r1t I tt:\bt201; tncrease/lL)e0roase)

Arnour¡t

Pcrcên!

SLIDE 8

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY ENERGY STATISTICAL DATA CURRENT MONTH 11t30t2018 11130t2017 ENERGY SALES RETAIL - REVEÍT¡UE Res¡dentiel Small General Service Medium General Service Large General Service Large lndustrial Small lrrigation Large lrrigation

Sfeet Lighis

Security Lights Unmetered Accounts Billed Revenues Before Taxes & Unbilled Revenue Unþilled Revenue Energy Sates Retail Subtotal City Occupat¡on Tax66 Bed Debt Expense (o.l670 of r€rair sares) TOTAL SALES . REVENUE EI¡ERGY SALES RETAIL. KWh Residential Small General Service Medium General Service Large Genêral Serv¡ce Large lndustrial Small lrrigaiion Large lrrigation Street Lights Security Lights Unmetered Accounts TOTAL ÏIA'h BILLED fr¡ET POWER COST BPA Power Costs Slicê Block Subtotal Other Power Purchases Freder¡ckson Transmiss¡on Ancillary Conservation Program Gross Power Costs Less Secondary Market Sales-Energy Less Secondary Market Sales-Gas Less Transmiss¡on of Power for Others f{ET POVI'ER COSTS NET POVI'ER - KWh BPA Power Slice Block Subtotal Other Power Purchases Frederickson Gross Power kwh Less Secondary Market Sales Less Transmission Losses/lmbalance NET POWER - KWh COST PER MWh: (dollars) Gross Power Cost (average) Net Power Cost BPA Power Cost Secondary Market Sales ACTIVE SERVICE LOCATIOI{S: Res¡dentiâl Small General Service Medium General Serv¡ce Large General Service Large lndustr¡al Small lrrigation Large lrrigat¡on Street Lights Secur¡ty Lights Unmetered Accounts TOTAL

16,608

16,587

$8,¿187,,+:¡3

$8,153,146

1,000,000

1,000,000

ffi

462,863

477,459

aMW

aMW

53,123,365 73.8 51.479.968 71.5

9,191 ,224 12.8

8,977,767 12.5 15,499,978 21.5 14,999,386 20.8 20,269,121 28.2 18,985,058 26.4 5,498,280 7.6

5,659,028 7.9 124,127 0.2 869

0.0

3,048,545 4.2 2,770,352 3.8 211,640 0.3

210,436 0.3 82,782 0.1 94,106 0.1 245,945 0.3 255,250 0.4 10?,295,00?

103,432,2n

$2,237,048

$2,775,524

1,889,370

1,935,059

4J26/18

4.710.583

2,458,663

884,210

2,687,669

870,163

898,202

850,518

184,585

186,857

124,336

220J04

10,479,873

7,722,435 ('t,349,471) (3,492,987) (1,057,860) 4,614,862 689,477 1,163, 1 50

1 ,346,136

249,257 '13,852 314,388 17,823 21,880 $4,453,122 679,615

1 ,1 06,981 1,260,121 294,332 2,746 299,636 17,795 22,211 4,727,334 695,062 1,'t14,928 1,292,638 278,270 13,39'1 321,260 17,798 22,544 16.535 $8,499,760 700,000 i9,199,760 464,401 (1 5,000) $9,649,161 54,793,496 9,272,759 15,O37,120 19,370,204 5,314,800 123,750 2,582,791 211,'t25 90,504 253,926 107,050,475 2,728,739 1.854.729 4,583,468 680,1 52 1,354,060 893,619 179,742 191.299 7,882,340 (1,490,387) (62,486) (144,468)

_!!¡!1f99_

15,063,000 25.1 99.000 173,994,000 (54,442,000) (1,1 94,000) $45.30 852.26 $34.27 $27.38

• 2o/o
• 1o/o

4o/o 4o/o 4Vo 3o/o

• 2o/o

þo/o

• 3o/o

0o/o

• %

43o/o

3%

Oo/o Qo/o 3Yo 4o/o 1o/o 5o/o 7o/o

• 2Vo

>200o/o 5o/o 0o/o

• 1o/o

0o/o

4%

0o/o 1%

• 18o/o

3o/. 3o/o 2o/o 7o/o

• 3o/o

>200o/o 10o/o 'lo/o

• 12o/o
• 4o/o

4o/r

• 'lgYo
• 2o/o
• 12o/o

't78%

>200o/o 60/o

• 1Yo
• 44o/o

360/o 28o/o

nla

1 14o/o

• 17%

0o/o 0o/o 0o/o

• 38o/o

nla

• 23o/o
• 65o/o
• 52o/o

5% AMW 76.'l 12.9 20.9 26.9 7.4 0.2

• .o

0.3 0.1 0.4 3o/o 5Yo 0o/o 18o/o Oo/o

• 9o/o
• 3o/o

0Yo

• 1o/o

AMW

76,904,000 106.8

76,985,399

62,908,000 87.4

62,908,173 139,A12,000. 194.2 139,893,572

14,849,000 20.6

24,025,545

• 36,050,000

154,661,000 214.A 199,969,117 (26,3e8,000) (36.7) (75,e15,110)

(1,315,000) (1.8)

(2,71e,s63)

126,948,000 176.3

121,334,444 AMW 106.9 87.4 194.3 33.4 50.1 277.7

(1 05.4)

(3.8) 168.5 20.9 35.0 24't.7 (75.6) (1.7) 164.4

• 18o/o

2o/o

• 10o/o

>2O0o/o 98o/o 1% 3o/o

• 35o/o

33o/o

• 9o/o

>20ïo/o 15o/o

• 12%

7o/o 2o/o 5o/o

• 1o/o

nla

• 1 1o/o
• 52o/o

1Oo/o

7% AMW

72,127,000 100.2 61,605,000 85.6 133,732,000 185.7 ÐÞ/./þ

$43.09 $29.51 $51.12 $38.62 $54.29 $33.67

$1 3.93

75%

• 21o/o
• 12o/o

267o/o 5Qo/o

• 18o/o
• 14o/o

87o/o

44,891 4,984 812 164 5 437

• "t,869

44,140 5,002 784 lÃo 5 55s 434 9 1,933

2o/o 0o/o 4o/o 3o/o 0o/o

• 4o/o

1o/o 0o/o

• 3o/o
• 2o/o

1o/o

370

v,073

378 53,399 ACTUAL ACTUAL AMEtrlI¡ÊO BUDSET PCT VAR

PCï

VAR

Page I

SLIDE 9 PUBLIC UTILIry DISTRICT NO. 1 OF BENTON COUNry ENERGY STATISTICAL DATA YEAR TO DATE 11t30t2018 ENERGY SALES RETAIL - REVENUE Res¡dential Small General Service Medium Gènerâl Serv¡ce Large General Service Large lndustrial Small lnigalion Large lrrigalion Street Lights Secur¡ty L¡ghts Unmetered Accounts

Bílled Rovenues Befo¡e Taxes & Unbilled Revenue Unbilled Revenue Energy Sales Retail Subtotal City Occupation Taxes Bad Debt Expense (0.'r6%of rerá¡tetes)

TOTAL SALES - REVENUE ENERGY SALES RETAIL - KWh Residential Small General Service Medium General Service Large General Service Large lndustrial Small lrrigation Largê lrrigation Slreet Lights Secur¡ty Lights Unmetered Accounts TOTAL KWh BILLED NET POWER COST BPA Power Costs Sl¡ce Block Sublotal Olher Power Purchases Frederickson Transmission Ancillary Conservation Program Gross Power Costs Less Secondary Market Sales-Energy Less Secondary Market Salee.Gas Less Transmission of Power for Others NET POWER COSTS NET POWER. KWh BPA Power Slice Block Subtotal Other Power Purchases Frederickson Gross Power kwh Less Secondary Market Sales Less Transmission Losses/lmbalance NET POWER. KWh COST PER ItWh: (dollars) Gross Power Cost (average) Net Power Cost BPA Power Cost Secondary Market Sales AVERAGE ACTIVE SERVICE LOCATIONS: Residential Small General Service Medium Gêneral Service Large General Service Large hdustrial Small lnigat¡on Large lrr¡gation Street Lights Secur¡ly L¡ghls Unmetered Accounls TOTAL

r30,351,000 16.3

183,650,000 2,204,591,OOO 27s.0 2,487,718,097

(523,124,000) (65.i1) (688,191,189) 53,257,119 8,401,020

I 1,861,198 13,803,392 3,143,142 'l,021,515 22,371,920 195,857

2Mj69

182,262 54,072,747 8,435,912 11,920,021 '13,597,647 3,155,480 976,80 1 22,064,599 195,746 245,087 182.605 56,914,041 8,550,993 11,815,911 13,201,776 3,126,483 906,935 20,795,163 192,611 245,000 aMW 77.5 14.2 20.9 27.4 7.5 1.9 51.0 0.3

0.1

eMW 78.7 14.3 20.9 26.6 7.5 1.8 50.6 0.3 0.1 0.3 201.2 AMW 135.5 102.7 23A.2 49.2 22.9 310.3 (85.e) (4.0) 220.5

Oo/o Oo/o 3o/o 0o/o 4o/o 1%

• %
• 5o/o

0% AMW 85.7 14.7 21.3 26.5 7.6 1.7 48.9 0.3 0.1 0.3 207.2

• 60/o
• 2o/o

Oo/o 5o/o 1o/o 13o/o 8o/o 2o/o Oo/o 2o/o

• 't%
• 44o/o
• 1olo
• 3Vo
• 3o/o
• 1o/o
• 1Oo/o
• 3o/o
• 2o/o

4o/o

• 'lo/o

11o/o 4o/o Qo/o

• 7o/o
• 2o/o
• 3õ/o
• 2%

Qo/o 0o/o 2o/o 0o/o 5o/o 1Vo O%o Oo/o

• %
• %
• %

0%

• 10/o
• 8o/o

Oolo

• 1o/o

$114,¿181,594 (1,000,000) 1 14,846,645 (1,000,000) 178,355 $115,927,268 (1,800,000) i114,127,268 5,595,407 (2o2,ooo) $119,520,675 686,928,910 118,234,467 1 70,890,91 1 212,170,900 60,929,190 13,710,552 391,769,024 2,323,736 1,021,459 2,791,476 1,660,770,625 $1 1 3,481,594

5,407,738 621,327,393 114,112,448 167,774,943 219,735,927 60,271,920

1 5,265,1 88

409,030,232 2,325,530 9M,928 $31,295,018 23,95A,574

1 13,846,645 5,455,070 630,600,196 114,521,161 167,657,698 213,491,200 60,041,698 14,646,886 405,942,582 2,3't9,677 994,092 $31,784,822 23.702.246 $55,2s3,592 14,221,228 12,302,913 10,317,335 2,300,809 58,161 $55,487,068 ' 11 ,841,788 11,372,954 '10,141,877 2,085,241 756,276 't,870,447,OOO 203,793,000 942.84

w.82

$29.54 627.29 1,909,508,111 394,559,986 $36.86 $42.08 $29.06 $23.54 $30,886,705 23,190,810 $54,077,5 1 5 10,128,533

11 ,674,855

9,327,913 2,803,690

ô51 168 $88,663,674 (11 ,747,973) (e11,680) (1,1s6,730)

i74,847,291 AMW 1,0¿14,973,000 130.4

838,016,000 r04.5 1,882,989,000 2U.9 229,756,000 28.7 153,884,000 19.2 2,266,629,000 282.8 (s46,610,000) (68.2) (26,601,000) (3 3) __L,99!,41!,099_ 211.3

$39.12 844.20 828.72 921.49 AMW 130.7 102.7

• 2o/o

1% Oo/o 2Oo/o 8o/o 2o/o 1Oo/o

• 92o/o

3o/o

• 12o/o

nla

180/o

• %

4Yo Oo/o

• 2o/o

'48o/o

• 29o/o
• 11o/o
• 240/o
• 14%

a%

1o/o 3o/o 2o/o 4Oo/o 5o/o '110/o

• 18o/o
• 91o/o

7o/o 22o/o >2OOo/o 13o/o

• 1olo

Oo/o

• 2o/o
• 1o/o
• 't1%
• 15o/o
• 3o/o

4o/o 4o/o

• 2%

1Oo/o 1o/o 3o/o 27o/o

$94,454,038 (14,274,627) (4,742,808)

1,047 ,417,OOO

823,030.000 $91,685,204 (16,201,764) 1,086,475,067

823,033,0¿14 233.3 25.4 160/0 7o/o 2o/o 16Vo

44,514 4,970 802 162 5 547 437

• 1,889

43,842 4,973 782 160 5 558 430

• 1,944

2o/o Oo/o 3% 1o/o Oo/o

• 2%

2o/o Oo/o

• 3o/o
• 1o/o

1% 373 ________99¿99_ 378

• -------5tõ81-

ACTUAL ACfUAL AMENÐED BUOGET PCT VAR PCT VAR

Page I

SLIDE 10 PUEIIC UIII.IW DIÍRICT NO. 1 OF BENTON COUNTY KVVH SALES MONTHLY ACTIVITY Resídential 2014 2015 2016 2017 2018 90,995,045 81,7s3,2s1 89,934,474 1L4,OA9,923 90,52r,667 86,8s6,866 70,842,807 72,255,O49 97,473,6L8 69,963,306 lL,773,687 ro,444,066 LO,6t5,A24 L2,326,759 10,600,544 L6,r74,267 1s,058,182 L5,L29,40r 15,406,899 74,4L2,773 L8,O04,500 17,2r2,7L7 t7,545,840 17,299,8A9

!4344,67r

5,695,020 5,394,485 5,306,745 5,31"9,830 5,t58,240 266,769

zto,554

379,L79 229,629 494,t43 6L,276,449 51,19s,817 53,460,881 72,629,078 64,!97,600 9,247,968 8,399,963 8,804,2s3

lL,375,2t9

9,492,590 L3,320,76! L3,L24,396 t2,982,308 15,083,130 L3,220,I77 t6,529,440

t6,2I3,065

L6,492,L20 18,510,883 L7,025,842

6,!4L,tL0

5,337,36s 5,715,980 5,953,160 s,69s,840 566,O22 648,290 469,477 277,71O

r$,892

1L,959,400 14,636,633 9,247pA4 r,485,633 r.0,909,657 46,126,349 43,964,t77 45,8A6,799 50,897,608 5t,994,462 8,838,27r 8,630,s63 9,093,5L7 8,459,581 9,262,432 r.3,43&288 L3,6tL,242 13,939,681 13,953,993 r.3,836,653 16,641,080 17,278,1A3 t7,360,382 L7,69L,O33 18,279,97L 5,9L7,690

5,784;30 5,547,t75

5,959,920 5,195,640 r37O,794 L,48t,2a6 r,647,439 434,783 846,58r 40,o53,677 39,362,242 45,29I,455 17,8A6,279 22,783,85s 38,751,097 38,845,198 38,72t,34L 40,454,502 4L,I72,298 8,960,528 9,005,788 9,2L7,5r4 8,910,ss7 9,4O3,579 L3,403,247 14078,883 t3,879,726 L4,t57,Or5 14,4s3,2L8 L7,L75,A60 L7,939,803 L7,583,7L2 18,241,,93L t9,678,682 6,227,320 5,632,340 4,L92,375 4,342,280 4,t57,840 2,487,573 2,L59,63.6 2,203,347 L,70t,606 2,L85,730 68,929,L39 61,259,905 66,290,382 54,086 389 64,616,180 43,347,9to 48,99s 659 44,464,304 45,0L4,248 46,OO5,694 10,069,805 r.0,6i.6,996 L0,063,7t7 10,148,595 L0,408,L32 14,808,800 1s,970,931 L4,686,797 L5,250,364 rs,432,469 L8,408,820 19,595,384 1 8,140,663 L8,951,191 19,988,s35 6,005,800 5,678,570 5,666,470 s,566,080 s,739,040 2,926,545 2,668,782 2,637,887 2,s05,r.09 2,676,895 94,789,557 103,842,869 88,901,499 93,753,a28 86,922,O59 5t,878,664 62,750,OO8 49,566,548 55,425,63L 52,40r,791 ro,498,332 12,060,700 L0,760,436

lt,42t,880

11,068,455 L5,526,97t L6,957,563 t5,578,700 15,663,861 16,006,913 19,689,940 20,935,183 18,545,919 20,5rL,714 20,624,407 62,LoL,272 58,699,674 57,564,364 62,752,408 63,97t,768 12,390,2L8 11,95s,370 11,863,201 12,037,978 t2,734,593

L7,!45,84t

L6,576,440 16,5t6,307 t7,906,763 L7,702,795 21,,264,420 20,74L,663 20,497,27L 2r,497,993 23,332,3L6 49,381,509 48,136,350 49,472,576 53,038,58s 48,545,386

rt,!06,946

10,809,84s 10,839,759 1L,357,363 LO,9t2,920 15,985,439 L5,990,572 t6,o93,629 r.6,509,954 16,o75,867 2r,006,340 2L,305,140 19,923,658 20,970,960 2r.,583,396 5,080,145 5,623,A20 4,427,850 5,753,440 5,353,960 2,24839a 2,O75,784 2,OOs,4S7 1,809,769 2,!33,836 38,Lt7,908 37,832,472 33,735,656 29,243,746 32,455,674 38,520,801 37,850,154 38,810,551 40,359,813 39,430,056 9,2t4,420 9,O6s,L97 9,285,276 9,027,734 8,9Oa327 1.5,533,136 L5,576,L54 15,538,491

t4,7s|,4a4

15,031,084 2t,502,220 20,ss&020 2t,L79,80L 205OLOA4 2I,498,126 6,181,005 s,598,540 s,998,320 5,962,760 5,976,320 7,745,t57

t,t72,302

889,198 928,403 858,769 27,773,t32 24,467,386 L4,740,237 18,136,316 L63A2,998 51,L27,327 46,90s,821 46,586,644 54,793,496 53,123,365 9,056,203 8,7L9,747 8,652,183 9,272,759 9,19L,224 14,9sO,232 L4,732,964 74,711,L27 15,037,r20 75,499,978 19,841,340 18,687,460 19,314538 19,370,204 20,269,I21 6,t25,825 5,408,760 5,625,690 5,314,800 5,498,280 (s2l 2,846 L23,750 L24,r27 3,779,5r5 3,4L4,78I 2,O22,639 2,582,79L 3,048,54s 76,447,442 75,565,855 75,0r8,ts7 72,704,997 10,725,57a 10,5L5,898 10,807,220 10,819,539 15,501,055 15,273,O04 ts,377,8s2 \5,264,344 18,573,00o 17,8t9,400 t8,495,4L5 18,503,509 5,922,215 5,732,865 4,774,520 6,t54,9?0 43,802 258,93r )1 Ã 1ñq 238,007 281,800 696.803,831 665.504,766 661,741,688 759,633,907 62t,327,393

t24,2U,UO

121,497,780 rzLß68,24s 729þ54,006 t74,1L2,44A t82þ43,8O2

t82ßto,322

180,466,703 186Jss,25s t67,774,943 226,679,300. 226,174,929 223,267,9r9 230,574,409 2I9,735,927 71,369,485 66,941,885 64,ô12,25L 67,Ð84,7t0 60,?71,920 L7,208,870 t6,424,664 L5,597,288 ]..3,v54,354 15,!65,188 455,134,566

451,777,tlg

419,588,399 392,050,824 409,O30,232 Small General Service

2çL4

r2,oo2,a84

2C15

L!,273,647

2CL6

1L,865,345

2CL7

13,896,042

2C18

L2,!29,652 L6,255,765 L5,719,99L t6,032,684 t7,L70,328 16,r.03,016

Lerge General Sery¡ce

2014

ta,o43,140

2ùts

L7,888,911

20t6

18,188,600

2AL7

18,624,018

2018

19,LL0,860 Lãrge lndustr¡al

2014

6,203,055

2015

5,597,495

2016

s,743,306

2017

5,118,880

2018

s,99s,840 Small lrr¡gat¡on 20L4 2015

20L6

20

2077

(4)

2018

50,526 Large hr¡gat¡on 247,328 2t4,532 22L,3L2 200,892 233,165 2AL4 2015 2AL6 2AL7 20L8

;

181

6,Llt,425

4,98L,620 5,7O4,84O 5,565,400 5,964,840 3,475,842 3,213,086 2,835,670 3,L47,673 3,29s,476 1o2,773,87r 98,850,190 88,434390 103,188,s20 1o2,L95,462 6,258,875 6,L7L,695 5,908,980 6,072,640 5,536,080 2,98A,59r 3,002,663 2,948,608 2,78L,753 2,9L6,373 67,085,339 67,47r,445 70,085,659 70,975,OOt 68,98&554 32,983 20L4 2015

20t6

2017 2018 PAGE 10

SLIDE 11 PUBUC UfILITY DISTRICT NO.1 OF BENTON COUNTY KWH SALES MONTHLY ACTIVITY

Street Lithts 20L4 2015 2016 20!7 2018 Security L¡ghts 20!4 2015 2016 20t7 2018 Unmetered 20t4 2015 20L6 20L7 20ta Total 20L4 20t5 2016 20L7 2018 229,425 225,624 225,O24 ztL,349 zLL,046 103,678

tL4,45t

Lr3,273 100,963 85,L12 ?47,686 249,LO6 257,O45 253,9ls 242,804 t44,328,006 133,037,008 14¿58L,083 169,666,306 144,683,688 229,425 225,624 724,878 zLL,253 2!L,337 103,678 114,408 113,r.96 100,920 90,490 247,5t6 249,tO6 257,O45 2s3,915 254,A23 L39,35t,728 119,751,958 L7L,827,338 r48,622,7L2 119,563,310 zz9,sts 225,624 224,A78 zrL,253 21L,343 103,420 tr4,o73 tL3,239 91,650 90,r44 247,5L6 ?49,106 257,045 253,7L5 255,332 rt9,62L,60L tLo,L44,332 to1,768,L65 L25,A7L,43r t¿L,247,4L7 229,5!5 225,672 224,494 2rL,2s3

ztt,3to

LO3,377 113,696 113,180 91,545 89,927 247,516

748,9t9 757,O45 253,7t5 255,332 L32,966,557 130,700,305 L39,32t,167 tL5,839,7L0 r22,756,t63 225,070 225,672 2Lt,235 zLL,253 zLt,3tO L03,334 113,s31 L01,382 9L,424 85,656 248,246 248,9t9 2s7,O45 253,7L5 245,684 L56,sto,6L4 149,s09,655 1s2,6s8,0s9

1"42,450,672 L56,2tO,L77 224,939 225,672

2Lt,t87 zt]-,253

ztt,3I0

103,248 113,488 101,425

9t,t34

84,953 248,246 248,9t9 257,U5 253,7t5 245,684 r90,932,770 707,957,270 L85,130,994 19t,745,517 L87,7L4,77t 225,Oæ 224,880 2Ll,L87 2L1,753

zLl,3tO

LO3,476 113,488 101,382

90,742 84,383 248,246 248,9L9 258,34t 253,715 245,6U 210 931,831 220,33s,637 19r,997,4L3 2L5,4aO,429 2t2,098,72t 725,6N 224,880

7u,r87

2Lt,253 2rt,634 1L4,623 tt3,445 101,409 90,860 84,206 249,106 2s4,930 259,637 253,7L5 245,745 t89,823,925 L85,2t2,205 185,956,623 194,580,364 L95,724,064 225,5r4 224,928 2Lr,t87 21t,253 211,650 L14,494 1t3,402 101,366 90,8s0 83,941 249,t06 254,Us 259,637 253,715 245,945 !43,5I5,799 t42,367,r58 t37,070,775 t39,239,635 t37,602,515 225,514 225,024 2rr,187

ztl,238

2L7,640

rt4,494

113,3s9 101,194 90,827 83,334 249,LO6 255,749 254,365 2s3,7t5 245,945 120,458,985 114881,885 102008,620 L1o,223,374 108,626,s99 225,29a 225,024 211,349 21t,L25 21]-,640 t14,444 113,359 101,108 90,504 42,782 249,LO6 257,O45 254,365 253,926 245,945 104,869,238 98,467,4O7 97,479,643 LO7,050,475 to7,295,007 225,586 225,024 2tL,349

zl1,046

LL4,430 113,309 101,108 90,659 249,L06 257,045 254,365 252,929 t2a,oLL,343 125,656,509 L25,277,997 t24,327,545 2,720,505 2,703,648 2,589,t42 ?,534,782 2,32s,s30 t,296,696 t,364,OO9 L,263,262

t,tt2,tLg

944,928 2,980,502 3,022,608 3,082,980 3,O444O5 2,728p23 L,78r322,397 1,738,O2r,729 r,694,077,877 !,785,O98,t70 1,6L3,5r7,432 PAGË 11

SLIDE 12

PUBLIC UTILITY DISTRICT NO. 1 OF BENTON COUNTY CAPIT.AL ADDITIONS AND RETIREMENTS CURRENT MONTH

ADDITIONS RETIREMENTS

tsALANCE 10t31t2A18 BALANCF '11t30t2018 INTANGIBLE PLANT: Organizations Franchises & Consents Miscellaneous & lntangible Plant TOTAL GENERATION PLANT: Land & Land Rights Structures & lmprovements Fuel Holders & Accessories Other Electric Generation Accessory Electric Equipment Miscellaneous Power Plant Equipment TOTAL TR.Ai¡SilrSS tOt{ PLAitT: 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 & lmprovemenfs 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 PLAlrlT: Land & Land Rights Structures & lmprovements lnformation Systems & Technology Transportation Equipment Stores Equipment Tools, Shop & Garage Equ¡pment LaÞoratory Equipnient Communication Equipment Broadband Equipment Miscellaneous Equipment Other Capitalized Costs TOTAL TOTAL ELECTRIC PLANT ACCOUNTS PLANT HELD FOR FUTURE USE CONSTRUCTION WORK IN PROGRESS $28,379 10,022 29.078 $o $0 $28,379 10,022 29.078 $67,479 67,479 1,141,911 770,459 1,141,911 770,459 1,912,370 1,912,370 156,400 25,544 832,047 256,175 4,998,4s2 156,400 25,544 832,047 256,17s 4,998,452 4.050.057 4.0s0 057 10,318,675 232,983,072 849 63,363 154,212 28,363 235,431 189,435 9,367 74,355 70,3'13 10,860 1,932 252,349

17 173

1,108,002 (29,707) (224) (12,811) (8e6) (166,219) (605) 10,318,875 1,761,458 295,502 40,705,676 21,376,844 13,868,285 37,540,115 48,378,370 31,825,844 2,922,103 20,584,286 10,393,781 862,2Ö6 779,883 2 765,122 1,760,609 295,502 40,642,313 21,252,339 13,839,922 37,304,908 48,201,746 31,825,844 2,912,736 20,509,931 10,323,468 863,192 779,883

1 ,130,759

18,723,197 9,343,681 8,171,989 54,108 487,239

489,1 35

2,512,138 21,399,573 1,141,835 1,130,759 18,723,197 9,188,322

8J71,989

54,108 487,239

489,1 35

2,513,465 21,651,922 1,141,835

11

320,709,033 388,589 5.691.431 146,569

11

(210,462) 321,606,573

388,5g9

• 5.838.000

326.789.053 Amended TOTAL CAPÍTAL

PAGE 12

1,254.s71 l$210.462ì $327.833.r62

SLIDE 13

PUBLIC UTILITY DISTRICT NO, 1 OF BENTON COUNTY CAPITAL ADDITIONS AND RETIREMENTS YEAR TO DATE

ADOITIONS RETIREMENTS

B,ALANCE

12t3'il20't7 BALANCE 11t30t2018 INTANGIBLE PLANT: Organizations Franchises & Consents Miscellaneous & lntangible Plant TOTAL GENÉRATION PLANT: Land & Land Rlghts Structures & lmprovements Fuel Holders & Accessories Other Electric Generation Accessory Electric Equ¡pment Miscellaneous Power Plant Equipment TOTAL TRANSMISSION PLAlrlT: 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 Sysl.em 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 CONSTRUCTION WORK IN PROGRESS

$28,379

$0 10,022 29,078 $0 $28,379 10,022 29,078 $67,479 1,',t41,911 770,4s9 67,479 1,141,911 770,459

3,933,872 116,185

• 4,050,0s7

10,009,600 309,075

• 10,318,675

'1,912,370 '156,400 25,544 832,047 256,175 4,805,562 1,724,870 295,502 39,953,634 20,332,146 13,',t24,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 192,890 36,588

752,042 1,356,972 902,586 2,125,013 2,707,526 't,824,006 103,874 73s,888 436,463 8,243 20,051 33,203 1,912,370

156,400 25,544 832,047 256,175 4,998,452 (312,274) (159,144) (1s,545) (121 ,631 ) (225,856) (6,055) (14,e36) (12,1e7) (520) 1,761,458 295,502 40,705,676 21,376,844 13,868,285 37,540,115 48,378,370 31,825,844 2,922,103 20,584,286 10,393,781 862,296 779,883 2.470,679

223,590,825 11,042,455 (868,158) 233,765,122

't ,1 30,759 1 ,1 30,759

18,522,269 200,928

• 18,723,197

8,917,609 637J.46

(366,433) 9,188,322

7,738,544 433,445

• 8,171,989

54,108

54,108

484,198 3,041

• 487,239

489,135

489,135

2,436,s22 83,845 (6,902) 2,513,465 20,695,799 956,123

• 21 ,651 ,922

1,141,835

1,141,835

11,845,428 145,528

• 11,990,956

73,456,206 2,460,056 (373,3351 75,542,927

13,811 ,586 309,036,480 388,589 4,599,287

(1,241,4931 321,606,573

• 388,589

5,838,000 1,238,713

314,024,356 1s,050,299 ($1,24r,493) $327,833,162

;16,003,426 AmendedBudget

TOTAL CAPITAL

PAGE 13

SLIDE 14

PUBLIC UTILITY DISTRICT NO. I OF BENTON COUNTY STATEMENT OF CASH FLOWS YTD 1'u30t2018 Monthly 11t30t2018 CASH FLOWS FROM OPERATING ACTIVITIES Cash Received from Customers and Counterparties Cash Paid to Suppliers and Counterparfles Cash Paid to Employees Taxes Paid Net Cash Provided(Used) by Operating Activities CASH FLOWS FROM NONCAPITAL F¡NANCING ACTIV¡TIES Other lnterest Expense Net Cash (Used) by Noncapital Financing Activities CASH FLOWS FROM CAPITAL AÎ{D RELATED FINANCING .ACTIVITIES Acquisition of Capital Assets Proceeds from Sale of Revenue Bonds Reimbursement of Bond Expense Bond Principal Paid Bond lnterest Paid Capital Contributions Sale of Assets

ilet Cash (Used) by Capital and Related Financing Activities

CASH FLOWS FROi/I INVESTING ACTIVITIES lnterest lncome Proceeds from Sale of lnvestments Purchase of lnvestments Joint Venture Net Revenue (Expense)

llet Cash Provided by lnvesting Activities

NET TTCREASE (DECREASE) tN CASH CASH BALAITICE, BEclt{Nll{c CASH BALAIICE, ENDII{G RECOI{CILIATION OF I¡ET OPERAT¡NG INCOME TO IIET CASH PROVIDED BY OPERATING ACTIVITIES Net Operating Revenues Adjustments to reconcile net operating income to net cash provided by operating activities: Depreciation & Amortization Unbilled Revenues Misellaneous Other Revenue & Receipts GASB 68 Pension Expense Decrease (lncrease) in Accounts Receivable Decrease (lncrease) in BPA Prepay Receivable Decrease (lncrease) in lnventories Decrease (lncrease) in Prepaid Expenses Decrease (¡ncrease) in Wholesale Power Receivable Decrease (lncrease) in Miscellaneous Assets Decrease (lncrease) in Prepaid Expenses and Other Charges Decrease (lncrease) in Deferred Derivative Outflows lncrease (Decrease) in Deferred Derivative lnflows lncrease (Decrease) in Warrants Outstanding lncrease (Decrease) in Accounts Payable lncrease (Decrease) in Accrued Taxes Payable lncrease (Decrease) in Customer Deposits lncrease (Decrease) in BPA Prepay lncentive Credit lncrease (Decrease) in Other Current Liabilities lncrease (Decrease) in Other Credits $145,0'10,766 (126,977,370)

(1 3,1 81 ,269)

11,876,483 $14,409,633 (14,596,990) (1,627,262) 1,233,457 16,728,610 (581,262) (30,333) (30,333) (10,222) (10,2221 (14,736,449) (3,570,000) (2,5e8,737) 1,957,874 44,548 (1,207,198) 484,603 1,878 (18,902,764) (720,717) 101,249 922,663 2,000,000 2,922.663 101,249 718,176 $45,298,801 (1,210,952) $47,227,929 9¡f6,0t6,977 $5,442,868 9,022,116 1,000,000 25,576 $1,086,542 830,212 (1,000,000) 3,424 (97e,459) (737,616) 36.1,099 (147,818) 1,527,149 (1,410,716) 1,237,036 550,000 67,941 111,442 (3e8,081) (60,560) 1,266,601 586,433 (736,401) 127,791 50,000 (2,015) 24,406 (122,002) (4e1) 107,057 27,690 (5e,858) (1,717,737) 220,529 30,059 (13,438) 21,888 {196,319) Net Cash Provided(Used) by Operating Activities 'AGE

14

10 ,2621

SLIDE 15

re 80 70 60

850

E40

gt8

10

Jan Feb March April May June July Aug Sept Oct Nov

Dec

ONormal a2018 a2O17

Average Temperature

Year Jan Feb

ilarch April

ilay

June July Aug Sept Oct filov Dec Annual Historical Avg 33.4 38.2 46.5

53.4 62.1 69.6 77.1 75.8 66.4 53.1 40.5 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 57.2 2017 21.6 32.4 46.8 52.0 63.0 71.1 80.4 79.4 67.6 51.9 41.2 55.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 57.5

PUBLIC UTILITY DISTRICT NO. I OF BEi¡TON COUNTY WEATHER STATISTICS November 30, 2018 Year Jan Feb illarch April

Ílay

June July Aug Sept Oct l{ov Dec Annual Historical Avg 0.94 0.70 0.57 0.55

0.51 0.51 0.23 0.18 0.31 0.49 0.95 5.94

zo18

1.'10

0.35 0.35 1.25 0.81

• .23

0.01 0.93 0.75 5.78 2017 1.43 1.78 0.79 0.98 0.37 0.23 0.06

• .29

4.72 1.45 8.10 5-yr Avg 0.82 0.74 0.77 0.42 0.78 0.47 0.07 0.24 0.20 0.95 0.67 6.13 800 700 600 500 400 300 200 100

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

• ô
• Dec

Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Nov

Each point on this graph represents the number of CDDs for the preceding 3Gday period, ¡.e., the cumulative CDDs that are b¡lled on November 15 occuned beiween Oclober 15 - November 14.

.^- ,.d1 {ffi

• ffi

I

lil

J

7

.t&\

1--#

\å

• <¿

,:iìi Month

Year Jan Feb March April May June July Aus Sept Oct Nov Dec Total 2018

6 141 165

485 356 68 1,221 2017 77 203 475 445 147 1,347 S-yr Avq 6 82 244 477 410

't'1 9

7 1,345

Cumulative GDDs in Billin

2018

19 1,997 4,305

9,442 15,375 6,163 550

37,851 2017 542 3,886 11,414 15,181 9,561 1.173 41,7 57 5-yr Avg 76 1,150 4,641 11,694 14,248

8,233 1,595

52 41,689 1,400 1,200 1,000 800 600 400 200

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

v,

• I

Dec Jan Feb Mar Apr May Jun Jul Aug Sep Oct

Nov

• 2016/2017
• 2017/2018

*-.. .,,5_Yr Avg

Year Jan Feb March April Mav June July Aug Sept Oct l{ov Dec Total 2018 843 740 593 344 25

20 2 60 391 761 3,779 2017 1,347

912

565 386 137 15 72 404

716 4,554 5-yr Avg 1,050 738 524 296

91 17

48 303 723 3,790

Cumulative HDDg in Billin

201 I

31,408 20.959 24,003 14,ô55 5,141 729 219

11

569 7,040 16,205 120,939 zo17 40,813 33,085 24,376 14,293 8,683 1,812 173 629 7,059 17,530 148,453 5-yr Avg 33,137 26,520 20,875 12,274 6.093 1,546 271 459 4,798 14,829 120,802

PAGE 15

SLIDE 16 PUBLIC UTILIW DISTRICT NO. 1 OF BENTON COUNTY BROADBAND SUMMARY , lnæpt¡on to Datc 20,458,961 11,511,262 (2,s5E,394) {6,s62,583) $3,1s9,092 ¡22,fi5,sr3 (ss,94r,495) 4,937,511

Decembar Hlghlights There were eleven new Access lnternet connections. one customer upgraded lo a 2ooMbps Transport serv¡ce and another one upgraded to a Gig. Th ree Transport conneôtions were d¡sconnected.

2ß18

Am{dcd

BudgÊt Nov L 20tE Ethernet Non-Recutr¡ng Charges - Ethemet TDM Wheles lnternet T€nsport Service Fixed \Mrde$ Aæess lntemet Non-Recurdng Charges - Al tsroadband Revenue - Olher Suþtotal $120,872 1,000 3,000 26 4,068 3,989 9,791 1,750 $1 14,785 1,331 3,000 26 4,.108 3,863 10.957 83'1 $l 14,480 '1,000 3,000 26 4,393 3,741 11,750 650 $1 1 7,183 500 3,000 26 4,437 12,197 1,400 $115,942 '1.000 3,000 26 4,664 3,623 '12,880 1,500 $115,738 1,500 3,000 26 4,732 3,581 't3,641 1,950 $116,284 1,000 3,000 4,473 3,551 13,089 2,350 $116,858 1,600 3.000 Æ 4.058 3.458 14,760 650 $117,327 1 ,000 3,000 3.063 15,263 s00 $1 17,611 1,150 3.000 3,158 17,332 2,000 $1,28't.201 1'1,081 33,500 2æ 45,463 39,884 142,9 t7 14,931

2330,324

2330,324 2,O55,847

$114j2

REVENUES 17,546 111 1E8,237 720

186,099 1A7,642 188,763 188,369 189,004 188,508

192.162 3,500 26 4,292 3,816 11,256 950

'182,621 181,682 182,760 1,298,747

1,298,747 66,399 329 106,239 72,O59 233¡600 66,399 329 106t239 72,059 233,600 32,899 43 60,776 32,175 90,683 (l¡r,931)

2,330'324 2,330'324 1E8,237 1E2,621 1E1,682 162,760 186,099 187,642 188,763 188,369 189.004 1s6,SO8

js2,16z 68,133 162 61.7t0 938,415 185 Mainlena¡ce ExpeËe 274,477 $2,055,847 145 2,086 146 Subtotêl $o

78,040 71,294 73,537 62,492 76,678 1.14.3S0 105.363 63,993 92,AO2

63,941

938,415 67.753

$470,242 Total OpeÊt¡ng Revenres EXPENSES $783,1'18 $85,506 145 98,r55 7,ma 75,158 73.854 2,423 61,897 70,046 3,491 60,443 10,850 70,s54 7,486 86,708 4,581 60,?49 3,244 63,845 3,908 General Expenses Other Ma¡ntenance NoC Mainlenanæ

616'724 54,337 52,399 22,434 52,6'13 42,.125 50,470 49,027 59,751 45,87S 7,999

20.368

(33s,360) (333,3€0) (27,661) (27,s62, lz7,4s1: (27,s7s\ (27,173) (27,ois) (27,0s11 (26.977) (27,o7e) ez221\

(2t,436) 178 $31,849 1,298 33,285 31,849 159,321 $457,403 $1 ($300,075) 5,406 9A 't47 618,724 INCOME

98

4,322

132

6,338

a,ao2

1,373 lnternal lnteGsl due to power Busines Un¡t(1) REVENUES & ÉXPENSÊS CONTRIBT'TIONS Total OpeÊl¡ng Êxpenæs

• PERATtNc TNCOME (LOSS)

Conlfibùtlons ¡n A¡d of Broedbând BTOP 9r,J¡5,5t6 $6,323 lr,¡83,618 96,323 s50t34 $77.830 s8a,æ¿l 33,450 ¡t¡3,857 25,15s $Êû,563 38,362 s{t,437 68,763

tsr,?å

53,424 ¡róð,5ûl (25,872) tyt,¡195 38,ô33

3t45.ût7 ù126.&r (33,ô38) (45,2s7) $al,at3

(72,921) $1,055,651 $ 1 54,326

It ¡9,Ca5

't48,003 CASH (TOYFROM AROADBAND('I

EFEtrDmnʡe

(1) rnternar¡ntererbudgetis$timatedbasedoncashflowprcject¡ons(an¡ntererfateof3.53%¡sbe¡ngused). (2) lncludes exces of revenues over operaling costs, capital expenditurcs and NoaNet ase$nents; exciudes deprec¡at¡on and internat ¡nterest to Êlectric system (3) ln september 2018, relêted the cãp¡tal expend¡tures for July and Augusl to ¡emoved the tT capiiat port¡on for the súnheaven Level 3 bu¡tdout. PAGE 1 6

SLIDE 17

'trtx

.-fl-a.o

Payroll Report

Pay Period Ending November 30, 2018

2g1A Amended Budqet** 2018 Actual Qver (Under) Actual to Budqet

Directorate Department

Operations Operations

• Supt. Of Transmission & Distribution
• Supt. of Operations

Meter Shop Transformer Shop Automotive Shop Warehouse Prosser Branch lT lnfrastructure lT Applications Executive Administration (1.00) (0.50) (3.00) (2.00) 4.00 3.75 2.00 3.00 3.75 2.00 15.00 3.00

1 5.00

3.00 2.00 3.00 6.00 3.00 2.00 3.00 6.00 3.00 6.00 9.50 5.00 5.00 6.00 9.00 5.00 5.00 6.00 32.00 2.00 5.00 6.00 4.00 7.00 4.00 7.00 I 1.00 6.00 29.00 2.00 5.00 4.00 4.00 7.00 4.00 7.00

I 1.00

General Manager Human Resources Communications & Governmental Affairs Customer Programs & Services Customer Service Key Accounts F¡nance & Business Services Director of Finance Treasury & Risk Management Accounting Contracts & Purchasing Engineering Engineering Customer Engineering Power Management Energy Programs 2018 Actual YTD 11t25t2018 Hours Position Department 2018 Budoet % YTD to Budoet Operations Eng¡neering Warehouse

IT

Operat¡ons Prosser Branch Customer Service 78 62 bb

61 467 '7 4e

172 350 1,043 520

9Oo/o

2,080 600

50o/o

Worker lniern CSR On-Call - Kennewick On-CalliLA - Prosser AssistanVLA

Tobl AA eolÌtiñÐnt h¡iüoBs

7.29b

tat

?.2t1 ßt¿

eoítlnocnt Y?O Fuil ?tnr Eoulwhñts {fÎg}

3.9û

8ßt

91.7o/o through the year

Original 2018

YTD

As of 1 1 /30/201 I 2018 Amended Regular Overtime $13,590,557 663,161 $13,425,7 93 $12,094,77 1

813,161 728.485

9Q.1o/o 89.60/o

14,253,718

90.1o/o

Subtotal Less: MutualAid

14,238,954 12,823,256

(4.500)

00o/o 75o/o 50o/o 25o/o * All Paid Leave includes personal lecn'e, holidays, shorllem disability, L&1,

iury duty pay, and miliîary letwe pay. +* There were no changes -from the original budgel to lhe amended budgeL PAGE ,17

Pay Per¡od Ênd¡ng YID 2018 Annual 2017

Oovertime lAll Pa¡d Leâve' ¡Regular

0o/o 11t25t14

SLIDE 18

Rural Economic Development Revolving Fund

• s of 1/4/2079

Datê

lnterest Lâte Fees

Fees Adm Fee

Bãlance ln¡tial deposit Second depos¡t Sandstone Café - 60 months Cupcakes & Del¡ - 36 months + Romeo & Juliet - 36 months 2010 - Q1 2010 - Q2 2010 - Q3 2010 - Q4 Yoplicity - 84 months 2011 - Ql

20tr - Q2

Let's Party 2011 - Q3 2011- Q4 Administrative Fee CY 2010 Admin¡strative Fee CY 2011 2012-Qr 2012-Q2 2012-Q3 20L2-Q4 Cente14Psych - 180 months 2013-Q1 2013-Q2 2013-Q3 F¡esta Restaurant - 84 months 2013-Q4 2014-Q1 2014-Q2 2014-Q3 2014-Q4 2015-Q1 201s-Q2 201.5-Q3 201s-Q4 2016-Q1 20L6-02 2015-Q3 2016-Q4

20L7-Ql 2017-Q2

2017-Q3 2017-Q4 2018-Ql 2018-Q2 2018-Q3 2018-Q4

to/28/08

• s/10/09

71/23109 03104/r0 03/31/LO 03/37/10

06/30/to

• e/30/!0

t2/3th0

03h6/tL 03/31/Lr 06/30/Lr 08/r7/rr 09/30/7r 72/31/tt 04/to/t2

041r0/12 0s/1o/t2

07/r7h2 to/22/lz 0!/Ls/13

• uzs/t3
• s/02/13

07/18h3 t0/14/13

L2/23/13 02/07/14 04/15/14 07/27/74 L0/t7 /14 02102/15 04/76hs

07/20/ls

10/13/75 01./ts/16

04/r8h6

07/t9/16 70/t3/16 02/03/t7

04/t4/t7

07/75/17 70/09/17

• L/08/18

04los/t8 07lt6/18 tol7s/18 0t/04/re

50,000.00 50,000.00 50,000.00 100,000.00 87,s00.00 70,000.00 60,000.00 60,749.99 64,188.75 67,065.10 69,247.48

41,,747,48 43,39L.67 46,325.75 3,82s,7s 6,907.74

t0,58r.r7

10,248.56 7,98t.82 11,658.20 55,401.98 56,98s.22 60,233.22 74,169.22 16,575.43 18,901.50 22,197.07 2,L97.07 4,957.78 7,659.17 10,98s.58 14,063.59 L7,677.08 19,973.00 2!,886.24 24,593.56 27,367.60 35,079.56 7r,714.3a 73,672.3r 83,046.34 83,832.72 84,622,37 85,418.55 86,227.2s 87,030.7L 87,844.40 88,665.00 89,490.78 s (12,s00.00) (17,s00.00) (r.0,000.00) (27,500.00) (42,s00.00) (46,064.00) (20,000.00) 552.45 2,847.15 2,4L5,?5 1,769.54 1,388.95 L,702.67 2,397.92 2,3s0,02 3,259.63 44,018.31 L,5L6.92 2,994.77 2,078.56

r,759.rr

2,733,93 L97.54 591.61 461.10

4r2.84 255,24

r,z3t.4r

683,47

r,324.0t

1,335.84 775.59 462.73 506.45 750.76 L,157.8L L,77r,04 (332.61) (2,266.741. (e19.09) (1,0s0.12) (39s.81) {2s3.22]. 2,L40.74

2,22s,rr

2,607.61 2,452.38 2,993.2s 7,724,92 1,308.52 2,094.80 2,228.26 7,t04.08 36,510.14 L,766.53 9,443,57 680.60 689.53 70I.39 7L4.43 727.95 736.4L 750.22 750.59 r,238.75 9s3.75 1,48s.36

r32a.73

r,3t2.I2

!,L7L.70 L,209.44 t,225,03 1,091.56 7,215.76 549.37 382.80 360.91 2t0.37 20t.44 189.58 176.54 163.02 154.56 L40.75 130.38 (2s0.00) (2s0.00) (619.38) (476.881 (742.68\ (664.371 (6s6.06) (s8s.85)

1604.72]|

l6t2.s2) (s4s.78)

(607.88) (274.69]¡ (1e1.40) (180.46)

(10s.le)

1100.72].

(94.7e)

188.27]| (81.s1) (77.28]. (70.38)

(6s.ls) (47.73\

(11.e4) (23.88) (23.88) (38.73) (3s.82) (14,8s) (37s.38) (s78.e1) (s8s.s2) Totals Outstending Pr¡ncípal: Loans ¡ssued Pr¡nc¡pal payments Write-offs / Adjustments Outstanding Loans Loans Outstanding: F¡esta Restaurant Outstanding Loans

S loo.ooo.oo s S 154.246.2L s 26.208.76

$ {196.83} S (soo.oo} S (14. 203.37) s 89,490.78

* Cupcokes ønd Ðeli princípol balonce of 514,379.70 was wr¡tten ofÍ os oi 9/30/77. Collect¡on efÍorts hdve not been successÍul.

S 175,064.00

(154,246.21l. (74,379.541

l__¿3193:_

5 7,438.2s 5 7,438.2s

SLIDE 19

2018 Monthly Loads vs BPA Resources

350 300

2SO

Actuals

Mar Apr May Jun Jul Aug

Sep

IBlock ICr¡tical Slice nAboveCritical Slice --Load

200

I :

ß 150 100 50

• Jan-18

Feb

Jan-18

Feb Oct

Nov

Dec-18 200 180 160 L40 L20

Í 100

• 80

60 40 20

Mar

Apr

• Cr¡tlcal

Sl¡ce

May

Jun

Jul

Aug

Sep

Oct

", ..eActual Slice

Nov

Dec-18

• ESP

Study Avg. Slice

• B. Scherer

1t15t19

SLIDE 20

FinaneialFloMIruatu

JanuaW 22,2olg

t1l

ffiomffii

SLIDE 21

23.d

+ ZOfg ú 25d' kr*elúfe NPe +nOZOt -20,2fl.ú Þqq

NTFC

2,0lbìlftrlf ñtrC

5's in Mill

Percentiler Rate Action Eftect¡ve Date

leyçryg_e_ late 4cltglt -

, 1. 2 3 5 7

:r --ìì i:f'--::

• ver time

>0

10 11 12 74 15 16 77 19

2.00

j:

t'75

r'--- .. _.' _ - -__ Benchmark Data

Stàff recþmmendat¡on: ;_.-.- _-

¡"-.. 1zQ+-1-

ncluded in 94

I Us,ing average rate action. Rate ection by class may ve.ry.

:..:

*Financial Forecasts are projections only, District stuff wìtl continue to monitor and evaluafu *e nèed for'futire rotè increoses.

'

BPA Future Year lncr:

power, 4.0 % transmission Preliminary 2019 Capital Plan

. $O.Svt under run each year 2O2O-2O23

2018 Load Forecast (201-8-2023)

BPA Spill Surcharge impact included

No BPA

R

uirements Financial Policy Moody's 2014 Median Ra Fitch 2016 Median A+

t 2l

Metrics 2023

20t7 2018 2019 2020 202L

2022

frrr.r|g-n

æWnmffi

SLIDE 22

2S"d

t:

a '

?orsMilIr$Prc

in Mill

ry-e-t j-o.ly9t:ç-o:I.l_e.l_c_e"î_t!!-e..,.,_

Rate Action Effective Date Revenue Rate Aetion

.

+ 2()1s-2()2€l at 5(ts' m*errtt" ]\J-PC

1

,ï:.Tt:Ie'iril1l'.r

i

4,

*Financial Forecasts are proiections only, District staÍf will continue to monìtor antd evaluate tfie need for future rate incred'ses. Flillnru¡-,.;

l|l¡brttt¡rr_È

I:,.,::.

¡¡rñtry-Ìr

2017 2018 20t9 2020 202t 2022

2023 Metrics

B PA Future Yea r I ncr: 4.O% pow er, 4.0 % tra nsmission

Preliminary 201"9 Capital Plan

. S0.5M under run eachyear 2O2O-2O23

2018 Load Forecast (2OL8-2O23)

BPA Spitl Surcharge impact included

Financial Policy uirements

Moody's 2014 Median Ra Fitch 2016 Median A+

t3l

eñ*k¡l4¡¡h

SLIDE 23

(2Or9.2OP,S)

BPA Power & Transmission

Description Power Transmission

As applied to Benton PUD

Annual $ Increase Annual %o Increase

4.oVo f.o.oYo

$9.5M 4.9y,

z.g%o

3.6Yo

$r.rM

L.SYo

,:.

Fti'uËl¡c

5¡3Çn¡"4ã

t4l

¡¡uk$kk¡ÈiË

.;]

SLIDE 24

füM

atus(2o19-2fJ,2,8)

terest Income

I

October Forecast Average Annual Investment Interest

2rJ-19-2023

$6ozk

Updated Forecast Average Annual Investment

Interest 2019-2023

$gozk

Increase / (Decrease)

$gook I year

t5l

SLIDE 25

(2Ore)

> Water forecast (as measured at the Dalles Ðam},

• Jan - July forecast around z5ü percentile
• Jan /Feb * less than,roth percentile

Effect on zoLg net power costs : ,

• 2|,or9 bud$et set at the ZS percentile
• Current 2or9 MtM $BS.4M

> Includes $6ook BPA reduction mentioned earlier

t (, ]

¿þWnmffi

SLIDE 26

>> Staff has updated forecasts with two variations to,review'

• Option A: May 2oLg Increase * z.4Yo

Option B: O,ct zoLg Increas€ * z'.4Yo-'

>) Staff Recommendation is.to move 2oug potentia,l increase to October

t7l

OHTOT

æ.4.0

¡e¡.&k.rd]¡N

SLIDE 27

Ð

2Ol.\ - 2Ol9 ùIrlI \-P(' + 2()2rO - 6õ(DurRrnentile

in Millions

5 6 7 8 9 10 72

LttS

5.9 {s q.t

4.(b l

3.13

E.q6"{ 3.78

1.38 1.45

s

624 :''.-*''.':

zt%,(

5

(

tgl" { _*.¿'i$ -

tn:{

1A%

!?.0 -:,

13

!4

15 16

l7

1.8 19

zo r -Pg9ig-lgl9d, cglt,o-r.r*çI Ds-po:its

2t Residential Bill Comparison

ñl qt-M qrgi¡ lRetail ler - Net

s s

118 5 1L8 l _ ,1rs_,

S A8i;.2 S

' '. f' , "

47.s 5 q6.t

lvsinc qyçI999,r,*9 9ction. Rate a cti on by cl ass .I9Y,Y?IY-:,-" 5 M.O f .u,4

ê I ì. :.: _: _ .i: ,: .: .i¡, ,i !

*Financial Forecasts are proiections only, District staff wilt continue to monitor aii¿ evaltuatè *e nèted lor ¡utiìre rate increases,

AssumDtions:

. Adopted 2019 Capital plan . $O.SVl under run eachyear 2O2O-2O23 . 2Ot8 Load Forecast (2018-20231 . BPA Spill Surcharge impact included . No BPACRACincluded . BPAFY2O/zI lncreãse: 2s%power,3.6 % transmission . Overall 1.5% increase as applied to Benton pUD . BPA Future Year lncr: 4.O/o power,4.0 % transm¡ss¡on

Signif icant Uncertainty Assu

• ns

2017 2018 20L9 2020 2021

2022 2023 Financial Policy Fitch 2016 Median A+ Moody's 2014 Metrics

20t7 2018 20L9 2020 202L 2022

2023

R

irements Median Ran

tBl

FI{I

t.7

$

s s s

• 35. 2
• 3. 3

s

1.9

, 5 '1.8

s 2.6

7,

2.6 3.9

lllfliü"är-¡c

5¡r.wER

tu.'*hç¡4|¡þ

SLIDE 28

lE)

2{)Ib-2{)I9 ÙIrtt IYFC' +'2¡O2O -, ?0/?È$lat 5Oü, Rrcent¡lef$rqc

1 2 4 5 6 7 8 9 10 11 72 1.3 74 15 16 17 18 19 20 2L

))

in Millions

• I"e!!g*!.rçrgegt þ¡cç¡tl_19, ". -.*.._ . .,., .i

Rate Action Effective Date

I

Revenue Rate Action çÊ_r,

t&p : .

Maximum of 38Yo

4Ùo/o

28%to29/o to

: Staffreaòmmenda tion:

.110r,. .,..., .,,.

186

: .'-..-.'''''-

• -l'.-

"-....-.-

*Financial Forecasts are projections only, District staff witl continue to manitor and evaluo

Oct 1 2.4%

Metrics

2077

2018 2019 2020 202t 2022

2023 Assumptions:

. Adopted 2019 Capital Plan . S0.5M under run each year 2O2O-2O23 . 2018 Load Forecast (2Ot8-2O23], . BPA Sp¡ll Surcharge impact included . No BPA CRAC included .

BP A N2O/2t I ncrease: 2.9%; power, 3.6 % transmission

. Overall 1.5% increase as applied to Benton pUD . BPA Future Year lncr: 4.O% powet,4.0 % transm¡ssion

9

Median Ra

e

Financial Policy

u irements

Moody's 201.4

Fitch 2016 Median A+

Füñf.ro e#ifnmilffiî

te the

SLIDE 29

totfi .20lghrcreafftuO

• Two full years since prêvious revenue

BPA record of decision won't be issued until July eorg

r BPA rate increase effective October 1, zoLg

.:.

• zoLg Water Year * too much uncertainty right now

ì:i

• 2oLg Legislative Session hasn't started

1' r': i

10

Hfw

ä-4.0

e.ss*k¡'ciø

SLIDE 30

> Staff Recommendation '

• Movê 2O1g revenue'increase to OCtober r

> Next Steps

• Monitori*g forecast (continúous)

COSA Presentation (February)

• Preparation for 2oL9 revenue increase

(Spring/Summer)

l: li : '

11

àffio: mffi

.;:

SLIDE 31

r)f

l2

lll!triüeL,c

tr¡?,çlVÊR

m¡,**¡q,s