Starting Out
Market News & Data
General Info
Real Estate Strategies
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_trust-2bcce80d03411a9e99a3cbcf4201c034562e18a3fc6eecd3fd22ecd5350c3aa5.avif)
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_1031_exchange-96bbcda3f8ad2d724c0ac759709c7e295979badd52e428240d6eaad5c8eff385.avif)
Real Estate Classifieds
Reviews & Feedback
Updated 12 months ago on . Most recent reply
![Nicholas R Paust's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/2025338/1621517586-avatar-nicholasr250.jpg?twic=v1/output=image/cover=128x128&v=2)
Rental calculator VS learning your market with a spreadsheet
I'm just wondering from seasoned investors on what's your go to method for analyzing a property. I'm currently looking for my second property and feel maybe I just got lucky on my first property since I didn't run any numbers. My first investment was a turn key property that cost $124,500 I put 20% down and rents for $1550. I see people talking about the 1% rule, as well as the bigger pockets calculator. I also listen to Mike Zuber author of one rental at a time talk about learning your market which is a course he has that includes a spreadsheet that tracks sales so you know what's a good/great deal in the area of the investment. Any thoughts on any of these or open to other suggestions. I'm trying to turn this into a business for something that I can do every day. Not just save up and do research when I have a down payment. THANKS
Most Popular Reply
![Ryan Chatman's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/1588273/1621513952-avatar-ryanc664.jpg?twic=v1/output=image/crop=1552x1552@0x0/cover=128x128&v=2)
@Nicholas R Paust Congrats on making it to the second deal!
My go to is this deal analysis spreadsheet; I've tweaked it to make it work for me:
Complete all of the Purple Boxes with your property's data and it will crunch the numbers. Looking at the Year 1 data is typically enough.
It also calculates Cap Rate, 1% Rule, and Cash on Cash return percentage
I think the 1% rule, CoC, Cap Rate, and some other metrics are fine for comparison sake but none are a one-size fits all.
I am by no-means seasoned, but I have done quite a bit of analysis on properties while searching.
I think the most important thing is analyze a deal with conservative estimates and see if those numbers align with your goals. Some investors look to make net profit of $100-$200 per door. For mine I wanted my per door net to be higher.