Real Estate Deal Analysis & Advice
Market News & Data
General Info
Real Estate Strategies
Short-Term & Vacation Rental Discussions
presented by
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Tax, SDIRAs & Cost Segregation
presented by
1031 Exchanges
presented by
Real Estate Classifieds
Reviews & Feedback
Updated almost 12 years ago, 03/30/2013
Estimate Home Values to within $34.00!
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