HomeMy WebLinkAbout20241122Direct Katherine Arp_Exhibits.pdf RECEIVED
Friday, November 22, 2024
IDAHO PUBLIC
UTILITIES COMMISSION
Preston N. Carter, ISB No. 8462
Morgan D. Goodin, ISB No. 11184
Megann E. Meier, ISB No. 11948
GIVENS PURSLEY LLP
601 West Bannock Street
P.O. Box 2720
Boise, Idaho 83701-2720
Office: (208) 388-1200
Fax: (208) 388-1300
prestoncarter@givenspursley.com
morgangoodin@givenspursley.com
mem@givenspursley.com
18557810.2[30.2641
Attorneys for TVeolia Water Idaho, Inc.
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION Case No. VEO-W-24-01
OF VEOLIA WATER IDAHO, INC. FOR A
GENERAL RATE CASE
DIRECT TESTIMONY OF KATHERINE ARP
FOR VEOLIA WATER IDAHO,INC.
NOVEMBER 22,2024
I INTRODUCTION
2 Q. Please state your name and business address.
3 A. My name is Katherine Arp, and my business address is 461 From Rd, Suite 400, Paramus,
4 New Jersey 07652.
5 Q. By whom are you employed and in what capacity?
6 A. I am employed by Veolia Water Management & Services (Paramus), Inc. ("VWM&S") as
7 a Manager Regulatory Business. In this role, I am responsible for compiling, analyzing,
8 and logically presenting supporting data for rate cases.
9 Q. Please summarize your educational background and professional experience.
10 A. I graduated from William Paterson University in Wayne,New Jersey in 2005 with a
11 Bachelor of Science degree in Accounting.
12 Q. Please describe your work experience.
13 A. Before joining the VWM&S Regulatory Business department, I worked eleven years in the
14 accounting department of VWM&S with a focus on fixed assets accounting and corporate
15 management and services costs accounting. I joined VWM&S Regulatory Business in
16 October 2010 as a Rate Analyst. In November 2020, 1 was prompted to the position of
17 Senior Regulatory Specialist, and later promoted to the position of Manager Regulatory
18 Business in July 2024.
19 Q. What regulatory agencies have you previously appeared before and presented
20 testimony?
21 A. I have provided testimony in rate case proceedings before the New York Public Service
22 Commission, State of Rhode Island and Providence Plantations Public Utilities
PAGE 1 OF 7
K.ARP,DI
VEOLIA WATER IDAHO,INC.
I Commission, Delaware Public Services Commission, and the New Jersey Board of Public
2 Utilities.
3 Q. What is the purpose of your testimony?
4 A. The purpose of my testimony is to support Veolia Water Idaho, Inc.'s ("Veolia Water
5 Idaho" or"Company") computation of Rate Base and the calculation of Depreciation
6 Expense for the test year.
7 Q. What is the test year for this proceeding?
8 A. The test year for this proceeding ends December 31, 2024 ("Test Year"), which consists of
9 a 12-month historic period ending on August 31, 2024 ("Historic Test Year") and a four-
10 month adjustment period ending on December 31, 2024.
11 Q. Please list the Exhibits that you are sponsoring in this rate case.
12 A. I am sponsoring the following exhibits:
13 1. Exhibit No. 10, Schedule 2-Adjustment to Depreciation Expense
14 11. Exhibit No. 11, Schedule 1-13-Rate Base Adjustment
15 Q. Please describe Exhibit No. 10, Schedule 2-Adjustment to Depreciation Expense.
16 A. Exhibit No. 10, Schedule 2 is a summary of the Company's calculation of its projected
17 annual depreciation expense based on the current Plant in Service balance plus the
18 proposed additions and retirements between the end of the HTY, or August 31, 2024,
19 through the end of the TY, or December 31, 2024.
20 The projected Depreciation Expense is derived by multiplying the individual
21 projected plant account balances as of the end of the TY, or December 31, 2024 by
22 VWID's current annual life, cost of removal, and salvage depreciation rates.
PAGE 2 OF 7
K.ARP,DI
VEOLIA WATER IDAHO,INC.
I Q. Please list the schedules you are presenting in support of Exhibit 11 Rate Base
2 Adjustment.
3 A. I am sponsoring the following schedules under Exhibit No. 11:
4 I. Schedule 1: Rate Base Summary
5 II. Schedule 2: 13-month Average Monthly Average Worksheet
6 III. Schedule 3: Utility Plant In Service with Forecast Additions and Retirements
7 IV. Schedule 4: Accumulated Depreciation and Accumulated CIAC Amortization
8 V. Schedule 5: Developer Advances for Construction Subject to Refund
9 VI. Schedule 6: Contributions In Aid of Construction
10 VII. Schedule 7: Summary of Net Utility Plant Acquisition Adjustments
11 VIII. Schedule 8: Accumulated Deferred Income Taxes
12 IX. Schedule 9: Deferred Debits Balance Included in Rate Base
13 X. Schedule 10: Materials and Supplies
14 XI. Schedule 11: Prepayments
15 XIL Schedule 12: Cash Working Capital Allowance
16 XIII. Schedule 13: Regulatory Liability-New Federal Tax Law
17 Q. Please explain Exhibit No. 11, Schedule 1.
18 A. Exhibit No. 11, Schedule 1, Page 1 of 1, Rate Base Summary, shows the elements of the
19 Company's rate base as of December 31, 2024,using an Average of Monthly Average
20 ("AMA") methodology. The elements of rate base are as follows: Gross Utility Plant in
21 Service; Accumulated Depreciation; Customer Advances for Construction; Contributions
22 In Aid of Construction;Net Utility Plant Acquisition Adjustments; Accumulated Deferred
PAGE 3 OF 7
K.ARP,DI
VEOLIA WATER IDAHO,INC.
I Income Taxes; Deferred Charges; Working Capital and a Regulatory Liability as a result
2 of the Tax Cuts and Jobs Act.
3 Q. Why is the Company using Average Monthly Average methodology to calculate Rate
4 Base?
5 A. Average Monthly Average methodology is being used to calculate Rate Base, consistent
6 with the methodology used by Idaho PUC staff in the Company's last rate case. The
7 methodology calculates the utility plant value based on the month in which it was placed in
8 service.
9 Q. Please explain Exhibit No. 11, Schedule 2.
10 A. Exhibit No. 11, Schedule 2 is a summary of the 9 months of actuals and 4 months of
11 projected Rate Base using AMA methodology.
12 Q. Please explain Exhibit No. 11, Schedule 3.
13 A. Exhibit No. 11, Schedule 3, Page 1 of 1, summarizes the Company's Utility Plant balance
14 as of August 31, 2024, and forecasted plant additions and retirements from September
15 2024 through December 2024 by month and plant account. Exhibit No. 3, sponsored by the
16 Company witness Cooper, forms the basis for the plant activity shown on this schedule.
17 Refer to Exhibit No. 3 for supporting details.
18 Q. Please explain Exhibit No. 11, Schedule 4.
19 A. Exhibit No. 11, Schedule 4, Page 1 of 1, shows the Company's Accumulated Depreciation
20 and CIAC Amortization for the test year ending December 31, 2024. The schedule shows
21 the recorded amounts for these rate base components for the months of January 2024
22 through August 2024. For the months beginning with September 2024, the amounts for
23 both accumulated depreciation and amortization of CIAC were estimated based on the
PAGE 4 OF 7
K.ARP,DI
VEOLIA WATER IDAHO,INC.
I historical test year, adjusted for forecasted additions, retirements, and changes to cost of
2 removal and salvage balances based on the information provided by the Company witness
3 Cooper.
4 Q. Please explain Exhibit No. 11, Schedule 5.
5 A. Exhibit No. 11, Schedule 5, Page 1 of 1, summarizes change to advances for construction
6 for the four months between the end of the HTY and the TY and the balance of these
7 accounts at the end of the TY. Since the issuance of Order No. 28505 in case UWI-W-00-
8 1, the Company does not depreciate advanced property.
9 Q. Please explain Exhibit No. 11, Schedule 6.
10 A. Exhibit No. 11, Schedule 6, Page 1 of 1, summarizes changes to Contributions In Aid of
11 Construction for the four months between the end of the HTY and the TY and the balance
12 of these accounts at the end of the TY.
13 Q. Please explain Exhibit No. 11, Schedule 7.
14 A. Exhibit No. 11, Schedule 7, Page 1 of 1, summarizes the net change to the balance of
15 Utility Plant Acquisition Adjustment(UPAA) for the four months between the end of the
16 HTY and the TY and the balance at the end of the TY. Shown on this schedule, lines 1
17 through 7, are seven individual UPAA items that were all approved by the Commission in
18 various proceedings.
19 Q. Please explain Exhibit No. 11, Schedule 8.
20 A. Exhibit No. 11, Schedule 8, Page 1 of 1, summarizes the composition of Accumulated
21 Deferred Income Taxes (ADIT) at the end of the Test Year. The tax depreciation portion of
22 this account was adjusted for assets projected to be in service as of December 31, 2023.
PAGE 5 OF 7
K.ARP,DI
VEOLIA WATER IDAHO,INC.
I Q. Please explain Exhibit No. 11, Schedule 9.
2 A. Exhibit No. 11, Schedule 9, Page 1 of 1, summarizes the deferred items the Company has
3 included in the rate base. The projected balance at December 31, 2024 is $5,560,585. Of
4 this balance, $1,974,473 is the net unamortized balance of deferred items that were all
5 approved by the Commission in various proceedings. The $3,586,112 of new deferred
6 charges, requested for inclusion in the rate base in this proceeding, consists of eight line
7 items. The Company is requesting a twenty-year amortization for tank painting
8 expenditures, in line with the amortization of tank painting granted in case UWI-W-04-04
9 as well as in the stipulations to the 2006, 2009, 2011, 2015, 2020 and as approved by
10 Commission in 2022 rate cases.
11 Q. Please explain Exhibit No. 11, Schedule 10.
12 A. Exhibit No. 11, Schedule 10, Page 1 of 1, summarizes the 9 months of actuals and 4
13 months of projections for Material and Supplies to be used in Schedule 2.
14 Q. Please explain Exhibit No. 11, Schedule 11.
15 A. Exhibit No. 11, Schedule 11, Page 1 of 1, summarizes the 9 months of actuals and 4
16 months of projections for prepayments to be used in Schedule 2.
17 Q. Please explain Exhibit No. 11, Schedule 12.
18 A. Exhibit No. 11, Schedule 12, Page 1 of 1, summarizes the calculation of the allowance for
19 working capital prepared and sponsored by Company witness MacDougall.
20 Q. Please explain Exhibit No. 11, Schedule 13.
21 A. Exhibit No. 11, Schedule 13, Page 1 of 1, reflects the regulatory liability balance projected
22 at December 31, 2024. This is the result of the Tax Cuts and Job Act,which reduced
23 corporate income tax rate from 35%to 21%.
PAGE 6 OF 7
K.ARP,DI
VEOLIA WATER IDAHO,INC.
I Q. Does this conclude your direct testimony?
2 A. Yes.
PAGE 7 OF 7
K.ARP,DI
VEOLIA WATER IDAHO,INC.
Preston N. Carter, ISB No. 8462
Morgan D. Goodin, ISB No. 11184
Megann E. Meier, ISB No. 11948
GIVENS PURSLEY LLP
601 West Bannock Street
P.O. Box 2720
Boise, Idaho 83701-2720
Office: (208) 388-1200
Fax: (208) 388-1300
prestoncarter@givenspursley.com
morgangoodin@givenspursley.com
mem@givenspursley.com
18557695.1 [30-264]
Attorneys for Veolia Water Idaho, Inc.
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
IN THE MATTER OF THE APPLICATION Case No. VEO-W-24-01
OF VEOLIA WATER IDAHO, INC. FOR A
GENERAL RATE CASE
BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION
EXHIBIT TO ACCOMPANY THE
DIRECT TESTIMONY OF KATHERINE ARP
VEOLIA WATER IDAHO, INC.
Details of Adjustments to Operating and Maintenance Expenses At Present Rates
SUMMARY- Exhibit 10, Schedule 1
Historic Test Year ended August 31, 2024, as Adjusted
(1) (2) (3) (4) (5)
Schedule Historic Test Year Adjusted Historic Test Year
Line Adjustment Account Ended Normalizing Test Year Ended Ending
Witness No. Description No. Reference 08/31/2024 Per Books Adjustments 08/31/2024 Adjustments 12/31/2024
EXHIBIT 10, Schedule 1
M. Wilson 1 Payroll 1 50100 to 50125 $ 7,806,288 $ 7,806,288 $ 135,265 $ 7,941,553
M. Wilson 2 Workers Compensation (excludes reserves, adds claims 2 91460 $ 68,115 1/ $ 17,684 $ 85,799 $ 32,028 $ 117,827
L. Bucci 3 Pension Cash Contributions 3 91500, 71257 & $ 873,877 $ 873,877 $ (193,268) $ 680,609
L. Bucci 4 Post-retirement Benefits Other than Pension (PBOP) 4 91550 &71258 $ (448,642) $ (448,642) $ (38,286) $ (486,928)
L. Bucci 5 Employee Healthcare (excludes reserves) 5 91700 $ 1,694,602 2/ $ (127,885) $ 1,566,717 $ 395,374 $ 1,962,090
L. Bucci 6 Employee 401k 6 91800 $ 511,836 $ 511,836 $ 25,033 $ 536,868
L. Bucci 7 Other Employee Benefits -Tuition &Other Awards 7 91850 &91860 $ 142,878 $ 142,878 $ (85,244) $ 57,634
M. Wilson 8 Payroll Overheads (Fringe Benefit Allocation) 8 90950 &90953 $ (1,307,201) $ (1,307,201) $ (132,253) $ (1,439,454)
L. Bucci 9 Purchased Water 9 50605 $ 433,064 $ 433,064 $ - $ 433,064
M. Wilson 10 Energy- Purchased Power and Other Utilities 10 50610 &50620 $ 2,869,189 $ 2,869,189 $ 317,512 $ 3,186,702
M. Wilson 11 Chemicals (reclass of prior year correction) 11 50635 $ 758,808 3/ $ 9,511 $ 768,319 $ (27,601) $ 740,718
M. Wilson 12 Subcontractors 12 50400 $ 1,066,558 $ 1,066,558 $ 46,117 $ 1,112,675
L. Bucci 13 Customer Billing Expenses 13 50405 $ 323,460 $ 323,460 $ 17,175 $ 340,635
L. Bucci 14 Bad Debts (reserves booked in separate 90405 account) 14 90400 &90405 $ 352,668 4/ (2,097) $ 350,571 $ (18,215) $ 332,356
L. Bucci 15 Materials (reclassification amount in Adjusted Test Year 15 50300 $ 276,106 5/ $ 276,106 $ (0) $ 276,106
M. Wilson 16 Vehicle Allocation (excludes reserves, adds claims 16 50645 &50646 $ 754,934 6/ $ 334,483 $ 1,089,417 $ (174,871) $ 914,546
M. Wilson 17 Office Expenses 17 50650 $ 726,981 $ 726,981 $ 42,551 $ 769,532
L. Bucci 18 Advertising Expense 18 50651 $ 116,722 $ 116,722 $ 19,286 $ 136,008
A. Jacob 19 Management&Service Fees 19 90850 $ 4,554,245 $ 4,554,245 $ 251,013 $ 4,805,258
L. Bucci 20 General Insurance (excludes reserves, adds claims 20 91400 &91450 $ (28,071) 7/ $ 127,589 $ 99,518 $ 154,558 $ 254,076
L. Bucci 21 IPUC Fees 21 91900 $ 111,595 $ 111,595 $ 8,017 $ 119,612
M. Wilson 22 Safety 22 92200 $ 212,503 $ 212,503 $ (0) $ 212,503
A. Jacob 23 Amortization Expense- Deferred Rate Case 23 92000 $ 55,308 8/ $ 55,308 $ 36,753 $ 92,061
A. Jacob 24 Amortization Expense- Deferred Pension 24 92056 $ 23,220 $ 23,220 $ (98,264) $ (75,044)
A. Jacob 25 Amortization Expense- Deferred Tank Painting 25 92053 $ 154,781 $ 154,781 $ 179,306 $ 334,086
A. Jacob 26 Amortization of Excess Deferred Income Taxes 26 92059 $ (200,004) $ (200,004) $ - $ (200,004)
A. Jacob 27 Amortization Expense- Deferred Power 27 92061 $ 264,072 $ 264,072 $ 142,212 $ 406,284
J. Cagle 28 AFUDC Equity Gross Up Amortization 28 92064 $ 46,036 $ 46,036 $ (46,036) $ -
M. Wilson 29 Adjustment to Variable Expenses Due to Volume 29 $ - $ - $ (290,315) $ (290,315)
30 Total Adjusted Operating & Maintenance Expenses $ 22,213,928 $ 359,284 $ 22,573,213 $ 697,848 $ 23,271,060
M. Wilson 31 Total Unadjusted Operating & Maintenance Expenses $ 265,210 $ - $ - $ - $ 265,210
32 Total Operating and Maintenance Adjustments $ 22,479,138 $ 359,284 $ 22,573,213 $ 697,848 $ 23,536,270
EXHIBIT 10, Schedule 2
K. Arp 33 Adjustment to Depreciation Expense 1 70100 &70101 $ 11,273,623 988,168 $ 12,261,791
A. Jacob 34 Amortization of Utility Plant Acquisition Adjustments 2 71255 282,588 (0) $ 282,588
35 Total Depreciation and Amortization $ 11,556,211 $ - $ - $ 988,168 $ 12,544,379
EXHIBIT 10, Schedule 3
M. Wilson 36 Other Tax 1 70200 $ 25,879 $ (25,879) $ -
M. Wilson 37 Property Taxes 2 70203 $ 1,388,498 $ 340,754 $ 1,729,252
M. Wilson 38 Payroll Taxes (combined FICA, FUI, SUI) Pages 3, 4 & 5 70250 $ 977,609 $ 23,310 $ 1,000,920
39 Total Taxes Other $ 2,391,986 $ - $ - $ 338,185 $ 2,730,171
40 Total Operating Expenses $ 36,427,336 $ 359,284 $ 22,573,213 $ 2,024,200 $ 38,810,820
Normalizing Adjustments: To exclude Reserves and adjust Historic Test Year Case No.VEO-W-24-01
1/ Workers Compensation (excludes reserves, adds claims payments GL account 26200) Exhibit No. 10
2/ Employee Healthcare (excludes reserves) Schedule 1-2-3
3/ Chemicals (reclassification amount in Adjusted Test Year to Materials or capitalized) Summary
4/ Bad Debts (reserves booked in separate 90405 account) Bucci/Wilson
5/ Materials (reclassification amount in Adjusted Test Year) Jacob/Cagle/Arp
6/ Vehicle Allocation (excludes reserves, adds claims payments GL account 26200) Page 1 of 1
7/ General Insurance (excludes reserves, adds claims payments GL account 26200, does not include premiums captured in M&S Fees)
8/ Rate Case Expense Amortization (excludes Intervenor funding)
Veolia Water Idaho
Calculation of Depreciation Expense
Case VEO-W-24-01
A B C D E F
Depreciation Cost of Removal Salvage
Plant
Account Gross Plant In Net Depreciable
Number Plant Account Description Service CIAC Advances Plant Depreciation Depreciation COR COR Salvage Salvage
12/31/2024 12/31/2024 12/31/2024 12/31/2024 Rate Expense Rate Expense Rate Expense
301-10 Organization $ 103,738 $ - $ (6,986) $ 96,752 0.00% $ - 0.00% $ - 0.00% $ -
Organization-CIAC - (9,878) - (9,878) 0.00% - 0.00% - 0.00% -
302-10 Franchise Rights 41,182 - - 41,182 0.00% - 0.00% - 0.00% -
303-20 Land & Land Rights-Source of Supply 3,106,589 - (387,217) 2,719,372 0.00% - 0.00% - 0.00% -
Land and Land Rights-SOS-CIAC - (341,987) - (341,987) 0.00% - 0.00% - 0.00% -
303-2W Water Rights-Source of Supply 8,629,377 - - 8,629,377 0.00% - 0.00% - 0.00% -
303-30 Land & Land Rights-Water Treatment 889,034 - - 889,034 0.00% - 0.00% - 0.00% -
303-40 Land & Land Rights-Trans. & Distrib. 1,242,681 - 3,644 1,246,325 0.00% - 0.00% - 0.00% -
303-50 Land & Land Rights-General Plant 430,405 - - 430,405 0.00% - 0.00% - 0.00% -
304-20 Structures and Improvements-Source of Supply 11,953,434 - (566,333) 11,387,101 2.31% 263,042 0.31% 35,300 0.00% -
Str& Imprv.-Source of Supply-CIAC - (353,797) - (353,797) 2.31% (8,173) 0.31% (1,097) 0.00% -
304-30 Structures and Improvements-Water Treatment 15,921,818 - - 15,921,818 2.07% 329,582 0.31% 49,358 0.00% -
Str& Imprv.-Water Treatment-CIAC - (29,187) - (29,187) 2.07% (604) 0.31% (90) 0.00% -
304-40 Structures and Improvements-Trans. & Distrib. 3,668,357 - 8,485 3,676,842 2.55% 93,759 0.34% 12,501 0.00% -
Str& Imprv.-Trans& Distrib-CIAC - (133,699) - (133,699) 2.55% (3,409) 0.34% (455) 0.00% -
304-50 Structures and Improvements-General Plant 7,709,264 - - 7,709,264 2.36% 181,939 0.37% 28,524 0.00% -
305-20 Collecting & Impounding Reservoirs-Source of Supply 44,944 - - 44,944 1.67% 751 0.00% - 0.00% -
306-20 Lake, River&Other Intakes 1,518,794 - - 1,518,794 1.68% 25,516 0.00% - 0.00% -
Lake, River&Other Intakes-CIAC - (72,696) - (72,696) 1.68% (1,221) 0.00% - 0.00% -
307-20 Wells&Springs 12,133,056 - (132,638) 12,000,419 1.44% 172,806 0.30% 36,001 0.00% -
Wells&Springs-CIAC - (1,405,459) - (1,405,459) 1.44% (20,239) 0.30% (4,216) 0.00% -
308-20 Infiltration Galleries&Tunnels - - - - 0.00% - 0.00% - 0.00% -
309-20 Supply Mains 3,038,066 - (40,115) 2,997,950 1.30% 38,973 0.00% - 0.00% -
Supply Mains-CIAC - (9,391) - (9,391) 1.30% (122) 0.00% - 0.00% -
310-20 Power Generation Equipment 3,844,577 - 1,761 3,846,337 4.25% 163,469 0.00% - 0.00% -
Power Generation Equipment-CIAC - 500 - 500 4.25% 21 0.00% - 0.00% -
311-20 Power Electric Pumping Equipment-Source of Supply 21,256,100 - (473,841) 20,782,258 3.39% 704,519 1.26% 261,856 0.00% -
Electric Pump. Equip.-Source of Supply-CIAC - (2,464,078) - (2,464,078) 3.39% (83,532) 1.26% (31,047) 0.00% -
311-30 Power Pumping Equipment-Water Treatment 4,881,362 - - 4,881,362 3.39% 165,478 1.26% 61,505 0.00% -
311-40 Power Pumping Equipment-Trans. & Distrib. 9,734,038 - 23,337 9,757,375 3.39% 330,775 1.26% 122,943 0.00% -
Power Pump Equip-T&D-CIAC - (661,606) - (661,606) 3.39% (22,428) 1.26% (8,336) 0.00% -
320-30 Water Treatment Equipment 45,211,390 - (12,775) 45,198,615 1.85% 836,174 0.77% 348,029 0.00% -
Water Treatment Equipment-CIAC - (49,094) - (49,094) 1.85% (908) 0.77% (378) 0.00% -
320-30 Water Treatment Equipment-Membranes 1,237,061 - - 1,237,061 12.50% 154,633 0.00% - 0.00% -
330-40 Distribution Reservoirs&Standpipes 24,198,455 - (827,861) 23,370,593 2.00% 467,412 0.13% 30,382 0.00% -
Distribution Reservoirs&Standpipes-CIAC - (2,108,957) - (2,108,957) 2.00% (42,179) 0.13% (2,742) 0.00% -
331-40 Trans. & Distrib. Mains&Accessories 288,852,411 - (2,135,602) 286,716,809 1.43% 4,100,050 0.41% 1,175,539 -0.02% (57,343)
T&D Mains&Accessories-CIAC - (125,606,243) - (125,606,243) 1.43% (1,796,169) 0.41% (514,986) -0.02% 25,121
333-40 Services 119,906,244 - (228,199) 119,678,045 1.32% 1,579,750 0.91% 1,089,070 -0.04% (47,871)
Services-CIAC - (34,524,358) - (34,524,358) 1.32% (455,722) 0.91% (314,172) -0.04% 13,810
334-40 Meters and Meter Installations 22,577,115 - - 22,577,115 5.36% 1,210,133 0.38% 85,793 -0.38% (85,793)
Meters-CIAC - (70,809) - (70,809) 5.36% (3,795) 0.38% °(269) -0.38% 269
335-40 Hydrants 19,830,150 - (6,986) 19,823,164 2.47% 489,632 0.00% - 0.00% -
Hydrants-CIAC - (6,451,772) - (6,451,772) 2.47% (159,359) 0.00% - 0.00% -
340-500 Office Furniture and Equipment 1,221,064 - - 1,221,064 6.67% 81,445 0.00% - 0.00% -
340-5H0 Computer Equipment- Hardware 291,486 - - 291,486 20.00% 58,297 0.00% - 0.00% -
340-5S0 Computer Equipment-Software 10,528 - - 10,528 20.00% 2,106 0.00% - 0.00% -
Office Furniture& Equipment-CIAC - - - - 6.67% - 0.00% - 0.00% -
341-50 Transportation Equipment 2,550,501 - - 2,550,501 10.59% 270,098 0.00% - -1.10% (28,056)
342-50 Stores Equipment 216,491 - - 216,491 4.76% 10,305 0.00% - 0.00% -
343-50 Tools, Shop and Garage Equipment 1,845,943 - - 1,845,943 5.88% 108,541 0.00% - 0.00% -
344-50 Laboratory Equipment 49,478 - - 49,478 10.00% 4,948 0.00% - 0.00% -
Laboratory Equipment-CIAC - - - - 10.00% - 0.00% - 0.00% -
345-50 Power Operated Equipment 1,191,049 - - 1,191,049 9.91% 118,033 0.00% - -1.13% (13,459)
346-50 Communications Equipment 6,841,318 - 215,909 7,057,227 5.26% 371,210 0.26% 18,349 0.00% -
Communications Equipment-CIAC - (148,955) - (148,955) 5.26% (7,835) 0.26% (387) 0.00% -
347-50 Miscellaneous Equipment 170,834 - - 170,834 6.67% 11,395 0.00% - 0.00% -
348-50 Other Tangible Property 894,659 - - 894,659 2.00% 17,893 0.00% - 0.00% -
348-50 Master Plan 3,722,064 - - 3,722,064 10.00% 372,206 0.00% - 0.00% -
Amortization of Reserve Balance Difference 90,983
(10 Year Period)-See Depreciation Study(SUZ-W-20-02)
TOTAL $ 650,965,055 $ (174,441,466) $ (4,565,418) $ 471,958,171 $ 10,220,179 $ 2,476,976 $ (193,322)
Test Year Ending December 31,2024 Total
Depreciation and Amortization Expense $ 12,503,833 $ 10,220,179 $ 2,476,976 $ (193,322)
Transportation Expense (242,043) (270,098) - 28,056
Net Test Year Depreciation Expense $ 12,261,790 = $ 9,950,081 + $ 2,476,976 + $ (165,266)
Historic Test Year Ending August 31, 2024
Depreciation and Amortization Expense $ 11,556,211 $ 9,370,166 $ 2,186,045 $ -
Transportation Expense (282,588) (282,588) -Net Historic Test Year Depreciation and Amortization 11,273,623 = 9,087,578 + 2,186,045 + -
Test Year Adjustment $ 988,167 $ 862,502 $ 290,931 $ (165,266)
Case No.VEO-W-24-01
Exhibit No. 10
Schedule 2
K.Arp
Page 1 of 1
Veolia Water Idaho
Rate Case VEO-W-24-01
Rate Base Summary
For The Test Year Ending December 31, 2024
Exhibit 11 Schedule
Line No. Rate Base Element Reference Basis of Calculation Amount
1 Gross Utility Plant in Service Schedule 3 Average Monthly Average $ 628,494,507
2 Total Accumulated Depreciation and CIAC Amortization Schedule 4 Average Monthly Average (197,338,636)
3 Net Utility Plant in Service $ 431,155,871
4 Customer Advances for Construction Schedule 5 Average Monthly Average $ (3,798,792)
5 Contributions in Aid of Construction (net of amortization) Schedule 6 Average Monthly Average (128,427,920)
6 Utility Plant Acquistion Adjustment Net Schedule 7 Average Monthly Average 10,461,498
7 Accumulated Deferred Income Taxes Schedule 8 Average Monthly Average (7,717,363)
8 Deferred Charges Included in Rate Base Schedule 9 Average Monthly Average 2,201,561
9 Materials & Supplies Schedule 10 Average Monthly Average 1,676,979
10 Prepayments Schedule 11 Average Monthly Average 98,104
11 Working Capital Allowance Schedule 12 Exhibit 14 4,581,200
12 Regulatory Liability-New Federal Tax Law(TCJA) Schedule 13 Average Monthly Average (3,823,676)
13 Total Rate Base $ 306,407,462
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 1
K.Arp
Page 1 of 1
Veolia Water Idaho
Summary Rate Base Calculation
13-month Average Monthly Average Worksheet
Case VEO-W-24-01 Actual Amounts Projected Amounts
Line No. Rate Base Element 12/31/2023 01/31/2024 02/29/2024 03/31/2024 04/30/2024 05/31/2024 06/30/2024 07/31/2024 08/31/2024 09/30/2024 10/31/2024 11/30/2024 12/31/2024 AMA
1 Utility Plant in Service $ 606,421,789 $ 608,189,622 $ 610,281,003 $ 614,642,437 $ 624,614,352 $ 627,444,026 $ 634,503,649 $ 635,781,866 $ 637,356,543 $ 637,967,754 $ 638,286,181 $ 644,173,230 $ 650,965,055
2 Gross Plant In Service 606,421,789 608,189,622 610,281,003 614,642,437 624,614,352 627,444,026 634,503,649 635,781,866 637,356,543 637,967,754 638,286,181 644,173,230 650,965,055 628,494,507
3 Accumulated Depreciation-Utility Plant (147,063,580) (147,699,003) (148,384,805) (148,564,691) (148,646,325) (149,363,127) (150,023,571) (150,706,788) (151,349,061) (151,241,026) (151,967,372) (152,479,795) (152,714,035)
4 Retirement Work in Progress 872,609 956,187 591,969 522,861 785,874 635,406 546,452 2,856,298 814,948
5 Cost of Removal Regulatory Asset 5,483,101 5,349,460 5,701,732 5,797,519 5,709,070 5,704,854 5,702,285 5,641,156 5,568,127 5,431,597 5,294,796 5,171,067 5,203,911
6 Accumulated Amortization CIAC (52,287,455) (52,505,071) (52,724,169) (52,944,145) (53,165,067) (53,387,120) (53,611,021) (53,835,143) (53,835,143) (54,052,282) (54,269,422) (54,486,561) (54,703,701)
7 Total Accumulated Depreciation &Amortization (192,995,324) (193,898,427) (194,815,273) (195,188,456) (195,316,448) (196,409,987) (197,385,855) (196,044,477) (198,801,129) (199,861,711) (200,941,998) (201,795,290) (202,213,825) (197,338,636)
8 Customer Advances for Construction (3,790,141) (3,790,141) (3,790,141) (3,790,141) (3,804,931) (3,804,931) (3,801,561) (3,801,561) (3,801,561) (3,801,561) (3,801,561) (3,801,561) (3,801,561) (3,798,792)
9 Contributions in Aid of Construction-Net (120,868,228) (121,478,539) (123,389,277) (123,375,492) (123,425,165) (125,733,886) (132,504,977) (132,456,577) (133,350,036) (133,132,602) (132,915,462) (132,698,323) (132,481,183) (128,427,920)
10 Utility Plant Acquisition Adjustment (Net) 10,602,792 10,579,243 10,555,694 10,532,145 10,508,596 10,485,047 10,461,498 10,437,949 10,414,400 10,390,851 10,367,303 10,343,754 10,320,205 10,461,498
11 Accumulated Deferred Income Taxes (6,651,495) (6,801,444) (7,174,544) (7,218,037) (7,382,099) (7,612,578) (7,805,929) (7,955,731) (8,087,274) (8,204,714) (8,322,154) (8,439,594) (8,557,034) (7,717,363)
12 Deferred Charges 2,129,806 2,116,862 2,103,917 2,090,973 2,078,028 2,065,084 2,052,140 2,039,195 2,026,251 2,013,307 2,000,362 1,987,418 5,560,585 2,201,561
13 Materials & Supplies 1,652,232 1,683,953 1,679,094 1,658,955 1,663,150 1,666,288 1,660,555 1,682,099 1,650,997 1,700,724 1,700,724 1,700,724 1,700,724 1,676,979
14 Prepayments 174,448 155,065 135,682 116,299 96,916 77,533 58,149 38,766 19,383 - 169,200 153,818 138,436 98,104
15 Regulatory Liability-New Federal Tax Law (TCJA) (3,923,678) (3,907,011) (3,890,344) (3,873,677) (3,857,010) (3,840,343) (3,823,676) (3,807,009) (3,790,342) (3,773,675) (3,757,008) (3,740,341) (3,723,674) (3,823,676)
16 Total Rate Base $ 290,925,522 $ 292,849,182 $ 291,695,810 $ 295,595,005 $ 305,175,389 $ 304,336,253 $ 303,413,993 $ 305,914,520 $ 303,637,232 $ 303,298,373 $ 302,785,586 $ 307,883,835 $ 317,907,728 $ 301,826,262
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 2
K.Arp
Page 1 of 1
Veolia Water Idaho
Utility Plant In Service with Forecast Additions and Retirements
Case VEO-W-24-01
Plant In Service Forecast September 2024 Plant In Service Forecast October 2024 Plant In Service Forecast November 2024 Plant In Service Forecast December 2024 Plant In Service
Plant
Account
Number Plant Account Description 08/31/2024 Additions Retirements 09/30/2024 Additions Retirements 10/31/2024 Additions Retirements 11/30/2024 Additions Retirements 12/31/2024
301-10 Organization 103,738 - - 103,738 - - 103,738 - - 103,738 - - 103,738
302-10 Franchise Rights 41,182 - - 41,182 - - 41,182 - - 41,182 - - 41,182
303-20 Land & Land Rights-Source of Supply 3,106,589 - - 3,106,589 - - 3,106,589 - - 3,106,589 - - 3,106,589
303-2W Water Rights-Source of Supply 8,541,209 - - 8,541,209 - - 8,541,209 - - 8,541,209 88,168 - 8,629,377
303-30 Land & Land Rights-Water Treatment 889,034 - 889,034 - 889,034 - 889,034 - - 889,034
303-40 Land & Land Rights-Trans. & Distrib. 1,242,681 - 1,242,681 - 1,242,681 - 1,242,681 - 1,242,681
303-50 Land & Land Rights-General Plant 430,405 - - 430,405 - - 430,405 - - 430,405 - - 430,405
304-20 Structures and Improvements-Source of Supply 11,792,864 - - 11,792,864 - - 11,792,864 - - 11,792,864 176,526 (15,956) 11,953,434
304-30 Structures and Improvements-Water Treatment 15,921,818 - - 15,921,818 - - 15,921,818 - - 15,921,818 - - 15,921,818
304-40 Structures and Improvements-Trans. & Distrib. 3,668,357 - - 3,668,357 - - 3,668,357 - - 3,668,357 - - 3,668,357
304-50 Structures and Improvements-General Plant 7,057,372 - - 7,057,372 - - 7,057,372 - - 7,057,372 651,892 - 7,709,264
305-20 Collecting & Impounding Reservoirs-Source of Supply 44,944 - - 44,944 - - 44,944 - - 44,944 - - 44,944
306-20 Lake, River& Other Intakes 1,518,794 - - 1,518,794 - - 1,518,794 - - 1,518,794 - - 1,518,794
307-20 Wells& Springs 9,756,699 - - 9,756,699 - - 9,756,699 1,884,020 - 11,640,719 652,037 (159,700) 12,133,056
308-20 Infiltration Galleries&Tunnels - - - - - - - - - - - - -
309-20 Supply Mains 3,038,066 - - 3,038,066 - - 3,038,066 - - 3,038,066 - - 3,038,066
310-20 Power Generation Equipment 3,844,577 - - 3,844,577 - - 3,844,577 - - 3,844,577 - - 3,844,577
311-20 Power Electric Pumping Equipment-Source of Supply 20,649,099 - - 20,649,099 - - 20,649,099 299,261 (84,900) 20,863,460 446,640 (54,000) 21,256,100
311-30 Power Pumping Equipment-Water Treatment 4,881,362 - - 4,881,362 - - 4,881,362 - - 4,881,362 - - 4,881,362
311-40 Power Pumping Equipment-Trans. & Distrib. 9,718,417 - - 9,718,417 - - 9,718,417 - - 9,718,417 15,621 - 9,734,038
320-30 Water Treatment Equipment 44,557,404 - 44,557,404 - 44,557,404 - 44,557,404 827,288 (173,302) 45,211,390
320-31VI0 Water Treatment Equipment-Membranes 1,237,061 - 1,237,061 - 1,237,061 - 1,237,061 - - 1,237,061
330-40 Distribution Reservoirs& Standpipes 24,200,455 - - 24,200,455 - - 24,200,455 - - 24,200,455 - (2,000) 24,198,455
331-40 Trans. & Distrib. Mains&Accessories 283,817,090 433,184 (750) 284,249,524 55,105 (750) 284,303,879 3,262,518 (134,678) 287,431,719 1,449,420 (28,728) 288,852,411
333-40 Services 118,259,883 66,126 (16,300) 118,309,709 49,595 (16,300) 118,343,003 462,882 (16,300) 118,789,585 1,132,959 (16,300) 119,906,244
334-40 Meters and Meter Installations 22,728,552 27,553 (72,300) 22,683,805 27,553 (72,300) 22,639,057 55,105 (72,300) 22,621,862 27,553 (72,300) 22,577,115
335-40 Hydrants 19,279,100 165,315 - 19,444,415 275,525 - 19,719,940 55,105 - 19,775,045 55,105 - 19,830,150
340-500 Office Furniture and Equipment 1,221,064 - - 1,221,064 - - 1,221,064 - - 1,221,064 - - 1,221,064
340-51-10 Computer Equipment- Hardware 226,404 - - 226,404 - - 226,404 - - 226,404 84,858 (19,775) 291,486
340-5S0 Computer Equipment-Software 10,528 - - 10,528 - - 10,528 - - 10,528 - - 10,528
341-50 Transportation Equipment 2,324,571 - - 2,324,571 - - 2,324,571 - - 2,324,571 225,931 - 2,550,501
342-50 Stores Equipment 216,491 - - 216,491 - - 216,491 - - 216,491 - - 216,491
343-50 Tools, Shop and Garage Equipment 1,763,811 - - 1,763,811 - - 1,763,811 - - 1,763,811 88,168 (6,036) 1,845,943
344-50 Laboratory Equipment 49,478 - - 49,478 - - 49,478 - - 49,478 - - 49,478
345-50 Power Operated Equipment 1,191,049 - - 1,191,049 - - 1,191,049 - - 1,191,049 - - 1,191,049
346-50 Communications Equipment 6,005,899 27,586 (19,200) 6,014,285 - 6,014,285 - 6,014,285 879,193 (52,160) 6,841,318
347-50 Miscellaneous Equipment 170,834 - - 170,834 - 170,834 - 170,834 - - 170,834
348-50 Other Tangible Property 894,659 - 894,659 - 894,659 - 894,659 - - 894,659
348-50 Master Plan 2,955,002 - - 2,955,002 - - 2,955,002 176,336 - 3,131,338 590,726 - 3,722,064
TOTAL 637,356,541 1 719,763 (108,550)1 637,967,754 1 407,777 (89,350)1 638,286,181 1 6,195,227 (308,178)1 644,173,230 1 7,392,083 (600,258)1 650,965,055
Case No. VEO-W-24-01
Exhibit No. 11
Schedule 3
K.Arp
Page 1 of 1
Veolia Water Idaho
Case VEO-W-24-01
Accumulated Depreciation And Accumulated CIAC Amortization
Actual Amounts Forecasted Amounts
Line No. Description 01/31/2024 02/29/2024 03/31/2024 04/30/2024 05/31/2024 06/30/2024 07/31/2024 08/31/2024 09/30/2024 10/31/2024 11/30/2024 12/31/2024
1 Accumulated Depreciation-Recorded $ (146,742,816) $ (147,792,836) $ (148,041,830) $ (147,860,451) $ (148,727,721) $ (149,477,119) $ (147,850,491) $ (150,534,113)
2 Incremental Depreciation $ (815,462) $ (815,697) $ (820,600) $ (834,498)
3 Retirements 108,550 89,350 308,178 600,258
4 Total Accumulated Depreciation $ (146,742,816) $ (147,792,836) $ (148,041,830) $ (147,860,451) $ (148,727,721) $ (149,477,119) $ (147,850,491) $ (150,534,113) $ (151,241,026) $ (151,967,372) $ (152,479,795) $ (152,714,035)
5 Cost of Removal Regulatory Asset- Recorded 5,349,460 5,701,732 5,797,519 5,709,070 5,704,854 5,702,285 5,641,156 5,568,127
6 Incremental Cost of Removal $ (201,490) $ (201,504) $ (202,655) $ (205,059)
7 Incremental Salvage 15,810 15,803 15,826 15,983
8 Cost of Removal 51,450 51,200 65,400 224,220
9 Salvage (2,300) (2,300) (2,300) (2,300)
10 Total Cost of Removal Regulatory Asset $ 5,349,460 $ 5,701,732 $ 5,797,519 $ 5,709,070 $ 5,704,854 $ 5,702,285 $ 5,641,156 $ 5,568,127 $ 5,431,597 $ 5,294,796 $ 5,171,067 $ 5,203,911
11 CIAC Amortization-Recorded (52,505,071) (52,724,169) (52,944,145) (53,165,067) (53,387,120) (53,611,021) (53,835,143) (53,835,143)
12 Incremental CIAC Amortization $ (217,140) $ (217,140) $ (217,140) $ (217,140)
13 Total CIAC Amortization $ (52,505,071) $ (52,724,169) $ (52,944,145) $ (53,165,067) $ (53,387,120) $ (53,611,021) $ (53,835,143) $ (53,835,143) $ (54,052,282) $ (54,269,422) $ (54,486,561) $ (54,703,701)
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 4
K.Arp
Page 1 of 1
Veolia Water Idaho
Developer Advances for Construction Subject to Refund
Case VEO-W-24-01
Advances Sep-24 Advances Oct-24 Advances Nov-24 Advances Dec-24 Advances
Plant
Account Forecast Forecast Forecast Forecast
Number Plant Account Description 08/31/2024 Activity 09/30/2024 Activity 10/31/2024 Activity 11/30/2024 Activity 12/31/2024
301-10 Organization (6,986) (6,986) (6,986) (6,986) (6,986)
303-20 Land and Land Rights- Source of Supply (387,217) (387,217) (387,217) (387,217) (387,217)
303-40 Land and Land Rights-T&D 3,644 3,644 3,644 3,644 3,644
304-20 Str& Imprv.-Source of Supply (566,333) (566,333) (566,333) (566,333) (566,333)
304-40 Str& Imprv.-Trans & Distrib 8,485 8,485 8,485 8,485 8,485
307-20 Wells & Springs (132,638) (132,638) (132,638) (132,638) (132,638)
309-20 Supply Mains (40,115) (40,115) (40,115) (40,115) (40,115)
310-20 Power Generation Equipment 1,761 1,761 1,761 1,761 1,761
311-20 Electric Pump. Equip.-Source of Supply (473,841) (473,841) (473,841) (473,841) (473,841)
311-40 Power Pump Equip-T&D 23,337 23,337 23,337 23,337 23,337
320-30 Water Treatment Equipment (12,775) (12,775) (12,775) (12,775) (12,775)
330-40 Distribution Reservoirs & Standpipes (827,861) (827,861) (827,861) (827,861) (827,861)
331-40 T&D Mains &Accessories (2,135,602) (2,135,602) (2,135,602) (2,135,602) (2,135,602)
333-40 Services (228,199) (228,199) (228,199) (228,199) (228,199)
335-40 Hydrants (6,986) (6,986) (6,986) (6,986) (6,986)
346-50 Communications Equipment 215,909 215,909 215,909 215,909 215,909
AIAC in CWIP 763,857 763,857 763,857 763,857 763,857
TOTAL (3,801,560.93) - (3,801,560.93) - (3,801,560.93) -+-(3,801,560.93) (3,801,560.93)
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 5
K.Arp
Page 1 of 1
Veolia Water Idaho
Contributions In Aid of Construction
Case VEO-W-24-01
CIAC Sep-24 CIAC Oct-24 CIAC Nov-24 CIAC Dec-24 CIAC
Plant
Account Forecast Forecast Forecast Forecast
Number Plant Account Description 08/31/2024 Activity 09/30/2024 Activity 10/31/2024 Activity 11/30/2024 Activity 12/31/2024
301-10 Organization (9,878) (9,878) (9,878) (9,878) (9,878)
303-20 Land and Land Rights- Source of Supply (341,987) (341,987) (341,987) (341,987) (341,987)
303-50 Land and Land Rights- General Plant (295)
304-20 Str& Imprv.-Source of Supply (353,797) (353,797) (353,797) (353,797) (353,797)
304-30 Str& Imprv.-Water Treatment (29,187) (29,187) (29,187) (29,187) (29,187)
304-40 Str& Imprv.-Trans & Distrib (133,699) (133,699) (133,699) (133,699) (133,699)
306-20 Lake, River& Other Intakes (72,696) (72,696) (72,696) (72,696) (72,696)
307-20 Wells & Springs (1,405,459) (1,405,459) (1,405,459) (1,405,459) (1,405,459)
309-20 Supply Mains (9,391) (9,391) (9,391) (9,391) (9,391)
310-20 Power Generation Equipment 500 500 500 500 500
311-20 Electric Pump. Equip.-Source of Supply (2,464,078) (2,464,078) (2,464,078) (2,464,078) (2,464,078)
311-40 Power Pump Equip-T&D (661,606) (661,606) (661,606) (661,606) (661,606)
320-30 Water Treatment Equipment (49,094) (49,094) (49,094) (49,094) (49,094)
330-40 Distribution Reservoirs & Standpipes (2,108,957) (2,108,957) (2,108,957) (2,108,957) (2,108,957)
331-40 T&D Mains&Accessories (125,606,243) (125,606,243) (125,606,243) (125,606,243) (125,606,243)
333-40 Services (34,524,358) (34,524,358) (34,524,358) (34,524,358) (34,524,358)
334-40 Meters (70,809) (70,809) (70,809) (70,809) (70,809)
335-40 Hydrants (6,451,772) (6,451,772) (6,451,772) (6,451,772 (6,451,772)
340-50 Office Furniture & Equipment - - - - -
344-50 Laboratory Equipment - - - - -
346-50 Communications Equipment (148,955) (148,955) (148,955) (148,955) (148,955)
CIAC IN CWIP (12,886,525) (12,886,525) (12,886,525) (12,886,525) (12,886,525)
TOTAL (187,328,285.74) - (187,327,991) - (187,327,991) - (187,327,991) - (187,327,991)
Monthly CIAC Amortization 53,978,250 217,140 54,195,389 217,140 54,412,529 217,140 54,629,668 217,140 54,846,808
Net CIAC (133,350,036.05) 217,140 (133,132,602) 217,140 (132,915,462) 217,140 (132,698,323) 217,140 (132,481,183)
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 6
K.Arp
Page 1 of 1
Veolia Water Idaho
Case VEO-W-24-01
Summary of Net Utility Plant Acquisition Adjustments
Accumulated
Utility Plant Amortization
Acquisition of UPAA Unamortized Monthly
Company IPUC Order Amortization Adjustment Through Balance at Amortization
Line No. Acquistion Description Project ID Month Period Amount 08/31/2024 08/31/2024 Amount
1 Warm Springs Mesa X00009 Aug-96 20 Years $62,302 ($62,302) $0 $0
2 Redwood Creek X00010 May-95 20 Years (110,249) 110,249 0 0
3 Island Woods X00011 Apr-95 20 Years (179,675) 179,675 0 0
4 Raintree X00014 Sep-00 40 Years (227,594) 136,586 (91,008) 474
5 South County Water X00020 Jan-99 40 Years 1,009,011 (647,467) 361,544 (2,102)
6 Barber Water X00027 Jan-99 40 Years 46,966 (28,934) 18,032 (98)
7 Eagle Water ACQ_EAGLE May-23 40 Years 10,475,000 (349,168) 10,125,832 (21,823)
$11,075,761 ($661,361) $10,414,400 ($23,549)
Monthly Ending Annual Amortization Amount $282,585
Month Amortization Balance
8 August-24 10,414,400
9 September-24 (23,549) 10,390,851
10 October-24 (23,549) 10,367,303
11 November-24 (23,549) 10,343,754
12 December-24 (23,549) 10,320,205
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 7
K.Arp
Page 1 of 1
Veolia Water Idaho
Case VEO-W-24-01
Accumulated Deferred Income Taxes as of
December 31, 2024
Actuals Forecasted
Balance at Dec Balance at Jan Balance at Feb Balance at Mar Balance at Apr Balance at Balance at Jun Balance at Balance at Balance at Balance at Oct Balance at Balance at Dec Balance at Dec Test Year
Line No. Account & Description 31, 2023 31, 2024 29, 2024 31, 2024 30, 2024 May 31, 2024 30, 2024 July 31, 2024 Aug 31, 2024 Sept 30, 2024 31, 2024 Nov 30, 2024 31, 2024 3132024 Adjustments
1 Accumulated Deferred FIT-MACRS $ 4,773,833 $ 4,888,180 $ 5,088,336 $ 5,049,143 $ 5,123,906 5,191,058 $ 5,381,908 $ 5,469,190 $ 5,555,738 5,651,808 5,747,877 5,843,946 5,940,015 $ 5,940,015 $ 384,277
2 Accumulated Deferred FIT Cost of Removal 1,900,293 1,944,819 1,989,593 2,069,261 2,125,502 2,181,741 2,166,621 2,210,967 2,255,314 2,255,314 2,255,314 2,255,314 2,255,314 2,255,314 $ -
3 Def. FIT-Tank Painting 754,416 742,192 867,061 866,778 896,535 1,000,323 1,014,643 1,029,516 1,026,863 1,044,933 1,063,003 1,081,074 1,099,144 1,099,144 $ 72,281
4 Def FIT- New Federal Tax Rate (777,047) (773,746) (770,446) (767,145) (763,844) (760,544) (757,243) (753,942) (750,641) (747,341) (744,040) (740,739) (737,438) (737,438) $ 13,203
5 Accumulated Deferred Income Taxes $ 6,651,495 $ 6,801,444 $ 7,174,544 $ 7,218,037 $ 7,382,099 $ 7,612,578 $ 7,805,929 $ 7,955,731 $ 8,087,274 $ 8,204,714 $ 8,322,154 $ 8,439,594 $ 8,557,034 $ 8,557,034 $ 469,761
6 Pro Forma Tax Depreciation-State $ 6,116,293
7 Pro Forma Book Depreciation 4,033,543
8 Excess Tax Over Book Depreciation $ 2,082,750
9 State Income Tax Rate 5.695%
10 Incremental State Deferred Income Tax 118,613
11 Pro Forma Tax Depreciation-Federal $ 5,982,044
12 Pro Forma Book Depreciation 4,033,543
13 Excess Tax Over Book Depreciation 1,948,501
14 Less: State Deferred Income Tax 118,613
15 Federal Amount 1,829,888
16 Federal Income Tax Rate 21.00%
17 Incremental Federal Deferred Income Tax $ 384,277
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 8
K.Arp
Page 1 of 1
Veolia Water Idaho
Case VEO-W-24-01
Deferred Debits Balance Included in Rate Base
Unamortized
Balance at Amortization Sept 24 Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized Unamortized
Approved August 31, Period in Monthly through Dec 24 Balance at Balance at Balance at Balance at Balance at Balance at Balance at Balance at Balance at Balance at Balance at Balance at Balance at Balance at
Line No. Description Amounts 2024 Months Expense Expense Dec 31,2024 Dec 31,2023 Jan 31,2024 Feb 29,2024 Mar 31,2024 Apr 30,2024 May 31,2024 Jun 30,2024 Jul 31,2024 Aug 31,2024 Sept 30,2024 Oct 31,2024 Nov 30,2024 Dec 31,2024
Amounts Approved In Case UWI-W-04-04:
1 Deferred Rents(Lakewood Well Lease) $ 19,090 $ 10,672 600 46 $ 184 $ 10,488 $ 11,040 $ 10,994 $ 10,948 $ 10,902 $ 10,856 $ 10,810 $ 10,764 $ 10,718 $ 10,672 $ 10,626 $ 10,580 $ 10,534 $ 10,488
2 Deferred Tank Painting-Gowen External 39,808 1,824 240 166 663 1,160 3,151 2,985 2,819 2,653 2,487 2,321 2,156 1,990 1,824 1,658 1,492 1,326 1,160
3 Deferred Tank Painting-Aeronica 21,100 966 240 88 352 615 1,670 1,582 1,494 1,406 1,318 1,230 1,142 1,054 966 878 790 703 615
4 Sub Total $79,998 $13,462 $300 $1,199 $12,263 $15,860 $15,561 $15,261 $14,961 $14,661 $14,361 $14,062 $13,762 $13,462 $13,162 $12,863 $12,563 $12,263
Amounts Approved In Case UWI-W-06.02:
5 Deferred Tank Painting-Federal Reservoir 162,895 15,611 240 679 2,715 12,896 21,040 20,362 19,683 19,004 18,326 17,647 16,968 16,289 15,611 14,932 14,253 13,574 12,896
6 Sub Total $162,895 $15,611 $679 $2,715 $12,896 $21,040 $20,362 $19,683 $19,004 $18,326 $17,647 $16,968 $16,289 $15,611 $14,932 $14,253 $13,574 $12,896
Amounts Approved In Case UWI-W-09.01:
7 Deferred Tank Painting-Ustick 74,183 20,394 240 309 1,236 19,158 22,866 22,557 22,248 21,939 21,630 21,321 21,012 20,703 20,394 20,085 19,776 19,467 19,158
8 Deferred Tank Painting-Steelhead 313,493 86,262 240 1,307 5,228 81,034 96,718 95,411 94,104 92,797 91,490 90,183 88,876 87,569 86,262 84,955 83,648 82,341 81,034
9 Deferred Tank Painting-Crestline 65,628 18,018 240 273 1,092 16,926 20,202 19,929 19,656 19,383 19,110 18,837 18,564 18,291 18,018 17,745 17,472 17,199 16,926
10 Sub Total $453,304 $124,674 $1,889 $7,556 $117,118 $139,786 $137,897 $136,008 $134,119 $132,230 $130,341 $128,452 $126,563 $124,674 $122,785 $120,896 $119,007 $117,118
Amounts Approved In Case UWI-W-11-02:
11 Deferred Tank Painting-Hillcrest 230,134 85,351 240 959 3,836 81,515 93,023 92,064 91,105 90,146 89,187 88,228 87,269 86,310 85,351 84,392 83,433 82,474 81,515
12 Sub Total $230,134 $85,351 $959 $3,836 $81,515 $93,023 $92,064 $91,105 $90,146 $89,187 $88,228 $87,269 $86,310 $85,351 $84,392 $83,433 $82,474 $81,515
Amounts Approved In Case UWI-W-15-01:
13 Deferred Tank Painting-Gowen Internal 208,050 117,894 240 867 3,467 114,426 124,829 123,962 123,095 122,228 121,361 120,494 119,628 118,761 117,894 117,027 116,160 115,293 114,426
14 Sub Total $ 208,050 $ 117,894 $ 867 $ 3,467 $ 114,426 $ 124,829 $ 123,962 $ 123,095 $ 122,228 $ 121,361 $ 120,494 $ 119,628 $ 118,761 $ 117,894 $ 117,027 $ 116,160 $ 115,293 $ 114,426
Amounts Approved In Case SUZ-W-20-02:
15 Deferred Tank Painting-Barber Tank-Internal 338,037 281,677 240 1,409 5,636 276,041 292,949 291,540 290,131 288,722 287,313 285,904 284,495 283,086 281,677 280,268 278,859 277,450 276,041
16 Deferred Tank Painting-Hulls Gulch Internal 1,135,161 945,961 240 4,730 18,920 927,041 983,801 979,071 974,341 969,611 964,881 960,151 955,421 950,691 945,961 941,231 936,501 931,771 927,041
17 Deferred Tank Painting-Hulls Gulch External 213,330 177,770 240 889 3,556 174,214 184,882 183,993 183,104 182,215 181,326 180,437 179,548 178,659 177,770 176,881 175,992 175,103 174,214
18 Deferred Tank Painting-Hidden Hollow(Exterior) 102,317 85,277 240 426 1,704 83,573 88,685 88,259 87,833 87,407 86,981 86,555 86,129 85,703 85,277 84,851 84,425 83,999 83,573
19 Sub Total $ 1,788,845 $ 1,490,685 $ 7,454 $ 29,816 $ 1,460,869 $ 1,550,317 $ 1,542,863 $ 1,535,409 $ 1,527,955 $ 1,520,501 $ 1,513,047 $ 1,505,593 $ 1,498,139 $ 1,490,685 $ 1,483,231 $ 1,475,777 $ 1,468,323 $ 1,460,869
Amounts Approved In Case VEO-W-22-02:
20 Deferred Tank Painting-Broken Horn 65,239 60,887 240 272 1,088 59,799 63,063 62,791 62,519 62,247 61,975 61,703 61,431 61,159 60,887 60,615 60,343 60,071 59,799
21 Deferred Tank Painting-Columbia 126,088 117,688 240 525 2,100 115,588 121,888 121,363 120,838 120,313 119,788 119,263 118,738 118,213 117,688 117,163 116,638 116,113 115,588
22 Sub Total $191,327 $178,575 $797 $3,188 $175,387 $184,951 $184,154 $183,357 $182,560 $181,763 $180,966 $180,169 $179,372 $178,575 $177,778 $176,981 $176,184 $175,387
Proposed
New Items Amortization Proposed Proposed Unamortized New Items New Items New Items New Items New Items New Items New Items New Items New Items New Items New Items New Items New Items
Proposed in Period in Monthly Annual Balance at Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in Proposed in
Current Case Months Expense Expense Dec 31,2024 Current Case Current Case Current Case Current Case Current Case Current Case Current Case Current Case Current Case Current Case Current Case Current Case Current Case
23 Deferred Tank Painting-Barber(interior) 502,182 240 2,092 25,109 502,182 - - - - - - - - - - - - 502,182
24 Deferred Tank Painting-Broken Horn(interior) 414,000 240 1,725 20,700 414,000 - - - - - - - - - - - - 414,000
25 Deferred Tank Painting-Columbia CWTP Clearwell(interior) 655,353 240 2,731 32,768 655,353 - - - - - - - - - - - - 655,353
26 Deferred Tank Painting-Good Street(interior) 800,252 240 3,334 40,013 800,252 - - - - - - - - - - - - 800,252
27 Deferred Tank Painting-Hidden Hollow(interior) 415,431 240 1,731 20,772 415,431 - - - - - - - - - - - - 415,431
28 Deferred Tank Painting-North Mountain Tank(interior&exterior) 271,819 240 1,133 13,591 271,819 - - - - - - - - - - - - 271,819
29 Deferred Tank Painting-Ustick(exterior) 89,307 240 372 4,465 89,307 - - - - - - - - - - - - 89,307
30 Deferred Tank Painting-Ustick(interior) 437,767 240 1,824 21,888 437,767 437,767
$3,586,112 $14,942 $179,306 $3,686,112 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $3,586,112
31 Sub Total
32 Grand Total $3,114,552 $5,612,363 $27,887 $231,083 $5,560,585 $2,129,806 $2,116,862 $2,103,917 $2,090,973 $2,078,028 $2,065,084 $2,052,140 $2,039,195 $2,026,251 $2,013,307 $2,000,362 $1,987,418 $5,560,585
33 Average Monthly Average $2,201,561
Case No.VEO-W-24-01
Exhibit No.11
Schedule 9
K.Arp
Page 1 of 1
Veolia Water Idaho
Case VEO-W-24-01
Materials and Supplies as of December 31, 2024
Balance at Balance at Balance at Balance at Balance at Balance at Balance at Jun Balance at Balance at Balance at Balance at Balance at Balance at Dec
Line No. Account & Description Dec 31, 2023 Jan 31, 2024 Feb 29, 2024 Mar 31, 2024 Apr 30, 2024 May 31, 2024 30, 2024 Jul 31, 2024 Aug 31, 2024 Sept 30, 2024 Oct 31, 2024 Nov 30, 2024 31, 2024
1 Materials and Supplies 1,652,232 1,683,953 1,679,094 1,658,955 1,663,150 1,666,288 1,660,555 1,682,099 1,650,997 1,700,724 1,700,724 1,700,724 1,700,724
2 Total $1,652,232 $1,683,953 $1,679,094 $1,658,955 $1,663,150 $1,666,288 $1,660,555 $1,682,099 $1,650,997 $1,700,724 $1,700,724 $1,700,724 $1,700,724
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 10
K.Arp
Page 1 of 1
Veolia Water Idaho
Case VEO-W-24-01
Prepayments as of December 31, 2024
Balance at Balance at Balance at Balance at Balance at Balance at Balance at Jun Balance at Balance at Balance at Balance at Balance at Balance at Dec
Line No. Account& Description Dec 31, 2023 Jan 31, 2024 Feb 29, 2024 Mar 31, 2024 Apr 30, 2024 May 31, 2024 30, 2024 Jul 31, 2024 Aug 31, 2024 Sept 30, 2024 Oct 31, 2024 Nov 30, 2024 31, 2024
1 Prepayments 174,448 155,065 135,682 116,299 96,916 77,533 58,149 38,766 19,383 - 169,200 153,818 138,436
2 Total $174,448 $155,065 $135,682 $116,299 $96,916 $77,533 $58,149 $38,766 $19,383 $0 $169,200 $153,818 $138,436
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 11
K.Arp
Page 1 of 1
Veolia Water Idaho
Cash Working Capital Requirements Water Utility
Adjusted Test Year Ending December 31, 2024
Water Services Lead Lag Summary
(Lead)
Line Annual Lag Weighted
No Revenue & Expense Days Amount
1 Total Revenue Lag Water Utility $56,235,286 52.13 $2,931,507,358
2
3 Operation &Maintenance Expense
4 Labor $7,941,553 14.00 $111,181,736
5 Payroll Overheads (Fringe Benefit Allocation) -$1,439,454 14.00 -$20,152,354
6 Pension Payments $680,609 0.00 $0
7 OPEB Payments -$486,928 0.00 $0
8 Group Health and Life Insurance $1,962,090 3.03 $5,937,907
9 401K Payments $536,868 0.00 $0
10 Other Awards $57,634 91.47 $5,271,973
11 Purchased Water $433,064 15.21 $6,588,083
12 Purchased Power and Other Utilities $3,186,702 12.88 $41,039,936
13 Chemicals $740,718 28.83 $21,355,121
14 Materials and Supplies $276,106 29.99 $8,279,288
15 Corporate Shared Services $4,805,258 0.00 $0
16 Outside Services $1,112,675 37.43 $41,652,319
17 Print& Postage $340,635 32.04 $10,913,641
18 Rentals $12,486 34.81 $434,564
19 Transportation $987,710 59.38 $58,650,826
20 Transportation Insurance -$128,037 0.00 $0
21 Transportation Labor $54,873 14.00 $768,219
22 Liability Insurance $254,076 0.00 $0
23 Workers' Compensation $117,827 25.00 $2,945,677
24 Advertising $136,008 24.95 $3,393,235
25 Bad Debt $332,472 2.17 $721,958
26 Sludge Disposal $17,069 70.32 $1,200,363
27 Office Expenses $769,532 30.53 $23,491,092
28 Miscellaneous Expenses $247,922 40.22 $9,970,397
29 Uniform and Safety Equipment $212,503 51.99 $11,048,770
30 Bank Charges $3,658 12.90 $47,178
31 Severance Plan $5,000 0.00 $0
32 Other G&A Expenses $60,060 1.67 $100,101
33 Total Operation & Maintenance Exp Excluding 904 $23,230,691 14.84 $344,840,028
34
35 Other Taxes
36 Other Miscellaneous Taxes $0 0.00 $0
37 Employer Payroll Taxes $1,000,920 14 $14,012,874
38 Property Taxes Water $1,729,252 2.95 $5,105,989
39 Total Other Taxes $2,730,171 7.00 $19,118,863
40
41 Depreciation &Amortization $11,556,211 0.00 $0
42
43 Regulatory Fees $119,654 11.66 $1,395,478
44
45 Income Taxes
46 Federal Income Taxes $2,274,766 25 $56,869,161
47 ID State Income Taxes 508,761 25.00 $12,719,021
48
49 Total Requirements for Working Capital Expenses $40,420,255 10.76 $434,942,550
50
51 Pro Forma Daily Operating Expenses $110,740
52
53 Cash Working Capital Revenue Requirement $110,740 41.37 $4,581,200
Note: Lead-Lag Study was performed by MCR Performance Solutions, LLC.
Please refer to Exhibit 14 and the Direct testimony of Ian MacDougall for more detail
Case No.VEO-W-24-01
Exhibit No. 11
Schedule 12
K.Arp
Page 1 of 1
Veolia Water Idaho
Case VEO-W-24-01
Regulatory Liability-New Federal Tax Law as of December 31, 2024
Actual Actual Actual Actual Actual Actual Actual Actual Actual Forecasted Forecasted Forecasted Forecasted
Balance at Balance at Balance at Balance at Balance at Balance at Balance at Jun Balance at Balance at Balance at Balance at Balance at Balance at Dec
Line No. Account& Description Dec 31, 2023 Jan 31, 2024 Feb 29, 2024 Mar 31, 2024 Apr 30, 2024 May 31, 2024 30, 2024 Jul 31, 2024 Aug 31, 2024 Sept 30, 2024 Oct 31, 2024 Nov 30, 2024 31, 2024
1 Regulatory Liability-New Federal Tax Law (TCJA) (3,923,678) (3,907,011) (3,890,344) (3,873,677) (3,857,010) (3,840,343) (3,823,676) (3,807,009) (3,790,342) (3,773,675) (3,757,008) (3,740,341) (3,723,674)
2 Total ($3,923,678) ($3,907,011) ($3,890,344) ($3,873,677) ($3,857,010) ($3,840,343) ($3,823,676) ($3,807,009) ($3,790,342) ($3,773,675) ($3,757,008) ($3,740,341) ($3,723,674)
3 Deferred Federal Income Taxes $ (777,047) $ (773,746) $ (770,446) $ (767,145) $ (763,844) $ (760,544) $ (757,243) $ (753,942) $ (750,641) $ (747,341) $ (744,040) $ (740,739) $ (737,438)
Case No.VEO-W-24-01
Monthly amount $ (16,667) Exhibit No. 11
Schedule 13
K.Arp
Page 1 of 1