WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 250+ Courses All In One Bundle
  • Login
Home » Financial Modeling Tutorials » Excel Modeling » CAGR Formula

CAGR Formula

Formula to Calculate CAGR (Compounded Annual Growth Rate)

CAGR (Compounded Annual Growth Rate) refers to the rate of return that is achieved by an investment by growing from its beginning value to its ending value, based on the assumption that the profits during the tenure of the investment were reinvested at the end of each year and it is calculated by dividing the value of the investment available at the period’s end by its beginning value and then raising the resultant to the exponent of the one divided by a number of the years and from further resultant subtract one.

CAGR Formula = [(Ending value / Beginning value) 1/No. of years – 1] * 100%

The formula can also be expressed by adding one to the absolute return on investment (ROI), then raise the result to the power of reciprocal of the tenure if investment and then finally subtract one.

CAGR = [(1 + Absolute ROI ) 1/No. of years – 1] * 100%

where Absolute ROI = (Ending value – Beginning value) / Beginning value

CAGR Formula

Calculation of CAGR (Step by Step)

The compounded annual growth rate can be calculated by using the following steps:

  • Step 1: Firstly, determine the beginning value of the investment or the money that was invested at the start of the investment tenure.
  • Step 2: Next, determine the final value of the investment at the end of the tenure of investment or the ending value.
  • Step 3: Next, determine the tenure of the investment, i.e., number years from the start of the investment to the end of the same.
  • Step 4: Next, divide the ending value of the investment by the beginning value and then raise the result to the power of reciprocal of the tenure of investment. Finally, subtract from the result and express in percentage terms to derive the compounded annual growth rate formula, as shown above.

Examples

You can download this CAGR Formula Excel Template here – CAGR Formula Excel Template

Example #1

Let us take an example of David, who invested $50,000 in a portfolio on Jan 1, 2015, and the following portfolio return has been outlined below: 

  • On Jan 1, 2016, the value of the portfolio stood at $60,000
  • On Jan 1, 2017, the value of the portfolio was $73,000
  • On Jan 1, 2018, the value of the portfolio was $70,000
  • On Jan 1, 2019, the value of the portfolio was $85,000

Based on the given, determine the yearly return and the CAGR for David’s investment portfolio.

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

Use the following data for the calculation of CAGR.

cagr formula example 1.1

Return for the 1st year

cagr formula example 1.2

  • Return for 1st year = [(Ending value / Beginning value) – 1] * 100%
  • = [($60,000 / $50,000) – 1] * 100%
  • = 20.00%

Return for 2nd year

cagr formula example 1.3

  • Return for 2nd year = [($73,000 / $60,000) – 1] * 100%
  • = 21.67%

Return for 3rd year

cagr formula example 1.4

  • Return for 3rd year = [($70,000 / $73,000) – 1] * 100%
  • = -4.11%

Return for 4th year

cagr formula example 1.5

  • Return for 4th year = [($85,000 / $70,000) – 1] * 100%
  • = 21.43%

Now, let us do the calculation of the CAGR in excel based on the given information,

cagr formula example 1.6

  • CAGR = [($85,000 / $50,000) 1/4 -1] * 100%

CAGR will be –

cagr formula example 1.7

  • CAGR = 14.19%

Therefore, the above example shows how CAGR encapsulates all the growth and de-growth during the investment period and provides an average annual growth rate during the investment tenure.

Example #2

Let us take an example of an equity portfolio that has value growth such that the absolute return over the period of five years stood at 57%. Do the calculation for the CAGR of the portfolio.

example 2.1

Therefore, the calculation of CAGR of the portfolio can be done as,

example 2.2

  • CAGR = [(1 + Absolute ROI) 1/ Number of years – 1] * 100%
  • = [(1 + 57%) 1/5 – 1] * 100%

CAGR will be –

example 2.3

  • CAGR = 9.44%

Therefore, the CAGR of the equity portfolio after five years stood at 9.44%.

CAGR Calculator

You can use the following CAGR Calculator.

Ending Value
Beginning Value
No. of Years
CAGR Formula =
 

CAGR Formula = [(Ending Value / Beginning Value)1/No. of Years- 1] * 100%
[(0 / 0)1/0-1] * 100% = 0

Uses of CAGR

It is important for the analyst to understand the concept of the compounded annual growth rate because it can be used to calculate the average growth of an investment. Under certain circumstances, the market becomes volatile, and as such, the year-to-year growth of an investment may appear uneven and erratic. In such a case, the CAGR helps in smoothening the erratic growth rates that are expected due to market volatility and inconsistency.

Another use of the CAGR equation is that it can be used for comparison of investments of different types. Nevertheless, the CAGR has its own drawback that by smoothening the erratic returns on investment, the CAGR conceals from the investor the fact of how risky or volatile the portfolio has been during its investment tenure. However, despite the drawback, the CAGR remains a very useful performance indicator for investors and analysts.

Recommended Articles

This article has been a guide to CAGR Formula. Here we learn how to calculate the compounded annual growth rate of the portfolio with examples and a downloadable excel template. You can learn more about financing from the following articles –

  • Return on Investment Formula
  • Formula of Effective Annual Rate
  • Calculation of Growth Rate
  • Formula to Calculate Interest Rate
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

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 CAGR Formula Excel Template

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More