House Hacking in HCOL Areas - Analysis Metrics and Thumb Rules?

[Ryan Hebert]

This question is for current or previous house hackers or others familiar with the numbers surrounding house hacking in HCOL areas:

As part of one of Brandon's webinars, I wrote down his rules of thumb for analyzing rental properties (in his market): $100 positive cash flow per unit, Cash on Cash ROI of 12% or higher (double risk premium of S&P 500 historical to justify added work and risk). I have analyzed a dozen or so properties and so far only one has met these standards in class B areas. That property, plus the highest possible purchase price to reach those two metrics, also fall under what I suppose could be called the "0.8% rule."

Now, those benchmarks Brandon mentioned are for Washington, a much different market than metro Boston Massachusetts, my market. Given the market differences between LCOL and HCOL, are these benchmarks too aggressive? Too conservative?

I also have been analyzing my house hacks with the assumption of all units being rented out, with effectively me "renting" as one of the tenants. This would make the only real calculated benefit of house hacking versus buying a multi-family be the low down payment. When running the numbers, is there another metric I ought to run that takes into account my being an owner occupant and improves the ROI from a certain perspective of accounting for not having to pay rent for primary residence?

If anyone has a house hacking analysis calculator they have created in Excel, I am also quite interested in order to inform my current spreadsheet.