{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["RCS-3","Exhibit No. ___(MRM-7)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":110,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"RCS-3","index":0,"n_rows":28,"n_cols":14,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Puget Sound Energy, Inc",null,null,null,null,null,null,null,"Exhibit No.__(RCS-03)"]
["Test Year Ending December 31, 2010",null,null,null,null,null,null,null,"Page 1 of 1"]
[]
["Adjustment to Reflect Impact of 2008 Tax Accounting Method Change for Repairs"]
["And Related Tax Accounting Method Change for Retirements"]
[]
[]
["Line",null,null,null,"Electric",null,"Gas",null,"Utility"]
["No.",null,"Description/Account",null,"Utility",null,"Utility",null,"Total"]
[null,null,null,null,"(A)",null,"(B)",null,"(C)"]
[]
[1,null,{"$f":"'Exhibit No. ___(MRM-7)'!U38","v":"Account 282 Repairs"},null,{"$f":"'Exhibit No. ___(MRM-7)'!V38","v":41842224.612499997},null,{"$f":"'Exhibit No. ___(MRM-7)'!W38","v":24996849.28125},null,{"$f":"E12+G12","v":66839073.893749997}]
[{"$f":"A12+1","v":2},null,{"$f":"'Exhibit No. ___(MRM-7)'!U39","v":"Account 282 Retirements"},null,{"$f":"'Exhibit No. ___(MRM-7)'!V39","v":-427902.80622836499},null,{"$f":"'Exhibit No. ___(MRM-7)'!W39","v":-432550.90029216761},null,{"$f":"E13+G13","v":-860453.70652053261},null,null,null,"cross foot","difference"]
[{"$f":"A13+1","v":3},null,{"$f":"'Exhibit No. ___(MRM-7)'!U40","v":"Total Repairs/Retirements"},null,{"$f":"SUM(E12:E13)","v":41414321.806271635},null,{"$f":"SUM(G12:G13)","v":24564298.380957831},null,{"$f":"SUM(I12:I13)","v":65978620.187229462},null,null,null,{"$f":"E14+G14","v":65978620.187229469},{"$f":"M14-I14","v":0}]
[]
[{"$f":"A14+1","v":4},null,"Account 282, Accumulated Deferred Income Taxes ",null,{"$f":"E14","v":41414321.806271635},null,{"$f":"G14","v":24564298.380957831},null,{"$f":"I14","v":65978620.187229462}]
[]
[{"$f":"A16+1","v":5},null,"Staff Adjustment (Decrease) to PSE's proposed Rate Base",null,{"$f":"-E16","v":-41414321.806271635},null,{"$f":"-G16","v":-24564298.380957831},null,{"$f":"-I16","v":-65978620.187229462}]
[]
[]
["Notes and Source"]
["PSE Exhibit No. ___(MRM-7) and related PSE workpapers"]
["This adjustment reflects the rate base impact for the amounts for repairs and retirements tax deductions that PSE has reflected on its books for the"]
["test year, on an average of monthly averages basis, as net credit balances in Account 282.  PSE proposes to not deduct these known test year"]
["balances from rate base based on its position that an IRS audit of its repairs deductions for tax years 2008, 2009 and 2010 must first be completed"]
["before these amounts are recognized for ratemaking purposes.  Account 282 balances for repairs deductions represent cost-free capital which"]
["should be deducted from PSE's rate base in the current case.  Staff's adjustment treats the known and measurable rate base impacts occurring"]
["during the test year appropriately by deducting the Account 282 balances from rate base, whereas PSE's proposal does not."]

{"sheet":"Exhibit No. ___(MRM-7)","index":1,"n_rows":68,"n_cols":26,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[null,"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P"]
[null,"Account","Account Description","2009-12-31","2010-01-31","2010-02-28","2010-03-31","2010-04-30","2010-05-31","2010-06-30","2010-07-31","2010-08-31","2010-09-30","2010-10-31","2010-11-30","2010-12-31","AMA (Dec-10)"]
[1,"Actual SAP Balances"]
[3,19000433,"NOL Carryforward",0,0,0,0,0,0,0,0,0,70817091.530000001,70817091.530000001,70817091.530000001,98908317.530000001,{"$f":"SUM(D5+P5+SUM(E5:O5)*2)/24","v":21825452.779583335}]
[4,23600033,"Federal Income Taxes Payable",98112731.530000001,92228778.530000001,72430586.180000007,66949893.18,66533456.18,64798721.689999998,84598984.040000021,85402640.040000021,93450728.040000021,57043858.530000001,58417376.759999998,49481109.509999998,60744622.509999998,{"$f":"SUM(D6+P6+SUM(E6:O6)*2)/24","v":72563734.141666666}]
[5,28200002,"DFIT - Gas Plant",-286369100.67000002,-287499100.67000002,-288634100.67000002,-289543100.67000002,-290599100.67000002,-291631100.67000002,-292311100.67000002,-293301100.67000002,-294291100.67000002,-307378217.67000002,-308981767.67000002,-310585317.67000002,-330789143.67000002,{"$f":"SUM(D7+P7+SUM(E7:O7)*2)/24","v":-296944519.2116667}]
[6,28200121,"DFIT - Electric Plant",-726234885.41999996,-729898885.41999996,-733562885.41999996,-736902981.41999996,-742864585.41999996,-746592690.41999996,-753833489.41999996,-758031935.41999996,-762230381.41999996,-814719157.41999996,-823429880.41999996,-832140603.41999996,-848068474.41999996,{"$f":"SUM(D8+P8+SUM(E8:O8)*2)/24","v":-768446596.29499996}]
[7,"subtotal",null,{"$f":"SUM(D5:D8)","v":-914491254.55999994},-925169207.55999994,-949766399.90999997,-959496188.90999997,-966930229.90999997,-973425069.39999998,-961545606.04999995,-965930396.04999995,-963070754.04999995,-994236425.02999997,-1003177179.8,-1022427720.05,-1019204678.05,{"$f":"SUM(Q5:Q8)","v":-971001928.58541667}]
[8]
[9,"STEP 1:  Extract the NOL C/F from the Tax Payable/Receivable Account and Restate Both Balances"]
[10,"Reconstruct the Tax Payable Balance for 2010"]
[11,23600033,"Federal Income Taxes Payable ORIGINAL",98112731.530000001,92228778.530000001,72430586.180000007,66949893.18,66533456.18,64798721.689999998,84598984.040000021,85402640.040000021,93450728.040000021,57043858.530000001,58417376.759999998,49481109.509999998,60744622.509999998]
[12,23600033,"Federal Income Taxes Payable REVISED",98112731.530000001,{"$f":"+D14-32330860+E13-D13","v":59897918.530000001},{"$f":"+E14+F13-E13","v":40099726.180000007},34619033.180000007,34202596.180000015,32467861.690000005,52268124.040000021,53071780.040000021,61119868.040000021,60744623,{"$f":"+M14","v":60744623},{"$f":"+N14","v":60744623},{"$f":"+O14","v":60744623}]
[13,"Difference is activity to the NOL in 2010",null,{"$f":"+D13-D14","v":0},32330860,32330860,32330859.999999993,32330859.999999985,32330859.999999993,32330860,32330860,32330860,-3700764.4699999988,-2327246.2400000021,-11263513.490000002,-0.49000000208616257]
[14]
[15,19000433,"NOL Carryforward ORIGINAL",0,0,0,0,0,0,0,0,0,70817091.530000001,70817091.530000001,70817091.530000001,98908317.530000001]
[16,"Difference from the Taxes Payable",null,{"$f":"+D15","v":0},32330860,32330860,32330859.999999993,32330859.999999985,32330859.999999993,32330860,32330860,32330860,-3700764.4699999988,-2327246.2400000021,-11263513.490000002,-0.49000000208616257]
[17,19000433,"NOL Carryforward REVISED",{"$f":"SUM(D17:D18)","v":0},32330860,32330860,32330859.999999993,32330859.999999985,32330859.999999993,32330860,32330860,32330860,67116327.060000002,68489845.289999992,59553578.039999999,98908317.039999992]
[18]
[19,"STEP 2:  Adjust NOL Carryforward to Remove Repairs/Reirement Method Changes"]
[20,19000433,"NOL Carryforward REVISED",{"$f":"+D19","v":0},32330860,32330860,32330859.999999993,32330859.999999985,32330859.999999993,32330860,32330860,32330860,67116327.060000002,68489845.289999992,59553578.039999999,98908317.039999992]
[21]
[22,"Remove Repairs",null,null,-248000,-496000,-744000,-992000,-1240000,-1488000,-1736000,-1984000,-1046334.95,-1161993.5,-1277652.05,-531293.15,{"$f":"SUM(D24+P24+SUM(E24:O24)*2)/24","v":-1056635.5895833333}]
[23,"Remove Retirements",null,null,null,null,546875,729166.55,772948.75,927538.52039268531,1082128.2907853706,1236718.0611780561,1391307.8315707413,1545897.6019634265,1700487.3723561119,784753,860453.70652053261]
[24,"Total Repairs/Retirements Removed",null,{"$f":"SUM(D24:D25)","v":0},-248000,-496000,-197125,-262833.44999999995,-467051.25,-560461.47960731469,-653871.70921462937,-747281.93882194394,344972.8815707413,383904.10196342645,422835.32235611184,253459.84999999998,-196181.88306280071]
[25,19000433,"NOL Carryforward",{"$f":"+D22+D26","v":0},32082860,31834860,32133734.999999993,32068026.549999986,31863808.749999993,31770398.520392686,31676988.290785372,31583578.061178055,67461299.941570744,68873749.391963422,59976413.362356111,99161776.889999986]
[26]
[27,"STEP 3:  Adjust Taxes Payable Balance to Remove Repirs/Retirements Method Changes"]
[28,23600033,"Federal Income Taxes (from above)",{"$f":"+D14","v":98112731.530000001},59897918.530000001,40099726.180000007,34619033.180000007,34202596.180000015,32467861.690000005,52268124.040000021,53071780.040000021,61119868.040000021,60744623,60744623,60744623,60744623]
[29]
[30,"Remove Repairs",null,-19046784.396242242,-19046784.396242242,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-3514566.6962422421,-3514566.6962422421,-3514566.6962422421,-3514566.6962422421,{"$f":"SUM(D32+P32+SUM(E32:O32)*2)/24","v":-5138137.4004089097}]
[31,"Remove Retirements",null,null,null,null,0,0,0,0,0,0,0,0,0,0,0]
[32,"Total Repairs/Retirements Removed",null,{"$f":"SUM(D32:D33)","v":-19046784.396242242},-19046784.396242242,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-2969498.3962422423,-3514566.6962422421,-3514566.6962422421,-3514566.6962422421,-3514566.6962422421,-5138137.4004089097]
[33,23600033,"Federal Income Taxes",{"$f":"+D30+D34","v":79065947.133757755},40851134.133757755,37130227.783757761,31649534.783757765,31233097.783757772,29498363.293757763,49298625.643757775,50102281.643757775,58150369.643757775,57230056.303757757,57230056.303757757,57230056.303757757,57230056.303757757,null,null,null,null,"Increase (Reduction) to ADIT/Reduction (Increase) to Rate Base"]
[34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"From Tax Accounting Method Changes for Repairs and Retirements"]
[35,"STEP 4:  Remove Repairs/Retirement Changes from Electric Deferred Tax Balance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Electric","Gas","Total"]
[36,"Remove Repairs - Electric",null,41211889.899999999,41330889.899999999,41449889.899999999,41568889.899999999,41687889.899999999,41806889.899999999,41925889.899999999,42044889.899999999,42163889.899999999,42156185.699999996,42208219,42260250.499999993,41793952,{"$f":"SUM(D38+P38+SUM(E38:O38)*2)/24","v":41842224.612499997},null,null,null,"Account 282 Repairs",{"$f":"Q38","v":41842224.612499997},{"$f":"V43","v":24996849.28125},{"$f":"V38+W38","v":66839073.893749997},null,{"$f":"V38/(10^6)","v":41.842224612499997}]
[37,"Remove Retirements - Electric",null,null,null,null,-323904,-431872,-367767.4,-441320.89403525623,-514874.38807051245,-588427.88210576866,-661981.37614102487,-735534.87017628108,-809088.36421153729,-520125,-427902.80622836499,null,null,null,"Account 282 Retirements",{"$f":"Q39","v":-427902.80622836499},{"$f":"V44","v":-432550.90029216761},{"$f":"V39+W39","v":-860453.70652053261}]
[38,"Total Repairs/Retirements Removed",null,{"$f":"SUM(D38:D39)","v":41211889.899999999},41330889.899999999,41449889.899999999,41244985.899999999,41256017.899999999,41439122.5,41484569.005964741,41530015.51192949,41575462.017894231,41494204.323858969,41472684.129823722,41451162.135788456,41273827,41414321.806271635,null,null,null,"Total Repairs/Retirements",41414321.806271635,{"$f":"SUM(W38:W39)","v":24564298.380957831},{"$f":"SUM(X38:X39)","v":65978620.187229462}]
[39,28200121,"DFIT - Electric Plant",{"$f":"+D8+D40","v":-685022995.51999998},-688567995.51999998,-692112995.51999998,-695657995.51999998,-701608567.51999998,-705153567.91999996,-712348920.4140352,-716501919.90807045,-720654919.40210569,-773224953.09614098,-781957196.29017627,-790689441.28421152,-806794647.41999996]
[40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gas Utility Increase (Reduction) to ADIT/Reduction to Rate Base"]
[41,"STEP 5:  Remove Repairs/Retirement Changes from Gas Deferred Tax Balance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Account 282 Repairs - Gas",{"$f":"Q44","v":24996849.28125}]
[42,"Remove Repairs - Gas",null,24411570.050000001,24540570.050000001,24669570.050000001,24798570.050000001,24927570.050000001,25056570.050000001,25185570.050000001,25314570.050000001,25443570.050000001,25058677.5,25122303.649999999,25185929.800000001,24905870,{"$f":"SUM(D44+P44+SUM(E44:O44)*2)/24","v":24996849.28125},null,null,null,"Account 282 Retirements - Gas",{"$f":"Q45","v":-432550.90029216761},null,null,null,{"$f":"V43/(10^6)","v":24.99684928125}]
[43,"Remove Retirements - Gas",null,null,null,null,-222971,-297294.55,-405181.35,-486217.62635742908,-567253.90271485818,-648290.17907228728,-729326.45542971638,-810362.73178714549,-891399.00814457459,-264628,-432550.90029216761,null,null,null,"Total Repairs/Retirements - Gas",{"$f":"Q46","v":24564298.380957831}]
[44,"Total Repairs/Retirements Removed",null,{"$f":"SUM(D44:D45)","v":24411570.050000001},24540570.050000001,24669570.050000001,24575599.050000001,24630275.5,24651388.699999999,24699352.423642572,24747316.147285141,24795279.870927714,24329351.044570282,24311940.918212853,24294530.791855425,24641242,24564298.380957831]
[45,28200002,"DFIT - Gas Plant",{"$f":"+D7+D44+D45","v":-261957530.62},-262958530.62,-263964530.62,-264967501.62,-265968825.17000002,-266979711.97,-267611748.24635744,-268553784.52271485,-269495820.79907227,-283048866.62542975,-284669826.75178719,-286290786.87814456,-306147901.67000002]
[46]
[52]
[53,"Revised Balances"]
[55,19000433,"NOL Carryforward",{"$f":"+D27","v":0},{"$f":"+E27","v":32082860},{"$f":"+F27","v":31834860},32133734.999999993,32068026.549999986,31863808.749999993,31770398.520392686,31676988.290785372,31583578.061178055,67461299.941570744,68873749.391963422,59976413.362356111,99161776.889999986,{"$f":"SUM(D51+P51+SUM(E51:O51)*2)/24","v":41742217.192770533},"a"]
[56,"19000433.1","NOL Carryforward Repairs/Retirement",{"$f":"-D26","v":0},{"$f":"-E26","v":248000},{"$f":"-F26","v":496000},197125,262833.44999999995,467051.25,560461.47960731469,653871.70921462937,747281.93882194394,-344972.8815707413,-383904.10196342645,-422835.32235611184,-253459.84999999998,196181.88306280071]
[57,23600033,"Accrued Federal Income Taxes Payable",{"$f":"+D35","v":79065947.133757755},{"$f":"+E35","v":40851134.133757755},37130227.783757761,31649534.783757765,31233097.783757772,29498363.293757763,49298625.643757775,50102281.643757775,58150369.643757775,57230056.303757757,57230056.303757757,57230056.303757757,57230056.303757757,47312650.445007764,"b"]
[58,23600033.100000001,"Federal Income Taxes Repairs/Retiremnt",{"$f":"-D34","v":19046784.396242242},{"$f":"-E34","v":19046784.396242242},2969498.3962422423,2969498.3962422423,2969498.3962422423,2969498.3962422423,2969498.3962422423,2969498.3962422423,2969498.3962422423,3514566.6962422421,3514566.6962422421,3514566.6962422421,3514566.6962422421,5138137.4004089097]
[59,28200002,"DFIT - Gas Plant",{"$f":"+D47","v":-261957530.62},{"$f":"+E47","v":-262958530.62},-263964530.62,-264967501.62,-265968825.17000002,-266979711.97,-267611748.24635744,-268553784.52271485,-269495820.79907227,-283048866.62542975,-284669826.75178719,-286290786.87814456,-306147901.67000002,-272380220.83070886,"a"]
[60,"28200002.1","DFIT - Gas Plant Repairs/Retirement",{"$f":"-D46","v":-24411570.050000001},{"$f":"-E46","v":-24540570.050000001},-24669570.050000001,-24575599.050000001,-24630275.5,-24651388.699999999,-24699352.423642572,-24747316.147285141,-24795279.870927714,-24329351.044570282,-24311940.918212853,-24294530.791855425,-24641242,-24564298.380957831,"c"]
[61,28200121,"DFIT - Electric Plant",{"$f":"+D41","v":-685022995.51999998},{"$f":"+E41","v":-688567995.51999998},-692112995.51999998,-695657995.51999998,-701608567.51999998,-705153567.91999996,-712348920.4140352,-716501919.90807045,-720654919.40210569,-773224953.09614098,-781957196.29017627,-790689441.28421152,-806794647.41999996,-727032274.48872817,"a"]
[62,"28200121.1","DFIT - Electric Plant Repairs/Retirement",{"$f":"-D40","v":-41211889.899999999},{"$f":"-E40","v":-41330889.899999999},-41449889.899999999,-41244985.899999999,-41256017.899999999,-41439122.5,-41484569.005964741,-41530015.51192949,-41575462.017894231,-41494204.323858969,-41472684.129823722,-41451162.135788456,-41273827,-41414321.806271635,"c"]
[63,null,null,{"$f":"SUM(D50:D58)","v":-914491254.55999994},{"$f":"SUM(E50:E58)","v":-925169207.55999994},-949766399.90999997,-959496188.90999997,-966930229.90999997,-973425069.39999998,-961545606.04999995,-965930396.04999995,-963070754.04999995,-994236425.02999997,-1003177179.8,-1022427720.05,-1019204678.05,{"$f":"SUM(Q50:Q58)","v":-971001928.58541656}]
[64,"Net Difference",null,{"$f":"+D9-D59","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"ADIT Deferred Taxes reflected in rate base by PSE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q57+Q55+Q51","v":-957670278.12666655},"a"]
[null,"Debit balance in account 236 reflected by PSE as a rate base addition for working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q53","v":47312650.445007764},"b"]
[]
[null,"Staff recommended rate base adjustments:"]
[null,"Reflect ADIT in account 282 related to repairs and retirements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q58+Q56","v":-65978620.187229469},"c"]
[null,"Remove debit balance in account 236 reflected by PSE as a rate base addition for working capital",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-Q64","v":-47312650.445007764},"-b"]