agreed (this does not constitute advice).
if anyone is interested (
), the Excel formula to give repayment term in years is:
=NPER(annual interest rate/12, monthly payment, -mortgage amount)/12
e.g for 2.5% APR, £500/month, £100,000 mortgage:
=NPER(0.025/12, 500, -100000)/12
=around 21.5 years
to give monthly payments, eg if interest rate goes up:
=PMT(annual interest rate/12, repayment term in years/12, -mortage amount)
e.g. for 5% APR, term as calculated above, same mortgage:
=PMT(0.05/12,21.58*12,-100000)
=around £632