Loading...
HomeMy WebLinkAbout20041201Healy Exhibits.pdfIdaho Public Utilities Commission Office of the SecretaryRECEIVED Dean J. Miller McDEVITT & MILLER LLP 420 West Bannock Street O. Box 2564-83701 Boise, ill 83702 Tel: 208.343.7500 Fax: 208.336.6912 oe~mcdevitt -miller .com Nav 3 0 2004 Boise, Idaho Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR WATER SERVICE IN THE STATE OF IDAHO Case No. UWI-O4- BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION EXHffiIT 1 TO THE DIRECT TESTIMONY OF JEREMIAH J. HEALY UN I T E D W A T E R I D A H O CA S E U W I - 04 - 4 Ra t e B a s e S u m m a r y Te s t Y e a r E n d e d J u l y 3 1 , 2 0 0 4 a n d t h e P r o F o r m a Y e a r E n d e d M a y 3 1 , 2 0 0 5 (A ) (B ) (C ) (D ) (E ) Pr o F o r m a Pe r B o o k s J u l y Te s t Y e a r Ye a r M a y 3 1 Li n e N o . De s c r i ti o n , 2 0 0 4 us t m e n t s us t e d us t m e n t s 20 0 5 Ut i l i t y P l a n t I n S e r v i c e $ 2 2 7 , 4 8 3 39 9 $ 2 2 7 , 4 8 3 , 39 9 15 6 52 1 $ 2 5 8 , 63 9 , 92 0 Ac c u m u l a t e d D e p r e c i a t i o n , A m o r t i z a t i o n o f UP A A a n d A m o r t i z a t i o n o f PH F U (5 5 28 7 81 9 ) (5 5 , 28 7 81 9 ) 89 2 91 2 ) (6 0 , 18 0 , 73 1 ) Ne t U t i l i t y P l a n t $ 1 7 2 , 19 5 , 58 0 $ 1 7 2 , 19 5 , 58 0 26 , 26 3 , 60 9 $ 1 9 8 , 45 9 , 18 9 Cu s t o m e r A d v a n c e s f o r C o n s t r u c t i o n 07 2 33 7 ) 07 2 33 7 ) 70 6 98 0 (6 , 36 5 , 35 7 ) Co n t r i b u t i o n s i n A i d o f C o n s t r u c t i o n ( n e t ) (4 4 67 0 35 9 ) (4 4 67 0 , 35 9 ) 66 0 , 66 0 (4 3 , 00 9 , 69 9 ) Ut i l i t y P l a n t A c q u i s i t i o n A d j u s t m e n t s ( g r o s s ) 60 0 , 76 2 60 0 76 2 60 0 , 76 2 Ac c u m u l a t e d D e f e r r e d I n c o m e T a x e s (1 1 14 4 38 8 ) (1 1 14 4 38 8 ) 54 1 52 2 ) (1 3 , 68 5 , 91 0 ) Pr e - 19 7 1 I n v e s t m e n t T a x C r e d i t s (1 4 32 8 ) (1 4 32 8 ) 07 1 (1 3 , 25 7 ) De f e r r e d C h a r g e s 63 5 , 12 4 63 5 12 4 39 6 56 8 03 1 69 2 Wo r k i n g C a p i t a l 04 5 12 6 04 5 12 6 04 5 , 12 6 To t a l R a t e B a s e $ 1 1 3 , 57 5 , 18 0 $ 1 1 3 , 57 5 , 18 0 26 , 48 7 , 36 6 14 0 , 06 2 , 54 6 Ex h i b i t N o . J. H e a l y Pa g e 1 o f 9 (1 ) Li n e N o . Un i t e d W a t e r I d a h o Ca s e U W I - W- O 4 - 4 Pl a n t I n S e r v i c e a t J u l y 3 1 20 0 4 a n d t h e Pr o F o r m a Y e a r E n d e d M a y 3 1 , 2 0 0 5 (2 ) (3 ) Pl a n t Ac c o u n t Nu m b e r Pla n t A c c o u n t D e s c r i p t i o n 30 1 - 30 3 - 30 3 - 30 3 - 4 0 30 3 - 30 4 - 30 4 - 30 4 - 4 0 30 4 - 30 5 . 30 6 - 30 7 - 30 8 - 30 9 - 31 0 - 31 1 - 31 1 - 31 1 - 31 1 - 32 0 - 32 0 - 33 0 - 33 1 - 33 1 - 33 1 - 4 0 33 3 - 4 0 33 4 - 33 5 - 4 0 33 6 - 4 0 33 9 - 33 9 - 33 9 - 33 9 - 4 0 33 9 - 34 0 - 34 0 - 34 O - 34 O - 34 O - 34 1 - 34 2 - 34 3 - 34 3 - 34 4 - 34 5 . 34 5 - 34 6 - 34 7 - 34 8 - 34 8 - Or g a n i z a t i o n la n d & l a n d R i g h t s , W a t e r Rig h t s - S o u r c e o f S u p p l y la n d & l a n d R i g h t s - Wa t e r T r e a t m e n t la n d & l a n d R i g h t s - Tr a n s . & D i s t r i b . la n d & l a n d R i g h t s - Ge n e r a l P l a n t St r u c t u r e s a n d I m p r o v e m e n t s - S o u r c e o f S u p p l y St r u c t u r e s a n d I m p r o v e m e n t s - W a t e r T r e a t m e n t St r u c t u r e s a n d I m p r o v e m e n t s - T r a n s . & D i s t r i b . St r u c t u r e s a n d I m p r o v e m e n t s - G e n e r a l P l a n t Co l l e c t i n g & I m p o u n d i n g R e s e r v o i r s - S o u r c e o f S u p p l y la k e , R i v e r & O t h e r I n t a k e s We l l s & S p r i n g s In f i l t r a t i o n G a l l e r i e s & T u n n e l s Su p p l y M a i n s Po w e r G e n e r a t i o n E q u i p m e n t Po w e r E l e c t r i c P u m p i n g E q u i p m e n t - S o u r c e o f S u p p l y Po w e r D i e s e l P u m p i n g E q u i p m e n t - S o u r c e o f S u p p l y Po w e r P u m p i n g E q u i p m e n t - W a t e r T r e a t m e n t Po w e r P u m p i n g E q u i p m e n t - T r a n s . & D i s t r i b . Wa t e r T r e a t m e n t E q u i p m e n t Wa t e r T r e a t m e n t E q u i p m e n t - M e m b r a n e s Di s t r i b u t i o n R e s e r v o i r s & S t a n d p i p e s Tr a n s . & D i s t r i b . M a i n s & A c c e s s o r i e s - I n t a n g i b l e Tr a n s . & D i s t r i b . M a i n s & A c c e s s o r i e s - S O S Tr a n s . & D i s t r i b . M a i n s & A c c e s s o r i e s Se r v i c e s Me t e r s a n d M e t e r I n s t a l l a t i o n s Hy d r a n t s Ba c k f l o w P r e v e n t i o n D e v i c e s Ot h e r P l a n t & M i s c . E q u i p m e n t - I n t a n g i b l e Ot h e r P l a n t & M i s c . E q u i p m e n t - S o u r c e o f S u p p l y Ot h e r P l a n t & M i s c . E q u i p m e n t - W a t e r T r e a t m e n t Ot h e r P l a n t & M i s c . E q u i p m e n t - T r a n s . & D i s t r i b . Ot h e r P l a n t & M i s c . E q u i p m e n t - G e n e r a l P l a n t Of f i c e F u r n i t u r e a n d E q u i p m e n t AM / F M S y s t e m - M a p p i n g Co m p u t e r H a r d w a r e & S o f t w a r e IF M S / W A N / P e o p l e S o f t Cu s t o m e r I n f o r m a t i o n S y s t e m Tr a n s p o r t a t i o n E q u i p m e n t Sto r e s E q u i p m e n t To o l s , S h o p a n d G a r a g e E q u i p m e n t Co n f i n e d S p a c e M o n i t o r , G e n e r a t o r , T r e n c h S h i e l d la b o r a t o r y E q u i p m e n t Po w e r O p e r a t e d E q u i p m e n t Po w e r O p e r a t e d E q u i p m e n t Co m m u n i c a t i o n s E q u i p m e n t Mis c e l l a n e o u s E q u i p m e n t Oth e r T a n g i b l e P r o p e r t y Ma s t e r P l a n Ro u n d i n g To t a l P l a n t I n S e r v i c e (4 ) (5 ) (6 ) (7 ) (8 ) (9 ) (1 0 ) (1 1 ) le s s : P l a n t H e l d Fo r F u t u r e U s e Pe r A s s e t M g t GL A c c o u n t Ma t r i x 10 5 0 0 0 Pr o F o r m a Ad d i t i o n s Pr o F o r m a - Au g u s t 1 , 2 0 0 4 Re c l a s s P H F U t o th r o u g h M a y Pla n t i n S e r v i c e 3 1 20 0 5 Pro F o r m a Re t i r e m e n t s Au g u s t 1 , 2 0 0 4 th r o u g h M a y 3 1 20 0 5 Pr o F o r m a Ca r r i a g e H i l l U t i l i t y P l a n t i n Tr a n s a c t i o n S e r v i c e Ma y Im p a c t 3 1 , 20 0 5 Pe r G e n e r a l le d g e r Pla n t I n S e r v i c e Ri v e r I n t a k e Pla n t I n S e r v i c e Riv e r I n t a k e Ad d i t i o n s Re t i r e m e n t s Ot h e r Ut i l i t y P l a n t 07 / 3 1 / 2 0 0 4 07 / 3 1 / 2 0 0 4 05 / 3 1 / 2 0 0 5 11 6 , 92 6 11 6 , 92 6 (9 , 87 8 ) 10 7 , 04 8 25 6 61 9 25 6 61 9 19 0 58 9 (7 8 , 17 1 ) 36 9 , 03 7 88 9 03 4 88 9 , 03 4 88 9 03 4 41 1 62 6 41 1 , 62 6 41 1 , 62 6 21 3 , 38 3 21 3 , 38 3 21 3 , 38 3 31 9 , 53 0 (6 5 9 75 5 ) 65 9 , 77 5 65 9 , 75 5 68 4 07 3 (6 , 80 0 ) (3 6 , 31 4 ) 96 0 , 48 9 00 2 , 05 0 00 2 05 0 46 2 , 86 2 46 4 91 2 35 , 38 8 35 , 38 8 57 5 (3 , 00 0 ) 40 , 96 3 19 3 , 68 8 19 3 , 68 8 94 , 15 8 (1 2 , 50 0 ) 27 5 34 6 83 , 21 7 83 , 21 7 21 7 27 2 , 27 5 (7 3 6 , 74 2 ) 53 5 53 3 73 6 , 74 2 27 2 , 27 5 20 5 , 94 1 20 5 , 94 1 24 1 01 1 (1 5 2 , 31 9 ) 29 4 63 3 65 2 65 2 65 2 59 2 , 82 5 59 2 , 82 5 62 0 , 84 2 21 3 , 66 7 38 1 , 12 5 38 1 , 12 5 93 , 40 8 47 4 , 53 3 10 , 24 6 64 1 10 , 24 6 64 1 71 3 , 04 3 (8 7 04 0 ) (8 0 58 4 ) 79 2 06 0 35 7 , 99 8 35 7 , 99 8 18 5 , 62 7 54 3 , 62 5 96 1 , 39 0 96 1 39 0 13 , 84 8 (1 9 , 27 0 ) 95 5 , 96 8 97 8 , 19 0 97 8 , 19 0 42 6 38 6 (8 9 , 45 7 ) 22 , 31 5 , 11 9 50 0 , 00 0 50 0 00 0 84 8 52 8 84 8 52 8 22 6 , 96 7 07 5 , 49 5 14 5 14 5 14 5 14 4 14 4 14 4 10 0 , 75 6 , 12 5 (1 , 15 9 16 1 ) 99 , 59 6 , 96 4 15 9 16 1 75 6 95 8 (6 8 , 63 1 ) (1 2 8 , 05 5 ) 10 3 , 31 6 , 39 7 36 , 82 4 78 6 82 4 78 6 65 8 , 23 1 (1 1 5 , 00 0 ) (2 8 , 74 3 ) 37 , 33 9 , 27 4 11 , 57 5 , 44 8 11 , 57 5 , 44 8 98 , 17 3 (1 1 5 00 0 ) (3 , 00 0 ) 55 5 , 62 1 07 8 , 40 5 07 8 40 5 (1 0 76 3 ) 06 7 , 64 2 37 , 15 7 15 7 63 7 45 , 79 4 43 , 52 5 43 , 52 5 43 , 52 5 88 , 44 1 44 1 88 , 44 1 15 , 79 8 15 , 79 8 15 , 79 8 68 4 57 9 68 4 , 57 9 14 , 00 0 13 4 ) 69 7 , 44 5 55 2 , 91 0 55 2 91 0 55 2 91 0 72 3 , 56 3 72 3 , 56 3 23 6 , 96 5 (1 6 7 , 75 0 ) 79 2 , 77 8 87 0 , 10 5 87 0 , 10 5 19 7 , 37 9 06 7 , 48 4 79 5 06 9 79 5 , 06 9 79 5 , 06 9 13 4 11 1 13 4 , 11 1 00 0 13 6 , 11 1 44 8 24 , 44 8 24 , 44 8 45 5 , 94 5 45 5 , 94 5 00 0 46 3 , 94 5 53 3 62 , 53 3 62 , 53 3 11 6 64 3 11 6 64 3 11 6 , 64 3 58 , 81 7 58 , 81 7 58 , 81 7 62 , 88 2 62 , 88 2 30 0 (1 4 , 91 0 ) 69 , 27 2 30 0 , 44 7 30 0 , 44 7 12 , 65 3 (6 , 60 0 ) (7 , 51 8 ) 29 8 , 98 2 10 7 , 62 1 10 7 , 62 1 10 7 , 62 1 26 8 38 1 26 8 , 38 1 36 7 61 7 63 5 , 99 8 (1 ) 23 0 03 9 , 05 6 (2 , 55 5 , 65 8 ) 22 7 , 48 3 , 39 8 55 5 , 65 8 84 3 , 30 1 (7 0 7 09 2 ) (5 3 5 , 34 5 ) 25 8 , 63 9 92 0 Ex h i b i t N o 1 J. H e a l y Pa g e 2 0 f 9 Un i t e d W a t e r I d a h o Ca s e N o . U W I - 04 - 4 Ba l a n c e o f A c c u m u l a t e d D e p r e c i a t i o n a n d A c c u m u l a t e d A m o r t i z a t i o n o f CI A C , A c c u m u l a t e d D e p r e c i a t i o n o f P l a n t H e l d F o r F u t u r e U s e a n d UP A A A m o r t i z a t i o n Te s t Y e a r E n d e d J u l y 3 1 20 0 4 a n d P r o F o r m a Y e a r E n d e d M a y 3 1 , 2 0 0 5 (A ) (B ) (C ) (D ) (E ) (F ) Am o r t i z a t i o n o f Ac c u m u l a t e d Ac c u m u l a t e d Pl a n t H e l d f o r Am o r t i z a t i o n o f De p r e c i a t i o n CI A C R e s e r v e Fu t u r e U s e UP A A Li n e N o . At J u l y 3 1 , ? Q ( ) 4 : Ii ? ! 98 5 46 , 69 9 67 7 29 3 , 50 1 28 0 , 65 6 98 5 Ac c u m u l a t e d D e p r e c i a t i o n Ac c u m u l a t e d R e s e r v e f o r D e p r e c i a t i o n CI A C Am o r t i z a t i o n o f P l a n t H e l d f o r F u t u r e U s e Am o r t i z a t i o n o f U P A A 46 , 69 9 , 67 7 29 3 50 1 28 0 65 6 Ac c u m u l a t e d D e p r e c i a t i o n A n d A m o r t i z a t i o n a t J u l y 3 1 , 20 0 ~ 46 , 69 9 , 67 7 29 3 , 50 1 28 0 , 65 6 13 , 98 5 55 , 28 7 81 9 Fr o m A u g u s t 1 2 0 0 4 t o Ma y 3 1 , 2 0 0 5 : De p r e c i a t i o n E x p e n s e o n J u l y 3 1 , 20 0 4 P I S , t e n m o n t h s 42 9 , 91 0 42 9 , 91 0 De p r e c i a t i o n E x p e n s e o n PI S a d d s p r i o r t o M a y 3 1 , 20 0 5 , t w o a n d o n e ha l f m o n t h c o n v e n t i o n 25 8 , 54 7 25 8 54 7 Ut i l i t y P l a n t R e t i r e m e n t s A u g u s t 1 , 2 0 0 4 t o M a y 3 1 , 2 0 0 ~ (7 0 7 09 2 ) (7 0 7 , 09 2 ) Am o r t i z a t i o n o f C o n t r i b u t e d P l a n t A u g u s t 1 , 2 0 0 4 t o M a y 3 1 , 2 0 0 ~ 95 1 , 4 6 0 95 1 , 46 0 Am o r t i z a t i o n o f P l a n t H e l d f o r F u t u r e U s e A u g I, 2 0 0 4 t o M a y 3 1 , 2 0 0 ~ 42 , 60 0 60 0 Tr a n s f e r i n F r o m PH F U f o r C W T P R W P S 32 3 , 25 6 (3 2 3 , 25 6 ) Co s t o f R e m o v a l o n P l a n t R e t i r e m e n t s (9 4 36 5 ) (9 4 , 36 5 ) Sa l v a g e o n P l a n t R e t i r e m e n t s 19 , 35 0 19 , 35 0 Re c o r d U P A A A m o r t i z a t i o n A u g 1 2 0 0 4 t o M a y 3 1 , 2 0 0 ~ 77 4 77 4 Re v e r s e C a r r i a g e H i l l A c c u m u l a t e d D e p r o n R e f u n d e d A d v a n c e s (2 , 4 1 0 ) (2 , 41 0 ) Re v e r s e C a r r i a g e A m o r t R e s e r v e F o r D e p r o f CI A C (1 2 86 2 ) (1 2 86 2 ) 50 , 92 6 , 87 3 23 2 , 09 9 21 , 75 9 60 , 18 0 , 73 1 Ch a n g e A u g u s t 1 , 2 0 0 4 t o M a y 3 , 2 0 0 5 22 7 , 19 6 93 8 , 59 8 (2 8 0 , 65 6 ) 77 4 89 2 , 91 2 Ex h i b i t N o . J. H e a l y Pa g e 3 o f 9 Un i t e d W a t e r I d a h o Ca s e U W I - 04 - 4 Ad v a n c e s f o r C o n s t r u c t i o n a s o f J u l y 3 1 , 20 0 4 a n d Pr o F o r m a Y e a r E n d e d M a y 3 1 , 2 0 0 5 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) (8 ) (9 ) (1 0 ) (1 1 ) Re c l a s s o f A d v a n c e s i n C W I P Re c l a s s o f Be l m o n t Re c l a s s o f Pr o F o r m a Ad v a n c e s f o r Re c l a s s o f So u r c e o f Ad v a n c e Re s t a t e d Re f u n d s A u g Ca r r i a g e H i l l Co n s t r u c t i o n Ba l a n c e a s o f Da n s k i n W e l l Mi c r o n / A r r o w Su p p l y Re f u n d s J u l y Ad v a n c e s a t 20 0 4 t o Tr a n s a c t i o n at M a y 3 1 Li n e N o Pl a n t A c c o u n t Ju l y 3 1 , 2 0 0 4 #2 A d v a n c e he a d R e c l a s s Ac q u i s i t i o n 20 0 4 Ju l y 3 1 , 2 0 0 4 Ma y 3 1 , 20 0 5 Im p a c t 20 0 5 30 1 1 0 - O r g a n i z a t i o n I n t a n g i b l e P l a n t 98 6 . 98 6 . 98 6 . 30 3 2 0 - S o u r c e o f S u p p l y l a n d & l a n d R i g h t s 34 7 57 4 . 68 0 . 37 9 , 25 4 . (1 0 26 0 . 00 ) (7 4 18 7 . 00 ) 29 4 80 7 . 30 3 4 0 - W a t e r T r e a t m e n t P l a n t la n d & l a n d R i g h t s 50 , 86 5 . 41 9 . 00 ) 49 , 44 6 . (6 , 46 7 . 00 ) 42 , 97 9 . 30 4 2 0 - S o u r c e o f S u p p l y & P u m p i n g P l a n t St r u c t u r e s & I m p r o v e m e n t s 85 , 38 3 . 40 , 09 6 . 12 5 , 47 9 . (1 1 66 0 . 00 ) (3 3 13 4 . 00 ) 80 , 68 5 . 30 5 2 0 - S o u r c e o f S u p p l y & P u m p i n g P l a n t Co l l e c t i n g a n d I m p o u n d i n g P l a n t 52 1 27 3 . (5 2 1 , 27 3 . 35 ) 30 7 2 0 - S o u r c e o f S u p p l y & P u m p i n g P l a n t W e l l s & S p r i n g s 36 9 , 14 4 . 64 1 . 14 1 41 4 . 58 3 , 20 1 . (1 4 51 0 . 00 ) (1 4 2 74 3 . 00 ) 42 5 , 94 8 . 30 9 2 0 - S o u r c e o f S u p p l y & P u m p i n g P l a n t Su p p l y Ma i n s 37 4 27 2 . 03 6 . 41 4 . 00 ) 37 8 89 4 . (1 4 60 0 . 00 ) 36 4 , 29 4 . 31 1 2 0 . S o u r c e o f S u p p l y & P u m p i n g P l a n t P o w e r Ge n e r a t i o n E q u i p m e n t 52 8 , 61 5 . 16 7 . 86 4 . 70 5 . 00 ) 60 3 , 94 2 . (2 9 , 11 0 . 00 ) (7 5 , 84 4 . 00 ) 49 8 , 98 8 . 31 1 4 0 - T r a n s & D i s t P l a n t P u m p i n g E q u i p m e n t 12 9 , 57 4 . 12 9 , 57 4 . 12 9 , 57 4 . 32 0 3 0 - W a t e r T r e a t m e n t P l a n t T r e a t m e n t Eq u i p m e n t 38 4 . 38 4 . 38 4 . 33 0 4 0 - T r a n s & D i s t P l a n t R e s e r v o i r s 65 3 , 19 . 33 7 19 8 . (8 , 25 3 . 00 ) 98 2 66 5 . (1 2 7 85 1 . 00 ) 85 4 81 4 . 33 1 4 0 - T r a n s & D i s t P l a n t M a i n s 13 7 , 12 3 . 15 , 58 5 . (1 0 , 32 7 . 00 ) 14 2 , 38 1 . (1 2 1 24 6 . 00 ) 02 1 13 5 . 33 3 4 0 . T r a n s & D i s t P l a n t S e r v i c e s 60 6 , 56 0 . 82 0 . 00 ) 60 2 , 74 0 . (3 9 09 0 . 00 ) 56 3 , 65 0 . 33 3 5 0 - T r a n s & D i s t P l a n t H y d r a n t s 98 6 . 98 6 . 98 6 . 34 6 5 0 - G e n e r a l P l a n t C o m m u n i c a t i o n E q u i p m e n t 33 , 58 7 . 91 6 . 89 6 . 77 , 39 9 . 28 0 . 00 ) (4 , 99 8 . 00 ) 71 , 12 1 . Ad v a n c ~ s i n C W I P 34 6 , 86 0 . (8 7 , 84 5 . 17 ) (2 9 8 , 95 3 . 23 ) 39 , 93 8 . Ro u n d i n g To t a l P e r G l J u l y 3 1 , 2 0 0 4 07 2 , 33 7 . 07 2 , 33 7 . (3 7 6 , 07 4 . 00 ) (3 3 0 , 90 6 . 00 ) 36 5 , 35 7 . Ex h i b i t N o . J. H e a l y Pa g e 4 o f 9 Li n e N o . Ch a n g e Un i t e d W a t e r I d a h o CA S E U W I - 04 - 4 Co n t r i b u t i o n s i n A i d o f C o n s t r u c t i o n ( n e t ) a s o f J u l y 3 1 20 0 4 a n d P r o F o r m a Y e a r E n d e d M a y 3 1 , 20 0 5 Co n t r i b u t i o n s i n A i d o f C o n s t r u c t i o n a t J u l y 3 1 , 20 0 4 : Gr o s s B a l a n c e i n G e n e r a l L e d g e r A c c o u n t 2 7 1 0 0 0 $ 5 2 , 96 3 , 85 8 Ac c u m u l a t e d A m o r t i z a t i o n i n G e n e r a l L e d g e r A c c o u n t 2 7 2 0 0 0 (8 , 29 3 50 1 ) Ba l a n c e a t J u l y 3 1 20 0 4 $ 4 4 , 67 0 , 35 7 Fr o m A u g u s t 1 , 2 0 0 4 t h r o u g h M a y 3 1 , 2 0 0 5 : Am o r t i z a t i o n O f C o n t r i b u t i o n s Re v e r s e C a r r i a g e H i l l C I A C Re v e r s e C a r r i a g e H i l l C I A C A m o r t Ba l a n c e i n C I A C a s s o c i a t e d w i t h C W I P (9 5 1 , 4 5 8 ) (1 7 7 , 4 3 8 ) 86 2 (5 4 4 62 6 ) $ 4 3 , 00 9 , 69 7 Ne t C o n t r i b u t i o n s i n A i d o f C o n s t r u c t i o n a t M a y 31 , 2 0 0 5 66 0 , 66 0 ) Ex h i b i t N o . J. H e a l y Pa g e 5 o f 9 Un i t e d W a t e r I d a h o I n c Ca s e U W I - W- O 4 - 4 Su m m a r y o f G r o s s a n d N e t U t i l i t y P l a n t A c q u i s i t i o n A d j u s t m e n t s Te s t Y e a r E n d e d J u l y 3 1 , 2 0 0 4 Pr o F o r m a t h r o u g h M a y 3 1 , 2 0 0 5 Am o r t i z a t i o n Ne t Pr o F o r m a UP A A Th r o u g h J u l y Un a m o r t i z e d Mo n t h l y Mo n t h s A u g u s t Co n s o l i d a t e d Co m p a n y IP U C O r d e r Am o r t z a t i o n Ac c o u n t 20 0 4 A c c o u n t Ba l a n c e a t Am o r t i z a t i o n th r o u g h M a y Pr o F o r m a Ne t U P A A A t Ac q u i s t i o n D e s c r i p t i o n Pr o j e c t I D Mo n t h Pe r i o d 11 4 0 0 0 11 5 0 0 0 Ju l y , 2 0 0 4 Am o u n t 20 0 5 Am o r t i z a t i o n Ma y . 31 , 20 0 5 Wa r m S p r i n g s M e s a XO O O 0 9 Au g u s t 1 9 9 6 20 Y e a r s 30 2 66 0 64 2 (2 6 0 ) (2 , 59 5 . 90 ) 04 6 . Re d w o o d C r e e k XO O 0 1 0 Ma y 1 9 9 5 20 Y e a r s (1 1 0 24 9 ) (5 1 45 0 ) (5 8 79 9 ) 45 9 59 3 . (5 4 20 5 . 30 ) Is l a n d W o o d s XO O 0 1 1 Ap r i p 1 9 9 5 20 Y e a r s (1 7 9 67 5 ) (8 3 , 09 9 ) (9 6 , 57 6 ) 74 9 7, 4 8 6 . (8 9 08 9 . 50 ) Ra i n t r e e XO O 0 1 4 Se p t e m b e r 2 0 0 0 40 Y e a r s (2 2 7 59 4 ) (2 2 35 3 ) (2 0 5 24 1 ) 47 4 74 0 . (2 0 0 , 50 1 . 00 ) So u t h C o u n t y W a t e r XO O 0 2 0 Ja n u a r y 1 9 9 9 40 Y e a r s 00 9 01 1 14 0 84 4 86 8 16 7 10 2 ) (2 1 02 0 . 00 ) 84 7 14 7 . Ba r b e r W a t e r XO O 0 2 7 Ja n u a r y 1 9 9 9 40 Y e a r s 46 , 96 6 38 2 41 , 58 4 (9 8 ) (9 7 8 . 50 ) 40 , 60 5 . 60 0 , 76 1 13 , 98 4 58 6 , 77 7 (7 7 7 ) 77 4 ) $ 57 9 , 00 3 Ex h i b i t N o . J. H e a l y Pa g e 6 o f 9 Li n e N o . Un i t e d W a t e r I d a h o CA S E U W I - 04 - Ac c u m u l a t e d D e f e r r e d F e d e r a l I n c o m e T a x e s a s o f J u l y , 2 0 0 4 a n d P r o F o r m a Y e a r E n d e d M a y 3 1 , 2 0 0 5 Ac c o u n t & D e s c r i p t i o n 28 2 0 0 1 A c c u m u l a t e d D e f e r r e d F I T A C R S 28 2 0 0 2 A c c u m u l a t e d D e f e r r e d F I T M A C R S 28 2 0 1 0 D e f e r r e d F I T A D R 28 3 3 0 0 D e f e r r e d F I T 28 3 9 9 1 D e f e r r e d F I T A F U D C E q u i t y 25 3 1 0 8 D e f e r r e d A d v a n c e s a n d C o n t r i b u t i o n s G r o s s U P De f e r r e d F e d e r a l F I T a t J u l y 3 1 , 2 0 0 4 Pr o F o r m a T a x D e p r e c i a t i o n Pr o F o r m a B o o k D e p r e c i a t i o n Ex c e s s T a x O v e r B o o k D e p r e c i a t i o n Fe d e r a l I n c o m e T a x R a t e In c r e m e n t a l D e f e r r e d F e d e r a l I n c o m e T a x To t a l D e f e r r e d F I T ( L i n e 7 p l u s l i n e 1 2 ) Ba l a n c e a t J u l y , 2 0 0 4 90 1 48 0 72 7 56 7 42 5 , 4 9 2 (7 9 8 , 99 8 ) 55 5 , 08 7 33 3 65 6 14 4 28 4 Pr o F o r m a Ba l a n c e a t M a y 20 0 5 13 , 64 8 , 00 1 38 6 50 9 26 1 , 49 2 35 . 00 % 54 1 , 52 2 13 , 68 5 , 80 6 Ex h i b i t N o . J. H e a l y Pa g e 7 o f 9 Un i t e d W a t e r I d a h o Ca s e N o U W I - 04 - Pr e - 19 7 1 I n v e s t m e n t T a x C r e d i t fo r t h e T e s t Y e a r E n d e d J u l y 3 1 , 2 0 0 4 an d t h e P r o F o r m a Y e a r e n d i n g Ma y , 3 1 , 2 0 0 5 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) Bo o k Ba l a n c e a t Te n Ba l a n c e a t Ju l y 3 1 An n u a l Mo n t h s Ma y 3 1 Li n e N o Ye a r Bo o k L i f e 20 0 4 Ex p e n s e Ex p e n s e 20 0 5 19 6 2 50 Y e a r s 36 4 18 2 15 2 21 2 19 6 3 50 Y e a r s 13 1 13 4 11 2 01 9 19 6 4 50 Y e a r s 90 5 82 3 19 6 5 50 Y e a r s 84 1 17 6 14 7 69 4 19 6 6 50 Y e a r s 54 0 13 6 11 3 42 7 19 6 7 50 Y e a r s 55 4 12 4 10 3 45 1 19 6 8 50 Y e a r s 3, 4 6 8 25 8 21 5 25 3 19 6 9 50 Y e a r s 52 5 17 6 14 7 37 8 32 8 12 8 5 07 1 13 , 25 7 Ex h i b i t N o . J. H e a l y Pa g e 8 o f 9 Un i t e d W a t e r I d a h o Ca s e U W I - W- O 4 - 4 De f e r r e d D e b i t s B a l a n c e f o r t h e T e s t Y e a r e n d e d J u l y 3 1 , 2 0 0 4 an d t h e P r o F o r m a Y e a r e n d i n g M a y 3 1 , 2 0 0 5 (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) (7 ) In t e r i m A c t i v i t y Ba l a n c e a t J u l y Ba l a n c e a t M a y Li n e N o . Ac c o u n t N u m b e r De s c r i p t i o n , 2 0 0 4 De b i t Cr e d i t , 2 0 0 5 18 6 0 0 1 De f e r r e d R a t e C a s e E x p e n s e 16 9 23 2 83 1 24 5 , 00 0 18 6 0 0 6 De f e r r e d P o w e r E x p e n s e 36 3 , 24 0 18 6 76 0 55 0 00 0 18 6 0 2 4 / 1 8 6 3 2 4 De f e r r e d R e l o c a t i o n C o s t 15 7 21 5 (2 1 39 0 ) 13 5 , 82 5 18 6 3 2 0 De f e r r e d R e n t s ( l a k e w o o d W e l l l e a s e ) 45 8 (4 6 0 ) 99 8 18 3 0 0 0 De f e r r e d T e r r a G r a n d e C o s t 30 0 40 7 70 7 18 6 6 0 1 De f e r r e d T a n k P a i n t i n g 74 2 58 0 ) 77 , 16 2 To t a l 63 5 12 4 42 0 99 8 (2 4 , 4 3 0 ) 03 1 69 2 Ex h i b i t N o . J. H e a l y Pa g e 9 o f 9 Dean J. Miller McDEVITT & MILLER LLP 420 West Bannock Street O. Box 2564-83701 Boise, ill 83702 Tel: 208.343.7500 Fax: 208.336.6912 iQe~mcdevitt-miller.com Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR WATER SERVICE IN THE ST ATE OF IDAHO Case No. UWI-O4- BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION EXHIBIT 2 TO THE DIRECT TESTIMONY OF JEREMIAH 1. HEALY Li n e No . De s c r i p t i o n Op e r a t i n g R e v e n u e s Op e r a t i n g E x p e n s e s Op e r a t i o n & M a i n t e n a n c e 10 . De p r e c i a t i o n Am o r t i z a t i o n O f P H F U Am o r t i z a t i o n O f U P A A To t a l D e p r e c i a t i o n a n d A m o r t i z a t i o n 11 . Ta x e s O t h e r T h a n I n c o m e 12 . 13 . 14 . Ad V a l o r e m Pa y r o l l T a x e s To t a l T a x e s O t h e r 15 . To t a l O p e r a t i n g E x p e n s e s Ex c l u d i n g I n c o m e T a x e s 16 . Op I n c o m e B e f o r e I n c o m e T a x e s 17 . In c o m e T a x e s 18 . 19 . St a t e I n c o m e T a x e s Fe d e r a l I n c o m e T a x e s 20 . To t a l I n c o m e T a x e s 21 . Ut i l i t y O p e r a t i n g I n c o m e 22 . Ad j u s t e d R a t e B a s e 23 . Ra t e o f R e t u r n o n R a t e B a s e UN I T E D W A T E R I D A H O ST A T E M E N T O F O P E R A T I N G I N C O M E P E R B O O K S A N D P R O F O R M A U N D E R PR E S E N T A N D P R O P O S E D R A T E S F O R T H E Y E A R E N D E D J U L Y 3 1 , 2 0 0 ~ Co l u m n Co l u m n Co l u m n Co l u m n Co l u m n Co l u m n (1 ) (2 ) (3 ) (4 ) (5 ) (6 ) Pe r Un d e r P r o p o s e d R a t e s Ad j u s t m e n t Bo o k s Te s t Y e a r Ad j u s t e d Sh o w n o n 07 / 3 1 / 0 4 Ad j u s t m e n t Te s t Y e a r Ad j u s t m e n t s Pr o f o r m a 00 0 22 2 53 4 12 5 53 4 34 7 76 7 87 0 38 , 30 2 21 7 Ex h 3 , S c h 1 47 0 , 31 9 $ 93 3 , 19 3 13 , 40 3 ; 5 1 2 11 7 13 , 44 7 62 9 Ex h 3 , S c h 2 73 8 , 84 8 64 7 66 1 38 6 , 50 9 38 6 , 50 9 Ex h 3 , S c h 2 11 3 (5 1 11 3 ) Ex h 3 , S c h 2 39 7 93 2 32 9 32 9 79 7 35 8 59 8 48 0 39 5 83 8 39 5 83 8 Ex h 3 , S c h 3 Ex h 3 , S c h 3 52 8 , 69 6 32 1 99 4 85 0 69 0 24 5 30 , 27 7 72 , 52 2 57 0 94 1 35 2 27 1 92 3 , 21 2 57 0 , 94 1 35 0 69 3 92 1 63 4 18 . 11 8 . 36 7 $ 3 . 60 4 . 19 5 $ 2 1 . 72 2 . 56 2 $ 4 4 . 11 7 $ 2 1 . 76 6 . 67 9 12 . 88 1 . 85 5 $ ( 3 ~ 70 . 07 0 ) 81 1 . 78 5 72 3 . 75 3 16 . 53 5 . 53 8 Ex h 3 , S c h 4 44 6 , 4 1 8 $ (6 8 0 42 7 ) $ (2 3 4 00 9 ) $ 53 7 90 0 $ 30 3 , 89 1 Ex h 3 , S c h 4 00 5 94 2 $ 45 3 , 4 6 7 ) $ 55 2 , 4 7 5 $ 16 5 04 8 $ 71 7 52 3 45 2 36 0 $ 13 3 , 89 4 ) $ 31 8 46 6 $ 70 2 , 94 8 $ 02 1 41 4 42 9 . 49 5 $ (9 3 6 . 17 6 \ $ 49 3 19 $ . 02 0 . 80 5 $ 12 . 5 1 4 . . 1 2 4 -- - . J 40 . 06 2 . 54 6 14 0 . 06 2 . 54 6 Ul l i Ex h i b i t N o . J. H e a l y Dean J. Miller McDEVITT & MILLER LLP 420 West Bannock Street O. Box 2564-83701 Boise, ill 83702 Tel: 208.343.7500 Fax: 208.336.6912 iQe~mcdevi tt -miller .com Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR WATER SERVICE IN THE STATE OF IDAHO Case No. UWI-O4- BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION EXHIBIT 3 TO THE DIRECT TESTIMONY OF JEREMIAH J. HEALY UNITED WATER IDAHO Details of Adjustments to Operating Expenses At Present Rates Summary July 31, 2004 Test Year Adjustment Income Statement Account Actual Twelve Months Pro Forma Expense at Line No.No.Description Reference Ended July 31 2004 Adjustments May 31,2005 (1)(2)(3)(4)(5)(6) Summary Adjusted O&M: Payroll to O&M Cost Types 1 & 2 155,584 232,555 388,139 Thrift Plan 926-700 90,156 321 91,477 Health Care 926-500/610/640 523,193 148,368 671,561 Pension 926-000 624,767 279 637 046 PEBOP 926-105/106/110 614,847 (145 345)469,502 Payroll Overheads 922-000 (859,795)(52,956)(912,751) Deferred Early Retirement Cost Amortization 926.590 (portion)152,208 105 526 257,734 Deferred Enhanced Severance Program Amortization 926-590 (portion)49,751 49,751 Purchased Water 602-000 107,788 528 195,316 Tank Painting Amortization-Old 672000 096 091 187 Power 623-000 242,538 514 265 756,803 Amortization of Deferred Power 623-000 516 667 516,667 Chemicals 641-000 235,950 78,224 314,174 Water Qualty Testing (Outside Lab Only)642-000 78,348 662 86,010Columbia Water Treatment Plant Misc Opex- Telephone, Water Quality Testing,Natural Gas other Utilities Security Alarm Monitoring,Sanitation Various 210 57,210 Variable Cost Savings Due to CWTP Operations Various (139,580)(139,580) Transportation Expense Cost Types 40 & 96 362 613 43,652 406,265 Customer Postage 903-020 170,280 061 178,341 Outside Computer 903-030 384,481 14,416 398,897 Outside Collection 903-040 99,590 (20,125)79,465 Customer Records & Collection Expense/Miscellaneous Customer Accounting Expenses 903-050/905000 18,009 (10 879)130 Uncollectibles 904-000 162,706 (31 661)131 045 IPUC Annual Assessment 928-000 72,347 3,476 75,823 Rate Case Expense Amortization 928-130 667 81,667 Relocation Expense Amortzation 930-310 25,688 1,477 27,165 Business Insurance 924-000/090 & 925-000/010 789,765 293,535 083,300 Adjust Dues, Eliminate Lobbying & Charitable Give 921110,921300,930300 005 (14 005) Information Technology 923-140 & 921-400 105,094 046 156,140 Enhanced Severance Program 930-250 995 995) Expenses Related to Customer Growth Various 022 73,022 Expenses Related to Weather Normalization Various (8,792)(8,792) Outside Services Legal 923-080 82,851 (28,851)54,000 Amortization of Deferred Terra Grande Expenses 923-080 569 569 Removal of Carriage Hill Operating Expense 623-000 (986)(986) Total Adjusted O&M 259,104 933,193 10,192,297 Unadjusted O&M: M & S Fees 923-010 006,757 006,757 Other Operation and Maintenance Expense Various 204458 204,458 Total Unadjusted O&M 211,215 211 215 Total Operation and Maintenance Adjustments 11470.319 933.193 13.403.512 Depreciation 403-000 738,848 647 661 386,509 Amortization of Plant Held for Future Use 405-000 51,113 (51 113) Amortization of Utility Plant Acquisition Adjustments 406-000 397 931 328 Total Depreciation and Amortization 797.358 598.479 395.837 Ad Valorem Taxes 408-120 528,696 245 570,941 Payroll Taxes 408-130/131/134 321 994 30,277 352,271 Total Taxes Other 850.690 72522 1 923212 Total Operating Expenses 18,118,367 604 194 722 561 Exhibit No. Summary J. Healy Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Description Adjustment of Payroll Chargeable to Operations and Maintenance To adjust labor chargeable to operation and maintenance expense based upon pay rates at April 1 2005 and proposed employee head count . Use test year derived 0 & M percentage Details Administrative,Engineering, Accounting,lnside Customer Service Production Department Employees Transmission & Distribution Employees Outside Customer Service Employees Total Regular Employees 10. 11. 12. 13. 14. Temporary Employees Stand By Pay Management Incentive Pay Non-Union Incentive Pay Union Incentive Pay Union Lump Sum Payments ABCD Awards 15.Pro Forma Payroll ~ 2005 Rates 16.Test Year Derived O&M Percentage 17.Pro Forma Expense 18.Test Year Expense 19.Adjustment 34 $ $ 52 837 28,023 775 287 14,400 300 000 Exhibit No. Healy Schedule 1 Page 1 of 598 773 987 251 296,471 408 911 247 622 539,028 74.6446% 388,139 155,584 232 555 Amount 232 555 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Description Normalize Company 401 (k) Matching Percentage To normalize Company contribution to 401 (k) savings plan based upon historical participation rates and proposed headcount. Details Pro Forma Company Match Test Year Expense Adjustment 91 ,477 90,156 321 Exhibit No. Healy Schedule 1 Page 2 of 34 Amount 321 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Description Adjustment of Employee Health Care Expense, Long Term Disability and Group Term Life Insurance To adjust health care, L TD and GTL expense to current costs level and proposed headcount. Details Gross HMO Blue Expense Gross United Health Care Choice Plus Plans Gross Dental & Vision Coverage Group Term Life Insurance Coverage Lond Term Disability Coverage Employee Incentive Opt Out Payment Total Coverage Cost 10.Less: Employee Contributions 11.Pro Forma Health Care, L TD and GTL Expense 12.Test Year Expense 13.Adjustment 553,941 175,229 76,905 100 21,700 4,400 849,275 177 714 671 561 523 193 148,368 Exhibit No. Healy Schedule 1 Page 3 of 34 Amount 148,368 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Line No.Description Adjustment of Pension Expense To adjust Employee Pension Expense to the curren1 level per latest actuarial data in accord with FAS 87 Details Idaho Bargaining Unit 303,084 Idaho Non-Bargaining Unit 333,962 Total Pro Forma Expense 637,046 Test Year Expense 624 767 Adjustment 12,279 Exhibit No. Healy Schedule 1 Page 4 of 34 Amount 279 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Line No.Description Adjustment of FAS 106 Post Retirement Cost To adjust Post Retirement Cost to the current level in per latest actuarial data in accord with FAS 106 Details Idaho Bargaining Unit 118 354 Idaho Non-Bargaining Unit 258,4 70 AnnuallTO Amortization Expense 078 PEPOB Amortization 40,600 Total Pro Forma Expense 469,502 Test Year Expense 614 847 Adjustment (145,345t Exhibit No. Healy Schedule 1 Page 5 of 34 Amount (145,345) UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Line No.Description Adjust Payroll Overheads Charged to Construction and other non Operations & Maintenance Accounts To normalize payroll overhead percentage charged to non-O&M labor based on pro forma labor and benefits Details Pro forma Payroll at April 1 ,2005 Rates Sch 1 , p. 539 028 % Chargeable to Other than O&M 25.3554% Payroll Other Than O&M 150,889 Overhead Rate Line 21 79.31% Overheads Credit (912 751) Test Year Expense - Acct 922-000 (859 795) Adjustment (52.956\ Payroll Related Expenses 10.FICA Taxes Sch 3,341 ,345 11.Federal Unemployment Taxes Sch 3,p.4 5,496 12.State Unemployment Taxes Sch 3,5,430 13.Group Health, Life & L Sch 1.671 561 14.Workers Comp Sch 1.164 900 15.Pension & PEBOP Sch 1.p.4, 5 106,548 16.Tuition Aid 2005 OP 700 17.Thrift Plan Expenses Sch 1.91,477 18.Payroll Related Expenses 395.457 19.Payroll Overheads %63.03% 20.Additive for Non-Work Days 16 28% 21.Overhead Rate to be Applied to non O&M Payroll 79.31% Note: Payroll OH % = Total Benefits! ( Gross Payroll-(Gross Payroll*Non Work Day Additive 63.03% Exhibit No. Healy Schedule 1 Page 6 of 34 Amount (52,956) UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Line No.Description Adjustment for Amortization of Deferred Early Retirement Program To reflect an adjustment to the test year level of amortzation of deferred early retirement cost previously approved by the IPUC in Case UWI-00- Details Deferred Pension Cost attributable to ERP 721 330 Deferred PEBOP Cost attributable to ERP 529,287 Remaining Balance from Prior Case 38,052 Total Deferred ERP Cost 288,669 Amortization Period 60 Months Pro Forma Expense 257,734 Test Year Expense 152,208 10.Adjustment 105,526 Exhibit No. Healy Schedule 1 Page 7 of 34 Amount 105,526 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Line No.Description Adjustment for Amortization of Deferred Enhanced Severance Package Expense Adjustment for amortization of deferred cost associated with the Enhanced Severance Package Program Details Deferred ESP Cost 2002 Deferred ESP Cost 2003 Total Deferred ESP Cost Amortization Period Pro Forma Expense Test Year Expense Adjustment 176,699 054 248,753 60 Months 751 49,751 Exhibit No. Healy Schedule 1 Page 8 of 34 Amount 49,751 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Adjustment of Purchased Water Cost Adjust purchased water expense for rented and leased natural flow rights,shares in canal companys and contracts/leases for storage water Details Natural Flow associated expenses Shares in Canal Companys, maintenance Contracts & Leases for storage water Other Miscellaneous Pro Forma Purchased Water Test Year Expense Adjustment 744 980 147 592 000 195,316 107 788 528 Exhibit No. Healy Schedule 1 Page 9 of 34 Amount 87,528 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 10 line No. Adjustment of Deferred Tank Painting Expense To adjust the test year level of amortization expense for deferred tank painting due to additional deferred paintings Details Deferred Gowen Tank Painting 39,808 Deferred Aeronica Well Tank Painting 100 Total Deferred Expense 60,908 Amortization Period 10 Years New Annual Amortization Expense 091 Continuing Amortizations from Prior Case 096 Pro Forma Purchased Water 187 10.Test Year Expense 096 11.Adjustment 091 Amount 091 Exhibit No. Healy Schedule 1 Page 10 of 34 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Description Adjustment of Purchased Power Expense To adjust purchased power expense based on test year usage priced at Idaho Power rates effective July 28 and December 1 , 2004; also reflect for CWTP and RWPS Details Schedule 7 with and without franchise fee Schedule 9 with and without franchise fee Marden WTP repriced from 9P to 19 CWTP and RWPS projected consuptive power use CWTP Redundant Power and Stand By Charge Pro Forma Power Expense 10.Test Year Expense 11.Adjustment 17,820 279,503 175,081 236,400 48,000 756,803 242 538 514,265 Exhibit No. Healy Schedule 1 Page 11 of 34 Amount 514 265 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 12 Description Reflect Amortization of Deferred Power Expense To reflect the amortization of deferred power expense as established by IPUC Order No 28505 in Case UWI-00- Details Projected Balance in Deferred Power as of May 31 2005 Amortization Period Pro Forma Annual Amortization Expense Test Year Expense Adjustment 550 000 3 Years 516,667 516,667 Exhibit No. Healy Schedule 1 Page 12 of 34 Amount 516 667 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 13 Description Adjust Chemical Expense To normalize chemical expense using test year usage at current prices; adjust for CWTP chemical usage; normalize phosphate Details Normalize test year expense at current prices Normalize phosphate usage CWTP chemical usage Pro Forma Annual Expense Test Year Expense Adjustment 242,029 15,000 57,145 314,174 235,950 78,224 Exhibit No. Healy Schedule 1 Page 13 of 34 Amount 78,224 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 14 Description Water Quality Testing Expense To adjust test year level of outside laboratory expense to comply with current testing cycle Details 3a. 3b. 3c. 3d. 3e. 3f. 3g. 3h. 3i. 3j. 3k. 31. Wells planned to adjust operations: Inorganic Cehicals Volitile Organic Chemicals Synthetic Organic Chemicals Nitrates Nitrites Fe/Mn Arsenic Radionuclides Disinfection By-Products Coliform T2ESWTR miscellaneous test 300 643 29,931 300 100 000 300 000 076 13,860 000 500 Total Pro Forma Outside Lab Testing Test Year Expense Adjustment 010 78,348 662 Exhibit No. Healy Schedule 1 Page 14 of 34 Amount 662 UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 15 Line No.Description Adjust CWTP Related Other Operating Expenses Adjust test year expense for additional minor operating expense associated with CWTP operations Details Communications infrastructure: CWTP T-1; MWTP T-1 upgrade,030 PRV communications upgrades to improve system flexibility Water quality testing, natuarl gas, bldg. elec light, janitorial 25,180 Pro Forma Annual Expense 210 Test Year Expense Adjustment 210 Exhibit No. Healy Schedule 1 Page 15 of 34 Amount 210 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 16 Description Adjust Test Year Power & Chemicals for CWTP Impact on Other Facilities To adjusttest year level of power and chemical expense for nine well facilities that will modify operations with CWTP operations Details 3a. 3b. 3c. 3d. 3e. 3f. 3g. 3h. 3i. Wells planned to adjust operations: Raptor Ten Mile Pioneer Pleasant Valley Market T erteling JR Flat Centennial Bergeson Total Power & Chemical Pro Forma Expense Reductions Test Year Expense Adjustment 139,580 (139,580) Exhibit No. Healy Schedule 1 Page 16 of 34 Amount (139,580) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 17 Description Adjust Transportation Expense To adjust transportation expense including lease, fuel maintenance, labor and overheads insurance & lease disposal proceeds at current projections and known & measurable changes Details Lease Cost Fuel Maintenance materials, outside service Mechanic payroll and benefits Insurance Lease disposal proceeds Pro Forma Annual Expense 10.Test Year O&M ratio 68.89% 11.Test Year Expense 12.Adjustment 299,719 130,200 000 879 56,400 (31,442) 589,756 406,265 362 613 43,652 Exhibit No. Healy Schedule 1 Page 17 of 34 Amount 43,652 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 18 Description Adjust Customer Postage Expense To adjust customer postage expense to May 31 2005 customer level and current postal rates Details Annual bills based on May 31 2005 customer count 461,442 Average test year postage cost per bill 3059 Pro Forma bill postage expense 141 136 Local postage machine for locally mailed customer 205 notices, correspondence, etc Pro Forma Annual Expense 178,341 Test Year Expense 170 280 Adjustment 061 Exhibit No. Healy Schedule 1 Page 18 of 34 Amount 061 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 19 Description Adjust Customer Information System (billing) Expense To adjust customer billing expense to May 31 2005 customer level Details 475 995 7200 342 716 635 6000 181 000 Annual bills produced Cost per bill Pro Forma customer billing expense Annual past due notices produced Cost per notice Pro Forma past due notice expense Misc programming charges based on test year level 10.Pro Forma Annual Expense 398,897 11.Test Year Expense 384,481 12.Adjustment 416 Exhibit No. Healy Schedule 1 Page 19 of 34 Amount 416 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 20 Description Adjust Customer Outside Collection Expense To adjust expense of collecting and processing customer payments: paid at local office, through lockbox and ACH Details Annual bills produced Lockbox transactions at test year level of 72.73% Lockbox transactions Price per unit based on test year Pro Forma lockbox expense 10. ACH transactions Price per unit based on test year Pro Forma ACH expense 11.US Bank local processing charges 12.Federal Express Charges 13.Normalizing adjustment for lower lockbox price per unit 14.Pro Forma Annual Expense 15.Test Year Expense 16.Adjustment 475,995 72.73% 346,191 2344 81,147 18,658 3472 6,478 20,364 1,476 (30,000) 79,465 99,590 (20,125) Exhibit No. Healy Schedule 1 Page 20 of 34 Amount (20,125) UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. Line No.Description Adjust Customer Records and Collection Expense and Miscellaneous Customer Accounting Expenses Adjust test year expense level of accounts 903-050 & 905-000 Details 903-050: test year level 524 Normalize contract temporary employee and minor adjustments (14 570) 903-050: pro forma level 954 905-000: test year level 485 Normalize for annual customer notice bill stutter & misc 691 905-000: pro forma level 176 Pro Forma Annual Expense 130 10.Test Year Expense 18,009 11.Adjustment (10,879) Exhibit No. Healy Schedule 1 Page 21 of 34 Amount (10,879) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 22 Description Adjust Uncollectible Accounts Expense To normalize uncollectible accounts expense based on a four year average Details Year Uncollectibles Revenue Jul-162 706 000,222 Jul-124 359 884 881 Jul-105 384 30,406,924 Jul-106 277 694 018 Sub Total 498,726 $ 119,986,045 0.41565% Pro Forma Revenue at Existing Rates Pro Forma Annual Expense Test Year Expense Adjustment 527 396 131 045 162,706 (31,661) Exhibit No. Healy Schedule 1 Page 22 of 34 Amount (31,661 ) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 23 Description Adjust IPUG Annual Assessment To adjust test year level of IPUG annual assessment based on latest assessment rate and pro forma adjusted revenue Details Total revenue subject to adjustment IPUG assessment rate Pro Forma IPUC Assessment Test Year Expense Adjustment 31,527 396 240500% 75,823 72,347 476 Exhibit No. Healy Schedule 1 Page 23 of 34 Amount 3,476 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 24 Description Adjust Rate Case Expense Amortization To amortize over three years the project level of deferred rate case expense Details Estimated deferred rate case expense Amortization Period Pro Forma Rate Case Expense Amortzation Test Year Expense Adjustment 245,000 Three Years 81,667 667 Exhibit No. Healy Schedule 1 Page 24 of 34 Amount 667 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 25 Description Adjust Employee Relocation Expense Amortization To amortize over five years deferred employee relocation expense Details Unamortized balance of deferred relocation at 31-May- Additional relocation expense incurred Total Deferred Employee Relocation Expense Amortization Period Pro Forma Relocation Expense Amortzation Test Year Expense Adjustment 732. 130,093 135 825 Five Years 165 25,688 477 Exhibit No. Healy Schedule 1 Page 25 of 34 Amount 1,477 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 27 Description Elimination of Dues, Charitable Contributions, Memberships, etc To eliminate from the test year certain expenses that do not qualify for rate making treatment under past IPUC Orders Details Charitable contributions NAWC Dues- Lobbying portion Idaho Association of Commerce & Industry Dues- Lobbying portion Country Club Dues Adjustment (5,510) (3,600) (780) 115) (14,005) Exhibit No. Healy Schedule 1 Page 27 of 34 Amount (14,005) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 28 Description Adjust Corporate and Local IT Maintenance & Support To adjust test year expense for services related to upkeep and support of communication infrastructure, networks, desktop software support, hydraulic model support, Intellution & Oracle support, SCADA support, etc. Details 108,340 800 Pro Forma Level of Corporate IT support, maintenance Pro Forma Level of Local IT support, maintenance 156,140Pro Forma Annual Expense 105,094Test Year Expense 046Adjustment Exhibit No. Healy Schedule 1 Page 28 of 34 Amount 51,046 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 29 Description Adjust Test Year Miscode To normalize Company books and records for an accounting entry that occurred during the test year and will not recur Details Eliminate charge to account 930-250 that was expensed in the test year and will not recur Adjustment 995) 995) Exhibit No. Healy Schedule 1 Page 29 of 34 Amount 995) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 30 Description Expenses Related to Customer Growth To normalize operating expenses related to customers added to the system during the test year and during the pro forma period July 31 , 2004 to May 31 2005 Details Purchased Power 242 538 235 950 362 613 789,765 388 083 018,949 Chemicals Transportation Cost General Insurance T&O Excluding Payroll Total Variable Cost 10. 11. 018 949 000,222 = Total Variable Cost Test Year Revenue Variable Cost Percentage 12.Customer Growth Revenue per Witness Gradilone 749 828 13.Operating Ratio Adjustment 73,022 Exhibit No. Healy Schedule 1 Page 30 of 34 Amount 022 74% Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 31 Description Expenses Related to Weather Normalization To normalize variable cost power and chemicals due to the negative weather normalization adjustment made by Witness Gradilone Details Purchased Power Chemicals Total Variable Cost related to weather Total Variable Cost Test Year Revenue Revenue adjustment due to weather normalization Variable Cost % 10.Operating Ratio Adjustment 242 538 235,950 1.478.488 1,478,488 000 222 77% (184 354) 77% 18.792\ Exhibit No. Healy Schedule 1 Page 31 of 34 Amount 792) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 32 Description Adjust Outside Services Legal To normalize outside legal expense to recognize the cessation of an amortization allowance that terminated in the test year Details Normalized Pro Forma Annual Expense Test Year Expense Adjustment 54,000 82,851 (28,851 ) Exhibit No. Healy Schedule 1 Page 32 of 34 Amount (28,851 ) Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 33 Description Adjust Pro Forma Expense for Amortization of Deferred Terra Grande Related Expenses To adjust outside legal expense to recognize the amortization of deferred legal expense incurred by Company in pursuit of Terra Grande solution Details Total Expenses Incurred by Company Amortization Period Normalized Pro Forma Annual Expense Test Year Expense Adjustment 707 Three Years 569 569 Exhibit No. Healy Schedule 1 Page 33 of 34 Amount 569 Line No. UNITED WATER IDAHO Details of Adjustments to Operations and Maintenance Expense At Present Rates Adjustment No. 34 Description Adjust Operating Expense to Reflect Sale of Carriage Hill System To normalize operating expense (power) due to the sale of the Carriage Hill System Details Test year power cost incurred by Company Normalized Pro Forma Annual Expense Adjustment 986 Exhibit No. Healy Schedule 1 Page 34 of 34 Amount (986) Line No. UNITED WATER IDAHO Details of Adjustment to Depreciation Expense At Present Rates Adjustment No. 37 Description Adjust Depreciation Expense To adjust the test year level of depreciation expese to the proforma level based on plant in service, CIAC and advances Details Pro Forma Depreciation Expense per page 2 of 4 Test Year Expense Adjustment 386,509 738,848 647.661 Amount 647.661 Exhibit No. J. Healy Schedule 2 Page 1 of 4 UNITED WATER IDAHO Pro Forma Annual Depreciation Provision Test Year Ended July 31 , 2004 with Capital Additions and Retirements through May 31, 2005 Adjustment No. 37 Detail Pro Forma Pro Forma Plant Utility Contributions Pro Forma Net Line Account Plant In Aid Advances Depreciable Depreciation Annual No.Account Descri tion No.05/31/2005 05/31/2005 05/31/2005 Plant Rate reciation NON DEPRECIABLE PLANT: Organization 301-107,048 (6,986) $100 062 0% $ land & land Rights, Water Rights - Source of Supply 303-369,037 (325,405) $(294 807) $748,825 0% $ land & land Rights - Water Treatment 303-889,034 889 034 0% $ land & land Rights - Trans. & Distrib.303-411 626 (42 978) $368,648 0% $ land & land Rights - General Plant 303-213,383 213,383 0% $ TOTAL NON DEPRECIABLE PLANT 990,128 (325,405) $(344 771) $319,952 DEPRECIABLE PLANT: Structures and Improvements - Source of Supply 304-960,489 (263,428) $(80,686) $616 375 00% $328 10.Structures and Improvements - Water Treatment 304-13,464 912 13,464,912 00% $269 298 11.Structures and Improvements - Trans. & Distrib.304-963 40,963 00% $819 12.Structures and Improvements - General Plant 304-275,346 275 346 50% $884 13.Collecting & Impounding Reservoirs - Source of Supply 305-83,217 (21 950) $61,267 00% $225 14.lake, River & Other Intakes 306-272 275 (68 216) $204 059 00% $081 15.Wells & Springs 307-294 633 (1,397 310) $(425,949) $7,471 374 86% $213,681 16.Infiltration Galleries & Tunnels 308-652 34,652 00% $693 17.Supply Mains 309-213 667 391) $(364,295) $839,981 00% $36,800 18.Power Generation Equipment 310-474,533 474,533 00% $23,727 19.Power Electric Pumping Equipment - Source of Supply 311-792,060 814 218) $(498,989) $9,478,853 00% $473,943 20.Power Diesel Pumping Equipment - Source of Supply 311-00% $ 21.Power Pumping Equipment - Water Treatment 311-543,625 543,625 00% $277 181 22.Power Pumping Equipment - Trans. & Distrib.311-40 955,968 (129,574) $826 394 00% $320 23.Water Treatment Equipment 320-315,119 (36,860) $(3,384) $274,875 00% $113 744 24.Water Treatment Equipment - Membranes 320-500 000 500 000 14.00% $70,000 25.Distribution Reservoirs & Standpipes 330-40 075,495 163,794) $(854 814) $056,887 00% $141 138 26.Trans. & Distrib. Mains & Accessories - Intangible 331-145 145 00% $ 27.Trans. & Distrib. Mains & Accessories SOS 331-144 144 00% $ 28.Trans. & Distrib. Mains & Accessories 331-40 103,316,397 (40 115 756) $021 136) $60,179 505 00% $203,590 29.Services 333-40 339,274 (6,253,083) $(563,650) $522,541 50% $763,064 30.Meters and Meter Installations 334-555,621 (191 517) $11,364 104 50% $284 103 31.Hydrants 335-40 067 642 (563,006) $(6,986) $497,650 50% $12,441 32.Backflow Prevention Devices 336-40 00% $ 33.Other Plant & Misc. Equipment - Intangible 339-00% $ 34.Other Plant & Misc. Equipment - Source of Supply 339-794 45,794 00% $916 35.Other Plant & Misc. Equipment - Water Treatment 339-43,525 43,525 00% $871 36.Other Plant & Misc. Equipment - Trans. & Distrib.339-40 88,441 88,441 00% $769 37.Other Plant & Misc. Equipment - General Plant 339-798 15,798 00% $316 38.Office Furniture and Equipment 340-697,445 131) $696,314 67% $46,444 39.AM FM System - Mapping 340-552 910 552 910 10.00% $55,291 40.Computer Hardware & Software 340-792,778 792 778 20.00% $358,556 41.IFMS WAN PeopleSoft 340-067,484 067,484 10.00% $406,748 42.Customer Information System 340-795 069 795 069 10.00% $179,507 43.Transportation Equipment 341-136,111 136,111 11.49% $639 44.Stores Equipment 342-24,448 24,448 67% $631 45.Tools, Shop and Garage Equipment 343-463,945 463,945 67% $30,945 46.Confined Space Monitor, Generator, Trench Shield 343-62,533 533 14.50% $067 47.laboratory Equipment 344-116,643 (16,729)99,914 67% $664 48.Power Operated Equipment 345-817 58,817 00% $ 49.Power Operated Equipment 345-69,272 69,272 14.50% $044 50.Communications Equipment 346-298,982 (71 123) $227,859 67% $898 51.Miscellaneous Equipment 347-107 621 107 621 67% $178 52.Other Tangible Property 348-00% $ 53.Master Plan 348-635 998 635 998 10.00% $63,600 54.Rounding 55. TOTAL DEPRECIABLE PLANT 250,649,791 51,916,389)020,586)192,712 816 402 149 56.TOTAL UTILITY PLANT IN SERVICE 258 639 919 241 16.00. 57.Less: Depreciation Included on Transportation Schedule (15,639) 58.Pro Forma Depreciation Expense 386,509 Exhibit No. J. Healy Schedule 2 Page 2 of 4 Line No. UNITED WATER IDAHO Details of Adjustment to Depreciation Expense At Present Rates Adjustment No. Description Adjust Amortization of Plant Held for Future Use To adjust the test year level of PHFU amortization to the proforma level based on the transfer of expenditures related to the CWTP raw water pump station to plant in service Details Pro Forma Plant Held for Future Use Amortization Test Year Expense Adjustment 113 (51.113\ Amou nt (51.13\ Exhibit No. J. Healy Schedule 2 Page 3 of 4 UNITED WATER IDAHO Details of Adjustment to Amortization of Utility Plant Acquisition Adjustment At Present Rates Adjustment No. 39 Line No.DescriDtion Amortization of Utility Plant Acquisition Adjustment To adjust pro forma UPAA amortization to normalize a test year adjustment Accumulated Gross Original Amortization Balance Annual UPAA Through July 31 UPAA at July Amort Amortization Balance 2004 31, 2004 Period Expense Raintree Mutual Water (227 594)22,353 (205 241)40 Years (5.690) South County Allowed 009 011 (140.844)868,167 40 Years 25,225 Barber Water Company 46,966 (5,382)41,584 40 Years 174 Warm Springs Mesa 302 (24 660)642 20 Years 115 Redwood Creek (110,249)51,450 (58,799)20 Years 512) Island Woods (179 675)099 (96,576)20 Years (8,984) Total 600,761 (13,984) $586,777 328 12.Total Pro Forma UPAA Amortization Expense 13.Test Year Expense 14.Adjustment Amount 328 397 931 Exhibit No. J. Healy Schedule 2 Page 4 of 4 Li n e No . UN I T E D W A T E R I D A H O Ca l c u l a t i o n o f R e a l a n d P e r s o n a l Pr o p e r t y T a x e s Ju l y 3 1 , 2 0 0 4 Ad j u s t m e n t N o . De s c r i p t i o n Ad j u s t P r o p e r t y T a x E x p e n s e To a d j u s t t h e a m o u n t o f P r o p e r t y T a x e x p e n s e ba s e d 6 - ye a r a v e r a g e i n c r e a s e a p p l i e d t o t a x e x p e n s e De t a i l s Es t i m a t e d P r o p e r t y T a x B i l l f o r 2 0 0 4 f o r u t i l i t y p r o p e r t y i n A d a & C a n y o n C o u n t y Av e r a g e a n n u a l e x p e n s e i n c r e a s e o v e r p a s t s i x y e a r s e x p e r i e n c e Es t i m a t e d 2 0 0 5 P r o p e r t y T a x E x p e n s e Te s t Y e a r E x p e n s e Pr o F o r m a L e v e l o f P r o p e r t y T a x E x p e n s e 50 4 , 4 4 5 4. 4 2 % 57 0 , 94 1 52 8 , 69 6 42 , 24 5 Am o u n t 24 5 Ex h i b i t N o . J. H e a l y Sc h e d u l e 3 Pa g e 1 o f 4 UN I T E D W A T E R I D A H O De t a i l s o f A d j u s t m e n t s t o Pa y r o l l T a x e s At P r e s e n t R a t e s Ad j u s t m e n t N o . Li n e No . De s c r i o t i o n To a d j u s t E m p l o y e r F I C A T a x L i a b i l i t y De t a i l s FI C A B a s e f o r 2 0 0 5 FI C A Me d i c a r e Am o u n t Am o u n t Co m b i n e d 00 0 No L i m i t 20 % 1 . 4 5 % 53 9 , 02 8 53 9 , 02 8 95 , 01 2 44 4 , 01 6 53 9 , 02 8 20 % 1. 4 5 % 27 5 , 52 9 65 , 81 6 34 1 , 34 5 31 1 92 0 29 . 42 5 FI C A R a t e f o r 2 0 0 5 Pr o F o r m a P a y r o l l a t 2 0 0 5 R a t e s Wa g e s i n E x c e s s o f F I C A b a s e Ta x a b l e W a g e s FI C A T a x R a t e s Pr o F o r m a F I C A T a x Te s t Y e a r E x p e n s e 10 . Ad j u s t m e n t Am o u n t 29 , 4 2 5 Ex h i b i t N o . J. H e a l y Sc h e d u l e 3 Pa g e 2 o f 4 Li n e No . UN I T E D W A T E R I D A H O De t a i l s o f A d j u s t m e n t s t o Pa y r o l l T a x e s At P r e s e n t R a t e s Ad j u s t m e n t N o . De s c r i p t i o n To a d j u s t S t a t e U n e m p l o y m e n t I n s u r a n c e T a x De t a i l s Id a h o T a x a b l e B a s e Id a h o U C T a x R a t e Em p l o y e e s c o v e r e d b y U . C. T a x (9 1 (Q ) $ 2 9 50 0 l e s s u n d e r l i m i t w a g e s $ 2 2 , 17 7 pl u s t e m p s $ 5 2 83 7 ) Ta x a b l e B a s e Ta x a b l e W a g e s T a x R a t e Pr o F o r m a I d a h o U n e m p l o y m e n t T a x Te s t Y e a r E x p e n s e 10 . Ad j u s t m e n t 50 0 20 % $ 2 71 5 , 16 0 $ 2 71 5 , 16 0 20 % 43 0 96 1 46 9 Am o u n t 46 9 Ex h i b i t N o . J. H e a l y Sc h e d u l e 3 Pa g e 3 o f 4 UN I T E D W A T E R I D A H O De t a i l s o f A d j u s t m e n t s t o Pa y r o l l T a x e s At P r e s e n t R a t e s Ad j u s t m e n t N o . 4 3 Li n e No . De s c r i p t i o n To a d j u s t F e d e r a l U n e m p l o y m e n t I n s u r a n c e T a x De t a i l s Fe d e r a l T a x a b l e B a s e 00 0 Fe d e r a l T a x R a t e 80 % Em p l o y e e s c o v e r e d b y F e d e r a l U n e m p l o y m e n t T a x (9 1 ~ $ 7 00 0 p l u s t e m p s $ 5 0 06 1 ) Ta x a b l e B a s e 68 7 06 1 Ta x a b l e W a g e s 68 7 06 1 Ta x R a t e 80 % Pr o F o r m a F e d e r a l U n e m p l o y m e n t T a x 49 6 Te s t Y e a r E x p e n s e 11 3 10 . Ad j u s t m e n t 38 3 Am o u n t 38 3 Ex h i b i t N o . J. H e a l y Sc h e d u l e 3 Pa g e 4 o f 4 Dean J. Miller McDEVITT & MILLER LLP 420 West Bannock Street O. Box 2564-83701 Boise, ill 83702 Tel: 208.343.7500 Fax: 208.336.6912 oe~mcdevitt-miller .com Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR WATER SERVICE IN THE STATE OF IDAHO Case No. UWI-O4- BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION EXHIBIT 4 TO THE DIRECT TESTIMONY OF JEREMIAH J. HEALY UNITED WATER IDAHO Computation of State and Federal Income Taxes At Present and Proposed Rates Line No. OPERATING INCOME BEFORE INCOME TAXES LESS: TAX DEDUCTIONS Interest Expense (A) Excess Tax Over Book Depreciation (B) TOTAL TAX DEDUCTIONS Taxable Income-State State Income Tax at 8% Federal Taxable Income (L.1-L.7) Federal Income Tax at 35% 10.Less: Amortization of ITC 11.NET FEDERAL INCOME TAX EXPENSE 12.(A) CALCULATION OF INTEREST EXPENSE DEDUCTION: 13.Pro Forma Rate Base 14.Debt Percentage of Capitalization 15.Debt Portion of Rate Base 16.Debt Rate 17.INTEREST EXPENSE 18.(B) EXCESS TAX OVER BOOK DEPRECIATION: 19.Pro Forma Tax Depreciation 20.Pro Forma Book Depreciation 21.EXCESS TAX OVER BOOK DEPRECIATION (B) EXISTING RATES (1 ) $ 9 811 785 $ 5,475,409 $ 7,261,492 $ 12.736.901 $ (2 925,116) (234 009) $ 4.570.385 $ 1,599,635 (47 160) $ 1.552.475 PROPOSED RATES (2) $ 16 535 538 5,475,409 261,492 $ 12.736.901 798,637 303,891 $ 10.756.238 764 683 160 717.523 $ 140 062,546 55.060% 77.118.438 10% 5.475.409 $ 13,648,001 386,509 261.492 Exhibit No. J. Healy Schedule 4 Page 1 of 1 UNITED WATER IDAHO Balance Sheet Per Books July 31, 2004 Line No. ASSETS Utility Plant Water Plant in Service Retirement Work in Progress Less: Accumulated Depreciation and Amortization Construction Work in Progress Plant Held for Future Use Total Utility Plant $ 227,483,399 296 (55,273 835) 506,811 555,658 $ 188,280,329 586,777 250 53,329 54,579 (352 564) 661 909 218,121 185,238 (25 800) (232 835) 266,212 111 610) 608,671 Utility Plant Acquisition Adjustment 10. 11. 12. 13. Other Property and Investments Investment in Associated Companies Other Investments Non-Utility Property Total Other Property and Investments 14. 15. 16. 17. 18. 19. 20. 21. 22. 23. Current and Accrued Assets Cash Net Accounts Receivable Customers Unbilled Utility Revenue Other Accounts Receivable Reserve for Uncollectibles Intercompany Accounts Receivable Materials & Supplies Prepaid Expenses Total Current and Accrued Assets 24.Deferred Debits 25. 26. 27. 28. 29. 30. 31. 32. 33. 34. 35. 36. 37. Preliminary Survey and Investigation Expenses Deferred Rate Case Expenses Deferred Power Expense Deferred Legal Expenses Deferred Relocation Expenses Deferred Rents Deferred Tank Painting Deferred Merchandising and Jobbing Cost Deferred ERP & ESP Deferred Post Retirement Benefits Deferred Regulatory Assets Clearing Accounts Total Deferred Debits 300 169 363,240 15,269 157 215 19,458 742 148,003 664,262 497 631 (3,126,432) 118,924 952,781 38.$ 195.483.137Total Assets Exhibit No. J. Healy Page 1 of 2 UNITED WATER IDAHO Balance Sheet Per Books July 31, 2004 Line No. LIABILITIES AND STOCKHOLDER'S EQUITI Stockholders Equity Preferred Shares-at stated par value $100 per share Authorized 25,000 shares, outstanding 6 965 Common Shares-at stated par value $500 per share Authorized 50,000 shares, outstanding --------- Paid in Capital Retained Earnings Total Stockholders Equity 696,500 261,750 104 330 53,395 684 $ 122,458,264 (134 859) 799 000 110 912,600 (236,208) 116,574 311 676 310 016 113,116 192,025 10. 11. 12. 13. 14. 15. 16. 17. 18. Current and Accrued Liabilities Accounts Payable Notes Payable to Associated Companies Customer Deposits Accrued Real Estate Taxes Accrued Income Taxes Other Accrued Taxes Dividends Declared Accrued Payroll Accrued Power Other Current Liabilities Total Current and Accrued Liabilities 19. 20. 21. 22. 23. 24. 25. 26. 27. 28. Deferred Credits and Other Liabilities Deferred Income Taxes and ITC Advances for Construction Contributions in Aid of Construction Pensions & Benefits Deferred Advances and CIAC Gross Up Deferred Regulatory Liabilities Deferred Post Retirement BenefitsOther Total Deferred Credits and Other Liabilities $ 5,533,525 072 337 670,359 272,164 333 656 996,838 660,031 293 938 $ 66,832,848 29.Total Liabilities and Stockholder s Equity $ 195.483.137 Exhibit No. J. Healy Page 2 of 2 Dean J. Miller McDEVITT & MILLER LLP 420 West Bannock Street O. Box 2564-83701 Boise, ill 83702 Tel: 208.343.7500 Fax: 208.336.6912 ioe~mcdevitt -miller .com Attorneys for Applicant BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION IN THE MATTER OF THE APPLICATION OF UNITED WATER IDAHO INC. FOR AUTHORITY TO INCREASE ITS RATES AND CHARGES FOR WATER SERVICE IN THE STATE OF IDAHO Case No. UWI-O4- BEFORE THE IDAHO PUBLIC UTILITIES COMMISSION EXHffiIT 5 TO THE DIRECT TESTIMONY OF JEREMIAH 1. HEALY UNITED WATER IDAHO Statement of Operating Income For the Year Ended July 31, 2004 Line No. Operating Revenues 31.000.222 Operating Expenses and Taxes Operation and Maintenance Expenses 11,470,319 Depreciation Expenses 738,848 Amortization of Other Utility Plant 51,113 Amortization of Utility Plant Acquisition Adjustment 397 Taxes Other than Income Taxes Real and Personal Property 528,696 Payroll Taxes 321 994 10.Income Taxes 11.State 446,418 12.Federal 005,942 13.Total Operating Expenses and Taxes 570,727 14.Utility Operating Income 429.495 Exhibit No. J. Healy