{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","TFRP"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Instructions","index":0,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":true,"merged":[[6,8,6,13],[7,9,7,11],[7,12,7,14],[18,8,20,14]]}
[]
[]
[]
[]
[]
[]
["Period","Withheld","Taxable Wages","Payments","Trust Fund Amount","Amount of payments applied to TFRP","Remaining TFRP",null,"TAX RATES"]
[201012,30137.5,300000,73207.45,53087.5,50257.45,2830.05,null,null,"Employee",null,null,"Employer"]
[201106,35551.71,250000,61302.66,49676.71,47177.66,2499.0500000000002,null,1995,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,1996,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,1997,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,1998,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,1999,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"The \"Adj. Rates\" button is to edit the listed percentages for tax rates or to add a new year.  When inputting percentages on the form, always use the decimal format, i.e. 10% = .1; 6.2% = .062; 1.45% = .0145"]

{"sheet":"TFRP","index":1,"n_rows":37,"n_cols":18,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,1,26,6],[2,10,2,16],[1,6,1,7],[3,11,3,13],[3,15,3,17],[1,4,1,5]]}
[null,"Last updated:","Monday, July 22, 2024"]
[null,null,null,null,"Total TFRP all periods:",null,{"$f":"SUM(I4:I19)","v":0}]
[null,"Period\n(yyyy qq)","Withheld","Wages for which the Additional Medicare tax applies *1","Taxable Wages","Payments","Trust Fund Amount","Amount of payments applied to TFRP","Remaining TFRP",null,"TAX RATES"]
[null,null,null,null,null,null,{"$f":"IF(B4=\"\",\"\",(E4*LOOKUP(--LEFT(B4,4),$K$5:$K$30,$N$5:$N$30)+C4+(D4*LOOKUP(--LEFT(B4,4),$K$5:$K$30,$O$5:$O$30))))","v":""},{"$f":"IF(B4=\"\",\"\",IF(F4<(LOOKUP(--LEFT(B4,4),$K$5:$K$30,$R$5:$R$30)*E4),0,F4-(LOOKUP(--LEFT(B4,4),$K$5:$K$30,$N$5:$N$30)*E4)))","v":""},{"$f":"IF(B4=\"\",\"\",G4-H4)","v":""},null,null,"Employee",null,null,"Add'l Med. Tax","Employer"]
[null,null,null,null,null,null,{"$f":"IF(B5=\"\",\"\",(E5*LOOKUP(--LEFT(B5,4),$K$5:$K$30,$N$5:$N$30)+C5+(D5*LOOKUP(--LEFT(B5,4),$K$5:$K$30,$O$5:$O$30))))","v":""},"","",null,2000,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(L5:M5)","v":7.6499999999999999E-2},null,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P5:Q5)","v":7.6499999999999999E-2}]
[null,null,null,null,null,null,"","","",null,2001,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2002,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2003,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2004,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2005,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2006,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2007,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P12:Q12)","v":7.6499999999999999E-2}]
[null,null,null,null,null,null,"","","",null,2008,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2009,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2010,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2011,4.2000000000000003E-2,1.4500000000000001E-2,5.6500000000000002E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2012,4.2000000000000003E-2,1.4500000000000001E-2,5.6500000000000002E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2013,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,"","","",null,2014,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,{"$f":"SUM(C4:C19)","v":0},null,{"$f":"SUM(E4:E19)","v":0},{"$f":"SUM(F4:F19)","v":0},{"$f":"SUM(G4:G19)","v":0},{"$f":"SUM(H4:H19)","v":0},{"$f":"SUMIF(I4:I19,\">0\",I4:I19)","v":0},null,2015,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,2016,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P21:Q21)","v":7.6499999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,2017,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P22:Q22)","v":7.6499999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,2018,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P23:Q23)","v":7.6499999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,2019,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P24:Q24)","v":7.6499999999999999E-2}]
[null,"*1   For 2013 & forward, wages over $200,000 are taxed an additional .9% for medicare.  \nIn this column, put the amount of wages that were over $200,000 per employee (not the total).",null,null,null,null,null,null,null,null,2020,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P25:Q25)","v":7.6499999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,2021,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(P26:Q26)","v":7.6499999999999999E-2}]
[null,null,null,null,null,null,null,null,null,null,2022,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,2023,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,2024,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,2025,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,2026,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,2027,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,2028,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,2029,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,2030,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,2031,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,2032,null,null,{"$f":"SUM(L37:M37)","v":0},null,null,null,{"$f":"SUM(P37:Q37)","v":0}]