- Download the spreadsheet file (an error was corrected at 12:10 p.m. ET December 27, 2005, so download again if you have the earlier version).
- Make sure you have the Analysis ToolPak - VBA loaded as an add-in.
- For recent versions of Excel, you may need to have your security setting lowered to medium before opening the spreadsheet. It contains macros, and you will have to allow them to run.
- Enter the loan closing date (the date the customer receives disclosures, including the rescission rights disclosure) in the top date field.
- The date by which rescission must be exercised to be effective is the second date in the yellow section, and it's calculated by the spreadsheet.
- The first date on which it is safe to fund the loan is the last date in the yellow section, and it is calculated for you. You can disburse funds on that date if you have reasonably assured yourself the consumer didn't rescind, and of course, if you're open for business.
The end of the rescission period will never fall on Sunday or on one of the federal holidays, as listed in the protected box below the yellow section. It can fall on Saturday, or on a holiday "observance" date, such as 12/26/05 or 1/2/06. Those days are business days for rescission purposes,
under federal law and Regulation Z. If you have a state Truth in Lending law that supersedes Regulation Z, you must determine whether your state's law permits you to count "observance" dates, or if a different calendar must be used.
The funding date may fall on ANY day of the week, including Sunday. Of course, if you aren't open for business, you'll probably wait for the next bank business day.