Skip to content
×
Try PRO Free Today!
BiggerPockets Pro offers you a comprehensive suite of tools and resources
Market and Deal Finder Tools
Deal Analysis Calculators
Property Management Software
Exclusive discounts to Home Depot, RentRedi, and more
$0
7 days free
$828/yr or $69/mo when billed monthly.
$390/yr or $32.5/mo when billed annually.
7 days free. Cancel anytime.
Already a Pro Member? Sign in here

Join Over 3 Million Real Estate Investors

Create a free BiggerPockets account to comment, participate, and connect with over 3 million real estate investors.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
The community here is like my own little personal real estate army that I can depend upon to help me through ANY problems I come across.
Starting Out
All Forum Categories
Followed Discussions
Followed Categories
Followed People
Followed Locations
Market News & Data
General Info
Real Estate Strategies
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Real Estate Classifieds
Reviews & Feedback

Updated over 3 years ago on . Most recent reply

User Stats

84
Posts
50
Votes
Sam Fickel
  • Lender
  • Pasco, WA
50
Votes |
84
Posts

Running numbers before paying

Sam Fickel
  • Lender
  • Pasco, WA
Posted

Apparently, I've used the BP calculators too many times in the past and can't use them anymore. I'm really just trying to play with numbers and get some reps in to learn how to analyze properties for when I'm ready to pull the trigger on REI. I don't want to run in blindly.

If I was regularly analyzing properties to seriously consider purchasing them, then by all means, I see how it pays for itself. But I'm just trying to figure out how different factors play into each other and how to come up with common metrics, and learning what to look for to determine what a "good deal" means to me.

Anyone have a spreadsheet they'd be willing to share?

Most Popular Reply

User Stats

129
Posts
126
Votes
Ryan Chatman
  • Investor
  • Lehigh Valley, PA
126
Votes |
129
Posts
Ryan Chatman
  • Investor
  • Lehigh Valley, PA
Replied

@Sam Fickel sharing my spreadsheet for everyone:

https://bit.ly/3EAhMm8

Fill in the purple boxes across the top. Then purple boxes in the other sections below. If single family be sure to set the number of units to 1. It is defaulted at 2 units. Works best by downloading a copy and using in excel

It also calculates cap rate, 1% rule, and cash on cash

Loading replies...