Mutual Fund Returns Calculator: XIRR, CAGR & SIP Returns in Excel

Mutual Fund Returns Calculator: XIRR, CAGR & SIP Returns in Excel

“How much have I actually earned?”

It sounds like a simple question. But the answer can be surprisingly different from the profit percentage you see on your screen. For example, if you have invested ₹6 lakh through SIPs and your investment is now worth ₹7.5 lakh, you have made a ₹1.5 lakh gain. But does that mean you earned 25% every year?

No.

Your first SIP instalment may have been invested several years ago, while your latest instalment may have been invested only last month. Each rupee has therefore been working for a different length of time.

That’s where things like CAGR and XIRR become useful. If you invested a lump sum and simply want to know how it grew over several years, CAGR is usually the number to look at.

But if you invest through SIPs, make additional investments, increase your SIP, or withdraw some money along the way, XIRR can give you a much more meaningful picture of the return you actually earned on your money.

And you don’t need to be an Excel expert to work it out.

In this guide, I’ll show you how to calculate mutual fund returns using absolute return, CAGR and XIRR, how to calculate SIP returns in Excel, and which method you should use depending on the way you invested.

If you’re also deciding which mutual funds or SIP categories to invest in, you can explore our guide to Best Mutual Funds to Invest in 2026 for a separate discussion on fund categories, risk and investment horizons.

Use the ArthikDisha Mutual Fund Returns Calculator to calculate:

• Total investment and current/final value
• Absolute gain and absolute return
• CAGR for lump-sum investments
• XIRR for SIPs and multiple cash flows
• Estimated SIP and Step-Up SIP future value

Important: A calculator showing an assumed future return is only a projection. It is not a guarantee of future mutual fund performance.

Important: The future value is only an estimate based on the return you enter. Actual mutual fund returns can be higher or lower.

How to use: Select the calculation type, enter your investment details, click Calculate, and download your personalised PDF report.

Quick Checkout: Which Return Should You Use?

CAGR and XIRR answer different questions: CAGR is designed for a single beginning and ending value, while XIRR incorporates dated cash flows.

Mutual Fund Returns Calculator: What Does It Calculate?

A useful mutual fund returns calculator should show more than one percentage because different return measures answer different questions.

1. Total Investment

The total amount you have actually invested.

For example:

₹10,000 monthly SIP × 60 months = ₹6,00,000 invested

2. Current Value

The present value of your mutual fund holdings.

3. Absolute Gain

Absolute Gain = Current Value − Total Investment

If you invested ₹6,00,000 and your current value is ₹8,00,000:

Absolute Gain = ₹2,00,000

4. Absolute Return

Absolute Return = (Current Value − Investment) ÷ Investment × 100

In this example:

₹2,00,000 ÷ ₹6,00,000 × 100 = 33.33%

But 33.33% does not mean that you earned 33.33% every year.

That is where CAGR and XIRR become important.

CAGR vs XIRR vs Absolute Return

Many mutual-fund investors confuse these three measures. They should not be used interchangeably.

Simple rule

Lump sum → CAGR

SIP/multiple dated cash flows → XIRR

Simple total gain → Absolute Return

This distinction is more useful than simply saying that one method is “better” than another.

How to Calculate Mutual Fund Returns

The calculation depends on how you invested.

Case 1: Lump-Sum Investment

Suppose you invested:

• Initial investment: ₹1,00,000
• Current value: ₹1,80,000
• Holding period: 5 years

Your absolute gain is:

₹1,80,000 − ₹1,00,000 = ₹80,000

Your absolute return is:

80%

But the annualised return is lower because the money was invested for five years.

CAGR Formula

CAGR = (Ending Value ÷ Beginning Value)^(1 ÷ Number of Years) − 1

Therefore:

CAGR = (₹1,80,000 ÷ ₹1,00,000)^(1/5) − 1

≈ 12.47% p.a.

CAGR is designed to express the compounded annual growth rate between a beginning value and an ending value.

Case 2: SIP Investment

Now suppose you invest:

₹10,000 every month for 5 years

Your total investment is:

₹10,000 × 60 = ₹6,00,000

But your January investment has been invested for much longer than your December investment. Therefore, treating the entire ₹6 lakh as though it were invested on Day 1 would distort the annualised return.

What Is XIRR in Mutual Funds?

XIRR stands for Extended Internal Rate of Return.

It calculates an annualised return when cash flows occur on different dates.

This makes it useful for:

• SIP investments
• Additional purchases
• SIP top-ups
• Partial withdrawals
• Redemptions
• Multiple investments
• Portfolio-level cash flows

Excel’s XIRR function uses the cash-flow values together with their corresponding dates. It requires at least one negative and one positive cash flow.

In simple language

Think of XIRR as asking:

“What annual rate of return would make all these investments and the final value balance out, considering exactly when each cash flow occurred?”

That is why XIRR can be very different from a simple percentage gain.

How to Calculate XIRR in Excel

You need two columns:

The investment cash flows are entered as negative values because they represent money going out.

The current/final value is entered as positive because it represents money received or the value available to you.

Excel Formula

=XIRR(B2:B14,A2:A14)

Where:

• Column A contains the dates
• Column B contains the cash flows

Microsoft’s official syntax is:

=XIRR(values, dates, [guess])

The optional guess parameter is normally unnecessary because Excel uses a default estimate.

XIRR Example for a SIP

Suppose you invest ₹10,000 every month.

After making 12 investments:

Total invested = ₹1,20,000

Suppose the value of the investment on the calculation date is ₹1,45,000

Your absolute gain is: ₹25,000

Your absolute return is: 20.83%

But 20.83% is not your annualised return. Because the full ₹1,20,000 was not invested for the entire period. The XIRR calculation considers the actual dates of all 12 investments and the final value.

Example cash-flow table

The exact XIRR depends on these dates and cash flows. The important lesson is that you should not calculate SIP annualised returns simply by dividing your gain by your total investment.

Why Your SIP Return Can Look Different From the Fund’s Return

This is an important point that many calculator pages do not explain clearly.

A mutual fund may report a fund-level return based on its own performance methodology.

Your personal return can be different because you did not own the fund continuously with the same amount of money.

For example:

• You started your SIP six months ago.
• Another investor started five years ago.
• The fund’s published return may be the same for both investors.
• Their personal XIRRs can be very different.

Your investment timing matters.

Therefore:

Fund performance and investor return are not necessarily the same thing.

SIP Returns Calculator vs XIRR Calculator

SIP Calculator

A SIP calculator generally answers:

“If I invest ₹10,000 every month and earn an assumed return of X%, what could my investment become after Y years?”

It is a future-value projection.

XIRR Calculator

An XIRR calculator answers:

“Given the actual dates and amounts I invested and the current value of my investment, what annualised return did I actually earn?”

It is an actual-return calculation.

₹5,000 Monthly SIP Example

Suppose you invest: ₹5,000 per month for 10 years. Total amount invested: ₹6,00,000

If a calculator assumes a hypothetical 12% annual return, the projected corpus can be calculated using a SIP future-value formula.

But remember:

12% is an assumption, not a guaranteed mutual fund return.

A projection calculator and an XIRR calculator answer different questions.

Planning question

“How much could ₹5,000 per month become?”

→ Use a SIP calculator.

Performance question

“What annualised return did my actual SIP earn?”

→ Use XIRR.

₹10,000 Monthly SIP: Compare Return Scenarios

Suppose you invest ₹10,000 per month for 10 years, for a total investment of ₹12,00,000. You can use the calculator to see how the projected corpus changes under different assumed return scenarios.

These are illustrative assumptions only, not predictions.

SIP vs Lump-Sum Investment

Another useful comparison is between regular investing and a one-time investment.

Suppose an investor has ₹6 lakh available.

Option A: Invest ₹6 lakh immediately

The entire amount participates in market movements from the beginning.

Option B: Invest ₹50,000 per month for 12 months

The money enters the market gradually.

The eventual value can therefore be different even though the total amount invested is the same.

Do not assume that SIP will always produce a higher or lower return. The outcome depends on market performance and timing.

Once you understand how your return is measured, the next question is which funds may suit your goals and risk profile. See our guide to Best Mutual Funds to Invest in 2026 for a separate discussion of fund categories, risk and investment horizons.

Step-Up SIP: A Feature Worth Adding

Many real investors do not keep their SIP unchanged for 10 or 20 years.

They increase it when their income rises.

For example:

Year 1: ₹10,000/month
Year 2: ₹11,000/month
Year 3: ₹12,100/month

This is a 10% annual step-up SIP.

The ArthikDisha calculator lets you compare:

• Flat SIP
• Step-up SIP
• Total investment
• Estimated corpus
• Estimated gain

This is a useful differentiator because a large number of generic calculators stop at a fixed monthly SIP.

How to Calculate Mutual Fund Returns in Excel

Excel can handle both lump-sum and multiple-cash-flow calculations.

CAGR Formula for Lump Sum

Let’s say:

• B2 = Initial investment
• B3 = Current value
• B4 = Number of years

Use:

=(B3/B2)^(1/B4)-1

Format the result as a percentage.

XIRR Formula for SIP

Suppose:

• Column A = investment dates
• Column B = cash flows

Use:

=XIRR(B2:B14,A2:A14)

For an actual portfolio, include every relevant investment, withdrawal and the current/final value.

Excel XIRR: The Correct Sign Convention

One of the most common errors is entering all amounts as positive numbers. Don’t do this.

Correct

Why? Because XIRR is based on the investor’s cash-flow perspective. Money paid into the investment is an outflow.

Money received from the investment is an inflow. Excel requires at least one positive and one negative cash flow for XIRR to produce a solution.

Common XIRR Errors in Excel

1. #NUM! Error

Possible reasons include:

• No positive cash flow
• No negative cash flow
• Incorrect dates
• Mismatched ranges
• A cash-flow pattern for which Excel cannot find a solution

Microsoft specifically notes that XIRR can return #NUM! when the cash flows do not contain both positive and negative values or when a valid solution cannot be found.

2. #VALUE! Error

Check whether your dates are recognised by Excel as actual dates rather than text.

3. Wrong Range

The number of cash-flow values and dates must correspond.

4. Missing Transactions

If you omit an SIP, redemption or additional investment, your XIRR can be wrong.

5. Wrong Current Value Date

The final/current value should be entered against the date on which you are measuring the portfolio.

Can XIRR Be Used for Partial Withdrawals?

Yes.

Suppose you:

• Invest ₹10,000 monthly
• Continue investing
• Withdraw ₹50,000 midway
• Continue the SIP
• Have a current portfolio value

The withdrawal is a positive cash flow from your perspective.

XIRR can therefore incorporate the withdrawal along with the investments and current value.

This is one of the biggest advantages of using dated cash flows rather than a simple SIP return formula.

Can XIRR Be Used for SIP Top-Ups?

Yes.

Suppose your SIP is: ₹10,000 initially and later becomes: ₹12,000

Then: ₹15,000. You don’t need a special mathematical formula for the actual return.

Enter each actual investment with its actual date and amount, and use XIRR.

CAGR vs XIRR: A Practical Example

Consider two investors: Investor A & Investor B

Investor A invests ₹1,00,000 as a lump sum → CAGR.
Investor B invests ₹10,000 monthly → XIRR.
Even though both eventually invest ₹1 lakh and reach ₹1.8 lakh, their annualised returns can differ because the timing of the investments is different.

Absolute Return Can Be Misleading for SIPs

Suppose:

Total invested = ₹6,00,000 , Current value = ₹7,20,000

Absolute gain: ₹1,20,000, Absolute return: 20%

20% absolute return does not tell you the annualised return when investments have different holding periods.

Mutual Fund Return After Tax

Your investment return and tax liability are two different things. A mutual fund may generate a capital gain, but the gross return shown by your investment does not necessarily equal the amount you finally retain after applicable taxes, if any.

To understand how mutual fund gains may be taxed, see our guide to Short-Term Capital Gain Tax on Shares & Mutual Funds. You can also refer to the Income Tax Department’s guidance on capital gains for official tax information.

Thus, Capital Gains depend on the following parameters:

• Fund type
• Equity/debt classification
• Holding period
• Nature of gain
• Applicable tax rules
• Exemptions/thresholds
• Date of transaction

If you want to estimate your overall income-tax liability alongside your investment planning, you can also use the ArthikDisha Tax Utility, which combines online tax calculation, Old vs New Tax Regime comparison, capital gains and downloadable tax reports.

Mutual Fund Returns Calculator: What Should You Compare?

Don’t compare funds simply because one shows a higher percentage.

Consider:

NB: A fund’s past return is not a promise of future performance.

7 Common Mistakes Investors Make

Mistake 1: Using CAGR for a SIP

A SIP involves multiple cash flows. For actual annualised SIP performance, XIRR is generally more appropriate.

Mistake 2: Looking only at absolute return

A 30% gain over six months is very different from a 30% gain over five years.

Mistake 3: Ignoring dates

XIRR depends on the timing of cash flows.

Mistake 4: Entering investments as positive numbers

Investment outflows should normally be negative in the XIRR cash-flow table.

Mistake 5: Using estimated returns as guaranteed returns

A SIP calculator is a projection tool. It cannot predict the actual future market return.

Mistake 6: Comparing your XIRR directly with a fund’s headline return

Your cash-flow timing can be different from the period used for the fund’s reported performance.

Mistake 7: Ignoring tax and inflation

A nominal return does not automatically represent your final purchasing-power gain.

Which Is Better: CAGR or XIRR?

Neither is universally “better.” The correct question is:

Which measure matches my cash-flow pattern?

Use CAGR when:

• You invested a lump sum.
• You have a clear beginning value.
• You have a clear ending value.
• You want annualised compounded growth.

Use XIRR when:

• You invest through SIPs.
• You made multiple purchases.
• You made investments on different dates.
• You have withdrawals/redemptions.
• You want a personal portfolio return.

Use Absolute Return when:

• You want to know the simple total gain.
• You are looking at a short period.
• You don’t need an annualised return.

Mutual Fund Returns Calculator: Quick Decision Guide

Final Takeaway

The biggest mistake in mutual fund return calculation is trying to use one return formula for every type of investment.

Remember:

Lump sum → CAGR

SIP / multiple dated cash flows → XIRR

Total gain → Absolute Return

And if you are planning a future investment:

SIP Calculator → projected future value

The ArthikDisha Mutual Fund Returns Calculator is designed to bring these calculations together so that you can understand not only how much your investment has grown, but also how that return should actually be measured.

Disclosure

The examples in this article are for educational and illustrative purposes only. Projected mutual fund returns are not guaranteed. Actual returns depend on market performance, investment timing, costs, taxes and other factors. Always verify your transaction dates, amounts and current portfolio value before calculating XIRR.