Excel Property Analysis Calculator

[Nic LeTexier]

Hey there BP Community! 

As we all know from listening to the BiggerPockets podcast, we should be analyzing 10 properties a day! For us just starting out (like me) we can easily miss something or plug in some numbers that are way off. That's why I wanted to create a template to help me quickly run the numbers. I've analyzed some properties around my area, Seattle, as well as a few cities in the mid-west, each time I'm unable to find a deal (I'm looking on the MLS but still...) that meets the 1% rule or even has a respectable $100/mo cash flow.

It would be great to have someone look at it to help answer some questions:
Is my spreadsheet off? Do the numbers look right? Is the spreadsheet helpful?

If you'd like to have a link please send me an IM, any feedback is greatly appreciated. There are screenshots below. 

*I used Chapter 5 from The Book On Rental Property Investing for my numbers, specifically page 103 for the CapEx numbers.

Thank you!