How to Quickly Evaluate a Real Estate Deal

Edit: There is an updated version of this article and spreadsheet over on our Serial Startups website.

There is a common saying among real estate investors, “Review 100 deals, make offers on 10, purchase 1.”

When I first began investing in real estate, I could not see how this could possibly be true.  Who really goes and looks at 100 properties just to get a single deal?

It wasn’t until I was speaking with a fellow investor that I learned my mistake: you don’t physically need to see 100 deals in person, you just need to find 100 deals to evaluate.  Obviously, it takes time to evaluate 100 deals, so it makes sense to find a way to quickly evaluate deals.

house_funnel

I ended up creating a spreadsheet for quickly evaluating deals.  Many of the formulas that I used came from the book “What Every Real Estate Investor Needs to Know About Cash Flow… And 36 Other Key Financial Measures“.  My goal was to be able to enter a few pieces of data and quickly analyze a property using multiple formulas.  I then wanted a quick way to determine if the property was worth a further look.  Below is the breakdown of the spreadsheet that I currently use.

Property Details

The first section is pretty straightforward.  Enter basic information about the property.  Orange cells require user entry.

estimation_sheet_property_details

 

Purchase Details

The second section gets into more of the financials.  Again orange cells need to be entered.  Gray cells with orange text are calculated and black cells do not apply.  This section contains information about the property itself, the funding to purchase it and the cost to renovate it.

estimation_sheet_purchase_details

 

Rental Information

This section contains information about the number of rentable units and the going rate for rent in the area.  It then calculates various relevant information about the rental financials.

estimation_sheet_rental_information

 

Estimated Financials

Since the point of this sheet initially is to be a quick way to evaluate deals, we use 50% as the operating expenses for the property.  This gives us a high level idea of how the investment looks.  I like to target at least $100 estimated cashflow per unit.

estimation_sheet_estimated_financials

 

Calculated Financials (Optional at this point)

As a later step if you want to further evaluate the deal, I have a second sheet where you can break down the operating expenses, which will give you a calculation based on the actual numbers you enter for each line item.  I skip this step when doing the initial analysis.

estimation_sheet_calculated_financials

 

Additional Analysis

This section contains some additional information which may be relevant to you.

estimation_sheet_additional_analysis

 

Should You Purchase the Property?

And now the magic.  The numbers on the page give you a lot of information, but do not make it clear if you should pursue the property.  I have determined 3 criteria that I want my properties to achieve in order to pursue them.

  1. Monthly rent (GSI) should exceed 2% of the purchase price (+ renovations)
  2. Cashflow should be $100+ per unit
  3. The debt coverage ratio should be greater than 1.2

Because you entered all of the information above in order to calculate these values, the spreadsheet will now tell you in simple terms if you should purchase the property.

estimation_sheet_purchase_property

 

If one of the values did not meet my criteria, it show up as red and provides a different recommendation.

estimation_sheet_do_not_purchase_property

 

What I love about this spreadsheet is how much data it generates and how easy it makes scanning through potential deals.  I have added a ton of additional functionality to provide further analysis if I decide to purchase the property, which I will outline in a future blog post.

Here is what the first tab of the spreadsheet looks like put together.

property_calculation_spreadsheet

Download a Free Copy of This Real Estate Spreadsheet

Do you need forms to run your real estate business?

Check out our Landlord Pack below!

Landlord Complete Forms Package for Buy and Hold Real Estate Investors

Learn More About Our Real Estate Forms

25 thoughts on “How to Quickly Evaluate a Real Estate Deal”

  1. Tom Sylvester

    Good to hear Dan. I should also point out… this analysis is for a buy/hold rental property. If I was looking at a buy/renovate/sell, rent-to-own or some other strategy, then my analysis would be different.

  2. Thanks. It works now. The only issue is that I can’t enter data into it since the file is protected and required a password.

    Please advise.

    1. Andy – The only cells that you should be changing are the orange ones. The other cells are protected since they calculate information. If you are having issues with entering into the orange cells, please let me know and I will assist.

  3. Tom, thank you for this post. I’m perusing your other site as we speak. This is a great tool and is helping me think through what a potential deal would look like. Again, thank you.

    John

  4. new to BP and wonder if @Tom Sylvester is still sending out link? I would be interested also. Tom article was very informative.

  5. Tom,

    Great post. Thanks for sharing. Is the spreadsheet referenced above still available? I ask because when I click on the download link on the site referenced above, it resolves to a page not available message. Please let me know.

  6. Hi Tom. I was unable to download the spreadsheet from your serialstartups website. Can you provide an updated link to it? Thanks!

  7. Reginald Auguste

    Great spreadsheet! I am new to real estate investing. Looking to learn as much as I can. Any advice or books you can recommend? Can I also have a copy of spreadsheet if available.

    Thank you in advance.

  8. Hey Tom, I had a question about this spreadsheet.

    Why do you not include the down payment in the cell for Out of Pocket Costs (E33) and do you know if this cell is used in any of the other calculations?

Leave a Comment

Your email address will not be published. Required fields are marked *