Create a NIM (net interest margin) sensitivity deck: rate paths, betas, convexity, and…
- User
Create a NIM (net interest margin) sensitivity deck: rate paths, betas, convexity, and management actions.
Assistant
1. Understand the Goal: The user wants a presentation deck structure and content for analyzing Net Interest Margin (NIM) sensitivity. The specific focus is on four key drivers: Rate Paths, Betas (deposit/cost of funds sensitivity), Convexity (asset/liability optionality), and Management Actions.
-
Target Audience: This is likely for a bank's ALCO (Asset Liability Committee), CFO, Treasurer, or Board of Directors. The tone needs to be professional, analytical, and strategic.
-
Core Concepts:
- NIM: (Interest Income - Interest Expense) / Average Earning Assets.
- Rate Paths: The scenario analysis (parallel shocks, non-parallel ramps, inversions).
- Betas: How fast deposit costs rise/fall relative to Fed Funds/Prime. Low beta = lagging, High beta = immediate.
- Convexity: Non-linear price/yield relationships, usually driven by prepayments (mortgages) or call options (bonds/loans) and caps/floors.
- Management Actions: What can be done to mitigate or take advantage of the environment (hedging, pricing changes, mix shifts).
-
Structuring the Deck: A standard financial presentation structure works best:
- Title/Executive Summary.
- Current State (Baseline).
- The Drivers (The "Engine Room"):
- Rate Paths.
- Betas.
- Convexity.
- The Simulation/Results (The "Output").
- Management Actions (The "Strategy").
- Appendix/Details.
-
Drafting Content - Slide by Slide:
-
Slide 1: Title Slide. Standard.
-
Slide 2: Executive Summary. Needs to be punchy. "NIM expected to compress/expand by X bps." Key drivers highlighted.
-
Slide 3: The Baseline (Current Balance Sheet Profile). We need to know what we are analyzing. Asset Mix (Loans vs. Securities), Liability Mix (DDA vs. Time), Current NIM.
-
Slide 4: Interest Rate Scenarios (Rate Paths). This addresses the first user requirement. I need to define the scenarios: +100bps, -100bps, Steepener, Flattener. Explain why these matter (static vs. dynamic modeling).
-
Slide 5: Deposit Beta Analysis. This addresses the second requirement. Explain the concept of Beta (lag and magnitude). DDA vs. CD behavior. Non-maturity deposit (NMD) decay.
-
Slide 6: Convexity & Optionality. This addresses the third requirement. This is often the hardest to explain simply. I need to focus on prepayments (mortgages) and caps/floors. Explain "negative convexity" (when rates drop, extension risk; when rates rise, prepay risk/call protection issues). Self-correction: Actually, when rates drop, prepayments speed up (contraction risk), and when rates rise, they slow down (extension risk).
-
Slide 7: NIM Simulation Output (The Matrix). This brings the data together. A heat map or bar chart showing NIM under the various scenarios. Link back to the drivers.
-
Slide 8: Earnings at Risk (EaR). A standard ALM metric to include alongside NIM.
-
Slide 9: Management Actions (The Levers). This addresses the fourth requirement. What can we actually do?
- Asset side: Loan pricing, fixed vs. float mix, investment portfolio duration.
- Liability side: Deposit pricing, wholesale funding usage.
- Hedging: Swaps, caps, floors.
-
Slide 10: Strategic Recommendations. Actionable items based on the previous slide.
-
-
Refining the Visuals/Notes: For each slide, I should provide "Visuals" (what charts to show) and "Key Talking Points" (what to say). This makes the output practical and ready-to-use.
-
Review against specific prompts:
- Rate paths? Covered in Slide 4.
- Betas? Covered in Slide 5.
- Convexity? Covered in Slide 6.
- Management actions? Covered in Slide 9 & 10.
-
Polishing the Tone: Ensure financial jargon is used correctly (basis points, repricing, duration, swap curves).
- Self-Correction during drafting Slide 6 (Convexity): Make sure to distinguish between asset convexity (MBS) and liability convexity (deposit decay). Usually, in NIM sensitivity, the asset side convexity (prepayments) is the dominant factor discussed, but deposit duration matters too. I will focus primarily on the asset side (MBS/Loans) as that is the classic "convexity" drag on NIM.
-
Final Output Generation: (This matches the structured response provided previously.) I will organize it into a clear slide-by-slide guide. I will add a section on "Assumptions" because a model is only as good as its assumptions.
(Self-Correction): I should emphasize that this is a template. The user needs to fill in their specific data.
-
Final Polish: Check formatting. Use bolding for emphasis. Create a clean layout. (Proceed to generate output). Here is a comprehensive structure and content outline for a NIM Sensitivity Deck. This is designed for an ALCO (Asset/Liability Committee) or Board presentation.
The deck moves from the macro environment (Rate Paths) to balance sheet dynamics (Betas/Convexity) and concludes with strategic levers (Management Actions).
Deck Overview
Presentation Title: NIM Sensitivity Analysis & Outlook Subtitle: Rate Scenarios, Beta Dynamics, and Strategic positioning Audience: ALCO / Board of Directors / Executive Leadership
Slide 1: Executive Summary
- Visual: A "Dashboard" view with 3 key gauges: Current NIM, NIM (+200bps shock), NIM (-100bps shock).
- Key Message: "Our base case NIM is projected to stabilize at [X]% over the next 12 months. We are [Asset/Liability] sensitive. A rising rate environment will [improve/compress] margins by [Y] basis points, assuming static management."
- Action Item: Request approval for [Specific Hedging/Repricing Strategy] to mitigate downside risk.
Slide 2: The Macro Backdrop: Rate Paths
- Visual: Line chart showing three distinct curves over 12–24 months:
- Base Case (Consensus): The implied forward curve (Fed funds/Sofr).
- Bull Steepener (Rates Rise): +200bps parallel shock.
- Bear Flattener (Rates Cut): -100bps parallel shock.
- Key Talking Points:
- Current market pricing implies [X] cuts/hikes over the next year.
- The "Fed Funds Effective" vs. "10-Year Treasury" spread indicates [Recessionary/Expansionary] signals.
- Model Assumption: We are modeling a "static balance sheet" against these dynamic rate paths to isolate pure interest rate risk.
Slide 3: Earning Assets Mix & Repricing Ladders
- Visual: Stacked Bar Chart (Assets) vs. Stacked Bar Chart (Liabilities) segmented by repricing time buckets (Overnight, <3M, 3-12M, >1Y, >5Y).
- Key Talking Points:
- Asset Sensitivity: [X]% of loans reprice within 12 months (Variable rate/Floater exposure).
- Fixed-Rate Concentration: We have a heavy concentration of fixed-rate mortgage/C&I loans repricing in the >5Y bucket, creating duration risk.
- Gap Analysis: We currently have a [Positive/Negative] cumulative 1-year gap.
Slide 4: Beta Analysis (The Behavioral Assumption)
- Visual: Two Scatter Plots.
- Chart A (Deposit Beta): X-axis = Change in Fed Funds; Y-axis = Change in Cost of Funds. Show "Historical" vs. "Projected."
- Chart B (Earning Asset Beta): X-axis = Change in Fed Funds; Y-axis = Change in Yield on Assets.
- Key Talking Points:
- Deposit Beta Definition: For every 1% increase in rates, our cost of funds rises by [0.X]%.
- Lagged Effect: We assume deposit betas lag the market by [2] months (delayed repricing).
- Floor vs. Ceiling: We have identified that [X]% of our loan book has interest rate floors, creating a "sticky bottom" for yields even if rates drop.
- Risk: In a falling rate environment, deposit betas are slower to decline (sticky deposits), compressing spread.
Slide 5: Convexity & Optionality (The Hidden Risk)
- Visual: Line chart showing "Theoretical Value" vs. "Actual Value" as rates move.
- Key Talking Points:
- Prepayment Risk (Convexity): As rates fall, mortgage/loan prepayments speed up. We get principal back that must be reinvested at lower rates (Reinvestment Risk).
- Extension Risk: As rates rise, prepayments slow down. We are stuck holding low-yielding assets longer than expected, missing out on higher yields.
- Callable Bonds: [X]% of the securities portfolio is callable. This limits upside in a falling rate scenario (negative convexity).
- Caps/Floors: Highlight the impact of commercial loan caps limiting upside in a +200bps scenario.
Slide 6: NIM Simulation Results (The Output)
- Visual: "Barbell" Chart or Waterfall Chart.
- Center: Base Case NIM.
- Left: NIM impact under -100bps.
- Right: NIM impact under +200bps.
- Key Talking Points:
- Instantaneous Shock: If rates ramp +200bps today, Year 1 NIM [Expands/Contracts] by [X] bps.
- Gradual Ramp: If rates rise 25bps/quarter, NIM improves by [Y] bps.
- Key Driver: The result is driven primarily by the [Asset/Liability] sensitivity mismatch identified in Slide 3.
Slide 7: Management Actions (Strategic Levers)
- Visual: "Triage" Graphic showing 3 columns: Defensive, Offensive, Structural.
- Content:
- Defensive (Liquidity):
- Action: Reduce reliance on wholesale FHLB advances (high beta).
- Action: Promote sticky DDA (Demand Deposit Accounts) products to lower cost of funds beta.
- Offensive (Yield):
- Action: Shift securities portfolio from Agencies to CLOs or Private Credit for yield pickup (manage capital/liquidity trade-off).
- Action: Loan pricing floors—ensure new origination has a minimum floor of [X]%.
- Structural (Derivatives):
- Action: Execute a Receive-Fixed Swap to synthetically fix floating rate exposure (protects against falling rates).
- Action: Purchase an Interest Rate Cap to limit cost of funds spike on LIBOR/SOFR debt.
- Defensive (Liquidity):
Slide 8: Appendix / Technical Assumptions
- Visual: Detailed Table.
- Content:
- Model Type: Static vs. Dynamic.
- Prepayment Speeds (PSA/CPR) assumptions.
- Non-Maturity Deposit Decay rate.
- Regulatory Liquidity Coverage Ratio (LCR) impact.
-
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.