Mortgage Calculator — Amortization, Prepayment & Lender Comparison | Excel

Know the true cost of your home before you sign anything.

This professional Excel mortgage calculator gives you instant clarity on your monthly payment, total interest paid over the life of the loan, and the real cost of your property — all automatically calculated from just 6 inputs. No financial background required.

What’s Included (4 Sheets)

• Mortgage Calculator — monthly payment, total interest, prepayment simulator, and 28% debt-to-income rule check


• Full Amortization Schedule — 300-month table showing principal vs. interest broken down for every single payment period


• Lender Comparison — compare up to 6 banks or lenders side by side on the exact same loan amount and term


• How to Use — color-coded guide explaining every cell (blue = your inputs, black = auto-calculated formulas)
  
  

Key Outputs You Get Instantly

✔ Exact monthly payment based on your rate and term
✔ Total amount paid over the life of the loan
✔ Total interest as a percentage of the original loan
✔ Real cost of the property including all financing
✔ Months and interest saved by making extra monthly payments
✔ Best lender automatically identified in the comparison tab

Built for Professionals and Beginners Alike

• Industry-standard color coding used by finance professionals


• Zero formula errors guaranteed


• Compatible with Excel 2016+ and Google Sheets


• Fully editable


• Bilingual: English and Spanish
  
  

Perfect For

First-time homebuyers, mortgage brokers, real estate investors, financial planners, and anyone evaluating refinancing decisions or comparing loan offers from multiple banks.