Guru, Book, & Course Reviews
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback
J. Scott's Book on Estimating Rehab Costs - Spreadsheet?
Along with many others I'm sure, I read "The Book on Estimating Rehab Costs" by @J. Scott. Great book by the way so if you haven't gotten around to it, do so (it's a quick read).
Since reading it I've felt like it needed a supplementary spreadsheet for easy reference and quick calculations (including entering your own numbers). I've been planning to put this together myself but haven't gotten around to it. Basically, I'm looking for an electronic version of the table that starts on page 201.
In the interest of saving myself some time and working smarter not harder, has anyone already done this?
Also, I can't seem to tag J on this post so if someone else could that would be appreciated. I'm guessing he may have already shared what I'm looking for but I missed it. Thanks.
There is a rehab analysis spreadsheet here on BP. I also believe the J. Scott has an electronic version on his website. @J Scott please confirm.
Thank you for sharing; Was also looking for this
Thank you @Tyrus Shivers and @Jassem A.
I'm looking through the spreadsheet and I think it's worth mentioning that it's possible to spend a lot less for certain material items as well as labor in many cases depending on how frugal you want to be
interior door with hardware: $5-10 used, $30-50 new
window: $10-50 used, $100-200 new
light fixtures: $1-10 used, 6 pack flushmount at lowes for $44
fan fixture: $24-60 new
water heater: $250 new
toilet: $50-90 new
sink: $40-200 new
faucet: $10-30 new
tile: 0.49-2/sqft new
appliance: $20-200 each appliance used
my last rehab was:
60 elec permit cost + 300 elec repair (tenant destroyed meter box causing house to be condemned)
1600 material + 1500 labor flooring for 1400 sqft
500 material + 600 labor spray paint whole house semigloss and patch some large holes
$30 for 4 interior doors which I put in
$10 mirror for bathroom
$100 paint porch, stairs, and stair rail brown
$50 fridge, $10 burner plates for stove
I also spent at least a few hundred with help on cleaning and taking out the trash and some other expenses here and there which altogether added up to about 5 thousand.
I spent maybe 30 hours over there in total on the weekends.
Originally posted by @Jassem A.:
I'm looking through the spreadsheet and I think it's worth mentioning that it's possible to spend a lot less for certain material items as well as labor in many cases depending on how frugal you want to be
I think you're missing the point of that spreadsheet. It is NOT intended to provide an estimate of what each of the things listed would cost. It's just a template of how you can use a spreadsheet to analyze a deal. The numbers in there are for a specific project I did years ago -- for example, where I list $300 for doors, that's probably the replacement of 4 interior doors...or perhaps one exterior door (I don't remember the specific project that I modeled this for).
But, if you use this spreadsheet to determine how much things cost, I'm curious where you'll find windows for $0... :)
Originally posted by @Lucas Pfaff:
Along with many others I'm sure, I read "The Book on Estimating Rehab Costs" by @J. Scott. Great book by the way so if you haven't gotten around to it, do so (it's a quick read).
Since reading it I've felt like it needed a supplementary spreadsheet for easy reference and quick calculations (including entering your own numbers). I've been planning to put this together myself but haven't gotten around to it. Basically, I'm looking for an electronic version of the table that starts on page 201.
In the interest of saving myself some time and working smarter not harder, has anyone already done this?
Hey Lucas,
If you purchase the books off BiggerPockets, it comes with a whole bunch of digital files that mirror what's in the books (including the table you're looking for).
I'm guessing you purchased the book off Amazon, so you wouldn't have gotten those digital files. Feel free to shoot me a email (address in sig) and I can get those over to you...
Yes I understood what the spreadsheet was conveying and that there was some materials provided in the labor section since it's difficult to know what the contractor spent on materials since most people pay after the job is done anyway. I suppose it's more useful as a way to check things off the list and gauge how much you could spend or would like to spend.
@J Scott Email sent
Originally posted by @Jassem A.:
I suppose it's more useful as a way to check things off the list and gauge how much you could spend or would like to spend.
Actually, the main purpose of the spreadsheet is the analysis provided on the left-hand side (columns B and C).
The inclusion of the rehab estimate section was just to give an example of how to generate the values for Cells C13 and C14 of the analysis, and the information in the rehab estimate portion of the spreadsheet can be completely ignored. I just included the rehab estimate portion of the spreadsheet as one example of how to do it -- you can generate those values any way you want, and don't need to use the rest of that spreadsheet at all.
I never intended for anyone to get any value out of the specific dollar values I have in those cells...they are essentially made up...
@J Scott J thanks for jumping in to take this one. Well put bro
Hi @J ScottI bought your books thru Amazon. Would you please send me the digital files? Thank you in advance. Mark Mattison
Originally posted by @Mark Mattison:
Hi @J ScottI bought your books thru Amazon. Would you please send me the digital files? Thank you in advance. Mark Mattison
Hey Mark - Shoot me an email to the address in my signature...
Hey @J Scott hope all is well, I just came by this thread and just bought your book on amazon and saw that bigger pockets actually offers estimation templates, sample contractor agreements and 8 other documents.. I know I'm late but was wondering if I can still recieve those documents? I can provide order info
P.S. Was gonna send you an email but for some reason your email isn't available anymore. I assume biggerpockets took it out because of the guidelines. Not sure how else to get in contact with you
Thank you :)
Originally posted by @Chandler Howell:Hey @J Scott hope all is well, I just came by this thread and just bought your book on amazon and saw that bigger pockets actually offers estimation templates, sample contractor agreements and 8 other documents.. I know I'm late but was wondering if I can still recieve those documents? I can provide order info
P.S. Was gonna send you an email but for some reason your email isn't available anymore. I assume biggerpockets took it out because of the guidelines. Not sure how else to get in contact with you
Thank you :)
Sent you a PM!
@J Scott...hi. could I also please get those additional documents that would come with the digital version? I have a hard copy of your book so I didnt get the additional stuff.
@J Scott I would like the digital files as well. I purchased the book via Amazon
The links are available above for the spreadsheets. One tool I have been looking at using as well is flipper force. Has anyone had experience with their project management tool? Might try it out for thirty days.
Hi @J Scott
I just finished reading your book, great stuff!! I'm from Mexico, so I'll try to embark on a mission to tropicalize some of the content, components and costs to this market. Anyway, I just found out I could've purchased your book here in BP, and I could've had all this great additional content. I was wondering if you could share this with me. I can also provide order details from Amazon
RM
Quote from @J Scott:
Originally posted by @Lucas Pfaff:
Along with many others I'm sure, I read "The Book on Estimating Rehab Costs" by @J. Scott. Great book by the way so if you haven't gotten around to it, do so (it's a quick read).
Since reading it I've felt like it needed a supplementary spreadsheet for easy reference and quick calculations (including entering your own numbers). I've been planning to put this together myself but haven't gotten around to it. Basically, I'm looking for an electronic version of the table that starts on page 201.
In the interest of saving myself some time and working smarter not harder, has anyone already done this?
Hey Lucas,
If you purchase the books off BiggerPockets, it comes with a whole bunch of digital files that mirror what's in the books (including the table you're looking for).
I'm guessing you purchased the book off Amazon, so you wouldn't have gotten those digital files. Feel free to shoot me a email (address in sig) and I can get those over to you...
I realize you wrote this ten years ago, and it was a very generous offer! I'm going to be that person who asks if you might be willing to also send me the same files? (I bought the book off of Kindle!)