Call me overly analytical, but I firmly believe that properties and neighborhoods should be classified separately. 

Specifically, I'm looking at some properties that the owner is renting way below market price...so using these analytics makes the offer prices crazy low.

Also it wasn’t an Excel but rather an online list of properties which is not easy to work with for data analytics 

You can check out year to date Airbnb demand analytics for free on Airdna.

Of course, being the analytical geek I am, I would do thorough research before making the purchase. 

I guess the way i was pertaining to would be more for you analytical type.. but if the way you recommended has proven results, might as well keep it simple! 

The reason being that it provides a benefit over multiple periods and hence, should not be expensed completely in the year of purchase.Apart from analytical reasons, the market is very hot right now.

A sobering bit of info from Moodys Analytics said home prices in Naples will not return to their pre-recession peak until 2038!

Yet he's just an average investor - by his own admission - who exercises incredible patience, analytical thinking and chooses to be transparent with his actions.

I've run a AirDNA report to get all the pricing/vacancy analytics.