Quick and easy mortgage calculator
Originally published: 11/08/2020 22:10
Publication number: ELQ-54160-1
View all versions & Certificate
certified

Quick and easy mortgage calculator

Understand your mortgage costs, different mortgage rates and how early repayments will reduce our overall loan profile

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

This Best Practice includes
1 mortgage excel model

Write a Strategy offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

- Understand your mortgage
- Calculate how much you can save from prepayments or changing mortgage rates
- See a full loan cost and how much your house really costs you!

- Able to use excel at a basic level
- Have a basic understanding of your mortgage
- Able to seek professional financial advise before making any decisions based on this template

- Need excel!

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Any questions on Quick And Easy Mortgage Calculator?

The user community and author are here to help. Go ahead!


5.0 / 5 (3 votes)

please wait...