Free Home Mortgage Calculator Spreadsheet Template
Calculate monthly mortgage payments and view a full amortization schedule. Enter loan amount, rate, and term to see payment breakdowns over the life of the loan.
What's Included
- Dashboard with payment summary showing monthly payment amount, total interest, and total cost of the loan
- Mortgage setup sheet with inputs for loan amount, annual interest rate, loan term in years, and start date
- Full amortization schedule displaying each monthly payment with principal, interest, and remaining balance
- Principal vs. interest breakdown per payment showing how the split shifts over the life of the mortgage
- Total interest over loan life with color-coded input cells (yellow) and auto-calculated schedule (blue)
- Works in Microsoft Excel, Google Sheets, and LibreOffice Calc with no setup required
Need more from this template?
The free version covers the basics. The Pro version goes further.
- Single loan setup with monthly payment calculation
- Dashboard with monthly payment, total interest, and total cost
- Basic amortization schedule
- Works in Excel and Google Sheets
- Set up and compare 3 loan scenarios side by side with loan amount, interest rate, term, and start date
- Dashboard with 6 KPI cards: best monthly payment, best total interest, loan count, total amount borrowed, lowest rate, and best term
- Full amortization schedule for each scenario with payment number, date, payment amount, principal, interest, and remaining balance
- Scenario comparison sheet ranking all 3 loans by monthly payment, total interest, total cost, and break-even analysis
- Extra payment analysis showing how additional monthly, annual, or one-time payments reduce interest and shorten the loan term
Preview
See what's inside this template
How to Use This Home Mortgage Calculator Template
Enter loan details
Input the loan amount, annual interest rate, loan term in years, and start date on the mortgage setup sheet.
Review monthly payment
The calculator displays your monthly payment amount including principal and interest. Taxes and insurance are not included.
Explore the amortization
The full schedule shows every monthly payment split between principal, interest, and remaining balance from first to last.
Check total interest
The dashboard shows total interest over the life of the loan alongside the total amount paid (principal plus interest).
Built by Claude AI. Perfected by us.
We use Claude AI to draft each template, after a deep research. Then our team steps in. We refine the layout, stress-test every formula, fix edge cases, and polish the design until it feels like something we would actually use ourselves. The AI gets us 80% there. The last 20% is all human judgment.
Frequently Asked Questions
Does it include taxes and insurance?
No. The calculator covers principal and interest only. Property taxes, insurance, and PMI are separate costs not included in this calculation.
Can I enter a 15-year term?
Yes. Enter any loan term in years. Common options are 15 and 30 years, but the calculator works with any term you input.
How is the monthly payment calculated?
The calculator uses the standard amortization formula. It divides the loan into equal monthly payments that cover both principal and interest over the full term.
Can I see how much interest I pay in year one?
Yes. The amortization schedule shows each monthly payment. Sum the interest column for the first 12 rows to see your first-year interest total.
How do I open this in Google Sheets?
Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.
What license is this template under?
All free templates are released under CC BY 4.0 (Creative Commons Attribution). You can use, modify, and share them freely - including for commercial purposes - as long as you credit FinancialAha.com. They are provided as-is and do not constitute financial advice.
More Free Mortgage & Home Templates
Looking for premium spreadsheet templates?
Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.