Need advice : analyzing multi-family property rental deals

[Naveen Himthani]

Hi Experts,

After reading through some material related to multi-property rentals by Rod Khlief, I decided to start analyzing deals online. I created a spreadsheet to do this myself. I am located in the Pittsburgh area. Can anyone tell me if this sheet I made is okay to quickly determine whether the property will cash flow or not. At what adjusted NOI / cap-rate / CoC do people usually even decide to take a look at a property in more detail or crunch more numbers? I do understand that it would vary significantly from person to person, so I am mainly looking at the reasoning behind dropping or not dropping a deal altogether after looking at initial numbers.

One thing I understand is that if the property is just breakeven and there is potential for increasing rents or potential for negotiation in the sale price, then one should dig deeper. I am looking for more reasons like this - where does one generally draw lines of - definitely, maybe (contingent on other things), absolutely No. 

Thanks in advance for your advice! 

Here is the sheet - https://docs.google.com/spreadsheets/d/12erbeAB_IMxu0H-184nL...