Good Morning Dave, I got this good deal on 3 bedroom and 1 bath Brick home, huge backyard, nice hardwood floor now the good thingthe a/c unit gone, need little plumbing work, patch a couple hole in wall & paint.

For example: if you had to replace a toilet you could classify that expense as plumbing or bathroom and use a sumif function on the master to capture each dollar amount spent in each category on each unit.

Find the approximate location of wall mount wanted and alternative location if not possible due to electric, plumbing or support. 

Short list of items to do are roof repairs, new kitchen, 2 new bathrooms, add laundry room, inslaute attic, new plumbing for one bathroom, paint the house inside and half of outside, and a host of small items.  

Small stuff like the age of furnace, plumbing, electric, HVAC will add up once tenants move out or in terms of on going maintenance cost.Sharad

Built: 1910 2-Family Lot size – 40FT x 100 FT Building size – 20FT x 58FT Back Taxes:  $7,748.79   Annual Taxes: $4,904Market Value: $1,175,000 (based on property tax assessment, building is uninhabitable so this is not accurate)Department of Buildings: Violation – unsafe building issued 2010My Half Baked Plan- I'm no where near acting on any of this so if I'm completely off base keep in mind i'm learning and would like your input.OFFER- 100K cash (no inspection i will assume back taxes)REHAB- 200-300K  - Without ever stepping foot inside, I'm assuming that we would need to go to the studs, new plumbing, electric, roof, mid-range finishes. 

I would also take into account the possible vandalization i.e. copper plumbing that might get ripped out, in certain neighborhoods, when the criminals smell a vacant property.

I am currently in plumbing school.

Have them point out what different components cost (roof, HVAC, plumbing, electrical, paint, flooring) and what to look for to determine if they need fixed/replaced.

Maybe there are major foundation issues, or plumbing, or its still knob and tube and needs a complete re-wiring.