Mortgage calculator with Excel Learn how to create a mortgage calculator in Excel using the PMT function. Then, you can easily and accurately calculate your loan payments.