I have downloaded both Chris's version and 123flip.com lite version, I do not see all 25 components (from the  book) on the spreadsheet.

Using the cap rate formula becomes straightforward once you grasp its components.

We toured their facility & having done a lot of rehab etc I was impressed with the construction & designs.At the time we visited they were building components for a commercial with high end units above a store front strip that was very well done.

The more challenging part is the financial conditions component over the actual MCR..

Do you have a ducted heating system, is it a system where all components have failed or just the seperate AC unit.

You just can't advertise the broker comp on the MLS. 

As with most house hacks there will also be an Add Value component and with many of these homes being nearly a century old there is room for this.

I happened to be looking at Monday's houses briefly only because a friend asked me to comp one property's value for him (because I've got mls access as a broker and he just wanted a quickie comp) but I stopped there so I don't know about this one in Shorewood you mentioned.As far as the suburban counties, as you may have noticed, the more well off parts of MKE Cty aren't very well represented compared to the less well off areas, so when you look at the other counties (like the Waukesha Cty sheriff has a running listing of the next maybe 5 or 6 weeks of auctions on their website and each week there's usually 10 to 20 TOTAL each week and quite a few will be in the relatively few not so well off areas of the county and you'll be hard pressed to find many in Chenequa, the most expensive community in all of SE WI) Ozaukee has very few as well as Washington County and I'd guess its the same pattern there as well, but you'll have investors in all of these counties who are watching them. 

Once it's 40+ units on a site ya really gotta have the on-site components.

But generate a nice windfall that is has a large tax-free component.1.