Excel Mortgage Calculator

Get our free excel mortgage calculator spreadsheet to estimate your monthly mortgage payment

Compatible with Windows and Mac

Compatible with Mac
windows_logo

Runs on Microsoft Excel Only

Excel-Icon
Landing Mortgage Calculator

More features than most Online Mortgage Calculators

Our excel mortgage calculator comes with all the features you need to quickly estimate your mortgage payments under various scenarios

Mortgage Calculator

Amortization Schedule

Get a monthly schedule of principal & interest payments, PMI and more

Custom Extra Payments

The calculator allows extra mortgage payments, either on a recurring or exceptional basis

House icon

Interest-Only Loans

Our excel calculator is also adapted to Interest-Only Loans

Transaction-Reports-Icon

Printable Summary

Your Loan Amortization Schedule can easily be printed and shared with others

Download our Free Excel Mortgage Calculator

UNDERSTAND YOUR MORTGAGE

Powerful Mortgage Calculator

Up to 30-year mortgage projections, with multiple parameters

Easy to Use Excel Spreadsheet

All parameters are entered in one area of the Excel spreadsheet, making it very easy to use, even for complete excel beginners

Dynamic Results

Quickly assess the impact of an interest-only period or some extra mortgage payments on your repayment schedule and the total cost of your financing

Mortgage Calculator
Annual Schedule
GET THE FULL PICTURE

Annual Amortization Schedule

Track down your debt repayment on a yearly basis, over the life of your loan

Principal vs Interest Payment

Determine how much goes towards principal repayment vs. interest

Total Cost of Debt

Know exactly how much your financing strategy is costing you over the life of your investment

SHARE YOUR MORTGAGE INFORMATION

Summary Report

Easily print and share your loan amortization schedule with all the necessary information: principal payments, interest payments, PMI, remaining loan balance and Loan to value ratio (LTV)

Ready to Print

Easily save your amortization schedule as a PDF with one click

All Key Financial Data

All key figures are included in the report: interests, principal, PMI and total payments made over the loan life

Monthly Amortization Report

Get our Free Excel Mortgage Calculator

Frequently Asked Questions

The excel mortgage calculator is composed of 3 sheets but only the “Mortgage” tab requires any input from users.

Key mandatory fields include:

  • Property Purchase Date: Enter the Property’s purchase date. This date will be used as a starting point for the loan amortization schedule.
  • Property Value: Indicate how much you will buy the property for
  • Down Payment: Indicate the initial up-front payment for the purchase of the property. A 20% down payment is usually considered to be the norm in the U.S., although it is possible to go as low as 3.5% for certain government-backed mortgages (FHA mortgage for instance). Once entered, the spreadsheet will automatically calculate the resulting loan amount.
  • Interest Rate: Enter the loan’s stated annual percentage rate (APR)
  • Loan Term: Most fixed-rate mortgages in the U.S. are scheduled to amortize over 30 years. Other customary tenors include 10, 15 and 20 years. Note that our calculator has been built to work with loans up to 30 years.

Other optional fields that may apply to your situation include:

  • Interest-Only Period: If your loan is an Interest-Only Loan, indicate the length (in years) of the Interest-Only Period.
  • Loan Insurance – PMI: A Private Mortgage Insurance is a type of insurance conventional mortgage lenders require when home buyers put down less than 20% of the home’s purchase price. If applicable, note than the average annual PMI premium typically ranges from 0.55% to 2.25% of the original loan amount each year.
  • LTV Threshold for PMI Cancellation: Most lenders require payment of PMI if your down payment is below 20% of the home’s purchase price. In most cases, PMI will continue to be paid until the Loan To Value (LTV) reaches 80%.
  • Property Value Annual Growth Rate: Enter the expected annual appreciation rate of your property. This figure is only used for the “Property Value & Loan Balance” graph on the right side of the Mortgage sheet.
  • Add Extra Monthly Payment: Enter your amount for recurring monthly mortgage prepayments. For custom prepayment amounts (on a month-by-month basis), please enter your figure in the “Custom” column of the “Optional Prepayment” section of the schedule. As a result, you will see that your mortgage is being amortized and repaid more quickly. The mortgage calculator will show you how much is being saved in interests and how many months or years are being saved off the original loan term.

Yes, our excel mortgage calculator is completely free to use.

Unlike other online mortgage calculators, our spreadsheet can be used offline as long as you have Microsoft Excel installed on your computer. Additionally, your work can easily be saved and continued later. On the privacy and security side, no data is being shared or tracked by external third parties: what is in your spreadsheet stays in your spreadsheet!

Finally, the spreadsheet offers additional tools and features that most online mortgage calculators don’t provide such as custom or recurring optional extra payments, interest-only loans, and payment of Private Mortgage Insurance based on a Loan To Value threshold.

Finally, the spreadsheet is easy to print and easy to share with others.

Absolutely, you can either add recurring monthly extra payments or custom payments on a month-to-month basis

Prepaying your mortgage with extra principal payments will have two key impacts on your mortgage:

  • It will reduce the overall length of your mortgage (i.e. your mortgage will be repaid earlier than initially projected)
  • It will reduce the total amount of interests paid over the life of the loan

Prepaying your mortgage will however not reduce your monthly payment.

Private Mortgage Insurance is usually required by conventional mortgage lenders when home buyers put down less than 20% of the home’s purchase price. Note that the average annual PMI premium typically ranges from 0.55% to 2.25% of the original loan amount each year.  In most cases, PMI will continue to be paid until the Loan To Value (LTV) reaches 80% or below (the lender is required to stop PMI payments when the LTV reaches 78%).

Not What You’re Looking For?

We have other calculators & spreadsheets

Rental Property Spreadsheet

Rental Property Analysis Spreadsheets

Free Rental Property Analysis Spreadsheet for reviewing rental properties and buy & hold investments like a pro

House Flipping Spreadsheet

House Flipping & Rehab Spreadsheet

An all-in-one solution for analyzing house flipping deals, estimating rehab costs, tracking expenses, managing deadlines and more.