{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":36,"n_cols":15,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,9,31,14],[31,0,31,2],[31,3,31,8],[34,0,34,5],[34,6,34,8],[34,9,34,12],[34,13,34,14],[35,0,35,14],[32,0,32,2],[32,3,32,8],[32,9,32,14],[33,0,33,2],[33,3,33,8],[33,9,33,14],[29,0,29,2],[29,3,29,8],[29,9,29,14],[30,0,30,2],[30,3,30,8],[30,9,30,14],[25,2,25,4],[25,5,25,6],[25,7,25,9],[25,10,25,12],[26,0,26,4],[26,5,26,6],[26,7,26,13],[23,2,23,4],[23,5,23,6],[23,7,23,9],[23,10,23,12],[24,2,24,4],[24,5,24,6],[24,7,24,9],[24,10,24,12],[21,2,21,4],[21,5,21,6],[21,7,21,9],[21,10,21,12],[22,2,22,4],[22,5,22,6],[22,7,22,9],[22,10,22,12],[19,7,19,9],[19,10,19,12],[20,2,20,4],[20,5,20,6],[20,7,20,9],[20,10,20,12],[8,12,8,14],[13,12,13,14],[13,0,13,11],[16,2,16,4],[16,5,16,6],[16,7,16,9],[16,10,16,12],[9,7,9,10],[10,7,10,10],[11,7,11,10],[12,7,12,10],[8,7,8,10],[11,0,11,6],[11,12,11,14],[12,0,12,6],[12,12,12,14],[5,0,5,3],[2,4,2,7],[3,4,3,7],[4,4,4,7],[5,4,5,7],[0,0,0,14],[1,0,1,14],[2,0,2,3],[3,0,3,3],[4,0,4,3],[27,0,27,14],[28,0,28,14],[9,0,9,6],[9,12,9,14],[10,0,10,6],[10,12,10,14],[17,2,17,4],[17,5,17,6],[17,7,17,9],[17,10,17,12],[18,2,18,4],[18,5,18,6],[18,7,18,9],[18,10,18,12],[19,2,19,4],[19,5,19,6]]}
["Use this worksheet to calculate state and local real estate excise tax (REET) per county, when the sale includes parcels in two or more location codes. Include all the parcels within the entire transaction on this worksheet.\n\nDo not use this worksheet if the predominant use for the sale is agriculture or timber land. For assistance in determining predominant use, see ETA 3215.2019 - Graduated Real Estate Excise Tax (REET): Land Classifications & Predominant Use."]
["Step 1: Calculate the taxable selling price for entire transaction"]
["Gross Selling Price",null,null,null,0]
["Personal Property (deduct)",null,null,null,0]
["Exemption Claimed (deduct)",null,null,null,0]
["Total Taxable Selling Price (A)",null,null,null,{"$f":"IF((E3-E4-E5)<0, \"ERROR\",(E3-E4-E5))","v":0}]
["Step 2: Calculate the total state REET tax"]
["Amount * Rate = Tax due"]
[null,null,null,null,null,null,null,"Amount",null,null,null,"Rate","Tax Due"]
["Portion of taxable sale price less than $525,000.01 at 1.1%",null,null,null,null,null,null,{"$f":"IF(E6=0,\" \",(IF(E6<525000.01, E6,525000)))","v":" "},null,null,null,1.0999999999999999E-2,{"$f":"IF(H10=\" \",\" \",(H10*L10))","v":" "}]
["Portion of taxable sale price from $525,000.01 to $1,525,000.00 at 1.28%",null,null,null,null,null,null,{"$f":"IF($E$6<525000.01,\" \",IF($E$6<1525000.01,(($E$6-525000)),(1000000)))","v":" "},null,null,null,1.2800000000000001E-2,{"$f":"IF(H11=\" \",\" \",(H11*L11))","v":" "}]
["Portion of taxable sale price from $1,525,000.01 to $3,025,000.00 at 2.75%",null,null,null,null,null,null,{"$f":"IF($E$6<1525000.01,\" \",IF($E$6<3025000.01,(($E$6-1525000)),(1500000)))","v":" "},null,null,null,2.75E-2,{"$f":"IF(H12=\" \",\" \",(H12*L12))","v":" "}]
["Portion of taxable sale price above $3,025,000 at 3.0%",null,null,null,null,null,null,{"$f":"IF(E6>3025000,E6-3025000,\" \")","v":" "},null,null,null,0.03," "]
["Total State REET Tax (B)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M10:O13)","v":0}]
["Step 3: Calculate the state REET tax and local REET tax per parcel"]
["Begin by listing the parcel number and taxable selling price for each. Then fill out the table from left to right for each parcel."]
["Parcel number","Taxable Selling\nPrice for this\nParcel\n\n(C)","Percentage of Sale for this Parcel\n\n(D)\n\nDivide the taxable selling price per parcel by the total taxable selling price\n\nC / A",null,null,"State REET Tax\n\nMultiply the total state REET tax by the percentage of sale for this parcel\n\n\n\n\nB * D",null,"Location\nCode",null,null,"County Where Parcel is Located",null,null,"Local Rate\n\n(E)","Local REET Tax\n\n\n\n\n\n\n\n\n\nC * E"]
[null,null,{"$f":"IF($E$6=0,\" \",IF(B18=\" \", \" \",B18/$E$6))","v":" "},null,null,null,null,null,null,null,null,null,null,null,{"$f":"B18*N18","v":0}]
[null,null,{"$f":"IF($E$6=0,\" \",IF(B19=\" \", \" \",B19/$E$6))","v":" "},null,null,{"$f":"IF(B19>0,C19*$M$14,\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"B19*N19","v":0}]
[null,null," ",null,null," ",null,null,null,null,null,null,null,null,0]
[null,null," ",null,null," ",null,null,null,null,null,null,null,null,0]
[null,null," ",null,null," ",null,null,null,null,null,null,null,null,0]
[null,null," ",null,null," ",null,null,null,null,null,null,null,null,0]
[null,null," ",null,null," ",null,null,null,null,null,null,null,null,0]
[null,null," ",null,null," ",null,null,null,null,null,null,null,null,0]
[null,null," ",null,null," ",null,null,null,null,null,null,null,null,0]
["Total state REET tax",null,null,null,null,{"$f":"SUM(F18:G26)","v":0},null,"Total local REET tax",null,null,null,null,null,null,{"$f":"SUM(O18:O26)","v":0}]
["Step 4: Calculate the state REET tax and local REET tax per county"]
["Sumbit one affidavit per county using the state and local amounts determined below. Enter these amounts in section 7 of the affidavits."]
["County Name",null,null,"State REET\nAdd the state REET amounts from the\nstate REET tax column above for all the locations within the county",null,null,null,null,null,"Local REET\nAdd the local REET amounts from the\nlocal REET tax column above for all the\nlocations within the county"]
[]
[]
[]
[]
["Total State REET Tax",null,null,null,null,null,{"$f":"SUM(D31:I34)","v":0},null,null,"Total Local REET Tax",null,null,null,{"$f":"SUM(J31:O34)","v":0}]
["For tax assistance, contact your local County Treasurer/Recorder or visit http://dor.wa.gov or call 360-534-1503. To request this document in an alternate format, please call 360-705-6705. Teletype (TTY) users may use the Washington Relay Service by calling 711."]