How do I analyze multifamily deals?  

With fixed expenses, this would depend on the SFH you’re analyzing.

Doing some rehab is generally one of the more common ways to do so.One other item to add, when analyzing a property in a hot market, looking at cash flow and cash-on-cash return alone doesn't give you a good picture.

I'd suggest starting out by analyzing properties and learning what constitutes a "deal"  there are alot of pigs out there with lip stick but underneath the lip stick they are still pigs.  

I think you need to analyzing your buyer in those areas and the demo graphics. 

I purchase their raw data by zipcode(s) to analyze historical/competitive properties and massage it into the critical details I am looking for (need some basic excel skills).  

(He also welcomed/encouraged us to run purchases by him: even to simply independently analyze whether we should pay down points, or use that cash toward the down payment, or save the cash and just pay more each month on the mortgage, etc -- things the BiggerPockets calculators can't do and loan officers give you the vibe they're too busy for.)

When analyzing a sub to I look at how much to get in and how long before I have my money back out via cash flow and captured equity.

the nicer the neighborhood also, the higher the rent.usually, when analyzing a property, I look at:Purchase price (loan payment)taxes (county, city, school)insurancevacancy (7-12%)management (10%)capex (10%)(repairs for things down the road, ie: roof, furnace, etc. less for newer home, maybe zero for a number of years.)Misc (could be anything, ie:  Water, trash. lawn care, snow removal, etc...depends on your area)once I have this number, I subtract it from the rent I can expect to receive. ( you need to know what you can get in the area for rent. 

Does anyone have a spreadsheet or tool they are willing to share that helps them analyze your budget vs actual costs for a rehab?