Skip to content
×
Pro Members Get
Full Access!
Get off the sidelines and take action in real estate investing with BiggerPockets Pro. Our comprehensive suite of tools and resources minimize mistakes, support informed decisions, and propel you to success.
Advanced networking features
Market and Deal Finder tools
Property analysis calculators
Landlord Command Center
ANNUAL Save 54%
$32.50 /mo
$390 billed annualy
MONTHLY
$69 /mo
billed monthly
7 day free trial. Cancel anytime
×
Take Your Forum Experience
to the Next Level
Create a free account and join over 3 million investors sharing
their journeys and helping each other succeed.
Use your real name
By signing up, you indicate that you agree to the BiggerPockets Terms & Conditions.
Already a member?  Login here
Buying & Selling Real Estate
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 13 years ago on . Most recent reply

User Stats

488
Posts
121
Votes
Danny Day
  • Rental Property Investor
  • Houston, TX
121
Votes |
488
Posts

Analyzing the buy

Danny Day
  • Rental Property Investor
  • Houston, TX
Posted

How do you analyze the purchase on your property?

How do you compare the one your looking at vs others?

The way I've been finding properties is I first search the MLS for discounted / distressed homes (corporate listing, foreclosure, or short sale). I gather the info and put into a spreadsheet (neighborhood, bed, bath, list price, list date, year built, zip code, and if its bank owned / short sale, etc).

I have a column that has the formula =Today() and then the Days on Market column will subtract todays date from list date, giving me the accurate days on market (matches the mls!).

But more importantly, I run comps on each one and put an ARV column next to the list price column. I can subtract ARV from List Price and have equity capture, or I can divide list price by ARV and have a list price to ARV percentage.

Of course once I do that, I can repsectively filter / sort the highest to lowest, instantlly giving me the best deal by the "numbers".

The one problem this leads too is it does not factor in repairs. I have a MAX OFFER column that uses the formula =SUM(B2*0.7)-G2, in which B2 is the ARV and G2 is the REPAIRS column.

Any others tracking this data like this? Its working out well for me.

Danny

Loading replies...