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.
General Real Estate Investing
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 13 years ago,

User Stats

8,794
Posts
4,382
Votes
Bryan Hancock#4 Off Topic Contributor
  • Investor
  • Round Rock, TX
4,382
Votes |
8,794
Posts

The Case For A Geometric Mean For Quoting Returns

Bryan Hancock#4 Off Topic Contributor
  • Investor
  • Round Rock, TX
Posted

Return citations were getting thrown around on another thread a few weeks ago so I took the liberty of dusting off some old finance texts where people try to get quite specific about citing returns. The case is made frequently for using a geometric mean instead of an arithmetic mean. There are also frequently negative returns with large enough samples so people like to add one to each of the observations and subtract one from the output of the geometric mean using these observations to arrive at a return metric.

So in other words you would use:

=GEOMEAN(Range_of_Percentages + 1) - 1

This mean is always equal to or smaller than the arithmetic mean that most people use to cite returns over a period of years. Presumably this is why it is not used even though it is more accurate.

Does anyone use this when they analyze their portfolio's returns? If so, do you use the percentages annually or make it more granular? Are there any problems you see with using geometric mean instead of arithmetic mean other than the greater difficultly in arriving at the figure?

Loading replies...