![[Image] GFOA Logo](http://www.estoregfoa.org/StaticContent/Images/revlogo.gif) |
Treasury Management |
June 1, 2007
Volume 25, Number 6 |
|
| Inside This Issue |
| |
Feature Articles and Resources
|
|
Tip for Printing |
1. Go to "File," "Page Setup."
2. Change all margins to 0.5 or less. |
|
|
|
Economy and Interest Rates
|
|
|
Investment Performance Benchmarks
- Performance Benchmarks
- 10-Bill Index
- Money Market Fund Index
- LGIP Index
- Key Rates: Cash Markets
- Relative Value Yield Chart
|
|
|
What You Need to Know Before Using a Lockbox Service
By Susan M. Cotton, CTP One way for a government to streamline the collection of water, sewer, utility, or other types of recurring remittances is to outsource the processing to a lockbox provider. Lockbox processing involves a third party service provider (typically a bank) handling all of the activities involved with remittances, including collecting, depositing, and reporting. By using lockbox services, a government reduces mail float, processing float, and check clearing float, allowing funds to be collected more quickly than through normal in-house processing. Consider the following before using a lockbox service:
Volume. Lockbox processing is very volume driven. There are two primary types of lockbox services based on volume: (1) wholesale lockboxes, which process a low volume of high ticket items (e.g., property taxes) and (2) retail lockboxes, which process a high volume of low ticket items (e.g., water payments). Some providers also offer a hybrid service for medium range volumes that require hands-on attention such as keying in data. For example, one bank calls its hybrid service, “Wholetail Lockbox.” When considering whether your agency qualifies for a retail lockbox service, the key question concerns the volume threshold, which can range from a minimum of 5,000 to 20,000 items a month.
What Lockbox Can Do for You. Lockbox processors will perform the following basic functions for a government: collect remittances from the Post Office, open the mail, scan or key in the coupon information, scan or key in the check information, encode and endorse all of the checks received, deposit the checks to make check clearing deadlines, and create and send an electronic file and/or a hard copy report with information on the items processed each day. Any number of exception-type activities can be arranged for, such as creating customized reports, mailing any correspondence received, making photocopies of the checks received, reconciling mismatched items, etc. A new service that some of the major banks are offering is Accounts Receivable Conversion (ARC), whereby the checks received by the lockbox are converted to ACH debits.
Costs of Lockbox Processing. The primary cost component of lockbox processing is the per item fee. For wholesale lockboxes, the per item fee might range from $.50 to $1.00. For retail lockboxes, the per item fee might range from $.15 to $.30 for matched items (i.e., one coupon and one check with matching dollar amounts). In addition, both wholesale and retail lockboxes may have other charges, such as monthly maintenance charges, P.O. Box rental, photocopies, and special handling requirements. Retail lockboxes may also have additional charges, including charges for data transmissions, ARC, and MICR rejects. The per item fee for retail lockbox items is increased for:
- Multiples (i.e., one coupon with more than one check or the reverse),
- Mismatched items (i.e., coupon and check amounts do not match),
- Check only (i.e., no coupon), and
- Reject items (e.g., coupon only with no check).
The higher the volume, the lower the price per item because lockbox processing, especially retail lockboxes, benefits from significant economies of scale.
Prerequisites for Lockboxes. In order to be able to benefit from retail lockbox processing, a government needs to have the following items in place in addition to the volume requirements:
- The agency needs a scanable remittance document or coupon. The lockbox service provider will give the agency document specifications for both the envelopes and coupons if scanable documents are not currently being used.
- The agency has to feel comfortable with the fact that its customers will mail remittances to a P.O. Box that is probably located in a different city. Lockbox processing sites are typically located in the downtown areas of major cities, such as Los Angeles, San Francisco, Dallas, etc.
- The agency needs to have the applicable technology in place, such as the ability to receive a lockbox file and have that information uploaded to the agency's accounts receivable system. If the computer connection is not in place, then the agency would receive only a hard copy file and have to manually input the data.
- The agency needs to have fairly clean processing with a low percentage (10 percent or less) of mismatched or exception items.
Lockbox Selection Criteria. When selecting a lockbox service provider, a government should consider and rank the following criteria:
- Protection of public funds (collateralization of deposits);
- Financial strength of provider (capitalization, bank ratings, profitability);
- Ability to provide basic remittance processing services;
- Ability to provide enhanced services, such as ARC and exception handling;
- Experience providing lockbox services to other with governments;
- Quality of references (governments with similar volumes and requirements); and
- Costs to the government (overall pricing, costs of programming, and staff time).
Summary. If a government is looking at outsourcing possibilities, then lockbox could be an effective option for remittance processing. Consider lockbox before investing in new remittance processing equipment, renewing an equipment-servicing contract, or hiring additional staff. In addition, perform a thorough cost-benefit analysis before signing on the dotted line with a potential lockbox provider. The universe of lockbox providers continues to grow with many choices available among bank and non-bank providers, making the market very competitive right now.
Susan M. Cotton is a Certified Treasury Professional and manages the firm Money Matters Consulting. She can be reached at 949/279-1855 or s_cotton@hotmail.com.
|
|
What are Lockbox Services?
Lockbox services are designed to expedite the collection of paper-based payments and provide timely payment information to update accounts receivable records. Lockbox services are usually provided by a third-party processor (usually a bank) that receives, opens, and processes payments for a government entity or business. For most entities, lockbox services should: increase payment and posting accuracy; improve cash flow by reducing processing time between delivery of mail and depositing of payments; and increase staff productivity by freeing personnel from the labor intensive process of manually handling mail, making daily deposits, and posting manual payments.
Eight Benefits of Lockboxes |
-
Reduced float, including mail and processing float.
- Accelerated funds availability.
- Receipts are transmitted for automated download and posting/crediting to individual accounts by government treasurers.
- Improved accuracy in the collection process.
- An audit trail is established.
- Reduced internal staffing costs due to outsourcing and/or the reallocation of staff to higher-value tasks.
- Reduced processing delays that would have been associated with sick time, vacation, and holidays taken by internal staff.
- Possible reduction in future hiring and training needs associated with growth in payments.
|
There are two basic types of lockbox services: wholesale (used for high-dollar, low-volume payments) and retail (used for high-volume, low-dollar payments such as taxes, utilities, licenses, and fees, and accompanied by standardized remittance documents). Retail lockbox services generally are of primary interest to government entities.
Most lockbox services function in the following manner:
- The bank contracted to provide lockbox service maintains a separate post office box in the government's name.
- Customers' remittances (that is, the document indicating amount due) and enclosed check are mailed to the specific post office box, rather than to the post office box for the government's regular mail (often facilitated by using pre-addressed, bar-coded envelopes).
- The bank collects the remittances periodically during the day. Depending on volume, the bank may collect remittances perhaps as often as once every two hours or as infrequently as once a day.
- Bank staff opens the remittances and sorts the check payments and accompanying data.
- Checks that match the particular bill, invoice, or other data are processed for deposit that day.
- Exceptions (non-matching items) may or may not be processed according to the special customized computer program. Any checks that are not processed are turned over to the government for action.
- Copies of all normal, accepted remittances and accompanying data are forwarded daily to the government (on CD-ROM and/or via the bank's online reporting) for its internal posting process. The posting process is automated among some governments. That is, the responsible government financial manager can capture data from the bank's online reporting tool and automatically post it to the internal financial management system.
|
|
Sequence of Activities in a Lockbox
Source: Banking Services: A Guide for Governments, Government Finance Officers Association, 2004.
|
|
Analysis of Lockbox Costs and Benefits
Data Needed for Analysis |
|
|
Calculation |
Example |
| Number of Items |
|
100,000 |
|
Item cost |
|
$0.20 |
| Average invoice |
|
$20 |
| Reduced staffing costs |
FTE savings in dollars |
$25,000 |
| Prevailing interest rate |
|
5% |
| Additional days invested (i.e., float reduction) |
Float reduction is sum of:
Improved mail float = 0.5 day
Improved processing float = 2 days
Improved availability float = 0.5 day
|
3 days |
| Float savings |
(Number of items) x (Average invoice) x (Additional days invested) x (Daily interest rate)
Example: 100,000 x $20 x 3 x (0.05 /365) = $822 |
$822 |
Cost/Benefit Analysis |
|
|
Calculation |
Example |
| Annual benefits |
Float savings + Reduced staffing costs
Example: $822 + $25,000 = $25,822 |
$25,822 |
|
Annual cost |
Item cost x Number of items
Example: $0.20 x 100,000 = $20,000 |
$20,000 |
| Annual net benefits |
Annual benefits - Annual costs
Example: $25,822 - $20,000 = $5,822 |
$5,822 |
Note: Data adapted from mid-sized Illinois municipality.
|
|
GFOA Cash Management Committee Updates Recommended Practice on Lockboxes
The GFOA Cash Management committee recently updated its recommended practice on the use of lockbox services. The new practice recommends that government entities evaluate the benefits and costs of utilizing lockbox services to determine if advantages can be gained in the areas of accuracy, cash flow, internal controls, and efficiency. The evaluation should consider:
- Availability of lockbox services
- An analysis of the existing workflow from receiving mail to depositing payments and posting receivables
- Volume of transactions
- Staffing requirements
- Time necessary to complete
- Expected float savings from using a lockbox
- Security of the process
- Employee accuracy
- Enhanced customer service
- Capital requirements
- Lockbox service charges
- Technical requirements
- Other considerations
|
|
Example: Lockbox Services Section in an RFP for Banking Services
- What is your deadline for data transmissions?
- Please describe the locations of your processing center.
- Please describe how processing errors are resolved and expected timeframes for resolution.
Below is a list of lockbox options next to which we have placed an “XX” for those items we require, and an “X” for those items in which we have an interest, but may not require. Please specify whether these options are available at your bank.
____ Remittance with photocopy
____ Remittance without photocopy
____ Attach photocopy to documents
____ Attach photocopy to documents and envelopes
____ Return envelopes
____ Invoice balances to check
____ Return Items included in mailed work
____ Weekend processing and deposit
____ Remittance document includes change of address
Reporting/Communications
____ Data keying
____ Full check MICR capture
____ Data transmission formats
___ BAI ___ 823 ___ 820 ___ Other (please explain)
____ CD/ROM
____ Email/fax
____ Internet
____ Imaging of checks
____ Third party reporting
RFPs for Lockbox Services
|
|
|
|
| Economy and Interest Rates |
| Panel of Economists |
|
| Interest Rate Outlook |
| Rate |
July-07
Average
(Low-High) |
Sept-07
Average
(Low-High) |
Dec-07
Average
(Low-High) |
| Fed Funds |
5.25
5.25 - 5.25 |
5.25
5.25 - 5.25 |
5.25
5.25 - 5.25 |
| 30-day prime bank (CD) |
5.30
5.30 - 5.30 |
5.30
5.30 - 5.30 |
5.30
5.30 - 5.30 |
| 3-month T-bill yield |
5.18
5.15 - 5.20 |
5.23
5.15 - 5.30 |
5.23
5.15 - 5.30 |
| 5-year Treasury note |
4.75
4.70 - 4.80 |
4.78
4.70 - 4.85 |
4.95
4.80 - 5.10 |
| 30-year Treasury bond |
4.90
4.80- 5.00 |
4.95
4.80 - 5.10 |
5.05
4.90 - 5.20 |
The Public Investor's panel of eminent institutional economists projects interest rates for the first day of each forecast month. Averages are the midpoints between the arithmetic mean and the median of individual projections. The low and high individual forecasts illustrate the range.
|
|
Interest rate forecast panelists
|
John Silvia |
Wachovia Securities |
|
Carl R. Tannenbaum |
LaSalle Bank ABN/Amro |
|
|
|
According to John Silvia of Wachovia Securities, the housing downturn is leading to weaker retail sales. Silvia predicts GDP growth of 3 percent and CPI inflation of 2.3 percent for the second half of this year. He expects that the Federal Reserve will keep the Fed Funds rate unchanged.
|
|
|
Effect of Housing Downturn on Economy
This month, Treasury Management asked its panel of economists what effect the downturn in the housing market is having on other sectors of the economy. We also asked the economists to provide their forecast of the economy over the next six months.
Carl Tannenbaum of LaSalle Bank/ABN-Amro says that there has been remarkably little spillover from the housing downturn to other sectors of the economy. However, he expects that the weakness in real estate will affect consumer spending during the year. Tannenbaum predicts that strong corporate profits should support business spending for the rest of this year, which he expects to post below-potential growth rates around 2.5 percent. He anticipates persistent inflation due to price pressures from energy, food, and monetary policy.
Lacy Hunt of Hoisington Investment Management states that growth in the first quarter of this year was the slowest in four years. He notes that four critical “big ticket” sectors – housing, household goods, automobiles, and capital spending – have all fallen into recessionary conditions. In fact, according to Hunt, the main problems in the housing sector still lie ahead. For example, housing completions have not been brought down into alignment with the slump in housing starts. The decline in U.S. home prices will reduce the amount of cash that households can extract from their homes and use to purchase consumer goods and services. He notes that the risk continues to rise for a recession late in 2007 or 2008.
|
|
| Snapshot of Economy and Interest Rates |
|
| Economic Summary |
| |
Current
Period |
Previous
Period |
Year
Ago |
| Economic Growth |
|
|
|
Real GDP growth
Annual rate, constant dollars |
I Q '07
1.3% |
IV Q '06
2.5% |
Year Ago
5.6% |
Retail sales
$ billions |
April
372.03 |
Mar
372.88 |
Year Ago
360.61 |
Industrial production index
Change, monthly and annually |
April
0.7% |
Mar
-0.3% |
12 mo. chg.
1.9% |
Leading indicators index
Change, monthly and annually |
April
-0.5% |
Mar
0.6% |
12 mo. chg.
-1.2% |
New housing starts
Thousands of units, annualized |
April
1,528 |
Mar
1,491 |
Year Ago
1,821 |
Purchasing Management Index
Institute for Supply Management |
April
54.7 |
Mar
50.9 |
Year Ago
56.9 |
| Inflation |
|
|
|
Consumer price index
Change, monthly and annually |
April
0.4% |
Mar
0.6% |
12 mo. chg.
2.6% |
Producer price index
Change, monthly and annually, seasonally adjusted |
April
0.7% |
Mar
1.0% |
12 mo. chg.
3.2% |
GDP price deflator
Annual rate |
I Q '07
4.0% |
IV Q '06
1.7% |
Year Ago
3.3% |
Unemployment rate
BLS |
April
4.5% |
Mar
4.4% |
Year Ago
4.7% |
| Other |
|
|
|
Money market fund maturities
Average portfolio maturity
(Money Fund Report Averages TM) |
May 15
42 days |
April 17
41 days |
May '06
38 days |
|
|
| Investment Performance Benchmarks |
| The Public Investor 10-bill index |
| |
Quarterly/Monthly Return |
Annualized Returns Since |
|
Date |
Index |
Annualized |
Jan.1, 2006 |
Jan. 1, 2005 |
| Jan. 1, 2006 |
288.3628 |
3.99%(Q) |
2.97% |
2.10% |
| Jan. 1, 2007 |
302.2210 |
5.33%(M)
5.51%(Q) |
4.81% |
3.89% |
| April 1, 2007 |
306.0307 |
5.50%(M)
5.14%(Q)
|
4.87% |
4.02% |
| May 1, 2007 |
307.3590r |
5.33%(M)r
|
4.90%r |
4.07% |
| June 1, 2007 |
308.3175 |
3.81%(M)
|
4.84% |
4.06% |
|
| The money market fund index |
| |
Annualized Returns Since |
|
Date |
Average Return |
Jan.1, 2006 |
Jan. 1, 2005 |
| Jan. 1, 2006 |
3.51%
|
2.47% |
1.29% |
| Jan. 1, 2007 |
4.85%
|
4.39% |
2.78% |
| April 1, 2007 |
4.87%
|
4.47% |
2.98% |
| May 1, 2007 |
4.87%
|
4.50% |
3.04% |
| June 1, 2007 |
4.84%
|
4.52% |
3.09% |
|
| S&P Rated LGIP Index |
|
Date |
7-day yield |
30-day yield |
Maturity (Days) |
| May 18 , 2007 |
5.08% |
5.09% |
28 |
|
| Key Rates: Cash Markets |
| Rate |
05/25/07 |
Year Ago |
| Fed funds |
5.29 |
5.00 |
| CDs: Three months |
5.31 |
5.20 |
| CDs: Six months |
5.33 |
5.30 |
| BAs: One month |
5.29 |
5.04 |
| T-bills: 91-day yield |
4.78 |
4.71 |
| T-bills: 52-week yield |
4.94 |
5.00 |
| Commercial paper, dealer-placed, 3 months |
5.24 |
5.08 |
| Bond Buyer 20-bond municipal index |
4.38 |
4.52 |
| Tax-exempt notes |
3.66 |
3.57 |
|
| Relative Value Yield Chart |
 |
Notes
Moving Averages - Public Investor's four-week moving averages are calculated as a simple average of Friday closing yield quotations for the most recently offered six-month Treasury bill (discount basis), two-year Treasury note, and 10-year Treasury note. Moving averages are used by analysts to monitor trends and trend changes. Generally, interest rates are increasing (prices falling) when the moving average yield is rising and the current rate exceeds the moving average. Conversely, current yields below a declining moving average are associated with lower interest rates (high prices on fixed-income securities). Some market timers buy (or sell) longer maturities when current market yields fall below (or penetrate above) their moving averages.
The Public Investor 10-bill index - This index consists of 10 hypothetical Treasury bill investments, with an average maturity of approximately 80 days. Every other Thursday, a T-bill matures and proceeds are reinvested alternately in the three-month and six month T-bills. This rolling index provides a benchmark for evaluating cash management portfolios with biweekly payment and payroll requirements. The original value of the index was 97.6765 on July 1, 1984.
The money market fund index - This index is the simple average of Money Fund Report Averages ™ seven-day money market fund indexes, as reported for the two weeks closest to the end of each month. The annualized return is calculated using these rates for a four-week period centering on the first of each month. The results should simulate returns from passive investment in an average money market fund.
S&P Rated LGIP Index - This index is comprised of local government investment pools that are rated AAAm or AAm by Standard & Poor's and represents pools that strive to maintain a stable net asset value.
|
| Executive Director/CEO: Jeffrey Esser |
Editor: R. Gregory Michel |
The Public Investor is published monthly by the Government Finance Officers Association (GFOA), 203 N. LaSalle Street, Suite 2700, Chicago, IL 60601. (312/977-9700; email: PublicInvestor@gfoa.org) Annual subscription rates are $55 for active GFOA members, $70 for associate GFOA members, and $85 for nonmembers. For reprint permission contact GFOA.
The information and opinions printed herein are from sources believed to be reliable, but GFOA makes no guarantee of accuracy. Opinions, forecasts and recommendations are offered by individuals and do not represent official GFOA policy positions. Nothing herein should be construed as a specific recommendation to buy or sell a financial security. |
Government Finance Officers Association of the United States and Canada
|
|