Analysis of all MLS properties in PG County

[Ari Bachrach]

I've put together a spreadsheet of every property currently available on the MLS for PG county along with it's estimated rent (from zillow), taxes (from SDAT), and then the calculated expenses, income, net cash flow, and cap rate. If you want to see it, I've shared it here:

https://docs.google.com/spreadsheets/d/1ZCyGxTIO-r...

Note that there are some variables you can modify on the second tab to see how they effect your calculated cash flow and cap rates. Just copy the sheet to your own account and then you can modify it.

* Interest rate (default is 5%, but you can change it. For the moment everything assumes 100% financing)

* Repairs (default is $2000)

* Vacancy (default is 10%)

I also make sure to include HOAs, management fees (which vary based on property type), and insurance (which also vary based on property type, and are just estimates).

The list is up to date as of this evening (June 6th), but it's static so it won't be updated unless I update it. If people find this useful or interesting I could potentially set up something automated to keep it updated.