Establishing and Automating Treasury Metrics

Defining Treasury Success

Establishing and Automating Treasury Metrics

B

H ow do we know when treasury is operating effectively? That is the key question many of our corporate clients are asking. They are looking for meaningful metrics that can quickly highlight how various treasury functions are performing.

This need for metrics is most urgent in times of market turmoil and economic distress, when speed, compliance and efficiency are in demand. However, it's a tremendous challenge to identify which activities should be measured, and how to quantify that activity in a meaningful way.

There is a significant opportunity right now for corporations to leverage treasury technology to automate Key Performance Indicators (KPIs), as well as compliance and performance metrics. Through our work consulting with corporations around the world, Treasury Strategies has identified three steps to take in order to establish effective KPIs:

1. Set overall objectives for the financial function and understand how treasury will support those objectives.

2. Decide on the specific operational, investment and strategic treasury activities needed to support financial objectives, and identify the factors that will determine success versus failure for each.

3. Establish processes and technology needed to execute and track these activities, as well as measure and report on progress toward achieving these objectives.

1

Objectives

The first step is to understand the overall financial goals of the corporation and set objectives for treasury to support those goals. To set objectives, there are several questions to ask:

? Is our objective to minimize risk? ? Is our objective to have visibility to all of your cash worldwide? ? Is our objective to reduce errors within treasury operations? ? Is our objective to streamline your banking structure?

What Should be Measured

Treasury should determine the critical activities it will manage to help achieve the previously set objectives. Now it's time to drill down within each objective to determine parameters for monitoring ongoing performance. For example, if one objective is to ensure sufficient liquidity, treasury might designate its corporate finance, investment and cash management functions as necessary to help meet that objective. Within each of those activities, treasury would define exactly what to measure to determine the extent to which treasury is helping to maximize liquidity.

Most of the activities treasury would manage to support organizational objectives fall into three basic categories:

Operational Activities Executing and settling financial transactions such as investments, FX and debt.

Portfolio Analytics Tracking performance of investments, foreign exchange derivatives, commodities and debt, as well as compliance with corporate and regulatory policies.

Strategic Initiatives Managing risk or leading efforts to enhance shareholder value in ways beyond traditional treasury.

2

Most companies focus their metrics on operational activities, thus analytic and strategic activities are often overlooked. However, it is crucial to report meaningfully across all three categories. Strategic KPIs are more difficult to track and report. As our clients undertake these activities, they are asked for progress--sometimes it's fairly evident.

The KPIs listed below are directional illustrations. Specific KPIs for your company would be determined by industry, as well as the size and scope of treasury.

Operational KPIs

KPI

Examples

Cash Concentration Balance Cash vs. Forecast

Total Number of Bank Accounts

Bank Fees

Investments

? Ending balance--the objective is to get as close to zero as possible and monitor any amount remaining in the account.

? Set a target amount for the maximum variance between cash and forecast.

? One metric is 100 bank accounts per billion of revenue. But for companies with $20 billion or $30 billion in revenue, this metric may be too high.

? Discus hard dollar fees and soft dollar earnings from business with the bank to ensure they all make sense on an ongoing basis

? Benchmark against a 3-month Treasury Bill or 3-month Euribor.

? Track returns, both yield and interest income, against meaningful numbers.

? Perform risk analysis, i.e., impact of a significant change in interest rates or the yield curve on investments.

3

Analytical KPIs -- Foreign Exchange

KPI

Examples

Percentage of Exposure Hedged

? Possible % for hedges for forecasted exposures:

Duration

% of Exposure to Hedge

1-3 months 100% of the forecast

4-6 months 80-90%

6-12 months 70-75%

12-18 months 50%

Earnings per Share Impact of Unhedged Versus Hedged Trades Competitively Bid Bank Bidding Performance

Hedge Performance

? Companies with longer product cycles could hedge further out (18-36 months ? 25%)

? Some clients use .01 EPS impact to assess the success of their FX hedging strategy and determine whether any action is required.

? Two or more competitive bids from banks on FX deals.

? Monitor winning bank for specific currency, interest rate, and commodity transactions.

? Many companies have a list of 10 banks for competitive bidding. The top three typically compete for the business. The winning bank stays at the top while the other two drop to the bottom of the list.

? Do-nothing comparison -- how did forward contract hedge perform vs. do-nothing or option instrument.

4

Analytical KPIs ? Counterparty Risk

KPI

Examples

Assessing the Bank's Financial Health

Percentage of Counterparty Limits Used

Total Exposure to a Counterparty

? Credit rating -- Lehman's A credit rating at the time of bankruptcy caused companies to implement other metrics, such as: - Credit default swap (CDS) spread < 150 basis points for 1 year CDS - Tier II Capital - Tangible common equity - Probability of default

? Some companies set their mark-to-market derivative limits based on the credit rating to measure % used. Examples are listed below. The appropriate amount is based on volume of derivative activity.

Rating AAA AA A

Sample Limit $20 million $10 million $1 million

? Some metrics for money market funds include: - Maximum amount in any single fund - Minimum investment in rated fund - Maximum investment in a fund as a notional amount

? Total counterparty exposure limit is highly dependent on activity and asset levels. Several examples include: - AAA - < $1 Billion - AA - < $500 Million - A - < $100 Million

5

Strategic KPIs

KPI

Examples

Long-Term Funding

Mix of Fixed and Floating Rate Debt Credit Rating

? Annual funding amount required based on forecasts for capital expenditures, merger and acquisition plan, and any longer-term objectives. Existing debt capacity and facilities are also considered.

? 60% fixed vs. 40% floating or 50% fixed vs. 50% floating or 40% fixed vs. 60% floating

? A significant measure for accessing credit and how the market views the company.

Technology

Treasury technology tools provide the means to track and report on your treasury's performance. The technology tools you leverage can range from a full Treasury Management System to a treasury intranet, bank websites, investment and multi-bank FX portals, and data companies like Bloomberg and Reuters.

A Treasury Management System (TMS) is the primary technology used to aggregate data from banks and subsidiaries, as well as track and report on financial transactions. A TMS often facilitates visibility to cash as well as the execution of cash forecasts. TMS vendors are adding functionality to incorporate compliance to policy limits, broader counterparty reporting and greater portfolio analysis. All of this functionality is critical to enable measuring and assessing the metrics outlined above.

Treasury intranets are often used as the central hub for the company's financial policies and procedures. They are also used to share materials and communicate with colleagues in multiple locations.

6

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download