Rehab Analysis Spreadsheet
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 }
{ 9 comments… read them below or add one }
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!
Loved the spreadsheet. Customized a few things I used, and on the way. Thanks so much! Pam, Almost Home in KC, Kansas City
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
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.
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
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?
Love the spreadsheet!!!!
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?
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.