{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data","Overall","Calculator","Sheet7","PD1","PD2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":23,"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":"Data","index":0,"n_rows":100,"n_cols":13,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,5,1,6],[1,9,1,11],[2,5,2,7]]}
[1040,null,null,null,null,null,null,"Most Recent %"]
["Year","Due","Extension",null,null,"ADD NEW: ",null,{"$f":"INDIRECT(ADDRESS(MIN(ROW(InterestRateTbl[])),COLUMN(InterestRateTbl[Daily Rate])))","v":2.4657534246575342E-4},null,"Return Due Dates"]
[2000,{"$f":"IF(WEEKDAY(DATE(A3,4,15),1)=1,DATE(A3+1,4,16),IF(WEEKDAY(DATE(A3,4,15),1)=7,DATE(A3+1,4,17),DATE(A3+1,4,15)))","v":"2001-04-17"},{"$f":"IF(WEEKDAY(DATE(A3,10,15),1)=1,DATE(A3+1,10,16),IF(WEEKDAY(DATE(A3,10,15),1)=7,DATE(A3+1,10,17),DATE(A3+1,10,15)))","v":"2001-10-16"},null,null,"INTEREST RATE TABLE",null,null,null,"Type","M","D","Y"]
[{"$f":"A3+1","v":2001},{"$f":"IF(WEEKDAY(DATE(A4,4,15),1)=1,DATE(A4+1,4,16),IF(WEEKDAY(DATE(A4,4,15),1)=7,DATE(A4+1,4,17),DATE(A4+1,4,15)))","v":"2002-04-16"},{"$f":"IF(WEEKDAY(DATE(A4,10,15),1)=1,DATE(A4+1,10,16),IF(WEEKDAY(DATE(A4,10,15),1)=7,DATE(A4+1,10,17),DATE(A4+1,10,15)))","v":"2002-10-15"},null,null,"PERIOD","APR","Daily Rate",null,"940",1,31,1]
[{"$f":"A4+1","v":2002},"2003-04-15","2003-10-15",null,null,"2024 12",0.09,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.4657534246575342E-4},null,"941Q1",4,30,0]
[2003,"2004-04-15","2004-10-15",null,null,"2024 09",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4},null,"941Q2",7,31,0]
[2004,"2005-04-15","2005-10-15",null,null,"2024 06",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4},null,"941Q3",10,31,0]
[2005,"2006-04-15","2006-10-17",null,null,"2024 03",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4},null,"941Q4",1,31,1]
[2006,"2007-04-17","2007-10-16",null,null,"2023 12",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4},null,"1040",4,15,1]
[2007,"2008-04-16","2008-10-15",null,null,"2023 09",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4},null,"1065"]
[2008,"2009-04-15","2009-10-15",null,null,"2023 06",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4},null,"1120"]
[2009,"2010-04-15","2010-10-15",null,null,"2023 03",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4}]
[2010,"2011-04-15","2011-10-15",null,null,"2022 12",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[2011,"2012-04-15","2012-10-17",null,null,"2022 09",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2012,"2013-04-16","2013-10-15",null,null,"2022 06",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2013,"2014-04-15","2014-10-15",null,null,"2022 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2014,"2015-04-15","2015-10-15",null,null,"2021 12",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2015,"2016-04-15","2016-10-15",null,null,"2021 09",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2016,"2017-04-15","2017-10-17",null,null,"2021 06",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2017,"2018-04-17","2018-10-16",null,null,"2021 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2018,"2019-04-16","2019-10-15",null,null,"2020 12",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2019,"2020-04-15","2020-10-15",null,null,"2020 09",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2020,"2021-04-15","2021-10-15",null,null,"2020 06",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2021,"2022-04-15","2022-10-15",null,null,"2020 03",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2022,"2023-04-15","2023-10-17",null,null,"2019 12",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2023,"2024-04-17","2024-10-16",null,null,"2019 09",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2024,"2025-04-15","2025-10-15",null,null,"2019 06",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[2025,"2026-04-15","2026-10-15",null,null,"2019 03",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[2026,"2027-04-15","2027-10-15",null,null,"2018 12",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2027,"2028-04-15","2028-10-15",null,null,"2018 09",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2028,"2029-04-17","2029-10-16",null,null,"2018 06",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[2029,"2030-04-16","2030-10-15",null,null,"2018 03",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2030,"2031-04-15","2031-10-15",null,null,"2017 12",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2031,"2032-04-15","2032-10-15",null,null,"2017 09",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2032,"2033-04-15","2033-10-15",null,null,"2017 06",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2033,"2034-04-15","2034-10-17",null,null,"2017 03",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2034,"2035-04-17","2035-10-16",null,null,"2016 12",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2035,"2036-04-16","2036-10-15",null,null,"2016 09",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2036,"2037-04-15","2037-10-15",null,null,"2016 06",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[2037,"2038-04-15","2038-10-15",null,null,"2016 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2038,"2039-04-15","2039-10-15",null,null,"2015 12",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2039,"2040-04-15","2040-10-17",null,null,"2015 09",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2040,"2041-04-16","2041-10-15",null,null,"2015 06",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2041,"2042-04-15","2042-10-15",null,null,"2015 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2042,"2043-04-15","2043-10-15",null,null,"2014 12",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2043,"2044-04-15","2044-10-15",null,null,"2014 09",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2044,"2045-04-15","2045-10-17",null,null,"2014 06",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2045,"2046-04-17","2046-10-16",null,null,"2014 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2046,"2047-04-16","2047-10-15",null,null,"2013 12",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2047,"2048-04-15","2048-10-15",null,null,"2013 09",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2048,"2049-04-15","2049-10-15",null,null,"2013 06",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2049,"2050-04-15","2050-10-15",null,null,"2013 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[2050,"2051-04-15","2051-10-17",null,null,"2012 12",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[null,null,null,null,null,"2012 09",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[null,null,null,null,null,"2012 06",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[null,null,null,null,null,"2012 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[null,null,null,null,null,"2011 12",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[null,null,null,null,null,"2011 09",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2011 06",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2011 03",0.03,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":8.219178082191781E-5}]
[null,null,null,null,null,"2010 12",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2010 09",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2010 06",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2010 03",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2009 12",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2009 09",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2009 06",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2009 03",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2008 12",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2008 09",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2008 06",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2008 03",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4}]
[null,null,null,null,null,"2007 12",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4}]
[null,null,null,null,null,"2007 09",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4}]
[null,null,null,null,null,"2007 06",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4}]
[null,null,null,null,null,"2007 03",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4}]
[null,null,null,null,null,"2006 12",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4}]
[null,null,null,null,null,"2006 09",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4}]
[null,null,null,null,null,"2006 06",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4}]
[null,null,null,null,null,"2006 03",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4}]
[null,null,null,null,null,"2005 12",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4}]
[null,null,null,null,null,"2005 09",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2005 06",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2005 03",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2004 12",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2004 09",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2004 06",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2004 03",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2003 12",0.04,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.0958904109589041E-4}]
[null,null,null,null,null,"2003 09",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2003 06",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2003 03",0.05,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.3698630136986303E-4}]
[null,null,null,null,null,"2002 12",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2002 09",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2002 06",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2002 03",0.06,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.6438356164383562E-4}]
[null,null,null,null,null,"2001 12",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4}]
[null,null,null,null,null,"2001 09",7.0000000000000007E-2,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":1.9178082191780824E-4}]
[null,null,null,null,null,"2001 06",0.08,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.1917808219178083E-4}]
[null,null,null,null,null,"2001 03",0.09,{"$f":"InterestRateTbl[[#This Row],[APR]]/365","v":2.4657534246575342E-4}]

{"sheet":"Overall","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"Interest Rate"]
[null,"Annual",0.08]
[null,"Daily",{"$f":"C2/365","v":2.1917808219178083E-4}]
[null,"Beginning Bal:",31000,"Payment Amt:"]
[null,"Payment Start Dt:","2024-09-28",500]
[null,"Payment Change 1:"]
[null,"Payment Change 2:"]
[null,"Payment Day:",{"$f":"DAY(C5)","v":28}]
[null,"Payoff Date:",{"$f":"_xlfn.XLOOKUP(1,--(Table248[End Bal]<0),Table248[Date])","v":{"$error":"#N/A"}},{"$f":"\"Months to payoff: \"&DATEDIF(C5,C9,\"M\")","v":{"$error":"#N/A"}}]
[null,"Total Paid at payoff:",{"$f":"_xlfn.XLOOKUP(C9,Table248[Date],Table248[Paid To Date])","v":{"$error":"#N/A"}},null,"Show this date:"]
[null,"Total Paid To Date:",{"$f":"_xlfn.XLOOKUP(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),Table248[Date],Table248[Paid To Date])","v":{"$error":"#N/A"}}]
[]
[null,"Date","Beg Bal","Interest","Credits","Penalties","End Bal","Current Pmt","Paid To Date"]

{"sheet":"Calculator","index":2,"n_rows":11,"n_cols":23,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[0,2,0,3],[1,0,1,1],[1,2,1,3],[2,0,2,1],[2,2,2,3]]}
["Payment amount",null,1500,null,null,null,"PD","Type","Year","Qtr.","LkUp","CSED","Ext. Filed (Y/N)","Return Due Date","Return Filed Date","File Date past due","Tax Amount","Tax Due Date","Tax paid by due date","Balance Due","Payoff Date","Pay Date past due","# Days"]
["Payment start date",null,"2024-09-28",null,null,null,1,1040,2014,null,{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"1040"},"2025-03-30",true,"2015-04-15","2015-11-04",{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":7},24000,"2015-04-15",11548,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":12452},"2020-01-25",{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":58.2},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3637}]
["Number of Months",null,120,null,null,null,2,940,2015,null,{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"940"},"2026-05-09",false,"2016-01-31",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2016-01-31",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3751}]
[null,null,null,null,null,null,3,941,2015,null,{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"941"},"2026-05-09",false,"2016-01-31",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2016-01-31",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3751}]
[null,null,null,null,null,null,4,1040,2016,null,{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"1040"},"2028-04-28",false,"2017-10-15",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2017-04-15",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":4031}]
[null,null,null,null,null,null,5,940,2016,null,{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"940"},"2027-05-15",true,"2017-01-31",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2017-01-31",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3756}]
[null,null,null,null,null,null,6,941,2016,"Q1",{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"941Q1"},"2026-08-08",true,"2016-04-30",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2016-04-30",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3752}]
[null,null,null,null,null,null,7,941,2016,"Q3",{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"941Q3"},"2027-02-06",false,"2016-10-31",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2016-10-31",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3750}]
[null,null,null,null,null,null,8,941,2016,"Q4",{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"941Q4"},"2027-05-15",false,"2017-01-31",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2017-01-31",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3756}]
[null,null,null,null,null,null,9,1040,2017,null,{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"1040"},"2029-03-22",false,"2018-04-15",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2018-04-15",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3994}]
[null,null,null,null,null,null,10,1040,2017,null,{"$f":"CalculationTbl[[#This Row],[Type]]&CalculationTbl[[#This Row],[Qtr.]]","v":"1040"},"2029-03-22",true,"2018-04-15",null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Return Filed Date]]<>\"\",CalculationTbl[[#This Row],[Return Due Date]]<>\"\"),MONTH(CalculationTbl[[#This Row],[Return Filed Date]])-MONTH(CalculationTbl[[#This Row],[Return Due Date]]),\"\")","v":""},null,"2018-04-15",null,{"$f":"CalculationTbl[[#This Row],[Tax Amount]]-CalculationTbl[[#This Row],[Tax paid by due date]]","v":0},null,{"$f":"IF(AND(CalculationTbl[[#This Row],[Balance Due]]>0,CalculationTbl[[#This Row],[Tax Due Date]]<>\"\",CalculationTbl[[#This Row],[Payoff Date]]<>\"\"),(CalculationTbl[[#This Row],[Payoff Date]]-CalculationTbl[[#This Row],[Tax Due Date]])/30,\"\")","v":""},{"$f":"(CalculationTbl[[#This Row],[CSED]]-CalculationTbl[[#This Row],[Tax Due Date]])","v":3994}]

{"sheet":"Sheet7","index":3,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,"rBox"]
[null,"cType","lo.ListColumns(\"Type\").DataBodyRange.Column",null,null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"=\",TRUE,B8:C8)","v":"cType=lo.ListColumns(\"Type\").DataBodyRange.Column"}]
[null,"cYear","lo.ListColumns(\"Year\").DataBodyRange.Column",null,null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"=\",TRUE,B9:C9)","v":"cYear=lo.ListColumns(\"Year\").DataBodyRange.Column"}]
[null,"cQtr","lo.ListColumns(\"Qtr.\").DataBodyRange.Column",null,null,null,null,null,null,"cQtr=lo.ListColumns(\"Qtr.\").DataBodyRange.Column"]
[null,"cCSED","lo.ListColumns(\"CSED\").DataBodyRange.Column",null,null,null,null,null,null,"cCSED=lo.ListColumns(\"CSED\").DataBodyRange.Column"]
[null,"cExt","lo.ListColumns(\"Ext.Filed(Y/N)\").DataBodyRange.Column",null,null,null,null,null,null,"cExt=lo.ListColumns(\"Ext.Filed(Y/N)\").DataBodyRange.Column"]
[null,"cRtnDueDt","lo.ListColumns(\"Return Due Date\").DataBodyRange.Column",null,null,null,null,null,null,"cRtnDueDt=lo.ListColumns(\"Return Due Date\").DataBodyRange.Column"]
[null,"cRtnFiledDt","lo.ListColumns(\"ReturnFiledDate\").DataBodyRange.Column",null,null,null,null,null,null,"cRtnFiledDt=lo.ListColumns(\"ReturnFiledDate\").DataBodyRange.Column"]
[null,"cTaxAmt","lo.ListColumns(\"TaxAmount\").DataBodyRange.Column",null,null,null,null,null,null,"cTaxAmt=lo.ListColumns(\"TaxAmount\").DataBodyRange.Column"]
[null,"cTaxDueDt","lo.ListColumns(\"TaxDueDate\").DataBodyRange.Column",null,null,null,null,null,null,"cTaxDueDt=lo.ListColumns(\"TaxDueDate\").DataBodyRange.Column"]
[null,"cTxPdTimely","lo.ListColumns(\"Taxpaidbyduedate\").DataBodyRange.Column",null,null,null,null,null,null,"cTxPdTimely=lo.ListColumns(\"Taxpaidbyduedate\").DataBodyRange.Column"]
[null,"cBalDue","lo.ListColumns(\"BalanceDue\").DataBodyRange.Column",null,null,null,null,null,null,"cBalDue=lo.ListColumns(\"BalanceDue\").DataBodyRange.Column"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,O40:S40)","v":""}]

{"sheet":"PD1","index":4,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,6,0,7],[0,8,0,9]]}
[null,null,null,null,"Failure to File",null,"Failure to Pay",null,"Failure to Deposit"]
[null,null,null,null,"Date","Amount","Date","Amount","Date","Amount"]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>2,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+1,1),\"\")","v":"2015-05-01"},null,{"$f":"IF(Calculator!V2>1,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+1,1),\"\")","v":"2015-05-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>1,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+2,1),\"\")","v":"2015-06-01"},null,{"$f":"IF(Calculator!V3>2,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+2,1),\"\")","v":"2015-06-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>3,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+3,1),\"\")","v":"2015-07-01"},null,{"$f":"IF(Calculator!V4>3,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+3,1),\"\")","v":"2015-07-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>4,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+4,1),\"\")","v":"2015-08-01"},null,{"$f":"IF(Calculator!V5>4,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+4,1),\"\")","v":"2015-08-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>5,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+5,1),\"\")","v":"2015-09-01"},null,{"$f":"IF(Calculator!V6>5,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+5,1),\"\")","v":"2015-09-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>6,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+6,1),\"\")","v":"2015-10-01"},null,{"$f":"IF(Calculator!V7>6,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+6,1),\"\")","v":"2015-10-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V8>7,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+7,1),\"\")","v":"2015-11-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V9>8,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+8,1),\"\")","v":"2015-12-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V10>9,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+9,1),\"\")","v":"2016-01-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V11>10,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+10,1),\"\")","v":"2016-02-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V12>1,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+1,1),\"\")","v":""}]
[]
[]
[]
[null,null,null,"Date","MonthDay","Qtr","Beg Bal","LKUP Int","Interest","Credits","FTF","FTP","Payment","End Bal","CurrentPmt"]
[null,null,null,{"$f":"Calculator!R2","v":"2015-04-15"},null,null,{"$f":"Calculator!T2","v":12452},{"$f":"IF(AND(MONTH(PD1Table[[#This Row],[Date]])>=1,MONTH(PD1Table[[#This Row],[Date]])<=3),YEAR(PD1Table[[#This Row],[Date]])&\" 03\",IF(AND(MONTH(PD1Table[[#This Row],[Date]])>=4,MONTH(PD1Table[[#This Row],[Date]])<=6),YEAR(PD1Table[[#This Row],[Date]])&\" 06\",IF(AND(MONTH(PD1Table[[#This Row],[Date]])>=7,MONTH(PD1Table[[#This Row],[Date]])<=9),YEAR(PD1Table[[#This Row],[Date]])&\" 09\",IF(AND(MONTH(PD1Table[[#This Row],[Date]])>=10,MONTH(PD1Table[[#This Row],[Date]])<=12),YEAR(PD1Table[[#This Row],[Date]])&\" 12\",\"\"))))","v":"2015 06"},{"$f":"_xlfn.XLOOKUP(PD1Table[[#This Row],[LKUP Int]],InterestRateTbl[PERIOD],InterestRateTbl[Daily Rate])","v":8.219178082191781E-5}]

{"sheet":"PD2","index":5,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,4,0,5],[0,6,0,7],[0,8,0,9]]}
[null,null,null,null,"Failure to File",null,"Failure to Pay",null,"Failure to Deposit"]
[null,null,null,null,"Date","Amount","Date","Amount","Date","Amount"]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>2,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+1,1),\"\")","v":"2015-05-01"},null,{"$f":"IF(Calculator!V2>1,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+1,1),\"\")","v":"2015-05-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>1,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+2,1),\"\")","v":"2015-06-01"},null,{"$f":"IF(Calculator!V3>2,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+2,1),\"\")","v":"2015-06-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>3,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+3,1),\"\")","v":"2015-07-01"},null,{"$f":"IF(Calculator!V4>3,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+3,1),\"\")","v":"2015-07-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>4,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+4,1),\"\")","v":"2015-08-01"},null,{"$f":"IF(Calculator!V5>4,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+4,1),\"\")","v":"2015-08-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>5,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+5,1),\"\")","v":"2015-09-01"},null,{"$f":"IF(Calculator!V6>5,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+5,1),\"\")","v":"2015-09-01"}]
[null,null,null,null,{"$f":"IF(Calculator!$P$2>6,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+6,1),\"\")","v":"2015-10-01"},null,{"$f":"IF(Calculator!V7>6,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+6,1),\"\")","v":"2015-10-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V8>7,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+7,1),\"\")","v":"2015-11-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V9>8,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+8,1),\"\")","v":"2015-12-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V10>9,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+9,1),\"\")","v":"2016-01-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V11>10,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+10,1),\"\")","v":"2016-02-01"}]
[null,null,null,null,null,null,{"$f":"IF(Calculator!V12>1,DATE(YEAR(Calculator!$N$2),MONTH(Calculator!$N$2)+1,1),\"\")","v":""}]
[]
[]
[]
[null,null,null,"Date","MonthDay","Qtr","Beg Bal","LKUP Int","Interest","Credits","FTF","FTP","Payment","End Bal","CurrentPmt"]
[null,null,null,{"$f":"Calculator!R2","v":"2015-04-15"},null,null,{"$f":"Calculator!T2","v":12452},{"$f":"IF(AND(MONTH(PD2Table[[#This Row],[Date]])>=1,MONTH(PD2Table[[#This Row],[Date]])<=3),YEAR(PD2Table[[#This Row],[Date]])&\" 03\",IF(AND(MONTH(PD2Table[[#This Row],[Date]])>=4,MONTH(PD2Table[[#This Row],[Date]])<=6),YEAR(PD2Table[[#This Row],[Date]])&\" 06\",IF(AND(MONTH(PD2Table[[#This Row],[Date]])>=7,MONTH(PD2Table[[#This Row],[Date]])<=9),YEAR(PD2Table[[#This Row],[Date]])&\" 09\",IF(AND(MONTH(PD2Table[[#This Row],[Date]])>=10,MONTH(PD2Table[[#This Row],[Date]])<=12),YEAR(PD2Table[[#This Row],[Date]])&\" 12\",\"\"))))","v":"2015 06"},{"$f":"_xlfn.XLOOKUP(PD2Table[[#This Row],[LKUP Int]],InterestRateTbl[PERIOD],InterestRateTbl[Daily Rate])","v":8.219178082191781E-5}]