Liquidity Coverage Ratio

Goal of the analysis:

Evaluate the organization’s ability to withstand short-term cash outflows by comparing readily available liquidity to modeled cash needs over a defined stress horizon. The Liquidity Coverage Ratio (LCR) for corporates is typically defined as High-Quality Liquid Assets (HQLA) and committed liquidity sources divided by projected net cash outflows over 30, 60, or 90 days. Executives use LCR to set minimum liquidity buffers, guide refinancing and hedging decisions, calibrate working-capital actions, manage bank relationship diversification, and ensure covenant and facility headroom. A rigorous approach clarifies the definition of “liquid assets” and eligible facilities, haircuts assets for time-to-cash, removes restricted/trapped balances, models stressed outflows (including working-capital swings and collateral calls), and presents results by currency and legal entity constraints.

Data required:

• Liquidity sources (HQLA and facilities):
  • Cash and cash equivalents by bank, entity, and currency; identification of restricted/trapped cash and minimum operating balances.
  • Marketable securities by instrument, credit quality, and time-to-cash bucket (T+0/T+1/T+3/>T+5); haircuts/mark-to-market history.
  • Committed undrawn facilities (RCFs), borrowing base/ABL availability, CP programs and backstops, intercompany loans, standby LCs/guarantees availability.
  • Hedge collateral and margin arrangements (CSA terms, thresholds, frequency).
• Liquidity uses (baseline and stress):
  • 13-week cash flow forecast: collections, disbursements (AP, payroll, taxes, rent, interest, capex, dividends), maturities (debt, leases), M&A closings.
  • Working-capital sensitivities: DSO/DIO/DPO shocks, seasonal inventory builds, returns/chargebacks.
  • Contingent outflows: litigation/settlements, acquisition earnouts, pension contributions, collateral calls (FX/IR/commodity), vendor prepayments.
• Capital structure and constraints:
  • Debt maturity ladder, covenants (minimum liquidity, springing tests), borrowing base advance rates, blocked cash rules, intercompany netting capability.
  • Bank counterparty limits, concentration by lender, and country transfer restrictions.
• Normalization and reference:
  • FX rates and constant-currency policy; fiscal calendar (52/53-week); M&A/divestiture flags; one-offs (large settlements, system cutovers).
  • Treasury policy on minimum buffers, target fixed/floating mix, collateral thresholds, and eligible HQLA haircuts.

Detailed step-by-step instruction on how to conduct the analysis:

1. Define scope, horizon, and policy parameters.
   • Select horizons (30/60/90 days) and a stress case (e.g., revenue −10%, DSO +8 days, DIO +7 days, DPO −5 days, 200 bps interest shock on floating, ±5% FX move).
   • Codify HQLA eligibility and haircuts (e.g., cash T+0 haircut 0%; T+1 government bills 1–2%; IG corporates T+3 3–5%). Exclude restricted/trapped cash and minimum operating cash from numerator.
   • Determine treatment of committed facilities: include undrawn committed capacity net of covenants/borrowing base and draw mechanics (funding T+0/T+1).
2. Assemble liquidity sources.
   • Extract cash/securities by account, entity, and currency; classify by time-to-cash and apply haircuts.
   • Compile RCF/ABL availability: limit − current drawings − letters of credit − covenant buffers; calculate effective availability by currency and entity.
   • Identify intraday requirements and minimum cash per entity; tag trapped balances (capital controls, tax frictions) and exclude from HQLA.
3. Model baseline and stressed outflows.
   • Start with the 13-week direct cash forecast; aggregate weekly into 30/60/90-day buckets.
   • Overlay stress adjustments: slower collections (DSO), higher inventory/returns, lower supplier terms (DPO), incremental interest, tax timing, and potential collateral/margin calls (based on VAR thresholds or recent history).
   • Include scheduled maturities (debt/leases) and required repayments; separate discretionary outflows (dividends, buybacks, capex deferrals).
4. Compute LCRs by horizon and currency.
   • LCR(30) = Eligible HQLA (haircut-adjusted, T+0/T+1 only) + Committed capacity fundable in ≤T+1, divided by net cash outflows over 30 days.
   • Repeat for 60/90-day horizons with broader HQLA buckets (include T+3 instruments for 60/90 as policy allows).
   • Calculate consolidated and currency-specific LCRs (e.g., USD, EUR, local currencies) to reveal FX/liquidity transfer risks.
5. Assess constraints and headroom.
   • Test covenant headroom and borrowing base under the stress case; identify any springing covenants that could limit facility access.
   • Check bank concentration (top-3 facilities share) and country transferability; note any legal-entity ring-fencing that reduces fungibility.
6. Bridge and trend analysis.
   • Build a bridge: Prior LCR(30) → Changes in cash/securities (market moves, redemptions) → Facility availability (draws/LC usage) → Outflow changes (WC drivers, maturities) → FX/one-offs → Current LCR.
   • Plot 6–8 quarters of 30/60/90-day LCR with policy bands and major events (refis, hedges, acquisitions).
7. Scenario and sensitivity testing.
   • Run shocks: +10 DSO days, +15% collateral calls, CP market shut for 30 days, downgrade-triggered margining; recompute LCR.
   • Test mitigations: draw RCF pre-emptively, extend DPO +10, accelerate collections −8 DSO, defer capex $X, rotate T+3 to T+1 securities; quantify LCR uplift and cost.
8. Integrity checks.
   • Eliminate double counting (cash pledged for LCs/derivatives cannot be counted as HQLA); ensure facilities are net of LC utilization and covenant buffers.
   • Verify time-to-cash classifications and haircuts; confirm legal-entity constraints and tax leakage on upstreaming.
   • Reconcile to GL and treasury systems; maintain documentation of stress assumptions.
9. Synthesize actions and policy recommendations.
   • Set minimum LCR targets (e.g., ≥1.2x at 30 days) and escalation thresholds; propose funding, WC, and hedging actions with value–risk trade-offs.

Format of the output of analysis:

• Executive scorecard: LCR 30/60/90 days (consolidated and by currency/entity), HQLA composition (cash, T+1/T+3), committed availability, net outflows, policy target and headroom.
• Liquidity ladder: weekly sources and uses over 13 weeks; maturity profile and near-term obligations.
• Bridges: LCR change vs prior quarter with driver attribution (HQLA, facilities, WC outflows, maturities, FX/marks).
• Quality panels: cash fungibility (unrestricted vs trapped), security liquidity buckets, covenant headroom and borrowing base, bank concentration.
• Scenario deck: sensitivities and mitigation playbook with expected LCR uplift and cost (interest, fees, margin impact).

How to interpret results:

• LCR ≥1.2x at 30 days and ≥1.0x at 60–90 days with diversified sources: Comfortable short-term liquidity; maintain buffers and monitor market access.
• LCR ~1.0x at 30 days, reliant on RCF: Adequate but execution-dependent; ensure covenant headroom, minimize bank concentration, and pre-arrange draw mechanics.
• LCR <1.0x at 30 days: Elevated risk; activate contingency actions (WC acceleration, facility upsizes, security rotation, capex deferral) and consider pre-emptive refinancing.
• Healthy headline LCR but weak currency/entity LCR: Transferability risk; build local currency buffers or hedges and align facilities to cash needs per entity.
• Volatile LCR driven by collateral calls/market marks: Tighten CSA terms, add caps/swaps, or increase HQLA cushion; reduce floating-rate and commodity exposure.
• Large portion of HQLA in T+3 instruments: Suitable for 60–90 day horizon, less reliable for 30-day stress; increase T+0/T+1 share.

Steps a company can take to improve on this measure:

• Treasury structure and facilities:
  • Upsize/extend committed RCFs; diversify banks; add ABL/borrowing base where assets support; align facility currencies with needs.
  • Centralize cash via pooling/netting; reduce trapped cash; implement intercompany lending frameworks.
• HQLA optimization:
  • Rotate a portion of securities to T+0/T+1 instruments; set minimum T+1 share; manage counterparty and duration risk.
  • Maintain minimum operating cash by entity; automate daily visibility and forecasting.
• Working-capital levers:
  • Accelerate collections (e-invoicing, dispute reduction, dunning cadence); deploy dynamic discounting selectively where APR > borrowing cost.
  • Extend DPO via terms programs and supply chain finance; optimize inventory parameters to reduce pre-buys/seasonal spikes.
• Market risk and collateral management:
  • Increase fixed-rate share; add caps/floors; renegotiate CSAs to reduce collateral volatility (higher thresholds, less frequent margining where feasible).
  • Hedge FX exposures aligned with liquidity currency needs to prevent adverse translation and collateral calls.
• Cash flow timing and governance:
  • Stage discretionary outflows (capex, buybacks, dividends) to protect 30-day LCR; embed LCR thresholds in investment gates.
  • Run a weekly liquidity war room when headroom is tight; pre-authorize contingency actions with playbooks.
• Scenario guidance:
  • If LCR(30) = 0.9x due to DSO slippage and a 200 bps rate rise, target DSO −8 days, swap 50% of floating to fixed, rotate $100m to T+1 instruments, and extend DPO +7; aim ≥1.2x within two quarters.
  • If currency-specific LCR in EUR is 0.7x despite consolidated 1.3x, secure a EUR tranche on the RCF and build local cash via pooling; increase EUR LCR ≥1.0x.
  • If collateral calls are volatile, renegotiate CSA thresholds and add a cap; set a dedicated collateral buffer within HQLA.

Benchmark comparisons:

General benchmarks:

• Regulated banks (Basel III): LCR ≥100% (30-day horizon) is required; higher buffers during stress.
• Non-financial corporates (policy guidance): 30-day corporate LCR targets typically 1.1–1.5x depending on cyclicality, rating goals, and market access; 60–90 day targets 1.0–1.3x.
• Cash composition: Best practice keeps ≥60–75% of 30-day HQLA in T+0/T+1 instruments; top-3 bank concentration <50% of committed facilities.

Constructing internal benchmarks:

• Track 8–12 quarters of 30/60/90-day LCR by currency and legal entity; publish quartiles and set minimum buffers by BU/region.
• Measure 13-week cash forecast accuracy (MAPE/BIAS); set targets to reduce variance and avoid false comfort.
• Maintain policy bands for HQLA composition (minimum T+1 share, counterparty limits) and for facility headroom (e.g., ≥25–35% undrawn).
• Rebase benchmarks after major refis, M&A, or treasury structure changes; document stress assumptions for comparability.