BTL Interest Rate Tracker - Template
Written by Scott Jones, founder of PropertyKiln · Last updated
Spot something wrong? Report an error. We reply within 48 hours.
Here is a reusable template for a quarterly interest rate tracker you can drop numbers and charts into every three months.
BTL Interest Rate Tracker - Q[X] [Year]
1. Bank of England base rate snapshot
Current Bank Rate: [X.XX]% as at [MPC decision date].
Last 12 months of base rate
| Date | Bank Rate |
|---|---|
| [Month Year] | [X.XX]% |
| ... | ... |
| [Current Month Year] | [X.XX]% |
Short comment: "Base rate has risen/fallen/stayed flat over the last 12 months, from a peak of [peak]% in [month/year] to [current]% now."
2. Current BTL mortgage rates (headline grid)
Typical BTL rates by product and LTV
| Product type | 60% LTV | 65% LTV | 75% LTV | Notes |
|---|---|---|---|---|
| 2-year fixed | [X.XX]% | [X.XX]% | [X.XX]% | Averages / best-buy range at quarter-end. |
| 5-year fixed | [X.XX]% | [X.XX]% | [X.XX]% | Often cheaper ICR stress; popular for portfolio lending. |
| Tracker | [X.XX]% | [X.XX]% | [X.XX]% | Typically "base + margin". |
Under the table: One line on how these compare to last quarter: "Average 2-year fixed BTL at 75% LTV moved from [prev]% to [current]%."
3. Rate trend: rising, falling or flat?
Add a small chart and a short read:
Chart 1: Line chart of Bank Rate vs average 5-year BTL rate over the last 4 quarters.
2-3 bullet commentary:
- "Base rate has [risen/fallen] by X.XX% over the last year."
- "Average 5-year BTL at 65% LTV has moved from [A]% to [B]% in the same period."
- "Lenders are currently [passing through / not fully passing through] base rate moves."
4. Affordability impact: what a 0.25% change actually costs
Use standard mortgage sizes and show monthly payment changes.
Example: effect of a 0.25% rate move (IO or repayment)
| Mortgage size | Rate before | Rate after | Monthly payment before | Monthly payment after | Change |
|---|---|---|---|---|---|
| GBP 150,000 | [X.XX]% | [X.XX+0.25]% | GBP [A] | GBP [B] | +/- GBP [delta] |
| GBP 200,000 | [X.XX]% | [X.XX+0.25]% | GBP [A] | GBP [B] | +/- GBP [delta] |
| GBP 300,000 | [X.XX]% | [X.XX+0.25]% | GBP [A] | GBP [B] | +/- GBP [delta] |
One-line takeaway: "Every 0.25% on a GBP 200k IO mortgage moves your monthly cost by roughly GBP X."
5. Yield impact: rate changes vs net yield
Property: GBP 200,000. Rent: GBP 950/month. Costs (ex-finance): GBP 250/month. Mortgage: GBP 130,000.
| Scenario | Gross yield | Net yield before finance | Net yield after finance |
|---|---|---|---|
| Old rate [X.XX]% | [Y1]% | [Y2]% | [Y3]% |
| New rate [X.XX+0.50]% | [Y1]% | [Y2]% | [Y3-delta]% |
Short commentary: "A 0.50% rise in rate on GBP 130k wipes roughly GBP [X] a year off your net income, cutting net yield from [Y3]% to [Y3-delta]%."
6. Lender stress tests and ICR
Typical stress test:
- ICR: 125-145% of stressed payment.
- Stress rate: often around 5.5% for BTL, higher for higher-risk or shorter fixes.
Worked example:
| Scenario | Stress rate | Required monthly rent (145% ICR, IO) | Comment |
|---|---|---|---|
| GBP 200k mortgage | 5.5% | GBP [required rent] | Fails if actual rent less than this. |
| GBP 200k mortgage | 7.0% | GBP [higher rent] | Shows impact of tougher lender. |
Note: Some lenders waive or reduce the stress for 5-year fixes or for lower LTVs.
7. What the market expects next
Market expectations
- Futures pricing implies [X] more cuts / hikes over the next 12 months.
- Bank of England commentary: [1-2 bullet summary from the latest MPC minutes / explainer].
What lenders are signalling
- Broker/lender commentary on whether BTL rates are likely to drift down, plateau, or bounce.
8. What landlords should consider this quarter
Key questions to ask yourself
Product expiries "Do I have any fixes ending in the next 6-12 months?"
Fix vs variable Pros/cons at current spreads between 2- and 5-year fixes and trackers.
Affordability and ICR "If rates/stress tests rose by another 1%, would my remortgage still pass?"
Portfolio strategy Are there low-yield properties that become marginal if rates tick back up?
Action checklist
- Pull a portfolio schedule: mortgage size, rate, product end date, LTV, rent.
- For any product ending within 12 months, run: "If remortgage at [current 5-year rate], what is the new payment and ICR?"
- Decide whether to: Fix now, wait and see with a plan, or deleverage / dispose of marginal units.