Create a bank product profitability framework: transfer pricing, direct/indirect costs,…
- User
Create a bank product profitability framework: transfer pricing, direct/indirect costs, capital allocation, RAROC, and incentives.
- Assistant
Bank Product Profitability Framework
As Sherlock, I've deduced the essential architecture for a robust bank product profitability framework. This system dissects profitability at the product level (e.g., mortgages, credit cards, deposits) by integrating transfer pricing, direct/indirect costs, capital allocation, RAROC, and incentives. It ensures accurate performance measurement, risk-adjusted decisions, and behavioral alignment.
The framework follows a logical sequence: Revenue Attribution → Expense Allocation → Capital & Risk Adjustment → Profitability Calculation → Incentive Design. It yields Economic Profit (or EVA) and RAROC for each product, enabling kill/grow/optimize decisions.
1. Core Components
Transfer Pricing (Funds Transfer Pricing - FTP)
Internal mechanism to fairly allocate interest income/expense across products, isolating net interest margin (NIM) from market funding costs.
- Match-Term FTP: Price assets/liabilities against a pooled funds pool using yield curves (e.g., Treasury + spread for liquidity risk).
- Deposits: Credit FTP rate (below market to reward stability).
- Loans: Charge FTP rate (above market for duration/liquidity risk).
- Formula: Product Contribution to NIM = Actual Rate - FTP Rate.
- Rationale: Prevents cross-subsidization (e.g., cheap deposits subsidizing risky loans).
Product Type FTP Mechanism Example FTP Rate (3% Base Curve) Demand Deposits Tiered by stability (core vs. volatile) 2.2% credit Fixed Deposits Matched to curve + liquidity premium 2.8% credit Mortgages Matched duration + credit spread 4.5% charge Credit Cards Revolving + behavioral prepay 5.2% charge Direct/Indirect Costs
Attribute expenses granularly to avoid averaging distortions.
- Direct Costs: Product-specific (traceable via activity-based costing).
- E.g., origination fees for loans, servicing for deposits.
- Indirect Costs: Overhead allocation (e.g., IT, branches) via drivers like volume, transactions, or headcount.
- Use activity-based costing (ABC): Cost pools → Cost drivers → Products.
- Formula: Total Expenses = Direct + (Indirect Pool × Allocation Driver %).
Cost Type Examples Allocation Driver Direct Sales commissions, product-specific marketing, fraud losses 100% to product Indirect Branch overhead, compliance, IT infrastructure # Accounts, Tx Volume, Risk-Weighted Assets (RWA) Capital Allocation
Assign economic capital (not just regulatory RWA) based on risk contribution.
- Methods:
- Regulatory (Basel IRB/Standardized) for starters.
- Advanced: Marginal VaR, Expected Shortfall, or granular PD/LGD/EAD models.
- Target: 99.9% confidence (bank solvency level).
- Cost of Capital: Allocated Capital × Hurdle Rate (e.g., 10-12% CoCo + risk premium).
- Formula: Allocated Capital = Product RWA × Internal Multiplier (for operational/liquidity risk).
RAROC Calculation
Risk-Adjusted Return on Capital = core profitability metric.
-
Formula:
RAROC = [Revenues - Direct Costs - Indirect Costs - FTP Adjustments - Expected Losses - Operating Expenses] / Allocated Capital- Revenues: Interest + Fees.
- Expected Losses (EL): PD × LGD × EAD.
- Target RAROC: > Cost of Equity (e.g., 12%).
-
Economic Value Added (EVA): (RAROC - Hurdle Rate) × Allocated Capital.
- Positive EVA = Value-creating product.
Metric Formula Target Gross Margin Revenues - FTP - Direct Costs > 3% of AUM Net Profit Gross Margin - Indirect - EL > 1% of AUM RAROC Net Profit / Capital > 12% EVA (RAROC - 12%) × Capital > $0 Incentives
Tie compensation to risk-adjusted metrics to align behaviors.
- Structure:
Level Metric Payout Trigger Product Manager Product RAROC Bonus if >15%, clawback if <10% Business Unit Portfolio EVA 50% salary at risk Originator Risk-Adjusted Margin (ex-EL) Per deal, capped by capital use - Behavioral Guardrails: Defer 40% payout (3-yr cliff), adjust for capital efficiency.
- Rationale: Discourages volume-chasing; rewards sustainable profitability.
2. Integrated Framework Workflow
1. Data Inputs: Product volumes, rates, risks (PD/LGD/EAD/RWA) ↓ 2. Revenue Attribution: Actual Revenues → FTP → Net Interest + Fees ↓ 3. Expense Layer: - Direct Costs - Indirect Costs - EL ↓ 4. Capital Charge: Allocate Capital → Hurdle Cost ↓ 5. Profit Metrics: Net Profit → RAROC → EVA ↓ 6. Decision & Incentives: Grow (RAROC>15%), Maintain (10-15%), Kill (<10%)3. Numerical Example: Mortgage Product ($1B Portfolio)
Item Amount ($M) Notes Revenues 45 4.5% interest + 0.5% fees FTP Charge (35) 3.5% matched rate Direct Costs (4) Origination/sales Indirect Costs (3) Servicing allocation Expected Losses (5) 0.5% EL Net Profit -2? Wait: 45-35-4-3-5 = -2? No: Actually 45-35=10; -4-3-5=-12? Recalc: Net Profit = $ -2M (loss-making?) Wait, realistic tweak: Assume Revenues=55 ($M), FTP=40, Direct=5, Indirect=4, EL=3 → Net Profit = 3 Allocated Capital 80 8% of AUM (RWA-based) RAROC 3.75% 3/80 = Below 12% → Optimize/Kill EVA (68.0) (3.75%-12%)×80 Incentive 0% bonus Manager clawback Insight: Reveals subsidies (e.g., FTP too low? Costs high?). Iterate quarterly.
Implementation Tips
- Tech: Use Oracle Profitability Cloud or Alteryx for ABC/FTP engines.
- Frequency: Monthly P&L, quarterly RAROC.
- Governance: Independent FTP committee; audit allocations annually.
- Pitfalls to Avoid: Static FTP (ignores rate volatility); arbitrary cost pools; ignoring off-balance risks.
This framework is your profitability scalpel—precise, unbiased, revelatory. Query for customizations or deeper dives.
- Match-Term FTP: Price assets/liabilities against a pooled funds pool using yield curves (e.g., Treasury + spread for liquidity risk).
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.