# How do you calculate the returns from SIP investment?

## Introduction

When you think of investing, one of the first few investment instruments that you may think of is mutual funds. Moreover, what makes it so popular is its versatile structure.

In mutual funds, you can either park a lumpsum amount in a scheme or go for a more systematic approach, i.e., the SIP route. Irrespective of the route you choose, you should a have an idea of how much returns you would earn a couple of years down the line from your investment? Such calculations keep you well informed whether you are on the right track towards your financial goal. Now, when you opt for a lumpsum investment, you invest in units at one single net asset value (NAV). Calculating returns from such an investment seems like an easy job. However, this is not the case with SIP investments. Your SIP investment is done at fluctuating NAVs. It is relatively more complex to calculate returns in this case due to the series of instalments and changing NAVs associated with each instalment. So, how do you find out the returns on both these investments?

Lumpsum vs SIP: Know the Advantages

What is a SIP and why is it Beneficial for You

Calculate the returns you can earn on a lumpsum investment or a SIP investment using the three methods explained below

## Absolute return or Point-to-Point method

You can use this straightforward method to calculate the returns from the start point to the endpoint of your mutual fund investment. To use this method, you must apply the following formula:

Absolute Return = {(Final NAV – Initial NAV) / Initial NAV} * 100

Example: Let us assume you started a lumpsum investment where the NAV was Rs. 75 at the start. A couple of months into the investment, the NAV rose to Rs. 100. The Absolute Returns, in this case, will be:

{(100-75)/75}*100

= 33.33%

Similarly, you can also use this method to calculate the returns using the initial investment amount and the value of your investment at the end. This method is easy to use and preferred where the investment tenure is under a year. One significant drawback of this method is that it disregards investment tenure. For instance, in the above example, you cannot assess whether the 33.33% was earned over a year, or two, or three, and so on. Time plays a centre-stage role in comparing schemes based on the returns they offer within a said duration. However, this method will not inform you about the pace at which your investment has garnered x% returns.

## Compounded Annual Growth Rate (CAGR) method

The CAGR method takes care of the shortcomings of the Absolute Return method. It factors in the investment tenure to give you the average annualised growth of the investment. In other words, the CAGR method calculates a steady rate of return at which your investments grow each year. It overlooks the volatility your investment goes through and only reflects the average rate of return throughout your investment tenure. To find out the returns using this method, you must apply the following formula:

CAGR = {(Final Value of Investment / Initial Investment Amount) ^ (1/n)} -1

Here, n = number of years

If your investment tenure is in months, you can divide the no. of months by 12 to convert the tenure in years.

Let us understand the CAGR method better with the help of the following example. Let us assume, you invested Rs 10,000 in a lumpsum mutual fund investment for three years. The NAV at the start of your investment was Rs. 25. Three years into the investment, the NAV rose to Rs. 50. The CAGR returns, in this case, will be:

{(50 / 25) ^ (1/3)} -1

= 25.99% or approximately 26%

The above method is advisable to be used only for lumpsum investments. To calculate the CAGR from SIP investments you can use XIRR function on MS Excel.

## Extended Internal Rate of Return (XIRR) method

XIRR is a method to calculate returns from SIP investments. It factors all the aspects of every SIP instalment, including the instalment amounts, the instalment dates, the investment maturity date, the cash inflows, and outflows. XIRR is a Microsoft Excel Function that calculates the CAGR to give you one consolidated SIP return rate.

In a SIP investment you invest a predefined amount at a set frequency. Each instalment fetches you a certain number of mutual fund units based on the NAV of that day. Your corpus of units keeps adding up, and accordingly, your returns may also increase. You can redeem the total units at the ongoing NAV and earn lumpsum returns.

Using this XIRR method is easy as Excel computes its complete calculation using the data points you provide. These include the SIP amount, the SIP instalment dates, the investment redemption date, and the redemption amount. This method does not require you to keep a record of any NAVs.

An example will help you understand easily how this method can be used in Excel.

Let us assume you have invested in a SIP, where the monthly instalment amount is Rs. 10000. You make timely payments starting from 1January 2021 for the next 12 months in a row. You redeem your investment a year later, on 1January 2022, and earn a maturity amount of Rs. 150000.

In this method, the instalments you pay are treated as cash outflows and must have a minus (-) prefix before the amount. Conversely, the redemption amount is an inflow to you. Hence, it must not have minus prefix.

To calculate the returns, you can earn in the above example, you have to mention all the SIP instalment dates in one column along with the instalment amounts in the adjacent column. In the row below the last instalment date, type the investment maturity date along with the maturity amount in the adjacent column.

It will look like this in MS Excel,

 Column A Column B 1 01-01-2021 -10000 2 01-02-2021 -10000 3 01-03-2021 -10000 4 01-04-2021 -10000 5 01-05-2021 -10000 6 01-06-2021 -10000 7 01-07-2021 -10000 8 01-08-2021 -10000 9 01-09-2021 -10000 10 01-10-2021 -10000 11 01-11-2021 -10000 12 01-12-2021 -10000 13 01-01-2022 150000

Now you need to only type in the XIRR formula in a blank cell, i.e., = XIRR (value, dates, guess). Select the respective columns against the ‘Value’ and ‘Dates’ fields. Leave the ‘Guess’ field blank and click on ‘OK’. Excel will instantly give you the SIP return rate of 48.9%.

If this seems like a complicated thing, you can always let a SIP calculator do the job for you. Simply punch in different combinations of instalments amounts, tenures, and expected return rates to see the future value of the investment at the end of the investment term.

Additional Read: How to Make the Best Use of SIP Calculator (Systematic Investment Plan)

## Conclusion

As a thumb rule, never enter a mutual fund investment blindly. Always know the risk and expected returns you can earn from an investment in advance and compare products. Knowing how much returns you can earn from an investment always helps in managing your investment decisions.

Additional Read: Is it normal if SIP returns are low in the initial years?

Disclaimer: ICICI Securities Ltd.( I-Sec). Registered office of I-Sec is at ICICI Securities Ltd. - ICICI Venture House, Appasaheb Marathe Marg, Prabhadevi, Mumbai - 400025, India, Tel No : 022 - 2288 2460, 022 - 2288 2470. I-Sec is a Member of National Stock Exchange of India Ltd (Member Code :07730) and BSE Ltd (Member Code :103) and having SEBI registration no. INZ000183631. Name of the Compliance officer (broking): Mr. Anoop Goyal, Contact number: 022-40701000, E-mail address: complianceofficer@icicisecurities.com. Investment in securities market are subject to market risks, read all the related documents carefully before investing. AMFI Regn. No.: ARN-0845. We are distributors of Insurance and Mutual funds, Corporate Fixed Deposits, NCDs, PMS and AIF products. Please note that Mutual Fund Investments are subject to market risks, read the scheme related documents carefully before investing for full understanding and detail. ICICI Securities Ltd. acts as a referral agent to ICICI Bank Ltd., ICICI Home Finance Company Limited and various other banks / NBFC for personal finance, housing related services etc. & the loan facility is subjective to fulfilment of eligibility criteria, terms and conditions etc. The contents herein above shall not be considered as an invitation or persuasion to trade or invest.  I-Sec and affiliates accept no liabilities for any loss or damage of any kind arising out of any actions taken in reliance thereon.

### Most Popular

• 21 Jun 2022
• ICICI Securities

#### Should you invest in Mutual Funds SIPs or FDs?

Choosing between a Systematic Investment Plan and a Fixed Deposit comes down to risk appetite and investment goal. Nevertheless, mutual fund SIP investments can be beneficial in many ways. This article will outline the difference between the two investment instruments and which one you should choose.

• 21 Jun 2022
• ICICI Securities

#### How to choose the best SIP investment?

Systematic Investment Plans (SIPs) are an option to make regular investments in mutual funds. Before heading to make an investment in SIP mutual funds, consider these factors to find the one that perfectly justifies your financial goals.

• 21 Jun 2022
• ICICI Securities

#### How does long term capital gains tax impact you?

Certain assets, such as real estate and shares, attract long term capital gains (LTCG) tax. Here’s what you need to know about LTCG tax and how it can impact your finances.

• 21 Jun 2022
• ICICI Securities

#### Choosing between stock market and fixed deposit investments

Choosing the right investment option is critical for meeting personal financial goals. This article will highlight the difference between choosing stock market investments and fixed deposits—the aspects to consider, the risk-return profile, and what would fit into your portfolio.

• 21 Jun 2022
• ICICI Securities

#### Are Small-Cap funds good investments?

The best small-cap funds outperformed large-cap and mid-cap mutual funds last year. Now that the markets are turning bearish, is it a good idea to invest in small-cap mutual funds? Here’s an overview of these equity mutual funds to help you make an informed decision.

• 17 Jun 2022
• ICICI Securities

#### What Does the US Fed's Biggest Rate Hike Mean?

On 15th June 2022, the US Federal Reserve hiked interest rates by 75 basis points, the biggest hike since 1994. Why did it do so? What are its implications for India? Read on to find out more.

• 15 Jun 2022
• ICICI Securities

#### What is ESG investing and everything you need to know about it

In the last few years, since climate awareness and social justice have piqued people’s interest worldwide, ESG investment has increased. This article talks about ESG investing and the options available for ESG investment in India.

• 15 Jun 2022
• ICICI Securities

#### The Latest ESG Reporting and Framework in India

In May 2021, India introduced a new environment, social, and governance (ESG) guideline for the top 1,000 listed companies by market capitalisation. The Business Responsibility and Sustainability Report (BRSR) will be mandatory for these companies from FY 2022-23. Here’s what you should know about this ESG guideline.

• 15 Jun 2022
• ICICI Securities

#### Difference Between ESG and SRI Investing

When it comes to value investing, the two terms—ESG investing and SRI investing—are often confused. However, ESG investing strategies are different from SRI investing strategies. Read more to find out what sets the two apart and how you can decide which approach to adopt.

• 14 Jun 2022
• ICICI Securities

#### Four ways to ensure you leave your children a financial legacy

It is a moment of pride for parents to see their children earn their own money and lead a life with dignity. No words can express the joy to see your children grow, but how do you touch their life when you are gone? You can do that by leaving behind a financial legacy for your children to inherit. Here are four ways you can align your financial plan such that you leave behind something for your children.