{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Muni.Tax- E","3.04 E","3.05 G","Annual Filing Fee","Pub Util Tax"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":5,"defined_names":2890,"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":"Muni.Tax- E","index":0,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[[2,5,2,7],[0,7,0,9]]}
[null,null,null,null,null,"Energy","E","Ordinance City Tax Rate =",null,null,0.06]
[]
["Total Bill Excluding City Tax and City Tax Related Additional Revenue",null,null,1000,null,"Calculated Grossed-up City Tax Rate =",null,null,6.070057578742994E-2]
["City Tax and City Tax Related Additional Revenue",null,null,{"$f":"ROUND(D3*I14,2)","v":60.7}]
["Gross Taxable Revenue",null,null,{"$f":"D3+D4","v":1060.7},null,null,null,"Electric State Utility Tax Rate =",{"$f":"+'Pub Util Tax'!D3","v":3.8733999999999998E-2}]
[null,null,null,null,null,null,null,"Natural Gas State Utility Tax Rate =",{"$f":"+'Pub Util Tax'!D4","v":3.8519999999999999E-2}]
["Allowed City Tax Deductions",null,null,null,null,null,null,"State Utility Tax Rate w/ Loss Adjustment =",{"$f":"IF(G1=\"E\",($I$5-($I$5*$I$12)),($I$6-($I$6*$I$11)))","v":3.8405574413999999E-2}]
["Credit Losses",null,"N",{"$f":"IF(C8=\"Y\",D5*I10,0)","v":0},null,null,null,"State Filing Fee Rate =",{"$f":"+'Annual Filing Fee'!A1","v":2E-3}]
["State Utility Tax",null,"Y",{"$f":"IF(C9=\"Y\",D5*I7,0)","v":40.736792780929804},null,null,null,"State Filing Fee w/ Loss Adjustment =",{"$f":"$I$8-($I$8*$I$10)","v":1.983042E-3}]
["State Filing Fee",null,"N",{"$f":"IF(C10=\"Y\",D5*I9,0)","v":0},null,null,null,"Bad Debts Rate =",{"$f":"+SUMIF($H$11:$H$12,G1,I11:I12)","v":8.4790000000000004E-3}]
["City Tax",null,"Y",{"$f":"IF(C11=\"Y\",D4-D4*I7-D4*I9-D4*I10,0)","v":57.733735683670197},null,null,null,"G",{"$f":"+'3.05 G'!E13","v":5.1240000000000001E-3}]
["Total Deductions",null,null,{"$f":"SUM(D8:D11)","v":98.470528464599994},null,null,null,"E",{"$f":"+'3.04 E'!E14","v":8.4790000000000004E-3}]
[]
["Net City Tax Taxable Revenue",null,null,{"$f":"D5-D12","v":962.22947153540008},null,null,null,"Grossed-up City Tax Rate to Use in CLX = ",{"$f":"ROUND(I3,5)","v":6.0699999999999997E-2}]
["City Tax Payable",null,null,{"$f":"D14*K1","v":57.733768292124005}]
["Additional State Utility Tax due to City Tax",null,null,{"$f":"D4*I7","v":2.3312183669298001}]
["Additional State Filing Fee due to City Tax",null,null,{"$f":"D4*I8","v":0.12140000000000001}]
["Additional Credit Losses due to City Tax",null,null,{"$f":"D4*I10","v":0.51467530000000006}]
[null,null,null,null,null,null,"Y"]
["Total Cost due to City Tax",null,null,{"$f":"SUM(D15:D18)","v":60.701061959053803},null,{"$f":"ABS(IF(ROUND(F25,0)<>0,F25,0))+IF(ABS(ROUND(D22,0)-ABS(ROUND(F25,0)))=0,ABS(D22)+ABS(F25),0)+ABS(IF(ABS(D22)<>0,D22,0))","v":2.1565265614071905E-3},"N"]
[]
["Difference between collected and paid",null,null,{"$f":"+D4-D20","v":-1.0619590537999102E-3},{"$f":"+D22/D4","v":-1.7495206817131964E-5},"[Hit \"Refresh\" button until F25 and D22 are near zero]"]
[null,null,null,null,null,"[Manual adjustment of I3 is necessary in some cases]"]
[]
["Difference between City Tax Deduction and City Tax Paid",null,null,null,null,{"$f":"IF(C11=\"Y\",D11-D15,0)","v":-3.2608453807370097E-5}]
[]
["Difference in collection resulting from using SAP rate =",null,null,null,null,{"$f":"D20-(D3*I14)","v":1.0619590538070156E-3}]

{"sheet":"3.04 E","index":1,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,24,4],[1,0,1,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4]]}
[null,null,null,null,null,null,null,null,null,null,null,"As Used in UE-190529 and UG-190530"]
[]
[null,null,null,null,null,null,null,"PUGET SOUND ENERGY-ELECTRIC"]
[null,null,null,null,null,null,null,"CONVERSION FACTOR"]
[null,null,null,null,"Page 3.04",null,null,"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2018"]
[null,"PUGET SOUND ENERGY-ELECTRIC",null,null,null,null,null,"GENERAL RATE CASE"]
[null,"CONVERSION FACTOR - ELECTRIC"]
[null,null,null,null,null,null,null,"LINE"]
[null,null,null,null,null,null,null,"NO.","DESCRIPTION",null,null,"RATE"]
[]
["LINE",null,null,null,null,null,null,1,"BAD DEBTS",null,null,8.4790000000000004E-3]
["NO.","DESCRIPTION",null,null,"RATE",null,null,2,"ANNUAL FILING FEE",null,null,2E-3]
[null,null,null,null,null,null,null,3,{"$f":"\"STATE UTILITY TAX ( \"&K13*100&\"% - ( LINE 1 * \"&K13*100&\"% )  )\"","v":"STATE UTILITY TAX ( 3.8734% - ( LINE 1 * 3.8734% )  )"},null,3.8733999999999998E-2,{"$f":"ROUND(K13-(K13*L11),6)","v":3.8406000000000003E-2}]
[1,"BAD DEBTS",null,null,{"$f":"+L11","v":8.4790000000000004E-3},null,null,4]
[2,"ANNUAL FILING FEE",null,null,{"$f":"'Annual Filing Fee'!A1","v":2E-3},null,null,5,"SUM OF TAXES OTHER",null,null,{"$f":"ROUND(SUM(L11:L13),6)","v":4.8884999999999998E-2}]
[3,{"$f":"\"STATE UTILITY TAX - NET OF BAD DEBTS ( \"&D16*100&\"% - ( LINE 1 * \"&D16*100&\"%) )\"","v":"STATE UTILITY TAX - NET OF BAD DEBTS ( 3.8734% - ( LINE 1 * 3.8734%) )"},null,{"$f":"'Pub Util Tax'!D3","v":3.8733999999999998E-2},{"$f":"ROUND(D16-(D16*E14),6)","v":3.8406000000000003E-2},null,null,6]
[4,null,null,null,null,null,null,7,{"$f":"\"CONVERSION FACTOR EXCLUDING FEDERAL INCOME TAX ( 1 - LINE \"&$A$15&\" )\"","v":"CONVERSION FACTOR EXCLUDING FEDERAL INCOME TAX ( 1 - LINE 2 )"},null,null,{"$f":"ROUND(1-L15,6)","v":0.95111500000000004}]
[5,"SUM OF TAXES OTHER",null,null,{"$f":"ROUND(SUM(E14:E16),6)","v":4.8884999999999998E-2},null,null,8,"FEDERAL INCOME TAX",null,0.21,{"$f":"ROUND((L17)*K18,6)","v":0.19973399999999999}]
[6,null,null,null,null,null,null,9,{"$f":"\"CONVERSION FACTOR INCL FEDERAL INCOME TAX ( LINE \"&H17&\" - LINE \"&H18&\" ) \"","v":"CONVERSION FACTOR INCL FEDERAL INCOME TAX ( LINE 7 - LINE 8 ) "},null,null,{"$f":"L17-L18","v":0.75138100000000008}]
[7,"CONVERSION FACTOR EXCLUDING FEDERAL INCOME TAX ( 1 - LINE 5)",null,null,{"$f":"ROUND(1-E18,6)","v":0.95111500000000004}]
[8,"FEDERAL INCOME TAX ( LINE 7 * 21%)",null,0.21,{"$f":"ROUND((E20)*D21,6)","v":0.19973399999999999}]
[9,"CONVERSION FACTOR INCL FEDERAL INCOME TAX ( LINE 5 + LINE 8 ) ",null,null,{"$f":"ROUND(1-E21-E18,6)","v":0.75138099999999997}]
[]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"3.05 G","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,0,24,4],[1,0,1,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"As Used in UE-190529 and UG-190530"]
[null,null,null,null,null,null,null,null,"PUGET SOUND ENERGY-GAS (PER SETTLEMENT)"]
[null,null,null,null,null,null,null,null,"CONVERSION FACTOR"]
[null,null,null,null,"Page 3.05",null,null,null,"FOR THE TWELVE MONTHS ENDED DECEMBER 31, 2018"]
[null,"PUGET SOUND ENERGY-GAS",null,null,null,null,null,null,"GENERAL RATE CASE"]
[null,"CONVERSION FACTOR - GAS"]
[null,null,null,null,null,null,null,null,"LINE"]
[null,null,null,null,null,null,null,null,"NO.","DESCRIPTION",null,"RATE","AMOUNT"]
[]
["LINE",null,null,null,null,null,null,null,1,"BAD DEBTS",null,null,5.1240000000000001E-3]
["NO.","DESCRIPTION",null,null,"RATE",null,null,null,{"$f":"+I10+1","v":2},"ANNUAL FILING FEE",null,null,2E-3]
[null,null,null,null,null,null,null,null,3,{"$f":"\"STATE UTILITY TAX ( \"&L12*100&\"% - ( LINE 1 * \"&L12*100&\"% )  )\"","v":"STATE UTILITY TAX ( 3.852% - ( LINE 1 * 3.852% )  )"},null,3.8519999999999999E-2,{"$f":"ROUND(L12-(L12*M10),6)","v":3.8323000000000003E-2}]
[1,"BAD DEBTS",null,null,{"$f":"+M10","v":5.1240000000000001E-3},null,null,null,4]
[2,"ANNUAL FILING FEE",null,null,{"$f":"'Annual Filing Fee'!A1","v":2E-3},null,null,null,5,"SUM OF TAXES OTHER",null,null,{"$f":"SUM(M10:M13)","v":4.5447000000000001E-2}]
[3,{"$f":"\"STATE UTILITY TAX - NET OF BAD DEBTS ( \"&D15*100&\"% - ( LINE 1 * \"&D15*100&\"%) )\"","v":"STATE UTILITY TAX - NET OF BAD DEBTS ( 3.852% - ( LINE 1 * 3.852%) )"},null,{"$f":"'Pub Util Tax'!$D$4","v":3.8519999999999999E-2},{"$f":"ROUND(D15-(D15*E13),6)","v":3.8323000000000003E-2},null,null,null,6]
[4,null,null,null,null,null,null,null,7,"CONVERSION FACTOR EXCLUDING FEDERAL INCOME TAX ( 1 - LINE 5)",null,null,{"$f":"ROUND(1-M14,6)","v":0.95455299999999998}]
[5,"SUM OF TAXES OTHER",null,null,{"$f":"ROUND(SUM(E13:E15),6)","v":4.5447000000000001E-2},null,null,null,8,"FEDERAL INCOME TAX ( LINE 7 * 21%)",null,0.21,{"$f":"ROUND(M16*L17,6)","v":0.200456}]
[6,null,null,null,null,null,null,null,9]
[7,"CONVERSION FACTOR EXCLUDING FEDERAL INCOME TAX ( 1 - LINE 5)",null,null,{"$f":"ROUND(1-E17,6)","v":0.95455299999999998},null,null,null,10,"CONVERSION FACTOR",null,null,{"$f":"M16-M17","v":0.75409700000000002}]
[8,"FEDERAL INCOME TAX ( LINE 7 * 21%)",null,0.21,{"$f":"ROUND((E19)*D20,6)","v":0.200456}]
[9,"CONVERSION FACTOR INCL FEDERAL INCOME TAX ( LINE 5 + LINE 8 ) ",null,null,{"$f":"ROUND(1-E20-E17,6)","v":0.75409700000000002}]
[]
[]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Annual Filing Fee","index":3,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[2E-3,"Link updated as of 7/28/2020"]
["RCW 80.24.010","http://apps.leg.wa.gov/rcw/default.aspx?cite=80.24.010"]
[]
["Companies to file reports of gross revenue and pay fees — Delinquent fee payments.  "]
["Every public service company subject to regulation by the commission shall, on or before the "]
["date specified by the commission for filing annual reports under RCW 80.04.080, file with the "]
["commission a statement on oath showing its gross operating revenue from intrastate "]
["operations for the preceding calendar year or portion thereof and pay to the commission a "]
["fee equal to one-tenth of one percent of the first fifty thousand dollars of gross operating "]
["revenue, plus two-tenths of one percent of any gross operating revenue in excess of fifty "]
["thousand dollars: PROVIDED, That the commission may, by rule, set minimum fees that do "]
["not exceed the cost of collecting the fees. The commission may by rule waive any or all of "]
["the minimum fee established pursuant to this section."]
[]
["     The percentage rates of gross operating revenue to be paid in any year may be decreased "]
["by the commission for any class of companies subject to the payment of such fees, by "]
["general order entered before March 1st of such year, and for such purpose such companies "]
["shall be classified as follows:"]
[]
["     Electrical, gas, water, telecommunications, and irrigation companies shall constitute class "]
["one. Every other company subject to regulation by the commission, for which regulatory fees "]
["are not otherwise fixed by law shall pay fees as herein provided and shall constitute "]
["additional classes according to kinds of businesses engaged in."]
[]
["     Any payment of the fee imposed by this section made after its due date shall include a "]
["late fee of two percent of the amount due. Delinquent fees shall accrue interest at the rate "]
["of one percent per month."]
[]
["[2003 c 296 § 1; 1994 c 83 § 1; 1990 c 48 § 1; 1985 c 450 § 14; 1961 c 14 § 80.24.010. Prior: 1955 "]
["c 125 § 2; prior: 1939 c 123 § 1, part; 1937 c 158 § 1, part; 1929 c 107 § 1, part; 1923 c 107 § 1, part; "]
["1921 c 113 § 1, part; RRS § 10417, part.]"]
[]
["Notes:"]
["     Severability -- Legislative review -- 1985 c 450: See RCW 80.36.900 and 80.36.901."]
[" "]

{"sheet":"Pub Util Tax","index":4,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[43,0,44,14],[1,8,2,14]]}
["State Utility Tax",null,"Link updated as of 7/28/2020"]
["https://dor.wa.gov/find-taxes-rates/other-taxes/public-utility-tax"]
[null,null,"Electric",3.8733999999999998E-2]
[null,null,"Gas",3.8519999999999999E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+#REF!","v":{"$error":"#REF!"}}]