Buy Now

Mortgage Calculator
Excel Template

Calculate your mortgage and payment schedule with our Mortgage Calculator and Rental Income Excel Template. Equipped with dynamic charts and graphs to view your principal and interest payments over a 15 or 30 year loan.
Unlock Access
Video Poster Image

What's Inside the Mortgage Calculator Template?

Details | 5 Sheets 

Supported Versions | Excel 2007, 2010, 2013, 2016, 2019, Office 365 (Mac)

Category | Real Estate

Tags | Payoff, Amortization, 15 year, 30 year

Why Professionals Choose Simple Sheets

It's simple. Access to the largest library of premium Excel Templates, plus world-class training.

100+ Professional Excel Templates

Optimized for use with Excel. Solve Excel problems in minutes, not hours.

Buy Now

World-Class Excel University

With our university, you'll learn how we make templates & how to make your own.

Explore Catalog

How-To Videos

Each template comes with a guide to use it along with how-to videos that show how it works.

Buy Now

Inside Our Mortgage Calculator

Excel Template

In the Monthly Rental Income sheet of our Mortgage Calculator Excel Template you can see the rental income mapped out and charted.

The largest purchase most people make in their lifetime? 

A Ferrari. 

That’s obviously not true, but wanted to make sure you’re paying attention. The answer is a home. While millennials living in New York City or San Francisco won’t ever get to feel that joy (that was the last joke, promise), it’s important to understand the financial obligation you walk into when signing up for a mortgage. 

That’s why we created the Mortgage and Rental Income Excel Template. There are two main tasks this template helps you achieve. The first calculating your mortgage payment information. The second is calculating your rental income if you rent out a home or even a room you own. 

Before we dive into how to use this pre-built spreadsheet, you’ll also want to check out our Personal Budget and Room Repair Request template (only if you are a landlord this will be helpful). 

Start in the Mapping sheet and confirm the Payment Frequency details.

Hop over to the Monthly Rental Income sheet, even if you’re not renting out your property. Input your data in the Real Estate Object section. Fields include Total Size (Square Feet or Meters), Purchase Price, Down Payment and Additional Expenses like Realtor, Land Registry and Taxes. The Total Capital Required will automatically calculate and be used in the Mortgage Calculation sheet. 

If you are not renting out the property or even another property, you can move to the Mortgage Calculation sheet without filling out the Monthly Rental Price. If you do fill that out, the Gross Yield Per Square Feet or Meter will automatically calculate. 

Below where you fill out that information is a chart that displays Accumulated Income and Monthly Cash Flow. Below the chart is an Income Schedule table for you to track monthly rental payments and additional expenses. You can even add notes about changes such as a tenant moving in or out and how that may adjust the cash flow that month. 

See the Payment Schedule on a 15 or 30 year mortgage mapped out in the Monthly Calculator sheet
View your Total Cash Flow by month in this sheet

Move to the Mortgage Calculation sheet and input your Mortgage Details. While the Loan Amount will be reflected in the data you put in the other sheet, fill out the Interest Rate, Duration of Loan, Payments Due, Payments Frequency and Date of First Payment. 

The chart below will auto populate the Amortization Schedule. Seeing your payments not stop until 2049, given how rough 2020 was, reminds us we might get through this year. 

Below that is a table with your Payment Schedule, detailing every payment due up until the house is paid off. You can also see the Principal vs. Interest Paid and Closing Balance. 

Whether you have already bought a home or are planning to buy one, a spreadsheet like this gives you real data that will be helpful in your decision making. 

More Real Estate Templates For You

Simple Pricing for Full Access

Unlock full access to the entire library for one low price.

Limited

$49

(no bundle savings)

  • 45+ Customizable Excel Templates
  • One User
  • One-Time Payment
BUY NOW

Premium + University

$199

($699 bundle savings)

  • Full Access to Excel University ($399 bundle savings)
  • 100+ Customizable Excel Template
  • Personal Membership Portal
  • Excel, PowerPoint, & Word 101 Courses ($199 bundle savings)
  • Two Users
  • One-Time Payment
BUY NOW

Premium

$99

($299 bundle savings)

  • 100+ Customizable Excel Templates
  • Excel, PowerPoint & Word 101 Courses ($199 bundle savings)
  • One User
  • One-Time Payment
BUY NOW