Money Excel - Personal Finance Blog

Menu
MENUMENU
MENUMENU
  • Home
  • Business Ideas
    • 225 Small Business Ideas
    • 40 Online Business Ideas
    • 20 Business Ideas for Beginners
    • 20 small manufacturing business
    • 30 Food Business Ideas
    • 100 Business Ideas low investment
  • Stock Market
    • Best Demat & Trading Accounts 2020
    • Best Stocks 2020 by Experts
    • Best Virtual Trading Apps
    • Best Stock Screener
    • Best Discount Brokers in India
    • Multibagger Stocks of LockDown
    • Rakesh Jhunjhunwala Portfolio
  • Mutual Funds
    • Best Mutual Funds 2020-21
    • Best Direct Mutual Fund Platform
    • Best Mutual Fund Mobile Apps
  • Incometax
    • Income Tax Slab FY 2020-21
    • Income Tax Calculator FY 2020-21
    • Income Tax Refund Request
    • Pay Advance Tax Online
    • Download New 15G -15 H Forms
  • Investment
    • Best Investment Ideas 2020
    • Long Term Investment Options
    • Best Investment Regular Income
    • Best Investment Options NRI
  • Credit Card
    • Best Credit Cards 2020-21
    • Best credit card for online shopping
    • Best Forex Card in India
    • Best Business Credit Cards
    • Credit Cards against Fixed Deposit
  • Insurance
    • Best Term Insurance Plans 2020
    • Best Health Insurance 2020
    • Best LIC Policy 2020
    • Best Car Insurance Companies
    • Best Mobile Insurance Companies
  • Downloads
Home
Investment
Calculating Returns of Investment – Formulas & Examples – 1

Calculating Returns of Investment – Formulas & Examples – 1

Raviraj Parekh August 2, 2020

investment retruns

We invest our money in various asset classes to earn returns. But most of us don’t know correct way to calculate returns. For example

  • Mr. Anil invested Rs 20,000 in a mutual fund and 2 years of holding it became Rs 40,000
  • Mr. Sunil invested Rs 50,000 in Gold for 6 years and it became Rs 4,00,000

Who has earned better returns? & what method we should use to calculate returns so that we do not end up comparing apple to oranges! We are herewith article showing correct ways to compare returns with formulas and examples.

Also Read – Home Loan EMI Calculator Prepayment and Closure

What is Return on Investment?

Return is the gain or loss in the value of an asset in a particular period. It is usually mentioned as a percentage.  The general rule is that the more risk you take, the greater the potential for higher return and loss. Return on investment has two basic components.

Do not miss below posts -
  • HDFC Double Money & Money Multiplier Review
  • Saving for Child education is not child’s play
  • eNPS – How to Open NPS account online and contribute …
  • Interest and/or dividends, the income generated by the underlying investment.
  • Appreciation (Depreciation), an increase (decrease) in the value of the investment.

Why finding return on investment is important:-

  • Determining return on investment is an important part of investment review to know      whether your investments are on track and make appropriate adjustments.
  • Estimating a return on investment also helps in choosing among investment options – One should invest in Gold/Real Estate/Stocks/Mutual Funds/Fixed Deposits ?

Let’s learn about various kinds of returns!

Absolute return (Point to Point Returns): Absolute return is the increase or decrease that an investment achieves over a given period of time expressed in percentage terms. It’s calculated as follows:

Absolute returns = 100* (Selling Price – Cost Price)/ (Cost Price)

For example you invested in asset in February 2006 at a price of Rs 20000. And you sold the investment in November 2012 at the cost of Rs 42000. Absolute returns in this case will be:

Absolute returns = 100* (42000 – 20000)/20000 = 110%

This is most simple method to calculate returns but it does not consider time period.  That is where real catch is. Most of time this method produces a large number so people are impressed!

Simple Annualized Return: The increase in value of an investment, expressed as a percentage per year. Expressed as –

Simple Annualized Return= Absolute Returns/Time period.

Do not miss below posts -
  • Real estate market of India can give 91 to 145 …
  • 5 Year Return comparison of Sensex, Real estate, Gold & …
  • Government Saving Bonds 7.75% Interest rate – Good for Investment?

Suppose investment of Rs 1,00,000 becomes 1,24,000 over three years.

Absolute return = 100* ( 124000 – 100000/100000 ) =24 %.

Simple annualized return = 24/3 = 8 %

Average Annual Return (AAR)

Average annual return (AAR) is the arithmetic mean of a series of rates of return. The formula for AAR is:

AAR = (Return in Period 1 + Return in Period 2 + Return in Period 3 + …Return in Period N) / Number of Periods or N

Also Read – Capital Gain Tax Calculator – Download

Let’s look at an example. Assume that an investment XYZ records the following annual returns:

Year Annual Return
2005 20%
2006 25%
2007 22%
2008 -10%

 

AAR for the period from 2005 to 2008: = (20% + 25% + 22% -10%) / 4 = 57%/4 = 14.25%

AAR is somewhat useful for determining trends. AAR is typically not regarded as a correct form of return measurement and thus it is not a common formula for analysis.

Compound Annual Growth Rate or CAGR

CAGR is the year-over-year growth rate of an investment over a specified period of time. It’s an imaginary number that describes the rate at which an investment would have grown if it grew at a steady rate.

Let’s assume you invested Rs 10,000 in Apr 2010 and by Apr 2011 your investment became Rs 30,000, by Apr 2012 it became Rs 15,000. What was the return on your investment for the period?

If you calculate absolute return than it is 50% & simple annualized return is 25%.

But this investment return has fluctuated over a period of time, so how to make estimation that if you have continued investing in same asset class it would have given better result or not. This is similar to saying that you went on a trip and averaged 60 km/hr. Whole time you did not actually travel 60 km/hr sometimes you were traveling slower, other times faster.

So CAGR is a way to smoothen out the returns, it determines an annual growth rate on an investment whose value has fluctuated from one period to the next. In that sense CAGR isn’t the actual return in reality.

Also Read – PPF Account Calculator Download

The formula to calculate CAGR is:

CAGR

CAGR Formula

So CAGR for above example is :

= ((15,000/10,000) ^ (1/2)) -1

= 22.47%

If the investment states that it had an 8% annualized return over ten years, that means if you invested on Apr 1, and sold your investment on Mar 31 exactly ten years later, you earned the equivalent of 8% a year. However, during those ten years, one year the investment may have gone up 20% and another year it may have gone down 10%. In the example if the investment Rs 10,000 would have grown at the rate of 22.47% every year and at end of two years it would be Rs 15,000 as shown in calculation below.

Year Initial Value Growth Final Value
1 10,000 2,247 12,247
2 12,247 2752 15,000

 

Good and Bad of CAGR: CAGR is the best formula for evaluating how different investments have performed over time. Investors can compare the CAGR in order to evaluate how well one stock/mutual fund has performed against other stocks in a peer group or against a market index. The CAGR can also be used to compare the historical returns of stocks to bonds or a savings account. But the bad points of CAGR are:

  • CAGR does not reflect investment risk, and you must use the same time periods.
  • CAGR does not reflect volatility. Investment returns are volatile, they can vary significantly from one year to another. CAGR give the illusion that there is a steady growth rate even when the value of the      underlying investment can vary significantly.

Please remember that returns that we have looked at so far are using value of investment at beginning and at end of the period. But it does not tell the full story. So what is to be done in order to know full story.

Check out next article Calculating Returns of Investment – Formulas & Examples – 2 to know full story explaining Rolling Returns, Relative Returns, IRR and XIRR.

Prev Article
Next Article
Tags:absolute return cagr calculation formulas investment return return investment returns

About The Author

Raviraj Parekh

Raviraj is the man behind moneyexcel.com. He is PGDBA, engaged in blogging for 10 years. Moneyexcel blog is ranked as one of the Top 10 Personal Finance Blog in India. He is not affiliated with any financial product, service provider, agent or broker. The purpose of this blog is to spread financial awareness and help people in achieving excellence for money. Please note that the views expressed on this Blog/Comments are clarifications meant for reference and guidance of the readers to explore further on the topics. These should not be construed as investment advice or legal opinion.

One Response

  1. Sunil shah

    Dear Raviraj ,

    your formulas on Absolute Return and Simple annulized return were eay to understand but i did not follow the CAGR formula, could you explain in details how you got 22.47% in the above example??
    could you send me your e mail address for future Queeries.
    Thanks
    Sunil

    September 23, 2016

Leave a Reply

Cancel reply

IIFL Demat Account

Search

Top Posts & Pages

  • Rakesh Jhunjhunwala Portfolio Holdings - January 2021
  • How to check Property Records and Land Records online in India?
  • Income Tax Calculator FY 2020-21 (AY 2021-22) – Excel Download
  • 20 small manufacturing business ideas with low cost
  • 225 Small Business Ideas with Low Investment in 2021-22
  • Cash Deposit Machine Locator – How to find CDM Near You?
  • LIC Premium Paid Certificate Download For Income Tax Purpose - Online
  • 10 ways to Convert Black Money to White
  • 30 Food Business Ideas with low investment
  • Top 60 Manufacturing Business Ideas

Subscribe to Blog via Email

Join 5,474 other subscribers

Follow MoneyExcel

Money Excel – Personal Finance Blog

Personal Finance Blog
Copyright © 2021 Money Excel - Personal Finance Blog
| About |Downloads | Contact Us | Sitemap | Disclaimer | Privacy Policy |