[Image] GFOA Logo 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.

Top

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.

Top

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

Moving averages
6-Month Treasury Bill


2-Year Treasury Note


10-Year Treasury Note


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.
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


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
[ Archive ] [ Feedback ] [ e-Store ]