{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["RCS-4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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-4","index":0,"n_rows":68,"n_cols":13,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
["Deferred Taxes Related to Bonus Depreciation",null,null,null,null,null,null,null,null,null,null,null,"Exhibit No.__(RCS-04)"]
["Illustration of Accounting and Ratemaking Treatment",null,null,null,null,null,null,null,null,null,null,null,"Page 1 of 1"]
[]
["Line"]
["No.",null,"Description",null,"Amount",null,null,null,"Description",null,"Amount"]
[null,null,"Year 1:",null,null,null,null,null,"Year 2:"]
[1,null,"Plant in Service",null,6500000,null,null,null,"Plant in Service",null,6500000]
[{"$f":"A7+1","v":2},null,"Revenues",null,1000000,null,null,null,"Revenues",null,1200000]
[{"$f":"A8+1","v":3},null,"O&M Expenses",null,640000,null,null,null,"O&M Expenses",null,640000]
[4,null,"Plant Additions During Year",null,500000,null,null,null,"Plant Additions During Year",null,0]
[5,null,"Assume all qualifying for bonus depreciation",null,null,null,null,null,"Assume all qualifying for bonus depreciation"]
[6,null,"Bonus Depreciation",null,500000,null,null,null,"Bonus Depreciation",null,0]
[7,null,"Other Accelerated Depr.",null,300000,null,null,null,"Other Accelerated Depr.",null,340000]
[8,null,"Accelerated Depr. On pre-year 1 additions",null,null,null,null,null,"Accelerated Depr. On pre-year 1 additions"]
[9,null,"Book Depreciation",null,160000,null,null,null,"Book Depreciation",null,160000]
[10,null,"Straight-line on total plant",null,null,null,null,null,"Straight-line on total plant"]
[11]
[12,null,"Current FIT:",null,null,null,null,null,"Current FIT:"]
[13,null,"   Revenues",null,{"$f":"+E8","v":1000000},null,null,null,"   Revenues",null,{"$f":"+K8","v":1200000}]
[14,null,"   O&M",null,{"$f":"+E9","v":640000},null,null,null,"   O&M",null,{"$f":"+K9","v":640000}]
[15,null,"   Tax Depreciation",null,{"$f":"+E12+E13","v":800000},null,null,null,"   Tax Depreciation",null,{"$f":"+K12+K13","v":340000}]
[16,null,"Taxable Income (Loss) NOL Carry-forward",null,{"$f":"+E19-E20-E21","v":-440000},null,null,null,"Taxable Income (Loss) NOL Carry-forward",null,{"$f":"+K19-K20-K21","v":220000}]
[17,null,"Current FIT",null,0,null,null,null,"Loss Carry-Forward Used",null,-220000]
[18,null,null,null,null,null,null,null,"Net Taxable Income",null,0]
[19,null,null,null,null,null,null,null,"Current FIT:",null,0]
[20]
[21,null,"Deferred FIT",null,null,null,null,null,"Deferred FIT"]
[22,null,"   Tax Depreciation",null,800000,null,null,null,"   Tax Depreciation",null,340000]
[23,null,"   Book Depreciation",null,160000,null,null,null,"   Book Depreciation",null,160000]
[24,null,"Difference",null,{"$f":"E28-E29","v":640000},null,null,null,"Difference",null,{"$f":"K28-K29","v":180000}]
[25,null,"   x 35% tax rate",null,{"$f":"E30*0.35","v":224000},null,"Deferred FIT",null,"   x 35% tax rate",null,{"$f":"K30*0.35","v":62999.999999999993},null,"Deferred FIT"]
[26]
[27,null,"Excess Tax Depreciation",null,640000,null,1,null,"Total Loss Carry-forward Year 1",null,440000]
[28,null,"Tax Loss Carry-forward",null,-440000,null,{"$f":"E34/E33*-1","v":0.6875},null,"Loss Carry-forward Used Year 2",null,220000]
[29,null,"Deduction used in Year 1",null,{"$f":"E34+E33","v":200000},null,{"$f":"E35/E33","v":0.3125},null,"Percentage Loss Carry-Forward Used",null,{"$f":"K34/K33","v":0.5}]
[30]
[31,null,"Deferred FIT Expense Total",null,224000,null,1,null,"Deferred FIT Carry-forward Year 1",null,154000]
[32,null,"Deferred FIT Carry-Forward",null,{"$f":"E37*G34","v":154000},null,{"$f":"E38/E37","v":0.6875},null,"Deferred FIT Carry-forward Used Year 2",null,{"$f":"K35*K37","v":77000}]
[33,null,"Deferred FIT for Deductions Used in Year 1",null,{"$f":"E37*G35","v":70000},null,{"$f":"E39/E37","v":0.3125},null,"Remaining FIT Carry-forward Year 1",null,{"$f":"K37-K38","v":77000}]
[34,null,null,null,null,null,null,null,"FIT Carry-forward Year 2",null,63000]
[35]
[36,null,"Entries to record deferred income taxes",null,null,null,null,null,"Entries to record deferred income taxes"]
[37,null,null,null,"Debit",null,"Credit",null,null,null,"Debit",null,"Credit"]
[38,null,null,null,null,null,null,null,"Carry-forward Used"]
[39,null,"Deferred FIT Expense",null,224000,null,null,null,"Deferred FIT Expense",null,77000]
[40,null,"   ADIT",null,null,null,224000,null,"   Deferred FIT Asset",null,null,null,77000]
[41]
[42,null,"Deferred FIT Asset",null,154000,null,null,null,"Year 2 Deferred FIT "]
[43,null,"   Deferred FIT Expense",null,null,null,154000,null,"Deferred FIT Expense",null,63000]
[44,null,null,null,null,null,null,null,"   ADIT",null,null,null,63000]
[45]
[46,null,null,null,null,null,null,null,"Deferred FIT Asset",null,63000]
[47,null,null,null,null,null,null,null,"   Deferred FIT Expense",null,null,null,63000]
[48]
[49,null,null,null,"Debit",null,"Credit",null,null,null,"Debit",null,"Credit"]
[50,null,"2 year cumulative balances"]
[51,null,"   ADIT Year 1",null,null,null,224000,null,"Deferred FIT Expense Year 1",null,224000]
[52,null,"   ADIT Year 2",null,null,null,63000,null,"Deferred FIT Expense Year 1",null,null,null,154000]
[53]
[54,null,"   Deferred FIT Asset Year 1",null,154000,null,null,null,"Deferred FIT Expense Year 2",null,77000]
[55,null,"   Deferred FIT Asset Year 2",null,null,null,77000,null,"Deferred FIT Expense Year 2",null,63000]
[56,null,"   Deferred FIT Asset Year 2",null,63000,null,null,null,"Deferred FIT Expense Year 2",null,null,null,63000]
[57]
[58,null,"Total",null,{"$f":"SUM(E57:E62)","v":217000},null,{"$f":"SUM(G57:G62)","v":364000},null,null,null,{"$f":"SUM(K57:K62)","v":364000},null,{"$f":"SUM(M57:M62)","v":217000}]
[59,null,null,null,null,null,null,null,"Net Income Statement Impact  "]
[60,null,"Net balance sheet impact (net ADIT)",null,null,null,{"$f":"G64-E64","v":147000},null,"   Net Deferred FIT Expense",null,{"$f":"K64-M64","v":147000}]
[]
["Source:  Original illustration similar to this was from a presentation by a KPMG representative at the NARUC 2011 Fall Accounting Conference in Denver, CO"]