How does this tool assess interest rate risk? The tool utilizes a Cumulative Cost Analysis to determine the point of parity between two mortgage deals with different interest rates. It calculates the capital gained during the lower-rate period of a tracker and calculates the exact month where subsequent rate hikes fully erode that initial capital benefit. The tool should give bit more predictability to uncertain events in the future and allows a broker to propose “what if” scenarios to their clients. To ensure practical application, the values provided are rounded to the nearest month within a period.

What is the significance of the ‘Breakeven Month’ for a borrower? The breakeven month defines the Strategic Window. If the projected breakeven is at Month 32, but the investment’s target exit or refinance event is scheduled for Month 24, the variable-rate strategy remains mathematically superior—even if the market moves against the borrower in the latter half of the term.

Why does the model highlight the difference between ‘Repayment’ and ‘Interest-Only’ facilities? Sensitivity to rate fluctuations is significantly higher in Interest-Only structures because the interest is applied to a non-amortizing principal. In contrast, with Capital Repayment, a portion of the principal is repaid each month, meaning the interest rate required to reach a breakeven point is higher. Conversely, the breakeven point for Interest-Only is reached at a lower interest rate because the debt remains static. This tool allows for a granular comparison, ensuring the “Cost of Debt” is accurately reflected in long-term cash flow projections.

How should these results be used in financial planning?  The unpredictability of Bank of England Base Rate movements often leads borrowers to seek the security of a fixed rate, potentially losing out on the financial gains of a lower variable or discounted rate. This tool establishes a ‘Maximum Rate Tolerance.’ Under normal economic conditions, Base Rate movements typically occur in 0.25% increments and can be lowered as well as raised depending on economic conditions. By adjusting the frequency and magnitude of rate steps (e.g., modeling a 0.25% hike every quarter vs. 0.5% bi-annually), an advisor can identify the specific environment required for a variable-rate strategy to outperform a fixed-rate facility over a 2–5 year horizon.