I created this template to analyze real estate investment deals. It's basically a quick model to see if an investment makes sense. The values filled in are for a warehouse that I bought a couple years ago.
For an actual purchase it's best to consider taxes and depreciation since this can have a large impact on the return. Typically I would use this calculator for an initial analysis and then use a spreadsheet that incorporates taxes and depreciation.