Mortgage calculator spreadsheet

Calculates monthly payment, total interest and total cost from price, down payment, rate and term.

Edit online in SheetsDownload XLSX

Good for

  • Comparing loan scenarios
  • Planning a home purchase

Tips

  • Change the blue input cells only.
  • Compare rates by duplicating the sheet.
  • It excludes taxes, insurance and fees.

About this template

This template was created by WorkFlo and is free to use for personal and commercial purposes. It is a regular XLSX file, so it opens in WorkFlo and in other office software.

More templates