Turn your Excel Spreadsheet into a powerful online database application with a few clicks

Excel Mortgage Calculator

February 2nd, 2005 | Categories: Templates | Tags: , ,

I’m working on buying a house and I’ve found myself using the Payment function quite a bit lately. I uploaded the few line example of an Excel Mortgage Calculator that may save somebody frustration from using the ridiculous java calculators I see on some sites.

Using the Payment(PMT) function straight from this Microsoft explanation, here is a basic Excel Mortgage Calculator, Excel Mortgage Calculator Download.

Here’s a screenshot of the basic Excel Mortgage Calculator I created (that’s all there is :-):

From the Help files: “The payment returned by PMT includes principal and interest but no taxes, reserve payments, or fees sometimes associated with loans.”

  1. November 17th, 2010 at 16:00
    Reply | Quote | #1

    there are mortgage calculators online that are free but i wonder if they are up to date “:-

  2. November 8th, 2011 at 22:43
    Reply | Quote | #2

    As someone said above, nothing!