Funding Cost Decomposition
Overview
Breaks down the bank's all-in funding cost into constituent components—deposit pricing, wholesale spreads, liquidity premiums, FTP allocations, and structural mix effects—to reveal the true economic cost of each funding source. Enables treasury to identify cost optimization levers, assess funding strategy effectiveness, and provide transparent cost attribution to business lines through FTP.
When to Use
- Analyzing period-over-period changes in weighted average cost of funds
- Evaluating the cost-effectiveness of funding sources (retail deposits vs. wholesale vs. secured)
- Reviewing or redesigning the FTP framework
- Preparing funding cost commentary for ALCO or CFO reporting
- Assessing the marginal cost of incremental funding for business-line pricing
- Comparing funding cost benchmarks against peers
Required Inputs
| Input |
Description |
Format |
| Funding composition |
Outstanding balances by funding source and product |
Balance table with rates |
| Deposit portfolio |
Balances, rates, maturity/behavioral profile by product |
Product-level detail |
| Wholesale funding |
Issuance details, spreads, tenors, benchmarks |
Instrument-level data |
| FTP curve |
Internal transfer pricing rates by tenor point |
Term structure |
| Market reference rates |
SOFR, Treasury yields, swap rates, credit spreads |
Market data |
| Historical funding data |
Prior period composition and costs for trend analysis |
Same format as current |
| Operating costs |
Cost-to-serve for each funding channel (branch, digital, wholesale) |
Cost allocation data |
Methodology
Step 1 — Segment the Funding Stack
Classify all funding sources into a structured taxonomy:
Core deposits (stable funding):
- Demand deposits / checking (zero or low-rate, highest behavioral stability)
- Savings and money market accounts (managed-rate, moderate stability)
- Time deposits / CDs (contractual maturity, rate-certain)
Market-sensitive deposits:
- Brokered deposits (rate-competitive, lower stickiness)
- Institutional deposits (large, relationship-driven, rate-sensitive)
- Online/digital deposits (rate-competitive, lower acquisition cost)
Wholesale funding:
- Senior unsecured bonds (term, benchmark + credit spread)
- Covered bonds (secured, tighter spreads)
- Repo / secured borrowing (overnight to term, haircut-dependent)
- FHLB advances / central bank facilities
- Commercial paper (short-term, rolling)
Capital instruments:
- Subordinated debt (Tier 2, higher spread)
- AT1 / preferred equity (highest cost, regulatory capital benefit)
Step 2 — Calculate Component Costs
For each funding segment, compute the all-in cost as:
All-in Cost = Interest Cost + Issuance/Origination Cost + Operating Cost + FDIC Assessment + Liquidity Premium
- Interest cost: Stated rate or benchmark + spread
- Issuance cost: Underwriting fees, legal, listing costs amortized over term
- Operating cost: Branch network, digital platform, relationship management costs allocated per dollar of funding raised
- FDIC/DGS assessment: Deposit insurance premium per dollar of deposits
- Liquidity premium: Incremental cost attributable to LCR/NSFR treatment (short-term wholesale funding carries higher implicit cost due to LCR outflow assumptions)
Step 3 — Construct the Weighted Average Cost of Funds
WACF = Σ (Balance_i × All-in Cost_i) / Σ Balance_i
Decompose WACF into:
- Base rate component: Weighted contribution of benchmark rates (SOFR, Treasury)
- Credit spread component: Average credit spread on market-based funding
- Deposit spread component: Margin between deposit rates and equivalent-maturity market rates
- Structural mix component: Impact of the proportion allocated to each funding type
- Operating cost component: Non-interest costs of funding channels
Step 4 — Perform Period-over-Period Variance Analysis
Decompose WACF change (ΔWACF) into:
- Rate effect: Change in cost holding mix constant = Σ (Balance_i,prior × ΔRate_i) / Σ Balance_i,prior
- Mix effect: Change in mix holding rates constant = Σ (ΔBalance_i × Rate_i,prior) / Σ Balance_i,current
- Cross effect: Interaction of simultaneous rate and mix changes
- Volume effect: Impact of overall balance sheet growth on fixed operating cost dilution
Present as a waterfall: Prior WACF → +Rate Effect → +Mix Effect → +Cross Effect → +Volume Effect = Current WACF
Step 5 — Assess FTP Alignment
Evaluate whether the FTP curve accurately reflects marginal funding costs:
- Compare FTP rates at each tenor point to actual marginal funding costs
- Identify FTP subsidies (FTP rate < actual cost, business line under-charged) and taxes (FTP rate > actual cost)
- Assess behavioral assumptions embedded in FTP (e.g., demand deposit FTP maturity)
- Evaluate the liquidity premium component of FTP: does it appropriately charge business lines for generating LCR-unfriendly assets or attracting LCR-friendly stable deposits?
- Recommend FTP curve adjustments where material misalignment exists (threshold: >15bps divergence from marginal cost)
Step 6 — Benchmark Against Peers and Market
Compare funding costs against:
- Peer group: WACF, deposit beta, wholesale credit spreads for comparable institutions
- Market indicators: Swap spreads, CDS levels, new-issue concessions
- Historical trend: 4-8 quarter time series of own WACF to identify structural trends
- Compute the funding advantage/disadvantage vs. peers in bps and absolute dollars
Step 7 — Identify Optimization Opportunities
Assess cost reduction levers:
- Deposit mix optimization: Shift from rate-sensitive to stable core deposits
- Wholesale tenor management: Extend or shorten term funding to optimize spread vs. liquidity cost
- Secured funding utilization: Increase repo or covered bond funding against eligible collateral
- Geographic/channel diversification: Exploit lower-cost digital deposit channels
- Behavioral repricing: Adjust deposit pass-through strategies to manage deposit beta
- Quantify each opportunity in annual dollar savings and implementation effort
Output Specification
# Funding Cost Decomposition — [Period]
## Summary
Weighted average cost of funds: [X]%, [up/down] [Y]bps from [prior period].
## Funding Stack
| Source | Balance ($B) | % of Total | All-in Cost | Δ vs Prior (bps) |
|--------|-------------|------------|-------------|-------------------|
| Core deposits | | | | |
| Market-sensitive deposits | | | | |
| Senior unsecured | | | | |
| Secured funding | | | | |
| Subordinated debt | | | | |
| **Total** | | **100%** | **[WACF]** | |
## Cost Variance Waterfall
Prior WACF: [X]%
→ Rate effect: +/- [A]bps
→ Mix effect: +/- [B]bps
→ Cross effect: +/- [C]bps
→ Volume effect: +/- [D]bps
= Current WACF: [Y]%
## FTP Alignment Assessment
| Tenor | FTP Rate | Marginal Cost | Gap (bps) | Action |
|-------|----------|---------------|-----------|--------|
## Peer Comparison
| Metric | Institution | Peer Median | Rank |
|--------|-------------|-------------|------|
## Optimization Opportunities
| Opportunity | Annual Savings ($M) | Effort | Timeline |
|-------------|--------------------|---------|-----------|
## Recommendations
1. [Specific funding strategy adjustment with quantified benefit]
Analysis Framework
Apply the Marginal Cost of Funds framework:
- The relevant cost for business-line pricing decisions is the marginal cost of the next dollar of funding, not the average (blended) cost of the existing stock
- Marginal cost should reflect: (a) the actual market rate for new funding at the relevant tenor, (b) the liquidity premium for LCR/NSFR impact, (c) the credit spread appropriate to current market conditions
- Distinguish between stock cost (weighted average of existing book) and flow cost (rate on new/renewed funding) to identify pricing lag or acceleration
- FTP should be calibrated to marginal cost to send correct pricing signals to business lines
Examples
Example — Funding Cost Increase Narrative:
"WACF increased 23bps to 2.87% in Q3, driven primarily by the rate effect (+31bps) as the deposit book repriced in response to the Fed's cumulative 75bps of hikes. This was partially offset by a favorable mix effect (-11bps) as the bank grew non-interest-bearing demand deposits by $1.4B through targeted commercial relationship deepening. The deposit beta for the quarter was 0.41, below the cycle-to-date average of 0.48, reflecting the lag in savings account repricing."
Example — FTP Misalignment Finding:
"The FTP curve underprices 3-year funding by 22bps relative to the marginal cost of a new 3-year senior unsecured issuance (FTP: 3.95% vs. marginal cost: 4.17%). This subsidizes the auto lending business, whose average loan tenor is 3.2 years, by approximately $14M annually. Recommendation: adjust the 3-year FTP rate to 4.15% to restore incentive alignment."
Guidelines
- Always decompose WACF into interest and non-interest components
- Distinguish between average/stock cost and marginal/flow cost explicitly
- Report deposit betas with clear specification of the reference rate
- Present variance analysis using the rate-mix-cross-volume decomposition
- Compare FTP rates to marginal (not average) funding costs
- Include FDIC/DGS assessments and operating costs in all-in calculations
- State all rates on a consistent day-count and compounding basis
Validation Checklist
1---2name: funding-cost-decomposition3description: Decompose funding cost drivers across deposit pricing, wholesale funding, FTP curves, and liquidity premiums. Use when analyzing cost of funds, explaining funding mix changes, evaluating FTP methodologies, or preparing treasury funding cost reports for ALCO.4---56# Funding Cost Decomposition78## Overview910Breaks down the bank's all-in funding cost into constituent components—deposit pricing, wholesale spreads, liquidity premiums, FTP allocations, and structural mix effects—to reveal the true economic cost of each funding source. Enables treasury to identify cost optimization levers, assess funding strategy effectiveness, and provide transparent cost attribution to business lines through FTP.1112## When to Use1314- Analyzing period-over-period changes in weighted average cost of funds15- Evaluating the cost-effectiveness of funding sources (retail deposits vs. wholesale vs. secured)16- Reviewing or redesigning the FTP framework17- Preparing funding cost commentary for ALCO or CFO reporting18- Assessing the marginal cost of incremental funding for business-line pricing19- Comparing funding cost benchmarks against peers2021## Required Inputs2223| Input | Description | Format |24|-------|-------------|--------|25| Funding composition | Outstanding balances by funding source and product | Balance table with rates |26| Deposit portfolio | Balances, rates, maturity/behavioral profile by product | Product-level detail |27| Wholesale funding | Issuance details, spreads, tenors, benchmarks | Instrument-level data |28| FTP curve | Internal transfer pricing rates by tenor point | Term structure |29| Market reference rates | SOFR, Treasury yields, swap rates, credit spreads | Market data |30| Historical funding data | Prior period composition and costs for trend analysis | Same format as current |31| Operating costs | Cost-to-serve for each funding channel (branch, digital, wholesale) | Cost allocation data |3233## Methodology3435### Step 1 — Segment the Funding Stack3637Classify all funding sources into a structured taxonomy:3839**Core deposits (stable funding):**40- Demand deposits / checking (zero or low-rate, highest behavioral stability)41- Savings and money market accounts (managed-rate, moderate stability)42- Time deposits / CDs (contractual maturity, rate-certain)4344**Market-sensitive deposits:**45- Brokered deposits (rate-competitive, lower stickiness)46- Institutional deposits (large, relationship-driven, rate-sensitive)47- Online/digital deposits (rate-competitive, lower acquisition cost)4849**Wholesale funding:**50- Senior unsecured bonds (term, benchmark + credit spread)51- Covered bonds (secured, tighter spreads)52- Repo / secured borrowing (overnight to term, haircut-dependent)53- FHLB advances / central bank facilities54- Commercial paper (short-term, rolling)5556**Capital instruments:**57- Subordinated debt (Tier 2, higher spread)58- AT1 / preferred equity (highest cost, regulatory capital benefit)5960### Step 2 — Calculate Component Costs6162For each funding segment, compute the **all-in cost** as:6364`All-in Cost = Interest Cost + Issuance/Origination Cost + Operating Cost + FDIC Assessment + Liquidity Premium`6566- **Interest cost**: Stated rate or benchmark + spread67- **Issuance cost**: Underwriting fees, legal, listing costs amortized over term68- **Operating cost**: Branch network, digital platform, relationship management costs allocated per dollar of funding raised69- **FDIC/DGS assessment**: Deposit insurance premium per dollar of deposits70- **Liquidity premium**: Incremental cost attributable to LCR/NSFR treatment (short-term wholesale funding carries higher implicit cost due to LCR outflow assumptions)7172### Step 3 — Construct the Weighted Average Cost of Funds7374`WACF = Σ (Balance_i × All-in Cost_i) / Σ Balance_i`7576Decompose WACF into:77- **Base rate component**: Weighted contribution of benchmark rates (SOFR, Treasury)78- **Credit spread component**: Average credit spread on market-based funding79- **Deposit spread component**: Margin between deposit rates and equivalent-maturity market rates80- **Structural mix component**: Impact of the proportion allocated to each funding type81- **Operating cost component**: Non-interest costs of funding channels8283### Step 4 — Perform Period-over-Period Variance Analysis8485Decompose WACF change (ΔWACF) into:86- **Rate effect**: Change in cost holding mix constant = Σ (Balance_i,prior × ΔRate_i) / Σ Balance_i,prior87- **Mix effect**: Change in mix holding rates constant = Σ (ΔBalance_i × Rate_i,prior) / Σ Balance_i,current88- **Cross effect**: Interaction of simultaneous rate and mix changes89- **Volume effect**: Impact of overall balance sheet growth on fixed operating cost dilution9091Present as a waterfall: Prior WACF → +Rate Effect → +Mix Effect → +Cross Effect → +Volume Effect = Current WACF9293### Step 5 — Assess FTP Alignment9495Evaluate whether the FTP curve accurately reflects marginal funding costs:96- Compare FTP rates at each tenor point to actual marginal funding costs97- Identify FTP subsidies (FTP rate < actual cost, business line under-charged) and taxes (FTP rate > actual cost)98- Assess behavioral assumptions embedded in FTP (e.g., demand deposit FTP maturity)99- Evaluate the liquidity premium component of FTP: does it appropriately charge business lines for generating LCR-unfriendly assets or attracting LCR-friendly stable deposits?100- Recommend FTP curve adjustments where material misalignment exists (threshold: >15bps divergence from marginal cost)101102### Step 6 — Benchmark Against Peers and Market103104Compare funding costs against:105- **Peer group**: WACF, deposit beta, wholesale credit spreads for comparable institutions106- **Market indicators**: Swap spreads, CDS levels, new-issue concessions107- **Historical trend**: 4-8 quarter time series of own WACF to identify structural trends108- Compute the **funding advantage/disadvantage** vs. peers in bps and absolute dollars109110### Step 7 — Identify Optimization Opportunities111112Assess cost reduction levers:113- **Deposit mix optimization**: Shift from rate-sensitive to stable core deposits114- **Wholesale tenor management**: Extend or shorten term funding to optimize spread vs. liquidity cost115- **Secured funding utilization**: Increase repo or covered bond funding against eligible collateral116- **Geographic/channel diversification**: Exploit lower-cost digital deposit channels117- **Behavioral repricing**: Adjust deposit pass-through strategies to manage deposit beta118- Quantify each opportunity in annual dollar savings and implementation effort119120## Output Specification121122```markdown123# Funding Cost Decomposition — [Period]124125## Summary126Weighted average cost of funds: [X]%, [up/down] [Y]bps from [prior period].127128## Funding Stack129| Source | Balance ($B) | % of Total | All-in Cost | Δ vs Prior (bps) |130|--------|-------------|------------|-------------|-------------------|131| Core deposits | | | | |132| Market-sensitive deposits | | | | |133| Senior unsecured | | | | |134| Secured funding | | | | |135| Subordinated debt | | | | |136| **Total** | | **100%** | **[WACF]** | |137138## Cost Variance Waterfall139Prior WACF: [X]%140→ Rate effect: +/- [A]bps141→ Mix effect: +/- [B]bps142→ Cross effect: +/- [C]bps143→ Volume effect: +/- [D]bps144= Current WACF: [Y]%145146## FTP Alignment Assessment147| Tenor | FTP Rate | Marginal Cost | Gap (bps) | Action |148|-------|----------|---------------|-----------|--------|149150## Peer Comparison151| Metric | Institution | Peer Median | Rank |152|--------|-------------|-------------|------|153154## Optimization Opportunities155| Opportunity | Annual Savings ($M) | Effort | Timeline |156|-------------|--------------------|---------|-----------| 157158## Recommendations1591. [Specific funding strategy adjustment with quantified benefit]160```161162## Analysis Framework163164Apply the **Marginal Cost of Funds** framework:165- The relevant cost for business-line pricing decisions is the **marginal** cost of the next dollar of funding, not the **average** (blended) cost of the existing stock166- Marginal cost should reflect: (a) the actual market rate for new funding at the relevant tenor, (b) the liquidity premium for LCR/NSFR impact, (c) the credit spread appropriate to current market conditions167- Distinguish between **stock cost** (weighted average of existing book) and **flow cost** (rate on new/renewed funding) to identify pricing lag or acceleration168- FTP should be calibrated to marginal cost to send correct pricing signals to business lines169170## Examples171172**Example — Funding Cost Increase Narrative:**173"WACF increased 23bps to 2.87% in Q3, driven primarily by the rate effect (+31bps) as the deposit book repriced in response to the Fed's cumulative 75bps of hikes. This was partially offset by a favorable mix effect (-11bps) as the bank grew non-interest-bearing demand deposits by $1.4B through targeted commercial relationship deepening. The deposit beta for the quarter was 0.41, below the cycle-to-date average of 0.48, reflecting the lag in savings account repricing."174175**Example — FTP Misalignment Finding:**176"The FTP curve underprices 3-year funding by 22bps relative to the marginal cost of a new 3-year senior unsecured issuance (FTP: 3.95% vs. marginal cost: 4.17%). This subsidizes the auto lending business, whose average loan tenor is 3.2 years, by approximately $14M annually. Recommendation: adjust the 3-year FTP rate to 4.15% to restore incentive alignment."177178## Guidelines179180- Always decompose WACF into interest and non-interest components181- Distinguish between average/stock cost and marginal/flow cost explicitly182- Report deposit betas with clear specification of the reference rate183- Present variance analysis using the rate-mix-cross-volume decomposition184- Compare FTP rates to marginal (not average) funding costs185- Include FDIC/DGS assessments and operating costs in all-in calculations186- State all rates on a consistent day-count and compounding basis187188## Validation Checklist189190- [ ] All funding sources classified and balances reconcile to total liabilities191- [ ] All-in costs include interest, issuance, operating, insurance, and liquidity components192- [ ] WACF calculated correctly as balance-weighted average of all-in costs193- [ ] Variance waterfall (rate + mix + cross + volume) reconciles to total ΔWACF194- [ ] FTP rates compared to marginal (not average) funding costs at each tenor195- [ ] Deposit betas specified with reference rate and observation period196- [ ] Peer comparison uses consistent cost definitions197- [ ] Optimization opportunities quantified with annual dollar impact198- [ ] Marginal vs. average cost distinction clearly made199- [ ] All rates stated on consistent day-count basis