Skip to content
×
Pro Members Get Full Access
Succeed in real estate investing with proven toolkits that have helped thousands of aspiring and existing investors achieve financial freedom.
$0 TODAY
$32.50/month, billed annually after your 7-day trial.
Cancel anytime
Find the right properties and ace your analysis
Market Finder with key investor metrics for all US markets, plus a list of recommended markets.
Deal Finder with investor-focused filters and notifications for new properties
Unlimited access to 9+ rental analysis calculators and rent estimator tools
Off-market deal finding software from Invelo ($638 value)
Supercharge your network
Pro profile badge
Pro exclusive community forums and threads
Build your landlord command center
All-in-one property management software from RentRedi ($240 value)
Portfolio monitoring and accounting from Stessa
Lawyer-approved lease agreement packages for all 50-states ($4,950 value) *annual subscribers only
Shortcut the learning curve
Live Q&A sessions with experts
Webinar replay archive
50% off investing courses ($290 value)
Already a Pro Member? Sign in here
Real Estate Deal Analysis & Advice

User Stats

13
Posts
6
Votes
Nic LeTexier
  • Bothell, WA
6
Votes |
13
Posts

Excel Property Analysis Calculator

Nic LeTexier
  • Bothell, WA
Posted Aug 27 2020, 16:26

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!

Loading replies...