DataBait

2-Year vs 5-Year Mortgage Decision Calculator

Description

“Should I get a 2 or 5-year fixed rate mortgage?”. This calculator helps you decide whether it’s more cost-effective to lock your mortgage rate for 2 years now and then re-fix for 3 years, or to lock for a full 5 years today. Please read the instructions below the calculator.

Calculator

  1. Locate Today’s Gilt Spot Yields
    • Spot 2-Year Yield (%)
      • Go to the Bank of England website (or another reliable financial data source such as MarketWatch or Trading Economics).
      • Find the current 2-year UK government bond (gilt) yield.
      • Enter that number (for example, 4.018) into the “Spot 2-Year Yield (%)” box.
    • Spot 5-Year Yield (%)
      • Similarly, find today’s 5-year gilt yield.
      • Enter that number (for example, 4.141) into the “Spot 5-Year Yield (%)” box.
  2. Enter Your Personal Mortgage Details
    • Your Best Available 2-Year Mortgage Rate (%)
      • Look up the 2-year fixed mortgage rate your lender (or broker) is offering to you right now.
      • This should be an annual percentage rate (for example, 4.200).
      • Enter that rate into the “Your Best Available 2-Year Mortgage Rate (%)” box.
    • Your Best Available 5-Year Mortgage Rate (%)
      • Look up the 5-year fixed mortgage rate your lender is offering (for example, 4.500).
      • Enter that rate into the “Your Best Available 5-Year Mortgage Rate (%)” box.
  3. Enter Your Loan Amount and Product Fees
    • Loan Amount (£)
      • Enter the total mortgage amount you intend to borrow (for example, 250 000).
      • This field drives all of the total-cost calculations in pounds.
    • 2-Year Product Fee (£)
      • Enter the arrangement fee (or product fee) you will pay when you fix for 2 years (for example, 999).
      • This fee is assumed to apply when you first take out the 2-year deal and also to the laster 3-year deal.
    • 5-Year Product Fee (£)
      • Enter the arrangement fee you will pay if you lock in a 5-year deal today (for example, 1 299).
      • If you instead choose the 2→3 chain, this 5-year fee is not charged—in that scenario you only pay the 2-year fee up front.
  4. Click “Calculate”
    Once all inputs (Spot yields, mortgage rates, loan amount, and fees) are filled out, click Calculate. The form will instantly compute:
    1. Implied 3-Year Forward from 2→5 (gilt) (%)
      – The gilt market’s expectation for a 3-year interest rate beginning in two years.
    2. 2-Year Mortgage Spread Over Gilt (%)
      – The difference between your 2-year mortgage rate and the 2-year gilt yield.
    3. Implied 3-Year Forward Mortgage Rate (2→5) (%)
      – Your forward gilt rate plus your 2-year mortgage spread, giving an estimate of the 3-year mortgage rate you’d likely pay in two years.
    4. Avg Cost Over 0→5 (2 yr + 3 yr) (%)
      – A time-weighted average: two years at your current 2-year mortgage rate, then three years at that implied forward mortgage rate.
    5. Your 5-Year Mortgage Rate (%)
      – Echoes the number you typed for your 5-year deal.
    6. Total Interest Cost (2 yr + 3 yr) (£)
      – The total interest you pay over five years if you do the 2→3 chain, calculated as
      (avgrate(avg rate % ÷ 100) × Loan Amount × 5 years(avgrate.
    7. Total Cost (2 yr + 3 yr) (£)
      – Total interest on the 2→3 path plus the 2-year product fee (since you only pay that one fee up front).
    8. Total Interest Cost (5 yr) (£)
      – The total interest you pay over five years if you fix for five years straight, calculated as
      (5−yearrate(5-year rate % ÷ 100) × Loan Amount × 5 years(5−yearrate.
    9. Total Cost (5 yr) (£)
      – Total interest on a 5-year fix plus the 5-year product fee.
    10. Recommendation: 2 yr → 3 yr vs 5 yr Now
      – A simple text conclusion that compares “Total Cost (2→3 chain)” vs “Total Cost (5 yr)” and indicates which option is likely cheaper in absolute pounds.

How to Interpret the Results

  • If the Recommendation says “2-yr → 3-yr chain is likely cheaper”
    This means that, once you add the 2-year fee only once (for the initial fix) and calculate all interest over five years, the sum of interest + fee for the 2→3 route is lower than the sum of interest + fee for the 5-year fix today. In practice, you’d save money over the full five-year horizon by doing a 2-year fix first (paying its fee) and then re-fixing for three years (without a second 2-year fee).
  • If it says “5-yr fix now is likely cheaper or equal”
    This means that, after adding the 5-year product fee to five years of interest at your 5-year rate, the total cost is the same or less than the total interest + 2-year fee you’d pay on the 2→3 chain. In that scenario, locking in a 5-year deal may be the better choice (or at least not more expensive).

Important Things to Consider

  1. Mortgage Spread May Change
    – We assume your lender’s margin above gilts stays constant between now and year 2→5. In reality, margins can widen or tighten, so your actual 3-year re-fix rate may differ. Treat the implied forward rate as a rough guide, not a guarantee.
  2. Gilt Yields Move Daily
    – Gilt spot yields (2-year and 5-year) fluctuate every trading day. Always fetch the latest rates (within a few hours of calculating). Using outdated gilt data will skew forward-rate and average-cost outcomes.
  3. Decimal Places
    – We display calculated rates to three decimal places. When comparing to your lender’s rates, note that a difference of even 0.010 % (1 basis point) can be meaningful on a large loan. In the total-cost fields, we show two decimals (pence).
  4. Transaction Costs & Fees
    – This calculator includes only the product fee(s) you typed in—it does not include application fees beyond that or any early-repayment penalties or legal costs. If one product has a low headline rate but hidden fees, be sure to add those into the relevant “Product Fee” box before calculating.
  5. Credit Score & Eligibility
    – The published rates (for example, 4.200 % on a 2-year fix) may require a certain loan-to-value (LTV) or a particular credit profile. If the rate you actually qualify for is higher, enter your true qualifying rate.
  6. What Happens at Year 2 and Year 5
    • If you choose the 2 yr → 3 yr chain: You pay the 2-year fee up front. In two years, you re-fix for three years at the implied forward rate—without paying a second 2-year fee. If interest rates rise sharply in the interim, your actual 3-year re-fix rate may exceed the implied rate, costing more than projected.
    • If you choose the 5 yr fix: You pay the 5-year fee once. You are fully locked in for five years—so if rates fall steeply, you cannot re-fix without facing penalties or switching costs.
  7. Round-Trip Comparison
    – You can run this calculator repeatedly with different 2-year or 5-year mortgage rates, loan amounts, or fees to find exactly where the “break-even” point is. For example, if your 2-year fee is much higher than the 5-year fee, the 5-year fix may become more attractive even if its headline rate is slightly higher.

Example Walk-Through (With Fees Included)

  1. User Inputs (today’s values):
    • Spot 2-Year Yield (%) = 4.018
    • Spot 5-Year Yield (%) = 4.141
    • Your 2-Year Mortgage Rate (%) = 4.200
    • Your 5-Year Mortgage Rate (%) = 4.500
    • Loan Amount (£) = 250 000
    • 2-Year Product Fee (£) = 999
    • 5-Year Product Fee (£) = 1 299
  2. Calculator Outputs:
    1. Implied 3-Year Forward (gilt) ≈ 4.223 %
    2. 2-Year Mortgage Spread Over Gilt = 4.200 − 4.018 = 0.182 %
    3. Implied 3-Year Forward Mortgage (2→5) = 4.223 + 0.182 = 4.405 %
    4. Avg Cost Over 0→5 (2 yr + 3 yr) = (2×4.200 + 3×4.405) ÷ 5 ≈ 4.323 %
    5. Your 5-Year Mortgage = 4.500 %
    6. Total Interest Cost (2 yr + 3 yr) = (4.323 % ÷ 100) × 250 000 × 5 = 54 037.50 £
    7. Total Cost (2 yr + 3 yr) = 54 037.50 + 999 = 55 036.50 £
    8. Total Interest Cost (5 yr) = (4.500 % ÷ 100) × 250 000 × 5 = 56 250.00 £
    9. Total Cost (5 yr) = 56 250.00 + 1 299 = 57 549.00 £
    10. Recommendation = “2-yr → 3-yr chain is likely cheaper.”
  3. What That Means:
    • Over five years, the 2→3 chain costs you £55 036.50 (including the one upfront 2-year fee).
    • Locking a 5-year deal costs you £57 549.00 (including the one 5-year fee).
    • Since £55 036.50 < £57 549.00, the calculator recommends the 2-year then 3-year route.
  4. Alternate Scenario: If your 5-year fee were only £499 instead of £1 299, then:
    • “Total Cost (5 yr)” would be 56 250.00 + 499 = £56 749.00.
    • You would still see the 2→3 chain as cheaper (55 036.50 < 56 749.00).
    • You can tweak each fee or rate until the calculator flips its recommendation.

Final Tips

  1. Always re-run this calculator whenever any input changes (gilt yields, mortgage rates, loan amount, or fees).
  2. Enter your actual qualifying rates and fees—never rely on generic “advertised” rates if you cannot personally secure them.
  3. Watch small differences in rate: A gap of just 0.1 % (10 basis points) on a £250 000 loan over 5 years can mean thousands of pounds.
  4. Include all fees: If your lender charges an “application fee” in addition to the product fee, add that into the “Product Fee” boxes before calculating.
  5. Consider early-repayment penalties: If you refinance or repay early, you may face breakage costs not captured here.
  6. Consult a mortgage broker or financial adviser for final guidance. This tool is a calculator and not a substitute for professional advice.