Interest-rate sensitivity for property portfolios: a simple framework for decision-making

Integration update, 20 October 2026: Clarity Ledger now connects Xero, QuickBooks Online and FreeAgent. GBP Xero examples below remain valid. Check current provider and currency eligibility; planning, KPI and pack-preparation tasks described as manual remain separate workflows.

This is an illustrative model maintained outside Clarity Ledger. Rate scenarios, debt registers, hedges, cash forecasts and covenant calculations are not enabled app features; historical GBP Xero reports provide only part of the reviewed input.

When interest rates move, property portfolios often feel it in three places-fast:

• Cash flow (higher debt service reduces distributions and liquidity buffers)
• Covenants (DSCR/ICR headroom can tighten quickly at an SPV level)
• Decision speed (you need a clear "so what?" before the next refinancing, capex decision, or investor call)

The good news: you do not need a complex treasury model to make better decisions. You need a repeatable sensitivity framework that turns "rates up 50 bps" into clear actions-and works across multiple SPVs/entities. (This is exactly the kind of "what-if" scenario planning that becomes powerful once your portfolio data rolls up cleanly across SPVs.)

Below is a simple approach you can run monthly, and tighten up quarterly.

---

Definition: what "interest-rate sensitivity" actually means

Interest-rate sensitivity is the change in your portfolio's financial outcomes when interest rates move.

In practice, it is not just "interest expense goes up." A good sensitivity framework shows the knock-on impacts on:

• Cash available (after debt service, before/after reserves)
• Distribution capacity (what can be paid vs what should be retained)
• Covenant headroom (DSCR/ICR, and sometimes cash trap thresholds)
• Refinancing risk (maturities, hedges expiring, margin resets)
• Portfolio resilience (how long you can withstand stress without reactive decisions)

---

The core principle: model rates at SPV level, decide at portfolio level

Rates hit facilities, and facilities sit inside SPVs. So the mechanics must start at SPV level.

But decisions (hedging policy, distribution guidance, capex pacing, refinancing plan) are usually made at portfolio level.

So your framework should do both:

1. SPV-level accuracy (because cash, covenants, and debt are legal-entity realities)
2. Portfolio-level clarity (because the board and investors need one coherent story)

If you are consolidating multiple entities (often across separate accounting files) into a standardised portfolio view, this becomes much easier to run consistently month after month.

---

The simple 5-step framework

Step 1: Build a "debt exposure map" (one row per facility)

You cannot stress test what you have not described.

Create a debt register with (at minimum):

• SPV / entity
• Facility name and lender
• Outstanding balance
• Rate type: fixed / floating / floating hedged
• Base index: SONIA / SOFR / Euribor (etc.)
• Margin and any step-ups
• Reset frequency (monthly, quarterly)
• Maturity date and extension options
• Amortisation (interest-only vs amortising schedule)
• Hedge details: swaps/caps, notional, strike, expiry, amortising/not
• Key covenants: DSCR/ICR thresholds, cash trap rules, LTV triggers
• Restricted cash / reserves tied to the facility

Outcome: you know exactly which SPVs are exposed, how, and when.

---

Step 2: Choose 3-5 rate scenarios that match real decisions

Keep this pragmatic. The best scenarios are the ones that change what you do next.

A solid baseline set:

1. Base case: current forward view / your house view
2. +50 bps parallel shock (quick stress)
3. +100 bps parallel shock (meaningful stress)
4. +200 bps shock (tail risk / covenant stress)
5. Refinance shock: "at maturity, margin + X bps and base rate at Y%"

Optional but useful if you are more advanced:

• Delayed cuts / higher-for-longer (timing matters)
• Hedge expiry scenario ("swap ends in 9 months-what then?")

Tip: do not over-model the yield curve. For decision-making, simple shocks beat complicated assumptions that no one trusts.

---

Step 3: Translate rate moves into interest cost-facility by facility

This is the mechanical heart of the model.

For each floating facility (unhedged portion):

• Incremental annual interest cost = Unhedged floating loan balance x Rate shock (decimal)
• Incremental monthly cost = Incremental annual cost / 12

For example, 100 bps is 1 percentage point, entered as 0.01. This approximation assumes a constant exposed balance and an immediate rate change for a full year; model actual reset dates, day-count conventions and repayment timing separately.

Then adjust for:

• Interest rate floors
• Caps (strike rate)
• Swap fixed legs
• Hedge amortisation (notional may reduce over time)

Outcome: a clear "rate up 100 bps = an additional £X/month of interest" by SPV and for the portfolio.

---

Step 4: Convert interest changes into decision metrics

Interest cost is not the decision. The decision is whether you still have:

• enough cash headroom, and
• enough covenant headroom,
• at the specific SPVs that matter.

The most useful decision metrics:

A) Cash available after debt service

A simple bridge per SPV:

NOI

• Interest
• Principal (if amortising)
• Committed capex
• Required reserves
  = Cash available / (cash burn)

(You can do this monthly or quarterly, depending on how tight liquidity is.)

B) DSCR / ICR headroom

Common simplified forms:

• Illustrative property interest cover = Annual NOI / Annual interest
• Simplified property DSCR = Annual NOI / Annual debt service (interest plus scheduled principal)

Use matching periods and positive denominators. The OCC handbook describes this property DSCR calculation. The NOI/interest example is not a universal ICR definition: PRA SS13/16, paragraph 2.3 uses expected monthly rent divided by monthly stressed interest for UK buy-to-let underwriting. Actual covenant calculations must follow the relevant agreement.

Use a simplified sensitivity for exploration; confirm the contractual calculation before reporting covenant compliance. The model also needs:

• consistency,
• and a clear warning system for SPVs nearing thresholds.

C) "Runway" under stress

If a scenario produces a cash burn, compute:

Runway (months) = Available unrestricted cash / Positive monthly cash burn

This approximation assumes a constant positive monthly burn and no new funding. Use a dated cash forecast when inflows, outflows or restrictions vary; zero or negative burn does not produce a finite runway from this formula.

---

Step 5: Define action triggers (what you will do when thresholds are hit)

This is where sensitivity becomes a decision tool, not an academic exercise.

Illustrative policy triggers to discuss and approve against the facility terms (these thresholds are not universal recommendations):

• DSCR falls below 1.30x in any SPV under +100 bps -> freeze discretionary distributions from that SPV
• "Runway under +100 bps" falls below 6 months -> accelerate refinance or restructure capex timing
• Hedge expiry within 9 months and unhedged exposure > X% -> hedge decision required by next IC meeting
• Refinancing within 12 months -> run refinance shock scenario monthly

Outcome: you can move quickly without re-debating policy every month.

---

Worked example: one table that turns rates into decisions

Assume this illustrative, interest-only sensitivity (not customer data):

• Portfolio NOI: £4.5m per year, held constant across shocks.
• Debt: £60m total: £40m floating and unhedged; £20m fixed.
• Rates change immediately for a full year; balances remain constant. Fees, floors, amortisation and hedge effects are excluded.
• Current annual interest:
  • Floating: £40m x 6% = £2.4m.
  • Fixed: £20m x 4% = £0.8m.
  • Total: £2.4m + £0.8m = £3.2m.
• Baseline illustrative property interest cover: £4.5m / £3.2m = 1.41x (rounded).

Scenario	Rate shock on floating	Incremental interest (annual)	Total interest (annual)	Interest cover (NOI / interest)	Cash after interest (NOI - interest)
Base	0 bps	£0	£3.2m	1.41x	£1.3m
+50 bps	+0.50%	£40m x 0.50% = £0.2m	£3.4m	4.5 / 3.4 = 1.32x	£1.1m
+100 bps	+1.00%	£40m x 1.00% = £0.4m	£3.6m	4.5 / 3.6 = 1.25x	£0.9m
+200 bps	+2.00%	£40m x 2.00% = £0.8m	£4.0m	4.5 / 4.0 = 1.13x	£0.5m

All amounts above are positive GBP amounts. Cash after interest is not distributable cash: it excludes principal repayments, capex, tax, reserves and cash timing. The interest-cover column is an illustrative NOI-based proxy, not a covenant-compliance conclusion.

Under these assumptions, +100 bps increases annual interest by £0.4m and reduces cash after interest by the same amount. Review each facility's contractual ratios and restrictions separately; a portfolio average cannot establish which SPVs comply or breach.

---

Common mistakes (that make sensitivity useless or misleading)

Mistake 1: Doing sensitivity only at portfolio level

A portfolio can look fine while one SPV is heading into a covenant breach.

Fix: calculate at SPV/facility level, then roll up.

---

Mistake 2: Ignoring hedges (or modelling them incorrectly)

Swaps, caps, floors, amortising notionals-small details change outcomes.

Fix: treat hedges as first-class inputs in the debt register, and separate hedged vs unhedged exposure.

---

Mistake 3: Stressing interest expense but not cash timing

Month-end P&L may look fine, while cash timing creates a crunch (quarterly interest, capex milestones, reserves).

Fix: pair the annual sensitivity with a simple 13-week / 6-month SPV cash view for exposed entities.

---

Mistake 4: Missing refinancing and margin reset risk

The biggest "rate shock" sometimes happens at refinance:

• margin increases,
• fees are paid,
• hedges roll off,
• amortisation terms change.

Fix: always include a refinance shock scenario for any facility inside 12-18 months to maturity.

---

Mistake 5: No action thresholds

If your sensitivity produces numbers but no decisions, it becomes a slide that no one uses.

Fix: pre-agree triggers tied to distributions, hedging, refinance timelines, and capex pacing.

---

Best-practice reporting: what to include in the monthly pack

If you want this to build trust with investors and boards, keep it consistent and simple.

A strong one-page "Rate Sensitivity" section includes:

1. Exposure summary

   • Total debt, % floating, % hedged, next 12 months maturities

2. Scenario table

   • +50 / +100 / +200 bps -> incremental interest and coverage headroom

3. SPV exception list

   • which SPVs are closest to DSCR/ICR triggers under +100 bps

4. Actions / mitigations

   • hedge decisions, refinance plan, distribution posture, reserve posture

5. Assumptions (as of date)

   • base rates used, hedge coverage date, debt balances date

With a separately maintained model, a reviewer can write a supported explanation such as: "Under the stated assumptions, rates +100 bps increase annual interest by £X." Any statement about distributable cash or SPV covenant headroom also needs the relevant cash forecast and contractual calculation.

---

A quick checklist you can implement this month

• Debt register updated (balances, maturities, hedges, covenants)
• Scenarios agreed (+50 / +100 / +200 bps + refinance shock)
• Incremental interest calculated per facility
• Cash and covenant headroom shown per SPV (exceptions highlighted)
• Action triggers agreed (distribution, hedging, refinance, capex)
• One-page pack output generated with "as of" dates

---

Closing: make sensitivity repeatable, not heroic

Interest-rate sensitivity does not need to be complex to be valuable. The goal is a repeatable system that answers:

• What happens if rates move?
• Which SPVs break first?
• What do we do about it-now?

If your data is spread across many SPVs (and often many accounting entities), the real unlock is being able to run these scenarios on consistent, standardised portfolio reporting-so decisions are grounded and fast.