Loading...
HomeMy WebLinkAbout20050406Harms exhibits.pdfUNITED WATER IDAHO UWI-04- Calculation of Revenue Requirement Test Year Ended July 31 , 2004 with Pro Forma Adjustments 13-Month Average Rate Base $124 524,407 Required Rate of Return 100% Required Net Operating Income $ 10 086 477 Adjusted Net Operating Income realized 747 299 Net operating income Deficiency 339 178 Net to Gross Multiplier **683 Gross Revenue Increase 570 837 Incremental Income Tax Net to Gross Multiplier Calculation Net Operating Income Requirement Less PUC Assessment Rate Less Uncollectible Accounts Exp. State Taxable Income Residual State Tax Rate Effective Net State Tax Rate (L 11 * L 12) 100.00% 24% 0.40% 99.36% 00% 95% Federal Taxable Income Residual (L 11 - L 13) Incremental Federal Income Tax Rate Effective Net Federal Tax Rate (L 14 * L 15) 91.41% 35.00% 31.99% Composite- Uncollectibles, Fees & Taxes (add L 9 13 & 16) Composite Residual (L8 - L 17) Net to Gross Multiplier (L8 / L 18) 40.58% 59.42% 683 Exhibit No. 110 Case No. UWI-04- P. Hanns, Staff 4/06/05 1- 0 t' r j -. . . . . . . . p j ~ "" r ' I ( / ) P" ' 0\ ~ (' ! ) 1 - " ~~ z (/ ) ~ 1- 0 ' " ' pj (/ ) . (J q S " "'" " " ' (' ! ) ! " " ' h "'" " " ' "' " " " ' H ) "'" " " ' Li n e No . De s c r i p t i o n Ut i l i t y P l a n t I n S e r v i c e 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 P H F U " ' " Ne t U t i l i t y P l a n t 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 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 ) 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 ) 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 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 De f e r r e d C h a r g e s Wo r k i n g C a p i t a l To t a l R a t e B a s e 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 a n d M a i n t e n a n c e 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 Ta x e s O t h e r T h a n I n c o m e 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 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 Op e r a t i n g I n c o m e B e f o r e I n c o m e T a x e s In c o m e T a x e s 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 To t a l I n c o m e T a x e s Ut i l i t y O p e r a t i n g I n c o m e UN I T E D W A T E R I D A H O UW I - 04 - 4 13 - Mo n t h A v e r a g e R a t e B a s e a n d O p e r a t i n g R e s u l t s 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 20 0 4 w i t h P r o F o r m a A d j u s t m e n t s (A ) (B ) (C ) (D ) (E ) (F ) (G ) (H ) (I) (J ) (K ) St a f f Sta f f St a f f Ad j u s t St a f f A d j u s t St a f f A d j u s t St a f f A d j u s t St a f f A d j u s t m e n t Ra t e B a s e a n d El i m i n a t e El i m i n a t e Me m b r a n e St a f f A d j u s t St a f f A d j u s t Gr o u n d W a t e r to R e m o v e to I n c l u d e UW I R a t e B a s e to 1 3 - Mo n t h Op e r a t i n g CW T P CW T P Fi l t e r D e p r . I n i t i a l B u t t e t o IM A P " t o Re c h a r g e t o Wa t e r R i g h t s J o b s C r e a t i o n pe r C o m p a n y Av e r a g e R a t e Ex p e n s e s o n 1 3 " La n d / B l d g . Ca n c e l l e d Ov e r 1 0 Us e d a n d Us e d a n d Us e d a n d AF U D C ' " a n d Ac t T a x Re c o r d s Ba s e Mo n t h A v e r a g e Ov e r s i z e PO ' A F U D C Ye a r s Us e f u l Us e f u l Us e f u l Ta x G r o s s U p Cr e d i t 22 7 , 48 3 39 9 03 8 67 8 24 5 52 2 07 7 $ ( 5 3 3 08 4 ) $ (2 5 8 77 2 ) (6 7 7 , 45 2 ) $ (6 4 4 70 0 ) $ (2 9 69 7 ) $ (6 8 4 , 96 2 ) (5 5 28 7 , 81 9 ) ( 1 84 3 62 4 ) ( 5 7 , 13 1 , 44 3 ) 1 2 , 93 9 2 0 00 0 7 , 06 7 17 2 , 19 5 58 0 $ 1 6 19 5 05 4 $ 1 8 8 39 0 63 4 $ ( 5 3 3 , 08 4 ) $ ( 2 4 5 83 3 ) $ 2 0 , 00 0 $ (6 7 7 , 4 5 2 ) $ ( 6 4 4 , 70 0 ) $ ( 2 9 , 69 7 ) $ ( 6 7 7 89 5 ) (7 , 07 2 33 7 ) 1 9 5 89 1 ( 6 87 6 44 6 ) (4 4 , 67 0 35 9 ) 1 , 4 6 7 38 2 ( 4 3 20 2 97 7 ) 60 0 76 2 6 0 0 76 2 (1 1 , 14 4 38 8 ) ( 3 37 7 27 9 ) ( 1 4 52 1 66 7 ) (1 4 32 8 ) - ( 1 4 32 8 ) 63 5 12 4 1 63 5 12 4 04 5 , 12 6 2 04 5 12 6 $ 1 1 3 57 5 18 0 $ 1 4 , 48 1 04 8 $ 1 2 8 , 05 6 , 22 8 $ ( 5 3 3 , 08 4 ) $ ( 2 4 5 , 83 3 ) $ 2 0 00 0 $ (6 7 7 , 4 5 2 ) $ . ( 6 4 4 , 7( ) 0 ) $ n 69 7 ) 68 4 96 2 06 7 $ 31 , 53 4 83 2 53 4 83 2 40 3 51 2 40 3 51 2 38 6 50 9 (4 9 0 53 9 ) 89 5 97 0 (1 2 , 93 9 ) (2 0 00 0 ) (1 3 , 4 8 2 ) 32 9 9 32 9 39 5 83 8 ( 4 9 0 , 53 9 ) 5 90 5 , 29 9 - ( 1 2 93 9 ) ( 2 0 00 0 ) 3, 4 8 ~ ) 57 0 94 1 57 0 94 1 35 2 27 1 35 2 , 27 1 92 3 , 21 2 92 3 21 2 72 2 56 2 (4 9 0 53 9 ) 21 , 23 2 02 3 (1 2 93 9 ) (2 0 00 0 ) 81 2 , 27 0 49 0 53 9 30 2 80 9 93 9 00 0 (2 3 4 00 9 ) 24 3 (1 9 4 76 6 ) 03 5 60 0 55 2 47 5 15 7 , 95 3 71 0 , 4 2 8 16 6 44 0 31 8 , 4 6 6 19 7 19 6 51 5 66 2 20 1 04 0 ,4 9 3 80 4 29 3 34 3 78 7 14 7 73 8 ~9 6 0 (1 3 48 2 ) 48 2 07 9 34 1 (8 7 50 1 ) 42 0 (8 7 , 50 1 ) 06 2 87 , 50 1 . P O = P u r c h a s e O r d e r .. IM A P = I n t e g r a t e d M u n i c i p a l A p p l i c a t i o n P a c k a g e .. . AF U D C = A l l o w a n c e f o r F u n d s U s e d D u r i n g C o n s t r u c t i o n .. . . M& S = U W I M a n a g e m e n t a n d S e r v i c e s .. . . . UP A A = 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 ; PH F U = P l a n t H e l d f o r F u t u r e U s e Ra t e B a s e ( L i n e s 1 - 11 ) i n C o l u m n A a r e f r o m J . H e a l y E x h i b i t N o . , P a g e 1 o f 9 , C o l . A ( p e r B o o k s J u l y 3 1 20 0 4 ) Re v e n u e ( 1 2 ) i n C o l u m n A i s f r o m F . G r a d i l o n e E x h i b i t N o . , S c h e d u l e 1 , P a g e 2 o f 2 , C o l . 6 Op e r a t i n g R e s u l t s ( L i n e s 1 3 - 2 6 ) i n C o l u m n A f r o m J . H e a l y E x h i b i t N o . , C o l . 4 ( A d j u s t e d T e s t Y e a r ) +: : '-- - - . P' ~ 0 ~ en P" " 0\ ~ (1 ) ... . . . 23 ~ VI ~ 0 .- t - . Z ~" c n e (J q S " (1 ) H 1 H) I ~ I- + ) +: : . Lin e No . UN I T E D W A T E R I D A H O UW I - 04 - 4 13 - Mo n t h A v e r a g e R a t e B a s e a n d O p e r a t i n g R e s u l t s 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 w i t h P r o F o r m a A d j u s t m e n t s (L ) (M ) (N ) (0 ) (P ) St a f f A d j u s t Ca r r i a g e H i l l Sta f f A d j u s t e d Re m o v e N o n , Re v e n u e p e r St a f f W i t n e s s Ra t e B a s e a n d Re g u l a t e d Co m m i s s i o n En g l i s h De b t I n t e r e s t Op e r a t i n g M& S " " F e e s Or d e r Ad j u s t m e n t s Re s t a t e m e n t In c o m e (1 3 5 63 0 ) 24 2 , 55 7 , 78 1 36 1 (5 7 , 08 7 07 6 ) (1 3 1 , 26 9 ) 18 5 , 4 7 0 70 5 87 6 , 4 4 6 ) (4 3 20 2 , 97 7 ) 60 0 76 2 (1 4 , 52 1 66 7 ) (1 4 32 8 ) (1 . 29 6 85 4 ) 02 3 23 2 04 5 . 12 6 $ ( 1 , 4 2 8 12 3 ) 12 4 , 52 4 , 40 7 62 8 31 , 54 0 , 4 6 0 (2 0 , 67 8 ) 94 8 15 9 ) 11 , 43 4 . 67 5 36 1 ) 84 5 18 9 32 9 36 1 85 4 51 8 57 0 94 1 (1 6 , 4 2 3 ) 33 5 84 8 16 , 42 3 90 6 78 9 (2 0 67 8 ) (1 , 96 8 94 3 ) 19 5 98 2 67 8 62 8 96 8 94 3 34 4 47 8 65 4 45 0 15 7 , 51 5 (9 6 16 2 ) (1 2 7 59 5 ) 65 8 81 2 63 4 , 00 0 44 4 , 4 2 9 72 4 77 4 31 2 26 2 79 1 51 5 34 8 26 7 59 7 , 17 9 36 6 36 6 17 7 , 42 8 34 8 26 7 74 7 29 9 De s c r i p t i o n Ut i l i t y P l a n t I n S e r v i c e 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 " ' " Ne t U t i l i t y P l a n t 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 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 ) Uti 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 ) 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 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 De f e r r e d C h a r g e s Wo r k i n g C a p i t a l To t a l R a t e B a s e 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 a n d M a i n t e n a n c e 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 Ta x e s O t h e r T h a n I n c o m e 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 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 Op e r a t i n g I n c o m e B e f o r e I n c o m e T a x e s In c o m e T a x e s 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 To t a l I n c o m e T a x e s Ut i l i t y O p e r a t i n g I n c o m e Li n e N o . '" d t: r 1 -- - . ~ ~ :: q r D e- . ~~ z (I ) ~ r/ ) . .- + "- " !- h 1- - 1 " - " I- t i I (A ) (B ) (C ) (D ) (E ) (F ) (G ) (H ) Co l u m b i a Pr o F o r m a Ca r r i a g e H i l l Wa t e r Ad d i t i o n s t h r o u g h Pr o F o r m a Tr a n s a c t i o n 13 - Mo n t h Tr e a t m e n t De c e m b e r 3 1 Re t i r e m e n t s a s i f Im p a c t a s i f St a f f T o t a l Av e r a g e o f Pl a n t 20 0 4 a s i f A d d e d Co m p l e t e d J u l y Cl o s e d i n J u l y St a f f 1 3 - Mo n t h Le s s C o m p a n y Te s t Y e a r An n u a l i z e d Ju l y 2 0 0 4 20 0 4 20 0 4 Av e r a g e Bo o k s $ 2 2 1 13 7 72 3 92 7 98 5 54 8 07 1 (5 0 36 5 ) (4 1 33 6 ) $ 2 4 5 52 2 07 7 03 8 67 8 De s c r i p t i o n Pe r C o m p a n y Re c o r d s a s o f Ju l y 3 1 , 2 0 0 4 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 J. H e a l y Ex h i b i t N o . Pa g e 1 o f 9 Co ! . A , L i n e 1 UN I T E D W A T E R I D A H O UW I - 04 - St a f f 1 3 - Mo n t h A v e r a g e P l a n t i n S e r v i c e A d j u s t m e n t UN I T E D W A T E R I D A H O UW I - O4 - St a f 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 m o r t i z a t i o n C a l c u l a t i o n s o n 1 3 - Mo n t h A v e r a g e (A ) (B ) (C ) Li n e No . Ac c u m u l a t e d De p r e c i a t i o n At A u g u s t 1 , 2 0 0 3 Ju l y 3 1 20 0 3 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 C I 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 (P H F U ) Am o r t i z a t i o n o f U P A A 72 0 17 5 IA 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 m o r t i z a t i o n a t A u g u s t 1 , 2 0 0 3 ( J u l y 3 1 , 2 0 0 3 ) 72 0 17 5 Te s t Y e a r A c t i v i t y : De p r e c i a t i o n E x p e n s e f o r O n e Y e a r o n 1 3 - Mo n t h A v e r a g e P l a n t i n S e r v i c e 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 h r o u g h D e c e m b e r 3 1 20 0 4 a s i f P r o c e s s e d i n J u l y 2 0 0 4 Am o r t i z a t i o n o f 1 3 - Mo n t h A v e r a g e C o n t r i b u t e d P l a n t f o r O n e Y e a r 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 ( B o i s e R i v e r I n t a k e ) (P l a n t H e l d f o r F u t u r e U s e i s n o L o n g e r A m o r t i z e d a n d N o w D e p r e c i a t e d i n L i n e 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 a s i f P r o c e s s e d i n J u l y 2 0 0 4 Sa l v a g e o n P l a n t R e t i r e m e n t s a s i f P r o c e s s e d J u l y 2 0 0 4 Re c o r d U P A A A m o r t i z a t i o n f o r O n e Y e a r 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 a s i f P r o c e s s e d J u l y 2 0 0 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 M e t e r s a n d T r e a t m e n t a s i f P r o c e s s e d J u l y 2 0 0 4 Re v e r s e C a r r i a g e A m o r t i z a t i o n R e s e r v e F o r C I A C a s i f P r o c e s s e d J u l y 2 0 0 4 Re v e r s e C a r r i a g e A c c u m D e p r F o r C I A C a s i f P r o c e s s e d J u l y 2 0 0 4 89 5 97 0 (5 0 36 5 ) 22 9 54 3 25 9 ) 1 , 4 8 8 03 1 ) 17 fA c c u m u l a t e d D e p r . , CI A C R e s e r v e , P H F U R e s e r v e a n d U P A A R e s e r v e o n 1 3 - Mo n t h A v e r a g e 78 8 28 0 J. H e a l y , E x h i b i t N o . , P a g e 1 o f 9 , C o l . A , L i n e 2 P e r C o m p a n y B o o k s 19 IS t a f f L e s s C o m p a n y B o o k s * U P A A = U t i l i t y P l a n t A c q u i s i t i o n Ad j u s t m e n t .J : : : . . CI 1 . ~ X 0 ~ U' J : : r 0\ ~ (D ", " " , . ~ ~ U'J . Z (/ ) .. . - t - e- ' ~ ~ e- ' 'T ' U J .J : : : . . .J : : : . . (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 Pl a n t H e l d f o r Am o r t i z a t i o n CI A C R e s e r v e Fu t u r e U s e of U P A A * 20 1 , 4 6 4 20 1 46 4 12 6 81 5 (1 8 8 ) (5 3 ) 03 1 ) 32 7 , 24 8 22 9 54 3 58 7 22 9 , 54 3 58 7 (2 2 9 54 3 ) 32 8 15 , 91 5 (G ) To t a l 72 0 , 17 5 20 1 46 4 22 9 , 54 3 58 7 50 , 15 7 76 9 89 5 , 97 0 (5 0 36 5 ) 12 6 , 81 5 25 9 ) 48 8 32 8 (1 8 8 ) (5 3 ) 03 1 ) 03 1 ) 13 1 44 3 28 7 , 81 9 84 3 , 62 4 UN I T E D W A T E R I D A H O UW I - O4 - 4 St a f f C a l c u l a t i o n o f 1 3 - Mo n t h A v e r a g e A d v a n c e s (A ) (B ) (C ) (D ) (E ) (F ) (G ) 13 - Mo n t h Au g u s t t h r u Av e r a g e 13 - Mo n t h De c e m b e r 2 0 0 4 Ad v a n c e s Re c l a s s e d Av e r a g e Re f u n d s a s i f Ca r r i a g e H i l l In c l u d i n g P o s t - Li n e Ad v a n c e s a t Ad v a n c e s b y Clo s e d i n J u l y Tr a n s a c t i o n a s i f Te s t Y e a r Le s s C o m p a n y St a f f L e s s Pl a n t A c c o u n t Ju l y 3 1 , 2 0 0 4 Ac c o u n t 31 , 2 0 0 4 Cl o s e d J u l y 2 0 0 4 Tr a n s a c t i o n s Bo o k s Co m p a n y B o o k s 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 Pl a n t 98 6 85 8 85 8 98 6 (1 2 8 ) 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 37 9 25 5 37 2 28 3 08 1 ) 84 0 ) 36 5 36 2 34 7 , 57 4 78 8 30 3 4 0 - W a t e r T r e a t m e n t P l a n t L a n d & L a n d R i g h t s 44 6 53 7 (6 8 1 ) 47 , 85 6 86 5 00 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 S t r u c t u r e s & I m p r o v e m e n t s 12 5 48 0 12 3 17 3 22 9 ) 65 5 ) 11 9 29 0 38 3 33 , 90 7 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 C o 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 ) 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 58 3 20 1 57 2 48 1 (1 , 52 9 ) (1 1 , 29 9 ) 55 9 65 2 36 9 14 5 19 0 50 7 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 S u p p l y M a i n s 37 8 , 89 5 37 1 93 0 53 8 ) 37 0 39 1 37 4 27 3 88 1 ) 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 G e n e r a t i o n E q u i p m e n t 60 3 94 3 59 2 84 0 06 7 ) 99 2 ) 58 3 78 1 52 8 61 6 16 5 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 7 19 2 12 7 19 2 12 7 , 19 2 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 E q u i p m e n t 38 4 32 2 32 2 38 4 (6 2 ) 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 98 2 66 5 96 4 60 1 (1 3 47 2 ) 95 1 12 9 65 3 72 0 29 7 41 0 33 1 4 0 - T r a n s & D i s t P l a n t M a i n s 14 2 38 2 08 4 61 6 (1 2 , 77 6 ) 07 1 , 84 0 13 7 12 4 (6 5 28 4 ) 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 2 , 74 0 59 1 66 0 (4 , 11 9 ) 58 7 54 1 60 6 56 0 (1 9 , 01 9 ) 33 5 4 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 85 8 85 8 98 6 (1 2 8 ) 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 40 0 97 7 (1 3 5 ) (4 6 8 ) 37 4 58 7 41 , 78 6 Ad v a n c e s i n C W I P 34 6 86 0 (3 4 6 86 0 ) To t a l P e r G e n e r a l L e d g e r 07 2 33 7 94 2 32 7 (3 9 62 7 ) (2 6 25 4 ) 87 6 44 6 07 2 , 33 7 (1 9 5 89 1 ) Ex h i b i t N o . J. H e a l y Pa g e 4 o f 9 Co l . 8 +: : . " " ' d tr : ! -- - - . PJ X (/ ) : : r 0\ i- I - I CD .. . . . . ~~ Z (/ ) ~ '" C/ ) .- + - ,.. . . . . . . I- + ) ,. . . . . . . . +:: . +: : . +: : . :! : : ~ 0 ~ C/ ) p - ' ~ ~ (1 ) _ . :: 1 z S'" . d 0 C/) . Z r. / 1M- ... . . . . . I- h ... . . . . . -S I V I +: : - +: : - UN I T E D W A T E R I D A H O UW I - 04 - 13 - Mo n t h 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 G r o s s t o N e t Li n e No . 13 - Mo n t h A v e r a g e G r o s s 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 ( C I A C ) Ac c u m u l a t e d A m o r t i z a t i o n a t e n d o f T e s t Y e a r ( L i n e 8 ) 13 - Mo n t h A v e r a g e G r o s s 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 N e t o f A m o r t i z a t i o n 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 i z a t i o n a s i f C l o s e d J u l y 2 0 0 4 ( P e r J o u r n a l E n t r y $ 1 3 , 4 0 9 ) St a f f N e 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 s A d j u s t e d St a f f C a l c u l a t i o n o f A m o r t i z a t i o n : Ac c u m u l a t e d A m o r t i z a t i o n a s o f A u g u s t 1 , 2 0 0 4 ( J u l y 3 1 , 2 0 0 3 ) Am o r t i z a t i o n o f 1 3 - Mo n t h A v e r a g e C o n t r i b u t i o n s f o r O n e Y e a r 32 8 27 9 ) Ac c u m u l a t e d A m o r t i z a t i o n a t e n d o f T e s t Y e a r 20 1 46 4 ) 12 6 81 5 ) Co m p a r i s o n t o C o m p a n y B o o k s : CI A C a t J u l y 3 1 20 0 4 ( J . H e a l y E x h i b i t N o . , P a g e 5 o f 9 , L i n e 2 ) Ac c u m u l a t e d A m o r t i z a t i o n a t J u l y 3 1 , 2 0 0 4 ( J . H e a l y E x h i b i t N o . , P a g e 5 o f 9 , L i n e 3 ) Ro u n d i n g CI A C N e t B a l a n c e a t J u l y 3 1 20 0 4 ( J . H e a l y E x h i b i t N o . , P a g e 1 o f 9 , L i n e 5 ) St a f f L e s s C o m p a n y B o o k s * R e v e r s a l o f C a r r i a g e H i l l C I A C a l r e a d y i n c l u d e d i n 1 3 - Mo n t h C I A C C a l c u l a t i o n 53 0 22 5 32 8 27 9 ) 20 1 94 6 03 1 20 2 97 7 96 3 85 8 29 3 50 1 ) 67 0 35 9 (1 , 4 6 7 , 38 2 ) Line No. UNITED WATER IDAHO UWI-O4- Staff Depreciation Expense Adjustment on 13-Month Average 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 Pro Forma Depreciation Expense per Staff Pro Forma Depreciation Expense per Company Test Year Expense Adj ustment J. Healy Exhibit No. Schedule 2 Page 1 of 4 UWI Proposed Amount $ 1.647.661 386 509 738,848 $ 1.647.661 Staff Proposed Amount $ (490.539) 895,970 386,509 $ (490.539) Exhibit No. 116 Case No. UWI- W -04- P. Hanns, Staff 4/06/05 Page 1 of 2 UNITED WATER IDAHO UWI-04- Staff Depreciation Expense Calculation for 13-Month Average Rate Base Pro Forma Pro Forma Net Line Account Utility Contributions Pro Forma Depreciable Depreciation Annual No.Account Descri tion No.Plant In Aid Advances Plant Rate reciation NON-DEPRECIABLE PLANT: Organization 301-111 642 961)858) $823 0% $ land & land Rights, Water Rights - Source of Supply 303-021 409 (320 231)(365 362) $335 815 0% $ land & land Rights - Water Treatment 303-893 548 893 548 0% $ land & land Rights - Trans. & Distrib.303-395 698 (47 856)347 842 0% $ land & land Rights - General Plant 303-205 126 205 126 0% $ TOTAL NON-DEPRECIABLE PLANT 627 423 (329 192) $(420 076) $878 155 DEPRECIABLE PLANT: Structures and Improvements - Source of Supply 304-552 893 (259 240)(119 290) $174 364 00% $487 10.Structures and Improvements - Water Treatment 304-954 601 954 601 00% $259 092 11.Structures and Improvements - Trans. & Distrib.304-599 599 00% $692 12.Structures and Improvements - General Plant 304-076 483 076,483 50% $912 13.Collecting & Impounding Reservoirs - Source of Supply 305-997 (21 601)396 00% $168 14.lake, River & Other Intakes 306-223 044 (67 131)155 913 00% $118 15.Wells & Springs 307 -854 317 375 093)(559 652)919 572 86% $197 900 16.Infiltration Galleries & Tunnels 308-311 311 00% $666 17.Supply Mains 309-192 625 242)(370 391)812 992 00% $260 18.Power Generation Equipment 310-372 701 372 701 00% $635 19.Power Electric Pumping Equipment - Source of Supply 311-296 996 785 372)(583 781)927 843 00% $446 392 20.Power Diesel Pumping Equipment - Source of Supply 311-00% $ 21.Power Pumping Equipment - Water Treatment 311-331 866 331 866 00% $266 593 22.Power Pumping Equipment - Trans. & Distrib.311-925 127 (127 192)797 935 00% $897 23.Water Treatment Equipment 320-981 936 (36 274)322)942 340 00% $047 117 24.Water Treatment Equipment - Membranes 320-500 000 500 000 14.00% $000 25.Distribution Reservoirs & Standpipes 330-294 072 145 290)(951 129)197 653 00% $143 953 26.Trans. & Distrib. Mains & Accessories - Intangible 331-139 139 00% $ 27.Trans. & Distrib. Mains & Accessories SOS 331-138 138 00% $ 28.Trans. & Distrib. Mains & Accessories 331-473 556 $ (39 594 086)071 840)807 630 00% $116 153 29.Services 333-436 665 179 733)(587 541)669 391 50% $716 735 30.Meters and Meter Installations 334-125 083 (188,472)936 612 50% $273,415 31.Hydrants 335-035 848 (563 818)858)465 173 50% $629 32.Backflow Prevention Devices 336-00% $ 33.Other Plant & Misc. Equipment - Intangible 339-00% $ 34.Other Plant & Misc. Equipment - Source of Supply 339-304 304 00% $726 35.Other Plant & Misc. Equipment - Water Treatment 339-841 841 00% $837 36.Other Plant & Misc. Equipment - Trans. & Distrib.339-019 019 00% $700 37.Other Plant & Misc. Equipment - General Plant 339-187 187 00% $304 38.Office Furniture and Equipment 340-658 035 113)656 922 67% $817 39.AM FM System - Mapping 340-532,463 532,463 10.00% $246 40.Computer Hardware & Software 340-741 192 741 192 20.00% $348 238 41.IFMS WAN PeopleSoft 340-2,759 047 759 047 10.00% $275 905 42.Customer Information System 340-725 609 725 609 10.00% $172 561 43.Transportation Equipment 341-129 057 129 057 11.49% $829 49.Stores Equipment 342-502 502 67% $568 50.Tools, Shop and Garage Equipment 343-437 206 437 206 67% $162 51.Confined Space Monitor, Generator, Trench Shield 343-113 113 14.50% $716 52.laboratory Equipment 344-112 130 (16 463)667 67% $381 53.Power Operated Equipment 345-541 541 00% $ 54.Power Operated Equipment 345-891 891 14.50% $974 55.Communications Equipment 346-257 180 (75 374)181 806 67% $826 56.Miscellaneous Equipment 347 -103,457 103,457 67% $901 57.Other Tangible Property 348-00% $ 58.Master Plan 348-282 882 282 882 10.00% $288 59.Related to Construction Work in Progress 894 N/A 60.Rounding N/A 61.TOTAL DEPRECIABLE PLANT 237 894 655 51 201 033 456 370 180 195 355 910 799 62.TOTAL UTILITY PLANT IN SERVICE 245.522.077 (51.530.225)(6.876.446)187.073.510 63.Less: Depreciation Included on Transportation Schedule (14 829) 64.Total 895 970 Exhibit No. 116 Case No. UWI- W -04- P. Hanns, Staff 4/06/05 Page 2 of 2 CERTIFICATE OF SERVICE HEREBY CERTIFY THAT I HAVE THIS 6Th DAY OF APRIL 2005 SERVED THE FOREGOING DIRECT TESTIMONY OF PATRICIA HARMS, IN CASE NO. UWI- W -04-, BY MAILING A COpy THEREOF POSTAGE PREPAID TO THE FOLLOWING: MARK GENNARI UNITED WATER 200 OLD HOOK RD HARRINGTON PARK NJ 07640 DEAN J MILLER ESQ McD EVITT & MILLER LLP PO BOX 2564 BOISE ill 83701 DOUGLAS K STRICKLING BOISE CITY ATTORNEY'S OFFICE 150 N CAPITOL BLVD. PO BOX 500 BOISE ill 83701 CHUCK MICKELSON CITY OF BOISE 150 N CAPITOL BLVD. PO BOX 500 BOISE ill 83701 WILLIAM M. EDDIE ADVOCATES FOR THE WEST PO BOX 1612 BOISE ill 83701 BILL SEDIVY ill AH 0 RIVERS UNITED PO BOX 633 BOISE ID 83701 BRAD M. PURDY ATTORNEY AT LAW 2019 N 17TH STREET BOISE ID 83702 SHARON ULLMAN 9627 W. DESERT AVE BOISE ill 83709 SCOTT L. CAMPBELL 101 S CAPITOL BLVD., 10TH FLOOR PO BOX 829 BOISE ill 83701 Jo~~ SECRET AR CERTIFICATE OF SERVICE