Mortgage Calculator for Google Sheets

With this Mortgage Calculator for Google Sheets you can quickly calculate the monthly payment for your mortgage and estimate home prices you can afford based on your personal finances.

You will get your own copy of this spreadsheet. You can use the calculators directly as is, but also modify them and make as many copies as you want of the document.

You will have access to the underlying formulas as well, which you can use to create new calculators and perform your own analyses.

With this product you will get:

🔢  Four ready to use calculators:

✅ Calculate the monthly payment for your mortgage
✅ Compare multiple mortgages at once
✅ Calculate the home price you can afford with your current purchase power and savings

✅ Calculate a range of home prices you could afford for different personal finance scenarios

🧪 Three custom formulas:

✅ Mortgage monthly payment formula
=MORTGAGE_MONTHLY_PAYMENT(homePrice, downpayment, years ,rate)

✅ Home Price you can afford formula
=HOME_PRICE(monthlyPayment, downpayment, years ,rate)

✅ Total Interest Payed for a given Mortgage formula
=TOTAL_INTEREST_PAYED(homePrice, downpayment, years ,rate)