HomeMy WebLinkAbout20180615PacifiCorp Final Report.pdfY ROCKY MOUNTAIN
BP,Iy,E^.R"-.
June 15,2018
VA OVERNIGHT DELIVERY
RECEIVED
?$18 JUi{ l5 ltt 9: l9
ii),\HU I-USLIC
.il il :l lr:ii CO}JMISSION
Diane Hanian
Commission Secretary
Idaho Public Utilities Commission
472 W. Washington
Boise, lD 83702
Re:CASE NO. GNR-U.18.01
INVESTIGATION INTO THE IMPACT OF FEDERAL TAX CODE REVISIONS
ON UTILITY COSTS AND RATEMAKING
Dear Ms. Hanian:
Please find enclosed an original and seven (7) copies of Rocky Mountain Power's Final Report
in the above referenced matter. Enclosed is a CD containing the non-confidential work papers.
Informal inquiries may be directed to Ted Weston, Idaho Regulatory Manager at (801) 220-
2963.
Very truly yours,
Pre
1407 West North Temple, Suite 330
Salt Lake City, Utah 84116
CERTIFICATE OF SERVICE
I hereby certify that on this l5th of June, 2018, I caused to be served via e-mail a true and
correct copy of Rocky Mountain Power's Final Report in Case No. GNR-U-18-01 to the
following:
Service List
IDAHO IRRIGATION PUMPERS ASSOCIATION, INC.
Eric L. Olsen
ECHO HAWK & OLSEN, PLLC
505 Pershing Ave., Ste. 100
P.O. Box 6119
Pocatello, Idaho 83205
E-mail: elo@echohawk.com
Anthony Yankel
12700 Lake Avenue, Unit 2505
Lakewood, Ohio 44107
E-mail: tony@yankel.net
MONSANTO COMPANY
Randall C. Budge
Racine, Olson, Nye & Budge, Chartered
P.O. Box 1391;201 E. Center
Pocatello, Idaho 83204- 1 39 I
E-mail : rcb@racinelaw.net
tjb@racinelaw.net
Brubaker & Associates
16690 Swingley Ridge Rd., #140
Chesterfield, MO 63017
E-mail : bcollins@consultbai.com
mbrubaker@consultbai.com
Katie Iverson
Brubaker & Associates
19540 N. Wessex Dr.
Surprise, AZ 85387
kiverson@consultbai. com
PIIC
Ronald L. Williams
Williams Bradbury, P.C.
P.O. Box 388
Boise ID, 83701
E-mail : ron@williamsbradbury.com
Jim Duke
Idahoan Foods
E-mail: iduke@idahoan.com
Kyle Williams
BYU Idaho
E-mail : williamsk@byui.edu
Val Steiner
Nu-West Industries, Inc.
E-mail : val.steiner@agrium.com
Bradley Mullins
1750 SW Harbor Way, Suite 450
Portland, OR 97201
E-mail : brmullins@mwanalytics.com
Page 1 of2
PACIFICORP, DBA ROCKY MOUNTAIN POWER
Ted Weston
PacifiCorp, dba Rocky Mountain Power
1407 West North Temple
Suite 330
Salt Lake City, uT 841l6
E-mail : ted.weston@oacifi corp.com
Data Request Response Center
PacifiCorp
825 NE Multnomah, Suite 2000
Portland, OFt97232
E-mail : datarequest@pacifi corp.com
Dated this l5th day of June,20l8.
Ve,.
Katie Savarin
Coordinator, Regulatory Operations
Page2 of2
Yvonne R. Hogle (#8930)
1407 West North Temple, Suite 320
Salt Lake City, Utah 84116
Telephone: (801 ) 220-4050
Facsimile : (80 l) 220 -3299
Email : wonne.hoele@l'tacifi corp.com
f?ECEIVED
?018 JUri l5 AFI 9r 20
qtrF-. tt,nl l,-,"1i 1Lr l-iJDLlUl[:i C0[{MISSICN
Afforney for Rocky Mountain Power
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
INVESTIGATION INTO THE IMPACT
OF FEDERAL TAX CODE REYISIONS
ON UTILITY COSTS A}tD
RATEMAKING
CASE NO. GNR-U-18-01
FINAL REPORT
Rocky Mountain Power, a division of PacifiCorp ("Rocky Mountain Power" or "the
Company"), in accordance with Idaho Code $61-502, $61-503, and RP 052, respectfully submits
this final report ("Final Report") to the Idaho Public Utilities Commission ("Commission")
pursuant to a) Order No. 33965 through which the Commission initiated an investigation into the
impact of the federal income tax legislation enacted December 22,2017, titled An Act to Provide
for Reconciliation Pursuant to Titles II and V of the Concurrent Resolution of the Budget for Fiscal
Year 2018 ("Tax Reform Act"), and b) the all-party agreement ("Stipulation") filed in this docket
with the Commission May I 1, 2018, and approved by Order No. 34072.
This Final Report complies with paragraph 14 of the Stipulation which requires the
Company to provide a final report of the Tax Reform Act's net savings, including the calculation
of excess deferred federal income taxes associated with both protected and unprotected defened
tax balances. In accordance with the Stipulation, the Company must provide a reconciliation of the
treatment of the benefits from the Tax Reform Act, including a true-up of any under- or over-
allocation of customer credits.
The Company's initial report and the Stipulation in this docket has resulted in a rate
1
reduction of $8.385 million, or approximately 3 percent, beginning June l, 2018. Specifically, the
Company reduced rates by $6.185 million through Electric Service Schedule No. 197 - Federal
Tax Act Adjustment, which will be in effect until the tax savings are included in base rates in the
next general rate case, and by $2.2 million through Schedule No. 97 - Energy Cost Adjustment
Rate, enabled by a one-time credit of $3.4 million applied as an offset to the 2013 incremental
depreciation regulatory asset balance.
PROCEDURAL BACKGROUND
On or about December 22, 2017, Congress enacted the Tax Reform Act effective
January 1,2018. In response, the Commission initiated this investigationl into the impact of the
federal tax code revisions on utilities'costs and ratemaking. On March 30,2018, in compliance
with Order No. 33965, the Company filed an application ("Report") proposing immediate deferral
of all savings associated with the Tax Reform Act and authorization to decrease rates by
$2.8 million effective June 1,2018.
With the intent of resolving the issues raised by parties as a result of the Company's
proposal in the Report, the parties met on April 30,2018 for settlement discussions, which led to
execution of the Stipulation that was approved by the Commission May 31,2018, pursuant to
Order No. 34072.
Consistent with the Stipulation, the Company provides this Final Report of the Tax Reform
Act's net savings, and a reconciliation of the accounting for the benefits from the Tax Reform Act.
The Final Report gives parties an opportunity to review the Tax Reform Act balance that remains
after accounting for the ongoing $6.185 million reduction to rates and the $3.4 million one-time
offset approved by Commission Order No. 34072. It also allows parties to respond to the
2
I Case No. GNR-U-18-01 Order No. 33965
Company's proposed ratemaking treatment for the remaining net Tax Reform Act benefits.
OVERVIEW OF THE TAX REFORM ACT
The Tax Reform Act was enacted December 22,2017, with the majority of the provisions
becoming effective January 1,2018. In general, the most notable items affecting the Company's
annual revenue requirement include:
o The federal corporate income tax rate reduction from 35 to 2l percent;
o The requirement to normalize excess deferred income taxes associated with public
utility property utilizing the average rate assumption method ("ARAM");
. The elimination of the allowance for bonus depreciation for public utility property;
o The repeal of the domestic production activities deduction (section 199);
o The repeal of the deduction and imposition of certain limitations with respect to
certain expenditures;
o A reduction to third-party wheeling revenues due to the change in the corporate
income tax rate; and
o The impact of the reduced tax gross-up on Production Tax Credits ("PTCs").
ESTIMATED REVENUE REOUIREMENT IMPACTS
To comply with the March 30,2018 filing requirement2 for the Company to provide the
revenue requirement impact of the federal tax code changes, the Company initially provided a
preliminary estimate using the 2016 Normalized Results of Operations in its Report. By the time
settlement discussions were held April 30,2018, the Company had completed the 2017
Normalized Results of Operations and updated its original estimate therewith. Both estimates were
calculated using a "price change" approach in which the Company reduced revenues to reflect the
J
2 Order No. 33965
lower revenue requirement while maintaining the same earned return on equity before accounting
for the change to the corporate income tax rate.
Some of the revenue requirement impacts associated with Tax Reform Act (normalization
of excess deferred income tax including the repeal of the domestic production activities deduction,
imposition of limitations on the deductibility of certain expenditures, and the impact on wheeling
revenues) were not included in either estimate in the Report because they were more complex or
required additional guidance or information to calculate. However, consistent with the Stipulation,
this Final Report provides a complete calculation of all the impacts of the Tax Reform Act.
The Company calculated the impacts by comparing the 2017 Results of Operations under
the old federal tax rate of 35 percent with the new federal tax rate of 2l percent, attached as
Exhibit l. The results are summarized in Table I below:
TABLE 1
To prepare the comparison, the Company modified its2017 Results of Operations to
include all of the plant additions for 2018 to correctly calculate the impact the Tax Reform Act
will have on the Company (see Exhibit l, page 2), forming the starting point in Exhibit l. The
impacts associated with the elimination of the allowance of bonus depreciation for public utility
property will only impact future revenue requirement calculations as new property is placed into
service. The Company then made the following adjustments:
o Changed the federal tax rate,
4
Current Ta>es
\Meeling Rercnue Ofbet
ARAIvI Am ortization
TOTAL
$ Thousands !daho
$
$ 10,905
8,103
(514)
3,316
Tax lmpact
o Adjusted fortax related changes, such as the change in section 199, changes to
employees meals deductibility, and the elimination of the deduction for transit
passes (see Exhibit 1, page 3),
o Added in the ARAM amortization discussed below (see Exhibit l, page 4),
. Adjusted the accumulated deferred income tax balances (see Exhibit l, page 5),
o Adjusted wheeling revenues for the tax law impact on (see Exhibit 1, page 6).
Federal Coroorate Income Tax Rate Reduction
The reduction of the federal corporate income tax rate from 35 to 2l percent impacts the
Company's revenue requirement in three ways: First, it reduces current income taxes; second, it
creates a reduction to the accumulated deferred income taxes ("ADIT") liability; and third, it
reduces the Company's FERC Open Access Transmission Tariff ("OATT"), which reduces third-
party wheeling revenues.
Required Normalization of Excess Deferred Income Taxes
In addition to current income taxes, the Tax Reform Act also impacts three groups of ADIT:
protected property related items; non-protected property related items; and non-protected non-
property related items.
The decrease to the tax rate reduces the future ADIT liability by reflecting the lower income
tax rate that will be due when the temporary differences reverse. This reduction ("Excess Deferred
Income Taxes") was calculated by measuring the temporary differences at the new combined
federal and state statutory income tax rate compared to the ADIT balance existing under the old
statutory income tax rate. The Excess Deferred Income Taxes were recorded to a regulatory
liability resulting in no immediate net change to the rate base upon which the Company earns a
return.
5
The treatment ofthe regulatory liability associated with property-related timing differences
is governed by normalization rules. The Tax Reform Act provides that Excess Deferred Income
Taxes on public utility properly (e.g., temporary differences that result from different depreciation
methods and lives) or protected property related ADIT must be normalized using the average rate
assumption method ("ARAM") of accounting.s Under the ARAM, the public utility identifies the
reversal pattern (book depreciation turnaround vs. tax depreciation turnaround) and reverses the
Excess Deferred Income Taxes beginning when the turnaround occurs over the remaining book
life through regulated operating expense. Thus, while excess ADIT was calculated based on
balances at the time of the enactment of the rate change that excess would not begin to reverse
until book depreciation exceeds tax depreciation.
The Company also has non-protected property related Excess Deferred Income Taxes.
While the Tax Reform Act does not require that non-protected property related to Excess Deferred
Income Taxes be normalized using ARAM, the Company has historically treated it that way and
proposes that treatment continue. In part, this is due to the configuration of the Company's
property-related tax system, PowerTax, which presently uses ARAM to amortize all Excess
Deferred Income Taxes included in the system, protected and non-protected.
The non-protected non-property Excess Deferred Income Taxes are not subject to the
income tax normalization rules imposed by the Tax Reform Act and can be used to satisfy other
regulatory assets or deferred and amortized over a period prescribed by the regulatory jurisdiction.
Based on the 20 I 7 Norm alized Results of Operations, the impact of the Tax Reform Act on the
3 Violations of the income tax normalization provisions associated with public utility property would result in (i) a
prohibition against the public utility's claim to accelerated depreciation with respect to all public utility property and
(ii) imposition of an additional tax on the public utility wherein the tax for the taxable year will increase by the amount
by which it reduces its excess tax reserve more rapidly than permitted under a normalization method of accounting.
6
non-protected non-property related Excess Deferred [ncome Taxes was $46.5 million total-
Company and $1.2 million for Idaho. Idaho includes actual cash payments rather than accruals for
pension expenses reducing its non-protected non-property Excess Deferred Income Taxes. The
Company is proposing a five-year amortization of this balance beginning with the next general
rate case.
The Excess Deferred Income Tax balances and amortization expense included in the filing
are shown in Tables 2 and 3 below.
TABLE 2
TABLE 3
OFFSETTING IMPACT TO FERC OATT
The net impact of the Tax Reform Act was a reduction to the Company's overall revenue
requirement. This also applies to the transmission revenue requirement used for its FERC OATT.
The reduction to the transmission revenue requirement reduces the FERC OATT, which reduces
7
Property Related
Protected
Non-Protected
Non-Property Related
TOTAL
$ Thousands ldaho
$
$ 1,637,36E $ 90,690
Total
Company
$ 1,331,532
259,302
46,534
77,448
12,017
1,215
Property Related ARAITI (includes
protected & Non-protected Propefi)
Non-Propefi Related (1)
TOTAL
$ Thousands Idaho
$ 2,6s4
$ 2,654
Excess Deferred lncome Tax Balance as of December 31, 20tB
Excess Deferred lncome Tax Amortization
lncluded in Filine
the amount of transmission wheeling revenues collected from third-party users of the Company's
transmission system. This reduced Idaho allocated wheeling revenues by $0.5 million, which is
netted against the overall savings shown in this report.
TAX IMPACT ON PRODUCTION TAX CREDITS
The Internal Revenue Code ("IRC") provides that a wind facility will generate PTCs equal
to an inflation-adjusted 1.5 cents per kilowatt hour of electricity that is produced and sold to a
third-party for a period of l0 years, beginning on the date the facility is placed in-service for
income tax purposes.a
The annual amount of PTCs passed on to customers is based on three factors: 1) the
megawatt-hours of energy produced at the qualifring wind facilities; 2) the inflation-adjusted IRS
rate; and 3) the Company's tax gross-up rate. The Company's wind facilities were placed in-
service in 2006 through 2010. Thus, beginning in 2016 as the first qualifying wind facilities
reached their I 0-year anniversary from their initial in-service date, the energy produced from those
wind facilities no longer qualified for PTCs. The number of qualifying wind facilities continues to
decline each year as they reach the 10-year anniversary from their initial in-service date. Due to
both the volatility of megawatt-hours produced from the wind facilities and the approaching end
of the qualification period for each of the wind facilities, the Commission authorizeds tracking
PTCs in the Energy Cost Adjustment Mechanism ("ECAM").
The Tax Reform Act reduces the Company's tax gross-up rate applied to PTCs from
l.6l percent to 1.33 percent, which reduces the value of the PTC customers receive in rates from
$1.99 per MWH to $1.75 per MWH, based on the PTCs included in the 2017 Normalized Results
of Operations. Beginning January 1,2018, the PTC rate willchange from $1.99 to $l .75 per MWh
4IRC section 45(a).
s Order No. 33440 in Case No. PAC-E-15-09 page 6.
8
to reflect that a portion of the PTCs have been adjusted for the current tax gross-up rate, Exhibit 2
provides the calculation of the new PTC rate.
PROPOSED ACCOUNTING TREATMENT FOR RATE STABILIZATION
Based on the 2017 Normalized Results of Operations, the net revenue requirement impact
of the Tax Reform Act is $10.9 million. Consistent with the Stipulation, $6.185 million will be
returned to customers through Schedule 197, $3.3 million is subject to ARAM, leaving
approximately $1.4 million per year which the Company proposes to defer into a regulatory
liability to be used to offset regulatory assets like the 2013 incremental depreciation balance, Deer
Creek closure costs, or other future customer expenses such as the 201 8 depreciation study.
Gradualism and rate stability are longstanding ratemaking principles recognized by this
Commission in setting rates. The Company's proposal to pass $9.485 million annually ($6.185
million plus $3.3 million), represents 87 percent, of the benefit to customers now and defer the
remaining $1.4 million into a regulatory liability better aligns with those principles. Reducing rates
by the full balance of the Tax Reform Act benefits would provide interim reductions, only to leave
customers facing greater upward pressures on rates a short time thereafter. Significant changes in
customer rates downward then upward in a matter of a few years does not meet the principle of
gradualism, and does not promote rate stability. The Company proposes that a deferred regulatory
liability and the Company's proposed ratemaking treatment provides for responsible accounting
treatment that willprovide customer benefits ofthe Tax Reform Act through lower and more stable
rates, as set forth in the example of the proposed deferral shown in Exhibit
IMPACT TO CREDIT RATING
Fitch, S&P, and Moody's have all issued reports suggesting that the tax law changes may
have the potential to negatively impact utility company credit metrics. Deferring part of the
9
reduction will allow more time to analyze these impacts and adjust capital structure levels, as
appropriate. At face value, it is easy to assume that the primary impacts on the Company of the
Tax Reform Act and its reduction of corporate rates from 35 percent down to 2l percent are
entirely positive, but a closer analysis shows there are negatives in the case of regulated public
utilities. A January 2018 report from The Brattle Group ("Brattle Tax Report") discusses several
of these adverse effects.6
The Brattle Tax Report demonstrates that coverage ratios for utilities will tighten as
eamings before interest and taxes ("EBIT") and earnings before interest, taxes, depreciation and
amortization ("EBITDA") decrease, EBIT and EBITDA interest coverage is lowered and EBITDA
to debt is also lowered. These reduced coverage ratios potentially result in ratings downgrades
which may increase utilities' borrowing costs. The report goes on to show that utilities' realized
earnings volatility is increased by a lower tax rate because the "cushion" provided by the impact
of taxes on utility rates becomes smaller. This will make earnings more sensitive to reductions to
EBITDA as the offsetting tax benefit goes from a 35 percent rate to a2l percent rate. The Brattle
Tax Report also states that cash flows may be deferred due to a lower tax rate on depreciation
timing differences.
The same impacts noted in the Brattle Tax Report led Moody's Investor Service
("Moody's") to lowerthe outlook for24 regulated utilities on January 19,2018 based primarily
on the Tax Reform Act's impacts on cash flows. On January 24,2018, just after issuing its revised
negative outlooks, Moody's, issued a Sector Comment for regulated utilities in the US entitled
"Tax reform is credit negative for sector, but impacts vary by company." The comment cited many
3 See The Brattle Group, "Six Implications of the New Tax Law for Regulated Utilities", January 2018 (available at
http://files.brattle.com/files/1301 l-six-implications oLthe-new-tax-law-for-reeulated-utilities.pd0.
l0
of the same adverse impacts raised in the Brattle Tax Report, noting that while tax reform is neutral
for utility earnings it is negative for cash flow and further noting that cash flow to debt ratio could
decline by 150-250 basis points.
While the Company has not had its outlook revised to negative, the adverse impacts
discussed by Moody's and The Brattle Group will likely impact the Company if all benefits are
refunded to customers immediately. Deferring part of the reduction to rates to offset future rate
increases will ease some of these negative impacts, and allow more time for the Company, the
Commission and the other parties to analyze the impacts and reach a solution that keeps the
Company financially healthy. Deferring the remaining balance of the Tax Reform Act into a
regulatory liability and allowing the Company to offset known cost increases discussed gives the
Company time to better consider potential adverse impacts from the Tax Reform Act and to adjust
its capital structure as appropriate to account for them.
REOUEST FOR RELIEF
Gradualism and rate stability are longstanding ratemaking principles recognized by this
Commission in seffing rates. The Company's proposal to pass 87 percent of the benefit to
customers now and defer the remaining balance to a regulatory liability is intended to support these
same principals and is responsible accounting treatment. The Company's proposed ratemaking
treatment will provide customer benefits of the Tax Reform Act through lower and more stable
rates and support the Company's current credit rating.
DATED this l5th day of June,2Ol8.
RESPECTFULLY SUBMITTED,
MO
R. Hogle
ll
General Counsel
EXHIBIT I
Revenue Requirement Impact - Tax Rate Change
Rocky Mountain Power
Revenue RequiEment lmpact - Tar Rate Change
RESULTS OF OPERATIONS SUMMARY
Exhibit 1 Page 'l
21016 TAX RATE
DECEMBER 2017
NORMALIZED RESULTS
tolxct'
DECEMBER 2017
NORMALIZED RESULTSl
IDAHO
TOTAL
TOTAL
CURRENT TAX OFFSET
1
2
3I
5
6
7
I
9
10
11
12
14
15
16
17
1E
t9
20
21
22
23
21
25
26
28
29
30
31
33
3,1
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
6'l
62
63
64
65
Operating Revenues
lnterdepadmental
Special Sales
Oher OpeEting Rewnues
Operating Expenses:
Steam Production
Nuclear Production
Hydrc Produclion
other Power supply
Transmission
Distribution
Customer Ac@unting
Customer SeM@ & lnfor
Sales
Operating Revenue for Retum
Rate Base:
Electric Planl in SeMce
Plant Held for Future Use
Misc Deferrcd Oebits
Elec Plant Acq Adj
Pensions
Prepayments
Fuel Slock
Material & Supplies
Wo.king Capital
Weatherization Loans
Mis@llaneous Rate Base
278,539,915
0
28,641,606
9,499,302
513,983
0
0
(s11,924\
267,635.233
0
28,641,606
8.987,379
102,60E)(6,
(8,102,608)
(10,489)
0
0
0
(3,316.058)
0
0
(3316^O5E)
(4,293)
o
0
(9.1'r9)
(675,640)
(1s3,014)
(2,553,891)
0
(3,495,957)
179,E99
305.264,218316,680,824 2,060
70,928,509
0
2,674,996
75,549,044
'12,913,866
10,936,574
4,542,613
't60,1 10
0
7,907,361
70,928,509
0
2,674,996
75,549,0,14
12,913,866
10,936,574
4,52A,497
160,1 10
0
7.907,381
0
0
(4,293)
185,613,093 00,489)1E5,596,977
Deprcciation
Amodization
Taxes OtherThan lncome
lncome Taxes - Federal
ln@me Taxes - State
lnmme Tdes - Def Net
lnvestment Tax Credit Adj.
41,078,81 3
3,831,300
9,873,361
3,720,069
907,657
12,610,002
(439.790)
(6,721)
0
0
(22,282)
(322,703)
532,021
(8,567,639)
0
257.187.784
59.493,040
0
(8,391.092)
2EE.4E4
0
0
1,413
(3)
(1)
0
0
0
41.078,813
3,831,300
9,843,373
2,721,722
1,286,664
1,348,472
(439,790)
(6,721)
2,076
__119r
1,690,932,850
(0)
21,863,4E6
E22,391
0
2,886,288
'1 1,878,959
13,727 ,710
1,267,654
1,687,023
0
1.745,0E6,360 4,'t t0 (236)
(554,286,183)
(33,988,970)
(262,095,165)
c/3.s02)
(r,763,371)
0
(15,243,459)
0
0
(867,450,650)4,251.577 2,653.89'l
877.635,710 4,255 688 (236) 2.653.860
4,
0
0
0
0
0
0
0
0
(236)
0
0
0
0
0
0
0
0
0
0
(31)
0
0
245.302,810
59.961.408
1,690,932,850
(0)
21,883,486
422,391
0
2,886,288
11,E78,959
13,727,710
1,271,497
1,687,023
0
1,745,090,203
(ss4,286,183)
(ss,988,970)
(255,189.696)
(73,502)
(1,763,371)
0
(15,243,459)
(860,545,181)
88/,,545,022
Rate Base Dedudionsl
A@um Prov For Oepr
(31)
2,653,89'l
00
110
0
0
,577
0
0
0
A@um Def lncome Taxos
Unamorlized ITC
Customer Adv for Consl
Customer Service Deposits
Misc. Rate Base Oeduclions
Total Rate Base
1,251
6.779%
8.208%
6.779%
a.208toRetum on Equity
Footnolaa:
act. Please rcferto Etibil 1 pege 2.
(2) RefertoRAMDec20lTResultslO-21%andJAMDec20lTResultslD-21%modelsandlDworkpapec-21%.
TOTAL
ARAM
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Exhibit 1 Page 2
Rocky Mountaan Power
Reyenue Requhrment lmpac{ - T.r Rate Change
RESULTS OF OPERATIONS SUMMARY
Descrlption of Account Summary:
DECEMBER 2017
FILED RESULTS
IDAHO loJUstEDl
DECEMBER 2017
NORMALIZED RESULTS
IDAHO
I
2
4
5
6
7
I
't0
11
12
t3
14
16
17
't8
19
20
21
23
25
26
27
28
29
30
31
u
35
36
38
40
11
42
43
44
45
46
47
48
49
50
5'l
52
53
54
56
57
5E
59
60
61
62
63
64
Operating Revenues
lnterdepartmental
Special Sales
Other Operating Revenues
Ope6ting Exp€nses:
Steam Produdion
Nuclear Produalion
Hydro Prcduction
Other Power Supply
Transmission
Dislrihnion
Customer A@our(ing
customer SeMce a lntor
Sales
278,539.915
0
28,641,6@
9,499,302
27E,539,915
0
28,641,606
9,499.302
0
0
0
0
316,680,824 0 316,6E0,824
70,928,509
0
2,674,995
75,549,044
'12,913,866
10,936,574
1,142,613
160,1 10
0
70,92E,509
0
2,674,996
75,549,0,14
12,9r3,866
10,936,574
4.542,613
,60.1 t0
0
7,907,381
0
0
0
0
0
0
0
0
0
07,907,381
1 85,613,093 185,613.093
Oepreiation
Amortization
Taxes Other Than lncome
Rate Base:
Elgc{ric Plant in Senice
,r0,569,404
3,807,S07
9,873,361
9,373,979
1,675,930
6,896,682
(439,790)
(6,721)
509,409
23.393
0
(5,653,910)
(768,273\
5.713,320
o
0
41.078,813
3,831,300
9,873,361
3,720,069
907,657
'r2,610,002
(439,790)
(6,7211
lncome Taxes - Def Net
lnvestment Tax Credit Adj.
Misc Rerenue & Expense
Operating Revenue for Retum
257,363,845 (176.061)
59,316,980 176.061
257,187.784
59,493,040
1.655.736,461
(0)
21,883,4E6
822,391
0
2,E86,288
11,878,959
13.727,710
't,279,68E
1,687,023
0
35,196,3E9 r,690,932,850
(0)
21,EE3,486
822,351
0
2,886,288
, r.E78,959
13,727,7't0
1,267,654
1,687,023
0
Misc Defered Oebits
Elec Plant Acq Adj
Pensions
PEpayments
Fuel Stock
Material & Suppli€3
Working Capital
Wsatherization Loeng
Ratg Base Oeductions:
Accum Prov For DePr
Accum Prov ForAmort
Accum O6f lncomo Taxes
Unamortized ITC
CuslomerAdvior Const
Customer SeMce Doposits
Misc. Rats Base Oedus{ions
Total Rate Base
(12,035)
0
0
1,709.902,005
(553,776,774)
(33,965,577)
(2s9,055,,r50)
(73,502)
(1,763,371)
0
(15.243,459)
35,'t84.355 1.745.086.360
(s09,409)
(23,393)
(3,039,715)
0
0
0
0
(554,286,183)
(33,988,970)
(262,095,165)
(73,502)
(1,763,371)
0
(15,243,459)
(863,878,1 33)(3,572,5r7)(867,450,650)
u6,023,a72 31.611.838 877,635,710
7.011%
8.660%
6.779%
A.20ao/oRetum on Equity
Footnotea:
(1) TheDeember20lTNomalizedResultsofOpe.ationswererevisedftomthefilsdDe@mber20lTRrsultsofOpeEtionsbyaddingtheiollowingadjustments;c)therCEpital
Additions,DoprecationE)eenseandResre,AFUDCEquity,andtdchangesonthe MajorPlantAdditions.PleaserefsrtoRAMOec20lTResultslO-35%,theJAMDec2017
Resuhs lO - 35%, and the lO work p8p€r3 -35%.
0
0
0
0
0
0
0
Exhibit 1 Page 3
WORK PAPER ADJUSTMENT PAGE NO, 7.7Rocky mountain Power
ldaho Results of Operations - December 2017
Tax Deductible ltems - New
Adjustment to Tax:
Schedule M Deduction - Sec. 199
Schedule M Deduction - Sec. 199
Sch M Add - Meals & Entertainment
Sch M Add - Meals & Entertainment
Sch M Add - Transit Pass
ACCOUNT Tvoe
SCHMDP 3
SCHMDP 3
SCHMAP
SCHMAP
SCHMAP 3
TOTAL
COMPANY
IDAHO
FACTOR FACTOR % ALLOCATED REF#
SG
SE
SO
SE
SO
c
3
(34,219,097)
(1,620,786)
731.873
22,879
343,380
6.221%
6 466%
5.953%
6.466%
5.953%
(2,1 28,639)
(1 04,807)
43,568
1,479
20,441
the December 201 7 results of operations to reflect ongoing tax expense as a result of the changes from the Tax Cuts and Jobs Act of 201 7 signed on
December22,2olTwilhaneffectivedateofJanuaryl,20l8. lncludedalsoisanaddbackforthetransitpasscostsprovidedforemployeesthatareno
longer tax deductible.
anremoves a expense
Rocky Mountain Power
ldaho Results of Operations - December 2017
ARAM Adjustment - NEI
Adjuatment to Tax:
Add 201 8 ARAM Amount
Add 201 I ARAM Amount
Add 201 I ARAM Amount - Bridger Coal
Add 2018 ARAM Amount - Bridger Coal
Exhibit 1 Page 4
WORK PAPERADJUSTMENT PAGE NO, 7.9
IDAHO
FACTOR FACTOR % ALLOCATED REF#ACCOUNT Tvoe
411 10
282
41110
282
TOTAL
COMPANY
t
J
3
3
(2,540,21e)
2,540,219
(113,672)
113,672
1 00.000%
100.00002
1 00.000%
1 00,000%
(2,540,21e)
2,540,219
(113,672)
113,672
ID
ID
ID
ID
property and non-protected property using the average rate assumption method (ARAM)
Also,
This adjustment provides an annual amortization of the accumulated deferred income taxes related to the change in federal tax rate of the protected
property and non-protected property using the average rate assumption method (ARAM) for Bridger Coal Company.
an
Exhibit 1 Page 5
WORK PAPERADJUSTMENT PAGE NO, 7.8Rocky Mountain Power
ldaho Results of Operations - December 2017
Deferred lncome Tax - New
Adjustment to Tax:
Restate DIT @24.58660
Remove DIT Attributed to Flow Through
of
ACCOUNT Tvoe
41010
41010
J
c
TOTAL
COMPANY FACTOR FACTOR%
(1,154,165) lD 100.000%
(734,855) tD 100.0000%
IDAHO
ALLOCATED REF#
(1,1 54,165)
(734,855)
ARAM associated with flow through taxes. The full impact of the ARAM will be captured under a separate ARAM adjustment.
removesexpensethe new tax rate. This
Exhibit 1 Page 6
Rocky Mountain Power
ldaho Results of Operations - December 2017
Tax lmpact on Wheeling Revenue - NEW
WORK PAPERADJUSTMENT PAGE NO. 3.5
ACCOUNT Tvoe
TOTAL
COMPANY FACTOR FACTOR%
sG 6.2210A
IDAHO
ALLOCATED REF#
(511 ,924)
AdJustment to Revenue:
Other Electric Revenues 456 3 (8,229,471)
Adjustment Detail:
Adjusted Vvheeling Revenues 12 ME December 2018
lmpact of Tax Rate Change
Adjusted Wheeling Revenues 12 ME December 2018
103,558,626
(8,22s,471)
95,329,1 56
of
in the transmission rate due to
EXHIBIT 2
Production Tax Credit Base Rate
ldaho Energy Cost Adjustment Mechanism
Production Tax Credit Base Rate
GNR-U-18-01
Base PTCs - PAC-E-15-09
1 TotalCompany PTCs in Rates
2 lD SG Allocation Factor
3 ldaho Allocated PTCs in Rates
4 Annual ldaho Base Load @ meter (M\Nh)
5 lD Allocated PTCs in Rates ($/M$lttl
Base PTCs - GNR-U-18-01
PTC in GNR-U-18-01 Before Tax Gross-up
Net to Gross factor = (1/(1-tax rate))
Base Amount Updated for New Tax Rate
lD SG Allocation Factor from GNR-U-18-01
lncluded in GNR-U-1 8-01
ldaho Allocated PTCs in Rates
Annual ldaho Base Load @ meter (M\/Vtt)
lD Allocated PTCs in Rates ($/MWh)
PAC-E-15-09
$ (115,633,069)
6.0063%
($6,945,269)
3,483,480
$(1.es)
Exhibit 2
PAC-E-i5-09 GNR-U-18-01
$ (47,5s5,547) $ (47,555,547)
'r.61 16 1.3260
$(76,641,923) $
6.22060/o
(63,058,655)
6.22060/o
$ 844,961 $ (4,767,587) $ (3,922,627)
($6,100,308)
3,483,480
$(1.75)
Federal/State Combined Tax Rate
Net to Gross factor = (1/(1-tax rate))
37.95',1o/o
1.6116
24.587o/o
1.3260
EXHIBIT 3
Estimated Federal Tax Impact Deferral and Amortization Table
Rocky Mountain Power
Estimated Federal Tax lmpact Deferral and Amortization Table
State of ldaho
$ - Thousands
Deferral
Exhibit 3
Ref
(2)
Current Tax.
\Mreelino. ARAM1 Offsets Total Deferred(
Annual Refund
$6,1 85
Refund
Jan-1 8
Feb-1 8
Mar-18
Apr-'18
May-18
Jun-1 8
Jul-18
Aug-18
Sep-18
Oct-18
Nov-1 8
Dec-18
Total
Beoinninq Balance
$-
909
1,817
2,726
3,635
4,544
1,512
1,905
2,299
2,692
3,085
3,478
515
515
515
5t5
515
515
515
Endino Balance$ 909
1,817
2,726
3,635
4,544
1,512
1,905
2,299
2,692
3,085
3,478
3,872
o
(2,516)
909
ono
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
a
(3,42s\
909
909
909
909
909
909
3,872 $
4,265
4,658
5,052
5,445
5,838
6,232
6,625
7,018
7,412
7,805
$r0,905 $
$
(3,425) $
$
7,480 $3,608 $3,872
4,265
4,658
5,0s2
5,445
5,838
6,232
6,625
7,018
7,412
7,805
8,1 98
8,985
9,378
9,771
1 0,1 65
't0,558
10,951
11 ,345
11,738
12,131
12,525
12,918
13.31 'l
Jan-19 $
Feb-'19
Mar-19
ApFl9
May-19
Jun-1 I
Jul-19
Aug-'19
Sep-1 9
Oct-19
Nov-19
Jan-20 $
Feb-20
Mar-20
Apr-20
May-20
Jun-20
Jul-20
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
909
515
515
515
515
5't5
5't5
515
515
515
515
515
Dec-1 9
Total $ 10,90s$ $ 10,905 $ 6,185 $ 8,s91
8,591 $
8,985
9,378
9,771
'10,165
10,558
'10,951
11,345
11,738
12,131
12,525
12,918
909
909
909
909
909
909
909
909
909
909
909
909
5't5
515
515
515
515
515
515
515
515
515
515
515
909
909
909
909
909
909
909
909
909
909
909
909
$$$
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Total $10,90s $$10,905 $6,185 $13,3't I
(1)
(2)
See Exhibit 1 page 1 line 2 for detail of the $10.9 million.
lncludes $3.425m offsetforthe 2013 depreciation study, effective June 2018. The settled cash refund of$6.185m is effective June 2018