Landing Mortgage Calculator

Excel Mortgage Calculator

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

Totally Free! Only requires Microsoft Excel

Compatible with Windows
Apple Logo
Compatible with Windows and Mac

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

Mortgage Calculator

Custom Extra Payments

The calculator allows extra monthly 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

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 principal payments on your repayment schedule and the total cost of your financing

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

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)

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%).

Download our Free Excel Mortgage Calculator

Not What You're Looking For?

We have other Calculators & Spreadsheets

Free Rental Property Analysis Spreadsheet

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

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

House Flipping Spreadsheet

© 2019 RealEstateSpreadsheets.com – All rights reserved.
Proudly made in NYC

Staying in Touch