Loading...
HomeMy WebLinkAboutU-1034-99 Staff Exhibit 102.pdf,~ N CXC'.. ::zc:a.:EoU Vl ë3 Z.. ¡:~ ~0:Lii-Z.. ..(" ;:.. VI :: Clr- eni:Olio i: .i'''U"0 i: ClLi ....So 1010 s.Cl :: :: VI 10 ~.. ClVI :i Cli- ~ Cl i:.i 3:.p 0 s. ~ot+ s.oVI t+i:o "C .,. Cl.p .p 10 VISo :: Cl ...0. "0o c: t+O r-.. .p Cl"O ~.:= ~ Cl U t.; ~ t+ Cl 0- Clt+ V' Cl ~10 a: Cl.p t+ 0:V' 0 oi VI.p..::VI Cl0: ...... "0 ~ Cl U Cl i: :: i:VI 10 i: Clo a. Cl .,.a. E ~ uo 0 Cl.,.s. u a: t+a. Clc: ..:i.. "0 Cl U Cl t+ :: i:VI 4- i: Clo 10 Cl.,.a..p ~ Uo V' Cl.,.s. 0: t+a. Clc: ..c. "0 "0 ;; t+ Cl Cl Clt+ VI .p :: 10 0 VI.p g-.~.pV' s. "0 VI0. c: ~ ..w... VI.p~ "0 i: i: Cl Cl10 VI Ea. o.pE 0. VIo 0 ::us..0. "0c: VI "0 .p t+ Cl ~t+ VI E10 o.p.p a. VIV' 0 ::s. ... a. "0c: ..Li.. c:.. "0 s. "0Cl 10 ~t+ VI Cl .,.~. 0 :: ...p o..p 10 V' 0 VI Es. Cl s.a. i- ~ ..u.. i:o VI.,. .p~ "0 .p i: i: Cl 10 ClIOVINE0. O.,..p E 0... VIOOIO::u So E'a. s. "0o c:z i:o VI.,. .p"0 .p i: 4- Cl 10 Clt+ VI N E 10 0.,. .p.p a.,. VIV' 0 10 ::s. E' a. s. "0o c:Z N~.. .. CO.. c:.. VI.s .. .p "010 i: Cl ..:: O"O...p:E i: ("U Lic: N.. INTERMOUNTAIN GAS CO. CASE NO. U-I034-99 Staff Exh. No. 102 Marian Hylen ..::r- ClU.,.~s. ClV' t+o .p VIou VI Cl::i:Cl~ Cl0: s. Clo CXC'~.. :0"co.. ~ CXo: CX.. at~.. CX~ NC'~..o:.... o:~ ~oo'"o:~".. C'(".. ~ o:" "(" 0.. C' CX(" ..o: ("..("o:..(" "o:.. ~!o:.......o: \0"(""C'("o: (" ~ I- I I ~.~~ o 0CX CX(" (" (" ("(" ("o: o:~ ~oo"o:\0" 0'(".- \0 NC' 0C' 0..i. 0o "o " (" No:..~ "oo..o\0N .-....~..\0o:o"NNo""..~ Ni.o" \0C'C' i. No C'o " (" C'o:.- ~ CX" ~o:..~ VI Cl 10V's. Cl.i.poVI 10c. ..N CXo:CX o:C'\0.. CX N CX(" ('oN ("o:.- \0o:o"NNo" .. 10.poi- (" VI Cl VIi: Cl ..C'" o:..o.. CXo: CX..oCXi. o:.-(".... ..C'" o:..o (".-.. 00o: CX"o CXi. o:.. .."oo:i. CX\0.. ("\0.."i.C'C' .-o: -0o 0C' " .. NN o:~ ..C'..o:o:~""o:..o..(".... ..oo..o:.. o:i.......en.... ....~.."o("i.i... CXi.C' o:ll CX.... VI 10c. t+o .pVIou o: .. o:o:\0...-oo..o:.- :E ~o i.\0 i. CX\0" R\0..(" i. CX\0'"o..~'"(" ..o.- CX'"(".. ..o.. CX"(" .. i.C'q'" ~\0"(" i.C'o:..o:..~..(" i:o VI.,. Cl.p X10 10.,. i-UCl ..s.a. i:Cl Clc: c. .. CX CX\0i. (" CXo:"(" CX("...."i. o: C'.. CX"o:o(" o: o:CX.."(".0 N CX\0i. (" CXo:..(" o:i.C' ("("i. N ("o" ~,'", CXC'.. \0Ni...CXo: ("o.- .... ..~ llC' o: o: Ni. 0N.. .. ("N i.\0o:"o\0o:..(" ..\0\0"~\0 CX"N ....--...(" CXN~".... ..C'N\0" co(".. .. i.~o:"o~o:..(" ~Ni.o\0"(" VI ClX10i- ClEoUi:.. C' o("o..N(" C' "(".. C'.. CX..o:o(" o: o:00.."("o N ~":oo (" CXN"(".. ~.~ ~:tlN 0~ at"CX ...- i.o ..,. i. (V).- .. ~ ~.. N CX ("~ i.N .. ~ ~ CX 0i. C'co .-~ i.CX 0N i.(" ~o:.. ClEs. 0Cl VI Ua. Cl i:o VI ..i: .. Cl10 a. s..p x Clo Li a.i- 0 o...- N ("...- .. o:o:o~C' C' ~ C'NooC'(" o:~ cOoi. i. ~ .n..Nll ~ ~ ("Ni.~("i.co CX~o:.-.. ClVI 10co Cl.p 100: i:s.::.p Cla: 4-o Cl.p 100: o:..i... INTRMOUNAIN GAS COMPAN Calculation of 13-Month Average Rate Base (A)(B)(C) Company. Staff Proposed Changes Staff 1 Gas Plant in Service: Original Cost Less: $ 110,310,941 $ 110,310~94i 2 Accumulated Depreciation (38,3861796)$11455 ,(38,385 ¡¡ 341) 3 Net Gas Plant in Service 71 ,924, 145 71,925,600 Less: 4 Accumulated Deferred Income Taxes (7,028,972)1801628 (6,848,344) 5 Advances in Aid of Construction (93,905)(93,905) Add: 6 Materials &Supplies Inventory 741,394 7411394 7 LNG Inventory 1,743,615 1,743,615 8 Zero- Interest Financing Notes 163 163 9 Total S 67.286,440 S 182,083 S 67,468.523 INTERMOUNAIN GAS COMPAN CASE NUR U-1034-99 Staff Exhibit No. 102 Schedule 1 Marian Hylen 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 3: V l V l n . . QI . n c - : ; : z ~ : : Q I V l - l .. . r o - l r i r i QI 0 . - t , : : ;: i : 2 3 : .. r r 0 0 :i r o X . c : ~ : : Z .. N . c : - l ro i : ; :: Z . . . . o O Z .w.. t ~ O~ V l N 1 . ( ' o3:~Z-oJu l y 1 9 8 1 Au g . 1 9 8 1 Se p t 1 9 8 1 Oc t . 1 9 8 1 No v . 1 9 8 1 De c . 1 9 8 1 Ja n . 1 9 8 2 Fe b . 1 9 8 2 Ma r . 1 9 8 2 Ap r . 1 9 8 2 Ma y 1 9 8 2 Ju n e 1 9 8 2 Ju l y 1 9 8 2 (A ) Ye a r - t o - D a t e Ba l a n c e A/ C 1 9 0 - 2 4 0 Ac c u m . D e £ . I n c . Ta x e s ( S t a t e ) , U n - fu n d e d F u t u r e T a x Li a b i l i t y ( D B ) $ 6 0 4 , 2 8 8 60 8 , 4 5 9 60 5 , 9 2 5 60 8 , 9 5 5 60 2 1 2 1 9 59 5 1 2 6 9 58 4 , 2 1 2 57 4 , 0 1 4 57 0 , 1 4 7 56 2 1 4 7 5 56 0 , 0 4 8 56 5 , 3 4 1 56 8 , 4 8 9 (B ) 4/ 5 o f Ba l a n c e o f Co l u m n ( A ) $ 4 8 3 , 4 3 0 48 6 , 7 6 7 48 4 , 7 4 0 48 7 , 1 6 4 48 1 1 7 7 5 47 6 , 2 1 5 46 7 , 3 6 9 45 9 , 2 1 1 45 6 , 1 1 7 44 9 , 9 8 0 44 8 1 0 3 8 45 2 , 2 7 2 45 4 , 7 9 1 IN T E R M O U N T A I N G A S C O M P A N De f e r r e d I n c o m e T a x e s Fo r t h e 1 2 M o n t h s E n d e d J u l y 3 1 , 1 9 8 2 (C ) Ye a r - t o - D a t e Ba l a n c e A/ G 1 9 0 - l 4 0 Ac c u m . D e f . I n c . Ta x e s ( F e d . ) , U n - fu n d e d F u t u r e T a x Li a b i l i t y ( D B ) $ 3 , 9 9 8 , 5 2 6 41 0 2 6 , 1 2 8 41 0 0 9 1 ~ 6 1 4, 0 2 9 , M 3 3, 9 8 4 , 8 ~ 8 3, 9 3 8 , 8 5 2 3, 8 6 5 , 6 9 1 31 7 9 8 , 2 0 6 3, 7 7 2 , 6 3 5 3, 7 2 1 , 8 6 9 3, 7 0 5 , 8 1 2 3, 7 4 0 , 8 2 1 3, 7 6 1 p 6 5 2 (D ) Ye a r - t o - D a t e Ba l a n c e , A / C 2 8 2 , Ac c u m . D e f . I n c . Ta x e s ( S t a t e ) , Li b e r a l i z e d De p r e c i a t i o p ( C R ) $ ( 1 , 4 7 4 1 2 4 4 ) (1 1 4 8 3 1 3 2 7 ) (1 , 4 5 7 , 9 7 1 ) (1 , 4 6 4 , 6 2 7 ) (1 , 4 7 1 , 2 7 0 ) (1 , 4 7 7 , 8 2 5 ) (1 , 4 8 4 , 2 4 7 ) (1 , 4 9 0 , 6 3 7 ) (1 , 4 9 7 , 2 0 3 ) (1 1 5 0 4 , 0 8 7 ) (1 , 5 1 1 , 3 0 2 ) (1 , 5 1 8 , 6 6 2 ) (1 , 5 2 5 1 6 2 5 ) (E ) 4/ 5 o f Ba l a n c è o f Co l u m n ( D ) $ ( 1 , 1 7 9 , 3 9 5 ) (1 , 1 8 6 , 6 6 1 ) (l , 1 6 6 , 3 7 6 ) (1 , 1 7 1 , 7 0 1 ) (1 , 1 7 7 , 0 1 6 ) (1 1 1 8 2 , 2 6 0 ) (1 , 1 8 7 , 3 9 7 ) (1 1 1 9 2 , 5 0 9 ) (1 , 1 9 7 , 7 6 2 ) (1 , 2 0 3 , 2 6 9 ) (1 , 2 0 9 1 0 4 1 ) (1 , 2 1 4 1 9 2 9 ) (1 1 2 2 0 1 5 0 0 ) (F ) Ye a r - t o - D a t e Ba l a n c e , A / C 2 8 2 Ac c u m . D e f e r r e d In c . T a x e s ( F e d . ) Li b e r a l i z e d De p r e c i a t i o n ( C R ) $( 9 , 9 0 4 , 8 1 2 ) ( 9 , 9 6 4 , 9 1 5 ) ( 9 , 7 9 7 , 1 3 5 ) ( 9 , 8 4 1 , 1 8 1 ) ( 9 , 8 8 5 t 1 3 9 ) ( 9 , 9 2 8 1 5 1 1 ) ( 9 , 9 7 1 , 0 0 3 ) (1 0 , 0 1 3 , 2 8 7 ) (1 0 , 0 5 6 , 7 3 0 ) (1 0 1 1 0 2 , 2 8 2 ) (1 0 1 1 5 0 , 0 2 2 ) (1 0 1 1 9 8 , 7 2 4 ) (1 0 1 2 4 4 , 7 9 8 ) (G ) Ne t A c c u m . D e f . In c o m e T a x e s ( C R ) Co l u m s ( E + F ) Le s s ( B + C ) $( 6 , 6 0 2 , 2 5 1 ) (6 , 6 3 8 , 6 8 1 ) ( 6 , 4 6 9 , 4 1 0 ) (6 , 4 9 6 , 3 0 5 ) (6 , 5 9 5 , 5 4 2 ) (6 , 6 9 5 , 7 0 4 ) (6 , 8 2 5 1 3 4 0 ) (6 , 9 4 8 1 3 7 9 ) (7 , 0 2 5 , 7 4 0 ) (7 , 1 3 3 , 7 0 2 ) (7 1 2 0 5 , 2 1 3 ) (7 , 2 2 0 , 5 6 0 ) (7 , 2 4 8 , 8 5 5 ) Av e r a g e D e f e r r e d I n c o m e T a x e s (H ) 13 - M o n t h Av e r a g e Ba l a n c e $ ( 6 , 6 2 0 , 4 6 6 ) ( 6 , 5 5 4 , 0 4 6 ) ( 6 , 4 8 2 , 8 5 8 ) ( 6 , 5 4 5 , 9 2 4 ) ( 6 , 6 4 5 1 6 2 3 ) ( 6 , 7 6 0 , 5 2 2 ) ( 6 , 8 8 6 1 8 6 0 ) ( 6 , 9 8 7 1 0 6 0 ) ( 7 , 0 7 9 , 7 2 1 ) ( 7 1 1 6 9 ; 4 5 8 ) ( 7 , 2 1 2 , 8 8 7 ) ( 7 , 2 3 4 , 7 0 8 ) $( 8 2 1 1 8 0 1 1 3 3 ) :- 1 2 $( 6 , 8 A 8 , 3 4 4 ) INTERMOUNAIN GAS COMPAN Cost of Gas Staff Normalized Therm Sales Volumes Purchased at Reduced Contract Demand Levels with Northwest Pipeline (A) 1 2 3 4 Purchase Requirements: Gas Sales Company Use Unaccounted-for Gas Total Therms 5 6 7 8 9 10 11 12 13 ODL - Demand ODL - Commodity SGS - Demand SGS - Seasonal Demand SGS - Commodity LSI - Demand LSI - Capacity LSI - Liquefaction LSI - Vaporization 1 1130,235 237, 645 ~ 768 305,704 11 ~0051000 11 1005 ,000 720;000 7,705,200 1,877,000 1,877 ,000 14 15 Actual Cost of Gas for Test Year Ended July 31, 1982 248,650,76S 16 Normaliz~tion Adjustment . (B) .15680 .42562 .15300 .01069 .42772 .03376' .' .03854 .01092 .00410 (e) 246,1791594 471,174 2,000,000 Z4S ..650, 16§, $ 2,1261650 101 i 146, 792 327,409 , 823,504 4,7071059 291,684 3,563,500 20,497 7,696 $ 113,014,791 118,544,958 $( 5,530,167) INTRMOUNTAIN GAS COMPAN CASE NUBER U-I034-99 Staff 'Exhibit No. 102 Schedule 3 Marian Hylen INTERMOUNTAIN GAS COMPAN Staff Adjustments to Test Year Test Year Operation & Maintenance Expenses 1 Salaries and Wages 2 Employee Non-Union Pension Expense 3 Group Insurance Expense 4 Other Insurance Expense 5 Regulatory Commission Expense 6 *Provision for Bad Debts: Adjusted Test Year Sales Revenue Actual Gross Operating Revenues for Test Year Ended July 31, 1981 Adjustment Required ,7 Removal of Amortization of Deferred Bad Debt Expense to Properly Match Revenues Stated at April 1, 1982 Rates 8 *Weatherization & Financing Program Expenses: A. Weatherization Expense B. Water Heater & Retrofit Rebate Program C. Other Financing & Administrative Expenses 9 *Refund of. C & K Exploration Advances: Staff NormaUzed Therm Sales Level. Refund Rate Test Year As Adjusted Test Year Ended July 31, 1982 Adjustment Required 10 *Price Level Adjustment Total O&M Expense for 12 Months Ended 7/31/82 $ O&M Expenses Separately Adjusted O&M Expenses Not Separately Adjusted Industry Association & Chamber of Commerce Dues & Expenses Total Price Level Factor Adjustment Required 11 Conference Center Adjustment 12 Amortization of Underground Storage Study Write..Off 13 Total 0 & M Expense Adjustment *Adjustments which differ from those proposed by Intermountain Gas Company. (A) $147,000,000 x .006 $882,000 $149 i 792,048 x .006 $898,752 $ 246,179,594x .00088 $( 2161638) $( 204,612) 14,001,644 10,138,690 3,862 i 954 127,676 $ 3, 735 ~278x .025 (B) $ 606,795 291033 341201 ( 2~242) 10,207 ( 16,700) (365,952) ( 7,875) 250~OOO ~o.. ( 12¡¡026) 93,382 ( 14,080) 17 , 161 $ 621.904 INTERMOUNAIN GAS COMPAN CASE NUBER U-I034-99 Staff Exhibit No. 102 Schedule 4 Madan Hylen 1l i:o.,..p10 Nr- CX :: C'u _r- IOU _("s.o ~ .p r-U :: 10 r-w."0 .p ClZ i: "0.. Cl i:c: E LiI- .pZ Vl s.:: :: 10o ... Cl~ ~::Li .pi- r- VIZ Cl Cl.. ~ I- Cl-o s.oCl w.u.,.s.a. ::z:c:a.:Eou V' ë3 INTERMOUNTA IN GAS CO. CASE NO. U-I034-99 Staff Exh. No. 102 Schedule 5 - Marian Hylen : -.... -:i -c... -w... Li.. -c:.. xVI Cls. "0Cl i:u..:: "0 Clo us. .,.a. s.a.-u.. co..s.o.p .p 10.,. r-U t+ .,. Clr- c:0.E Cl.. u.,.s.a.c:.. xCl"0i:.. ClU.,.s.a. VIs. ClE:: VIi:ou :~~ IoCl r- Cl:: VI ~ r- 10 c: VlE Cl VI ~ ~ r- -or-c: ..~ Cl~ VIOl .. Cl 10s. "0 E.ieu 0 0 ui: o:i s.Li w. æ .. t+M 0 X Cl~~'"r- i: :: VI .. r- 10 Ol"0 i: Cl vi.,..i "0 "0 "0VlO::O.,. or- 0i:c. uw..,. xw. Li .- t+(" 0 X Cl~~"Or- i::: VI.. r- 10 r-.. Vl 10 '" '" Vl.poi:uo 0 10 ~i- (! V' r-ßoi- o: a .. \0a a_ .- ~ \0a..N (" .. (" \0.. "N N 1..N("N o: 1.. o: \0(" ("N N VI ClU \0.N N_(" .,.~s. ClV' CXa(" a o:a.. (" ¡:N N 1...N o: 1. Ø' i. .-1. o: (" (" ("a a a 0 a.- _ _ .. _ (" \0 N CX a N.. CX CXN N N o: 1. (" o:CX CXN N CX .. o: \0 0.NN.-aao 0 0 a 0_ _ .- .- .- N 1. CXN (" co o: 1. o: \0 .-. .CX C' .. N (" o: 1.(" (" o: o: o: o: o:NNNNNNN C'.\0.-(" o: o: C' o: 1. 1" ... .co _ N o: i. 1. CX_NNNNNN(" (" (" (" (" (" (" \0.("a.. CX C'N ..a a.. _ o: \0"N \Ô C' C'. .co a .... CX CXN N N C' (" " _ 1. o: o: (" (" Na a a a 0_ _ _ _ _ \0.N .-a.._o.- o:.. CXN o: \0C' _CX C'N N o " .. coo: o:N N CX 1. ~ ~(" (" \0.co N o::'N 0.. ..-NN._aa a p a 0_..__...-a.. a 0 .- .-("N_OCX co co CXN N N N .- .. N _o 0.- _ co .. o: 1. \0 co \0 o:.(" 1. \0 " CX C' a .-C' C' C' C' C' C' a a.. _ _ .. _ _ N N .. _ .- _ ..co CX co CX CXC' C' C' C' C'_ _ .- .- ..~ .p.r- Ol 0. .p :::: :: Cl u 0'" c: V' 0 Z _ N (" o: 1. _ NCX CXC' C'_ _ u i:Cl 10c: r- \0 .. (" C' _ aa a_ .- N CX N Na aN N N CXC'.. N N NCX CX coC' C' C'_ _ _ ..Clw. .s. s. ~~ .ê ~ co 0' a .-_ .. ~ a o:. .C' (" 1... co CXN N N " o: a a aa a a_ .. .- o: a co. . (" o: o:a a aN N N N~.- Cli:::r- N.- C'" (" o:. . . a ("("o: 0N.... o:.("C'N ("a1.N ~ ~(" (" a 0. (I 0o: N NNaN .-.. ~ _ ... . .1. N NNaN _".- -aNa -...- (" NcoC'.- ... .. ClVl Cl 10OLCOr- 10 10 s. VI .p Cl VIo :: Cl I- c: ..~r-::r- (".--= 1.1._ _ .. 1.1. .. N -a ..... ClOl 10s. Cl~c: ,... 1#. INTEROUNAIN GAS COMPAN Income Tax Calculation for the Staff-Proposed Adjusted Test Year (A)(B) 1 Operating Revenues 2 Operating Expenses (except Income Taxes) 3 Earnings Before Interest & Income Taxes Interest Charges: $ 143,203,382 - 134,749,892 $ 8,453,490 4 5 Rate Base Long-Term & Short-Term Debt Weighted Average Interest Cost $ 67,468,523 4.392% 6 7 State Taxable Income 8 Less: State Taxes ~. 6-1/2% 9 Federal Taxable Income 2,963,218 $ 514901272 356,868 $ 5.133,404 10 Federal Taxes ~ 46% Less: 11 Surtax Exemption 12 I.T. C. Amortization 13 Net Federal Tax 14 State Taxes 15 Amortization of Unfunded Future Tax Liability (Federal Portion = 3,761,653 + 18 Yrs. Remaining) 16 Income Taxes for Test Year as Adjusted 17 Income Taxes for Normalized Test Year 18 Adjustment $ 2,361,366 ( 19,875) ( 116,000) $ 2,225,491 356,868 208,981 $ 2,791,340 2,866,667 '$( 75,327) INTRMOUNAIN GAS COMPAN CASE NUBER U-I034-99 Staff Exhibit No. 102 Schedule 6 Marian Hylen