Loading...
HomeMy WebLinkAbout20250113VEO to Staff 95 Attachment.pdf VEOLIA WATER IDAHO,INC. SUMMARY OF TEST YEAR REVENUES UNDER PRESENT AND PROPOSED RATES FOR THE TEST YEAR ENDED DECEMBER 31,2024 Adjustment R1 Adjustment R2 Adjustment R1 Adjustment R2 Bill Analysis - -Customer -Customer Total Test Year Test Year Revenues, Annualization Growth from Adjustment R3 Total Test Year Annualization Growth from Adjustment R3 Revenue Revenues, Proposed of Historic Test 9/1/2024- -Usage Revenue Proposed of Historic Test 9/1/2024- -Usage Proposed Proposed Phase II% Present Rates Rates Phase I Year Growth- 12/31/2024- Adjustments- Proposed Increase Phase Phase I% Year Growth- 12/31/2024- Adjustments- Rates-Phase Increase Phase Increase Customer Classification (Schedule 2) (Schedule 3) Phase I Phase I Phase I Rates-Phase I I Increase Phase II Phase II Phase II II II (overall) (7)=(3)+(4)+ (13)=(7)+ (1) (2) (3) (4) (5) (6) (5)+(6) (8)=(7)-(2) (9)_(8)/(2) (10) (11) (12) (14) (14) (15) METERED SALES Residential 38,185,094 45,820,947 157,986 46,660 (2,482,465) 43,543,127 5,358,033 14.0% 8,304 2,453 (130,482) 45,831,820 2,288,693 20.0% Commercial 16,524,829 20,129,905 178,056 63,527 (1,527,926) 18,843,562 2,318,732 14.0% 9,359 3,339 (80,310) 19,834,008 990,446 20.0% Public Authority 152,391 173,974 (201) - 173,774 21,383 14.0% (11) - 182,907 9,134 20.0% Total Metered Sales 54,862,314 66,124,826 335,841 110,187 (4,010,392) 62,560,462 7,698,148 14.0% 17,652 5,792 (210,792) 65,848,736 3,288,273 20.0% UNMETERED SALES Private Fire Protection 1,520,026 1,471,993 19,318 3,240 1,494,551 (25,475) -1.7% - - 1,494,551 - -1.7% Public Fire Protection - - - - - - - Total Unmetered Sales 1,520,026 1,471,993 19,318 3,240 1,494,551 (25,475) -1.7% - - 1,494,551 -1.7% Total Sales of Water 56,382,340 67,596,819 355,159 113,427 (4,010,392) 64,055,013 7,672,673 13.6% 17,652 5,792 (210,792) 67,343,287 3,288,273 19.4% Other Operating Revenue 50,945 50,945 - - 50,945 - 50,945 - 0.0% Total 56,433,285 67,647,764 355,159 113,427 (4,010,392) 64,105,958 7,672,673 13.6% 17,652 5,792 (210,792) 67,394,232 3,288,273 19.4% Case No.VEO-W-24-01 Exhibit No.5 Schedule No.1 T.Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 1 of 24 VEOLIA WATER IDAHO,INC. SUMMARY OF HISTORIC TEST YEAR REVENUES UNDER PRESENT RATES AND TEST YEAR REVENUES UNDER PRESENT RATES FOR THE TEST YEAR ENDED DECEMBER 31,2024 Per Books Bill Analysis Adjustment 2 Normalization Revenues Removal of Adjusted Revenues Adjustment 1 Customer of Existing Historic Test Unbilled, Historic Test Historic Test Annualization Growth from Adjustment R3 Eagle Total Test Year Year Rates Surcharges& Year Book Year Rates of Historic Test 9/1/24- weather usage Customer Revenue Customer Classification 8/31/2024 Misc Revenue (Schedule 3) Year Growth 12/31/24 adjustment Rates Present Rates (10)=(5)+(6) (1) (2) (3) (4)=(2)+(3) (5) (6) (7) (8) (9) +(7)+(8)+(9) METERED SALES Residential 40,001,372 (479) 40,000,893 40,000,893 138,545 40,918 (2,176,992) 181,729 38,185,094 Commercial 17,551,023 153 17,551,176 17,551,176 156,146 55,710 (1,339,911) 101,709 16,524,829 Public Authority 147,502 3,855 151,357 151,356 (175) - 1,210 152,391 Total Metered Sales 57,699,898 3,529 57,703,427 57,703,425 294,516 96,628 (3,516,903) 284,648 54,862,314 UNMETERED SALES Private Fire Protection 1,492,979 - 1,492,979 1,492,979 19,318 3,240 4,489 1,520,026 Public Fire Protection 3,855 (3,855) - - - - - - Total Unmetered Sales 1,496,834 (3,855) 1,492,979 1,492,979 19,318 3,240 4,489 1,520,026 Total Sales of Water 59,196,732 (326) 59,196,406 59,196,405 313,834 99,868 (3,516,903) 289,137 56,382,340 Other,Surcharge,Unbilled 120,537 (69,592) 50,945 50,945 - - - 50,945 Total 59,317,269 (69,918) 59,247,351 59,247,350 313,834 99,868 (3,516,903) 289,137 56,433,285 Case No.VEO-W-24-01 Exhibit No.5 Schedule No.2 T. Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 2 of 24 VEOLIA WATER IDAHO,INC. APPLICATION OF PRESENT RATES AND PROPOSED RATES TO CONSUMPTION ANALYSIS-V W ID SYSTEM HISTORIC TEST YEAR ENDED AUGUST 30,2024 AND TEST YEAR ENDED DECEMBER 31,2024 Increase 6.0% Increase PHASE PHASE II Historic TY Historic Historic Historic TY Historic TY 14.0% Proposed Meter/ Revenue Revenue Meter/ Revenue Revenue Rate Block #Bills Test Year Test Year Total Present Revenue Proposed Revenue Consump Proposed From Proposed Consump Proposed From Proposed CCF Volumes Revenues #Bills Consumption Rate Pres Rate Rate Phasel Adjustment Rate Adjustments Rates Adjustment Rate Adjustments Rates (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16) (17) Residential-Bi-Monthly Residential-Bi-Monthly Residential-Bi-Monthly Customer Charge 5/8 122,729 3016,690 122,729 24.58 3,016,690 28.03 3,439,989 460 28.03 12,891 3,452,880 460 29.50 13,569 3,634,368 3/4 357,938 8:798,110 357,938 24.58 8,798,110 28.03 10,032,652 1,341 28.03 37,597 10,070,250 1,341 29.50 39,573 10,599,557 1 56,496 1,775,095 56,496 31.42 1,775,095 35.83 2,024,174 212 35.83 7,586 2,031,760 212 37.71 7,984 2,138,552 11/2 1,526 82,019 1,526 53.75 82,019 61.29 93,528 - 61.29 - 93,528 - 64.51 - 98,444 2 723 60,292 723 83.42 60,292 95.13 68,752 95.13 68,752 100.13 72,365 Subtotal 539,412 13,732,206 539,412 13,732,206 15,659,095 2,013 58,074 15,717,169 2,013 61,126 16,543,287 Winter Usage 3,429,086 5,858,936 3,429,086 1.7086 5,858,936 1.9483 6,681,056 (277,026) 1.9483 (539,743) 6,141,313 (277,026) 2.0508 (568,113) 6,464,110 Summer Usage Up to 3 CCF 1,468,552 2,509,222 11418,552 1.7086 2,509,222 1.9483 2,861,252 (118,640) 1.9483 (231,152) 2,630,100 (118,640) 2.0508 (243,302) 2,768,342 Over 3 CCF 7,673,285 16,597,315 7,673,285 2.1630 16,597,315 2.4665 18,926,233 (619,902) 2.4665 (1,528,995) 17,397,239 (619,902) 2.5962 (1,609,361) 18,311,664 Subtotal 12,570,923 24,965,472 12,570,923 24,965,472 28,468,542 (1,015,568) (2,299,890) 26,168,652 (1,015,568) (2,420,776) 27,544,116 Total Class 38,697,678 39,697,678 44,127,637 (2,241,816) 41,995,821 (2,359,649) 44,087,403 Commercial-Bi-Monthly Commercial-Bi-Monthly Commercial-Bi-Monthly Customer Charge 5/8 3,232 79,442 3,232 24.58 79,442 28.03 90,589 - 28.03 - 90,589 - 29.50 - 95,351 3/4 12,637 310,621 12,637 24.58 310,629 28.03 354,216 142 28.03 3,992 358,208 142 29.50 4,202 377,036 1 15,356 482,486 15,356 31.42 482,486 35.83 550,188 173 35.83 6,201 556,390 173 37.71 6,527 585,634 11/2 12,304 661,328 12,304 53.75 661,328 61.29 754,124 139 61.29 8,500 762,624 139 64.51 8,947 802,709 2 15,065 1,256,762 15,065 83.42 1,256,762 95.13 1,433,110 170 95.13 16,153 1,449,263 170 100.13 17,002 1,525,438 3 1,546 251,597 1,546 162.70 251,597 185.53 286,901 - 185.53 - 286,901 - 195.28 - 301,981 4 251 76,156 251 303.54 76,156 346.13 86,842 - 346.13 - 86,942 - 364.33 - 91,407 6 35 17,857 35 506.77 17,857 577.88 20,362 - 577.88 - 20,362 - 608.25 - 21,433 8 6 3,978 6 662.97 3,978 756.00 4,536 - 756.00 - 4,536 - 795.73 - 4,774 10 - - - 944.78 - 1,077.35 - - 1,077.35 - - - 1,133.98 - - 12 - 1,359.52 1,359.52 - 1,430.98 Subtotal 60,433 3,140,235 60,433 3,140,235 3,580,869 624 34,846 3,615,715 36,678 3,805,763 Temporary Meter Charge 734 19,638 734 26.77 19,638 30.53 22,394 - 30.53 - 22,394 32.13 23,571 Winter Usage 2,113,879 3,611,774 2,113,879 1.7086 3,611,774 1.9483 4,118,574 (176,064) 1.9483 (343,033) 3,775,541 2.0508 (361,064) 3,973,989 Summer Usage Up to 3 CCF 700,578 1,197,021 700,578 1.7086 1,197,021 1.9483 1,364,971 (58,351) 1.9483 (113,688) 1,251,283 2.0508 (119,663) 1,317,052 Over3 CCF 4,126,834 8,926,342 4,126,834 2.1630 8,926,342 2.4665 10,178,878 (343,721) 2.4665 (847,792) 9,331,085 2.5962 (892,353) 9,821,541 Subtotal 6,941,291 13,735,137 6,941,291 13,735,137 15,662,422 (578,136) (1,304,513) 14,357,909 (1,373,080) 15,112,583 Total Clan 16,895,009 16,895,0D9 19,265,685 (1,269,667) 17,996,018 (1,336,402) 18,941,916 Public Authority-Bi-Monthly Pub Auth-Bi-Monthly Public Authority-Bi-Monthly Customer Charge 5/8 22 541 22 24.58 541 28.03 617 - 28.03 - 617 - 29.50 - 650 3/4 48 1,170 48 24.58 1,170 28.03 1,335 - 28.03 - 1,335 - 29.50 - 1,405 1 182 5,714 182 31.42 5,714 35.83 6,515 (1) 35.83 (37) 6,479 (1) 37.71 (39) 6,819 1 1/2 119 6,405 119 53.75 6,405 61.29 7,304 (1) 61.29 (41) 7,263 (1) 64.51 (43) 7,644 2 229 19,128 229 83.42 19,128 95.13 21,812 (1) 95.13 (123) 21,689 (1) 100.13 (130) 22,829 3 6 976 6 162.70 976 185.53 1,113 - 185.53 - 1,113 - 195.28 - 1,172 Street Sweeping 1 3,855 1 3,940.24 3,940 4,493.13 4,493 4,493.13 4,493 - 4,729.30 4,729 Subtotal 607 37,790 607 37,875 43,190 (3) (202) 42,988 (212) 45,248 Winter Usage 9,533 16,289 9,533 1.7086 16,289 1.9483 18,574 (43) 1.9483 (83) 18,491 (43) 2.0508 (87) 19,463 Summer Usage Up to 3 CCF 4,337 7,410 4,337 1.7086 7,410 1.9483 8,450 (19) 1.9483 (38) 8,413 (19) 2.0508 (40) 8,855 Over 3 CCF 38,932 84,209 38,932 2.1630 84,209 2.4665 96,025 (174) 2.4665 (428) 95,597 (174) 2.5962 (451) 100,622 Subtotal 52,802 107,908 52,802 107,908 123,050 (235) (549) 122,501 (235) (577) 128,940 Total Class 145,698 145,793 166,239 (750) 165,499 (790) 174,187 Private Fire Lines-Bi-Monthly Priv Fire Lines-Bi-Monthly Private Fire Lines-Bi-Monthly Fire Line Size 3"and smaller 5,340 231,431 5,340 43.34 231,431 43.34 231,431 83 43.34 3,108 235,039 83 43.34 3,608 235,039 4" 3,988 261,978 3,988 65.69 261,978 65.69 261,978 62 65.69 4,084 266,063 62 65.69 4,084 266,063 6" 3,527 575,462 3,527 163.15 575,462 163.15 175,462 55 163.15 8,972 584,434 55 163.15 8,972 584,434 8" 1,192 319,458 1,192 268.11 319,458 268.11 319,458 19 268.11 4,981 324,438 19 268.11 4,981 324,438 30" 72 30,104 72 418.11 30,104 418.11 30,104 - 418.11 - 30,104 - 418.11 - 30,104 12" 36 22,546 36 626.28 22,546 626.28 22,546 - 626.28 - 22,546 - 626.28 - 22,546 Hydrants 969 25,475 969 26.29 25,475 - - Total Private Fire 15,124 1,466,454 15,124 1,466,454 1,440,979 219 21,645 1,462,624 219 21,645 2,462,624 Total 57,204,839 19,565,016 57,204,924 65,000,540 (1,593,939) (3,490,588) 61,509,952 (3,675,196) 64,666,131 VEO-W-24-01 case No.VEo-W-24-01 Exhibit N1.5 IPUC DR 95 Attachment Schedule No.3-VWIDSyrtem Page 1 of 1 Page 3 of 24 rdichaelsoo VEOLIA WATERIDAHO,INC. APPLICATION OF PRESENT RATES AND PROPOSED RATES TO CONSUMPTION ANALYSIS-EAGLE EXIST HISTORIC TEST YEAR ENDED AUGUST 31,2024 AND TEST YEAR ENDED DECEMBER 31,2024 Increase 6.0% Increase PHASE I PHASE II SEPT 2023-DEC 2023 JANUARY 20M&THEREAFTER Historic TY Historic Historic Historic TY Historic 114,0M Meter/ Revenue Revenue Meter/ Revenue Revenue Rate Block Number Total Present PhaseI Number Total Present Phase ll p Bills Test Year T-Year Total Present Revenue Proposed Proposed Consume Proposed From Proposed Consume Proposed From Proposed CCF Of Bills Consumption pate Revenue Of Bills Consumption Rate Revenue Volumes Revenues k Bills Consumption Rate Pres Rate Rate Revenue Adjustment Rate Adjustments pates Adjustment Rate Adjustments Rates (1) (2) (3) (4) (5) (6) (]) (8) (9) ' (10) fill I121 (13) (141 (15) (16) IV) (181 (191 (201 1211 R2) (23) 124) 125) Residential-Monthly Residential-Monthly Residential-Monthly Residential-Monthly Customer Charge 5/8 5,382 ].1] 38,588 10,3" 8.19 84,]41 11,129 113,334 15,729 9.22 145,025 10.51 165,375 - 10.51 - 165,371 - 11.07 - 174,167 314 6,510 ].1] 46,673 12,499 8.19 102,368 19,D09 149,042 19,009 9.22 175,260 10.51 199,853 - 10.51 - 199,853 - 11.07 - 210,357 1 193 9.16 1,764 368 10.47 3,841 560 5,612 560 11.]8 6,598 13.43 7,524 - 13.43 - ],524 - 14.14 - ],919 11/2 12 15.6] 188 24 1].92 422 36 610 36 20.16 ]1] 22.99 818 - 22.99 - 818 - 24.20 - 861 2 4 24.33 91 8 27.81 220 12 317 12 31.28 3]2 35.6] 425 35.67 425 - 37.54 441 Subtotal 12,100 87,310 23,246 191.606 35,346 278,916 35,346 327,973 313,994 - - 313,994 - 393,652 Winter Usage 76,989 0.9966 76,727 50,811 1.1391 57,879 127,801 134,607 127,801 1.2815 163,1]] 1.4613 186,757 (11,9371 1.4613 (1],4431 169,314 (11,9371 1.5381 (18,3601 178,213 Summer Usage Up W 1.5 CCF 4,481 0.9966 4,472 40,433 1.1391 46,057 44,920 50,529 44,920 1.2815 57,565 1.4613 15.12 15.1121 1.4513 1],4]DI 58,172 15,1121 1.5381 I7,8631 61,229 Over 1.5 CCF 144,566 1.2618 182,414 245,975 1.4420 354,696 390,542 537,110 390,542 1.6223 633.576 1.8499 722,479 (26,7111 1.8499 (49,4141 673,065 (26,7111 1.9472 (52,0111 7p8.442 Subtotal 0 226,043 263,613 337.219 458,633 563,262 722,246 563,262 854,917 914,878 (43,7601 (74,3281 900,550 (78,2341 947,885 Total Class 350.923 650,238 1,IXYiJ62 1.182.890 1.30,872 174.328) 1.274.544 (78.234) 1.341.536 Commercial-Monthly Commercial-Monthly Commercial-Monthly Commercial-Monthly Customer Charge 5/8 38 0 ].1] 2]S 65 8.19 533 103 8. 103 9.22 948 30.51 1,p81 - 10.51 - 1,p81 - 11.07 - 1,138 314 324 0 ].1] 2,322 648 8.19 5,30] 9]2 ],629 9]2 9.22 8,961 10.51 10,218 - 50.51 - 10,218 - 11.07 - 10,755 1 268 0 9.16 2,451 525 10.47 5,497 1 7,113 793 11.]8 9,343 13.43 10,654 - 13.43 - 10,654 - 14.14 - 11,214 1 1/2 514 0 15.6] 8,055 1,023 1].92 38,3. 1,138 21395 1,538 20.16 30,996 22.99 35,345 - 22.99 - 35,341 - 24.20 - 3],203 2 515 0 24.33 12,539 982 2].81 2],3. 1,49] 39,848 1,497 31.28 46,83] 35.6] 53,409 - 35.67 - 53,409 - 37.54 - 56,217 3 14 0 4].45 655 31 54.23 11682 45 2,336 45 61.01 2,734 69.5] 3,117 - 69.57 - 3,111 - 13.23 - 3,281 4 44 0 88.53 3.869 90 101.18 9,0]4 133 12,943 133 113.83 15,183 129.80 1],313 - 129.80 - 1],313 - 136.63 - 18,223 6 4 0 14].81 591 ] 168.92 1,166 11 1,]58 11 190.04 2,0]2 216.]1 2,363 - 216.]1 - 2,363 - 228.30 - 2,48] 8 0 0 193.36 0 - 220.99 - - - - 248.61 - 283.49 - - 283.49 - - - 298.40 - - 10 0 0 275.56 0 - 314.93 - - - - 354.29 - 404.00 - - 404.00 - - - 425.24 - - 12 0 0 - 0 - - 5D9.81 536.61 Subtotal 1,721 0 30,]5] 3,3]1 68,909 5,D92 99,666 5,D92 117,074 133,501 0 0 133,501 0 0 140,518 Temporary Meter Charge 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Winter Usage 0 48,994 0.9966 48,821 43,247 1.1391 49,263 92,241 9810% 92,241 1.2815 118,207 1.4613 134,793 (9,8191 1.4613 (14,3491 120.445 (9,8191 1.5381 (15,1031 126,]]5 Summer Usage Up W 1.5 CCF 0 619 0.9966 617 24.21 1.1391 27,571 24,823 28,188 24,8243 1.2815 31,811 1.4613 36,274 13,2541 1.4613 (4,7551 31,519 (3,2541 1.5381 I5,0051 33,176 Over 1.5 CCF 0 85,899 1.2638 108,38] 164,144 IA420 236,696 250,043 345,083 250,043 1.6223 405,644 1.8499 462,564 (19,1691 1.8499 (35,4621 427,102 (19,1691 1.9472 (3],3261 449,551 Subtotal 0 135,512 157,831 231,595 313,529 367,107 471,360 36],10] 555,662 633,632 (32,243) (54,566) 579,065 (32,243) (57,434) 609,502 Total Class 188.588 382,438 S71,026 672,735 ]6].133 (S4,5661 ]12,56] (S1.434) ]50.020 Public Authority-Monthly Public Authority-Monthly Pub Auth-Monthly Publlc Authority-Monthly Customer Charge 5/8 0 ].1] - - 8.19 - - - - 9.22 - 10.51 - - 10.51 - - - 11.0] - - 3/4 0 ].1] 0 - 8.19 0 - - - 9.22 - 10.51 - - 10.51 - - - 11.0] - - 1 0 9.36 0 - IOA] 0 - - - 11.]8 - 13.43 - - 13A3 - - - 14.14 - - 11/2 8 15.6] 119 I6 1].92 283 23 402 23 20.16 4]2 22.99 538 6 22.99 131 676 6 24.20 145 731 2 0 24.33 0 - 2].81 0 - - - 31.28 - 35.67 - - 35.6] - - - 3].54 - - 3 0 4]AS 0 - 54.23 0 - - - 61.01 - 69.57 - - 69.57 - - - 73.23 - - StreetSWeeping 0 - 0 0 - - - - - Subtotal 8 119 16 283 23 402 23 472 538 6 138 676 145 731 Winter Usage 112 0.9966 112 4 1.1391 5 116 11] 116 1.2815 149 1.4613 170 43 IA613 62 232 43 1.5381 65 244 Summer Usage UO to 1.5 CCF 3 0.9966 3 13 1.1311 1 16 I8 16 1.2815 21 1.4613 24 19 IA613 28 52 19 1.5381 30 55 Over 1.5 CCF 1,959 1.2618 2,4]1 1,]41 1.4420 2,510 3,699 4,981 3,6" 1.6223 6,DO1 1.8499 6,844 1]4 1.8499 321 ],165 1]4 1.94]2 338 7,541 Subtotal 2,074 2,586 1,]58 2,530 3,832 5,116 3,832 6,171 7,037 235 411 7,449 433 7,840 Total Class 2.705 2,61; 51518 6.643 tj."2117%767� 549 8.1. 578 8,552 Private Fire Lines-Monthly Private Fire Lines-Monthly Priv Fire Unes-Monthly Private Fire Lines-Monthly Fire❑ne Sire 3"and smaller 214 0 12.64 2,]01 425 0 14.45 6,144 639 818" 639 16.231 10,381 11.25 16.21 - 10,386 - 16.25 - 10,386 4" 168 0 19.16 3,214 330 0 21.90 ],225 498 30,439 498 24.63 12,258 24.63 - 24.63 - 12,258 - 24.63 - 12,258 6" 28 0 4].59 1,333 59 0 54.38 3,226 8] 4,559 8] 61.18 5,343 61.18 - 61.38 - 5,343 - 61.18 - 5,343 8" 8 0 78.20 610 16 0 89.37 1,396 23 2,006 23 100.54 2,354 100.54 - 100.54 - 2,354 - 100.54 - 2,354 30" 0 0 121.95 0 - 0 139.37 0 - - - 156.]9 - 156.]9 - 156.]9 - - - 356.]9 - - 12" 0 0 182.6] 0 - 0 2p8.]6 0 - - - 234.86 - 234.86 - 234.86 - - - 234.86 - - Hvdrants 0 0 - 0 0 - 0 - - - - - TotalPrm-Fire 418 0 7.862 830 0 1T,990 1.20 25,852 1,248 30.341 00 W.341 0 30.341 Total 363.628 550.0T8 5]0,5]2 1,053,479 1,603,558 934,201 1,892.609 6]) 1128,344) 2,025,516 1135.. 2.1.. VEO-W-24-01 " IPUC DR 95 Attachment Page 4 of 24 "`°" VEOLIA WATER IDAHO,INC. APPLICATION OF PRESENT RATES AND PROPOSED RATES TO CONSUMPTION ANALYSIS-EAGLE NEW HISTORIC TEST YEAR ENDED AUGUST 31,2024 AND TEST YEAR ENDED DECEMBER 31,2024 Increase 6.0% Increase PHASE PHASE II Historic TY Historic Historic Historic TY Historic TY 14.0% Proposed Meter/ Revenue Revenue Meter/ Revenue Revenue Rate Block #Bills Test Year Test Year Total Present Revenue Proposed Revenue Consump Proposed From Proposed Consump Proposed From Proposed CCF Volumes Revenues #Bills Consumption Rate Pres Rate Rate Phase Adjustment Rate Adjustments Rates Adjustment Rate Adjustments Rates (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) Residential-Monthly Residential-Monthly Residential-Monthly Customer Charge 5/8 3,650 44,863 3,650 12.29 44,863 14.01 51,158 476 14.01 6,673 57,832 476 14.75 7,024 60,871 3/4 5,194 63,832 5,194 12.29 63,832 14.01 72,788 575 14.01 8,065 80,853 575 14.75 8,489 85,103 1 171 2,685 171 15.71 2,685 17.91 3,061 - 17.91 - 3,061 - 18.86 - 3,222 11/2 - - - 26.88 - 30.65 - - 30.65 - - - 32.26 - - 2 41.71 47.56 47.56 50.06 Subtotal 9,015 111,379 9,015 111,379 127,008 1,052 14,738 141,746 1,052 15,513 149,196 Winter Usage 24,756 42,298 24,756 1.7086 42,298 1.9483 48,234 2,841 1.9483 5,535 53,769 2,941 2.0508 5,826 56,595 Summer Usage Up to 1.5 CCF 9,494 16,204 9,484 1.7086 16,204 1.9483 18,477 1,217 1.9483 2,371 20,948 1,217 2.0508 2,495 21,944 Over 1.5 CCF 61,106 132,173 61,106 2.1630 132,173 2.4665 150,719 6,357 2.4665 15,680 166,399 6,357 2.5962 16,505 175,146 Subtotal 95,346 190,675 95,346 190,675 217,430 10,415 23,586 241,016 10,415 24,826 253,685 Total Class 302,054 302,054 344,438 39,324 392,762 40,339 402,881 Commercial-Monthly Commercial-Monthly Commercial-Monthly Customer Charge 5/8 52 635 52 12.29 635 14.01 724 - 14.01 - 724 - 14.75 - 762 3/4 185 2,276 185 12.29 2,276 14.01 2,595 54 14.01 753 3,348 54 14.75 792 3,524 1 114 1,796 114 15.71 1,796 17.91 2,047 44 17.91 785 2,833 44 18.86 827 2,982 11/2 300 8,074 300 26.88 8,074 30.65 9,206 85 30.65 2,604 11,811 85 32.26 2,741 12,432 2 278 11,590 278 41.71 11,590 47.56 13,216 83 47.56 3,937 17,153 83 50.06 4,144 18,054 3 - - - 81.35 - 92.76 - - 92.76 - - - 97.64 - - 4 - - - 151.77 - 173.07 - - 173.07 - - - 182.16 - - 6 - - - 253.39 - 288.94 - - 288.94 - - - 304.13 - - 8 - - - 331.49 - 378.00 - - 378.00 - - - 397.87 - - 10 - - - 472.39 - 538.68 - - 538.68 - - - 566.99 - - 12 - 679.76 679.76 715.49 Subtotal 929 24,369 929 24,369 27,789 265 8,079 35,868 265 8,504 37,753 Temporary Meter Charge 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Winter Usage 6,095 10,415 6,095 1.7086 10,415 1.9483 11,876 4,023 1.9483 7,839 19,715 4,023 2.0508 8,251 20,751 Summer Usage Up to 1.5 CCF 3,016 5,152 3,016 1.7086 5,152 1.9483 5,875 1,333 1.9483 2,598 8,473 1,333 2.0508 2,734 8,919 Over 1.5 CCF 20,899 45,205 20,899 2.1630 45,205 2.4665 51,548 7,855 2.4665 19,373 70,921 7,855 2.5962 20,392 74,649 Subtotal 30,010 60,772 30,010 60,772 69,299 13,211 29,810 99,109 13,211 31,377 104,318 Total Class 85,141 85,141 97,088 37,889 134,977 39,881 142,072 Public Authority-Monthly Pub Auth-Monthly Public Authority-Monthly Customer Charge 5/8 - - - 12.29 - 14.01 - - 14.01 - - - 14.75 - - 3/4 11 138 11 12.29 138 14.01 158 - 14.01 - 158 - 14.75 - 166 1 - - - 15.71 - 17.91 - - 17.91 - - - 18.86 - - 11/2 - - - 26.88 - 30.65 - - 30.65 - - - 32.26 - - 2 - - - 41.71 - 47.56 - - 47.56 - - - 50.06 - - 3 - - - 81.35 - 92.76 - - 92.76 - - - 97.64 - - StreetSWeeping - - - - Subtotal 11 138 11 138 158 0 0 158 - 0 166 Winter Usage 1 2 1 1.7086 2 1.9483 2 - 1.9483 - 2 - 2.0508 - 2 Summer Usage Up to 1.5 CCF 0 0 - 1.7086 - 1.9483 - - 1.9483 - - - 2.0508 - - Over 1.5 CCF 0 0 2.1630 2.4665 2.4665 2.5962 Subtotal 1 2 1 2 2 - - 2 - - 2 Total Class 140 140 160 - 160 - 168 Private Fire Lines-Monthh Priv Fire Lines-Monthly Private Fire Lines-Monthly Fire Line Size 3"and smaller 24 520 24 21.67 520 21.67 520 19 21.67 419 939 19 21.67 419 939 4" 5 153 5 32.85 153 32.85 153 15 32.85 494 647 15 32.85 494 647 6" - - - 81.58 - 81.58 - - 81.58 - - - 81.58 - - 8.. - - - 134.06 - 134.06 - - 134.06 - - - 134.06 - - 1D. - - - 209.06 - 209.06 - - 209.06 - - - 209.06 - - 12" - - - 313.14 - 313.14 - - 313.14 - - - 313.14 - - Hydrants - - - - Total Private Fire 29 673 29 673 673 34 913 1,586 34 913 1,586 Total 388,008 125,357 388,008 442,359 23,626 77,126 519,485 81,132 546,707 Case No.VEO-W-24-01 Exhibit No.S VEO-W-24-01 Schedule No.3-Eagle New IPUC DR 95 Attachment T.rdich,dl Page 5 of 24 Page lufl VEOLIA WATER IDAHO, INC. SUMMARY OF BILLING DETERMINANTS FOR REVENUE ADJUSTMENTS-VWID SYSTEM ADJUSTMENT R1: ANNUALIZATION OF HISTORIC TEST YEAR GROWTH Historic TY Average Usage Annualization Number of Customers 1/2 of Number of Bi- per Bill Adjustment 8/31/2023 8/31/2024 Gain/Loss Growth Monthly Bills CCF CCF Residential 89,695 90,244 549 275 1,647 22.93 37,765 Commercial 10,089 10,249 160 80 480 116.36 55,851 Public Authority 136 135 -1 -1 (3) 78.47 (235) Private Fire 2,397 2,460 63 32 189 0.00 - ADJUSTMENT R2: WEIGHTED CUSTOMER GROWTH THROUGH 12/31/2024 Test Year Average Usage Growth Number of Customers Number of Bi- per Bill Adjustment 8/31/2024 12/31/2024 Gain/Loss Monthly Bills CCF CCF Residential 90,244 90,305 61 366 22.93 8,392 Commercial 10,249 10,273 24 144 116.36 16,755 Public Authority 135 135 0 - 78.47 - Private Fire 2,460 2,465 5 30 0 - ADJUSTMENT R3: WEATHER USAGE ADJUSTMENT Test Year Test Year No. Adjustment per Weather Customers Customer Adjustment 12/31/2024 CCF CCF Residential 90,305 -11.76 (1,061,725) Commercial 10,273 -63.34 (650,742) TOTAL OF PRO-FORMA ADJUSTMENTS(R1+R2+R3) Pro-Forma Total Pro- No. Forma Customers Adjustment 12/31/2024 CCF Residential 90,305 (1,015,568) Commercial 10,273 (578,136) Public Authority 135 (235) Fire 2,465 - (1,593,939) Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4-VWID System T. Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 6 of 24 VEOLIA WATER IDAHO,INC. SUMMARY OF BILLING DETERMINANTS FOR REVENUE ADJUSTMENTS-EAGLE ADJUSTMENT R1: ANNUALIZATION OF HISTORIC TEST YEAR GROWTH Growth Historic TY (use Average Usage Annualization Number of Customers Gain/Loss Number of per Bill Adjustment 8/31/2023 8/31/2024 Gain/Loss Amount) Monthly Bills CCF CCF Residential-New 3,722 3,826 104 52 624 11.46 7,154 Commercial-New 509 535 26 13 156 58.18 9,076 Public Authority-Existing 2 3 1 1 6 39.24 235 Private Fire-New 105 109 4 2 24 0.00 - ADJUSTMENT R2: WEIGHTED CUSTOMER GROWTH THROUGH 12/31/2024 Test Year Average Usage Growth Number of Customers Number of per Bill Adjustment 8/31/2024 12/31/2024 Gain/Loss Monthly Bills CCF CCF Residential-New 3,826 3,862 36 428 11.46 4,903 Commercial-New 535 544 9 109 58.18 6,360 Public Authority-Existing 3 3 0 - 39.24 - Private Fire-New 109 110 1 10 0 - ADJUSTMENT R3: WEATHER USAGE ADJUSTMENT Test Year Test Year No. Adjustment per Weather Customers Customer Adjustment 8/31/2024 CCF CCF Residential-Existing 3,722 -11.76 (43,760) Residential-New 140 -11.76 (1,642) Commercial-Existing 509 -63.34 (32,243) Commercial-New 35 -63.34 (2,224) TOTAL OF TEST YEAR ADJUSTMENTS(R1+R2+1113) Test Year No. Total Test Year Customers Adjustment 12/31/2024 CCF Residential 3,862 (33,345) Commercial 544 (19,031) Public Authority 3 235 Private Fire 110 (52,141) Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4-Eagle T.Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 7 of 24 VEOLIA WATER IDAHO,INC. R-1 APPLICATION OF PRESENT AND PROPOSED RATES TO NUMBER OF CUSTOMERS ADDED IN HISTORIC TEST YEAR-VWID SYSTEM Rate Block Number Total Present Proposed Proposed Proposed Proposed Phasell CCF Of Bills Consumption Rate Revenue Rate-Phase I Revenue-Phase I Rate-Phase II Revenue-Phase II Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Bi-Monthly Customer Charge 5/8 376 $ 24.58 $ 9,249 28.03 10,547 29.50 11,102 554 3/4 1,097 24.58 26,976 28.03 30,761 29.50 32,378 1,617 1 173 31.42 5,443 35.83 6,206 37.71 6,533 326 Subtotal 1,647 41,668 47,515 50,012 2,497 Winter Usage 0 10,302 1.7086 17,601 1.9483 20,071 2.0508 21,126 1,055 Summer Usage Up to 3 CCF 0 4,412 1.7086 7,538 1.9483 8,596 2.0508 9,048 452 Over 3 CCF 0 23,052 2.1630 49,861 2.4665 56,858 2.5962 59,846 2,989 Subtotal 0 37,765 75,000 85,524 90,020 4,495 Total Class 1,647 37,765 $ 116,669 $ 133,039 $ 140,032 $ 6,993 Commercial-Bi-Monthly Customer Charge 3/4 110 $ 24.58 $ 2,693 28.03 3,071 29.50 3,233 161 1 133 31.42 4,183 35.83 4,770 37.71 5,021 251 1 1/2 107 53.75 5,734 61.29 6,538 64.51 6,882 344 2 131 83.42 10,896 95.13 12,425 100.13 13,078 653 Subtotal 480 23,506 26,805 28,214 1,409 Winter Usage 0 17,009 1.7086 29,061 1.9483 33,139 2.0508 34,880 1,742 Summer Usage Up to 3 CCF 0 5,637 1.7086 9,631 1.9483 10,983 2.0508 11,560 577 Over CCF 0 33,205 2.1630 71,823 2.4665 81,901 2.5962 86,206 4,305 Subtotal 0 55,851 110,515 126,022 132,646 6,624 Total Class 480 55,851 $ 134,021 $ 152,827 $ 160,860 $ 8,033 Other Public Authority-Bi-Monthly Customer Charge 1 (1) $ 31.42 $ (32) 35.83 (37) 37.71 (39) (2) 11/2 (1) 53.75 (36) 61.29 (41) 64.51 (43) (2) 2 (1) 83.42 (108) 95.13 (123) 100.13 (130) (6) Subtotal (3) (176) (202) (212) (11) Winter Usage 0 (43) 1.7086 (73) 1.9483 (83) 2.0508 (87) (4) Summer Usage Up to 3 CCF 0 (19) 1.7086 (33) 1.9483 (38) 2.0508 (40) (2) Over CCF 0 (174) 2.1630 (375) 2.4665 (428) 2.5962 (451) (23) Subtotal 0 (235) (481) (549) (577) (29) Total Class (3) (235) $ (657) $ (750) $ (790) $ (39) Private Fire Lines-Bi-Monthly Fire Line Size 3"and smaller 72 0 $ 43.34 $ 3,114 43.34 3,114 43.34 3,114 - 4" 54 0 65.69 3,525 65.69 3,525 65.69 3,525 - 6" 47 0 163.15 7,743 163.15 7,743 163.15 7,743 - 8" 16 0 268.11 4,298 268.11 4,298 268.11 4,298 - Total Class 189 0 $ 18,680 $ 18,680 $ 18,680 $ - Total Adjustment 2,313 93,381 268,713 303,796 318,782 14,986 Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4A-VWID System VEO-W-24-01 T.Michaelson IPUC DR 95 Attachment Page 1 of 1 Page 8 of 24 VEOLIA WATER IDAHO,INC. R-1 APPLICATION OF PRESENT AND PROPOSED RATES TO NUMBER OF CUSTOMERS ADDED IN HISTORIC TEST YEAR-EAGLE EXIST Rate Block Number Total Present Proposed Proposed Proposed Proposed Phasell CCF Of Bills Consumption Rate Revenue Rate-Phase I Revenue-Phase I Rate-Phase II Revenue-Phase II Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Monthly Customer Charge 5/8 0 9.22 0 10.51 0 11.07 0 0 3/4 0 9.22 0 10.51 0 11.07 0 0 Subtotal 0 0 0 0 0 Winter Usage 0 0 1.2815 0 1.4613 0 1.5381 0 0 Summer Usage Up to 1.5 CCF 0 0 1.2815 0 1.4613 0 1.5381 0 0 Over 1.5 CCF 0 0 1.6223 0 1.8499 0 1.9472 0 0 Subtotal 0 0 0 0 0 0 Total Class 0 0 0 0 0 0 Commercial-Monthly Customer Charge 3/4 0 9.22 0 10.51 0 11.07 0 0 1 0 11.78 0 13.43 0 14.14 0 0 1 1/2 0 20.16 0 22.99 0 24.20 0 0 2 0 31.28 0 35.67 0 37.54 0 0 Subtotal 0 0 0 0 0 Winter Usage 0 0 1.2815 0 1.4613 0 1.5381 0 0 Summer Usage Up to 1.5 CCF 0 0 1.2815 0 1.4613 0 1.5381 0 0 Over 1.5 CCF 0 0 1.6223 0 1.8499 0 1.9472 0 0 Subtotal 0 0 0 0 0 0 Total Class 0 0 0 0 0 0 Other Public Authority-Monthly Customer Charge 5/8 0 9.22 - 10.51 0 11.07 0 0 3/4 0 9.22 - 10.51 0 11.07 0 0 1 1/2 6 20.16 121 22.99 138 24.20 145 7 2 0 31.28 - 35.67 0 37.54 0 0 Subtotal 6 121 138 145 7 Winter Usage 0 43 1.2815 54 1.4613 62 1.5381 65 3 Summer Usage Up to 1.5 CCF 0 19 1.2815 25 1.4613 28 1.5381 30 1 Over 1.5 CCF 0 174 1.6223 282 1.8499 321 1.9472 338 17 Subtotal 0 235 361 411 433 22 Total Class 6 235 482 549 578 29 Private Fire Lines-Monthly Fire Line Size 3"and smaller 0 0 16.25 0 16.25 0 16.25 0 0 4" 0 0 24.63 0 24.63 0 24.63 0 0 Total Class 0 0 0 0 0 0 Total Adjustment 6 235 482 549 578 29 Case No.VEO-W-24-01 Exhibit No.5 VEO-W-24-01 Schedule No.4A-Eagle Existing T.Michaelson IPUC DR 95 Attachment Page 1 of 1 Page 9 of 24 VEOLIA WATER IDAHO,INC. R-1 APPLICATION OF PRESENT AND PROPOSED RATES TO NUMBER OF CUSTOMERS ADDED IN HISTORIC TEST YEAR-EAGLE NEW Rate Block Number Total Present Proposed Proposed Proposed Proposed Phasell CCF Of Bills Consumption Rate Revenue Rate-Phase I Revenue-Phase I Rate-Phase II Revenue-Phase II Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Monthly Customer Charge 5/8 283 12.29 3,473 14.01 3,960 14.75 4,168 208 3/4 341 12.29 4,196 14.01 4,785 14.75 5,037 252 Subtotal 624 7,669 8,745 9,205 460 Winter Usage 0 1,951 1.7086 3,334 1.9483 3,802 2.0508 4,002 200 Summer Usage Up to 1.5 CCF 0 836 1.7086 1,428 1.9483 1,628 2.0508 1,714 86 Over 1.5 CCF 0 4,367 2.1630 9,445 2.4665 10,771 2.5962 11,337 566 Subtotal 0 7,154 14,208 16,201 17,053 852 Total Class 624 7,154 21,877 24,946 26,258 1,311 Commercial-Monthly Customer Charge 3/4 32 12.29 388 14.01 443 14.75 466 23 1 26 15.71 405 17.91 462 18.86 486 24 11/2 50 26.88 1,343 30.65 1,531 32.26 1,612 80 2 49 41.71 2,030 47.56 2,315 50.06 2,436 122 Subtotal 156 4,166 4,751 5,000 250 Winter Usage 0 2,764 1.7086 4,722 1.9483 5,385 2.05 5,668 283 Summer Usage Up to 1.5 CCF 0 916 1.7086 1,565 1.9483 1,785 2.05 1,879 94 Over 1.5 CCF 0 5,396 2.1630 11,671 2.4665 13,309 2.60 14,008 700 Subtotal 0 9,076 17,959 20,479 21,555 1,076 Total Class 156 9,076 22,125 25,229 26,555 1,326 Other Public Authority-Monthly Customer Charge 5/8 0 9.22 0 14.01 0 14.75 0 0 3/4 0 9.22 0 14.01 0 14.75 0 0 1 1/2 0 20.16 0 30.65 0 32.26 0 0 2 0 31.28 0 47.56 0 50.06 0 0 Subtotal 0 0 0 0 0 Winter Usage 0 0 1.7086 0 1.9483 0 2.0508 0 0 Summer Usage Up to 1.5 CCF 0 0 1.7086 0 1.9483 0 2.0508 0 0 Over 1.5 CCF 0 0 2.1630 0 2.4665 0 2.5962 0 0 Subtotal 0 0 0 0 0 0 Total Class 0 0 0 0 0 0 Private Fire Lines-Monthly Fire Line Size 3"and smaller 13 0 21.67 292 21.67 292 21.67 292 0 4" 11 0 32.85 345 32.85 345 32.85 345 0 Total Class 24 0 637 637 637 - Total Adjustment 804 16,230 44,639 50,813 53,450 2,637 Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4A-Eagle New VEO-W-24-01 T.Michaelson IPUC DR 95 Attachment Page 1 of 1 Page 10 of 24 VEOLIA WATER IDAHO,INC. R-2 APPLICATION OF PRESENT AND PROPOSED RATES TO NUMBER OF CUSTOMERS ADDED IN TEST YEAR-VWID SYSTEM Rate Block Number Total Present Proposed Proposed Proposed Proposed Phase 11 CCF Of Bills Consumption Rate Revenue Rate-Phase I Revenue-Phase I Rate-Phase II Revenue-Phase II Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Bi-Monthly Customer Charge 5/8 84 $ 24.58 $ 2,055 28.03 2,344 29.50 2,467 123 3/4 244 24.58 5,995 28.03 6,836 29.50 7,195 359 1 38 31.42 1,209 35.83 1,379 37.71 1,452 72 Subtotal 366 9,260 10,559 11,114 555 Winter Usage 0 2,289 1.7086 3,911 1.9483 4,460 2.0508 4,695 234 Summer Usage Up to 3 CCF 0 980 1.7086 1,675 1.9483 1,910 2.0508 2,011 100 Over CCF 0 5,123 2.1630 11,080 2.4665 12,635 2.5962 13,299 664 Subtotal 0 8,392 16,667 19,005 20,004 999 Total Class 366 8,392 25,926 29,564 31,118 1,554 Commercial-Bi-Monthly Customer Charge 3/4 33 $ 24.58 $ 808 28.03 921 29.50 970 48 1 40 31.42 1,255 35.83 1,431 37.71 1,506 75 11/2 32 53.75 1,720 61.29 1,961 64.51 2,065 103 2 39 83.42 3,269 95.13 3,728 100.13 3,923 196 Subtotal 144 7,052 8,041 8,464 423 Winter Usage 0 5,103 1.7086 8,718 1.9483 9,942 2.0508 10,464 523 Summer Usage Up to 3 CCF 0 1,691 1.7086 2,889 1.9483 3,295 2.0508 3,468 173 Over CCF 0 9,962 2.1630 21,547 2.4665 24,570 2.5962 25,862 1,291 Subtotal 0 16,755 33,154 37,807 39,794 1,987 Total Class 144 16,755 $ 40,206 $ 45,848 $ 48,258 $ 2,410 Other Public Authority-Bi-Monthly Customer Charge 1 0 $ 31.42 $ - 35.83 - 37.71 - - 1 1/2 0 53.75 - 61.29 - 64.51 - - 2 0 83.42 - 95.13 - 100.13 - - Subtotal 0 0 0 0 0 Winter Usage 0 0 1.7086 0 1.9483 0 2.0508 0 0 Summer Usage Up to 3 CCF 0 0 1.7086 0 1.9483 0 2.0508 0 0 Over CCF 0 0 2.1630 0 2.4665 0 2.5962 0 0 Subtotal 0 0 0 0 0 0 Total Class 0 0 $ - $ - $ - $ - Private Fire Lines-Bi-Monthly Fire Line Size 3"and smaller 11 0 $ 43.34 $ 494 43.34 494 43.34 494 - 4" 9 0 65.69 560 65.69 560 65.69 560 - 6" 8 0 163.15 1,229 163.15 1,229 163.15 1,229 - 8" 3 0 268.11 682 268.11 682 268.11 682 - Total Class 30 0 $ 2,965 $ 2,965 $ 2,965 $ - Total Adjustment 540 25,147 69,098 78,378 82,341 3,964 Case No.VEO-W-24-01 Exhibit No.5 VEO-W-24-01 Schedule No.4B-VWID System T.Michaelson IPUC DR 95 Attachment Page 1 of 1 Page 11 of 24 VEOLIA WATER IDAHO,INC. R-2 APPLICATION OF PRESENT AND PROPOSED RATES TO NUMBER OF CUSTOMERS ADDED IN TEST YEAR-EAGLE NEW Rate Block Number Total Present Proposed Proposed Proposed Proposed Phase II CCF Of Bills Consumption Rate Revenue Rate-Phase I Revenue-Phase I Rate-Phase II Revenue-Phase II Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Monthly Customer Charge 5/8 194 12.29 2,380 14.01 2,714 14.75 2,856 143 3/4 234 12.29 2,876 14.01 3,279 14.75 3,452 172 Subtotal 428 5,255 5,993 6,308 315 Winter Usage 0 1,337 1.7086 2,285 1.9483 2,606 2.0508 2,743 137 Summer Usage Up to 1.5 CCF 0 573 1.7086 979 1.9483 1,116 2.0508 1,175 59 Over 1.5 CCF 0 2,993 2.1630 6,473 2.4665 7,381 2.5962 7,769 388 Subtotal 0 4,903 9,736 11,103 11,686 584 Total Class 428 4,903 14,992 17,096 17,994 899 Commercial-Monthly Customer Charge 3/4 22 12.29 272 14.01 310 14.75 326 16 1 18 15.71 284 17.91 324 18.86 341 17 11/2 35 26.88 941 30.65 1,073 32.26 1,129 56 2 34 41.71 1,422 47.56 1,622 50.06 1,707 85 Subtotal 109 2,919 3,329 3,504 175 Winter Usage 0 1,937 1.7086 3,309 1.9483 3,773 2.0508 3,972 198 Summer Usage Up to 1.5 CCF 0 642 1.7086 1,097 1.9483 1,251 2.0508 1,316 66 Over 1.5 CCF 0 3,781 2.1630 8,178 2.4665 9,326 2.5962 9,816 490 Subtotal 0 6,360 12,584 14,350 15,104 754 Total Class 109 6,360 15,503 17,679 18,608 929 Other Public Authority-Monthly Customer Charge 5/8 0 9.22 0 14.01 0 14.75 0 0 3/4 0 9.22 0 14.01 0 14.75 0 0 1 1/2 0 20.16 0 30.65 0 32.26 0 0 2 0 31.28 0 47.56 0 50.06 0 0 Subtotal 0 0 0 0 0 Winter Usage 0 0 1.7086 0 1.9483 0 2.0508 0 0 Summer Usage Up to 1.5 CCF 0 0 1.7086 0 1.9483 0 2.0508 0 0 Over 1.5 CCF 0 0 2.1630 0 2.4665 0 2.5962 0 0 Subtotal 0 0 0 0 0 0 Total Class 0 0 0 0 0 0 Private Fire Lines-Monthly Fire Line Size 3"and smaller 6 0 21.67 126 21.67 126 21.67 126 0 4" 5 0 32.85 149 32.85 149 32.85 149 0 Total Class 30 0 275 275 275 0 Total Adjustment 547 11,262 30,770 35,049 36,877 1,828 Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4B-Eagle New VEO-W-24-01 T.Michaelson IPUC DR 95 Attachment Page 1 of 1 Page 12 of 24 VEOLIA WATER IDAHO,INC. R-3 APPLICATION OF PRESENT AND PROPOSED RATES TO WEATHER NORMALIZATION-VWID SYSTEM Rate Block Number Total Present Proposed Proposed Proposed Proposed Phasell CCF Of Bills Consumption Rate Revenue Rate-Phase I Rev-Phase I Rate-Phase 11 Rev-Phase 11 Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Bi-Monthly Customer Charge 0 0 0 0 Winter Usage 0 (289,617) 1.7086 (494,839) 1.9483 (564,274) 2.0508 (593,933) (29,659) Summer Usage Up to 3 CCF 0 (124,032) 1.7086 (211,921) 1.9483 (241,658) 2.0508 (254,360) (12,702) Over 3 CCF 0 (648,077) 2.1630 (1,401,790) 2.4665 (1,598,488) 2.5962 (1,682,506) (84,019) Subtotal 0 (1,061,725) (2,108,550) (2,404,420) (2,530,800) (126,380) Subtotal 0 (1,061,725) (2,108,550) (2,404,420) (2,530,800) (126,380) Total Class 0 (1,061,725) (2,108,550) (2,404,420) (2,530,800) (126,380) Commercial-Bi-Monthly Customer Charge 0 0 0 0 0 0 Winter Usage 0 (198,175) 1.7086 (338,601) 1.9483 (386,114) 2.0508 (406,408) (20,295) Summer Usage Up to 3 CCF 0 (65,679) 1.7086 (112,219) 1.9483 (127,965) 2.0508 (134,691) (6,726) Over CCF 0 (386,888) 2.1630 (836,839) 2.4665 (954,263) 2.5962 (1,004,421) (50,158) Subtotal 0 (650,742) (1,287,659) (1,468,342) (1,545,520) (77,178) Total Class 0 (650,742) $ (1,287,659) $ (1,468,342) $ (1,545,520) $ (77,178) Total 0 (1,712,467) (3,396,209) (3,872,762) (4,076,320) (203,558) Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4C-VWID System T.Michaelson VEO-W-24-01 Page 1 of 1 IPUC DR 95 Attachment Page 13 of 24 VEOLIA WATER IDAHO,INC. R-3 APPLICATION OF PRESENT AND PROPOSED RATES TO WEATHER NORMALIZATION-EAGLE EXIST Rate Block Number Total Present Proposed Proposed Proposed Proposed Phasell CCF Of Bills Consumption Rate Revenue Rate-Phase I Revenue-Phase I Rate-Phase II Revenue-Phase II Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Monthly Customer Charge 0 0 0 0 0 0 0 0 0 Winter Usage 0 (11,937) 1.2815 (15,297) 1.4613 (17,443) 1.5381 (18,360) (917) Summer Usage Up to 1.5 CCF 0 (5,112) 1.2815 (6,551) 1.4613 (7,470) 1.5381 (7,863) (393) Over 1.5 CCF 0 (26,711) 1.6223 (43,333) 1.8499 (49,414) 1.9472 (52,011) (2,597) Subtotal 0 (43,760) (65,181) (74,328) (78,234) (3,907) Total Class 0 (43,760) (65,181) (74,328) (78,234) (3,907) Commercial-Monthly Customer Charge 0 0 0 0 0 0 0 0 0 Winter Usage 0 (9,819) 1.2815 (12,583) 1.4613 (14,349) 1.5381 (15,103) (754) Summer Usage Up to 1.5 CCF 0 (3,254) 1.2815 (4,170) 1.4613 (4,755) 1.5381 (5,005) (250) Over 1.5 CCF 0 (19,169) 1.6223 (31,098) 1.8499 (35,462) 1.9472 (37,326) (1,864) Subtotal 0 (32,243) (47,852) (54,566) (57,434) (2,868) Total Class 0 (32,243) (47,852) (54,566) (57,434) (2,868) Total Adjustment 0 (76,002) (113,033) (128,894) (135,669) (6,775) Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4C-Eagle Exist VEO-W-24-01 T.Michaelson IPUC DR 95 Attachment Page 1 of 1 Page 14 of 24 VEOLIA WATER IDAHO,INC. R-3 APPLICATION OF PRESENT AND PROPOSED RATES TO WEATHER NORMALIZATION-EAGLE NEW Rate Block Number Total Present Proposed Proposed Proposed Proposed Phase II CCF Of Bills Consumption Rate Revenue Rate-Phase I Revenue-Phase I Rate-Phase II Revenue-Phase II Adjustments (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Residential-Monthly Customer Charge 0 0 0 0 0 0 0 0 0 Winter Usage 0 (448) 1.7086 (765) 1.9483 (873) 2.0508 (918) (46) Summer Usage Up to 1.5 CCF 0 (192) 1.7086 (328) 1.9483 (374) 2.0508 (393) (20) Over 1.5 CCF 0 (1,002) 2.1630 (2,168) 2.4665 (2,472) 2.5962 (2,602) (130) Subtotal 0 (1,642) (3,260) (3,718) (3,913) (195) Total Class 0 (1,642) (3,260) (3,718) (3,913) (195) Commercial-Monthly Customer Charge 0 0 0 0 0 0 0 0 0 Winter Usage 0 (677) 1.7086 (1,157) 1.9483 (1,320) 2.0508 (1,389) (69) Summer Usage Up to 1.5 CCF 0 (224) 1.7086 (384) 1.9483 (437) 2.0508 (460) (23) Over 1.5 CCF 0 (1,322) 2.1630 (2,860) 2.4665 (3,261) 2.5962 (3,433) (171) Subtotal 0 (2,224) (4,401) (5,018) (5,282) (264) Total Class 0 (2,224) (4,401) (5,018) (5,282) (264) Total Adjustment 0 (3,866) (7,661) (8,736) (9,195) (459) Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4C-Eagle New VEO-W-24-01 T.Michaelson IPUC DR 95 Attachment Page 1 of 1 Page 15 of 24 Veolia Water Idaho,Inc. Calculation of Predicted Residential Consumption(thousand gallons) (Yr- Actual Predicted Year 1990)A2 Yr-1990 PalmerZ Residential Residential SUMMARYOUTPUT 1995 1 1 1.72 155.00 158.64 1996 4 2 1.07 163.26 158.91 Regression Statistics 1997 9 3 0.60 159.56 158.41 Multiple R 0.9729 1998 16 4 2.28 153.51 148.75 R Square 0.9465 1999 25 5 (0.60) 171.17 158.53 Adjusted R Square 0.9426 2000 36 6 (0.52) 162.30 155.68 Standard Error 5.2599 2001 49 7 (1.51) 157.13 157.40 Observations 30 2002 64 8 (1.60) 157.19 155.29 2003 81 9 (0.56) 151.75 148.35 ANOVA 2004 100 10 (0.03) 144.39 143.59 df SS MS F Significance F 2005 121 11 0.06 132.26 140.70 Regression 2 13,224.99 6,612.49 239.01 0.00 2006 144 12 (0.24) 135.56 139.48 Residual 27 747.00 27.67 2007 169 13 (1.48) 139.23 142.26 Total 29 13,971.98 2008 196 14 (0.72) 130.28 136.52 2009 225 15 0.50 123.17 128.81 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 2010 256 16 1.35 116.70 122.69 Intercept 168.4794 1.9900 84.6612 0.0000 164.3962 172.5626 164.3962 172.5626 2011 289 17 1.26 114.86 120.57 Yr-1990 (2.5022) 0.1146 (21.8317) 0.0000 (2.7373) (2.2670) (2.7373) (2.2670) 2012 324 18 (0.85) 122.77 127.07 Palmer Z (4.2647) 0.9843 (4.3326) 0.0002 (6.2845) (2.2450) (6.2845) (2.2450) 2013 361 19 (1.34) 122.63 126.65 2014 400 20 (0.67) 119.24 121.29 2015 441 21 (1.22) 116.75 121.14 2016 484 22 (0.74) 115.21 116.59 2017 529 23 0.18 108.04 110.16 2018 576 24 (1.25) 111.26 113.76 2019 625 25 1.14 103.46 101.06 2020 676 26 (0.37) 107.92 105.00 2021 729 27 (0.93) 111.20 104.89 Input Y Range=E6-E35(Actual Consumption) 2022 784 28 (0.61) 103.13 101.02 Input X Range=C6-D35(Year and Palmer Z) 2023 841 29 0.32 100.01 94.55 2024 900 30 (0.16) 102.91 94.11 Twelve months ending August 2024 Difference b/w Predicted/Actual (8.79) Gallons (8,794) CCF (11.76) Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4D T.Michaelson VEO-W-24-01 Page 1 of 1 IPUC DR 95 Attachment Page 16 of 24 Veolia Water Idaho,Inc. Calculation of Predicted Commercial Consumption(thousand gallons) (Yr- Actual Predicted Year 1990)A2 Yr-1990 Palmer Z Commercial Commercial SUMMARY OUTPUT 1995 1 1 1.72 657.65 675.78 1996 4 2 1.07 706.86 679.53 Regression Statistics 1997 9 3 0.60 700.32 680.00 Multiple R 0.9331 1998 16 4 2.28 680.96 641.20 R Square 0.8706 1999 25 5 (0.60) 705.63 685.68 Adjusted R Square 0.8611 2000 36 6 (0.52) 703.36 676.10 Standard Error 27.6309 2001 49 7 (1.51) 738.84 686.07 Observations 30 2002 64 8 (1.60) 650.06 679.59 2003 81 9 (0.56) 634.28 652.48 ANOVA 2004 100 10 (0.03) 635.25 634.69 df SS MS F Significance F 2005 121 11 0.06 596.61 624.93 Regression 2 138,748.03 69,374.02 90.87 0.00 2006 144 12 (0.24) 623.67 622.29 Residual 27 20,613.60 763.47 2007 169 13 (1.48) 634.36 636.82 Total 29 159,361.63 2008 196 14 (0.72) 579.49 614.83 2009 225 15 0.50 541.89 584.43 Coefficients Standard Error t5tat P-value Lower95% Upper95% Lower95.0% Upper95.0% 2010 256 16 1.35 510.17 560.79 Intercept 715.3016 10.4539 68.4241 0.0000 693.8519 736.7513 693.8519 736.7513 2011 289 17 1.26 520.94 554.32 Yr-1990 (8.1159) 0.6021 (13.4800) 0.0000 (9.3512) (6.8806) (9.3512) (6.8806) 2012 324 18 (0.85) 573.02 584.74 Palmer Z (18.2615) 5.1709 (3.5316) 0.0015 (28.8713) (7.6517) (28.8713) (7.6517) 2013 361 19 (1.34) 571.54 585.57 2014 400 20 (0.67) 570.41 565.22 2015 441 21 (1.22) 554.90 567.15 2016 484 22 (0.74) 551.35 550.27 2017 529 23 0.18 526.50 525.35 2018 576 24 (1.25) 540.53 543.35 2019 625 25 1.14 503.83 491.59 Input Y Range=E6-E35(Actual Consumption) 2020 676 26 (0.37) 495.24 511.04 Input X Range=C6-D35(Year and Palmer Z) 2021 729 27 (0.93) 523.24 513.16 2022 784 28 (0.61) 509.16 499.20 2023 841 29 0.32 512.82 474.10 2024 900 30 (0.16) 522.20 474.82 Twelve months ending August 2024 Difference b/w Predicted/Actual (47.38) Gallons (47,382) CCF (63.34) Case No.VEO-W-24-01 Exhibit No.5 Schedule No.4E T.Michaelson VEO-W-24-01 Page 1 of 1 IPUC DR 95 Attachment Page 17 of 24 Veolia Water Idaho, Inc. Residential Consumption Trends 1995-2024 (gallons per customer) Change from Actual Previous Predicted Year Annual Usage Year Percent Residential 95 155,001 96 163,263 8,262 5.3% 158,912 97 159,559 (3,704) -2.3% 158,414 98 153,513 (6,046) -3.8% 148,747 99 171,173 17,660 11.5% 158,527 00 162,303 (8,870) -5.2% 155,684 01 157,127 (5,175) -3.2% 157,404 02 157,190 63 0.0% 155,286 03 151,750 (5,440) -3.5% 148,348 04 144,388 (7,362) -4.9% 143,586 05 132,263 (12,125) -8.4% 140,700 06 135,560 3,297 2.5% 139,477 07 139,231 3,671 2.7% 142,263 08 130,281 (8,949) -6.4% 136,520 09 123,172 (7,109) -5.5% 128,814 10 116,702 (6,471) -5.3% 122,687 11 114,864 (1,837) -1.6% 120,569 12 122,772 7,908 6.9% 127,065 13 122,630 (142) -0.1% 126,653 14 119,242 (3,388) -2.8% 121,293 15 116,753 (2,489) -2.1% 121,137 16 115,214 (1,540) -1.3% 116,588 17 108,042 (7,171) -6.2% 110,162 18 111,257 3,215 3.0% 113,758 19 103,460 (7,798) -7.0% 101,063 20 107,916 4,456 4.3% 105,001 21 111,201 3,285 3.0% 104,887 22 103,131 (8,070) -7.3% 101,020 23 100,006 (3,125) -3.0% 94,552 24 102,909 2,903 2.9% 94,114 Case No.VEO-W-24-01 Exhibit No. 5 Schedule No. 5 T. Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 18 of 24 Veolia Water Idaho, Inc. Residential Consumption trends 1995-2024 180,000 160,000 140,000 >- 120,000 a� n 100,000 0 U 80,000 m a 0 60,000 - - - CD 40,000 — 20,000 95 96 97 98 99 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Year Actual Annual Usage t Predicted Residential ......••• Linear( Predicted Residential ) Billed Historic Test Year Consumption per Customer Projected Test Year Consumption per customer 102,909 gallons per year 94,114 gallons per year 137.6 CCF per year 125.8 CCF per year 282 gallons per customer per day 258 gallons per customer per day Case No.VEO-W-24-01 Exhibit No.5 Schedule No. 6 T. Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 19 of 24 Veolia Water Idaho, Inc. Commercial Consumption Trends 1995-2024 (gallons per customer) Change Actual from Annual Previous Predicted Year Usage Year Percent Commercial 95 657,648 675,776 96 706,860 49,212 7.5% 679,530 97 700,319 (6,541) -0.9% 679,997 98 680,964 (19,354) -2.8% 641,202 99 705,635 24,670 3.6% 685,679 00 703,356 (2,278) -0.3% 676,102 01 738,845 35,488 5.0% 686,065 02 650,058 (88,787) -12.0% 679,593 03 634,278 (15,780) -2.4% 652,485 04 635,250 973 0.2% 634,690 05 596,606 (38,645) -6.1% 624,931 06 623,667 27,062 4.5% 622,294 07 634,363 10,696 1.7% 636,822 08 579,490 (54,873) -8.7% 614,827 09 541,893 (37,597) -6.5% 584,432 10 510,165 (31,728) -5.9% 560,794 11 520,941 10,775 2.1% 554,322 12 573,021 52,081 10.0% 584,738 13 571,537 (1,484) -0.3% 585,570 14 570,415 (1,122) -0.2% 565,219 15 554,895 (15,519) -2.7% 567,147 16 551,347 (3,548) -0.6% 550,265 17 526,498 (24,849) -4.5% 525,349 18 540,532 14,034 2.7% 543,347 19 503,834 (36,698) -6.8% 491,586 20 495,237 (8,597) -1.7% 511,045 21 523,243 28,006 5.7% 513,155 22 509,158 (14,085) -2.7% 499,196 23 512,818 3,659 0.7% 474,097 24 522,204 9,386 1.8% 474,822 Case No.VEO-W-24-01 Exhibit No. 5 Schedule No. 7 T. Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 20 of 24 Veolia Water Idaho, Inc. Commercial Consumption Trends 1995-2024 800,000 700,000 CO 600,000 aD a� n 500,000 E 0 �j 400,000 m a 0 300,000 CD 200,000 100,000 95 96 97 98 99 00 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 t Actual Annual Usage —41— Predicted Commercial ......••• Linear(Predicted Commercial) Billed Historic Test Year Consumption per Customer Projected Test Year Consumption per customer 522,204 gallons per year 474,822 gallons per year 698.1 CCF per year 634.8 CCF per year 1,431 gallons per customer per day 1,301 gallons per customer per day Case No.VEO-W-24-01 Exhibit No.5 Schedule No.8 T. Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 21 of 24 VEOLIA WATER IDAHO, INC. COMPARISON OF PRESENT AND PROPOSED RATES VWID SYSTEM-BI-MONTHLY Percentage Percentage Proposed Increase Proposed Increase Bi-Monthly Customer Rates-Phase Phase I vs. Rates-Phase Phase II vs. Charge Present Rates I Present II Present 5/8" 24.58 28.03 14.0% 29.50 20.0% 3/4" 24.58 28.03 14.0% 29.50 20.0% V. 31.42 35.83 14.0% 37.71 20.0% 11/2" 53.75 61.29 14.0% 64.51 20.0% 2" 83.42 95.13 14.0% 100.13 20.0% 3" 162.70 185.53 14.0% 195.28 20.0% 4" 303.54 346.13 14.0% 364.33 20.0% 6" 506.77 577.88 14.0% 608.25 20.0% 8" 662.97 756.00 14.0% 795.73 20.0% 10" 944.78 1,077.35 14.0% 1,133.98 20.0% 12" - 1,359.52 1,430.98 Percentage Percentage Proposed Increase Proposed Increase Rates-Phase Phase I vs. Rates-Phase Phase II vs. Consumption Charge Present Rates I Present II Present Winter Rates Up to 3 CCF 1.7086 1.9483 14.0% 2.0508 20.0% Over 3 CCF 1.7086 1.9483 14.0% 2.0508 20.0% Summer Rates Up to 3 CCF 1.7086 1.9483 14.0% 2.0508 20.0% Over 3 CCF 2.1630 2.4665 14.0% 2.5962 20.0% Hydrant Rent Flat Rate 26.77 30.53 14.0% 32.13 20.0% Street Sprinkling Service 328.35 374.43 14.0% 394.11 20.0% Flat Rate Service 94.30 107.53 14.0% 113.19 20.0% Percentage Percentage Proposed Increase Proposed Increase Rates-Phase Phase I vs. Rates-Phase Phase II vs. Private Fire Present Rates I Present II Present 3"and smaller 43.34 43.34 0.0% 43.34 0.0% 4" 65.69 65.69 0.0% 65.69 0.0% 6" 163.15 163.15 0.0% 163.15 0.0% 8" 268.11 268.11 0.0% 268.11 0.0% 10" 418.11 418.11 0.0% 418.11 0.0% 12" 626.28 626.28 0.0% 626.28 0.0% Hydrants 26.29 - -100.0% - -100.0% Case No.VEO-W-24-01 Exhibit No.5 Schedule No.9A T.Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 22 of 24 VEOLIA WATER IDAHO,INC. COMPARISON OF PRESENT AND PROPOSED RATES EXISTING EAGLE CUSTOMERS-MONTHLY Rates Rates Percentage Percentage Starting Starting Proposed Increase Proposed Increase Jan 1,2027 Jan 1,2028 Rates-Phase Phase I vs. Rates-Phase Phase II vs. (91.67%) (100%) Monthly Customer Charge Present Rates I Present II Present (1) (1) 5/8" 9.22 10.51 14.0% 11.07 20.0% 13.52 14.75 3/4" 9.22 10.51 14.0% 11.07 20.0% 13.52 14.75 1" 11.78 13.43 14.0% 14.14 20.0% 17.29 18.86 11/2" 20.16 22.99 14.0% 24.20 20.0% 29.57 32.26 2" 31.28 35.67 14.0% 37.54 20.0% 45.89 50.06 3" 61.01 69.57 14.0% 73.23 20.0% 89.51 97.64 4" 113.83 129.80 14.0% 136.63 20.0% 166.99 182.16 6" 190.04 216.71 14.0% 228.10 20.0% 278.79 304.13 8" 248.61 283.49 14.0% 298.40 20.0% 364.72 397.87 10" 354.29 404.00 14.0% 425.24 20.0% 519.76 566.99 12" - 509.81 536.61 655.89 715.49 Rates Rates Percentage Percentage Starting Starting Proposed Increase Proposed Increase Jan 1,2027 Jan 1,2028 Rates-Phase Phase I vs. Rates-Phase Phase II vs. (91.67%) (100%) Consumption Charge Present Rates I Present II Present (1) (1) Winter Rates Up to 1.5 CCF 1.2815 1.4613 14.0% 1.5381 20.0% 1.8799 2.0508 Over 1.5 CCF 1.2815 1.4613 14.0% 1.5381 20.0% 1.8799 2.0508 Summer Rates Up to 1.5 CCF 1.2815 1.4613 14.0% 1.5381 20.0% 1.8799 2.0508 Over 1.5 CCF 1.6223 1.8499 14.0% 1.9472 20.0% 2.3799 2.5962 Hydrant Rent Flat Rate 26.77 30.53 14.0% 32.13 20.0% 32.13 32.13 Flat Rate Service 31.43 35.84 14.0% 37.72 20.0% 51.88 56.59 Rates Rates Percentage Percentage Starting Starting Proposed Increase Proposed Increase Jan 1,2027 Jan 1,2028 Rates-Phase Phase I vs. Rates-Phase Phase II vs. (91.67%) (100%) Private Fire Present Rates I Present II Present (1) (1) 3"and smaller 16.25 16.25 0.0% 16.25 0.0% 19.86 21.67 4" 24.63 24.63 0.0% 24.63 0.0% 30.11 32.85 6" 61.18 61.18 0.0% 61.18 0.0% 74.78 81.58 8" 100.54 100.54 0.0% 100.54 0.0% 122.89 134.06 10" 139.37 139.37 0.0% 156.79 12.5% 191.64 209.06 12" 208.76 208.76 0.0% 234.86 12.5% 287.06 313.14 Hydrants 8.76 - -100.0% -100.0% - - (1)Assuming no subsequent base rate increases Case No.VEO-W-24-01 Exhibit No.5 Schedule No.9B T.Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 23 of 24 VEOLIA WATER IDAHO,INC. COMPARISON OF PRESENT AND PROPOSED RATES NEW EAGLE CUSTOMERS-MONTHLY Percentage Percentage Proposed Increase Proposed Increase Rates-Phase Phase I vs. Rates-Phase Phase II vs. Monthly Customer Charge Present Rates I Present II Present 5/8" 12.29 14.01 14.0% 14.75 20.0% 3/4" 12.29 14.01 14.0% 14.75 20.0% 1" 15.71 17.91 14.0% 18.86 20.0% 11/2" 26.88 30.65 14.0% 32.26 20.0% 2" 41.71 47.56 14.0% 50.06 20.0% 3" 81.35 92.76 14.0% 97.64 20.0% 4" 151.77 173.07 14.0% 182.16 20.0% 6" 253.39 288.94 14.0% 304.13 20.0% 8" 331.49 378.00 14.0% 397.87 20.0% 10" 472.39 538.68 14.0% 566.99 20.0% 12" - 679.76 715.49 Percentage Percentage Proposed Increase Proposed Increase Rates-Phase Phase I vs. Rates-Phase Phase II vs. Consumption Charge Present Rates I Present II Present Winter Rates Up to 1.5 CCF 1.7086 1.9483 14.0% 2.0508 20.0% Over 1.5 CCF 1.7086 1.9483 14.0% 2.0508 20.0% Summer Rates Up to 1.5 CCF 1.7086 1.9483 14.0% 2.0508 20.0% Over 1.5 CCF 2.163 2.4665 14.0% 2.5962 20.0% Hydrant Rent Flat Rate 26.77 30.53 14.0% 32.13 20.0% Flat Rate Service 47.15 53.77 14.0% 56.59 20.0% Percentage Percentage Proposed Increase Proposed Increase Rates-Phase Phase I vs. Rates-Phase Phase II vs. Private Fire Present Rates I Present II Present 3"and smaller 21.67 21.67 0.0% 21.67 0.0% 4" 32.85 32.85 0.0% 32.85 0.0% 6" 81.58 81.58 0.0% 81.58 0.0% 8" 134.06 134.06 0.0% 134.06 0.0% 10" 209.06 209.06 0.0% 209.06 0.0% 12" 313.14 313.14 0.0% 313.14 0.0% Hydrants 13.15 - -100.0% 0 -100.0% Case No.VEO-W-24-01 Exhibit No.5 Schedule No.9C T. Michaelson Page 1 of 1 VEO-W-24-01 IPUC DR 95 Attachment Page 24 of 24