Gut check my quick & dirty rehab cost estimation?

[Eli Kallison]

Hi BP,

I am considering buying my first BRRR property with significant rehab costs associated with it. I tried to estimate costs without getting bids (through a combination of local website prices to average costs in my area googling) to make an initial offer. I know this will not be all that accurate but I want to know if I am in the general ballpark for this 3-family all-brick 3200sq foot building (2 stories) in St. Louis, MO. I have an inspection from a previous potential buyer.

For the kitchen and bathroom remodels, I am less concerned about exact figures here I just wanted to allocate a budget towards modernizing them. I am mostly concerned with the other items, particularly the Safety/Structural items.

Any feedback here (see screenshot of spreadsheet).