![Nic LeTexier's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/1224440/1621510390-avatar-nletexier.jpg?twic=v1/output=image/crop=450x450@0x0/cover=128x128&v=2)
Excel Property Analysis Calculator
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!
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1598570773-Property_Analysis_Sheet_1.jpg)
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1598570773-Property_Analysis_Sheet_2.jpg)
![](https://assets0.biggerpockets.com/uploads/uploaded_images/normal_1598570774-Property_Analysis_Sheet.jpg)