Loading...
HomeMy WebLinkAbout20160812Darrington Exhibit 14.pdfRonald L. Williams, ISB No. 3034 Williams Bradbury, P.C. 1015 W. Hays St. Boise, ID 83702 Telephone: (208) 344-6633 Email: ron@williamsbradbury.com Attorneys for Intermountain Gas Company BEFORE THE IDAHO PUBLIC UTILITES COMMISSION IN THE MATTER OF THE APPLICATION OF INTERMOUNTAIN GAS COMPANY FOR THE AUTHORITY TO CHANGE ITS RATES AND CHARGES FOR NATURAL GAS SERVICE TO NATURAL GAS CUSTOMERS IN THE STATE OF IDAHO ) ) ) ) ) ) ) Case No. INT-G-16-02 EXHIBIT 14 Proposed Company Company Revenue Company Line Unadjusted Company Direct Deficiency Direct No.Description Direct[2]Adjustments[3]Present[4](Over Collection)Proposed[5] (a)(b)(c)(d)(e)(f) 1 Gas Operating Revenues 233,637,331$ 18,262,816$ 251,900,147$ 10,165,700$ 262,065,847$ 2 Other Revenues 2,893,572 [6]6,791 2,900,363 - 2,900,363 3 Total Operating Revenue 236,530,903 18,269,607 254,800,510 10,165,700 264,966,210 4 Operating Expenses 5 Cost of Gas 150,178,166 18,644,493 168,822,659 - 168,822,659 6 Operation & Maintenance 7 Production 46,565 - 46,565 - 46,565 8 Natural Gas Storage, Terminaling, and Processing 1,383,094 - 1,383,094 - 1,383,094 9 Transmission 496,038 (3,297) 492,741 - 492,741 10 Distribution 18,854,837 (118,581) 18,736,256 - 18,736,256 11 Customer Accounts 9,378,630 (111,430) 9,267,200 36,536 9,303,736 12 Customer Service and Informational 202,610 - 202,610 - 202,610 13 Sales 1,263,653 (26,782) 1,236,871 - 1,236,871 14 Administrative and General 15,148,072 (1,328,388) 13,819,684 19,081 13,838,765 15 Other 93,510 (93,510) - - - 16 Depreciation 21,707,112 - 21,707,112 - 21,707,112 17 Payroll Taxes 1,743,002 (101,060) 1,641,942 - 1,641,942 18 Property Taxes 3,198,871 - 3,198,871 - 3,198,871 19 Franchise Taxes 7,087,860 (7,087,860) - - - 20 Interest Expense 4,348,423 (4,348,423) - - - 21 Total Operating Expense 22 Before Income Taxes 235,130,443 5,425,162 240,555,605 55,617 240,611,222 23 Income Taxes 205,475 2,544,743 2,750,218 4,024,824 [7]6,775,042 24 Total Operating Expenses 235,335,918 7,969,905 243,305,823 4,080,441 247,386,264 25 Net Operating Income 1,194,985$ 10,299,702$ 11,494,687$ 6,085,259$ 17,579,946$ NOTES [2] See T. Dedden's Exhibit 08, Page 1, Column (d). [3] See Exhibit No. 14, Page 2. [4] Column (b) + Column (c). [5] Column (d) + Column (e). [6] See T. Dedden's Exhibit 09, Page 1, Column (d), line 17. [7] Reflects statutory income tax rates at 39.81%: Federal at 35% and Idaho at 7.4%. Intermountain Gas Company Statement of Operating Income with Adjustments For the Test Year Ending December 31, 2016[1] [1] Test Year ending December 31, 2016 is composed of actual financial data from January 1 - June 30, 2016 and forecasted financial data from July 1, 2016 - December 31, 2016. Exhibit No. 14 Case No. INT-G-16-02 J. Darrington, IGC p. 1 of 2 No n - E x e c u t i v e Ot h e r Lo s t In c e n t i v e Ex e c u t i v e Re v e n u e To t a l No n - U t i l i t y Fr a n c h i s e Ga s Co m p e n s a t i o n Co m p e n s a t i o n An d In t e r e s t In c o m e Op e r a t i n g Lin e Un b i l l e d LN G S a l e s Ta x Ex p e n s e No r m a l i z a t i o n Ex p e n s e Ex p e n s e Ex p e n s e Ex p e n s e Ta x Sta t e m e n t No . De s c r i p t i o n Ad j u s t m e n t [2 ] Ad j u s t m e n t [3 ] Ad j u s t m e n t [4 ] Ad j u s t m e n t [5 ] Ad j u s t m e n t [6 ] Ad j u s t m e n t [7 ] Ad j u s t m e n t [8 ] Ad j u s t m e n t [9 ] Ad j u s t m e n t [1 0 ] Ad j u s t m e n t [1 1 ] Ad j u s t m e n t s (a ) (b ) (c ) (d ) (e ) (f ) (g ) (h ) (i) (j) (k ) (l) 1 Ga s O p e r a t i n g R e v e n u e s 27 , 6 0 5 , 9 2 6 $ (1 , 8 1 3 , 2 3 0 ) $ (7 , 0 8 7 , 1 5 4 ) $ - $ (4 4 2 , 7 2 6 ) $ - $ - $ - $ - $ - $ 18 , 2 6 2 , 8 1 6 $ 2 Ot h e r R e v e n u e s - - - - - - - 6,7 9 1 - - 6, 7 9 1 3 To t a l O p e r a t i n g R e v e n u e 27 , 6 0 5 , 9 2 6 (1 , 8 1 3 , 2 3 0 ) (7 , 0 8 7 , 1 5 4 ) - (4 4 2 , 7 2 6 ) - - 6,7 9 1 - - 18 , 2 6 9 , 6 0 7 4 Op e r a t i n g E x p e n s e s 5 Co s t o f G a s 21 , 2 4 6 , 0 0 4 (1 , 4 6 1 , 1 4 0 ) - (8 0 3 , 9 2 8 ) (3 3 6 , 4 4 3 ) - - - - - 18 , 6 4 4 , 4 9 3 6 Op e r a t i o n & M a i n t e n a n c e - - - - - - - - - - - 7 Pr o d u c t i o n - - - - - - - - - - - 8 Na t u r a l G a s S t o r a g e , T e r m i n a l i n g , a n d P r o c e s s i n g - - - - - - - - - - - 9 Tra n s m i s s i o n - - - - - (3 , 2 9 7 ) - - - - (3 , 2 9 7 ) 10 Dis t r i b u t i o n - - - - - (1 1 8 , 5 8 1 ) - - - - (1 1 8 , 5 8 1 ) 11 Cu s t o m e r A c c o u n t s - - - - - (1 1 1 , 4 3 0 ) - - - - (1 1 1 , 4 3 0 ) 12 Cu s t o m e r S e r v i c e a n d I n f o r m a t i o n a l - - - - - - - - - - - 13 Sa l e s - - - - - (2 6 , 7 8 2 ) - - - - (2 6 , 7 8 2 ) 14 Ad m i n i s t r a t i v e a n d G e n e r a l - - - - - (1 1 3 , 1 7 9 ) (1 , 2 1 5 , 2 0 9 ) - - - (1 , 3 2 8 , 3 8 8 ) 15 Oth e r - - - - - - 16 2 , 8 1 1 (2 5 6 , 3 2 1 ) - - (9 3 , 5 1 0 ) 16 De p r e c i a t i o n - - - - - - - - - - - 17 Pa y r o l l T a x e s - - - - - (3 2 , 7 2 8 ) (6 8 , 3 3 2 ) - - - (1 0 1 , 0 6 0 ) 18 Pro p e r t y T a x e s - - - - - - - - - - - 19 Fr a n c h i s e T a x e s - - (7 , 0 8 7 , 8 6 0 ) - - - - - - - (7 , 0 8 7 , 8 6 0 ) 20 In t e r e s t E x p e n s e - - - - - - - - (4 , 3 4 8 , 4 2 3 ) - (4 , 3 4 8 , 4 2 3 ) 21 To t a l O p e r a t i n g E x p e n s e 22 B e f o r e I n c o m e s T a x e s 21 , 2 4 6 , 0 0 4 (1 , 4 6 1 , 1 4 0 ) (7 , 0 8 7 , 8 6 0 ) (8 0 3 , 9 2 8 ) (3 3 6 , 4 4 3 ) (4 0 5 , 9 9 7 ) (1 , 1 2 0 , 7 3 0 ) (2 5 6 , 3 2 1 ) (4 , 3 4 8 , 4 2 3 ) - 5, 4 2 5 , 1 6 2 23 In c o m e T a x e s - - - - - - - - - 2, 5 4 4 , 7 4 3 2, 5 4 4 , 7 4 3 24 To t a l O p e r a t i n g E x p e n s e s 21 , 2 4 6 , 0 0 4 (1 , 4 6 1 , 1 4 0 ) (7 , 0 8 7 , 8 6 0 ) (8 0 3 , 9 2 8 ) (3 3 6 , 4 4 3 ) (4 0 5 , 9 9 7 ) (1 , 1 2 0 , 7 3 0 ) (2 5 6 , 3 2 1 ) (4 , 3 4 8 , 4 2 3 ) 2, 5 4 4 , 7 4 3 7, 9 6 9 , 9 0 5 25 Ne t O p e r a t i n g I n c o m e 6, 3 5 9 , 9 2 2 $ (3 5 2 , 0 9 0 ) $ 70 6 $ 80 3 , 9 2 8 $ (1 0 6 , 2 8 3 ) $ 40 5 , 9 9 7 $ 1,1 2 0 , 7 3 0 $ 26 3 , 1 1 2 $ 4, 3 4 8 , 4 2 3 $ (2 , 5 4 4 , 7 4 3 ) $ 10 , 2 9 9 , 7 0 2 $ NO T E S [1 ] T e s t Y e a r e n d i n g D e c e m b e r 3 1 , 2 0 1 6 i s c o m p o s e d o f a c t u a l f i n a n c i a l d a t a f r o m J a n u a r y 1 - J u n e 3 0 , 2 0 1 6 a n d f o r e c a s t e d f i n a n c i a l d a t a f r o m J u l y 1 , 2 0 1 6 - D e c e m b e r 3 1 , 2 0 1 6 . [2 ] S e e E x h i b i t N o . 1 5 , P a g e 1 , C o l u m n ( d ) , L i n e s 1 6 a n d 1 7 . [3 ] S e e E x h i b i t N o . 1 5 , P a g e 2 , C o l u m n ( d ) , L i n e s 1 a n d 2 . [4 ] S e e E x h i b i t N o . 1 5 , P a g e 3 , C o l u m n ( d ) , L i n e s 1 a n d 2 . [5 ] S e e E x h i b i t N o . 1 5 , P a g e 4 , C o l u m n ( d ) , L i n e 2 0 . [6 ] S e e E x h i b i t N o . 1 5 , P a g e 6 , C o l u m n ( b ) , L i n e s 1 0 a n d 1 1 . [7 ] S e e E x h i b i t N o . 1 5 , P a g e 1 7 , C o l u m n ( b ) , L i n e s 1 1 - 1 6 . [8 ] S e e E x h i b i t N o . 1 5 , P a g e 1 9 , C o l u m n ( d ) , L i n e s 4 - 6 . [9 ] S e e E x h i b i t N o . 1 5 , P a g e 2 2 , C o l u m n ( d ) , L i n e s 1 2 a n d 1 3 . [1 0 ] S e e E x h i b i t N o . 1 5 , P a g e 2 3 , C o l u m n ( d ) , L i n e 1 . [1 1 ] S e e E x h i b i t N o . 1 5 , P a g e 2 5 , C o l u m n ( c ) , L i n e 7 8 . In t e r m o u n t a i n G a s C o m p a n y Ad j u s t m e n t s t o O p e r a t i n g I n c o m e Fo r t h e T e s t Y e a r E n d i n g D e c e m b e r 3 1 , 2 0 1 6 [1 ] Exhibit No. 14 Case No. INT-G-16-02 J. Darrington, IGC p. 2 of 2