Rental analysis spreadsheet - seeking feedback

[Brian Jolliffe]

I have been using a rental analysis spreadsheet I put together for awhile and I'd love for anyone to pick it apart to find flaws or suggest improvements. Green tab worksheets are the active input worksheets, yellow cells are user entry. The rest auto-calculate. The capex worksheet was from someone on here (sorry - can't remember who) and I added more logic to it.

https://drive.google.com/open?id=1g_k4hXi08_GE48vDMNh_xOU9eojwOvjx

[Robert Leonard]

@Brian Jolliffe Overall, I think it's a great spreadsheet. I did not go through every single cell, but I did spend some time looking at it. It looks like it covers all of the information an investor could want when analyzing a property/properties. 

However, it's a bit complex for me, personally. As I said, it's a great spreadsheet, but it seems like it would be quite time-consuming. In general, when I am analyzing deals, I want to do it quickly and get a general idea if the property is in the ballpark I need it to be to make an offer. Then, I can do deeper analysis if need be. I want to be able to analyze a property confidently in less than 5 minutes, and I don't think that would be possible with that spreadsheet. But, it all really depends on the individual doing the analysis.

I have a simpler spreadsheet I've created that I'd be happy to share with you if you'd like - just PM me your email and I'll send it over. Here is a screenshot of it: