What is Compounded Annual Growth Rate (CAGR)? Part I: Lump Sum Investing

At some point or another mutual fund or stock investors would have encountered the acronym, CAGR  - Compounded Annual Growth rate.

I would like to discuss what this stands for, its limitations and how to use it to interpret mutual fund or portfolio performance in a series of posts.

Imagine a fixed deposit that is subject to annual compounding at the rate of 10%. If I invest Rs. 100 in it, after one year I shall get 100 x (1+10%) = 110

After two years, 110 x (1+10%) = 100 x (1+10%)2 = 121

After three years, 100 x (1+10%)3 = 133.1

So we say the money compounds at the rate of 10%. Hence the compounded annual growth rate is 10%.

Compounded Annual Growth Rate
By John Sauter (Own work) [Public domain], via Wikimedia Commons
However, most fixed deposits do not compound in this simple fashion. They compound each quarter rather than each year.

That is , we will need to use 100 x(1+10%/4)^4 = 110.38 for a FD of one year and

100 x(1+10%/4)^8  = 121.84 for a FD of 2 years (8 quarters) and so on,

So after three years, we have 100 x(1+10%/4)^12 = 134.48.

Notice that that the corpus is a good Rs. 1 higher since the compounding frequency is higher.

Quarterly compounding is tough to understand and visualise. So I would like to know what is the rate at which the money compounds each year or, what is the CAGR?

I do not care about the frequency of actual compounding. I just need to know the CAGR. That is I am assuming that the investment compounds annually (note that this assumption is key to understanding CAGR)

To obtain the CAGR, I write

100 x (1+r)3 = 134.48

That is I would like to know what is rate of return which for annual compounding would give me a corpus identical to quarterly compounding. Thus r is the CAGR.

r = (134.48/100)(1/3) -1 = 10.38%

This extra 0.38% originates in the frequency of compounding - quarterly in this case.

Let us use this example to define the CAGR,

r =(maturity value/investment)^(1/years)-1

It is important to recognise that r will be negative if the maturity value is lower than the investment!

How does compounding work in a stock or mutual fund? This is the most popular question I have received by email!

The reason for this is simple enough to understand. Most people are fed on ‘power of compounding’ propaganda. They are told that if you start a SIP in an equity fund, you money will compound at the rate of 14%.

A couple of years later, they see their investments in the red and being to wonder what went wrong.

Soon enough they recognise that compounding can be quite confounding!

It sure can, and it sure is, if the rate of return fluctuates like in a mutual fund or stock (or bond if ... sold!)

So how does compounding work in a mutual fund or stock?

The simple and disappointing answer to this question is that mutual funds and stocks do not compound wealth!

The value of stocks and therefore the corresponding net asset value of (equity) mutual funds are influenced by a variety of logical and illogical factors : a scandal in a company, the taking over by a dynamic official or some good old profit booking. Just about anything that can affect the market will affect it sooner or later.

So there is no such thing as, you invest Rs. 100, and after an year I pay you interest.  The next year I pay you interest on the investment plus the first year’s interest.

Stocks/mutual funds simply do not work that way.

If the rate of return is fixed, the concept of a CAGR is useless.  I can take the relevant compounding formula (check out some of them in my fixed deposit calculators) and calculate the maturity value. That is good old compounding.

When something does not compound, it is hard for me to make sense out of it.

Therefore, I choose to determine the net return assuming that mutual fund or stock behaves like instruments that compounds annually!

The above statement is the key-takeaway from this post. Allow me re-state it:

I try to make sense of a stock/mutual funds performance by pretending that is compounds annually!

We pretend that

r =(maturity value/investment)^(1/years)-1

holds true for all instrument whether the interest rate is fixed or not. There is no justification for this choice. We try this out and see how it goes. Since the going is not terrible, we stick with it!

If I speak like that in a physics class, students accuse me of being unromantic! Perhaps so but that is the way math and science works: Assume and check how it fares!

So if I make a lump sum investment in a stock to determine CAGR, all I need to do is to use the above formula.

Since CAGR is the ‘average’ rate at which the investment has compounded (positively or negatively!) per year.

  • It is the annual ‘average’ growth rate, it makes sense only for periods above 1 year – that is, since the instrument is volatile, the period should be reasonably long enough  so that a long term trend can be inferred.
  • The ‘average’ here is a geometric average and not an arithmetic average.

To understand this idea, consider our fixed deposit offering annual offering 10% per annum.

After 3 years the maturity amount is given by

100 x (1+ 10%) x (1+10%) x (1 +10%) = 100 x (1+10%)3 = 100 x (1+r)3

Therefore I write,

 (1+r)3 =(1+ 10%) x (1+10%) x (1 +10%)

r = [(1+ 10%) x (1+10%) x (1 +10%)]^(1/3)  -1

This is known as the geometric average. Of course r  is the CAGR. So,

r =(maturity value/investment)^(1/years)-1

is still valid. Notice the similarity in structure between the two definitions.

I now define CAGR as

r = [(1+ r1) x (1+r2) x (1 +r3) …. x (1+rn)]^(1/years)  -1 = (maturity value/investment)^(1/years)-1

Here r1, r2, r3,… rn are the rates of annual interest.

For a fixed deposit, this formula is an over-kill since r1 = r2 =r3, …, = rn (= 10% for the above example).

However for a stock or a mutual funds the annual interest can be very different! For a detailed analysis of annual stock market returns, see this:Understanding the Nature of Stock Market Returns

Therefore, for a lump sum investment made in a stock or a mutual fund 3 years ago, there two ways in which I can calculate CAGR.

1. Simply note the value as on date (say after 3 years).

r =( value today /investment)^(1/3)-1

2. I tabulate the annual returns  (365 days from the date of investment).

r1 = return after one year (from date of investment = +10%

r2 = return after two years = -25%

r3 = return after three years = +3%

value today = Investment x (1+ 10%) x (1-25%) x (1 +3%) = Investment x (1+ r)3

The CAGR, r = [(1+ 10%) x (1-25%) x (1 +3%)]^(1/3) -1

To summarise,  CAGR is the average annual growth rate of an instrument assuming annual compounding.

The CAGR completely washes out the intermediate volatility. It is just worried about the end points – the investment and final value.

The stock could have increased steadily in this period or could have see-sawed several times in this period. The CAGR completely ignores this.

So CAGR by itself does not tell you the complete picture. You will need to worry about the standard deviation. That is the average deviation from the arithmetic mean ( [r1 +r2 +r3]/3).

Excuse me for suddenly dropping the arithmetic mean from nowhere! Unfrotunately that is how it works. I will be happy to explain as to why this is necessary, if you leave a comment

The standard deviation of a mutual fund is the single most important parameter that investor should worry about.  Read more: How to select mutual fund categories suitable for your financial goals?

What about a SIP? How does CAGR work then? 

To be continued ....

Feel free to share your views on this post. 

If you are familiar with the CAGR, check this out, Visualizing Mutual Fund Volatility Measures

Install Financial Freedom App! (Google Play Store)

Install Freefincal Retirement Planner App! (Google Play Store)

book-footer

Buy our New Book!

You Can Be Rich With Goal-based Investing A book by  P V Subramanyam (subramoney.com) & M Pattabiraman. Hard bound. Price: Rs. 399/- and Kindle Rs. 349/-. Read more about the book and pre-order now!
Practical advice + calculators for you to develop personalised investment solutions

Thank you for reading. You may also like

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete  the entire comment or remove the links before approving them.

29 thoughts on “What is Compounded Annual Growth Rate (CAGR)? Part I: Lump Sum Investing

  1. Srini

    Dear Pattu, for a Lay Man (like me) instead of using r1, r2 etc it will be good if you can use real examples like someone invested so much and their cagr return is so much etc. This way it will be easy to correlate. By mutual funds here u mean only equity funds i suppose. Can u also throw across the difference between interest/dividend paid and accumulation?

    Reply
    1. pattu

      Thank you very much. I have implemented your suggestion in the post. I will be using more examples in the following parts as they are impossible to handle otherwise. I will also cover dividend and growth options later.

      Reply
  2. Srini

    Dear Pattu, for a Lay Man (like me) instead of using r1, r2 etc it will be good if you can use real examples like someone invested so much and their cagr return is so much etc. This way it will be easy to correlate. By mutual funds here u mean only equity funds i suppose. Can u also throw across the difference between interest/dividend paid and accumulation?

    Reply
    1. pattu

      Thank you very much. I have implemented your suggestion in the post. I will be using more examples in the following parts as they are impossible to handle otherwise. I will also cover dividend and growth options later.

      Reply
  3. Ashal Jauhari

    Eagerly waiting part 2 of this sereis. it looks like a mouth watering dish to my brain. thanks for posting such thing.

    Thanks

    Ashal

    Reply
  4. Ashal Jauhari

    Eagerly waiting part 2 of this sereis. it looks like a mouth watering dish to my brain. thanks for posting such thing.

    Thanks

    Ashal

    Reply
  5. Zahiruddin Babar

    Good article, but the challenge is to calculate CAGR in mutual fund when your fund have dividend reinvestment option and switch in & switch out is frequent. i have and example of the same in excel, if you want i can send it on your email.

    Reply
  6. Zahiruddin Babar

    Good article, but the challenge is to calculate CAGR in mutual fund when your fund have dividend reinvestment option and switch in & switch out is frequent. i have and example of the same in excel, if you want i can send it on your email.

    Reply
  7. Aparna CK

    What happens when frequency of compounding is not annual, not quarterly but very very small, tending to zero? I am sure Pattu must've worked it out. Just commenting here because the answer to this question is very exciting. 🙂

    Reply
  8. Aparna CK

    What happens when frequency of compounding is not annual, not quarterly but very very small, tending to zero? I am sure Pattu must've worked it out. Just commenting here because the answer to this question is very exciting. 🙂

    Reply
  9. Aparna CK

    What happens when frequency of compounding is not annual, not quarterly but very very small, tending to zero? I am sure Pattu must've worked it out. Just commenting here because the answer to this question is very exciting. 🙂

    Reply
  10. Aparna CK

    Dear Ashal,
    I don't think my comment was interpreted correctly by you and Pattu. My question is purely academical. I want at a frequency such that gap between compounding tends to zero. Answer is a very familiar number. I had worked this out long ago. Want to give it a try?
    Pattu,
    I will be surprised if you haven't don't this exercise already. Yes, it doesn't increase proportionally, precisely because of this '.....'
    Regards
    Aparna

    Reply
    1. pattu

      Yes I understood that it is academic. For continuous compounding, (1+r/k)^k = exp(r) when k the duration, goes to infinity.

      Reply
    2. ashalanshu

      Dear Aparna, I got your message at the first place. that's why put the lighter note comment. Hope after Pattu's equation, the answer is there with you.I'm sorry if I hurt you.

      Thanks

      Ashal

      Reply
  11. Aparna CK

    Dear Ashal,
    I don't think my comment was interpreted correctly by you and Pattu. My question is purely academical. I want at a frequency such that gap between compounding tends to zero. Answer is a very familiar number. I had worked this out long ago. Want to give it a try?
    Pattu,
    I will be surprised if you haven't don't this exercise already. Yes, it doesn't increase proportionally, precisely because of this '.....'
    Regards
    Aparna

    Reply
    1. pattu

      Yes I understood that it is academic. For continuous compounding, (1+r/k)^k = exp(r) when k the duration, goes to infinity.

      Reply
    2. ashalanshu

      Dear Aparna, I got your message at the first place. that's why put the lighter note comment. Hope after Pattu's equation, the answer is there with you.I'm sorry if I hurt you.

      Thanks

      Ashal

      Reply

Do let us know what you think about the article