![[Image] GFOA Logo](http://www.estoregfoa.org/StaticContent/Images/revlogo.gif) |
Public Investor |
June 2 , 2006
Volume 24, Number 6 |
|
| Inside This Issue |
| |
Feature Articles and Resources
|
|
|
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
|
|
|
|
Use of Account Analysis Statements
By Donald E. Gray, Jr.
Are government
finance officers using account analysis statements (AAS) for the
purpose they are intended? An account analysis statement is a monthly
report produced by a government’s bank that lists the services
provided to a government and the compensating balances required to keep
on deposit at the bank to pay for these services. By using these
statements, a finance officer should be able to determine the best way
to pay for bank services, whether it be 1) direct fees, 2) compensating
balances, or 3) a combination of both.
Analyzing the Statement.
The first step in analyzing the AAS is to make sure the bank sends it
every month. If the bank is not sending it, finance officers should
request it. Also, an AAS should be received for each account with the
bank along with a summary statement that combines all accounts.
The earnings credit rate on
the AAS is an interest rate applied to the investable balance of a
demand deposit account to determine a fee-based equivalent balance. The
investable balance is determined by subtracting reserves from the
average collected balance for each account. Banks are required to keep
10 percent of their net demand deposits (checking accounts) at their
Federal Reserve bank. Banks pass this expense on to their customers.
Make sure that the reserve requirement on the AAS is not higher than 10
percent. If it is, have the bank adjust the account and adjust for
prior periods as necessary. Since 90 percent of the available balances
are usable for offsetting services, paying for services with fees is
more cost efficient.
Banks have some latitude
with earnings credit rates (ECR). A higher ECR may look good initially,
but it may be accompanied by higher service prices. Similarly, a low
ECR and lower than average prices may be increasing the bank’s
profits at the government’s expense. Therefore, keep track of the
ECR each month and compare the ECR of different banks. A rule of thumb
is that the ECR should be similar to the 3-month Treasury bill rate.
Each month compare the types
of transactions, volume of transactions, and the cost for the same
transactions from each bank. By placing this information onto a
spreadsheet, trends and discrepancies will become apparent. The
transaction volume for each bank service may be used in price
negotiations with the bank. Price fluctuations within a bank may
indicate that prices have been raised without the government’s
knowledge. This review also should disclose charges for services that
are not being performed or for services that are no longer being used,
such as special accounts that no longer have any transactions. Banks
generally charge a monthly maintenance fee just to keep an account open.
By reviewing and analyzing
the AAS, a government can be assured that it is: 1) paying only for
services used, 2) paying a fair and equitable fee for these services,
3) not losing the use of some of the potential earning on the
government’s funds by keeping excessive non-performing balances
in the banks, and 4) creating a database to use in the future when
preparing an RFP for banking services.
Donald E. Gray, Jr. is a former president of the New England States Government Finance Officers Association.
|
|
|
|
| What is an Account Analysis? |
|
An account analysis is a type of
monthly statement banks provide to their governmental and other
institutional customers. Essentially, it is the bank's monthly invoice
for services rendered. The account analysis differs from bank
statements for retail customers because it is not a list of paid checks
and deposits; rather, it is an expanded list of services provided by
the bank (e.g., the volume of checks presented and cleared) and their
costs. In some cases, the provision of an account analysis may not be a
standard practice, in which case it would need to be requested from the
bank as part of the RFP.
The government should request an
account analysis statement for each bank account that the government
maintains, accompanied by a summary statement for all accounts. The
summary statement is simply a consolidated report of multiple account
analysis statements. Compensation to the bank should be based upon the
summary statement, as opposed to the individual account analysis
statements. The account analysis can be delivered through the bank's
electronic reporting tool, or through the mail.
|
|
|
|
|
|
Analyze This!
By Susan M. Cotton
An agency’s bank
account analysis statement is a window into the banking relationship
and is the best tool available to review and understand any banking
arrangements in place.
First of all, if you do not
know what an account analysis statement is, then you need to talk to
your bank to make sure that your agency’s checking accounts are
being analyzed, and if they are being analyzed, that you are receiving
the monthly statements. Sometimes not all accounts for one reason or
another are on account analysis, and sometimes statements are mailed to
an incorrect address or department.
Even if you do receive a
monthly bank account analysis statement, you may ask, “What is
it?” or “Why should I care?” Account analysis
provides you and the bank with a recap of all banking activity
associated with your agency to include services utilized, related
volumes and pricing, and a summary of balances maintained and any fees
owed. Further, it is through account analysis that banks provide their
clients with a soft-dollar interest rate (earnings credit rate) that is
applied to balances maintained in the accounts. This credit is then
used to offset service charges. One should care about account analysis
because by reviewing statements on a regular basis, an agency can
double-check pricing, catch possible errors, and monitor balances, and
consequently be in control of its overall bank fees.
Often, agencies do not start
paying attention to account analysis until they receive an
unanticipated invoice or auto debit for bank service charges. If an
agency wants to be in command of its banking activity and the related
fees (and not surprised by banking invoices), the primary way to
accomplish this is to stay on top of account analysis on a
month-to-month basis.
Here are some tips for getting up close and personal with your account analysis statements:
Start at the Top.
The top section of the first page of the statement usually outlines
balances maintained for that month—ledger, collected, and
available—for all of the accounts on analysis. Ledger is the
gross amount of funds deposited, collected is after check clearing
float, and available is after 10 percent reserves are deducted.
Check the Earnings Credit Rate.The
earnings credit rate is applied to available balances and generates the
monthly earnings allowance. You should understand how the rate is
derived, and generally it should approximate the 3 month T-Bill rate.
This item becomes a hidden fee if the rate is too low.
Surplus or Deficit? Your
primary concern each month should be whether you have an earnings
allowance surplus or deficit and how either will be handled by the
bank. If you have a surplus and your bank does not roll it over to
prior or future months, you lose. If you have a deficit, you need to
know if that also can be carried over to future months when you might
have a surplus.
Pick Settlement Period.
The settlement period is the frequency that a bank reviews a
client’s earnings allowance positions and sends a bill if an
amount is owed. Needless to say, most banks prefer their clients to be
on monthly settlement, and most clients would like to be on quarterly
or even annual settlement. Generally, if the agency is paying fees
every month, then the settlement really should be monthly. If the
client keeps high balances and has occasional or frequent surpluses,
then the settlement should be at least quarterly.
Fees or Balances? This
is the perennial question. In general, one should pay for bank services
with fees. This is primarily because the prevailing earnings credit
rates are low compared to alternative investment returns, and they are
further lowered by the 10 percent reserve requirement. With an
increasing interest rate environment, it is imperative that agencies do
the math regarding fees versus balances and make a policy decision
about how they are going to compensate for banking services, so there
are no surprises.
Fiscal Year vs. Calendar Year. Banks
work on a calendar year basis, so any account analysis discrepancies in
your favor need to be resolved before each December 31st. Otherwise,
the banks are hard-pressed to make adjustments once the new calendar
year has commenced. So, start in November of each year looking at all
of the activity to date to make sure there are not any unresolved
issues.
Review Line Item Detail. The
meat of the account analysis statement lies in the line item detail:
service descriptions, volumes, and per item prices. If you do not
understand what any of the items are, you can request a glossary of
terms from the bank or call your relationship manager and ask for a
training session. Many agencies, especially larger ones, will download
their account analysis statements (available on-line from the bank) to
a spreadsheet program, so that they can track all of the line items on
a monthly basis.
In summary, the more you
understand about your agency’s account analysis, the less you
will end up paying in bank fees. And what you do end up paying can be
planned and budgeted for.
Susan
M. Cotton is a Certified Treasury Professional and manages the firm,
Money Matters Consulting. Reprinted with permission from Dollars & Sense, California Municipal Treasurer's Association, Fall 2005, p. 12.
|
|
|
|
|
| Sample Balance Analysis (Simplified) |
|
|
Example for One Month
|
Remarks |
|
Average Daily Balance
|
$862,743
|
The Average Daily
Balance is simply the amount of cash on hand at the end of each
business day—the bank’s book or ledger balance—not
necessarily the amount available to the government (owing to the
reserve requirment and other factors discussed below). Determining the
average depends on the method employed by the bank, and generally can
be approached in at least two ways: (a) the sum of the beginning and
ending balance divided by the number of days within the month, or (b)
“true average.” Calculating the daily balance with the true
average (balance determined daily, summed, then divided by the number
of days) takes into account every day within a billing period and
thereby generates the most complete portrayal of daily balance.
|
|
Less Average Float
|
(16,539)
|
Average Float refers
to funds in transit through the U.S. banking system. Float measurement
may differ from bank to bank, therefore if actual float is not used,
the bank should specify so in their proposal.
|
|
Average Collected Balance
|
846,204 |
Average Collected Balance is simply equal to the average daily ledger balance less average float.
|
|
Less 10% Reserve Requirement
|
(84,620) |
Federal Reserve
regulations require that a percentage of all deposited funds be held in
reserve. Generally this is 10 percent of deposits. To offer a more
competitive RFP proposal, some banks will waive the 10 percent offset
for the purposes of the account analysis.
|
|
Average Investable Balance
|
761,584 |
Average Investable
Balance is the portion of the government’s average daily account
balance that is available for investment after subtracting float and
reserve balance requirements.
|
|
Earnings Credit Allowance
|
$2,911 |
Earnings Credit
Allowance is the income the government’s Average Investable
Balance would have earned for one month if it had been invested at the
earning credit rate (ECR). The earnings credit allowance is the amount
that is used to essentially pay for banking fees, under a compensating
balances or blended method.
|
|
Note: The assumed annual
earnings credit rate (ECR) of 4.50 percent is converted to a monthly
figure to determine the monthly earnings credit allowance. The ECR may
fluctuate according to an index. This table is adapted from the GFOA
publication Banking Services: A Guide for Governments, 2004.
|
| Sample Account Analysis (Simplified): Analysis of Service Costs (for a Single Month) |
|
Category / Service
|
Number of Units
|
Unit Price |
Charge for Service (rounded) |
1. General Account Services / Account Maintenance
|
1
|
$42.00
|
$42
|
|
2. Depository Services / Deposit Checks (Encoding)
|
950
|
0.095
|
90
|
|
3. Branch Teller services / Credits Posted (Branch)
|
44
|
3.750
|
165
|
|
4. Retail Lockbox Services / Lockbox Payments
|
1,273
|
0.27
|
344
|
|
5. ACH / ACH Direct Items
|
230
|
0.20
|
46
|
|
Total Fees
|
|
|
$687
|
|
Note: Figures are illustrative only, not actual government data. This table is adapted from the GFOA publication Banking Services: A Guide for Governments, 2004.
|
|
Analysis to Determine Optimal Account Balance
| Data Needed for Analysis |
| |
|
Source of Data/ Calculation
|
Example for One Month
|
| A |
Term |
Calendar year days divided by number of days in specific month (365 days/31 days in January)
|
11.7742
|
| B |
Earning credit rate |
Index as defined in RFP
(may fluctuate)
|
4.50%
|
| C |
Term earning rate |
Earnings credit rate divided by
term (B/A)
|
0.382%
|
| D |
Dollars in balance to
offset $1 in service
charges
|
Term divided by earnings credit rate (A/B)
|
$ 262
|
| E |
Total monthly service
charges |
From account analysis
|
$ 687
|
| Calculation of Excess (or Deficit) Balance |
| |
|
Source of Data/ Calculation
|
Example for One Month
|
| F |
Average daily balance |
Sum of daily balance divided by
number of days in month
|
$862,743
|
| G |
Average float balance |
Verify with bank; should be similar
to ledger balance
|
$ 16,539
|
| H |
Average collected balance |
Average daily balance less average
float balance (F-G)
|
$846,204
|
| I |
Reserve requirement
|
10 percent of average collected
balance (H x 0.10)
|
$ 84,620
|
| J |
Average investable balance |
Average collected balance less
reserve requirement (H-I)
|
$761,584
|
| K |
Balance required for service charges |
Dollars in balance to offset $1 in
service charges multiplied by Total
service charges (D x E)
|
$179,753
|
| |
Excess (deficit) balance |
Average investable balance less
balance required for service
charge (J-K)
|
$581,831
|
| Calculation of Excess (or Deficit) Earnings |
| |
|
Source of Data/ Calculation
|
Example for One Month
|
| L |
Earnings Credit Allowance |
Average investable balance
multiplied by term earning rate
(J x C)
|
$ 2,911
|
| M |
Total monthly service charges |
From account analysis
|
$ 687
|
| |
Excess (deficit) earnings |
Earnings credit allowance less total
service charges (L-M)
|
$ 2,224
|
|
|
|
| Panel of Economists |
| Interest Rate Outlook |
| Rate |
July-06
Average
(Low-High)
|
September-06
Average
(Low-High) |
December-06
Average
(Low-High) |
| Fed Funds |
5.0
5 - 5 |
5.0
5 - 5 |
5.0
5 - 5 |
| 30-day prime bank (CD) |
4.9
4 7/8 - 5 1/8 |
4.9
4 7/8 - 5 1/8 |
4.9
4 7/8 - 5 |
| 3-month T-bill yield |
4.9
4 3/4 - 5 |
4.9
4 3/4 - 5 |
4.9
4 7/8 - 4 7/8 |
| 5-year Treasury note |
4.8
4 3/4 - 5 |
4.9
4 3/4 - 5 |
4.9
4 7/8 - 5 1/8 |
| 30-year Treasury bond |
5.0
4 7/8 - 5 |
5.0
5 - 5 1/4 |
5.1
4 7/8 - 5 1/4 |
| Consensus Index* |
100% |
100% |
100% |
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.
Consensus index is the percentage of responses within 75 basis points
(0.75 percent) of the average interest rate. Index measures the extent
of panelists' agreement. If all forecasts are with 3/4 percent of the
various averages for a given month, the consensus would be 100. If all
responses fall at the extreme ends of a wide range, the index is 0. |
|
Interest rate forecast panelists
| John Silvia |
Wachovia Securities |
| Carl R. Tannenbaum |
LaSalle Bank ABN/Amro |
|
Gary Thayer
|
AG Edwards & Sons, Inc.
|
|
|
|
|
High Energy Prices and the Economy
This month Public Investor
asked its panel of economists to explain the causes behind the rise in
energy prices and predict the effect that high energy prices will have
on the economy. We also asked the panel if energy prices will continue
to increase.
Carl Tannenbaum of LaSalle Bank
ABN Amro expects that rising energy prices will affect household
spending and slow growth, but he does not anticipate a significant
increase in core inflation. Tannenbaum predicts that, by the end of the
year, oil prices will settle around $60 per barrel.
Gary Thayer of AG Edwards &
Sons expects that rising energy prices will dampen economic growth this
year. He notes that two years ago, the negative impact of rising energy
prices was offset by low interest rates and a strong housing market.
However, this year, these factors are also negative. Thayer states that
energy prices are rising because traders are worried that demand will
outpace supply in a strong global economy.
John Silvia of Wachovia Securities
predicts that high energy prices will contribute to slower growth and
higher inflation, but have no impact on interest rates. Silvia states
that the causes behind the increase in energy prices are global demand
exceeding supply and political risks.
Lacy Hunt of Hoisington
Invest-ment Management states that the economy is likely to slow
substantially over the next six to 12 months due to high energy costs,
higher interest costs, and the wearing off of a temporary boost in the
economy in the first quarter. Hunt expects that any upturn in inflation
due to higher energy costs should be mild and transitory. The
multi-year trend in inflation remains downward.
|
|
Economic and Interest Rate Data
|
| Databank |
| |
Current
Period
|
Previous
Period
|
Year
Ago
|
| Economic Growth |
|
|
|
Real GDP growth
Annual rate, constant dollars |
I Q '06
4.8% |
IV Q '05
1.7% |
Year Ago
3.8% |
Retail sales
$ billions |
April
362.68 |
Mar
360.92 |
Year Ago
340.26 |
Industrial production index
Change, monthly and annually |
April
0.8% |
Mar
0.6% |
12 mo. chg.
4.7% |
Leading indicators index
Change, monthly and annually |
April
0.4% |
Mar
-0.4% |
6 mo. chg.
0.7% |
New housing starts
Thousands of units, annualized |
April
1,849 |
Mar
1,996 |
Year Ago
2,079 |
Purchasing Management Index
Institute for Supply Management |
April
57.3 |
Mar
55.2 |
Year Ago
53.8 |
| Inflation |
|
|
|
Consumer price index
Change, monthly and annually |
April
0.6% |
Mar
0.4% |
12 mo. chg.
3.6% |
Producer price index
Change, monthly and annually, seasonally adjusted |
April
0.9% |
Mar
0.5% |
12 mo. chg.
4.0% |
GDP price deflator
Annual rate |
I Q '06
3.3% |
IV Q '05
3.5% |
Year Ago
3.1% |
Unemployment rate
BLS |
April
4.7% |
Mar
4.7% |
Year Ago
5.1% |
| Other |
|
|
|
Money market fund maturities
Average portfolio maturity
(Money Fund Report Averages TM) |
May 16
38 days |
April 18
37 days |
May '05
22 days
|
|
|
|
| Investment Performance Benchmarks |
| The Public Investor 10-bill index |
| |
Quarterly/Monthly Return
|
Annualized Returns Since
|
|
Date
|
Index
|
Annualized
|
Jan.1, 2005
|
Jan. 1, 2004
|
| Jan. 1, 2005 |
280.0364
|
1.93% (Q)
|
1.23%
|
1.16%
|
| Jan. 1, 2006 |
288.3628
|
3.99%(Q)
|
2.97%
|
2.10%
|
| April 1, 2006 |
291.2848
|
4.66%(M)
4.12%(Q)
|
3.20%
|
2.32%
|
| May 1, 2006 |
292.3697r
|
4.56r%(M)
|
3.29r%
|
2.40r%
|
| June 1, 2006 |
293.5509
|
4.96%(M)
|
3.38%
|
2.49%
|
|
The Public Investor 10-bill
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 |
| |
Annualized Returns Since
|
|
Date
|
Average Return
|
Jan.1, 2005
|
Jan. 1, 2004
|
| Jan. 1, 2005 |
1.46%
|
0.76% |
0.82% |
| Jan. 1, 2006 |
3.51%
|
2.47% |
1.29% |
| Apr. 1, 2006 |
4.04% |
2.73% |
1.50%
|
| May 1, 2006 |
4.21% |
2.7382% |
1.507%
|
| June 1, 2006 |
4.33%
|
2.90% |
1.64% |
|
The money market fund 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 |
|
Date
|
7-day yield
|
30-day yield
|
Maturity (Days)
|
| May 19, 2006 |
4.73%
|
4.66%
|
31
|
|
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. |
| Key Rates: Cash Markets |
| Rate |
5/26/06 |
Year Ago |
| Fed funds |
5.00 |
3.02 |
| CDs: Three months |
5.20 |
3.25 |
| CDs: Six months |
5.30 |
3.50 |
| BAs: One month |
5.04 |
3.04 |
| T-bills: 91-day yield |
4.71 |
2.90 |
| T-bills: 52-week yield |
5.00 |
3.31 |
| Commercial paper, dealer-placed, 3 months |
5.08 |
3.22 |
| Bond Buyer 20-bond municipal index |
4.52 |
4.24 |
| Tax-exempt notes |
3.57 |
2.81 |
|
|
| Relative Value Yield Chart |
 |
|
|