Mutual Fund Returns Calculator using Excel [VIDEO]

MF RETURNS calculator How Mutual Fund Returns are calculated video

I get many queries on my YouTube Channel regarding how mutual funds work, is there any Mutual Fund Returns Calculator in Excel, what is expense ratio, what is NAV, how mutual fund NAV is calculated, what are the best mutual funds and how to select best mutual fund based on goals.

Mutual funds are funds that invest in set of companies to maximize investor’s returns. The amount you invest helps you buy units of mutual funds based on NAV (Net Asset Value), which is the price of a single unit of a mutual fund. You accumulate mutual fund units over a period of time based on your goals and sell them off with a NAV value that provides you good returns. Also, every mutual fund has a fund manager that tries to maximize your returns by selecting good stocks to invest your money in. We will see all these with the help of examples.

Also, you can find the Mutual Fund Returns Excel Calculator Download link at the bottom of this article.

Table of Contents

Mutual Fund Returns Calculator Video using Excel

YouTube player

Watch more Excel Videos Here

What are Mutual Funds

  • Mutual Funds are Funds that help you invest in shares of multiple companies
  • Unlike stocks investing, mutual funds invests your money in multiple companies thus reducing the risks
  • This benefit of mutual funds investing in shares of multiple companies is called Diversification
  • Every mutual fund is assigned a Fund Manager who manages that mutual fund
  • Fund manager is responsible to select percentage of stocks to invest your money in, to give you better returns
  • Unlike stocks investing, you need not have to worry about selecting and monitoring stock performances while investing in mutual funds. Fund manager does the job for you
Mutual Fund Portfolio of Stocks
Mutual Fund Portfolio of Stocks

What is NAV (Net Asset Value) of Mutual Fund

  • NAV (Net Asset Value) is the price of single unit of mutual fund
  • NAV of every mutual fund is updated on daily basis except on weekends and public holidays in India
  • For example, NAV = Rs. 100, and you invest Rs. 10,000 then you get 100 units (Rs. 10,000 / Rs. 100) of this mutual fund in your folio (mutual fund account)
  • In this way, your investment value divided by the NAV value will determine the units that will be allocated to you
  • NAV of a mutual fund is something you should NOT consider while choosing a mutual fund. It doesn’t matter if NAV is Rs. 10 or Rs. 1000
    List of stocks present in mutual fund will determine the fund’s future growth
  • If the companies in fund’s portfolio grows with positive returns, NAV increases with time, else NAV decreases with time. Ideally, the NAV fluctuates over time and over longer run (over 5-7 years), mutual funds are believed to give good returns

ALSO READ: 20 Years SIP Returns Calculation in Excel

How Mutual Funds Work

  • As mentioned above, you invest certain amount in mutual fund, and based on NAV, required number of units are allocated to you
  • Similarly, whenever you want to sell the mutual fund units once your goal is achieved, you sell off required units based on latest NAV and get the amount
  • Let’s say you bought 100 units at NAV = Rs. 100 by depositing Rs. 10,000. After 1 year the NAV increases to Rs. 110 and you want to sell the mutual fund units. So you can sell at the NAV value of Rs. 110 and get Rs. 11,000 (100 Units multiplied by Rs. 110 NAV). This gave profit of Rs. 1000
  • Mutual Fund Returns Calculator will help you see all these numbers in action.

Always remember to invest in mutual funds with a goal in mind. Goal must be time specific and realistic. Some goal examples can be to buy a new car, to save for child’s education or to accumulate retirement fund.

You can find the Mutual Fund Returns Calculator at the bottom of this article.

Love Reading Books? Here are some of the Best Books you can Read: (WITH LINKS)

  • Book - Rich Dad Poor Dad - FinCalC Blog
  • Book - The Richest Man in Babylon
  • Book - The Intelligent Investor
  • Book - Think and grow Rich

More Recommended Books Here

What is Expense Ratio

Expense ratio is a small percentage taken by AMC (Asset Management Company) to manage your funds. You need not have to pay additionally as a part of Expense Ratio.

Expense Ratio amount is recovered from your profits that you make. Usually, expense ratio of regular mutual funds are high compared to those of direct mutual funds. You can get details of expense ratio of every fund on the mutual fund page.

SIP Returns Calculator Excel

YouTube player

Watch more Excel Videos Here

Lump sum vs SIP Investment

  • Lump sum Investing: You deposit a one time amount as a lump sum investment in mutual fund
  • SIP Investing: You deposit a fixed amount regularly every month which is called SIP (Systematic Investment Planning)
  • In lump sum investing, you invest entire amount just once, and the units allotted to you will be based on the NAV value on the day of investment
  • In SIP, you invest regularly every month and the number of units are allotted to you every month based on the ups and downs of NAV values. This helps you get the advantage of Rupee Cost Averaging
  • When we see returns, lump sum investing will give you more returns compared to SIP, but lump sum investing also has high risk compared to SIP

ALSO READ: SIP vs Lumpsum Investments in Mutual Fund

Mutual Fund Categories

  • Every mutual fund has 2 categories: Regular and Direct
  • Both regular and direct mutual fund have almost same set of stocks under their portfolio
  • Expense Ratio: Expense ratio of regular mutual fund is high compared to direct mutual fund
  • Returns: Direct mutual fund gives you higher returns compared to regular mutual fund
  • You should go for direct mutual fund to get better returns

ALSO READ: Rs. 1000 SIP Returns Calculation for 15 Years

Types of Mutual Funds

  • There are 3 types of mutual funds: Equity, Debt and Hybrid mutual funds
  • Equity mutual fund: Mutual funds that invest in equities – shares of companies. These mutual funds high risk but also gives you high returns
  • Debt mutual fund: Mutual funds that invest in bonds or instruments. They have low risk and low returns
  • Hybrid mutual fund: Mutual funds that invest in a combination of Equity and Debt instruments. They have medium risk and medium returns
  • Based on your risk appetite and your goals, you can choose between above categories of mutual funds

ALSO READ: Taxation on Short Term Capital Gains (STCG Tax)

Things to remember before investing in Mutual Fund

  • While you are searching for a good mutual fund, you should see how the fund has performed in past
  • You should also see the expense ratio of the fund and how much money is invested in the fund which is called AUM (Asset under management). Lower the expense ratio of the fund, more returns you’ll receive
  • You should only invest in Direct mutual funds for better returns which also have low expense ratio compared to their regular fund counterpart
  • Never book losses in mutual funds. If the market is down, wait for the market to come up so that you are in profit
  • It is always better to divide your money and invest via SIP (Systematic Investment Planning) compared to investing as lump sum.
    Never try to time the market to get best returns.
  • If someone says they can maximize your returns and ask you to lend them your money, just run away and never look back

Some more Videos

YouTube player

YouTube player

YouTube player

Watch more Excel Videos Here

DOWNLOAD MUTUAL FUND RETURN EXCEL CALCULATOR

Click below button to download Mutual Fund Returns Calculator

Download SIP Excel

Conclusion

You can start investing with a small amount of Rs. 500 and gradually increase this amount with time as your income increases. SIP (Systematic Investment Plan) is on of the best ways to invest in mutual funds.

Also lumpsum investing in mutual funds in between during bear market will help you accumulate good number of mutual fund units and give better profits over long term.

Always remember to link a goal with every investment in mutual fund and when the goal is achieved, redeem the mutual fund units and live a better life with such personal finance planning!

Some more Reading:

Get EARLY Retirement!

Use Retirement Excel Calculator that will help you to Retire Early.
Click below button to download Retirement Calculator in Excel:

Download Retirement Excel

Watch how Retirement Calculator in Excel Works

Income Tax Calculator App – FinCalC

For Income Tax Calculation on your mobile device, you can Download my Android App “FinCalC” which I have developed for you to make your income tax calculation easy.

What you can do with this mobile App?

  • Calculate Income Tax for new FY 2024-25 and previous FY 2023-24
  • Enter estimated Investments to check income tax with Old and New Tax Regime
  • Save income tax details and track regularly
  • Know how much to invest more to save income tax
  • More calculators including PPF, SIP returns, Savings account interest and lot more
Download Income Tax Calculator APP from play store
Download Income Tax Calculator APP from play store

Use Popular Calculators:

I’d love to hear from you if you have any queries about Personal Finance and Money Management.

JOIN Telegram Group and stay updated with latest Personal Finance News and Topics.

Download our Free Android App – FinCalC to Calculate Income Tax and Interest on various small Saving Schemes in India including PPF, NSC, SIP and lot more.

Follow the Blog and Subscribe to YouTube Channel to stay updated about Personal Finance and Money Management topics.

Related Posts