Rehab Analysis Spreadsheet


NOTE: The spreadsheet provided below contains numbers for a specific deal that I did…these numbers shouldn’t be assumed to be the numbers that would go into your particular deal(s). If you want to learn how to estimate rehab costs and analyze deals, I highly recommend picking up my books: FLIPPING & ESTIMATING BOOKS.

For investors (and up-and-coming investors) looking for a good spreadsheet to analyze the profitability of a flip, here you go. This is one of the spreadsheets I use everyday in my business (modified to remove a lot of the crap that’s specific to my projects).

It’s a pretty straight-forward spreadsheet, and anyone who has completed a couple flips probably has their own; but for those who don’t or those who have no idea where to start, this should be helpful. Just being able to see in one place all the costs, expenses, commissions, and fees associated with a typical rehab makes the whole analysis a lot less daunting. Not to mention, the rundown of typical labor and materials costs on the worksheet should help new investors get a handle on the list of rehab costs associated with a rehab project.

The spreadsheet is currently populated with an estimate from a recent flip we completed, just to give an idea of how it’s used. Hopefully, you’ll find this useful…

{ 1 trackback }

Top Blogs: 8 Investors Who Are Crushing It and Sharing | Struggling to Get Started
January 28, 2010 at 10:57 pm

{ 24 comments… read them below or add one }

1 Mark Knudson October 26, 2010 at 4:07 pm

This re-hab spreadsheet just saved me a whole day of designing one from scratch. Plus I’m sure theres stuff in here that I wouldn’t have thought of. Thank you so much! Thank god for Google Search!

2 Pam Hutchison January 17, 2011 at 12:37 pm

Loved the spreadsheet. Customized a few things I used, and on the way. Thanks so much! Pam, Almost Home in KC, Kansas City

3 Amanda Fox July 20, 2011 at 12:02 am

EXTREMELY HELPFUL!! Thank you! I just paid for a rehab estimator and am much happier with the one you just provided me. One big question I had, though, is what is the square footage roughly of the house you were estimating? Thanks again, Amanda

4 J Scott July 20, 2011 at 12:11 am

Hi Amanda,

That house was about 1900 square feet. That said, I wouldn’t use this spreadsheet as an estimation tool…it’s definitely not meant to be used that way. It’s more of a template you can use to analyze a deal, using your own rehab numbers.

5 Amanda Fox July 20, 2011 at 5:56 pm

Thanks so much! I’m using your spreadsheet along with several other resources to come up with a rehab analysis tool to analyze my deals. Your spreadsheet is really helpful to me for comparison. Where, out of curiousity, was this house located? Thanks again!! Amanda

6 Philip Bourdon August 18, 2011 at 2:49 am

Hi. No matter what I do, no matter how much updating I do with Microsoft Word, I cannot download the Business Plan. Is there any other way I can receive it?

7 mariana August 26, 2011 at 7:51 pm

Love the spreadsheet!!!!

8 Dennis LaVergne September 28, 2011 at 5:49 pm

Great spreadsheet-it helps put a lot of things side by side so that I can get my mind around what all needs to be considered as well as the associated costs. I am curious as to how you estimate your labor cost. Do you start out with a rough estimate and adjust as you go along?

9 J Scott September 28, 2011 at 11:52 pm

Hey Dennis,

I’ve been using the same contractors for several years now, so I have a very good idea of what they charge for different types of jobs. That said, doing what you suggest (starting with rough estimates and iterating as you get bids) is definitely the way to go. Just make sure you start very conservative, so that when you fill in actual numbers (from actual bids), you don’t have to worry about your budget skyrocketing.

10 D Phillips November 25, 2012 at 8:25 pm

You’re God sent!

11 Patricia Richardson May 28, 2013 at 2:20 pm

How do we reach you for a consultation?

12 J Scott May 29, 2013 at 11:35 pm

Hi Patricia -

I don’t really do consultation. You’re welcome to post questions on the blog, and I can answer them here, and if you want more flipping info, feel free to check out my new books:

13 James T July 30, 2013 at 3:59 pm

Thank you for great spreadsheet!

14 Javi January 29, 2014 at 6:36 pm

was the holding total for 1 month?

15 J Scott January 29, 2014 at 9:45 pm

Javi -

I’m not sure I understand the question? You can ignore the data in the spreadsheet…it’s just an example. You can enter your own data to get results for your specific properties.

16 Bryan Love January 30, 2014 at 7:04 pm

Just wanted to be number 10000000 to thank you for all the time and insight you offer us. This site is a wealth of information! Thanks again

17 Pat King April 8, 2014 at 9:26 pm

Thank’s for this spreadsheet. Just what I was looking for!

18 Kumar April 25, 2014 at 10:50 am

Thanks J for the wonderful spreadsheet.

19 Susan Perry April 26, 2014 at 5:23 pm

I wanted to see your spreadsheet

20 CJ May 8, 2014 at 1:17 am

Thanks for the spreadsheet and easy download. Just what I was looking for.

21 Linda M May 24, 2014 at 3:23 pm

Nice job developing this sheet. It saved me so much time. Thanks so much!

22 Lisa Fara September 4, 2014 at 2:52 am

What a great, simple spreadsheet template!! Love it! Thank you! -LF

23 Dan Sullivan January 20, 2015 at 3:33 pm

Proud owner of J. Scott’s book and love the bigger pockets website. The final questions in each blog segment is a cool send off as well. Looking at the spreadsheet where “Seller Costs” is listed, I don’t understand why you have a “Commission to Agent” and “Buyer Closing Costs”. Aren’t you just duplicating the same 6% commission fee?

24 J Scott January 24, 2015 at 10:06 am

Hey Dan -
Regarding your question about Seller Costs, the commissions are what are paid directly to the two agents for their work; the “Buyer Closing Costs” are concessions that some buyers ask for to offset their out-of-pocket costs at closing. For example, with FHA buyers, it’s not uncommon for them to ask the seller to pay up to 3% of the sale price towards their closing costs.

Leave a Comment