Regulation CC
Funds Availability Calendar
Updated 12/14/07 for 2008
By Andy Zavoina, BOL Guru Bio and Contact Info
This tool consists of an Excel spreadsheet designed to allow a user to calculate when funds must be made available under Reg CC and a short online video to help the user understand how to use the tool correctly. There is also a printable calendar that may be used where computer access is limited. This is based on the Reg. CC Calendar program Andy did and Jim Bedsole enhanced with an easy to use interface.
Here's how it works: When you open the spreadsheet the current business date field will be populated by the current date. Adjust that date to reflect the business date on which you are operating, being mindful of when you are working after cutoff hour (on the next business day). Use the pull down menu to select the hold type, and verify the hold release and computer hold release dates. The computer hold release date is set for one business day prior to the hold release.
You need to have Excel set properly for the program to work. In Excel, go to the "Tools" menu, and then to "Add-Ins". Make sure the checkbox for "Analysis ToolPak" is checked on. You should then have no problems with the program.
This program may be revised from time to time; check for updates periodically. You may use it at no cost, but may not redistribute it. The program comes with no warranties. Please advise us if you see any errors or desired "tweaks" to make it function better for you.
Download the Reg CC Date Availability Calculator 2008 version or the 2007 version by RIGHT clicking on the link and saving the xls (Excel) file to your hard drive. You can also save the file to your institution's intranet directory to make it available to all in your institution that have intranet access.
Be sure you turn on the Analysis ToolPak-VBA as noted in the steps on the Output tab. This short video will show you how to avoid the most common error and begin using the tool.
Updated 12-14-07. First published on BankersOnline.com 11-08-01.
BankersOnline is a free service made possible by the generous support of our advertisers and sponsors. Advertisers and sponsors are not responsible for site content. Please help us keep BankersOnline FREE to all banking professionals. Support our advertisers and sponsors by clicking through to learn more about their products and services.
Print Friendly!
Email This Article!
Discuss NOW!
