To calculate mutual fund returns manually, you need to know the mutual fund return calculation formula. It’s always much easier (and faster) to use the ET Money mutual fund returns calculator. This is particularly true when you’re trying to compare returns from your mutual fund investment generated using either a lump sum or SIP strategy.
Even if you choose to use the Mutual Fund return calculator online, it’s helpful to know the formula that was used to calculate the returns on mutual funds that you can receive from your investments. Following are the mutual fund calculation formulas. You shall notice that the formulae for both modes of investment are different. Wonder why? Read on.
Lumpsum investment |
SIP Investment |
---|
M = P (1 + r/100)n |
M = A [ (1 + i)n – 1] x (1 + i)/i |
Where:
M = Maturity amount
P = Principal amount
r = Estimated rate of return
n = Holding period (in years)
|
Where:
M = Maturity amount
A = SIP contribution per period
i = Rate of return
n = Holding period (in months)
Note: For daily/weekly SIPs, adjust i and n accordingly.
|
You should know two things about both formulas.
First, the formula used in the lump sum formula is CAGR (compound annual growth rate) while the one used in the SIP formula is XIRR (Extended Internal Rate of Return). The reason is that CAGR works only for calculating returns on a point-to-point basis. When there are multiple cash flows (like in the case of SIP), you need to use XIRR because the returns for each cash flow will differ. XIRR helps you calculate a single return percent for all cash flows and is, therefore, relevant to SIPs. If you are keen to learn more about this, click on XIRR and CAGR to know more.
It’s also worth noting that the based on the scheme you choose and whether you choose a direct or regular plan. The fund house will deduct their commission from your returns when you invest through the regular mode (i.e., through a broker, advisor, or distributor). Since a direct plan doesn’t involve an intermediary, you don’t pay any commission, which reduces the expense ratio and translates to relatively higher returns. Preferably, you’d want to go with a direct plan when choosing mutual fund schemes in India because you’ll end up with relatively higher returns.
For instance, let’s assume that the difference in the expense ratio between the direct and regular plan of a scheme is 0.75%. Following are the returns and the investment value calculated using the ET Money mutual fund calculator for direct vs regular plans:
|
Direct |
Regular |
---|
Inputs |
Investment = ₹6 lakh
Holding period = 10 years |
Investment = ₹6 lakh
Holding Period = 10 years |
Expected return before expense ratio (p.a.) [A] |
13% |
13% |
Expense ratio [B] |
1% |
1.75% |
Expected return after expense ratio (p.a.) [A - B] |
12% |
11.25% |
Total returns (based on expected returns after expense ratio) |
₹12.64 lakh |
₹11.42 lakh |
Maturity value |
₹18.64 lakh |
₹17.42 lakh |
Note that by simply choosing to invest in a direct plan (i.e., without taking any additional risk), you’re able to increase your returns substantially. You can invest in a direct plan online with just a couple of steps through the ET Money website.