Over the past few years Brock Mogensen at Smart Asset Capital has worked on developing his own multifamily deal analyzer.  After receiving great feedback over the years regarding the tool, he decided to make it available to everyone.  It was designed with the idea of being simple enough for people that aren't experts in Excel, but detailed enough to provide the information an investor needs to make an educated investment decision.  As an added bonus the analyzer is accompanied with a 10 part video series that will teach you everything you need to know about analyzing deals and using this tool.