Four Square Method of Analyzing Rental Properties

[Rick Turman]

Good morning BP family!

So I decided to make my own spin on Brandon Turner's Four Square Method of Analyzing Rental Properties by incorporating it into a "FILL IN THE BLANK" template.   

With this being said, I've shared the link through my One Drive so that someone else who finds it useful can download it and try it out.  

If you have excel, google docs, or Open office on your IPAD, and are hesitant about that deal on your prospected property, run it through this template and find out what your COC-ROI will be year end.

Those fields that are gray in color have been locked as they are hard coded with formulas.  Simply plug in your Income, Expenses, and a few Cash Flow items and let the template do the rest.  I hope you enjoy it as much as I am.  Always trying to make things simple, better, faster.  Build that system!

If you like it, and found it useful in any way, please vote on this post so that I know that another fellow BP member benefited from it.  

Thanks everyone, and  have a wonderful holiday weekend ahead!

All the best,

-Rick

Four Square Method of Analyzing Rental Properties

[Earl Co]

I made an auto-populating spreadsheet that I derived from the same four-square worksheet, and I'm happy to share it with the BiggerPockets community. I also wrote a program to automatically populate the spreadsheet with MLS listings from my agent. I'm leaving this here in case someone wants to adapt my version of the spreadsheet (supports multiple properties, one per row), as well as an automated, programmatic way of populating the spreadsheet given a paragonrels.com link from an agent/broker. Enjoy!

https://github.com/earlvanze/Paragon-MLS-API-Interface

The program now supports given only a list of MLS numbers and a System ID. If your region's MLS doesn't use Paragon's undocumented API, the code won't work without significant modifications to the get_properties() function. I am planning to have this code running on a website using Flask soon so I can access it while mobile, but it will still need to use the Paragon API which not every region uses.