Give the lower rate its due
Illustration, not a current mortgage offer: both deals start on the same day with a £200,000 repayment balance, 25 years remaining, monthly payments and exactly 24 months until the next remortgage. Both are assumed available to the same borrower, with identical early-repayment terms and no other fees. Deal A charges 4.70% fixed plus a £999 product fee paid upfront; deal B charges 5.00% fixed with no product fee. Figures assume no overpayments, rate changes or early exit and round only after calculation. Compare the remaining balance as well as payments: lower monthly payments alone do not measure total cost.
The fee deal is cheaper under those assumptions. It has £1,134.49 monthly payments versus £1,169.18 for fee-free, and an ending balance £359.89 lower. The fee option saves about £1,192.44 in repayments plus equity over 24 months, leaving £193.44 after the upfront fee. That is the same maths as the case for paying the fee. My disagreement is over whether this narrow gain is worth spending the buffer today.
The mortgage calculator can help explore repayment sensitivity, but for fee choices you must also track cash upfront and the balance at the deal end.