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 :-) :
MortgagePaymentCalculator

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


Get LIVE Help
Custom Excel solutions & live Excel help!
► Go to www.ExcelAutomationHelp.com
► Email Now@ExcelAutomationHelp.com
  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!