Ultimate Rental Property
Analysis Spreadsheet

Get our free rental property analysis spreadsheet for reviewing rental properties
and buy & hold investments like a pro

Try our Light Version, completely Free!

Free Rental Property Analysis Spreadsheet
Compatible with Windows
Compatible with Mac
Compatible with Windows and Mac
Runs on Excel
Runs on Microsoft Excel
Featured Image Featured Image

Don't make the same mistakes as most investors

  • Wasting hours trying to analyze properties?
    Our pre-built spreadsheet is easy to use and beginner-friendly. With it, you'll be able to analyze any property in less than two minutes so you can review lots of potential deals very quickly
  • Buying unprofitable properties because you didn't run the numbers?
    Our calculator will run them for you and will immediately tell you if a deal is worth negotiating for or if it is a non-starter
  • Not knowing what to look at when searching for a "good" deal? Our template includes all the most relevant measures and indicators used by professional real estate investors

Jumpstart your journey as a real estate investor

As a real estate investor, you will have to look at tens or hundreds of deals before finding the one that works for you. So you need to be able to quickly identify opportunities and tailor your offer to each situation in order to get a shot against other seasoned investors

Review More Properties

Make More Offers

Negotiate Better Prices

Close More Deals

All the features you need... and more!

With our rental property analysis spreadsheet, analyze rental investments in less than a minute and get a detailed assessment of a property’s potential

House icon

Single & Multi-Family Analysis

Analyze both Single Family Houses and Multi-Family Properties

30-year forecasts Icon

30-year forecasts

Rental income, Operating expenses, Net Operating Income, Debt service, Capex,  Cash Flow…

Profitability Analysis Icon

Profitability Analysis

Perform complex profitability analysis using more than 15 key financial indicators          (IRR, MIRR, EMx, CoC, Cap Rate, etc.)

Scenario Analysis Icon

Scenario Analysis

Automatically review the impact of multiple parameters on your profitability

House Check icon

Maximum Offering Price

Identify the maximum offering price to achieve your profitability target

Sale Date Optimization Icon

Sale Date Optimization

Optimize your total return by selling your property at the right time

Transaction Reports Icon

Transaction Reports

4 reports included: Summary Overview, Operating Expenses, Financing, and Debt Amortization Schedule

custom sheet

Custom Sheet & White Labeling

Tailor our template to your specific needs with our additional fully customizable sheet. You can also add your logo to our reports

Online Knowledge Database Icon

Online Knowledge Base

Get access to an online knowledge database to help you source all the information you need

Free Rental Property Analysis Spreadsheet

In Real Estate, money is made when you buy not when you sell so do the math before you close the deal

Advanced Investment Projections

Up to 30-year operational and financial projections, with flexible drivers and multiple parameters.

Detailed Cash Flow Forecasts

Calculate Rental Income, Operating Expenses and Cash Flows over the life of your investment

Profitability Analysis

Check your profitability using industry standards such as Cash on Cash Return, Cap Rate, Internal Rate of Return, etc.

Sale Date Optimization

Our model will let you know how to optimize your profit by selling at the right time

Debt Amortization Schedule

Track down your debt repayment on a monthly or yearly basis, over the life of your project

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 over the life of your investment

Key Debt Ratios

These mandatory ratios for lenders and financial partners (Loan To Value, Interest Coverage, etc…) 

Professional Reports

Easily print and share professional reports with investors, lenders, business partners and other professionals and get instant credibility as you advance in your real estate journey.

Summary Report

With all key assumptions, indicators and results

Financing Report

Snapshot of financing terms and lending ratios, a must-have for business partners and lenders

Expense Report

Detailed overview of your yearly operating costs, summarized in a clear and concise way

Try our Free Rental Property Analysis Spreadsheet Now

Plenty of Summary Graphs

Get an overview of your deal and identify key takeaways in a second. Our graphs are easy to understand and easy to share:

Cash Flow Waterfall

Understand the transition from rent to cash flow

Property Value & Equity Build-up

Check your property’s value and its built-in equity year after year

Total Return Analysis

Visualize the value creation through Cash Flow, Property Appreciation and Principal Repayment 

Automated Scenario Analysis

Easily see how the profitability metrics of your deal are impacted by changes in key assumptions, including:

Changes in Purchase Price or Rent Level
Changes in Down Payment and Interest Rate
Changes in Operating Expenses
(Rule of thumb)

Maximum Purchase Price

Let our spreadsheet guide you in the negotiation process by estimating the maximum purchase price you can offer in order to achieve your desired profitability, using multiple financial indicators:

Minimum Cap Rate or Cash on Cash Return
Minimum Cash Flow
Minimum Internal Rate of Return

And Much More!

We stand behind our products and services

Cart Icon

One-time payment

Purchase it once, and keep it forever! No membership, no hidden fee or additional charge! We pride ourselves to be one of the most affordable solutions for investors

Support Icon

Premium Support

You have a question about the spreadsheet or you are facing a technical difficulty? Get in touch and we will assist you in no time!

updated

Free Updates

We update our spreadsheets frequently based on users’ feedback & requests.  All future updates come free of charge for our customers

0
Lines of Calculation
0
Years Projected
0
Financial Ratios & KPIs
0
Powerful Graphs
0
Professional Reports

Still not impressed?

Don’t take our words, check what our customers say.

Great tool! Building it myself would have taken so much time so it made sense to get it. And it’s clearly more detailed than other tools and templates I’ve used in the past.

5/5

Visar A.

New York, NY

A big thank you for the spreadsheet. I have limited knowledge of excel and I was afraid I would struggle with this one but it is actually very easy to use, even for true beginners

5/5

Ana P.

Charlotte, NA

As a real estate agent and investor myself, I’ve been recommending it to my clients. It’s a great tool to review deals online and it saves me a lot of time on a daily basis

5/5

Pete B.

New York City

A very practical tool that is easy to use, even when you’re not familiar with excel and financial models in general. It’s the ultimate resource to become a successful investor

5/5

Brendan H.

Denver, CO

This is an amazing spreadsheet. I’ve been using it when looking at properties and get a feel for potential investments and this calculator has been helping me a lot. Highly recommend for anyone interested in real estate investing.

5/5

Lina C.

Los Angeles, CA

I’m by no means an excel guy, even less a math guy but after trying the spreadsheet, I knew it would be a great investment. And for the price, it’s an invaluable resource for any serious investor. On top of it, Nick has always been helpful when I had questions or needed guidance

5/5

Mark S.

Pittsburgh. PA

I can’t imagine the hours spent to build this template and I’m thankful I won’t have to do it myself. This spreadsheet is well thought and provides great flexibility thanks to the custom sheet. Love it! 

5/5

Ben T.

Seattle, WA

Flexible Pricing for Everyone

Try out our Light Version or super charge your analysis skills with the premium features of our Advanced Version

For Beginner

Light Version

Free
Yes, Completely!

Basic Features

  • Rental Property Analysis
  • 30-year Projections
  • Essential Return Analysis
  • Debt Maturity Schedule
  • Summary Page
Try Now
Pro Package

Advanced Version

$50
One-Time Payment

Premium Features

  • Everything in Light Version
  • Save Project
  • Advanced Return Analysis
  • All Reports available
  • Scenario Analysis
  • Max Purchase Price Tool
  • Sale Date Optimization
  • Custom Sheet & Labeling
Get Now

About The Author

Hi there, I’m Nick Peters. Investment Banker during the day, I’m passionate about real estate and financial modeling so I decided to combine both interests and create RealEstateSpreadsheets.com to help people find better real estate deals. This free rental property analysis spreadsheet is the result of countless hours of work, and will help you make well-informed decisions before pulling the trigger on a property.

In Real Estate, money is made when you buy, not when you sell so it is important that you do the math before you close the deal. This spreadsheet is all about that: running numbers for you so you can efficiently distinguish great deals from non-performing assets.

It has been built with everything you need to analyze potential deals very quickly so I hope it will be as useful to you as it has been to me for several years now!

Free Rental Property Analysis Spreadsheet

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

Staying in Touch