What Is a Lumpsum Investment?
A lumpsum investment is a single, one-time payment into a mutual fund scheme, as opposed to an SIP where the same total amount is spread across monthly instalments.
Most investors make a lumpsum investment when they receive a cash windfall: a year-end bonus, an inheritance, proceeds from a property sale, or the maturity payout of an FD or insurance policy. The full principal starts compounding on day one.
Under AMFI guidelines issued by SEBI, mutual fund performance for periods over one year is reported as CAGR, the same annualised rate this calculator uses for its lumpsum projections. A Rs 10,00,000 lumpsum at 11% for 15 years grows to approximately Rs 47,84,589 on this basis.
Lumpsum Calculator Formula: How Maturity Value Is Calculated
The calculator uses the standard compound interest formula with annual compounding:
A = P × (1 + r)^t| Symbol | Meaning |
|---|---|
| A | Maturity value: total corpus at the end of the tenure |
| P | Principal: your one-time investment amount |
| r | Expected annual return rate, as a decimal (12% = 0.12) |
| t | Investment duration in years |
Worked example: Rs 5,00,000 invested for 10 years at an expected 12% annual return. A = 5,00,000 × (1.12)^10 = Rs 15,52,924. The investor put in Rs 5,00,000 and earns Rs 10,52,924 in returns, all from a single entry that compounded untouched for a decade.
Lumpsum Formula in Excel: Three Methods
The same maturity value can be built in a spreadsheet using any of these three formulas, all of which return an identical result for the Rs 5,00,000 example above.
| Method | Formula |
|---|---|
| Direct formula | =5000000*(1+0.12)^10 |
| POWER function | =500000*POWER(1.12,10) |
| FV function | =-FV(0.12,10,0,500000) |
The FV function needs a negative sign because Excel treats the investment as a cash outflow. All three return Rs 15,52,924.
Reverse Lumpsum Calculator: How Much to Invest Today for a Target Corpus
A reverse lumpsum calculation answers a different question: how much should I invest today to reach a specific goal amount? The formula rearranges the maturity equation to solve for principal:
P = A / (1 + r)^t| Target corpus | Duration | Return rate | Lumpsum needed today |
|---|---|---|---|
| Rs 1 crore | 10 years | 12% | Rs 32,19,732 |
| Rs 1 crore | 15 years | 12% | Rs 18,26,963 |
| Rs 1 crore | 20 years | 12% | Rs 10,36,668 |
| Rs 1 crore | 25 years | 12% | Rs 5,88,233 |
| Rs 50 lakh | 10 years | 10% | Rs 19,27,716 |
| Rs 50 lakh | 15 years | 10% | Rs 11,96,960 |
| Rs 25 lakh | 5 years | 8% | Rs 17,01,458 |
| Rs 10 lakh | 3 years | 7% | Rs 8,16,298 |
A shorter horizon or a lower expected return both push the required lumpsum up, since there is less time for compounding to do the work. To sanity-check how long any amount takes to double at a given rate, the Rule of 72 Calculator gives a quick mental-math estimate.
Types of Mutual Fund Returns: Absolute, Annualised, Trailing and Rolling
Mutual fund fact sheets quote returns in several different formats, and confusing one for another is the most common mistake investors make when comparing funds.
| Return type | What it measures |
|---|---|
| Absolute return | Total percentage gain over the full holding period, with no adjustment for time. (Current value − investment) / investment × 100. |
| Total return | Absolute return that also includes dividends or IDCW payouts reinvested along the way. |
| Annualised return (CAGR) | The single yearly rate that would produce the same growth. (End value / start value)^(1/years) − 1. |
| Point-to-point return | Return measured between two fixed calendar dates, useful for comparing a specific past window. |
| Trailing return | Return measured backward from today over a fixed window, such as trailing 1-year or trailing 5-year, the most commonly quoted figure on fund fact sheets. |
| Rolling return | The average of returns calculated across many overlapping periods through history, which smooths out the bias of picking one lucky or unlucky start date. |
For a lumpsum specifically, CAGR and the annualised return are the same number, since there is only one cash flow date. SIP portfolios need XIRR instead of CAGR, because multiple instalments go in on different dates. Use the XIRR Calculator for SIP or staggered investment returns.
SIP vs Lumpsum Calculator
Compare the same total amount invested as a lumpsum against a monthly SIP, side by side.
SIP + Lumpsum Combined Calculator: What It Measures
The SIP + Lumpsum tab above models a common real-world scenario: investing a lumpsum now while also continuing a regular monthly SIP. It adds the lumpsum maturity value to the SIP maturity value, both compounding at the same expected annual return over the same period.
For example, a Rs 3,00,000 lumpsum combined with a Rs 10,000 monthly SIP, both running at 12% for 10 years, grows to a Rs 9,31,754 lumpsum component plus a Rs 22,40,359 SIP component, for a combined maturity value of roughly Rs 31,72,113 on a total investment of Rs 15,00,000.
This combined mode is useful right after receiving a windfall: it shows what happens if you invest part of it immediately and keep your existing SIP running, rather than treating the two as separate, unrelated decisions.
Lumpsum vs SIP: Which Is Better?
Lumpsum wins on paper when the market rises steadily from your entry date, because every rupee gets the maximum possible time to compound. SIP wins on risk management, because it spreads your entry across many market levels instead of betting on one date.
| Mode | Total invested | Maturity value |
|---|---|---|
| Lumpsum (day one) | Rs 12,00,000 | Rs 37,27,018 |
| SIP (Rs 10,000/month) | Rs 12,00,000 | Rs 22,40,359 |
When lumpsum makes more sense
Lumpsum works best after a genuine market correction, or when you have a large idle sum and a holding period of 7 years or more, since a longer runway gives the full amount more time to compound.
When SIP makes more sense
SIP suits investors putting away money from monthly income, or anyone unsure whether current valuations are high. If you want to project both a lumpsum and an ongoing SIP together instead of choosing one, the Wealth Growth Calculator models existing wealth plus new SIP contributions in one place.
Best Lump Sum Investment Plans in India
The right lump sum investment plan depends mainly on the time horizon and how much volatility you can tolerate before the money is needed.
| Option | Typical return | Lock-in | Best for |
|---|---|---|---|
| Equity index funds (Nifty 50, Sensex) | 10-12% | None | Long-term goals, 7+ years |
| Flexicap / multicap active funds | 12-15% | None | Long-term with active risk tolerance |
| ELSS | 12-15% | 3 years | Section 80C tax saving plus equity exposure |
| Debt mutual funds | 6-8% | None | Goals under 3 years |
| Fixed deposits | 6.5-7.5% | As chosen | Capital safety, short-term parking |
| PPF | 7.1% | 15 years | Guaranteed, tax-free long-term goals |
| NPS | 9-12% (market-linked) | Till retirement | Retirement corpus with tax benefit |
Rates for FD, PPF and equity are historical or government-declared figures and change over time. Check current PPF rates on the PPF Calculator, and if the 80C limit also matters to your decision, the ELSS Calculator shows the tax-adjusted comparison.
What Return Rate Should You Use for a Lumpsum Investment?
Use a rate based on the asset class you are actually going to invest in, not a round number. Historical category averages, per AMFI category data and NSE India index data, give a reasonable starting point.
| Asset class | 10-year CAGR range |
|---|---|
| Nifty 50 / Sensex index funds | 10-12% |
| Large-cap active funds | 10-13% |
| Flexicap / multicap funds | 12-15% |
| Midcap funds | 13-17% |
| Smallcap funds | 14-19% |
| Hybrid / balanced advantage funds | 9-12% |
| Debt mutual funds | 6-8% |
| Bank fixed deposits | 6.5-7.5% |
For planning purposes, run the calculator at your assumed rate, then run it again 2 to 3 percentage points lower. The gap between the two maturity values tells you how much buffer your plan actually needs.
Tax on Lumpsum Mutual Fund Returns in India
Equity mutual fund units held under 12 months are taxed at 20% short-term capital gains (STCG). Units held 12 months or more are taxed at 12.5% long-term capital gains (LTCG), with the first Rs 1.25 lakh of gains in a financial year exempt.
Debt mutual funds bought after April 2023 are taxed differently: all gains are added to your income and taxed at your slab rate, regardless of how long you hold the units, per current Income Tax Department rules. ELSS funds qualify for a Section 80C deduction at the time of investment but carry a mandatory 3-year lock-in.
Lumpsum Calculator for Stocks and Index Funds
The same formula applies to a single stock purchase, not just mutual funds. Buying Rs 2,00,000 of Reliance Industries shares and holding for 8 years at an assumed 13% CAGR would project to A = 2,00,000 × (1.13)^8, or approximately Rs 5,31,689.
For an actual stock, that projected rate should come from the stock's own historical CAGR, not a fund category average, and note that this is a price-return estimate. It excludes dividends, which the total return figure would include separately.
Limitations of the Lumpsum Calculator
It assumes a constant annual return. Real markets do not grow in a straight line. A 12% assumption smooths over years of 30% gains and years of 15% losses into one average, which is useful for planning but not a forecast.
It does not account for expense ratio or exit load. Actual mutual fund returns are net of a fund’s expense ratio, and an exit load applies if you redeem before the fund’s minimum holding period. Both reduce your real return slightly below the projected figure.
It shows nominal value, not inflation-adjusted value. The maturity amount shown is what your account will show, not what that amount will be able to buy in the future. Subtract an assumed inflation rate before comparing the result against a real-world goal.
It does not model taxes on redemption. The maturity value shown is pre-tax. Actual take-home proceeds depend on the STCG or LTCG rate applicable at the time you redeem, covered in the tax section above.
SWP Calculator
Already have a lumpsum invested? Model a monthly withdrawal plan against it for retirement income.
How to Use This Lumpsum Calculator
- Choose a tab: pick Lumpsum for a single one-time investment, or SIP + Lumpsum to add a monthly SIP alongside it.
- Enter your investment amount: the one-time principal, and, in the combined tab, the monthly SIP amount.
- Set the expected return rate and duration: use the sliders, or click a value to type it exactly. Year presets are available for quick comparison.
- Review the results: the maturity amount, invested vs returns split, and the donut chart update instantly as you adjust any input.
- Open the growth schedule: expand Your Growth Schedule to see the year-by-year breakdown of principal, returns, and total value.
Are you a CA or financial advisor?
Generate branded Tax Optimization Reports for your clients.
Frequently Asked Questions
Disclaimer: All calculations on this page are indicative only. Projected returns are based on a constant annual rate you supply and do not predict actual future performance. Past performance of any investment does not guarantee future results. This calculator is for educational and planning purposes only and does not constitute financial advice. Consult a SEBI-registered investment adviser before making investment decisions.