Skip to content
×
PRO
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
$0
TODAY
$69.00/month when billed monthly.
$32.50/month when billed annually.
7 day free trial. 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.
Real Estate Deal Analysis & Advice
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 almost 12 years ago, 03/30/2013

User Stats

10
Posts
1
Votes
Jeremy Wells
  • Contractor
  • Alamosa, CO
1
Votes |
10
Posts

Estimate Home Values to within $34.00!

Jeremy Wells
  • Contractor
  • Alamosa, CO
Posted

I just put together this spreadsheet for using comps to estimate the value of a potential property.

Have you ever wasted time trying to play around with adjustment amounts to get your comps to all end up around the same adjusted price?

This spreadsheet uses a macro-enabled iteration that changes the adjustment amounts incrementally to minimize the standard deviation among the adjusted comp prices. I've only tried it on one property. Please, try it out and let me know if it works for you!

You can access the spreadsheet using the link below. If you get a yellow bar in Excel when you open it, you must enable macros to use it.

http://www.biggerpockets.com/files/user/twotalents/file/compcalc-10

~Jeremy

Loading replies...