A SIP creates a series of investments at different dates. Dividing total profit by total contributions gives an absolute return, but it does not reflect how long each instalment was invested. That is why an annualised money-weighted measure such as XIRR can tell a different story.

Calculate the basic figures first

Suppose a learner invests ₹10,000 on each of three monthly dates. Total contributions are ₹30,000. If the portfolio is valued at ₹31,200 on a later measurement date, the gain is ₹1,200 and the simple absolute return is 4%.

That 4% is not automatically an annual return. The first instalment has been invested longer than the third, and the measurement date changes the elapsed time.

Understand XIRR’s inputs

XIRR uses dated cash flows to estimate an annualised rate consistent with those flows. In a typical investor worksheet, contributions are negative cash flows and withdrawals or the closing portfolio value are positive cash flows.

Use the actual dates and ensure that the closing value is entered once. Missing a withdrawal, duplicating the final value or reversing a sign can materially change the result. Some unusual cash-flow patterns can produce multiple solutions or no useful solution.

Avoid short-period exaggeration

Annualisation can make a short observation look dramatic. A large annualised figure over a small number of weeks does not mean the same growth will continue for a year.

Compare investments using compatible measures and periods. A fund’s published time-weighted performance and an individual investor’s money-weighted return answer different questions because contribution timing affects the latter.

Build a verification exercise

Create a table with date, contribution, withdrawal and closing value. First reconcile the total amount invested with account statements. Then calculate absolute return and XIRR, explicitly labelling each measure.

Check whether transaction costs and taxes are included in the reported values. Do not treat a worksheet result as a promise of future performance or proof that the investment suits your goals.

Is XIRR always better than absolute return?

They answer different questions. Absolute return describes a simple gain relative to contributions; XIRR incorporates dated cash flows and annualisation.

Does a SIP prevent losses?

No. A SIP is a method of investing; the underlying product can lose value.

Build mutual-fund foundations with FinDraft and consult SEBI’s learning resources.

Official learning references

Educational content only; not personalised investment advice or a recommendation. Investments and trading involve risk. All numerical examples are hypothetical. FinDraft provides independent preparation; official NISM examinations and certifications are administered by NISM.