Hi Tyler,
Definitely a lot of info to work with, which is great. I'll start with a few off the top of my head questions split between rehab and ongoing operations.
Rehab:
-Assuming the roof costs come in at $10K, I've got a minimum of $107,200 in costs given your totals. That doesn't include any AC work on the second building (which I assume was excluded as it's not needed. But I'd question that given the overall state of the building you give.)
-Will the tenants continue to live in their current units as work is done, or will they need to be displaced? Their income needs to be factored into this if they stay, and if they need to be moved, depending on their lease, you might need to cover some/all of the costs. There's obviously the potential of moving them into a post rehab unit but will you be able to get the increased rents and as they're tenants prior to you buying will they treat the new unit as well as a new rehab required?
-If the property is in such rough condition, will $2K in landscaping costs and no exterior work be enough to get new tenants at the increased rental rates? All the interior work is great, and probably way overdue, but if someone won't walk into a unit to see it it's poorly deployed capital.
Operations:
-What's current market occupancy and how long do you think it will take to get the units rented? You show how much they can rent for, but knowing how long it will take to rent them, and if you want to keep current residents (assuming they'll pay the new rents), will be necessary to model.
-There's no marketing budget and if you're trying to turn around the image you're going to need to do something which will draw the type of attention you need. You'll need an ongoing cost considered as well as a bigger upfront splash to get people in the door.
-I might have misunderstood something, but I calculated $46,200 gross potential based on rental rates of $425 (1 BR) and $500 (2 BR). Was I missing something here?
There are many more questions to be asked, and I'd be happy to go review some of it with you if you'd like, but this is a good starting point.
-Justin