Design a treasury FTP for deposits: stickiness tiers, rate betas, deposit decay, FTP…
- User
Design a treasury FTP for deposits: stickiness tiers, rate betas, deposit decay, FTP credits, and performance attribution.
- Assistant
Treasury FTP Framework for Deposits
As Sherlock, I've deduced the optimal design for a Funds Transfer Pricing (FTP) system tailored to deposits. This framework incentivizes stable, low-cost funding while accurately attributing performance to deposit teams. It balances stickiness (stability), rate sensitivity (beta), decay risk, FTP credits (internal pricing), and attribution for P&L analysis.
The design assumes a Treasury curve (e.g., interpolated SOFR + tenor premium) as the base reference rate. FTP rates are calculated daily/weekly, with credits flowing from Treasury to deposit businesses.
1. Stickiness Tiers
Deposits are segmented into 4 tiers based on behavioral data (e.g., historical duration, volatility, relationship linkage). Higher stickiness = higher FTP credit (more value to the bank).
Tier Description Criteria Stickiness Score FTP Premium (bps over base) Core Non-interest bearing (NIB), operational cash Avg. life >5 yrs, volatility <5% 100% +50 bps Sticky Relationship CDs, MMDA linked to loans/relationships Avg. life 2-5 yrs, volatility <15% 80% +30 bps Volatile Relationship Savings, NOW accounts with some linkage Avg. life 1-2 yrs, volatility 15-30% 50% +10 bps Hot Money Brokered CDs, time deposits Avg. life <1 yr, volatility >30% 20% 0 bps Assignment: Machine learning model (e.g., survival analysis) reclassifies quarterly based on 12-month rolling data.
2. Rate Betas
Beta measures deposit rate repricing sensitivity to market rates (e.g., Treasury/SOFR curve shifts). Estimated via regression on historical data.
Tier Beta (ΔDeposit Rate / ΔMarket Rate) Rationale Adjustment to FTP Core 0.1 Largely insensitive (corporate cash) -40 bps (low cost) Sticky Relationship 0.4 Partial pass-through -20 bps Volatile Relationship 0.7 High sensitivity 0 bps Hot Money 1.2 Over-indexes market (competitive) +20 bps (penalty) Formula: FTP Rate = Reference Curve Rate × Beta + Stickiness Premium + Decay Adjustment.
3. Deposit Decay
Models expected balance runoff using exponential decay:
Balance_t = Balance_0 × e^(-λt)
Where λ (decay rate) varies by tier, calibrated to historical attrition.Tier Half-Life (t½) λ (Decay Rate, monthly) Decay Penalty (bps, cumulative) Core 10 years 0.007% -5 bps/yr Sticky Relationship 4 years 0.017% -15 bps/yr Volatile Relationship 2 years 0.035% -30 bps/yr Hot Money 6 months 0.116% -60 bps/yr Implementation: Forward-looking adjustment to FTP credit. E.g., for a $100M Volatile deposit: Expected decay over 1yr = 20%, so haircut FTP by 20% of margin.
4. FTP Credits Calculation
FTP Credit Rate = (Treasury Reference Rate × Beta) + Stickiness Premium + Decay Penalty + Volume Incentive.
-
Reference Rate: Weighted average cost of funds (WACF) from Treasury curve (e.g., 3M SOFR + 10bps credit spread).
-
Full Formula (annualized):
FTP_Credit = [Ref_Rate × Beta] + Stickiness_Premium - Decay_Penalty + (Volume_Growth × 2bps) -
Example (Ref_Rate = 5.00%):
Tier Beta Adj. Stickiness Decay FTP Credit Margin to Deposit Business Core 0.50% +50bps -5bps 5.45% Deposit Rate (0%) → +545bps Hot Money 6.00% 0bps -60bps 5.40% Deposit Rate (5.25%) → +15bps -
Credits Flow: Monthly accrual: Credit = Avg Balance × FTP Credit Rate. Paid to P&L of originating unit.
5. Performance Attribution
Decomposes deposit P&L into actionable drivers for incentives/oversight. Uses marginal FTP (incremental credits on growth).
Attribution Bucket % of Total P&L Calculation Incentive Weight Volume 40% ΔBalance × Avg FTP Rate High (growth rewarded) Mix Shift 25% ∑(Tier Weight × FTP Margin) - Prior Mix High (stickier = better) Rate Capture 20% (Market Δ × (1-Beta)) × Balance Medium (low beta wins) Decay Control 10% Actual Runoff vs. Modeled Decay High (retention bonus) Beta Stability 5% Variance in Observed vs. Expected Beta Low (risk control) Dashboard Example:
Deposit Team P&L: +$12M - Volume: +$5M (42%) - Mix: +$3M (25%) [↑Core 10%] - Rate: +$2.5M (21%) [Beta=0.3 vs. mkt] - Decay: +$1.2M (10%) [Runoff -5% vs. exp] - Beta: +$0.3M (2%)Implementation Notes
- Tech Stack: Python (pandas for calc, scikit-learn for tiers/betas), integrated with core banking (e.g., FIS, Temenos).
- Governance: Monthly calibration by ALCO; stress-tested for +200bps rate shock.
- Incentives: Bonus pool = 20% of attributed margin > budget.
- Edge Cases: New products default to "Hot Money"; grandfather legacy at tier average.
This design promotes sticky, low-beta deposits while providing granular insights. If you supply bank-specific data (e.g., deposit book stats), I can refine with simulations. Elementary, my dear banker. 🔍
-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.