定期投资(SIP)计算器

估算每月共同基金定投(SIP)的到期价值,可选择每年增加投入,或计算达到目标所需的定投金额。

更新于 已验证的示例:7

$
%
years
%
Raise the monthly amount by this percentage every 12 months
试一试
Maturity value
$
Maturity value: $1,161,695.38
小数位数:2;取最近值,等距时取偶数末位
Total invested
$600,000.00
Estimated returns
$561,695.38
Market-linked returns vary year to year; this assumes a constant return compounded monthly.

Investing $5,000.00 a month for 10 years grows to $1,161,695.38. Of that, $600,000.00 is your money and $561,695.38 is return.

Invested amount and returns

$0$250K$500K$750K$1M0246810Years
InvestedReturns

Maturity value split

$1.2Mmaturity value
Invested51.6%Returns48.4%
Year-by-year growth 行数:10
年Monthly SIPInvested this yearTotal investedValue at year end
1$5,000.00$60,000.00$60,000.00$64,046.64
2$5,000.00$60,000.00$120,000.00$136,216.00
3$5,000.00$60,000.00$180,000.00$217,538.24
4$5,000.00$60,000.00$240,000.00$309,174.17
5$5,000.00$60,000.00$300,000.00$412,431.83
6$5,000.00$60,000.00$360,000.00$528,785.15
7$5,000.00$60,000.00$420,000.00$659,894.99
8$5,000.00$60,000.00$480,000.00$807,632.83
9$5,000.00$60,000.00$540,000.00$974,107.53
10$5,000.00$60,000.00$600,000.00$1,161,695.38
计算方法 S
  1. Monthly rate

    i=12%12=0.01i = \frac{12\%}{12} = 0.01
  2. Value of one year of start-of-month instalments of 1

    a=(1+i)12−1i(1+i)=12.80932804a = \frac{(1+i)^{12}-1}{i}(1+i) = 12.80932804
  3. Grow all instalments to the end

    F=(1+i)120−1i(1+i)=232.3390764F = \frac{(1+i)^{120}-1}{i}(1+i) = 232.3390764
  4. Maturity value

    FV=C×F=5,000.00×232.3390764=1,161,695.38FV = C \times F = 5{,}000.00 \times 232.3390764 = 1{,}161{,}695.38

    Money shown rounded half-to-even to 2 decimals.

关于定期投资(SIP)计算器

A SIP (systematic investment plan) puts a fixed amount into a mutual fund every month. At a steady return, N monthly installments grow to FV = P × ((1 + i)^N − 1) ÷ i × (1 + i), where i is the annual return ÷ 12. The extra factor (1 + i) counts each installment as invested at the start of its month, the convention AMFI's SIP calculator uses. A step-up raises the installment by a fixed percentage every 12 months.

With the defaults, 5,000 a month for 10 years at an expected 12% a year grows to 1,161,695.38. Of that, 600,000 is the money invested and 561,695.38 is estimated returns. In goal mode the same formula runs backwards: reaching 1,000,000 in 10 years at 12% takes 4,304.05 a month.

The return is held constant and compounded monthly. Fund returns vary from month to month, so treat the result as one scenario; taxes and exit loads are not deducted.

SIP formula, worked by hand

Take 10,000 a month for 15 years at an expected 10% a year.

  1. Monthly rate: i = 10 ÷ 12 ÷ 100 = 0.0083333.
  2. Number of installments: N = 15 × 12 = 180.
  3. Growth factor: (1 + i)^180 = 4.453920.
  4. Value of 180 end-of-month payments of 1: (4.453920 − 1) ÷ 0.0083333 = 414.4703.
  5. Shift every payment to the start of its month by multiplying by (1 + i): 414.4703 × 1.0083333 = 417.9243.
  6. Maturity value: 10,000 × 417.9243 = 4,179,242.66.

You invest 1,800,000, so estimated returns are 2,379,242.66, and 57% of the final value is growth. In Excel, =FV(10%/12, 180, -10000, 0, 1) gives the same figure; the final 1 tells it that payments come at the start of each period. Leave it out and you get the end-of-month value, 4,144,703.46, which is 34,539.20 less: one month's growth on the whole balance.

With INR selected in settings, the result is grouped in lakhs and crores, so 4,179,242.66 shows as 41,79,242.66. SIP is the Indian name for the plan, but the arithmetic is the same for a monthly investment into any fund in any currency.

What the expected return means

Because the monthly rate is the yearly return ÷ 12, a 12% entry compounds to 12.68% a year: 1.01^12 − 1 = 12.6825%.

That matters because fund factsheets and index histories report returns as compound annual growth rates. If you expect a fund to grow 12% a year in that sense, the matching monthly rate is 1.12^(1/12) − 1, and the figure to enter is 12 × (1.12^(1/12) − 1) = 11.39%. Over 15 years at 10,000 a month the difference is large:

  • 12% entered directly: 5,045,760.00.
  • 11.39% entered, matching a 12% annual growth rate: 4,760,870.31.

The first figure overstates the second by 284,889.69, about 6%. Convert first whenever your return assumption comes from a CAGR.

SIP return scenarios

Maturity values for 10,000 a month at four steady returns, using the calculator's convention:

YearsInvested8%10%12%14%
5600,000739,667.02780,823.81824,863.67872,007.35
101,200,0001,841,656.752,065,520.202,323,390.762,620,913.83
151,800,0003,483,451.434,179,242.665,045,760.006,128,537.79
202,400,0005,929,472.187,656,969.109,991,479.1913,163,462.75
253,000,0009,573,665.7113,378,903.4818,976,350.9227,272,777.15
303,600,00015,002,951.7822,793,253.2435,299,137.7455,570,556.28

The return assumption dominates long horizons. Over 5 years, 14% instead of 8% adds 18% to the result; over 30 years it multiplies it by 3.7. At 30 years, moving the assumption from 12% to 14% adds 57%, more than investing half as much again each month would. Scale the table for other amounts: 5,000 a month is half of each figure.

Step-up SIP: how much a yearly increase adds

Starting at 10,000 a month at 12%, raising the installment every 12 months:

Step-upYearsFinal monthly SIPTotal investedMaturity value
0%1510,000.001,800,000.005,045,760.00
5%1519,799.322,589,427.636,530,751.93
10%1537,974.983,812,697.808,683,849.43
15%1570,757.065,709,649.3011,835,224.59
0%2010,000.002,400,000.009,991,479.19
5%2025,269.503,967,914.4913,737,623.28
10%2061,159.096,872,999.9419,888,715.49
15%20142,317.7212,293,229.9130,255,941.57

Over 20 years a 10% step-up raises the maturity value by 9,897,236.30, of which 4,472,999.94 is extra money you put in. Each unit invested also earns less: returns are 3.16 times the amount invested without a step-up and 1.89 times with a 10% step-up, because the later, larger installments have less time to compound. Check the final-year installment before committing. A 15% step-up over 20 years ends at more than 14 times the starting amount, which assumes your income grows as fast.

XIRR vs CAGR: measuring what your SIP earned

CAGR, (end value ÷ start value)^(1 ÷ years) − 1, describes a single lump sum. A SIP has a different investment date for every installment, so the return has to weight each one by how long it was invested. XIRR does that: it finds the yearly rate at which every dated installment, grown to the valuation date, adds up to the current value. Excel's XIRR counts time in days over a 365-day year (Microsoft).

Take 5,000 invested on the 1st of each month through 2025, worth 64,000 on 1 January 2026. The gain is 4,000 on 60,000 invested, an absolute return of 6.67%. Treating that as a one-year CAGR understates the result, because the average installment was invested for only about six and a half months. XIRR on the 13 dated flows gives 12.48% a year.

XIRR is an effective annual rate, so compare it with the effective rate of your calculator input, not the input itself. Run the calculator's own flows through XIRR, 5,000 on the 1st of each month at 12% growing to 64,046.64, and the result is 12.63%. That is close to the 12.68% effective rate, with the gap coming from months of unequal length. The XIRR calculator handles the dated flows, and the ROI and CAGR calculator covers lump sums.

Reading the result

The projection assumes the same return every month. Real returns arrive unevenly, and for a SIP the timing of a fall matters because the balance is largest at the end. On 10,000 a month for 15 years at 12%, a 20% market fall at the end of year 1 cuts the maturity value by 136,316.10. The same fall at the end of year 8 costs 745,194.00, and just before maturity it costs 1,009,152.00. Moving money into lower-risk funds as the goal date approaches limits that exposure.

Pauses cost more than the money skipped. The calculator cannot skip months, but the cost is easy to work out: a year's installments are worth 12.8093 times the monthly amount at the end of that year, and then grow for the years left. Stopping 10,000 a month during year 5 of the 15-year plan leaves 10,000 × 12.8093 × 1.01^120 = 422,757.38 less at maturity, 3.5 times the 120,000 not invested.

The figure is also before costs and taxes. Enter a return net of the fund's expense ratio, and deduct tax on gains when you redeem. To see what a maturity value is worth at today's prices, use the inflation calculator. To test whether it covers retirement spending, use the retirement calculator.

计算示例

5,000 a month at 12% for 10 years

我要计算
Maturity value
Monthly investment
5000
Expected return (per year)
12%
Investment period
10 years
Yearly step-up
0%
Maturity value
1,161,695.38
Total invested
600,000.00
Estimated returns
561,695.38

核验来源:Python decimal: 5000 × ((1.01^120 − 1)/0.01) × 1.01 = 1161695.3818…; equals Excel =FV(1%,120,-5000,0,1)

AMFI worked example: 5,000 a month at 12% for 7 years

我要计算
Maturity value
Monthly investment
5000
Expected return (per year)
12%
Investment period
7 years
Yearly step-up
0%
Maturity value
659,894.99
Total invested
420,000.00

核验来源:AMFI Mutual Funds Sahi Hai SIP page: invested about ₹4.20 lakh, corpus around ₹6.60 lakh; Python decimal gives 659894.9857…

One year, 1,000 a month at 12%

我要计算
Maturity value
Monthly investment
1000
Expected return (per year)
12%
Investment period
1 year
Yearly step-up
0%
Maturity value
12,809.33

核验来源:Python decimal: 1000 × ((1.01^12 − 1)/0.01) × 1.01 = 12809.3280…

10% step-up at 12%

我要计算
Maturity value
Monthly investment
5000
Expected return (per year)
12%
Investment period
10 years
Yearly step-up
10%
Maturity value
1,687,163.13
Total invested
956,245.48
Monthly SIP in the final year
11,789.74

核验来源:Python decimal year-by-year sum of 5000·1.1^y·a·1.01^(12(9−y)): 1687163.1321…

常见问题

How is SIP maturity value calculated?

FV = P × ((1 + i)^n − 1) ÷ i × (1 + i), with P the monthly amount, i the annual return ÷ 12 and n the number of months. AMFI's example of 5,000 a month for 7 years at 12% gives 420,000 invested and a corpus of about 6.60 lakh; the exact figure is 659,894.99. Excel's =FV(1%, 84, -5000, 0, 1) returns the same.

How much SIP is needed to reach 1 crore?

At a steady 12% a year, reaching 1 crore (10,000,000) takes 43,040.54 a month over 10 years, 19,818.62 over 15 years, 10,008.53 over 20 years and 5,269.72 over 25 years. Each extra five years roughly halves the monthly amount, because the earliest installments compound for longer. A lower return raises every figure.

What is a step-up SIP?

A SIP whose monthly amount rises by a fixed percentage each year, usually in line with salary. Starting at 5,000 a month with a 10% yearly step-up at 12% for 10 years, the installment reaches 11,789.74 in the final year, 956,245.48 is invested and the maturity value is 1,687,163.13, against 1,161,695.38 without the step-up.

Is a lump sum better than a SIP?

At a constant return, yes, because all the money compounds from the first day. 600,000 invested at once at 12% (compounded monthly) grows to 1,980,232.14 in 10 years, against 1,161,695.38 when the same total is spread as 5,000 a month. A SIP spreads the purchase price over many months, which reduces the risk of investing everything just before a fall; this constant-return model does not capture that.

“定期投资(SIP)计算器”有多准确?

准确性取决于输入值和方法的假设。十进制运算使用50位有效数字,但估算、数值方法和源数据的精度可能较低;显示时的舍入并不能消除这些限制。 已按独立来源核验的计算示例:7。 例如,“5,000 a month at 12% for 10 years”根据Python decimal: 5000 × ((1.01^120 − 1)/0.01) × 1.01 = 1161695.3818…; equals Excel =FV(1%,120,-5000,0,1)进行核验。

这种方法出自哪里?

Microsoft Excel FV function (type = 1 for payments at the start of each period); AMFI Mutual Funds Sahi Hai — SIP calculator (FV = P((1+i)^n − 1)/i·(1+i), i = annual/12).

关于此计算器

FV=C (1+i)N−1i (1+i),i=r12, N=12Y;step-up: FV=∑y=0Y−1C(1+s)y a (1+i)12(Y−1−y)FV = C\,\frac{(1+i)^{N}-1}{i}\,(1+i),\quad i = \frac{r}{12},\ N = 12Y;\quad \text{step-up: } FV = \sum_{y=0}^{Y-1} C(1+s)^{y}\,a\,(1+i)^{12(Y-1-y)}

来源

  1. Microsoft Excel FV function (type = 1 for payments at the start of each period)
  2. AMFI Mutual Funds Sahi Hai — SIP calculator (FV = P((1+i)^n − 1)/i·(1+i), i = annual/12)

仅用于规划。贷款机构、税务机关和市场采用各自的舍入方式、费用和规则;作出承诺前,请向相关机构确认数值。

已对照来源验证

此计算器包含 7 个已解示例,答案来自独立来源。这些示例会在测试套件中运行,你也可以在此运行验证。

相关计算器