Skip to content

Visualising The Annualized Return and Volatility

I discuss ways in which we can visualise and interpret the annualised return, also known as the compounded annualised growth rate or the CAGR and volatility of returns. Franklin India Prima Fund had a NAV of 201.75 on April 3rd, 2006 and a NAV of 878.5 on 12th April 2017. What is the annualised return?

To compute this, we first realise 11 years is the intervening time period - 11.033 to be precise. The annualized return is given by,

878.5 = 201.75 x (1+ CAGR)^11.033

CAGR = (878.5/201.75)^(1/11.033)-1 = 14.26%.

Here ^ refers to "the power of" ( eg. 2^4 = 2 x 2 x 2 x 2)

This means that if we treat the mutual fund investment as a fixed income instrument providing annual interest on the account balance then the annual interest is 14.26%.

Of course, any market-related instrument does not provide interest or compound. It grows up or down in value. We make this kind of calculation to compare the "growth" with a risk-free instrument (that does compound) to ascertain the risk premium.

Now, suppose we decide to simulate the NAV growth from April 2006 to 2017, with only the above-mentioned information, then we will have to assume that the NAV grows by the same amount every day, and there are 2709 business days.

So we have,

NAV on April 12th 2017 = (NAV on April 3rd 2006) x (1+R)^2709

R = daily growth rate (I don't want to call it interest rate!)

R = 0.054%.

This is how it will pan out.

Naturally, this is nonsense. The actual NAV movement is shown below.

The point of this exercise is to illustrate how the annualised return calculation sweeps the NAV ups and downs under the carpet and focusses only on the initial NAV and final NAV. There are literally millions of smooth curves that I can draw between the end points and what is shown above is just one.

When you buy something from Amazon, you don't care whether the delivery guy braved the hot sun or floods. All you care about is the condition of the package.  You ordered something at a price and you got it in one piece - only the start and end points matter.

When you buy anything that is market-linked, you are not the end-user. You are in charge of the delivery department. You need to deliver your own net worth to where it needs to be. Therefore, the route matters. In other words, the ups and downs matter - not just the end result which is unpredictable. The volatility associated with a return matters.

Suppose we assume each month has about 21 business days and computed the "monthly" returns from April 2006 to April 2017, we would get 129 months.

This is an absolute view of the volatility. When we invest in equity, it is better to temper ourselves that -20% monthly returns are more than possible. When such returns occur will decide the wealth we create - early, middle or later in the investment schedule. More on that later.

Problems arise when we start to replace this view with a single number.  If we bin the returns into compartments, this is what we get.

This is anything but a bell curve or a normal distribution. Therefore the idea of an "average" monthly return is not valid. And by extension, the "average" deviation from the "average return", also known as the standard deviation is also invalid. The standard deviation is the "industry standard" representation of volatility and it is wrong.

IF we assume that NAV grows by the same amount each month, then 

final NAV = initial NAV x (1+monthly_return)^129

monthy_return ~ 1.15%

Instead of the standard deviation, a simpler way to depict volatility is to define it as:

No of negative monthly returns/Total monthly returns

For the present case, this is 45/129 ~ 35%.

This gives me an idea of what to expect from this fund (or this category of funds) over the next 10 years: Expect NAV to fall for at least 1/3 rd of the months invested. Now let us try selling mutual funds with statistic!

=-=-=-=-=-=-=

Kolkata DIY Investor Workshop May 28th, 2017

Register for the Kolkata DIY Investor Workshop May 28th, 2017

You Can Be Rich Too With Goal-Based Investing

You can be rich too with goal based investing is my new book with PV Subramanyam. If you have not yet got the book, check out the reviews below and use the links to buy.

Reader Quotes:

Gift it to your Friends and Relatives whom you care more. Already follower of Pattu and Subra's forum. Ordered 4 more copies to give gift to my friends and eagerly waiting to read

The best book ever on Financial Freedom Planning. Go get it now!

Your first investment should be buying this book

The (nine online) calculators are really awesome and will give you all possible insights

Thank you, readers, for your generous support and patronage.

Amazon Hardcover Rs. 317. 21% OFF

Kindle at Amazon.in (Rs. 307)

Google
Infibeam Now just Rs. 307 24% OFF.

If you use a mobikwik wallet, and purchase via infibeam, you can get up to 100% cashback!!

Bookadda Rs. 344. Flipkart Rs. 359

Amazon.com ($ 3.70 or Rs. 267)

Google Play Store (Rs. 244.30)

  • Ask the right questions about money
  • get simple solutions
  • Define your goals clearly with worksheets
  • Calculate the correct asset allocation for each goal.
  • Find out how much insurance cover you need, and how much you need to invest with nine online calculator modules
  • Learn to choose mutual funds qualitatively and quantitatively.

More information is available here: A Beginner's Guide To Make Your Money Dreams Come True!

What Readers Say


Free Apps for your Android Phone

Install Financial Freedom App! (Google Play Store)


Install Freefincal Retirement Planner App! (Google Play Store)


Find out if you have enough to say "FU" to your employer (Google Play Store)


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.

4 thoughts on “Visualising The Annualized Return and Volatility

  1. Sorabh

    "This gives me an idea of what to expect from this fund (or this category of funds) over the next 10 years: Expect NAV to fall for at least 1/3 rd of the months invested. Now let us try selling mutual funds with statistic!"

    doesnt this mean you are suggesting "past performance will be indicative of future perfomance" 🙂

    it can be 35 or 15 or even 65 .. no one can say for sure.....

    also the period matters.... would you get 35% if you took it between 2006 and 2013 ? ....

    you wouldnt is my guess ... for the same reason it wont happen in future too...

    Reply
    1. freefincal

      I am saying that past risk is the indicator of minimum future risk. Yes period and durations matter and can one can easily do this over rolling durations.

      Reply
  2. sorabh

    Ok i understand but still i feel just like we cannot predict mininum future performance in the same vien we cannot comment on minimum future risk as well based on past risk... but thanks for this insight ...

    Reply

Do let us know what you think about the article

%d bloggers like this: