Ultimate Rental Property Analysis Spreadsheet

Review rental properties and buy & hold investments like a Pro with our free rental property analysis spreadsheet

  • No Credit Card Required
  • User Friendly
  • Full Privacy & No Ads
  • Works Online & Offline

Compatible with Windows and Mac

Compatible with Mac
windows_logo

Runs on Microsoft Excel Only

Excel-Icon

10,000+ investors trust our products to review their investments

Real Estate Investors Common Mistakes

INVESTING DOESN’T HAVE TO BE DIFFICULT

Don’t Make The Same Mistakes

Our pre-built spreadsheet is easy to use and beginner-friendly. With this template, you’ll be able to analyze any property within a few minutes, making it easy to quickly review a lot of deals and investing opportunities

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 so you don’t have to waste your time on bad apples

Our template includes all the most relevant metrics and financial indicators used by professional real estate investors to guide your in your selection

Our Rental Property Analysis Spreadsheet will help you make sound financial decisions with your money. By taking the guesswork out of the equation, you’ll learn to be more confident in your actions and overcome your analysis paralysis

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

discipline Matters

All the features you need… and more!

With our Rental Property Analysis Spreadsheet, quickly review rental investments and uncover the true economic potential of your properties

Single & Multi-Family

Analyze both Single Family Houses and Multi-Family Properties

30-year-forecasts

30-year forecasts

Rental Income, Operating Expenses, Net Operating Income, Debt Service, Capex, Cash Flow…

Profitability Analysis

Advanced profitability analysis with 15+ Key Financial Indicators (IRR, MIRR, CoC, Cap Rate, EMx, etc.)

Scenario-Analysis-Icon

Scenario Analysis

Automatically assess the impact of your parameters & assumptions on profitability

Maximum Offering Price

Maximum Offering Price

Calculate the maximum offering price to achieve your profitability target

Sale Date Optimization

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

Transaction-Reports-Icon

Transaction Reports

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

Custom Sheet & White Labeling

Tailor our template to your specific needs with our additional fully customizable sheet

Online-Knowledge-Database-Icon

Online Knowledge Base

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

Excel in Real Estate

Ready to Excel in Real Estate?

Download our Free Rental Property Analysis Spreadsheet and start investing in real estate now

Kickstart 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

Powerful & Easy To Use

FULL STACK SPREADSHEET

This real estate investing spreadsheet is an all-in-one solution for investors looking to acquire rental properties for buy-and-hold investments. It’s full of features that will make your life as an investor easier and less stressful

PLAN FOR THE FUTURE

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

KEEP YOUR DEBT IN CHECK

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

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

SHARE YOUR ANALYSIS

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

Graphs

SEE YOUR INVESTMENT IN PICTURES

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 

RUN WHAT IF ANALYSIS

Automated Scenario Analysis

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

Purchase Price or Rent Level

Impact of variations in Offering Price for different levels of rental income

Down Payment and Interest Rate

Impact of various down payment levels and interest rates on investment return

Operating Expenses

Impact of variations in operating expenses using the rule of thumb

Automated Scenario Analysis
Max-Offering-Price-Tool

ASSESS HOW MUCH YOU SHOULD OFFER

Maximum Purchase Price

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

Minimum Cap Rate or Cash on Cash Return

Expected Cash Flow

Internal Rate of Return Threshold

FOR LARGER INVESTMENTS

Multi-Family Analysis

Easily review large multi-family properties and apartment buildings with our Pro Version

Unlimited Number of Units

Review buildings of all sizes with unlimited units and up to 10 different types of unit

Detailed Per Unit Assumptions

Individual operating assumptions for greater customization and additional flexibility

Multi-Unit Report

Get a comprehensive overview of your portfolio with detailed data about all your units

Multi-Unit-Report

And Much More!

We stand behind our products and services

One Time Payment

Purchase it once, and keep it forever! No membership, monthly plan or hidden fee!

Premium Support

If you have any questions about the spreadsheet, get in touch and we will assist you in no time

Free Updates. Forever

We update our spreadsheets frequently based on users’ feedback and requests, free of charge

Lines of Calculation
Years Projected
Financial Ratios
Graphs & Reports
Happy Customers

Still not Impressed?

Don’t Take Our Word For It, Check What Our Customers Say

Try our Free Rental Property Analysis Spreadsheet Now

Flexible Pricing for Everyone

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

Light Version

Free

  • Basic Features
  • Rental Property Analysis
  • Multifamily (Up to 5 units)
  • 30-year Projections
  • Basic Return Analysis
  • Debt Maturity Schedule
  • Summary Page

Advanced Version

$85

  • Advanced Features
  • Everything in Light
  • Advanced Return Analysis
  • All Reports Available
  • Scenario Analysis
  • Cash Out Refinancing
  • Max Purchase Price Tool
  • Sale Date Optimization
  • Custom Sheet & Labeling

Pro Version

$250

  • PRO Features
  • Everything in Advanced
  • Unlimited # of Units
  • Up to 10 Types of Unit
  • Per Unit Assumptions
  • Multi-Unit Report
  • Priority Support

or Pick a package and Unlock all spreadsheets.

Combo Package

$140

  • Full Access to All Advanced Spreadsheets:
  • Advanced Rental Property Analysis
  • Advanced House Flipping & Rehab

Gold Package

$400

  • Full Access to All Pro Spreadsheets:
  • Pro Rental Property Analysis
  • Pro House Flipping & Rehab

Common Questions

Absolutely, we made our spreadsheet as user friendly as possible. The great thing with pre-built templates is that you don’t need to know how they work to use them and take advantage of them.

Our Rental Property Analysis Spreadsheet works with Microsoft Excel (2013 or newer). It is not compatible with Google Sheets nor Apple Numbers unfortunately, due to the limited capabilities of these applications.

The spreadsheet works both on Mac and Windows computers so we’ve got you covered!

There are a few reasons why you might prefer to use an Excel spreadsheet over an online rental calculator, including:

  1. Customization: Our Excel spreadsheet allows for a higher degree of customization, making it easier to track the specific information that is important to you and your real estate investment. You can create customized formulas and calculations in the custom sheet to better analyze your property.
  2. Control: With our Rental Property Excel spreadsheet, you have complete control over your data and the way it is stored. This can be especially important if you have sensitive financial information that you prefer not to store online. Also, because we don’t store any of your data, we don’t sell it either! So no ads, no targeted phone calls, just the peace of mind.
  3. Cost: Our excel template is offered for a one-time fee only, whereas online calculators and other apps usually have a monthly or annual subscription fee. For those on a tight budget, an Excel spreadsheet definitely represents a more cost-effective solution.
  4. Access: With our rental spreadsheet, you can access and make changes to your investment assumptions even when you don’t have an internet connection. Very useful to globetrotters that travel the world looking for the right deal.
  5. Advanced Analysis: Online apps are great to have a quick snapshot of your real estate investment but Excel provides advanced modeling and analytical capabilities, allowing you to perform more sophisticated financial calculations and simulations that may not be possible with an online app.

Because everyone has specific needs and requirements, we added to our template a custom sheet that users can freely modify to tailor the spreadsheet to their needs. In this sheet, you can add additional features and calculations and link their results to other sections of our template

House-Flipping-Spreadsheet

More into House flips and Rehab Projects?

Check out our new Ultimate House Flipping & Rehab Spreadsheet

Get In Touch Today!

Let us know how we can help you!

We care about our users and are always happy to assist you in your real estate investing journey so reach out and let us know how we can help!

About The Author

NICK PETERS

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!

About the Author