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, 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.”