{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Rescission Calc."],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Rescission Calc.","index":0,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,1,7],[45,0,45,11],[12,2,12,7],[39,0,39,11],[41,0,41,11],[43,0,43,11]]}
[null,null,"Rescission Date Calculator"]
[null,null,"2012-2013"]
[]
[null,null,null,null,null,null,null,"mm/dd/yy"]
[null,null,"Rescission Start Date ",null,null,null,{"$f":"H5","v":"2013-03-07"},"2013-03-07",null,"<Enter only a Loan Date"]
[null,null,null,"§1026.15/23(a)(3)"]
[null,null,"Rescission End Date",null,null,null,{"$f":"H7","v":"2013-03-11"},{"$f":"sixdayworkweek(H5,3,Holiday)","v":"2013-03-11"}]
[]
[null,null,"Funding Date",null,null,null,{"$f":"H9","v":"2013-03-12"},{"$f":"H7+1","v":"2013-03-12"},null,"(Loans may be funded on Sunday)"]
[]
[]
[]
[null,null,"Federal Holidays  2012 -- 2013"]
[null,null,"New Years Day",null,null,null,{"$f":"H14","v":"2012-01-01"},"2012-01-01"]
[null,null,"Martin Luther King Day",null,null,null,"2012-01-16","2012-01-16"]
[null,null,"Presidents Day",null,null,null,"2012-02-20","2012-02-20"]
[null,null,"Memorial Day",null,null,null,"2012-05-28","2012-05-28"]
[null,null,"Independence Day",null,null,null,"2012-07-04","2012-07-04"]
[null,null,"Labor Day",null,null,null,"2012-09-03","2012-09-03"]
[null,null,"Columbus Day",null,null,null,"2012-10-08","2012-10-08"]
[null,null,"Veterans Day",null,null,null,"2012-11-11","2012-11-11"]
[null,null,"Thanksgiving Day",null,null,null,"2012-11-22","2012-11-22"]
[null,null,"Christmas Day",null,null,null,"2012-12-25","2012-12-25"]
[null,null,"New Years Day",null,null,null,{"$f":"H24","v":"2013-01-01"},"2013-01-01"]
[null,null,"Martin Luther King Day",null,null,null,"2013-01-21","2013-01-21"]
[null,null,"Presidents Day",null,null,null,"2013-02-18","2013-02-18"]
[null,null,"Memorial Day",null,null,null,"2013-05-27","2013-05-27"]
[null,null,"Independence Day",null,null,null,"2013-07-04","2013-07-04"]
[null,null,"Labor Day",null,null,null,"2013-09-02","2013-09-02"]
[null,null,"Columbus Day",null,null,null,"2013-10-14","2013-10-14"]
[null,null,"Veterans Day",null,null,null,"2013-11-11","2013-11-11"]
[null,null,"Thanksgiving Day",null,null,null,"2013-11-28","2013-11-28"]
[null,null,"Christmas Day",null,null,null,"2013-12-25","2013-12-25"]
[null,null,"Static holidays"]
[]
[]
["NOTE: New Year's Day 2012 will be recognized by banks on Monday, 01/02/2012. But the holiday is static, 01/01/xx."]
["NOTE: Veterans day 2012 will be recognized by banks on Monday 11/12/2012. But the holiday is static, 11/11/xx."]
[]
["12 CFR §1026.2 Definitions and rules of construction.\n(6) Business day means a day on which the creditor's offices are open to the public for carrying on substantially all of its business functions. However, for purposes of rescission under §§226.15 and 226.23, and for purposes of §226.31, the term means all calendar days except Sundays and the legal public holidays specified in 5 U.S.C. 6103(a), such as New Year's Day, the Birthday of Martin Luther King, Jr., Washington's Birthday, Memorial Day, Independence Day, Labor Day, Columbus Day, Veterans Day, Thanksgiving Day, and Christmas Day."]
[]
["OSC - 12 CFR §1026.2 Definitions and rules of construction.\n2. Rescission rule. A more precise rule for what is a business day (all calendar days except Sundays and the federal legal holidays listed in 5 U.S.C. 6103(a)) applies when the  right of rescission or mortgages subject to §226.32 are involved. (See also comment 31(c)(1)-1.) Four federal legal holidays are identified in 5 U.S.C. 6103(a) by a specific date: New Year's Day, January 1; Independence Day, July 4; Veterans Day, November 11; and Christmas Day, December 25. When one of these holidays (July 4, for example) falls on a Saturday, federal offices and other entities might observe the holiday on the preceding Friday (July 3). The observed holiday (in the example, July 3) is a business day for purposes of rescission or the delivery of disclosures for certain high-cost mortgages covered by §226.32."]
[]
["12 CFR §1026.15 Right of rescission.(open end transactions)\n(3) The consumer may exercise the right to rescind until midnight of the third business day following the occurrence described in paragraph (a)(1) of this section that gave rise to the right of rescission, delivery of the notice required by paragraph (b) of this section, or delivery of all material disclosures,36  whichever occurs last. If the required notice and  material disclosures are not delivered, the right to rescind shall expire 3 years after the occurrence giving rise to the right of rescission, or upon transfer of all of the consumer's  interest in the property, or upon sale of the property, whichever occurs first. In the case of certain administrative proceedings, the rescission period shall be extended in accordance with §125(f) of the act."]
[]
["12 CFR §1026.23 Right of rescission.(closed end transactions)\n(3) The consumer may exercise the right to rescind until midnight of the third business day following consummation, delivery of the notice required by paragraph (b) of this section, or delivery of all material disclosures,48  whichever occurs last. If the required notice or material disclosures are not delivered, the right to rescind shall expire 3 years after consummation, upon transfer of all of the consumer's interest in the property, or upon sale of the property, whichever occurs first. In the case of certain administrative proceedings, the rescission period shall be extended in accordance with §125(f) of the act."]
[]
["5 USC 6103(a) The following are legal public holidays: "]
["New Year’s Day, January 1.",null,null,null,null,null,null,"Labor Day, the first Monday in September."]
["Birthday of Martin Luther King, Jr., the third Monday in January.",null,null,null,null,null,null,"Columbus Day, the second Monday in October."]
["Washington’s Birthday, the third Monday in February.",null,null,null,null,null,null,"Veterans Day, November 11."]
["Memorial Day, the last Monday in May.",null,null,null,null,null,null,"Thanksgiving Day, the fourth Thursday in November."]
["Independence Day, July 4.",null,null,null,null,null,null,"Christmas Day, December 25"]
[]
[]
["Thanks to JohnBF for the scripting."]
[]
["Rev. 12/13/2012"]
["Courtesy of Andy Zavoina CRCM and BankersOnline.com"]
["andyz@bankersonline.com"]
["You may use this at your own risk. No warranty is provided."]
["© Andy Zavoina & BankersOnline.com"]