TEXPO KPI Presentation 02-2012 sbHANDOUT

1 3/2 treasury Performance with KPIsSteve Bullock, SVP & General ManagerTEXPO 2012 BenchmarkingTreasury Performance with KPIsAgenda A Brief Introduction to Key Performance Indicators The Value of treasury kpis The KPI Selection Process Practical examples of kpis Tools of the Trade Conclusion Q&ABenchmarking treasury Performance with KPIsIntroduction to Key Performance Indicators Key Performance Indicator/k p r f rm ns indi k t rKPIshelp to get insight in your business performance --"What gets measured, gets managed". kpis are also known as performance metrics , business indicators, and performance also be seen as.

2 Measure mania , the tyranny of targets, silo working and feeding the beast 3/2/20122 Benchmarking treasury Performance with KPIsThe Value of treasury kpis treasury s management reporting burden has increased since the financial crisis first struck treasury s importance requires objective, transparent and controlled workflows to support cash & risk management and treasury accounting kpis Key Performance Indicators are an established benchmarking tool treasury kpis provide structured, objective benchmarking results - SOX compliance is enhancedBenchmarking treasury Performance with KPIsSelecting kpis for your treasury KPI programs are usually defined & implemented via enhanced treasury policy application treasury kpis are delivered through technology, and integrated into the treasury process workflow Choosing kpis can be demanding!

3 Your kpis should reflect your specific need and priorities Benchmarking treasury Performance with KPIsBusiness Objectives of KPI Selection For the treasury Team to gain a better understanding of and ability to monitor and improve the performance of their daily tasks For Management to benchmark critical treasury operations, and track & analyse performance improvement For Auditors to enjoy a more accurate, objective and dependable insight into treasury3/2/20123 Benchmarking treasury Performance with KPIsSample kpis Liquidity and Cash Management kpis Funding and Investment Management kpis FX, Commodity and Interest Rate Exposure Management kpis treasury Operations and Accounting kpis Risk Management and Policy Compliance KPIsBenchmarking treasury Performance with kpis Liquidity and Cash Management KPIsKPI: Percentage of Account Balances Reported DailyObjective.

4 Supporting the monitoring and measuring of the effectiveness of the daily bank account balance reporting mechanism. Typical Calculation: 100% Benchmarking treasury Performance with kpis Liquidity and Cash Management KPIsKPI: Percentage of wires which were released on timeObjective: To help ensure that wire processing is efficientTypical Calculation: 100% 3/2/20124 Benchmarking treasury Performance with kpis Liquidity and Cash Management KPIsKPI: Time taken to initiate and complete a signatory change on a bank accountObjective.

5 To ensure that authorized signers can be added or removed from accounts in a timely fashion to support controlled changes in the organizationTypical Calculation: Benchmarking treasury Performance with kpis Liquidity and Cash Management KPIsKPI: Percentage Forecast ErrorObjective: To improve the level of transparency of cash forecasting accuracyTypical Calculation: 100% Benchmarking treasury Performance with kpis Liquidity and Cash Management KPIsKPI: Absolute Cash Balance ErrorObjective: To minimize the required cash buffer in order to maximize the investment amount; or to minimize the borrowing amount improve the level of transparency of cash forecasting accuracyTypical Calculation: 3/2/20125 Benchmarking treasury Performance with kpis Liquidity and Cash Management KPIsKPI: Absolute value of cash swept automatically from/to ZBA accountsObjective: To maximize the amount of cash that is mobilized for reuse within the organization.

6 Typical Calculation: | !"# | Benchmarking treasury Performance with kpis Liquidity and Cash Management KPIsKPI: Daily pooling & sweeping benefitObjective: To monitor that pooling & sweeping benefits outweigh the costs of these processes. Typical Calculation: $ " % " &" " & $ " % ' ( " ' ( where$ " = | | & | | Benchmarking treasury Performance with kpis Funding & Investment Management KPIsKPI: Funding BufferObjective: To help ensure that the business has access to the funds it anticipates needing over a specified time period.))

7 Typical Calculation: + + ( + ( , 3/2/20126 Benchmarking treasury Performance with kpis Funding & Investment Management KPIsKPI: Maximum percentage of available credit per provider Objective: To support assurance that funding is not too dependent on too few providers. Typical Calculation: +-.. 100%/ where. =. ( ( Benchmarking treasury Performance with kpis Funding & Investment Management KPIsKPI: Maximum percentage of investment per providerObjective: To monitor that the value of assets at risk with any one provider is not greater than a set percentage of the total investment portfolio.))))

8 Typical Calculation: +-# # 100%/ where# =# ( & Benchmarking treasury Performance with kpis Funding & Investment Management KPIsKPI: Weighted average CDS spread of the investment portfolioObjective: To monitor the portfolio s overall non-performance risk. Typical Calculation: 012 # # whereand# =# ( & 012 =012 , 3/2/20127 Benchmarking treasury Performance with kpis FX, Commodity & Interest Rate Exposure Management KPIsKPI: Percentage that the traded rate deviates from the market or benchmark rateObjective: To ensure that executed hedges are close to the current market or benchmark rateTypical Calculation: | + , | , 100% Benchmarking treasury Performance with kpis FX, Commodity & Interest Rate Exposure Management KPIsKPI.))

9 Prospective hedge effectivenessObjective: Prove that future changes in value of the each hedge are expected to be effective in offsetting the changes in value of the hedged exposures. Typical Calculation: 3 ( 3 ( 100% Benchmarking treasury Performance with kpis FX, Commodity & Interest Rate Exposure Management KPIsKPI: Fixed/Floating Rate MixObjective: To Protect earnings and/or future cash flow against adverse interest rate movements by ensuring that fixed and variable portions of the interest rate portfolio are in line with the treasury policy.))

10 Typical Calculation: # + + # + 100% 3/2/20128 Benchmarking treasury Performance with kpis treasury Operations & Accounting KPIsKPI: Time taken to confirm new trade details with the counterpartyObjective: To help ensure that trade details are confirmed with the counterparty within a target timeframeTypical Calculation: & + Benchmarking treasury Performance with kpis treasury Operations & Accounting KPIsKPI: Number of days taken for cash transactions to reach the GLObjective: To help ensure that cash transactions reach the GL within a specified timeframe.