{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Penalty Computations"],"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":"Penalty Computations","index":0,"n_rows":22,"n_cols":17,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,10,1,16],[12,1,12,7],[21,1,21,7]]}
[]
[null,"FAILURE TO DEPOSIT PENALTY",null,null,null,null,null,null,null,null,"FAILURE TO PAY PENALTY"]
[null,null,"FTD1","FTD2","FTD3","FTD4","FTD5","FTD6",null,null,null,"FTP1","FTP2","FTP3","FTP4","FTP5","FTP6"]
[null,"Amount",null,null,null,null,null,null,null,null,"Amount"]
[null,"Due",null,null,null,null,null,null,null,null,"Due"]
[null,"Paid",null,null,null,null,null,null,null,null,"Calculate to"]
[null,"Number of days PD",{"$f":"IF(OR(C6=\"\",C5=\"\"),\"\",C6-C5)","v":""},{"$f":"IF(OR(D6=\"\",D5=\"\"),\"\",D6-D5)","v":""},"","","","",null,null,"Months Past Due",{"$f":"IF(OR(L4=\"\",L5=\"\",L6=\"\"),\"\",DATEDIF(L5, L6, \"m\")+1)","v":""},{"$f":"IF(OR(M4=\"\",M5=\"\",M6=\"\"),\"\",DATEDIF(M5, M6, \"m\")+1)","v":""},"","","",""]
[]
[null,"FTD Penalty",{"$f":"IF(OR(C5=\"\",C6=\"\"),\"\",IF(C7<=5,0.02*C4,IF(AND(C7>=6,C7<=15),0.05*C4,IF(C7>15,0.1*C4))))","v":""},{"$f":"IF(OR(D5=\"\",D6=\"\"),\"\",IF(D7<=5,0.02*D4,IF(AND(D7>=6,D7<=15),0.05*D4,IF(D7>15,0.1*D4))))","v":""},"","","","",null,null,"FTP Penalty",{"$f":"IF(OR(L4=\"\",L5=\"\",L6=\"\"),\"\",MIN(0.25*L4,L7*0.005*L4))","v":""},{"$f":"IF(OR(M4=\"\",M5=\"\",M6=\"\"),\"\",M7*0.005*M4)","v":""},"","","",""]
[]
[]
[]
[null,"FAILURE TO FILE PENALTY"]
[null,null,"FTF1","FTF2","FTF3","FTF4","FTF5","FTF6"]
[null,"Unpaid Tax"]
[null," Return Due"]
[null,"Return Filed"]
[null,"Months Past Due",{"$f":"IF(OR(C15=\"\",C16=\"\",C17=\"\"),\"\",DATEDIF(C16, C17, \"m\")+1)","v":""},{"$f":"IF(OR(D15=\"\",D16=\"\",D17=\"\"),\"\",DATEDIF(D16, D17, \"m\")+1)","v":""},"","","",""]
[]
[null,"FTD Penalty *",{"$f":"IF(OR(C15=\"\",C16=\"\",C17=\"\"),\"\",MIN(0.25*C15,(C18*0.05)*C15))","v":""},{"$f":"IF(OR(D15=\"\",D16=\"\",D17=\"\"),\"\",MIN(0.25*D15,(D18*0.05)*D15))","v":""},"","","",""]
[]
[null,"* FTF is 5% of the unpaid tax each month the return was late (up to a maximum of 25%) unless, taxpayer is also being \ncharged Failure to Pay penalty.  If that is the case, the FTF penalty is 4.5% fore each month the return was late (up to \na maximum of 25%).\n\nSince you will not be charged a FTF penalty if you don't owe, you will likely never have FTF without FTP.  Therefore this table\nuses the 4.5% rate."]