Originally published 16 October 2026. This educational article reflects its publication date; check current rules and suitability before taking action.
Your mutual fund app may show a profit in rupees, an absolute return and an annualised return. Those numbers answer different questions. Absolute return describes the overall percentage change for a simple investment. CAGR expresses growth as an equivalent compounded annual rate for a single starting investment. XIRR considers the amounts and dates of multiple cash flows, making it useful for analysing an investor’s SIP history.
The important first step is to identify which number you are reading. A high percentage without a time period, cash-flow history or risk context tells you surprisingly little.
For families, salaried investors and business owners, this is a practical guide to reading performance more carefully. It is general education, not a recommendation to buy, sell or switch a scheme.
Begin with the rupees
Suppose a hypothetical investor puts ₹1,00,000 into an investment and later sees a value of ₹1,20,000, with no additions or withdrawals. The increase is ₹20,000. That rupee figure is easy to understand, but it does not describe how long the money was invested.
The same ₹20,000 gain over one year and over five years represents very different experiences. Nor does it reveal how much the investment fluctuated along the way. Start with the amount, then add the period and the method of calculation.
If your account includes withdrawals, distributions or transfers, simply subtracting total deposits from the current value may give an incomplete picture. Money already received also belongs in the review. Keep the transaction record beside the dashboard.
Absolute return: the total change
For a single investment with no intervening cash flows, absolute return is the gain or loss divided by the original amount, multiplied by 100. In the example above, ₹20,000 divided by ₹1,00,000 gives 20%.
That is a total-period return. It is not automatically 20% per year. A dashboard should make the period clear, and the reader should resist adding an annual meaning that is not there.
For an account with repeated contributions, an app may show a gain as a percentage of total contributions. That can describe the size of the gain relative to money put in, but it ignores how long each instalment was invested. A contribution made last month has not had the same time in the market as one made five years ago.
Ask your provider how its displayed absolute-return figure treats redemptions and distributions. Platforms can use different labels and calculation conventions.

Editorial illustration: a return should be read alongside its period and cash-flow record. Any depicted charts are illustrative, not investment performance.
CAGR: an equivalent annual growth rate
CAGR stands for compound annual growth rate. For one starting investment and one ending value, it answers: what constant compounded annual rate would connect those two values over this period?
Imagine ₹1,00,000 becoming ₹1,21,000 over exactly two years, with no cash flows in between. The absolute return is 21%. The CAGR is 10%, because ₹1,00,000 multiplied by 1.10 and then by 1.10 becomes ₹1,21,000.
This does not mean the investment actually earned 10% in each year. It might have fallen in one year and recovered in the next. CAGR compresses the journey into an equivalent rate; it does not describe the journey’s smoothness.
The formula is ending value divided by beginning value, raised to the power of one divided by the number of years, minus one. The calculation becomes less intuitive when substantial contributions or withdrawals occur between the start and finish. That is where a cash-flow-aware measure is helpful.
XIRR: the timing of your money matters
XIRR is an annualised, money-weighted return calculated from dated cash flows. Contributions are usually entered as negative amounts from the investor’s perspective. Withdrawals and distributions received are positive. The value remaining on the valuation date is entered as a final positive amount for measurement, even if it has not actually been redeemed.
Microsoft’s XIRR function is designed for cash flows that are not necessarily periodic. It needs at least one positive and one negative value, matching dates and sensible data. Its calculation uses a 365-day year.
For a SIP, every instalment has its own investment date. An occasional top-up or withdrawal adds another dated cash flow. XIRR uses that history instead of pretending all contributions were invested on the first day.
The result is still a historical calculation. It is not a promised interest rate, a forecast or a guarantee that future instalments will earn the same return.
A simple case: identical totals, different timing
This is a hypothetical illustration, not a Bright Vision client result.
Investor A contributes ₹1,20,000 at the beginning of a period. Investor B contributes the same total through instalments spread across that period. At the end, both accounts are worth ₹1,32,000. Each shows a ₹12,000 gain, or 10% of the contributed amount.
It would be misleading to conclude that the annualised investor experience was identical. Investor B’s later instalments were invested for less time. To calculate and compare their money-weighted returns, we need the exact dates and values of every relevant cash flow.
We deliberately do not attach an XIRR percentage to this example. Without those dates, an exact answer would be invented. That is a useful discipline to carry into real portfolio reviews: request the missing information before trusting a precise-looking number.
Build a clean calculation record
Create a table with a date column, an amount column and a short description. Include actual purchase transactions, additional investments, withdrawals and cash distributions as appropriate to the scope you are analysing.
Add the current value on a single, clearly stated valuation date. Avoid mixing one scheme’s value from Monday with another scheme’s value from Friday. Use actual transaction records rather than bank debits alone, because the investment transaction date may differ from the debit date.
For a spreadsheet, an illustrative formula is =XIRR(B2:B10,A2:A10), where column B contains signed amounts and column A contains corresponding dates. Adjust the range to your own data. Check that dates are recognised as dates rather than text.
Do not enter the final value twice, count a failed SIP as an investment, or forget a redemption. A spreadsheet can calculate a confident answer from an incorrect table.

Conceptual illustration: organise dated transactions before calculating returns. No real investor information is shown.
Define what sits inside your portfolio
A switch may look like a withdrawal from one scheme and an investment into another. At the individual-scheme level, those flows matter. At the combined-portfolio level, an internal transfer should not be treated as new money arriving from outside or leaving the portfolio.
Write the scope at the top of your worksheet: one folio, one scheme, all mutual funds, or a broader household portfolio. Then apply it consistently. This helps prevent double-counting when money moves between holdings.
Likewise, a distribution reinvested within the same defined portfolio needs careful treatment. Ask the statement provider or a qualified professional to help reconcile transactions if the record is complex. Changing signs until a spreadsheet produces an attractive number is not reconciliation.
Why your return can differ from the fund’s return
A scheme’s published performance and your personal XIRR need not match. You may have invested on different dates, added money after a rise, withdrawn before a fall or held a different plan or option from the one shown in the comparison.
First compare the same scheme, plan, option, period and valuation date. Read the performance methodology and benchmark information in the official factsheet. An investor’s cash-flow-weighted experience is a different measure from the published return of a scheme over a defined period.
This difference alone does not prove that the app is wrong or that the fund performed badly. It is a reason to investigate the inputs and calculation method.
Four comparisons that can mislead
Different time periods. A one-year result and a five-year annualised result describe different market experiences. Label them clearly rather than placing them side by side without explanation.
Very short histories. Annualising a brief gain or loss can produce a dramatic-looking number. It should not be interpreted as a reliable estimate of what the next year will deliver.
Different risks. A return comparison without asset allocation, volatility, liquidity and investment-objective context can reward a risk you did not intend to take.
Different cash-flow treatment. One report may include exited investments while another shows only current holdings. Both can be internally consistent while answering different questions. Ask what is included.
Before comparing percentages, compare the question each percentage answers.
An editorial rule of thumb for reviewing investment reports.
Use the number to improve the conversation
A review meeting should connect performance to the purpose of the investment. Has the goal amount changed? Is the time available shorter? Are contributions still affordable? Has the household’s need for accessible money increased?
A return number cannot answer those questions. It can help you understand what happened, but suitability requires a broader discussion. Avoid switching solely because a recent ranking looks more attractive. Costs, tax consequences, risk and the original objective also need consideration.
Keep a short review note recording the valuation date, calculation method, transactions checked and questions still open. That creates continuity between reviews and makes unexplained changes easier to investigate.

Illustrative financial discussion, not a photograph of a client consultation or a performance testimonial.
Frequently asked questions
Is XIRR better than CAGR?
Neither is universally better. CAGR is useful for a single starting value and ending value without intervening flows. XIRR is useful when amounts enter or leave on different dates. Choose the measure that fits the question.
Can I average the XIRRs of my funds?
A simple average generally does not produce the portfolio XIRR. Calculate the combined portfolio from its external dated cash flows and ending value. The amounts and timing matter.
Why does XIRR show an error?
Check signs, dates, matching ranges and whether the cash flows support a solution. Some cash-flow patterns can produce calculation difficulties or multiple possible rates. An error needs investigation, not a guessed replacement.
Does a positive return mean I have met my goal?
No. You also need to consider the amount accumulated, time remaining, inflation, costs and the goal itself. A positive percentage can coexist with a funding shortfall.
Read performance with context
The next time you open your investment app, identify four things: the rupee result, the period, the cash flows and the method. That small habit can turn a confusing dashboard into a useful starting point for discussion.
Bright Vision Investment Services encourages investors to bring questions and complete records to a review. Understanding a calculation is part of making an informed decision; it does not remove investment risk. Mutual fund investments are subject to market risks. Read all scheme-related documents carefully.
Further reading
See Microsoft’s XIRR documentation for spreadsheet mechanics and the AMFI investor resource centre for mutual fund education. Consult the relevant scheme’s official documents for its actual performance methodology, risks and terms. All numerical illustrations above are hypothetical and exclude transaction-specific taxes or charges unless stated.
Explore more perspectives or talk to Bright Vision about your financial goals.
Explore all insights


