Build a Better Process

# Geometric Return Definition and Tutorial

Deeply understanding the three methods of calculating return can be a career differentiator. In terms of difficulty, this one is right in the middle.
1. Define - Define geometric return of investments.
2. Calculation - See how it is calculated and interpreted.
3. Context - Use it in a sentence.
4. Video - See the video and transcript.
5. Quiz - Test your knowledge.
Updated: February 17, 2021
Geometric return takes compounding into consideration and that requires calculations using exponents. Keep reading.

/ factorpad.com / fin / glossary / geometric-return.html

## Understanding Geometric Returns

Beginner

Geometric Return is one of three methods for calculating return over multiple time periods. It is commonly used in backward-looking performance reviews because it takes compounding into consideration. There are two versions: 'total geometric return' and 'average geometric return'. This is time-certain, meaning, the order of returns does matter.

Synonyms: geometric mean, geometric average, compounded rate of return

For context, it is important to realize that the calculation of rate of return is more complex than it seems on the surface, particularly when you consider all corporate actions such as splits, special dividends and spin-offs. As a result most practitioners utilize data providers to make these calculations. This still doesn't absolve the financial modeler from understanding the distinctions and use cases of each calculation type.

### How it is Calculated

As an example, let's say an investment had a compounded return over two periods at 5% each period. The total geometric return formula in Excel would read `=((1+0.05)^2)-1` or 10.25%.

In math and statistics, a distinction is often made between discrete and continuous data. Log return is the more theoretical continuous version. In the practical world, however, most people think of returns broken into discrete periods instead.

• Arithmetic Return - One period, not-compounded, discrete.
• Geometric Return - Multi-period, compounded, discrete.
• Logarithmic Return - Infinite-periods, compounded, continuous.

So geometric returns is a compounded version where you add one to the return, take that to the power of the number of periods, then at the end subtract one. See below for the average geometric return.

Because it compounds returns over time it most resembles an investor's actual performance, so it is used in backward-looking performance contexts.

### In a Sentence

Leo:  Professor, I'm soooo looking forward to your lecture on geometric return.
Doc:  [silently] Hmm, class just started at 4:30. What was he doing 10 minutes ago?

### Video

This video can be accessed in a new window or App here , at the YouTube Channel or within this page below.

Geometric return definition for investment modeling (4:54)

### Video Script

The script includes two sections where we visualize and demonstrate the calculation of geometric return.

#### Visualize

We're sitting in Excel and this is a snippet from our boot camp course.

We'll simplify this to two-periods but it applies to 3, and beyond. Here we have two versions of geometric return.

The geometric total return, sometimes called geometric return, involves adding 1 to each return, mulitplying them together, then subtracing 1.

And for the average, often called the geometric mean, take that total to the power of one over the number of observations. That's what this caret symbol means, here we'd raise it to the 1/2 power. I put the total here in double parentheses because that's similar to the logic in Excel.

#### Demonstrate

Let's now demonstrate the 'total' and 'average' calculations using two hypothetical stocks, over three periods.

ABC had returns of 10%, followed by -11%, then another positive 10%. XYZ had returns of 100%, followed by -50%, then it was flat.

Total geometric return is calculated by adding 1 to each return. You could multiply them together manually, like this, and subtract one, or use the `=PRODUCT` function, with the range of returns in parentheses, minus 1.

We have observations here. And for the geometric average take that same product, raise it to the power of 1 over 3, then subtract 1, like this. Or you could use a cell reference to the cell containing the number of observations.

And to review, you would choose the geometric method for backward-looking perforamnce reviews because it measures the compounding of returns, and I put an example here showing the change in dollars, starting with \$1,000 so you can follow the logic. Notice this, and this.

The sentence earlier about time-certain is meaningful now. Let me show you why. Arithmetic returns, are more forward-looking, when you don't know the order of returns, unlike here. It is more reflective of the estimates for future periods. Take a moment to think about this.

Using the same data, but using arithmetic returns, look at the differences. 2.5% versus 3%, 0% versus 16.67%. To see why follow the link at the end.

### Quiz

Which return calculation method is best suited for forward-looking risk estimation. | Arithmetic or Geometric?

Arithmetic, because the order of returns doesn't matter.

Average arithmetic return is usually lower than average geometric return. | True or False?

False. Average geometric is lower because it compounds at a lower rate to get to the same place.

Still unclear on geometric return? Leave a question in the comments section on YouTube. Also, see a tutorial page and video on Stock return calculation methods from the Quant 101 Series on YouTube. There we go over when to use arithmetic, geometric and log returns.

### Related Terms

Our trained humans found other terms in the category return math you may find helpful.

## What's Next?

• To see all terms in the Glossary, click Outline.
• To learn about Fundamental Analysis, click Back.
• Support a coffee plantation in Costa Rica, click Tip.
• For an Excel tutorial on creating a Histogram, click Next.

/ factorpad.com / fin / glossary / geometric-return.html

geometric return
geometric mean
geometric average
backward-looking returns
investment performance
compounded return
time-certain return
stock performance
financial modeling
stock return tutorial
geometric average return
calculate geometric return
geometric mean return
financial performance
rate of return