Deal calculation

[James Sullivan]

Good morning BP world! I just recently came upon what seems to be a good deal. I have a motivated seller willing to release 4 properties in a low income area (all in a 2 mile radius) for around 75K. I am certain that two of the four will appraise for at least 30K. So of course, I am trying to make the deal work on the lending aspect of it. My questions is how would I calculate this on an excel sheet? I used the investor calculator posted by @BrandonTurner and treated it like a multi-unit and lumped everything in. Should I be doing this or is there another way to have each house broken down and each cost separated per SFH?