Quick and easy mortgage calculator

Description
The mortgage calculator helps you understand your mortgage costs, different mortgage rates and how early repayments will reduce our overall loan profile and how much money you can save by paying off your mortgage early.

This mortgage calculator lets you take an in-depth look at one of the most expensive purchases of your life – your house.

It is set up for one property but can be replicated for a number of different properties in a portfolio. The model does everything you would expect – lets you add details of your house price, LTV, deposit, term length, etc. to see your payment profile, interest over time, and how different mortgage rates and periods will change your interest expenses.

The model can be used to see how early repayments will reduce our overall loan profile and how much money you can save by paying off your mortgage early.

Instructions:
- Fill in anything in yellow on the Mortgage projection tab and don't edit anything else
- Go to [Mortgage projection] and input your house price, deposit, date of first payment and mortgage years
- Complete the mortgage information section - e.g. if you have a 5 year fixed mortgage at 3% rate which converts to a 5% variable then put 5 rows of fixed 3% with any associated one off costs and 5% in the rest
- You can edit when you think you will remortgage and approx. rates as well as any prepayments to see how much you could save on your mortgage