Real Estate Deal Analysis & Advice
Market News & Data
General Info
Real Estate Strategies
Short-Term & Vacation Rental Discussions
presented by
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/hospitable-deef083b895516ce26951b0ca48cf8f170861d742d4a4cb6cf5d19396b5eaac6.png)
Landlording & Rental Properties
Real Estate Professionals
Financial, Tax, & Legal
Tax, SDIRAs & Cost Segregation
presented by
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_trust-2bcce80d03411a9e99a3cbcf4201c034562e18a3fc6eecd3fd22ecd5350c3aa5.avif)
1031 Exchanges
presented by
![](http://bpimg.biggerpockets.com/assets/forums/sponsors/equity_1031_exchange-96bbcda3f8ad2d724c0ac759709c7e295979badd52e428240d6eaad5c8eff385.avif)
Real Estate Classifieds
Reviews & Feedback
Updated over 11 years ago, 03/30/2013
![Jeremy Wells's profile image](https://bpimg.biggerpockets.com/no_overlay/uploads/social_user/user_avatar/87648/1621416397-avatar-twotalents.jpg?twic=v1/output=image/cover=128x128&v=2)
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