A mutual fund return is not a single number, because the fund return and the investor return differ. The fund return is the growth of its net asset value, NAV, plus any distributions, over a period. The investor return depends on when money went in: a lump sum invested on day one rides the whole period, while a systematic investment plan, SIP, buys units at many different prices over months or years. This guide explains NAV, the SIP and lump-sum formulas, the XIRR that summarises an irregular investment, and the fees that quietly take a share, all without recommending any fund, because past returns do not predict future ones.

NAV: the price of one unit

Net asset value is the fund total assets minus its liabilities, divided by units outstanding. If a fund holds $100 million of securities, owes $1 million, and has 10 million units, the NAV is $9.90. NAV is computed daily after markets close, and it is the price at which investors buy and sell units that day, unlike a stock price, which moves continuously.

A fund return over a period is NAV growth plus distributions reinvested, divided by starting NAV. If NAV rises from $10 to $11 and distributes $0.50 reinvested, the return is 15 percent. Distributions matter: a fund that pays out income looks lower on NAV alone, but the reinvested distribution is part of the return, and total-return figures include it.

NAV is not a quality signal. A fund with NAV $10 and a fund with NAV $100 are not cheap or expensive relative to each other: NAV is assets divided by units, and a fund with more units has a lower NAV for the same portfolio. Compare returns, not NAV levels, and compare funds in the same category, because a bond fund and an equity fund are not competing on the same risk.

Lump sum versus SIP: timing is the difference

A lump sum compounds for the whole period: future value equals principal times (1 plus rate) to the power of years. A $10,000 lump sum at an assumed 8 percent for 15 years grows to about $31,700. The return is the fund return, because the money was in for the full period, and the risk is that the starting date was a market peak.

A SIP invests a fixed amount regularly, buying more units when NAV is low and fewer when it is high, which averages the purchase price over time. The future value of a monthly SIP is the monthly amount times ((1 plus monthly rate) to the power of months minus 1) divided by monthly rate, times (1 plus monthly rate), for payments at the start of each month. At an assumed 10 percent a year, $500 a month for 10 years, 120 months, grows to about $103,200, from $60,000 invested.

The SIP advantage is behavioural as much as mathematical: it invests through falls without requiring a timing decision, and it turns volatility into cheaper units. The lump-sum advantage is time in the market: money invested earlier compounds longer. Over long periods with rising markets, the lump sum usually wins on return, while the SIP usually wins on adherence, because it is automatic.

XIRR: the return that accounts for timing

Extended internal rate of return, XIRR, is the annualised return that equates the present value of all cash flows, in and out, at their actual dates. It answers: what constant yearly rate, applied to these dated investments, would give this final value? For a SIP, XIRR is the right summary, because a simple total return ignores that early instalments compounded longer than late ones.

The intuition: a SIP that ends at $103,200 from $60,000 over 10 years has a total gain of about 72 percent, but the annualised XIRR is about 10 percent by construction in the example, because the return was assumed at 10 percent. For a real SIP, compute XIRR from the dated instalments and the final value in a spreadsheet, with =XIRR(values, dates), and compare it across funds and periods, not the raw gain, which favours longer periods.

XIRR has limits: it assumes interim cash flows compound at the same rate, which is a simplification, and it is sensitive to the final valuation date. A fund that spikes just before the valuation date shows a flattering XIRR. Use XIRR for comparison over the same period, and total return for the fund itself, and never annualise a short period, because a lucky month becomes an absurd yearly rate.

Fees: the quiet share

The expense ratio is the yearly fee as a percentage of assets, deducted from NAV daily, so it never appears as a bill. A 1 percent expense ratio on $100,000 compounding at 7 percent for 20 years leaves about $320,700, against about $386,970 without the fee, a difference of about $66,000. The fee looks small yearly and costs hugely over decades, because it compounds against you exactly as returns compound for you.

Entry loads are largely gone in many markets, but exit loads, charged on early redemption, and transaction costs inside the fund still exist. Index funds typically charge far less than active funds, and the fee gap is the most reliable predictor of relative performance available: fees are certain, outperformance is not. The calculator return view shows gross and net figures side by side, so the fee is visible.

Taxes are the second quiet share, and they depend on jurisdiction and holding period. In the US, distributions and capital gains are taxed yearly or at sale, and the after-tax return is the return that matters. The calculator does not compute tax, because the rules vary, but any return comparison should state whether it is before or after tax.

SIP in India: the same maths, in rupees

In India, the SIP is the dominant way retail investors buy mutual funds, and the maths is identical in rupees. A ₹5,000 monthly SIP at an assumed 12 percent a year for 10 years grows to about ₹11.6 lakh, from ₹6 lakh invested, by the same annuity formula. The assumption is illustrative, not a forecast: Indian equity funds have delivered varied returns, and no SIP return is assured.

Indian specifics include expense ratios regulated by SEBI, exit loads on early redemption, and ELSS funds, which offer tax deduction under section 80C with a three-year lock-in. The calculator India section works in rupees and labels the currency, because mixing rupee SIP figures with dollar fund figures is the commonest error in cross-market comparisons.

No fund is recommended here, and no return is promised. Past performance, Indian or otherwise, does not predict future returns, and a SIP does not protect against loss: it averages purchase prices, but if the market falls and stays down, the SIP falls with it.

Mistakes with fund returns

First, comparing NAV levels instead of returns. Second, annualising short periods, which turns a lucky month into a fantasy yearly rate. Third, ignoring fees, which compound against you. Fourth, comparing a SIP return with a lump-sum return directly, without XIRR, which ignores timing.

Fifth, chasing last year winners: fund performance persists weakly, and last year top quartile is barely more likely than average to repeat. Sixth, treating a SIP as safe: it is a purchase method, not a guarantee, and it loses money in falling markets like any equity investment. The calculator shows the maths; the judgement about risk stays with the investor.

Frequently Asked Questions

How does this mutual fund calculator combine SIP and lump sum?

It projects each separately by its own formula, SIP as a monthly annuity and lump sum as single-period compounding, then adds the two future values. The combination is the sum of the two projections.

What is the SIP future-value formula used here?

Monthly amount times ((1 plus monthly rate) to the power of months minus 1) divided by monthly rate, times (1 plus monthly rate), for payments at the start of each month.

What expected annual return should I enter?

A conservative planning assumption, not last year return. Equity planning often uses 8 to 10 percent nominal for long horizons, and bond planning lower, but no assumption is a forecast, and the result should be stress-tested lower.

Does this calculator account for taxes and fees?

Fees can be entered as a reduced return, because the expense ratio deducts from NAV. Taxes are not computed, because rules vary by jurisdiction and holding period; compare returns before or after tax consistently.

Can I use it for a lump sum only, or SIP only?

Yes. Set either amount to zero and the projection uses the other alone. A lump sum alone compounds for the full period; a SIP alone buys at many prices over time.

How much can a 1 percent expense ratio cost me?

On $100,000 compounding at 7 percent for 20 years, about $66,000: about $386,970 without the fee against about $320,700 with it. The fee compounds against you like returns compound for you.