Analysis Feedback

[Derek L.]

Good afternoon, wanted to post another spreadsheet to see if this was a fair way of analyzing a potential rental deal. This is a duplex in Lancaster (75134) listed for $74k. This model assumes traditional financing with 20% down and assumes minimal rehab (although this could, and probably should, be added).

This is ideally what I'd use to back into an offer price that would get me into a 10% - 15% total return range.

Based on the inputs here, the returns are lower than the target range and would require the total purchase price to be in the $55k range.

Would love input on anything material that I might be leaving out.

Thanks in advance.

Spreadsheet Link