Start investing in Hidden Gems and Value Picks to create wealth in long term. Click here for details.

MULTIBAGGER SMALL / MID CAPS & LONG TERM INVESTING REPORT >>>  FREE DOWNLOAD

TECHNO-FUNDA (POTENTIAL MULTIBAGGER) STOCK 2019 REPORT >>>  FREE DOWNLOAD

PAST PERFORMANCE >>> HIDDEN GEMS, VALUE PICKS & WEALTH-BUILDER >>>  VIEW / DOWNLOAD

SERVICES:        HIDDEN GEMS    |    VALUE PICKS    |    15% @ 90 DAYS    |    WEALTH-BUILDER

SUBSCRIPTION:        FREE SUBSCRIPTION      |      PAID SUBSCRIPTION     |      PAYMENT OPTIONS

Wednesday, February 21, 2018

How to Calculate CAGR of your Investments?

This article will let you know how to calculate the compound annual growth rate, or CAGR, in Excel. You’ll also learn about some of the limitations.

Different investments go up or down in value by different amounts over different time periods. Investors need a method of comparing one investment against another, especially if the returns have been volatile, or if investments and withdrawals are at irregular dates.

CAGR is the annual return of an investment assuming it has grown at the same rate every year. It’s a common concept; for example, the one, three and five-year returns on mutual fund fact sheets are CAGR values.

One method of calculating CAGR is given by this equation.

 There are three parameters in this equation.
  • start value of the investment
  • end value of the investment
  • number of years between the start and end value
You can also manipulate this formula to give, for example, the number of years required to grow an initial investment from a start value to an end value, given the growth rate..

Below tables use the above formulas to calculate CAGR.


You can also rearranges the formula so you can calculate the final amount (given the initial amount, CAGR, and number of years) and the number of years (given the initial and final amount, and CAGR).

You can also calculate the Compound Annual Growth Rate using Excel’s XIRR function – check out the screen below for an example.
 

XIRR takes three arguments:
  • The first is a range of cash flows into or out of the investment. Invested amounts are positive, but withdrawals are negative.
  • The second is a range of dates corresponding to the investments or withdrawals,
  • The third is a guess value for the CAGR (XIRR uses Newton-Raphson iteration, so it needs a guess value tostart the iteration).
XIRR is flexible, and can also given you the CAGR given investments and withdrawals at irregular dates. As an example, examine the screengrab of the Excel spreadsheet.

CAGR has some limitations that investors need to be aware of:
  • CAGR hides volatility by assuming that investments grow at a constant rate. Volatility is an important factor in managing investment risk and can’t be ignored.
  • It’s based on historical data, and can’t be relied on as the only method of predicting future value.
  • CAGR can be manipulated by picking the time period over which it is measured. An unscrupulous fund manager can, for example, choose a start date with an unusually low investment value.
You can download our excel file which contains examples demonstrated in this article. 

CAGR Calculator excel file - Download

Note: You’ll need to enable the Analysis Toolpack to use the XIRR function.
Become a Smart Investor in 2 Minutes!
Sign Up for FREE Articles providing Insight to Equity Market

What is ASBA & how ASBA process works?  You can subscribe to Saral Gyan to  receive regular updates, stock tips &  stock market news.

 Subscribe by email by providing your  email below and all updates will direct  to your inbox:


Rss Feed Saral Gyan Rss Twitter Feed rss feed Twitter Facebook Google

Saral Gyan Annual Subscription Services

Unexplored Multibagger Small Cap Stocks
Hidden Gems:  Indepth & unbiased research reports of unexplored multibagger micro & small companies in terms of market capital. Read More >>> Click Here!

Mid Caps with Plenty of Upside Potential
Value Picks:  Research reports of mid cap companies which offers value with plenty of upside potential in medium to long term. Read More >>> Click Here!

Buy to Sell Stocks for Short Term Gains
15% @ 90 Days:  Stock recommendation for short term profits based on buy to sell & gain strategy. Read More >>> Click Here!

Long Term Wealth Creation Portfolio
Wealth-Builder:  An offline portfolio management service to create wealth by investing in fundamentally strong small and mid cap stocks. Read More >>> Click Here!