Facebook TwitterLinkedInYoutubewhatsapp Start Planning for your Financial goals
Schedule Your Free Consultation
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
Holistic investment planners, financial planning Chennai, Private wealth management Chennai

Holistic investment planners, financial planning Chennai, Private wealth management Chennai

Financial Planning chennai India, Private wealth management chennai India, Investment Advisory India, Systematic Investment Plan, Mutual Fund SIP, Mutual Fund ELSS, Tax Saving scheme

  • Home
  • About Us
    • Who we are & What we do
    • Services
      • Financial Road Map
      • Retirement Roadmap
      • Asset Allocation Plan
      • Webinar
      • Money Management
      • Wealth Management
    • In the Media
    • Testimonials
    • What Makes Us Different
    • How we can help you
    • Specialties
    • Honors and Awards
    • Vision & Mission
  • Resources
    • Blog
    • Articles
    • Podcast
  • Ideal Client
  • Contact Us
Calculate-Mutual-Funds-Return

How to Calculate Mutual Fund Returns

by Holistic 7 Comments | Filed Under: Mutual Funds

Listen to this article


Are you one of those avid mutual fund investors who miss none of your investment follow-ups?

Then, how certain are you about what has been ROI (Returnate on Investment)?

Do you at times still, feel lost and confused about calculating your mutual fund investment returns, beforehand?

This is an alarming concern since being aware of the returns you may earn in the future can help you plan your financial decisions in a much smoother way. 

But you worry not! 

Because not being able to calculate the accurate returns on your mutual fund investment is no individual’s fault. 

It’s the challenging calculation behind ascertaining your mutual fund returns that builds a wall between you and your returns. 

So, that brings us to the most important question:  

How  to  calculate mutual fund returns?

Give us a few minutes of your precious time and read this piece; You will learn, how to calculate mutual fund returns with worked-out examples and a formula for calculating different types of mutual fund returns.
You will also get to know how to calculate the profit percentage in the mutual fund for investments done for different periods.

Table of Contents:

  • Mutual Fund Related Terms You Need to Get Familiarised With
  • What is the ‘return’ on a Mutual fund Scheme?
  • So what’s NAV and formula to calculate the NAV?
  • How to Calculate Mutual Fund Returns?
  • What is a Mutual Fund Calculator?
  • Advantages of using a mutual fund calculator
  • Finally

Mutual fund related terms you need to get familiarised with:

Before getting started with calculating returns of mutual fund investments, let me explain a few terminologies that might help you understand the concept of mutual funds better.

  • Mutual fund lump sum investment
  • Systematic Investment Plan(SIP)
  • Exit load

i. Mutual fund lump sum investment:

A lump sum investment refers to a ‘one-time’ investment. 

It is usually made when the investor has a substantial disposable amount of money in hand.

ii. Systematic Investment Plan(SIP):

Investing/depositing a certain amount in a mutual fund scheme at periodic intervals by an investor is called Systematic Investment Plan (SIP).

iii. Exit load:

A fee amount paid to ‘exit’ a mutual fund may be termed as ‘Exit load’. Only some Mutual Funds require that you pay a fee to do so. And the amount varies from one fund to another and is usually some percentage of your  redemption value.

What is the ‘return’ on a mutual fund scheme?


In simple terms, ‘return’ is the yield that your investment generates throughout a period. It is the percentage increase or decrease in the value of the investment in that period.

The simple ways to calculate the returns are given below:

    • Absolute Returns
    • Simple Annualized Returns
    • CAGR (Compounded Annual Growth Rate)
    • XIRR (for calculating SIP Retrns)
    • Mutual Fund SIP calculator to Build a corpus

We will discuss them in detail. But first, let’s understand, what is the significance of  (NAV) in Mutual Fund calculations.

So what’s NAV and formula to calculate the NAV?

According to SEBI, the performance of a particular scheme of a mutual fund is denoted by Net Asset Value (NAV). NAV is the market value of the securities held by the scheme. Since the market value of securities changes every day, NAV of a scheme also varies on day to day basis.The NAV per unit is the market value of securities of a scheme divided by the total number of units of the scheme on any particular date.

Purchase NAV and sale NAV are two important numbers for mutual fund profit calculation.

Example: How to calculate NAV of mutual fund

If the market value of securities of a mutual fund scheme is Rs 300 lakhs and the mutual fund has issued 20 lakh units of Rs. 10 each to the investors, then the NAV per unit of the fund is Rs.15.

i.e. 300 Lakhs / 20 Lakhs = 15

To know more about NAV, you can read this detailed post on Net Asset Value (NAV).

How to Calculate Mutual Fund returns?

There are many ways to calculate mutual funds returns.

Either you have invested in a lump sum or a SIP investment, these methods can be applied to both of them.  

So,the method of mutual funds returns calculationwhich you need to use depends on what you are trying to calculate and why.

1. Absolute Returns

This method is common when the holding period of your investment is less than 12 months. It helps you calculate the simple returns on your initial investment.

Absolute Returns refers to the returns that a fund achieves throughout a period.
Holistic InvestmentIt measures the percentage appreciation or depreciation in the value of the NAV over a certain time frame.

To calculate absolute returns, all you need is the current NAV and the initial NAV of your investment.
Simply put,

the absolute returns formula is:
Absolute Returns

Example: Mutual Fund Return on Investment Calculation

If the current NAV is 15 and the previous NAV was 13.5,

the return would be (15 – 13.5) x 100/13.5 = 150/13.5 = 11.11% over the  period.

If the is in months say 3 months or in years say 2, or in days say 100, in that case, the above formula can be used as
Mutual fund calculationsThe above example will produce returns of 11.11 x 4 = 44.44% (for 3 months); or 5.55% for 2 years or 40.55% for a period of 100 days.

Example 2: Calculation of the absolute returns of a Mutual Fund:

If you have purchased it at Rs.11 per unit and after 3 years, if NAV appreciates to Rs. 15 per unit, here the absolute return is 36.36% as calculated below:

(15 – 11) x 100 / 11 = 36.36%

2. Simple Annualized Returns

mutualfund returns
This method is used when the investment duration is exactly 1 year.

The formula to find out the simple annualized returns is given as:
Absolute ReturnsYou may put this in the excel sheet to calculate it.

For example, the NAV of Rs. 20 may shoot to Rs. 25 in the next 8 months, that is, 240 days. The absolute returns can be calculated as (25-20)/20 = 0.25.

To find the simple annualized returns, we use the formula described above,

(1 + 0.25)^(365/240) – 1 = 40.4%

3. CAGR (Compounded Annual Growth Rate)

When the investment duration is more than 1 year, CAGR is a better way to depict returns. The value of CAGR indicates that how the investment would have grown had it generated a steady return.

The CAGR returns are annualized returns, with the compounding effect.

The formula used to find CAGR is given below,
Absolute Returns

Example: CAGR Calculation

The purchase NAV of your MF is Rs.15 per unit. After two years NAV rises to Rs.25.

Then CAGR will be 29.09%

i.e. [(25/15)^(1/2) -1].

The CAGR calculates the growth rate of investment every year with the compounding effect. In the above example, in case your investment was Rs1500 which has appreciated by 29.09% each year to become Rs.2500 at the end of two years.

Holistic Investment

Absolute Returns Vs Annualized Returns

When you are calculating returns for less than a year, you can calculate absolute return. For calculating mutual fund returns for an investment period of more than a year then you can use  returns.

When you need to calculate point to point returns, you can use absolute return. When you want to calculate the average yearly return, then you can use  return.


4. XIRR (for calculating SIP Returns)

XIRR is a function in Excel for calculating the Internal Rate of Returns for an array of cash flows occurring at an irregular interval. To calculate XIRR, you need the data given below

      • SIP Amount
      • Dates of SIP investments
      • Date of redemption; and
      • Maturity (Redemption) Amount

Let’s take an example:

Suppose you have invested Rs. 2000 every month for the last 1 year and the value of your investment rose to Rs. 26000 due to appreciation in NAV. The following table illustrates your SIP investment:

Returns on SIP (Systematic Investment Plans)

Dec 1, 2020 2000
Jan  1, 2021 2000
Feb  1, 2021 2000
Mar  1, 2021 2000
Apr  1, 2021 2000
May 1, 2021 2000
Jun  1, 2021 2000
Jul  1, 2021 2000
Aug  1, 2021 2000
Sep  1, 2021 2000
Oct  1, 2021 2000
Nov 1, 2021 2000
Dec 1 , 2021 Rs. 26000
XIRR 15.65%
Total Amount Invested Rs. 24000

As the investor invests Rs.2000 per month for 1 year, the absolute returns formula will not work as the money is invested for different periods of time.

The IRR (Internal Rate of return) considers the time value of money for the investment made at different points of time. 

Therefore, we may use XIRR returns (which is nothing but IRR) in MS Excel to find out the return on SIP in the above example, which is 15.65%

5. Mutual Fund SIP calculator to build a corpus

The above 4 methods explain the most effective formulae which helps you in calculating the mutual fund returns you have earned.

The below-automated calculator will help you project and find how much will be the future value of your SIP investments.

This calculator also can be used to find out how much you need to save to accumulate a particular corpus.

What is a Mutual Fund Calculator?

Now, who wouldn’t say yes to an online tool which can help investors calculate their returns rather than manually pulling out the whole math?

This is called the Mutual Fund calculator and this calculator uses a certain investment strategy. 

A mutual fund return calculator can help an investor to understand how far they have reached with their scheduled goal. 

They also provide data on how far you can achieve your goals based on the planned investment and rate of return.

How can you make utmost use Advantages of using a mutual fund calculator?

There are several ways to have benefits through  using a Holistic mutual fund returns calculator, which in turn could make the life of an investor much easier. 

They include: 

      • Accurate valuation
      • Effortless and time-saving process 
      • Easy access 

Accurate valuation

If it’s a never-ending process for you to calculate the returns on your mutual fund investment, then using an online Mutual Fund returns calculator is just for you. 

A Mutual Fund Calculator can provide you with an accurate valuation of the returns on your mutual fund investments.

Effortless and time-saving process

A Mutual Fund calculator could save your valuable time and effort by simply eliminating the need to do lengthy manual calculations.

Easy access

Are you are home away for a while now and can’t stop worrying about the returns you would earn in the coming future, then an Online Mutual Fund Calculator is what you need the most. 

You can access the online Mutual Fund calculator tool from anywhere you want, making it incredibly convenient to perform any financial planning on the go.

Final Words

You now know very simple ways to calculate returns on Mutual Fund investments. To know the NAVs of MF schemes, you may have to go to the website of AMFI (The Association of Mutual Funds in India) at www.amfiindia.com.

Have you tried any other way to calculate mutual fund returns? What result did you get? How much time did it consume? Kindly share your views in the comment box.

If you are  inclined to make this solid difference in achieving your financial goals by creating a financial plan, then I would suggest you to test-drive our services by opting for

Reader Interactions

Previous article: What every Tax Payer needs to know about Mutual Fund ELSS?
Next article: 4 Types of NRI Banking/Savings Account. How to make use of these accounts?

Comments

  1. George d says

    June 8, 2022 at 7:11 pm

    Much appreciate your service … but it does not reflect the complexity of fund changes over a period of time. For example, one invests 1000 (ignore the currency) on 01Jan20, then withdraws 250 on 23Mar22, but adds 375 on 10Apr22 … and so on. Assuming you are privy to fund NAV on a daily basis, what is the yield on this investment. Obviously, this is not a SIP. The XIRR might be appropriate.

    Reply
    • Holistic says

      September 26, 2022 at 5:16 pm

      In the above example, using XIRR will help.

      Reply
  2. Seby says

    September 8, 2020 at 7:56 pm

    Thanks for the detailed explanation. Just one question though is, if there are three active SIP and all the SIP are clubbed together to get overall XIRR. Now say from these combined data of three schemes of mutual fund, if I need to figure out XIRR for one of the scheme, how to get that. Do not want to enter separately scheme wise. Wanted to have one database with all SIP of different scheme and from the same database XIRR of one scheme

    Reply
    • Holistic says

      October 3, 2022 at 8:04 pm

      Advanced excel formula needs to be used sir. It is possible in the excel sheet.

      Reply
  3. prasant saboth says

    July 4, 2020 at 7:45 pm

    Where is the expenses , commissions and taxes paid calculations??

    Reply
    • Holistic says

      October 3, 2022 at 8:05 pm

      Expenses, commissions are already adjusted in NAV. So no need to include here.

      Income tax liability differs person to person based their income slab and the nature of transaction line ….short term CG or Long term CG. It needs to be separately calculated.

      Reply
  4. Manivel says

    April 15, 2018 at 12:58 am

    Thanks a lot!

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Client Login

Recent Posts

  • Mastering Islamic Finance: The Ultimate Guide to Sharia Investment
  • Smart Financial Planning Tips for Beginners – A Complete Guide
  • SIP Investment Mistakes! How to Overcome Them?
  • What is Flexi Cap Mutual Fund:
    Explained
  • Explained: What is ELSS Mutual Fund?
Jey S
Jey S
24. September, 2021.
I have been using Holistic Investment Planners for the last three years. Mr. Srinivasavaradhan answered all my questions and doubts very patiently during the first free consultation. I was able to clearly define my short-, medium- and long-term goals once I signed up for the comprehensive plan and got their investment plan suggestion to achieve my goals. They are very polite and highly professional whenever I contact them for any queries or make investments. They never pressurize you to invest on their recommended financial products. I would have been lost money by investing directly without their help since I do not have time and knowledge about different financial products. Risk planning is also done as part of financial planning. Truly, they are holistic planners when it comes to your financial planning. They help you to define your life goals, understand your financial resources and establish a plan to invest towards reaching those goals. They do review your plan as you progress to make sure that you are on correct path to achieve those goals. Kudos to the team and keep up the good work!!! I am happy that I found holistic investment planners for my financial planning and management.
aksaswadkar
aksaswadkar
24. September, 2021.
I was about to retire and really not understanding how to invest money to have financial freedom and fulfilling my goals. Was desperately searching on internet way out and fortunately came across Holistic Investment Planners. I read number of articles on their website and realized that this is the agency which I want and engaged their services for my retirement planning. It is an excellent experience to be associated with Holistic. Right from day one our interaction was fantastic and they gave me such a wonderful plan that I had never imagined. I am fortunate enough to be in the client list of Holistic. I have recommended Holistic to my friends as well.
Lionel Faber
Lionel Faber
16. September, 2021.
I've been availing their services for the past year. They are highly knowledgeable in the field and are very patient with all doubts and queries. Personalized financial planning is provided keeping your short term, medium term and long term goals in mind. They do not pressurize you to purchase schemes of their choice. They provide their input and suggestions and leave the decision up to you which shows their honesty and high principle.
Sridhar
Sridhar
8. September, 2021.
Financial planning brings peace in life. Holistic Investment have supported in arriving financial plan based on future goals. My investments are regular since then. They are professionals in their business, will recommend others.
Nitesh Agrawal
Nitesh Agrawal
6. September, 2021.
I have been using Holistic Investment Planners from last one year. The journey has been fantastic. Being a finance person myself I always thought we can look after and plan own finances also. However, due to lack of time and deciplain the things are not always as desired. After joining with Holistic Investment for the first time Icame to know the Financial goals and quantified them. Some dreams were unrealistic based on the earnings and savings so had a reality check. Also got the information and deciplain of investing on regular and more rewarding securities. I definetly suggest to use Holistic Investment Planners. They are professionals, available and hear youor full story before presenting plans. They are flexile in the sense if there are some urgent deviations required, they help to plan the same. For all professionals/individuals I would suggest using professional help of Holistic Investment Planners for best results in long term investment and financial goals achivements. Last advise will be to start early in your life. It really pays well to start in the beginning itself else the dreams needs to adjust :)
Swetha Vasanth
Swetha Vasanth
6. September, 2021.
This is my first year service with the Holistic Team and I would say that they are very much helpful in creating a financial plan and follow ups during the year. I would definitely suggest them if anyone who is willing to proceed with their savings professionally.
Joseph Mathias
Joseph Mathias
6. September, 2021.
I came to know about Holistic Investment Planners online while searching for different investment ideas. Once I contacted them the journey was very smooth. Mr. Ramalingam explained all the aspects of Financial planning in detail and it opened my mind. I realized how important it is to have a Financial planning. Mr. Rajan suggested all the requirements as per my goals and made a Investment plan keeping in mind of my goals. I started my Investment journey with them. I wish I had done it some years back then it would have been in a different level. Review meetings were held every six month to check the implementation of the plan and check the results as per the requirements and to check if any changes required. Overall it was a good experience with Holistic Investment team and would like to continue in the years to come.
Srinvas Kannan
Srinvas Kannan
30. July, 2021.
I came across Holistic investment planners almost 5-6 years back, but I did not have the trust since I had met a few of them who did not sound promising. Then I started investing through a financial advisor of my friend. After 4 years of investing the returns were very low. I was disappointed and started looking for financial advisors when I came across Holistic investment. I had a detailed discussion about my goals and the way they would approach achieving my goal before deciding to switch my investments to them. After a thorough analysis of my then existing portfolios, they suggested new ones and we zeroed-in on 6 schemes/funds where our investment would be split. I am glad I made the decision of switching over and taking Holistic planner's advise, my returns are handsome and I only wish I could have taken their help/advise 5 years back itself. Neverthless, I would like to recommend their services for investment and financial advise if someone is serious about their investments.
Shivaram Andiappan Selvaraj
Shivaram Andiappan Selvaraj
3. July, 2021.
I got a free first time consultation. I got my doubts resolved. They also gave additional advises for investment planning which was also useful.
Nellai B
Nellai B
26. June, 2021.
I have been associated with them for the past three years. They are very professional and polite in answering all our questions. I have complete trust in their suggestions. I strongly recommend for anyone. I am looking forward to have strong and successful association with them.
Google rating score: 4.4 of 5,
based on 61 reviews

Footer

  • Articles
  • Gallery
  • Ideal Client
  • Jobs(Full Time)
  • Podcast
  • Services
  • Testimonials

Connect With Us

Holisticinvestment.in
10/15, Second Cross Street,
Seethammal Extn.,
Teynampet,
Chennai – 600 018,
INDIA.

Copyright © 2022. Holisticinvestment.in | All rights reserved.    Cared with ❤ by T-Square Cloud

×