20230201Schultz Exhibit 4 Schedule 1-2.pdf

DAVID J. MEYER VICE PRESIDENT AND CHIEF COUNSEL FOR
REGULATORY & GOVERNMENTAL AFFAIRS
AVISTA CORPORATION P.O. BOX 3727 1411 EAST MISSION AVENUE SPOKANE, WASHINGTON 99220-3727
TELEPHONE: [phone]
[e-mail]

BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION

IN THE MATTER OF THE APPLICATION ) CASE NO. AVU-E-23-01
OF AVISTA CORPORATION FOR THE ) CASE NO. AVU-G-23-01 AUTHORITY TO INCREASE ITS RATES ) AND CHARGES FOR ELECTRIC AND ) NATURAL GAS SERVICE TO ELECTRIC ) EXHIBIT NO. 4
AND NATURAL GAS CUSTOMERS IN THE )
STATE OF IDAHO ) KAYLENE J. SCHULTZ )

FOR AVISTA CORPORATION

(ELECTRIC AND NATURAL GAS)

AVISTA UTILITIES
IDAHO ELECTRIC RESULTS
TWELVE MONTHS ENDED JUNE 30, 2022
WITH PRESENT RATES WITH 09.2023 PROPOSED RATES
Actual Per Proposed Pro Forma
Line Results Total Pro Forma Revenues &Proposed
No.DESCRIPTION Report Adjustments Total Related Exp Total
a b c d e f
REVENUES
1 Total General Business $285,093 ($9,709)$275,384 $37,462 $312,846
2 Interdepartmental Sales 270 - 270 270
3 Sales for Resale 44,832 29,186 74,018 74,018
4 Total Sales of Electricity 330,195 19,477 349,672 37,462 387,134
5 Other Revenue 37,899 (16,688) 21,211 21,211
6 Total Electric Revenue 368,094 2,789 370,883 37,462 408,345
EXPENSES
Production and Transmission
7 Operating Expenses 119,142 15,809 134,951 134,951
8 Purchased Power 61,082 (24,480) 36,602 36,602
9 Depreciation/Amortization 21,579 2,154 23,733 23,733
10 Regulatory Amortization (6,152) 4,611 (1,541) (1,541)
11 Taxes 8,335 (282) 8,053 8,053
12 Total Production & Transmission 203,986 (2,188) 201,798 - 201,798
Distribution
13 Operating Expenses 18,132 (411) 17,721 17,721
14 Depreciation/Amortization 18,878 867 19,745 19,745
15 Taxes 6,884 (3,252) 3,632 3,632
16 State Income Taxes (89) 73 (16) - (16)
17 Total Distribution 43,805 (2,723) 41,082 - 41,082
18 Customer Accounting 3,824 264 4,088 67 4,155
19 Customer Service & Information 11,206 (10,754) 452 452
20 Sales Expenses - 0 0 0
Administrative & General
21 Operating Expenses 39,295 3,462 42,757 75 42,832
22 Depreciation/Amortization 19,681 3,683 23,364 23,364
23 Regulatory Amortization (4,612) 8,136 3,524 3,524
23 Taxes 2,389 - 2,389 2,389
24 Total Admin. & General 56,753 15,281 72,034 75 72,109
25 Total Electric Expenses 319,574 (120) 319,454 142 319,596
26 OPERATING INCOME BEFORE FIT 48,520 2,909 51,429 37,320 88,749
FEDERAN INCOME TAX
27 Current Accrual 2,289 442 2,731 7,837 10,568
28 Debt Interest - (524) (524) (524)
29 Deferred Income Taxes (7,212) 7,538 326 326
30 Amortized Investment Tax Credit (173) - (173) (173)
31 NET OPERATING INCOME $53,616 ($4,547)$49,069 $29,483 $78,552
RATE BASE
PLANT IN SERVICE
32 Intangible $111,236 $7,229 $118,465 $118,465
33 Production 511,691 42,015 553,706 553,706
34 Transmission 322,819 39,163 361,982 361,982
35 Distribution 703,038 98,838 801,876 801,876
36 General 149,885 18,801 168,686 168,686
37 Total Plant in Service 1,798,669 206,046 2,004,715 - 2,004,715
ACCUMULATED DEPRECIATION
38 Intangible (43,162) (15,407) (58,569) (58,569)
39 Production (233,431) (24,797) (258,228) (258,228)
40 Transmission (87,663) (13,303) (100,966) (100,966)
41 Distribution (261,608) (34,770) (296,378) (296,378)
42 General (55,395) (13,512) (68,907) (68,907)
43 Total Accumulated Depreciation (681,259) (101,789) (783,048) - (783,048)
44 NET PLANT BEFORE DFIT 1,117,410 104,257 1,221,667 - 1,221,667
45 DEFERRED TAXES (197,501) (2,985) (200,486) (200,486)
46 NET PLANT AFTER DFIT 919,909 101,272 1,021,181 - 1,021,181
47 DEFERRED DEBITS AND CREDITS (13,048) - (13,048) (13,048)
48 WORKING CAPITAL 26,672 133 26,805 26,805
49 TOTAL RATE BASE $933,533 $101,405 $1,034,938 $0 $1,034,938
09.2023 RY1
Exhibit No. 4Case Nos. AVU-E-23-01 and AVU-G-23-01

AVISTA UTILITIES
IDAHO ELECTRIC RESULTS
TWELVE MONTHS ENDED JUNE 30, 2022
WITH 09.2023 PROPOSED RATES WITH 09.2024 PROPOSED RATES
09.2023 09.2024 09.2024 09.2024 Proposed 09.2024 Pro Forma
Line Pro Forma Total Pro Forma Revenues &Revenues &Proposed
No.DESCRIPTION Total Adjustments Total Related Exp Related Exp Total
a b c d e f g
REVENUES
1 Total General Business $275,384 $0 $275,384 $37,462 $13,150 $325,996
2 Interdepartmental Sales 270 - 270 270
3 Sales for Resale 74,018 2,717 76,735 76,735
4 Total Sales of Electricity 349,672 2,717 $352,389 37,462 13,150 403,001
5 Other Revenue 21,211 1,528 22,739 22,739
6 Total Electric Revenue 370,883 4,245 375,128 37,462 13,150 425,740
EXPENSES
Production and Transmission
7 Operating Expenses 134,951 3,278 138,229 138,229
8 Purchased Power 36,602 5,231 41,833 41,833
9 Depreciation/Amortization 23,733 612 24,345 24,345
10 Regulatory Amortization (1,541) 246 (1,295) (1,295)
11 Taxes 8,053 454 8,507 8,507
12 Total Production & Transmission 201,798 9,822 211,619 - - 211,619
Distribution
13 Operating Expenses 17,721 704 18,425 18,425
14 Depreciation/Amortization 19,745 1,140 20,885 20,885
15 Taxes 3,632 249 3,881 3,881
16 State Income Taxes (16) - (16) - - (16)
17 Total Distribution 41,082 2,094 43,176 - - 43,176
18 Customer Accounting 4,088 183 4,271 67 24 4,362
19 Customer Service & Information 452 24 477 477
20 Sales Expenses - 0 0 0
Administrative & General
21 Operating Expenses 42,757 1,100 43,857 75 26 43,958
22 Depreciation/Amortization 23,364 1,100 24,464 24,464
22 Regulatory Amortization 3,524 (97) 3,427 3,427
23 Taxes 2,389 - 2,389 2,389
24 Total Admin. & General 72,034 2,103 74,137 75 26 74,238
25 Total Electric Expenses 319,454 14,225 333,679 142 50 333,871
26 OPERATING INCOME BEFORE FIT 51,429 (9,980) 41,449 37,320 13,100 91,869
FEDERAL INCOME TAX
27 Current Accrual 2,731 (2,096) 635 7,837 2,751 11,223
28 Debt Interest (524) (180) (704) (704)
29 Deferred Income Taxes 326 - 326 326
30 Amortized Investment Tax Credit (173) - (173) (173)
31 NET OPERATING INCOME $49,069 ($7,704)$41,365 $29,483 $10,349 $81,197
RATE BASE
PLANT IN SERVICE
32 Intangible $118,465 $1,479 $119,944 $119,944
33 Production 553,706 12,315 566,021 566,021
34 Transmission 361,982 13,957 375,939 375,939
35 Distribution 801,876 46,325 848,201 848,201
36 General 168,686 9,380 178,066 178,066
37 Total Plant in Service 2,004,715 83,456 2,088,171 - - 2,088,171
ACCUMULATED DEPRECIATION
38 Intangible (58,569) (3,359) (61,928) (61,928)
39 Production (258,228) (12,495) (270,723) (270,723)
40 Transmission (100,966) (7,464) (108,430) (108,430)
41 Distribution (296,378) (16,406) (312,784) (312,784)
42 General (68,907) (6,980) (75,887) (75,887)
43 Total Accumulated Depreciation (783,048) (46,704) (829,752) - - (829,752)
44 NET PLANT BEFORE DFIT 1,221,667 36,752 1,258,419 - - 1,258,419
45 DEFERRED TAXES (200,486) (1,893) (202,379) (202,379)
46 NET PLANT AFTER DFIT 1,021,181 34,859 1,056,040 - - 1,056,040
47 DEFERRED DEBITS AND CREDITS (13,048) - (13,048) (13,048)
48 WORKING CAPITAL 26,805 - 26,805 26,805
49 TOTAL RATE BASE $1,034,938 34,859 $1,069,797 $0 $0 $1,069,797
50 RATE OF RETURN 4.74%3.87%7.59%
09.2024 RY2
Exhibit No. 4Case Nos. AVU-E-23-01 and AVU-G-23-01K. Schultz, Avista
AVISTA UTILITIES
Calculation of General Revenue Requirement
Idaho - Electric System
RY1 RY2
Incremental RY2
Sep-23 Sep-24 Sep-24
Line (000's of (000's of (000's of
No.Description Dollars)Dollars)Dollars)
1 Pro Forma Rate Base $1,034,938 $1,069,797
2 Proposed Rate of Return 7.59%7.59%
3 Net Operating Income Requirement $78,552 $81,198
4 Pro Forma Net Operating Income $49,069 $41,365
5 Net Operating Income Deficiency $29,483 $39,833 $10,350
6 Conversion Factor 0.78701 0.78701 0.78701
$37,462 $50,613 $13,150
8 Total General Business Revenues $275,654 $313,116
13.59%4.20%
10 Total Billed Revenues $255,635 $293,097
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
Proposed:
Total Debt 50.00%4.92%2.46%
Common 50.00%10.25%5.13%
Total 100.00%7.59%
AVISTA UTILITIESPro Forma Cost of CapitalIdaho - Electric System
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
Line
No.Description Factor
1 Revenues 1.000000
Expenses:
2 Uncollectibles 0.001795
3 Commission Fees 0.001995
4 Idaho Income Tax 0.000000
5 Total Expenses 0.003790
6 Net Operating Income Before FIT 0.996210
7 21% Federal Income Tax @ 21%0.209204
REVENUE CONVERSION FACTOR 0.787006
AVISTA UTILITIES
Revenue Conversion Factor
Idaho - Electric System
TWELVE MONTHS ENDED JUNE 30, 2022
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES Rate Year September 1, 2023 - August 31, 2024
IDAHO ELECTRIC RESULTS
TWELVE MONTHS ENDED JUNE 30, 2022
(000'S OF DOLLARS)
Results of Accumulated Deferred Debits,Working Restate Eliminate Uncollectible Regulatory Injuries FIT/DFITLineOperations Deferred FIT Credits & Reg Capital Capital B & O Expense Expense and ITC/PTCNo.DESCRIPTION Rate Base Amortizations 06.2022 EOP Taxes Damages Expense1.00 1.01 1.02 1.03 1.04 2.01 2.02 2.03 2.04 2.05E-ROO E-ADFIT E-DDC E-WC E-RCAP E-EBO E-UE E-RE E-ID E-FIT
1 Total General Business $285,093 $0 $0 $0 $0 ($3,756)$0 $0 $0 $02Interdepartmental Sales 270 - 0 - - - 0 0 0 - 3 Sales for Resale 44,832 - 0 - - - 0 0 0 - 4 Total Sales of Electricity 330,195 0 0 0 0 (3,756)0 0 0 05Other Revenue 37,899 - 0 - - - 0 0 0 - 6 Total Electric Revenue 368,094 0 0 0 0 (3,756)0 0 0 0
EXPENSES Production and Transmission
7 Operating Expenses 119,142 - 56 - - - 0 0 0 -
8 Purchased Power 61,082 - 0 - - - 0 0 0 -
9 Depreciation/Amortization 21,579 - 0 - - - 0 0 0 -
10 Regulatory Amortization (6,152)- 0 - - - 0 0 0 -
11 Taxes 8,335 - 0 - - - 0 0 0 - 12 Total Production & Transmission 203,986 0 56 0 0 0 0 0 0 0
Distribution 13 Operating Expenses 18,132 - 0 - - - 0 0 0 - 14 Depreciation/Amortization 18,878 - 0 - - - 0 0 0 - 15 Taxes 6,884 - 0 - - (3,761) 0 0 0 - 16 State Income Taxes 0.000000 (89)- 0 0 0 0 0 0 0 - 17 Total Distribution 43,805 0 0 0 0 (3,761)0 0 0 0
18 Customer Accounting 3,824 - 0 - - - (157)0 0 -
20 Sales Expenses 0 - 0 - - - 0 0 0 -
21 Operating Expenses 39,295 - - - - - - 101 (165) - 22 Depreciation/Amortization 19,681 - - - - - - - - - 23 Regulatory Amortization (4,612)- 34 - - - - - - - 24 Taxes 2,389 - - - - - - - - - 25 Total Admin. & General 56,753 0 34 0 0 0 0 101 (165)0
26 Total Electric Expenses 319,574 0 90 0 0 (3,761)(157)101 (165)0
27 OPERATING INCOME BEFORE FIT 48,520 0 (90)0 0 5 157 (101)165 0
FEDERAL INCOME TAX 28 Current Accrual 2,289 - (19) - - 1 33 (21) 35 - 29 Debt Interest 0 7 - (1) (190) - - - - - 30 Deferred Income Taxes (7,212)- 0 - - - 0 0 0 -
31 Amortized ITC (173)- 0 - - - 0 0 0 -
RATE BASE PLANT IN SERVICE 33 Intangible $111,236 $0 $0 $0 $3,327 $0 $0 $0 $0 $034Production 511,691 - 0 - 19,115 - 0 0 0 - 35 Transmission 322,819 - 0 - 11,206 - 0 0 0 - 36 Distribution 703,038 - 0 - 22,821 - 0 0 0 - 37 General 149,885 - 0 - 1,070 - 0 0 0 - 38 Total Plant in Service 1,798,669 - - - 57,539 - - - - -
ACCUMULATED DEPRECIATION/AMORT39Intangible (43,162)- 0 - (2,745) - 0 0 0 - 40 Production (233,431)- 0 - (5,345) - 0 0 0 - 41 Transmission (87,663)- 0 - (3,243) - 0 0 0 - 42 Distribution (261,608)- 0 - (7,951) - 0 0 0 - 43 General (55,395)- 0 - (1,249) - 0 0 0 - 44 Total Accumulated Depreciation (681,259) - - - (20,533) - - - - - 45 NET PLANT 1,117,410 - - - 37,006 - - - - -
46 DEFERRED TAXES (197,501) (1,420) - - (316) - - - - -
47 Net Plant After DFIT 919,909 (1,420) - - 36,690 - - - - -
48 DEFERRED DEBITS AND CREDITS (13,048) - - - - - - - -
49 WORKING CAPITAL 26,672 - - 133 - - - - - -
51 RATE OF RETURN 5.74%0
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO ELECTRIC RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
1 Total General Business 2 Interdepartmental Sales 3 Sales for Resale 4 Total Sales of Electricity 5 Other Revenue 6 Total Electric Revenue
EXPENSES Production and Transmission
7 Operating Expenses
8 Purchased Power
9 Depreciation/Amortization
10 Regulatory Amortization11Taxes 12 Total Production & Transmission
Distribution 13 Operating Expenses 14 Depreciation/Amortization15Taxes 16 State Income Taxes
17 Total Distribution
18 Customer Accounting
20 Sales Expenses
21 Operating Expenses 22 Depreciation/Amortization23Regulatory Amortization24Taxes 25 Total Admin. & General
26 Total Electric Expenses
27
FEDERAL INCOME TAX 28 Current Accrual 29 Debt Interest30Deferred Income Taxes
31 Amortized ITC
RATE BASE PLANT IN SERVICE 33 Intangible 34 Production 35 Transmission 36 Distribution 37 General 38 Total Plant in Service
39 Intangible 40 Production 41 Transmission 42 Distribution 43 General 44 Total Accumulated Depreciation45NET PLANT
46 DEFERRED TAXES
47 Net Plant After DFIT
48
49 WORKING CAPITAL
51 RATE OF RETURN
SIT/SITC Revenue Miscellaneous Restate ID Nez Perce Colstrip /RestateExpenseNormalizationRestatingIncentivesPCA Settlement CS2 Debt Restated Adjustment Maintenance Interest TOTAL2.06 2.07 2.08 2.09 2.10 2.11 2.12 2.13 R-TtlE-SIT E-RN E-MR E-RI E-PCA E-NPS E-CCOM E-RDI
$0 ($288)$0 $0 ($5,665)$0 $0 $0 $275,384- - 0 - - 0 0 0 270 - - 0 - - 0 0 0 44,832 0 (288)0 0 (5,665)0 0 0 320,486 - 5,136 0 - - 0 0 0 43,035 0 4,848 0 0 (5,665)0 0 0 363,521
- (319) 0 - (1,702) (34)0 0 117,143
- (11,242) 0 - - 0 0 0 49,840
- - 0 - - 0 0 0 21,579
- 4,741 0 - - 0 (130)0 (1,541)
- - 0 - - 0 0 0 8,335 0 (6,820)0 0 (1,702)(34)(130)0 195,356
- - 2 - - 0 0 0 18,134 - - 0 - - 0 0 0 18,878 - - 0 - - 0 0 0 3,123 73 - 0 0 - 0 0 - (16) 73 0 2 0 0 0 0 0 40,119
- 19 0 - (14) 0 0 0 3,672
396
- - 0 - - 0 0 0 -
- (1) (7)(494) (11) 0 0 0 38,719 - - 0 - - 0 0 0 19,681 - - 0 - - 0 0 0 (4,578) - - 0 - - 0 0 0 2,389 0 (1)(7)(494)(11)0 0 0 56,211
73 (17,610)(6)(494)(1,727)(34)(130)0 295,754
(73)22,458 6 494 (3,938)34 130 0 67,767
(15) 4,716 1 104 (1,184) 7 27 188 6,162 - - - - - - - (183) - 6,981 0 - 357 0 0 0 126
- - 0 - - 0 0 0 (173)
61,835
$0 $0 $0 $0 $0 $0 $0 $0 114,563$ - - 0 - - 0 0 0 530,806 - - 0 - - 0 0 0 334,025 - - 0 - - 0 0 0 725,859 - - 0 - - 0 0 0 150,955 - - - - - - - - 1,856,208
- - 0 - - 0 0 0 (45,907) - - 0 - - 0 0 0 (238,776) - - 0 - - 0 0 0 (90,906) - - 0 - - 0 0 0 (269,559) - - 0 - - 0 0 0 (56,644) - - - - - - - - (701,792)- - - - - - - - 1,154,416
- - - - - - - - (199,237)
- - - - - - - - 955,179
- - - - - - - - (13,048)
- - - - - - - - 26,805
$968,936
6.38%
73 (13,673) (6) (496) 3,953 (34) (130) 239 14,876
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO ELECTRIC RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
1 Total General Business 2 Interdepartmental Sales 3 Sales for Resale 4 Total Sales of Electricity 5 Other Revenue 6 Total Electric Revenue
EXPENSES Production and Transmission
7 Operating Expenses
8 Purchased Power
9 Depreciation/Amortization
10 Regulatory Amortization11Taxes 12 Total Production & Transmission
Distribution 13 Operating Expenses 14 Depreciation/Amortization15Taxes 16 State Income Taxes
17 Total Distribution
18 Customer Accounting
20 Sales Expenses
21 Operating Expenses 22 Depreciation/Amortization23Regulatory Amortization24Taxes 25 Total Admin. & General
26 Total Electric Expenses
27
FEDERAL INCOME TAX 28 Current Accrual 29 Debt Interest30Deferred Income Taxes
31 Amortized ITC
RATE BASE PLANT IN SERVICE 33 Intangible 34 Production 35 Transmission 36 Distribution 37 General 38 Total Plant in Service
39 Intangible 40 Production 41 Transmission 42 Distribution 43 General 44 Total Accumulated Depreciation45NET PLANT
46 DEFERRED TAXES
47 Net Plant After DFIT
48
49 WORKING CAPITAL
51 RATE OF RETURN
Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Planned PlannedPowerTransmissionLaborLaborEmployee IS/IT Property Insurance EDIT Capital Add Capital AddSupplyRev/Exp Non-Exec Exec Benefits Costs Tax Expense (RSGM)12.2022 EOP 08.2023 EOP3.00P 3.00T 3.01 3.02 3.03 3.04 3.05 3.06 3.07 3.08 3.09E-PPS23 E-PTR24 E-PLN E-PLE E-PEB23 E-ISIT E-PPT E-PIns E-RSGM E-CAP22E E-CAP23E
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0- - - - - 0 0 - - - - 29,186 - - - - 0 0 - - - - 29,186 0 0 0 0 0 0 0 0 0 0(26,945) 1,793 - - - 0 0 - - - - 2,241 1,793 0 0 0 0 0 0 0 0 0
15,137 - 980 - (46) 0 0 - - - -
(13,238) - - - - 0 0 - - - -
- - - - - 0 0 - - 463 796
0 0 - -
- - - - - 0 (282)- - - - 1,899 0 980 0 (46)0 (282)0 0 463 796
- - 598 (27) 0 0 - - - - - - - - - 0 0 - - 635 851 - - - - - 0 509 - - - - 0 0 0 0 0 0 0 - - - - 0 0 598 0 (27)0 509 0 0 635 851
- - 206 - (9) 0 0 - - - -
- - 0 - - 0 0 - - - -
- - 1,029 173 (48) 408 0 1,231 - - - - - - - - 0 0 - - 534 1,561 - - - - - 0 0 - - - - - - - - 0 0 - - - - 0 0 1,029 173 (48)408 0 1,231 0 534 1,561
1,899 0 2,827 173 (131)408 227 1,231 0 1,632 3,208
342 1,793 (2,827)(173)131 (408)(227)(1,231)0 (1,632)(3,208)
72 377 (594) (36) 27 (86) (48) (259) - (343) (674) - - - - - - - - - (197) (41) - - - - - 0 0 - 200 - -
- - - - - 0 0 - - - -
$0 $0 $0 $0 $0 $0 $0 $0 $0 $2,376 ($501)- - - - - 0 0 - - 12,893 1,801 - - - - - 0 0 - - 3,780 13,479 - - - - - 0 0 - - 29,488 25,008 - - - - - 0 0 - - 7,589 4,921 - - - - - - - - - 56,126 44,708
- - - - - - - - - - 0 0 - - (2,110) (5,491) - - - - - 0 0 - - (2,956) (9,896) - - - - - 0 0 - - (3,139) (3,636) - - - - - 0 0 - - (7,327) (11,545) - - - - - 0 0 - - (2,875) (5,372) - - - - - - - - - (18,407) (35,940) - - - - - - - - - 37,719 8,768
- - - - - - - - - 420 (909)
- - - - - - - - - 38,139 7,859
- - - - - - - - - - -
- - - - - - - - - - -
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO ELECTRIC RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
1 Total General Business 2 Interdepartmental Sales 3 Sales for Resale 4 Total Sales of Electricity 5 Other Revenue 6 Total Electric Revenue
EXPENSES Production and Transmission
7 Operating Expenses
8 Purchased Power
9 Depreciation/Amortization
10 Regulatory Amortization11Taxes 12 Total Production & Transmission
Distribution 13 Operating Expenses 14 Depreciation/Amortization15Taxes 16 State Income Taxes
17 Total Distribution
18 Customer Accounting
20 Sales Expenses
21 Operating Expenses 22 Depreciation/Amortization23Regulatory Amortization24Taxes 25 Total Admin. & General
26 Total Electric Expenses
27
FEDERAL INCOME TAX 28 Current Accrual 29 Debt Interest30Deferred Income Taxes
31 Amortized ITC
RATE BASE PLANT IN SERVICE 33 Intangible 34 Production 35 Transmission 36 Distribution 37 General 38 Total Plant in Service
39 Intangible 40 Production 41 Transmission 42 Distribution 43 General 44 Total Accumulated Depreciation45NET PLANT
46 DEFERRED TAXES
47 Net Plant After DFIT
48
49 WORKING CAPITAL
51 RATE OF RETURN
RY1
$0 $0 $0 $0 $0 $0 $0 $0 $275,384- - - - - - - - 270 - - - - - - - - 74,018 0 0 0 0 0 0 0 0 349,672- - 3,328 - - - - - 21,211 0 0 3,328 0 0 0 0 0 370,883
- - (14) - - 1,762 (12) - 134,951
- - - - - - - - 36,602
198 697 - - - - - - 23,733
- - - - - (1,541) - - - - - - - - 8,053 198 697 (14)0 0 1,762 (12)0 201,798
- - (25) - - 888 (1,846) - 17,721 (1,653) 1,034 - - - - - - 19,745 - - - - - - - - 3,632 - - - - - - - - (16) (1,653)1,034 (25)0 0 888 (1,846)0 41,082
- - - 27 - 192 - - 4,088
- - - - - - - - 0
- - (114) - - 1,360 - - 42,757 (69) 1,657 - - - - - - 23,364 - - - (23) 3,008 - 5,272 (155) 3,524 - - - - - - - - 2,389 (69)1,657 (114)(23)3,008 1,360 5,272 (155)72,034
(1,524)3,388 (153)4 3,008 4,244 3,414 (155)319,454
1,524 (3,388)3,482 (4)(3,008)(4,244)(3,414)155 51,429
320 (711) 731 (1) (632) (891) (717) 33 2,731 - (91) - - - - - (13) (524) - - - - - - - - 326
- - - - - - - - (173)
$0 $2,027 $0 $0 $0 $0 $0 $0 118,465$ - 5,756 - - - - - 2,450 553,706 - 10,698 - - - - - - 361,982 - 21,521 - - - - - - 801,876 - 5,221 - - - - - - 168,686 - 45,223 - - - - - 2,450 2,004,715
- (5,061) - - - - - - (58,569) - (6,600) - - - - - - (258,228) - (3,285) - - - - - - (100,966) - (7,947) - - - - - - (296,378) - (4,016) - - - - - - (68,907) - (26,909) - - - - - - (783,048) - 18,314 - - - - - 2,450 1,221,667
- (760) - - - - - (200,486)
- 17,554 - - - - - 2,450 1,021,181
- - - - - - - - (13,048)
- - - - - - - - 26,805
4.74%
(1,530) 4,979 (3,495) 4 3,019 4,260 3,427 65 37,462
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO ELECTRIC RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
1 Total General Business 2 Interdepartmental Sales 3 Sales for Resale 4 Total Sales of Electricity 5 Other Revenue 6 Total Electric Revenue
EXPENSES Production and Transmission
7 Operating Expenses
8 Purchased Power
9 Depreciation/Amortization
10 Regulatory Amortization11Taxes 12 Total Production & Transmission
Distribution 13 Operating Expenses 14 Depreciation/Amortization15Taxes 16 State Income Taxes
17 Total Distribution
18 Customer Accounting
20 Sales Expenses
21 Operating Expenses 22 Depreciation/Amortization23Regulatory Amortization24Taxes 25 Total Admin. & General
26 Total Electric Expenses
27
FEDERAL INCOME TAX 28 Current Accrual 29 Debt Interest30Deferred Income Taxes
31 Amortized ITC
RATE BASE PLANT IN SERVICE 33 Intangible 34 Production 35 Transmission 36 Distribution 37 General 38 Total Plant in Service
39 Intangible 40 Production 41 Transmission 42 Distribution 43 General 44 Total Accumulated Depreciation45NET PLANT
46 DEFERRED TAXES
47 Net Plant After DFIT
48
49 WORKING CAPITAL
51 RATE OF RETURN
Rate Year September 1, 2024 - August 31, 2025
09.2023 Pro Forma Pro Forma Planned Planned Pro Forma Pro Forma Pro Forma Pro Forma Pro FormaFINALPowerTransmissionCapital Add Capital Add Property Labor Fee Free Revenue &Misc.TOTAL Supply Rev/Exp 08.2024 EOP 08.2025 AMA Tax Non-Exec Amortization O&M Offsets O&M ExpenseF-Ttl 24.00P 24.00T 24.01 24.02 24.03 24.04 24.05 24.06 24.07E-PPS24 E-PTR24 E-CAP24E E-CAP25A E-PPT24 E-PLN24 E-PFee24 E-POFF24 E-PME24
$275,384 $0 $0 $0 $0 $0 $0 $0 $0 $0270 0 0 - - 0 0 0 0 074,018 2,717 0 - - 0 0 0 0 0349,672 2,717 0 0 0 0 0 0 0 021,211 36 (335)- - 0 0 0 1,827 0370,883 2,753 (335)0 0 0 0 0 1,827 0
134,951 2,074 0 - - 0 391 0 (93)812
36,602 5,231 0 - - 0 0 0 0 0
23,733 0 0 - 612 0 0 0 0 0
(1,541) 0 0 - - 0 0 0 0 08,053 0 0 - - 454 0 0 0 0201,798 7,305 0 0 612 454 391 0 (93)812
17,721 0 0 - - 0 250 0 (11)40919,745 0 0 - 1,140 0 0 0 0 03,632 0 0 - - 249 0 0 0 0(16) 0 0 - - 0 0 0 0 041,082 0 0 0 1,140 249 250 0 (11)409
4,088 0 0 - - 0 75 0 0 89
0 0 0 - - 0 0 0 0 0
42,757 0 0 - - 0 373 0 0 62723,364 0 0 - 1,100 0 0 0 0 03,524 0 0 - - 0 0 (97)0 02,389 0 0 - - 0 0 0 0 072,034 0 0 0 1,100 0 373 (97)0 627
319,454 7,305 0 0 2,852 704 1,094 (97)(105)1,956
51,429 (4,552)(335)0 (2,852)(704)(1,094)97 1,932 (1,956)
2,731 (956) (70) - (599) (148) (230) 20 406 (411) (524) - - (51) (129) - - - - - 326 0 0 - - 0 0 0 0 0
(173) 0 0 - - 0 0 0 0 0
118,465 $0 $0 ($2,796)$4,275 $0 $0 $0 $0 $0553,706 0 0 3,372 8,943 0 0 0 0 0361,982 0 0 8,642 5,315 0 0 0 0 0801,876 0 0 22,575 23,750 0 0 0 0 0168,686 0 0 3,891 5,489 0 0 0 0 02,004,715 - - 35,684 47,772 - - - - -
- - (58,569) 0 0 (2,800) (559) 0 0 0 0 0(258,228) 0 0 (6,986) (5,509) 0 0 0 0 0(100,966) 0 0 (3,543) (3,921) 0 0 0 0 0(296,378) 0 0 (8,048) (8,358) 0 0 0 0 0(68,907) 0 0 (3,463) (3,517) 0 0 0 0 0(783,048) - - (24,840) (21,864) - - - - - 1,221,667 - - 10,844 25,908 - - - - -
(200,486) - - (968) (925) - - - - -
1,021,181 - - 9,876 24,983 - - - - -
(13,048) - - - - - - - - -
26,805 - - - - - - - - -
4.74%
4,569 336 888 5,108 706 1,099 (97) (1,939) 1,963
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO ELECTRIC RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
1 Total General Business 2 Interdepartmental Sales 3 Sales for Resale 4 Total Sales of Electricity 5 Other Revenue 6 Total Electric Revenue
EXPENSES Production and Transmission
7 Operating Expenses
8 Purchased Power
9 Depreciation/Amortization
10 Regulatory Amortization11Taxes 12 Total Production & Transmission
Distribution 13 Operating Expenses 14 Depreciation/Amortization15Taxes 16 State Income Taxes
17 Total Distribution
18 Customer Accounting
20 Sales Expenses
21 Operating Expenses 22 Depreciation/Amortization23Regulatory Amortization24Taxes 25 Total Admin. & General
26 Total Electric Expenses
27
FEDERAL INCOME TAX 28 Current Accrual 29 Debt Interest30Deferred Income Taxes
31 Amortized ITC
RATE BASE PLANT IN SERVICE 33 Intangible 34 Production 35 Transmission 36 Distribution 37 General 38 Total Plant in Service
39 Intangible 40 Production 41 Transmission 42 Distribution 43 General 44 Total Accumulated Depreciation45NET PLANT
46 DEFERRED TAXES
47 Net Plant After DFIT
48
49 WORKING CAPITAL
51 RATE OF RETURN
RY2
RY2 INCREMENTAL
$0 $0 $275,384 $000270 $00076,735 $2,71700352,389 2,7170022,739 $1,52800375,128 4,245
94 0 138,229 $3,278
0 0 41,833 $5,231
0 0 24,345 612
0 246 (1,295) $246008,507 $45494246211,619 9,822
57 0 18,425 $7040020,885 $1,140003,881 $24900(16) $057043,176 2,094
19 0 4,271 $183
0 0 0 $0
100 0 43,857 $1,1000024,464 $1,100003,427 ($97)0 0 2,389 $0100074,137 2,103
269 246 333,679 14,225
(269)(246)41,449 (9,980)
(57) (52) 635 ($2,096)- - (704) ($180)0 0 326 $0
0 0 (173) $0
$0 $0 $119,944 $1,47900566,021 $12,31500375,939 $13,95700848,201 $46,32500178,066 $9,380- - 2,088,171 83,456
- - 0 0 (61,928) ($3,359)0 0 (270,723) ($12,495)0 0 (108,430) ($7,464)0 0 (312,784) ($16,406)0 0 (75,887) ($6,980)- - (829,752) (46,704) - - 1,258,419 36,752
- - (202,379) ($1,893)
- - 1,056,040 34,859
- - (13,048) $0
- - 26,805 $0
3.87%
270 247 50,613 13,151
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS
TWELVE MONTHS ENDED JUNE 30, 2022
(000'S OF DOLLARS)
Actual Per 09.2023 Proposed Pro FormaLineResults Total Pro Forma Revenues &Proposed
No.DESCRIPTION Report Adjustments Total Related Exp Total
a b c d e f
REVENUES
1 Total General Business $76,137 $ (30,580)$45,557 2,771$ $48,328
2 Total Transportation 595 7 602 602
3 Other Revenues 28,824 (27,232) 1,592 1,592
4 Total Gas Revenues 105,556 (57,805) 47,751 2,771 50,522
EXPENSES
Production Expenses
5 City Gate Purchases 64,459 (64,459) - -
6 Purchased Gas Expense 328 (12) 316 316
7 Net Nat Gas Storage Trans (3,550) 3,550 - -
8 Total Production 61,237 (60,921) 316 - 316
Underground Storage
9 Operating Expenses 695 109 804 804
10 Depreciation 224 21 245 245
11 Taxes 98 21 119 119
12 Total Underground Storage 1,017 151 1,168 - 1,168
Distribution
13 Operating Expenses 4,879 507 5,386 5,386
14 Depreciation 6,713 335 7,048 7,048
15 Taxes 3,010 (575) 2,435 2,435
16 State Income Taxes (18) 13 (5) - (5)
17 Total Distribution 14,584 280 14,864 - 14,864
18 Customer Accounting 2,190 153 2,343 5 2,348
19 Customer Service & Information 1,786 (1,489) 297 297
20 Sales Expenses - 18 18 18
Administrative & General
21 Operating Expenses 8,170 585 8,755 6 8,761
22 Depreciation/Amortization 4,013 311 4,324 4,324
23 Regulatory Amortizations (937) 1,194 257 257
24 Taxes 490 - 490 490
25 Total Admin. & General 11,736 2,090 13,826 6 13,832
26 Total Gas Expense 92,550 (59,718) 32,832 11 32,843
27 OPERATING INCOME BEFORE FIT 13,006 1,913 14,919 2,760 17,679
FEDERAL INCOME TAX
28 Current Accrual (1,781) 417 (1,364) 580 (784)
29 Debt Interest - (75) (75) - (75)
30 Deferred FIT 1,348 1,512 2,860 2,860
31 Amort ITC - - - -
32 NET OPERATING INCOME $13,439 $59 $13,498 $2,180 $15,678
RATE BASE: PLANT IN SERVICE
33 Underground Storage $15,296 $1,350 $16,646 $16,646
34 Distribution Plant 286,853 27,363 314,216 314,216
35 General Plant 47,069 3,696 50,765 50,765
36 Total Plant in Service 349,218 32,409 381,627 - 381,627
ACCUMULATED DEPREC/AMORT
37 Underground Storage (5,854) (508) (6,362) (6,362)
38 Distribution Plant (96,120) (13,252) (109,372) (109,372)
39 General Plant (19,240) (4,451) (23,691) (23,691)
40 Total Accum. Depreciation/Amort.(121,214) (18,211) (139,425) - (139,425)
41 NET PLANT 228,004 14,198 242,202 - 242,202
42 DEFERRED FIT (35,042) 507 (34,535) (34,535)
43 Net Plant After DFIT 192,962 14,705 207,667 - 207,667 44 GAS INVENTORY 6,661 - 6,661 6,661
45 GAIN ON SALE OF BUILDING - - - -
46 OTHER (8,523) - (8,523) (8,523)
47 WORKING CAPITAL 950 (193) 757 757
48 TOTAL RATE BASE $192,050 $14,512 $206,562 $0 $206,562
9.2023 RY1WITH PRESENT RATES WITH 09.2023 PROPOSED RATES
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS
TWELVE MONTHS ENDED JUNE 30, 2022
(000'S OF DOLLARS)
09.2023 09.2024 09.2024 09.2023 Proposed 09.2024 Proposed 09.2024 Pro FormaLinePro Forma Total Pro Forma Revenues &Revenues &Proposed
No.DESCRIPTION Total Adjustments Total Related Exp Related Exp Total
a b c d e f g
REVENUES
1 Total General Business $45,557 $45,557 2,771$ $120 $48,448
2 Total Transportation 602 - 602 602
3 Other Revenues 1,592 795 2,387 2,387
4 Total Gas Revenues 47,751 795 48,546 2,771 120 51,437
EXPENSES
Production Expenses
5 City Gate Purchases - - - -
6 Purchased Gas Expense 316 12 328 328
7 Net Nat Gas Storage Trans - - - -
8 Total Production 316 12 328 - - 328
Underground Storage
9 Operating Expenses 804 50 854 854
10 Depreciation 245 9 254 254
11 Taxes 119 12 131 131
12 Total Underground Storage 1,168 71 1,239 - - 1,239
Distribution
13 Operating Expenses 5,386 283 5,669 5,669
14 Depreciation 7,048 259 7,307 7,307
15 Taxes 2,435 (30) 2,405 2,405
16 State Income Taxes (5) - (5) - - (5)
17 Total Distribution 14,864 512 15,376 - - 15,376
18 Customer Accounting 2,343 118 2,461 5 - 2,466
19 Customer Service & Information 297 17 314 314
20 Sales Expenses 18 - 18 18
Administrative & General
21 Operating Expenses 8,755 221 8,976 6 - 8,982
22 Depreciation/Amortization 4,324 (290) 4,034 4,034
23 Regulatory Amortizations 257 (158) 99 99
24 Taxes 490 - 490 490
25 Total Admin. & General 13,826 (227) 13,599 6 - 13,605
26 Total Gas Expense 32,832 503 33,335 11 - 33,346
27 OPERATING INCOME BEFORE FIT 14,919 292 15,211 2,760 120 18,091
FEDERAL INCOME TAX
28 Current Accrual (1,364) 61 (1,303) 580 25 (698)
29 Debt Interest (75) (24) (99) - - (99)
30 Deferred FIT 2,860 - 2,860 2,860
31 Amort ITC - - - -
32 NET OPERATING INCOME $13,498 $255 $13,753 $2,180 $95 $16,028
RATE BASE: PLANT IN SERVICE
33 Underground Storage $16,646 $602 $17,248 $17,248
34 Distribution Plant 314,216 11,503 325,719 325,719
35 General Plant 50,765 (249) 50,516 50,516
36 Total Plant in Service 381,627 11,856 393,483 - - 393,483
ACCUMULATED DEPREC/AMORT
37 Underground Storage (6,362) (248) (6,610) (6,610)
38 Distribution Plant (109,372) (6,381) (115,753) (115,753)
39 General Plant (23,691) (280) (23,971) (23,971)
40 Total Accum. Depreciation/Amort.(139,425) (6,909) (146,334) - - (146,334)
41 NET PLANT 242,202 4,947 247,149 - - 247,149
42 DEFERRED FIT (34,535) (343) (34,878) (34,878)
43 Net Plant After DFIT 207,667 4,604 212,271 - - 212,271 44 GAS INVENTORY 6,661 - 6,661 6,661
45 GAIN ON SALE OF BUILDING - - - -
46 OTHER (8,523) - (8,523) (8,523)
47 WORKING CAPITAL 757 - 757 757
48 TOTAL RATE BASE $206,562 $4,604 $211,166 $0 $0 $211,166
09.2024 RY2 WITH 09.2024 PROPOSED RATESWITH 09.2023 PROPOSED RATES
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
Calculation of General Revenue Requirement
Idaho - Natural Gas
RY1 RY2 RY2
Sep-23 Sep-24 Sep-24
Line (000's of (000's of (000's of
No.Dollars)Dollars)Dollars)
1 Pro Forma Rate Base $206,562 211,166$
2 Proposed Rate of Return 7.59%7.59%
3 Net Operating Income Requirement $15,678 $16,027
4 Pro Forma Net Operating Income $13,498 13,753$
5 Net Operating Income Deficiency $2,180 $2,274 $93
6 Conversion Factor 0.78701 0.78701 0.78701
7 Revenue Requirement $2,771 $2,890 $120
8 Total Base Distribution Revenues $46,159 $48,930
9 Percentage Base Distribution Revenue Increase 6.00%0.25%
10 Total Present Billed Revenue $103,243 $106,014
11 Percentage Billed Revenue Increase 2.68%0.11%
Description
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
Proposed:
Pro Forma
Capital Pro Forma Weighted
Component Structure Cost Cost
Total Debt 50.00%4.92%2.46%
Common Equity 50.00%10.25%5.13%
Total 100.00%7.59%
AVISTA UTILITIES
PRO FORMA COST OF CAPITALIdaho - Natural Gas
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
Revenue Conversion Factor
Idaho - Natural Gas SystemTWELVE MONTHS ENDED JUNE 30, 2022
Line
No.Description Factor
1 Revenues 1.000000
Expenses:
2 Uncollectibles 0.001795
3 Commission Fees 0.001995
4 Idaho State Income Tax 0.000000
5 Total Expenses 0.003790
6 Net Operating Income Before FIT 0.996210
7 21% Federal Income Tax @ 21%0.209204
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
K. Schultz, Avista
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS Rate Year September 1, 2023 - August 31, 2024
(000'S OF DOLLARS)
Per Accumulated Deferred Debits, Working Restating Eliminate Uncollectible Regulatory Injuries FIT / DFITLineResults Deferred FIT Credits & Reg Capital 06.2022 B & O Expense Expense and ExpenseNo.DESCRIPTION Report Rate Base Amortizations Capital EOP Taxes Damages 1.00 1.01 1.02 1.03 1.04 2.01 2.02 2.03 2.04 2.05
Workpaper Reference G-ROO G-DFIT G-DDC G-WC G-RCAP G-EBO G-UE G-RE G-ID G-FIT
REVENUES1Total General Business $76,137 -$ $0 -$ -$ (1,317)$ $0 $0 $0 -$
2 Total Transportation 595 - - - - (9) - - - -
3 Other Revenues 28,824 - - - - - - - - -
4 Total Gas Revenues $105,556 - $0 - - (1,326) $0 $0 $0 -
EXPENSESProduction Expenses
5 City Gate Purchases 64,459 - - - - - - - - -
6 Purchased Gas Expense 328 - - - - - - - - -
7 Net Nat Gas Storage Trans (3,550) - - - - - - - - -
8 Total Production 61,237 - - - - - - - - -
Underground Storage
9 Operating Expenses 695 - - - - - - - - -
10 Depreciation/Amortization 224 - - - - - - - - -
11 Taxes 98 - - - - - - - - -
12 Total Underground Storage 1,017 - - - - - - - - -
Distribution
13 Operating Expenses 4,879 - - - - - - - - -
14 Depreciation/Amortization 6,713 - - - - - - - - -
15 Taxes 3,010 - - - - (1,327) - - - - 16 State Income Taxes 0.000000 (18) - - - - - - - - -
17 Total Distribution 14,584 - - - - (1,327) - - - -
18 Customer Accounting 2,190 - - - - - (42) - - -
19 Customer Service & Information 1,786 - - - - - - - - -
20 Sales Expenses - - - - - - - - - -
Administrative & General
21 Operating Expenses 8,170 - - - - - - 39 (20) -
22 Depreciation/Amortization 4,013 - - - - - - - - -
23 Regulatory Amortizations (937) - (100) - - - - - - -
24 Taxes 490 - - - - - - - - - 25 Total Admin. & General 11,736 - (100) - - - - 39 (20) -
26 Total Gas Expense 92,550 - (100) - - (1,327) (42) 39 (20) -
27 OPERATING INCOME BEFORE FIT 13,006 - 100 - - 1 42 (39) 20 -
FEDERAL INCOME TAX
28 Current Accrual (1,781) - 21 - - 0 9 (8) 4 - 29 Debt Interest - (4) - 1 (21) - - - - -
30 Deferred FIT 1,348 - - - - - - - - -
31 Amort ITC - - - - - - -
RATE BASEPLANT IN SERVICE
33 Underground Storage $15,296 -$ $0 -$ 358$ -$ $0 $0 $0 -$
34 Distribution Plant 286,853 - - - 6,818 - - - - -
35 General Plant 47,069 - - - 426 - - - - -
36 Total Plant in Service 349,218 - - - 7,602 - - - - -
ACCUMULATED DEPRECIATION/AMORT37Underground Storage (5,854) - - - (112) - - - - -
38 Distribution Plant (96,120) - - - (2,998) - - - - - 39 General Plant (19,240) - - - (567) - - - - -
40 Total Accumulated Depreciation/Amortization (121,214) - - - (3,677) - - - - -
41 NET PLANT 228,004 - - - 3,925 - - - - -
42 DEFERRED TAXES (35,042) 785 - - 76 - - - - -
43 Net Plant After DFIT 192,962 785 - - 4,001 - - - - -
44 GAS INVENTORY 6,661 - - - - - - - - -
45 GAIN ON SALE OF BUILDING - - - - - - - - - -
46 OTHER (8,523) -
47 WORKING CAPITAL 950 - - (193) - - - - - -
48 TOTAL RATE BASE 192,050$ 785$ -$ (193)$ 4,001$ -$ -$ -$ -$ -$
49 RATE OF RETURN 7.00%
50 REVENUE REQUIREMENT 1,445 71 (100) (17) 360 (1) (42) 39 (20) -
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
REVENUES1Total General Business
2 Total Transportation
3 Other Revenues
4 Total Gas Revenues
EXPENSESProduction Expenses
5 City Gate Purchases6Purchased Gas Expense
7 Net Nat Gas Storage Trans
8 Total Production
Underground Storage
9 Operating Expenses10Depreciation/Amortization
11 Taxes
12 Total Underground Storage
Distribution
13 Operating Expenses
14 Depreciation/Amortization
15 Taxes16State Income Taxes
17 Total Distribution
18 Customer Accounting
19 Customer Service & Information20Sales Expenses
Administrative & General
21 Operating Expenses
22 Depreciation/Amortization
23 Regulatory Amortizations
24 Taxes25Total Admin. & General
26 Total Gas Expense
27
FEDERAL INCOME TAX
28 Current Accrual29Debt Interest
30 Deferred FIT
31 Amort ITC
RATE BASEPLANT IN SERVICE
33 Underground Storage
34 Distribution Plant
35 General Plant
36 Total Plant in Service
37 Underground Storage
38 Distribution Plant39General Plant
40
41 NET PLANT
42 DEFERRED TAXES
43 Net Plant After DFIT
44 GAS INVENTORY
45 GAIN ON SALE OF BUILDING
46 OTHER
47 WORKING CAPITAL
48 TOTAL RATE BASE
49 RATE OF RETURN
50 REVENUE REQUIREMENT
SIT/SITC Revenue Miscellaneous Restate RestateExpenseNormalization &Restating Incentive Debt Restated Gas Cost Adj. Interest Total2.06 2.07 2.08 2.09 2.10
G-SIT G-RNGC G-MR G-RI G-RDI R-Ttl
-$ (29,263)$ $0 $0 -$ $45,557
- 16 - - - 602
- (28,673) - - - 151
- (57,920) $0 $0 - 46,310
- (64,459) - - - -
- (39) - - - 289
- 3,550 - - - -
- (60,948) - - - 289
- - - - - 695
- - - - - 224
- - - - - 98
- - - - - 1,017
- - (3) - - 4,876
- - - - - 6,713
- - - - - 1,683 13 - - - - (5)
13 - (3) - - 13,267
- (52) - - - 2,096
- (1,524) (1) - - 261
- - - - - -
- (59) (6) (117) - 8,007
- - - - - 4,013
- 1,252 - - 215
- - - - - 490 - 1,193 (6) (117) - 12,725
13 (61,332) (10) (117) - 29,655
(13) 3,412 10 117 - 16,655
(3) 716 2 24 39 (976) - - - - - (24)
- 1,469 - - - 2,817
- - - - - -
(10)$ 1,226$ 8$ 92$ (39)$ 14,837$
-$ -$ $0 $0 -$ 15,654$
- - - - - 293,671
- - - - - 47,495
- - - - - 356,820
- - - - - (5,966)
- - - - - (99,118) - - - - - (19,807)
- - - - -
- - - - - 231,929
- - - - - (34,181)
- - - - - 197,748
- - - - - 6,661
- - - - - -

- - - - - 757
7.55%
13 (1,558) (10) (117) 50 112
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
REVENUES1Total General Business
2 Total Transportation
3 Other Revenues
4 Total Gas Revenues
EXPENSESProduction Expenses
5 City Gate Purchases6Purchased Gas Expense
7 Net Nat Gas Storage Trans
8 Total Production
Underground Storage
9 Operating Expenses10Depreciation/Amortization
11 Taxes
12 Total Underground Storage
Distribution
13 Operating Expenses
14 Depreciation/Amortization
15 Taxes16State Income Taxes
17 Total Distribution
18 Customer Accounting
19 Customer Service & Information20Sales Expenses
Administrative & General
21 Operating Expenses
22 Depreciation/Amortization
23 Regulatory Amortizations
24 Taxes25Total Admin. & General
26 Total Gas Expense
27
FEDERAL INCOME TAX
28 Current Accrual29Debt Interest
30 Deferred FIT
31 Amort ITC
RATE BASEPLANT IN SERVICE
33 Underground Storage
34 Distribution Plant
35 General Plant
36 Total Plant in Service
37 Underground Storage
38 Distribution Plant39General Plant
40
41 NET PLANT
42 DEFERRED TAXES
43 Net Plant After DFIT
44 GAS INVENTORY
45 GAIN ON SALE OF BUILDING
46 OTHER
47 WORKING CAPITAL
48 TOTAL RATE BASE
49 RATE OF RETURN
50 REVENUE REQUIREMENT
Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Pro Forma Planned PlannedLaborLaborEmployeeIS/IT Property Insurance EDIT Capital Add Capital AddNon-Exec Exec Benefits Costs Tax Expense (RSGM)12.2022 EOP 08.2023 EOP3.01 3.02 3.03 3.04 3.05 3.06 3.07 3.08 3.09
G-PLN G-PLE G-PEB23 G-ISIT G-PPT G-Ins G-RSGM G-CAP22E G-CAP23E
$0 $0 $0 $0 $0 $0 -$ -$ -$
- - - - - - - - -
- - - - - - - - -
$0 $0 $0 $0 $0 $0 - - -
- - - - - - - - -
21 - (1) - - - - - -
- - - - - - - - -
21 - (1) - - - - - -
0 - - - - - - - -
- - - - - - - 6 7
- - - - 21 - - - -
0 - - - 21 - - 6 7
240 (12) - - - - - -
- - - - - - - 166 183
- - - - 752 - - - - - - - - - - - - -
240 - (12) - 752 - - 166 183
131 - (6) - - - - -
10 - (0) - - - - - -
- - - - - - - - -
230 41 (11) 93 - 172 - - -
- - - - - - - 32 28
- -
- - - - - - - - - 230 41 (11) 93 - 172 - 32 28
631 41 (31) 93 773 172 - 204 218
(631) (41) 31 (93) (773) (172) - (204) (218)
(133) (9) 6 (20) (162) (60) - (43) (46) - - - - - - - (26) (9)
- - - - - - 43 - -
- - - - - - - - -
$0 $0 $0 $0 $0 $0 -$ 301$ 393$
- - - - - - - 7,165 7,276
- - - - - - - 1,811 378
- - - - - - - 9,277 8,047
- - - - - - - (117) (158)
- - - - - - - (2,956) (4,224) - - - - - - - (1,000) (1,705)
- - - - - - - (4,073) (6,087)
- - - - - - - 5,204 1,960
- (81) (142)
- - - - - - - 5,123 1,818
- - -
-
-
-$ -$ -$ -$ -$ -$ -$ 5,123$ 1,818$
634 41 (31) 93 776 142 55 665 382
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
REVENUES1Total General Business
2 Total Transportation
3 Other Revenues
4 Total Gas Revenues
EXPENSESProduction Expenses
5 City Gate Purchases6Purchased Gas Expense
7 Net Nat Gas Storage Trans
8 Total Production
Underground Storage
9 Operating Expenses10Depreciation/Amortization
11 Taxes
12 Total Underground Storage
Distribution
13 Operating Expenses
14 Depreciation/Amortization
15 Taxes16State Income Taxes
17 Total Distribution
18 Customer Accounting
19 Customer Service & Information20Sales Expenses
Administrative & General
21 Operating Expenses
22 Depreciation/Amortization
23 Regulatory Amortizations
24 Taxes25Total Admin. & General
26 Total Gas Expense
27
FEDERAL INCOME TAX
28 Current Accrual29Debt Interest
30 Deferred FIT
31 Amort ITC
RATE BASEPLANT IN SERVICE
33 Underground Storage
34 Distribution Plant
35 General Plant
36 Total Plant in Service
37 Underground Storage
38 Distribution Plant39General Plant
40
41 NET PLANT
42 DEFERRED TAXES
43 Net Plant After DFIT
44 GAS INVENTORY
45 GAIN ON SALE OF BUILDING
46 OTHER
47 WORKING CAPITAL
48 TOTAL RATE BASE
49 RATE OF RETURN
50 REVENUE REQUIREMENT
Base
G-Depr G-CAP24A G-POFF23 G-Fee23 G-PRA E-PME23 F-Ttl
-$ -$ -$ -$ -$ -$ $45,557
- - - - - - 602
- - 1,441 - - - 1,592
- - 1,441 - - - 47,751
- - - - - - -
- - - - - 7 316
- - - - - - -
- - - - - 7 316
- - - - - 109 804
(1) 9 - - - - 245
- - - - - - 119
(1) 9 - - - 109 1,168
- - (55) - - 336 5,386
(297) 283 - - - - 7,048
- - - - - - 2,435 - - - - - - (5)
(297) 283 (55) - - 336 14,864
- - - - - 123 2,343
- - - - - 27 297
- - - 18 - - 18
- - (25) - - 248 8,755
(26) 277 - - - - 4,324
26 16 257
- - - - - - 490 (26) 277 (25) 26 16 248 13,826
(324) 569 (79) 44 16 850 32,832
324 (569) 1,520 (44) (16) (850) 14,919
68 (119) 319 (9) (3) (179) (1,364) - (15) - - - - (75)
- - - - - - 2,860
- - - - - - -
256$ (434)$ 1,201$ (35)$ (13)$ (672)$ 13,498$
-$ 298$ -$ -$ -$ -$ 16,646$
- 6,104 - - - - 314,216
- 1,081 - - - - 50,765
- 7,483 - - - - 381,627
- (121) - - - - (6,362)
- (3,074) - - - - (109,372) - (1,179) - - - - (23,691)
- (4,374) - - - - (139,425)
- 3,109 - - - - 242,202
- (131) - - (34,535)
- 2,978 - - - - 207,667
- - - - - 6,661
-
(8,523)
- 757
6.53%
(325) 839 (1,526) 44 16 853 2,770
RY1 RATE CHANGE
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
REVENUES1Total General Business
2 Total Transportation
3 Other Revenues
4 Total Gas Revenues
EXPENSESProduction Expenses
5 City Gate Purchases6Purchased Gas Expense
7 Net Nat Gas Storage Trans
8 Total Production
Underground Storage
9 Operating Expenses10Depreciation/Amortization
11 Taxes
12 Total Underground Storage
Distribution
13 Operating Expenses
14 Depreciation/Amortization
15 Taxes16State Income Taxes
17 Total Distribution
18 Customer Accounting
19 Customer Service & Information20Sales Expenses
Administrative & General
21 Operating Expenses
22 Depreciation/Amortization
23 Regulatory Amortizations
24 Taxes25Total Admin. & General
26 Total Gas Expense
27
FEDERAL INCOME TAX
28 Current Accrual29Debt Interest
30 Deferred FIT
31 Amort ITC
RATE BASEPLANT IN SERVICE
33 Underground Storage
34 Distribution Plant
35 General Plant
36 Total Plant in Service
37 Underground Storage
38 Distribution Plant39General Plant
40
41 NET PLANT
42 DEFERRED TAXES
43 Net Plant After DFIT
44 GAS INVENTORY
45 GAIN ON SALE OF BUILDING
46 OTHER
47 WORKING CAPITAL
48 TOTAL RATE BASE
49 RATE OF RETURN
50 REVENUE REQUIREMENT
Rate Year September 1, 2024 - August 31, 2025
09.2023 Planned Planned Pro Forma Pro Forma Pro Forma Pro Forma Pro FormaFINALCapital Add Capital Add Property Labor Fee Free Revenue &Misc.TOTAL 08.2024 EOP 08.2025 AMA Tax Non-Exec Amortization O&M Offsets O&M Expense24.01 24.02 24.03 24.04 24.05 24.06 24.07
F-Ttl G-CAP24E G-CAP25A G-PPT24 G-PLN24 G-Fee24 G-POFF24 E-PME24
-$ -$ -$ -$ -$ -$ -$
602 - - - - - - -
1,592 - - - - - 795 -
47,751 - - - - - 795 -
- - - - - - - -
316 - - - 7 - - 3
- - - - - - - -
316 - - - 7 - - 3
804 - - - 0 0 0 50
245 - 9 - - - - -
119 - - 12 - - - -
1,168 - 9 12 0 0 0 50
5,386 - - - 103 - - 155 7,048 - 259 - - - - -
2,435 - - (30) - - - - (5) - - - - - - -
14,864 - 259 (30) 103 - - 155
2,343 - - 48 - - 57
297 - - - 3 - - 13
18 - - - - - - -
8,755 - - - 83 - - 114
4,324 - (290) - - - - - 257 - - - - (158) - -
490 - - - - - - - 13,826 - (290) - 83 (158) - 114
32,832 - (22) (18) 245 (158) 0 392
14,919 - 22 18 (245) 158 795 (392)
(1,364) - 5 4 (51) 33 167 (82) (75) (8) (15) - - - - -
2,860 - - - - - - -
- - - - - - - -
16,646$ 301$ 301$ -$ -$ -$ -$ -$
314,216 5,614 5,889 - - - - -
50,765 (938) 689 - - - - -
381,627 4,977 6,879 - - - - -
(6,362) (123) (125) - - - - -
(109,372) (3,153) (3,228) - - - - - (23,691) 110 (390) - - - - -
(139,425) (3,166) (3,743) - - - - -
242,202 1,811 3,136 - - - - -
(34,535) (184) (159) - - - - -
207,667 1,627 2,977 - - - - -
6,661 - - - - - - -
- - - - - - - -
(8,523) - - - - - - -
757 - - - - - - -
206,562$ 1,627$ 2,977$ -$ -$ -$ -$ -$
6.53%
2,770 146 245 (18) 246 (158) (798) 393
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01
AVISTA UTILITIES
IDAHO NATURAL GAS RESULTS
(000'S OF DOLLARS)
LineNo.DESCRIPTION
Workpaper Reference
REVENUES1Total General Business
2 Total Transportation
3 Other Revenues
4 Total Gas Revenues
EXPENSESProduction Expenses
5 City Gate Purchases6Purchased Gas Expense
7 Net Nat Gas Storage Trans
8 Total Production
Underground Storage
9 Operating Expenses10Depreciation/Amortization
11 Taxes
12 Total Underground Storage
Distribution
13 Operating Expenses
14 Depreciation/Amortization
15 Taxes16State Income Taxes
17 Total Distribution
18 Customer Accounting
19 Customer Service & Information20Sales Expenses
Administrative & General
21 Operating Expenses
22 Depreciation/Amortization
23 Regulatory Amortizations
24 Taxes25Total Admin. & General
26 Total Gas Expense
27
FEDERAL INCOME TAX
28 Current Accrual29Debt Interest
30 Deferred FIT
31 Amort ITC
RATE BASEPLANT IN SERVICE
33 Underground Storage
34 Distribution Plant
35 General Plant
36 Total Plant in Service
37 Underground Storage
38 Distribution Plant39General Plant
40
41 NET PLANT
42 DEFERRED TAXES
43 Net Plant After DFIT
44 GAS INVENTORY
45 GAIN ON SALE OF BUILDING
46 OTHER
47 WORKING CAPITAL
48 TOTAL RATE BASE
49 RATE OF RETURN
50 REVENUE REQUIREMENT
Base
RY2 Rate Change
E-PEB24 F-Ttl F-Ttl
-$ 45,557$ -$
- 602 -
- 2,387 795
- 48,546 795
- - -
2 328 12
- - -
2 328 12
- 854 50
- 254 9
- 131 12
- 1,239 71
24 5,669 283
- 7,307 259
- 2,405 (30) - (5) -
24 15,376 512
13 2,461 118
1 314 17 - 18 -
24 8,976 221
- 4,034 (290)
- 99 (158)
- 490 - 24 13,599 (227)
64 33,335 503
(64) 15,211 292
(13) (1,303) 61 - (99) (24)
- 2,860 -
- - -
(50)$ 13,753$ 255$
-$ 17,248$ 602
- 325,719 11,503
- 50,516 (249)
- 393,483 11,856
- (6,610) (248)
- (115,753) (6,381) - (23,971) (280)
- (146,334) (6,909)
- 247,149 4,947
- (34,878) (343)
- 212,271 4,604
- 6,661 -
- -
- (8,523) -
- 757 -
6.51%
64 2,890 120
RY2 RATE CHANGE
Exhibit No. 4
Case Nos. AVU-E-23-01 and AVU-G-23-01