BAJAJ ASSET MANAGEMENT LIMITED.

SIP Calculation Formula: How SIP Returns Are Calculated

SIP Investment Plan Calculator- How to Factor in Step-Up SIPs for Better Projections

The SIP calculation formula estimates the future value of regular investments using an assumed return and contribution schedule. It does not predict what a mutual fund will earn.

For an existing investment, each instalment purchases units at the applicable NAV. Your investment value depends on the units held and their current NAV, while XIRR measures annualised returns using actual transaction amounts and dates. Keeping these calculations separate helps you plan and assess performance correctly.

What is the SIP calculation formula?

For equal contributions made at the end of each month, the formula for SIP calculation is:

FV=P×((1+i)n−1)/iFV=P×((1+i)^n-1)/i

For contributions made at the beginning of each month, multiply by an additional month’s growth:

FV=P×((1+i)n−1)/i×(1+i)FV=P×((1+i)^n-1)/i×(1+i)

These formulas assume regular intervals, a constant monthly return and no withdrawals.

Breaking down the formula’s variables

  • FV represents the estimated future value of your investment.
  • P is the amount you contribute each month.
  • i is the assumed monthly return expressed as a decimal.
  • n is the total number of monthly contributions.

For five years, n = 5 x 12 = 60

If the assumed return is zero, the future value is simply P x n. Use this directly rather than dividing by zero in the formula.

Converting an annual return into a monthly rate

Two conventions are commonly encountered:

  • For a nominal annual rate, calculate the monthly rate as i = R/12
  • For an effective annual return, calculate the monthly rate as i = (1 + r)^1/12-1

Here, r is the annual rate expressed as a decimal.

A 12% nominal annual rate gives 1% monthly. A 12% effective annual return converts to approximately 0.9489% monthly. They are different assumptions: compounding 1% monthly produces approximately 12.68% over a year.

The worked projections below consistently use 1% monthly and end-of-month contributions. This is a hypothetical calculation assumption, not an expected return from a scheme.

Sources: Microsoft Support, official FV function documentation on periodic payments and payment timing; NISM, SIP Calculator guidance on projection inputs and limitations.

Key Takeaways

  • The SIP formula projects future value under stated assumptions rather than forecasting scheme performance.
  • Beginning- and end-of-month contributions produce different estimates.
  • Monthly-rate conversion depends on whether the annual input is nominal or effective.
  • Step-up SIP calculations must account for changing contribution amounts.
  • XIRR accounts for successive investment dates, while CAGR should not be applied to aggregated SIP contributions as though they were invested upfront.

Step-by-step SIP calculation examples

These examples exclude taxes, exit loads and other investor-level charges. Intermediate calculations retain their precision, while final corpus amounts are rounded to the nearest rupee.

Example 1: Fixed monthly SIP

Assume:

  • Monthly contribution: ₹5,000
  • Duration: Five years
  • Contribution timing: Month-end
  • Assumed monthly return: 1%
  • Number of instalments: 60

Substitute the values:

FV=₹5,000×((1.01)60−1)/(0.01)FV=₹5,000×((1.01)^60-1)/(0.01)

Estimated future value = ₹4,08,348

ComponentAmount
Total contributions: ₹5,000 × 60₹3,00,000
Estimated growth₹1,08,348
Estimated future value₹4,08,348

The entire corpus is not your gain. It includes the ₹3,00,000 contributed.

Changing the assumptions produces different estimates:

Assumption for ₹5,000 monthly over five yearsEstimated future value
1% monthly, month-end contributions₹4,08,348
1% monthly, month-start contributions₹4,12,432
12% effective annual return converted monthly, month-end contributions₹4,01,706

This is why matching the displayed annual rate alone is insufficient when comparing calculators.

The figures shown are for illustrative purpose only

Example 2: Step-up SIP

Suppose the monthly contribution increases by 10% after every twelve instalments:

YearMonthly contributionAnnual contributions
1₹5,000₹60,000
2₹5,500₹66,000
3₹6,050₹72,600
4₹6,655₹79,860
5₹7,320.50₹87,846
Total—₹3,66,306

The fixed-payment formula cannot be applied unchanged. One method is to update the balance monthly:

Vm=V(m−1)×(1+i)+PmV_m=V_(m-1)×(1+i)+P_m

Here, Vm is the month-end balance and Pm is that month’s contribution. Start with zero, apply one month’s assumed growth to the existing balance, then add the scheduled month-end contribution.

At the same assumed 1% monthly return:

ComponentAmount
Total contributions₹ 3,66,306
Estimated growth₹ 1,21,105
Estimated future value₹ 4,87,411

The higher corpus partly reflects larger contributions. It does not mean the step-up arrangement earned a higher percentage return.

The figures shown are for illustrative purpose only

How does compounding affect the SIP formula over time?

Under a constant positive-return assumption, earlier contributions have more periods to grow. Growth retained in the investment also contributes to subsequent growth.

For ₹5,000 contributed at each month-end, assuming 1% monthly:

DurationTotal contributionsEstimated future valueEstimated growth
Five years₹ 3,00,000₹ 4,08,348₹ 1,08,348
Ten years₹ 6,00,000₹ 11,50,193₹ 5,50,193
Fifteen years₹ 9,00,000₹ 24,97,901₹ 15,97,901

These figures illustrate constant-rate mathematics. Mutual funds do not credit fixed monthly interest, and a longer holding period does not guarantee profit.

An SIP calculator can illustrate regular contributions. Use a lumpsum calculator for an amount invested upfront.

Sources: SEBI Investor, Power of Compounding and Standard Compound Interest Calculator limitations.

The figures shown are for illustrative purpose only

The calculator is an aid, not a prediction tool. It may provide only an indicative picture.

How is actual SIP investment value calculated?

Actual investment value depends on units and NAV:

Units allotted = Amount applied to unit allotment /Applicable NAV

Investment value =Units held×Valuation-date NAV

Consider a separate illustration that ignores stamp duty and other charges:

InstalmentAmount investedApplicable NAVUnits allotted
1₹3,000₹30₹100
2₹3,000₹25₹120
3₹3,000₹40₹75
Total₹9,000—295

At a valuation-date NAV of ₹36, the holding is worth 295 × ₹36 = ₹10,620.

The applicable purchase NAV depends on transaction acceptance, availability of funds and relevant cut-off rules. The scheduled SIP date alone does not always determine the allotment NAV.

Sources: AMFI, Net Asset Value guidance; Cut-off Timings and New Rule on Applicable NAV.

The figures shown are for illustrative purpose only

CAGR vs XIRR: Which should you use to measure SIP returns?

Use a future-value formula for projections and an appropriate return measure for actual performance.

CAGR

Compound annual growth rate expresses the equivalent annual growth between a beginning and ending value:

CAGR=(Ending value /Beginning value )^(1/t)-1

It is useful for a single upfront investment without intervening cash flows, or for measuring NAV growth over a period.

Do not enter total SIP contributions as the beginning value in a CAGR calculator. That incorrectly treats later instalments as invested from the start.

Source: National Centre for Financial Education, Mutual Fund Performance educational material.

XIRR

Extended internal rate of return accounts for transaction amounts and dates, making it appropriate for measuring personal annualised returns across SIP instalments.

For the calculation:

  1. Enter investments as negative cash flows.
  2. Enter redemptions and cash distributions as positive cash flows.
  3. Add the remaining investment value as a positive amount on the valuation date.
  4. Supply the corresponding transaction dates.

An XIRR calculator performs the calculation. Excel uses:

=XIRR(values, dates)

Avoid counting a withdrawal or final value twice. Also interpret short-period XIRR cautiously: annualising a brief investment period can produce unusually large or small percentages.

Source: Microsoft Support, official XIRR function documentation on dated cash flows and the 365-day annualisation convention.

Absolute return

For an investment without withdrawals or cash distributions:

Absolute return=(Current value-Total contributions)/Total contributions ×100

Using the unit-allotment example:

(₹10,620-₹9,000)/₹9,000×100=18%

This measures the gain relative to contributions. It does not consider how long each instalment was invested and is not an annualised SIP return.

Source: National Centre for Financial Education, Mutual Fund Performance, Absolute Return Method.

The figures shown are for illustrative purpose only

What factors affect SIP calculations?

The main factors are:

  • Contribution amount and duration: These determine how much is invested and for how long.
  • Return assumption: A higher input increases projected value without making that outcome more likely.
  • Contribution timing: Month-start and month-end calculations differ.
  • Changes to payments: Step-ups, pauses and additional investments alter the cash flows.
  • NAV movements: Actual market performance determines allotments and subsequent investment value.
  • Costs and taxes: Exit loads and taxes can affect proceeds, while scheme expenses are already reflected in published NAVs.

For projections, establish whether the return assumption is before or after scheme expenses. Do not subtract those expenses again from actual NAV-based returns.

Sources: NISM, SIP Calculator guidance; AMFI, Expense Ratio and Net Asset Value guidance.

What mistakes should you avoid when calculating SIP returns?

Here are the common errors that can produce misleading results:

  • Calling the entire corpus a gain: Separate contributions from growth.
  • Mixing rate conventions: Match the annual-rate interpretation to the monthly conversion.
  • Ignoring payment timing: Specify when each contribution is invested.
  • Using a fixed-payment formula for step-ups: Account for the changing amounts.
  • Applying CAGR to aggregated contributions: Use dated cash flows for personal annualised returns.
  • Omitting transactions: Include withdrawals, distributions and remaining value in XIRR.
  • Treating estimates as guarantees: Compare projections with actual performance separately.

Conclusion

The SIP calculation formula estimates future value under stated contribution, timing and return assumptions. Step-up investments require changing-payment calculations, while actual value depends on units and NAV. Use XIRR to assess returns across dated transactions, and distinguish your contributions, projected growth and actual performance before evaluating progress towards a financial goal.

FAQs

Why do manual SIP calculations differ from calculator results?

Differences commonly arise from payment timing, annual-to-monthly rate conversion, instalment counts and rounding. Step-ups or skipped payments also change the result.

Is XIRR the same as the SIP calculator’s assumed return?

No. A calculator uses a chosen return to project value. XIRR derives an annualised return from dated transactions and the ending value. They can differ because of both performance and calculation conventions.

Does the SIP formula account for step-up SIPs?

The fixed-payment formula does not incorporate increases automatically. Use a changing-contribution calculation or calculate each contribution’s value at the target date.

How is CAGR different from absolute return in SIP?

Absolute return measures the gain relative to contributions without considering timing. CAGR annualises growth between beginning and ending values but should not be applied to aggregated SIP contributions. XIRR accounts for successive payment dates.

Related Searches

BSE MidcapNifty Microcap 250Nifty Midcap 150 Index
Nifty Next 50Gift NiftySemiconductor ETF
NSE HolidaysTax on Intraday TradingMicro Cap Mutual Funds

Start an SIP

Every long-term goal begins with a simple step. Explore mutual funds from Bajaj AMC and choose between equity, debt, hybrid and passive funds. Start an SIP to invest regularly, build consistency, and potentially achieve your financial goals.

Get A Call Back

Want help planning your investments?

Share your details and our experts will guide you.

By submitting my details, I agree to receive a call from
Bajaj AMC for assistance.

Grow wealth with mutual funds

Must Read

Different Types of STP in Mutual Funds
What is STP in Mutual Funds: Meaning, Types, Full Form & Benefits

An investment instrument that has gained popularity among investors is

GIFT Nifty
What is GIFT Nifty? Meaning of GIFT Nifty explained

GIFT Nifty refers to US dollar-denominated Nifty derivatives traded on

Nifty 50 Index Live Today

If you follow the Indian stock market, you have probably

Calculators

FAQs

Fund Collections

Disclaimer

Mutual Fund investments are subject to market risks, read all scheme related documents carefully.
This document should not be treated as endorsement of the views/opinions or as investment advice. This document should not be construed as a research report or a recommendation to buy or sell any security. This document is for information purpose only and should not be construed as a promise on minimum returns or safeguard of capital. This document alone is not sufficient and should not be used for the development or implementation of an investment strategy. The recipient should note and understand that the information provided above may not contain all the material aspects relevant for making an investment decision. Investors are advised to consult their own investment advisor before making any investment decision in light of their risk appetite, investment goals and horizon. This information is subject to change without any prior notice.
The content herein has been prepared on the basis of publicly available information believed to be reliable. However, Bajaj Asset Management Limited (formerly known as Bajaj Finserv Asset Management Limited) does not guarantee the accuracy of such information, assure its completeness or warrant such information will not be changed. The tax information (if any) in this article is based on prevailing laws at the time of publishing the article and is subject to change. Please consult a tax professional or refer to the latest regulations for up-to-date information.

Login/Signup