WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » Geometric Mean Return

Geometric Mean Return

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is the Geometric Mean Return?

The geometric mean return calculates the average return for the investments which are compounded on the basis of its frequency depending on the time period and it is used to analyze the performance of investment as it indicates the return from an investment.

Geometric Mean Return Formula

Geometric-Mean-Return-Formula

  • r = rate of return
  • n = number of periods

It is the average set of products technically defined as the ‘n’ th root products of the expected number of periods. The focus of the calculation is to present an ‘apple to apple comparison’ when looking at 2 similar kinds of investment options.

Examples

Let us understand the formula with the help of an example:

You can download this Geometric Mean Return Excel Template here – Geometric Mean Return Excel Template

Assuming the return from $1,000 in a money market that earns 10% in the first year, 6% in the second year, and 5% in the third year, the Geometric mean return will be:

Geometric Mean Return Formula Example

This is the average return taking into consideration the compounding effect. If it had been a Simple average return, it would have taken the summation of the given interest rates and divided it by 3.

Thus to arrive at the value of $1,000 after 3 years, the return will be taken at 6.98% every year.

Year 1

  • Interest = $1,000 * 6.98% = $69.80
  • Principal = $1,000 + $69.80 = $1,069.80

Year 2

  • Interest = $1,069.80 * 6.98% = $74.67
  • Principal = $1,069.80 + $74.67 = $1,144.47

Year 3

  • Interest = $1,144.47 * 6.98% = $79.88
  • Principal = $1,144.47 + $79.88 = $1,224.35
  • Thus, the final amount after 3 years will be $1,224.35, which will be equal to compounding the principal amount using the three individual interests compounded on a yearly basis.

Let us consider another instance for comparison:

An investor is holding a stock which has been volatile with returns significantly varying from one year to another. The initial investment was $100 in stock A, and it returned the following:

Popular Course in this category
Sale
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
4.9 (1,067 ratings)
250+ Courses | 40+ Projects | 1000+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Year 1:  15%

Year 2: 160%

Year 3:  -30%

Year 4: 20%

  • The Arithmetic mean will be = [15 + 160 – 30 + 20] / 4 = 165/4 = 41.25%

However, the true return will be:

  • Year 1 = $100 * 15%   [1.15] = $15 = 100+15 = $115
  • Year 2 = $115 * 160%   [2.60] = $184 = 115+184 = $299
  • Year 3 = $299 * -30%   [0.70] = $89.70 = 299 – 89.70 = $209.30
  • Year 4 = $209.30 * 20% [1.20] = $41.86 = 209.30 + 41.86 = $251.16

The resultant geometric mean, in this case, will be 25.90%. This is much lower than the Arithmetic mean of 41.25%

The issue with Arithmetic mean is that it tends to overstate the actual average return by a significant amount. In the above example, it was observed that in the second xyear the returns had risen by 160% and then fell by 30% which is year over year variance by 190%.

Thus, Arithmetic mean is easy to use and calculate and can be useful when trying to find the average for various components. However, it is an inappropriate metric to use for determining the actual average return on investment. The geometric mean is highly useful for measuring the performance of a portfolio.

Uses

The uses and benefits of the Geometric Mean Return formula are:

  1. This return is specifically used for investments that are compounded. A simple interest account will make use of the Arithmetic average for simplification.
  2. It can be used for breaking down the effective rate per holding period return.
  3. It is used for Present value and future value cash flow formulas.

Geometric Mean Return Calculator

You can use the following Calculator.

r1  (%)
r2  (%)
r3  (%)
Geometric Mean Return Formula =
 

Geometric Mean Return Formula = 3√(1 + r1) * (1 + r2) * (1 + r3) − 1 =
3√(1 + 0) * (1 + 0) * (1 + 0) − 1 = 0

Geometric Mean Return Formula in Excel (with excel template)

Let us now do the same example above in Excel. This is very simple. You need to provide the two inputs of Rate of Numbers and Number of Periods.

You can easily calculate the Geometric Mean in the template provided.

Geometric Mean Return Example 1

Thus to arrive at the value of $1,000 after 3 years, the return will be taken at 6.98% every year.

Geometric Mean Return Example 1.1

Thus, the final amount after 3 years will be $1,224.35, which will be equal to compounding the principal amount using the 3 individual interests compounded on a yearly basis.

Let us consider another instance for comparison:

Geometric Mean Return Example 2

However, the true return will be:

Geometric Mean Return Example 2.1

The resultant geometric mean, in this case, will be 25.90%. This is much lower than the Arithmetic mean of 41.25%

Recommended Articles

This article has been a guide to Geometric Mean and its definition. Here we discuss the formula of Geometric Mean Return along with examples and excel templates. You may also have a look at these articles below to learn more about Corporate Finance.

  • Compare – Geometric Mean vs. Arithmetic Mean
  • Harmonic Mean Example
  • Population Mean Formula – Examples
  • Weighted Mean Formula
0 Shares
Share
Tweet
Share
All in One Financial Analyst Bundle (250+ Courses, 40+ Projects)
  • 250+ Courses
  • 40+ Projects
  • 1000+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Download Coursera IPO Financial Model

By continuing above step, you agree to our Terms of Use and Privacy Policy.
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
WallStreetMojo

Free Investment Banking Course

IB Excel Templates, Accounting, Valuation, Financial Modeling, Video Tutorials

* Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Login

Forgot Password?

WallStreetMojo

Download Geometric Mean Return Excel Template

Coursera IPO Financial Model & Valuation Free Download