Loading...
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