How to calculate mortgages

how to calculate mortgages

Using your Spreadsheet to calculate mortgages

Here the values in column D "Pre-Paid" can be added by the user to show how much additional principal is paid off that pay period. You can then add up the interest values in column B for each year to see how much tax deductible interest you have paid.

To do ARM's, you use the same idea, but stop the table after X payments and shift to a new interest rate which generates a new $b$2 value for column B interest values as well as a new payment (not $b$4 any more in column C). You can do all sorts of different scenarios this way by having the interest in a single cell you can change and watch the whole amortization table shift.

Here is hcmort.wks a very basic Lotus 123 compatible spreadsheet following the example above. Just about every spreadsheet made by mankind (and Microsoft too!)

will accept WKS format spreadsheets. See if this works for you.

This example above uses the Excel version of PMT. Yours may differ.

Here is a Excel 5.0 module (Windows or Mac) for doing Canadian mortgages that I found at

Here is a shareware Excel 5.0 for example: Windows Version Mac Version

Mac users can also get a demo ClarisWorks amortization spreadsheet here which should work fine in Excel too.

If for some reason you do not have a spreadsheet like Excel or a similar office suite, you can download and use LibreOffice free for any platform. Windows or Linux GNOME users who do not want to use the full LibreOffice suite can use gnumeric too.

If anybody wants me to write up a simple Excel spreasheet for your particular case, I will do so for a small PayPal or check payment. Contact me if you are interested.


Category: Credit

Similar articles: