---
title: 4 Reports for Analyzing & Understanding IRR
description: Read this blog by Dave Wicklund, former FDIC examiner, to learn 4 reports for analyzing & understanding your IRR.
---

[Plansmith Blog](https://blog.plansmith.com)

# [4 Reports for Analyzing & Understanding IRR](https://blog.plansmith.com/4-reports-for-analyzing-understanding-irr)

 Written by [Dave Wicklund](https://blog.plansmith.com/author/dave-wicklund) | 11/18/19 7:48 PM

Knowing and understanding your organization's risk position is important. Regulators expect you to keep a close eye on your IRR exposure and be ready for a rising rate environment.

Here are four reports to help you measure and monitor your interest rate risk.

**4 Reports for Analyzing & Understanding IRR**

**1. Margin Risk Tolerance**

**How much rate change can your organization absorb?**

- Start with your 12-month NIM projection
- Add non-interest income
- Deduct capital requirements and non-interest expense
- How much can rates change before your cushion goes to zero?

**2. Rate Shocked Margin**

**Will you survive low probability, high impact events?**

- Review your 12- and 24-month horizon of earnings
- Run shocks out to +/-400 bps in 100 bp increments
- What if rates don't move in a parallel fashion?  
    - Run multiple likely and unlikely non-parallel shifts
- Will earnings fall below your minimum required margin? 
    - If so, will capital be jeopardized?

**3. Value-at-Risk**

**MVE, EVE, NEV and MVPE - Whatever you call it, "V" is for value!**

- Bank-specific assumptions are essential:  
    - Prepayment and decay rates have the biggest impact on results
- Focus on how the capital value changes in the shocked scenarios
- Value shouldn't fall below board policy limits

**4. Sensitivity Test**

**Do the analysis again using likely and unlikely assumptions...**

- Change decay rates to the extreme:  
    - Are you still within board limits?
- Change one assumption at a time to identify the greatest vulnerability
- Run multiple scenarios using low probability assumptions: 
    - What's the worst case scenario?

If you have any questions about these reports or IRR in general, **[email us](mailto:advisory@Plansmith.com)** or **[click to schedule a discovery call](https://www4.plansmith.com/contact-us/)**.

 

Dave Wicklund  
*Director of ALM Advisory Services*

 

 

[View full post](https://blog.plansmith.com/4-reports-for-analyzing-understanding-irr)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Dave Wicklund"
  },
  "dateModified" : "2025-06-30T18:20:44.411Z",
  "datePublished" : "2019-11-18T19:48:14Z",
  "headline" : "4 Reports for Analyzing & Understanding IRR",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1168,
    "url" : "https://cdn2.hubspot.net/hubfs/2363460/office-3295556_1920%20%281%29.jpg",
    "width" : 1920
  },
  "mainEntityOfPage" : "https://blog.plansmith.com/4-reports-for-analyzing-understanding-irr",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Plansmith Blog"
  }
}
```