Returns on an SIP depends on the risk that an investor is willing to take. More the risk, more is the return. In this case, since the risk involved is moderate, the return is also moderate.

Investing in these funds can be done via lumpsum as well as via Systematic Investment Plan (SIP).

An investor having INR 100 for 10 years will stay invested for the entire period of 10 years. But in case of SIP if INR 10 is invested every year for 10 years, then the first installment of INR 10 will be invested for 10 years, next installment for 9 years and so on. So here the growth is less.

Investors make this mistake of calculating return on Systematic Investment Plan (SIP) of mutual funds by taking the installment amount for the entire year for calculating the return.

Suppose an investor has done a SIP of Rs. 1000 for 36 months which means that the investor will have to pay Rs 1000 every month for next 36 months.

Looking to invest? Open an account with Groww and start investing in direct mutual funds for free

In this case, an investor is basically taking Rs. 1000 for the entire year for all the installments made in the year. Investors simply take 1000 multiplied by 12 i.e 12000 and then they start calculating the result. Now, this is a mistake committed by investors.

What investors should do is that they should take the installment amount for the duration for which it is invested in order to calculate annualized return on the fund in which he/she has invested.

Suppose in the above case where an investor has done an SIP of Rs 1000 for 36 months, an investor should calculate return on the first installment made for 12 months, return on next installment made should be calculated for 11 months and same way for the last installment made in that particular year return should be calculated only for 1 month.

Say return rate is 10 %, then it should be calculated separately for the first month i.e 10 % of 1000 which is 100. For the next month, the return will be 10 % of 1000 * 11 / 12 which is 91.67. This way return for the last month on an installment in a financial year will be 10 % of 1000 * 1 / 12 which will be 8.33.

Above mentioned method helps an investor in rightly calculating the return on the investment made in mutual funds via Systematic Investment Plan.

Also, an investor should keep in mind that the number of units that he will be getting for a particular fund will not be same throughout the year. This happens because the Net Asset Value ( NAV ) of the fund will not be constant. It will keep changing depending on the market price of the stocks in which the fund has invested in.

Lets say that the NAV of a fund is Rs. 57 in a particular month, then the no of units an investor will be getting will be 1000 / 57 which is 17.54 units. Now say the next month NAV of the fund changes to 61, then the number of units allotted to the holder of the fund will be 1000 / 61 which is 16.39 units.

This method helps an investor to calculate the simple returns on his initial investment. What one needs is only the initial and the present or the ending Net Asset Value (NAV) of the fund. In calculating the point to point or absolute return, the holding duration does not have any importance in calculating return.

So, if an investors initial NAV was, say, Rs 30 and now after 3 years, it is Rs 45, the point to point return will be 50 %.

In formula, absolute return = (present NAV initial NAV) / initial NAV x 100

An investor may try this in excel sheet to calculate the return. In any box, start by typing =

Use this formula to calculate returns when the time period is less than 12 months.

Few investors may want to annualise the return made when holding duration is less than 12 months.

Also called as effective annual yield, it is actually extrapolating the returns but not giving the true picture. If an investor wants to annualise the returns, then the formula is:

((1 + Absolute Rate of Return) ^ (365/number of days)) 1

You may put this in excel sheet to calculate it.

Illustration:The NAV of Rs 30 may increase to Rs 37.5 in, say, 7 months, i.e., 210 days. The absolute return in this case is 33.33 % over 7 months, i.e., 0.25

Absolute return, therefore, as told by the Securities and Exchange Board of India (SEBI), is when the period is less than a year, and simple annualised return is shown when period is exactly a year.

When the time duration is more than a year, CAGR is a better way to calculate returns. It is basically a number that shows how the investment would have grown had it generated a constant return. In reality, however, returns may not be the same every year. CAGR, therefore, shows a mean annual growth rate that smoothens out the volatility in returns over a duration of time.

Here, we consider CAGR of investment made in Mutual Funds.

Assuming an investor had invested Rs 1 lakh in an Mutual Funds 3 years back at an NAV of Rs 15. Now, the NAV is Rs 30.


Formula: =(((ending-value/beginning-value)^(12/number-of-months))-1*100

Similarly, if you know the NAV and the number of days, then use

Formula: =(((ending-value/beginning-value)^(365/number-of-days))-1*100

Cash inflows and outflows may not always be evenly matched and instead these could be at irregular intervals. For example, in a money back plan or in a mutual fund SIP. XIRR is a function in Excel for calculating internal rate of return or annualized yield for a time table of cash flows taking place at irregular intervals.

In a SIP, an investor should keep investing regularly over a long duration and get back the maturity amount upon maturity. SIP investments happen on a date that is decided beforehand by the investor and even the amount of SIP is fixed.

Depending on the NAV of the fund on that day, an investor will get certain number of units. Hence, he should keep accumulating units from the day his SIP starts. On the day he redeems the fund, he will get the maturity amount, which is NAV of redemption day multiplied by total units on redemption day.

Now, to know how much returns a fund has made, an investor may use the XIRR function in excel. It is simple and one does not even need the NAV of any date.

What an investor calculates as returns are in fact, the absolute returns earned from his investment. The calculations are very simple i.e divide the profits earned by the capital invested, and convert it into a percentage figure.

There is an innate defect in this method, though. The absolute return figure has limited application in case of SIPs because the cash flows have been staggered into the portfolio and not invested in one go. In other words if an investor had invested an amount as a lump sum and earned some amunt as a profit over a year, his assessment of the return would have been spot on.

In case of a SIP, though, the entire invested capital did not spend a full year in the fund. One instalment had a holding tenure of 380 days, another had 340 days, and so on and so forth. Therefore, each SIP instalment would, in fact, have to be viewed differently in order to correctly calculate the returns earned on an investors investment.

The correct way to calculate returns from an investors SIP would be to consider the CAGR of each unique SIP instalment separately, and thereafter average these instalments. Since a SIP consists of equal sized instalments, a weighted average calculation would not be needed instead a simple average would be sufficient.

In doing so, an investor will be taking into account the fact that each SIP instalment is, in fact, a unique investment in itself. By calculating the CAGR for each instalment, investor be condensing each instalment to a common frame of reference, thereby removing the impact of the holding difference for each SIP instalment.

Many software systems used by Financial Planners have an inbuilt system to calculate SIP returns in this manner. An investor do not have to themselves calculate the returns on these SIPs. As an investor, whats important is that they have the knowledge of how SIP returns are calculated, more than anything else.

After going through the methods mentioned for calculating returns on SIP for mutual funds, an investor will be able to calculate the return for SIP in the right way and will not make the mistake which most of the investors make.

Moreover funds from different categories have also been explained in detail so that an investor can make the right choice of investing in mutual funds via SIP and calculate returns for the same accordingly.

Disclaimer: the views expressed here are of the author and do not reflect those of Groww.

Start investing in 2 mins. Direct plans for free. Join the community of 1m+ users.

All You Need To Know About Direct Funds Mutual Funds

This Is Why You Should Consider Mutual Funds if You Want to Buy a Property

How to Avoid LTCG (Long Term Capital Gain) Tax?

Liquid funds vs savings bank account: which is a better investment?

ICICI Prudential Launches Bharat Consumption Fund Everything You Need to Know About This NFO

1st Floor, Proms Complex, SBI Colony, 1A Koramangala, 560034

Mutual fund investments are subject to market risks. Please read the scheme information and other related documents carefully before investing.

Past performance is not indicative of future returns. Please consider your specific investment requirements, risk tolerance, investment goal, time frame, risk and reward balance and the cost associated with the investment before choosing a fund, or designing a portfolio that suits your needs.

Groww is an investing platform where users can find the best mutual funds to invest in and can invest their money without any hassles. Groww provides objective evaluation of mutual funds and does not advice or recommend any mutual fund or portfolios. Investor shall invest with their own descretion. Groww does not guarantee any returns and safety of capital.

By providing objective evaluation of products available on Groww

By bringing up red flags, if any, involved in the products. However Groww does not guarantee to bring out all red flags

By being transparent about fees and charges involved in investing in a product

By clearly representing the risk associated with buying a product

All transactions on Groww are safe and secure. Users can invest through SIP or Lumpsum using Netbanking through all supported banks. It uses BSE Star MF (with Member code 11724) as transaction platform.

Mutual fund investments are very popular with individual investors because of the benefits they provide. Among the many advantages, the most important factors that drive investors to mutual funds are that Investors can

– Start with any amount (as low as 500) – Diversify across multiple stocks and other instruments like debt, gold etc. – Start automated monthly investments (SIP) – Invest without requiring to open DMAT account

All type of mutual funds are available on Groww.

Portfolio is collection of mutual funds designed to meet your investment goals. Investing in mutual fund portfolios helps you in diversifying your investments and reduces the risk. Portfolios also help you in assigning an investment goals and make it easy for you to save for and achieve your goals. You can create a portfolio yourself or ask an expert to build it for you.

NextBillion Technology Private Limited (withARN-111686) and Finvantage Investment Adviser Private Limited (INA200008981) makes no warranties or representations, express or implied, on products offered through the platform. It accepts no liability for any damages or losses, however caused, in connection with the use of, or on the reliance of its product or related services. Unless otherwise specified, all return figure shown above are for illustrative purposes only. Actual returns will vary greatly and depends on personal and market circumstances. The information provided by our blog is educational only and is not investment or tax advice. NextBillion Technology Private Limited and Finvantage Investment Adviser Private Limited does not endorse views given or portfolio designed by third parties on the website, and these are their independent opinion on the scheme or performance of the schemes. Terms and conditions of the website/app are applicable. Privacy policy of the website are applicable. Prevent unauthorised transactions in your account. Receive information of your transactions directly to your mobile/email. Issued in the interest of investors, KYC is one time exercise while dealing in Mutual Funds – once KYC is done you need not undergo the same process again when you approach another Mutual Fund.