# XIRR Calculator from a CAS PDF

> Calculate the XIRR of your whole mutual fund portfolio from a CAMS or KFintech CAS PDF, without typing transactions into a spreadsheet.

XIRR is the right way to measure mutual fund returns when you invest through SIPs, lump sums, and partial redemptions at different dates. Computing it by hand means copying every transaction from your CAS into a spreadsheet. Portfolio Intel reads the transactions directly from the PDF.

[Calculate your XIRR on portfoliointel.co.in →](https://portfoliointel.co.in)

## Why XIRR and not absolute return

Absolute return divides total gain by total cost. It ignores time: ₹1 lakh invested five years ago and ₹1 lakh invested last month count the same. XIRR weights each rupee by how long it was invested, so a portfolio built through monthly SIPs gets a return you can compare with an FD rate or an index return.

For example, a SIP of ₹10,000 a month for five years puts in ₹6,00,000. If it is worth ₹8,50,000 today, the absolute return is 41.7%, but the XIRR is 13.9% a year: the last instalments were invested for only a month or two.

That example assumes the same amount on the same day every month. Your CAS has the real dates and amounts, including top-ups, missed instalments and redemptions, so the XIRR from your statement is the one to trust.

To see where a SIP could go from here, rather than what it has earned, use the [SIP calculator](https://portfoliointel.co.in/sip-calculator).

## How the calculation works

1. Each purchase, SIP instalment, and switch-in in the statement becomes a negative cash flow on its transaction date.
2. Each redemption and switch-out becomes a positive cash flow.
3. Stamp duty and other charges are excluded, since they are not investment decisions.
4. The current value of all holdings on the statement date is added as a final positive cash flow.
5. XIRR is the annual rate at which the present value of all these cash flows is zero.

If your statement starts after your first investment, the value of units you already held on the start date is treated as a purchase on that date. The result is then the XIRR for the statement period, not since inception.

## Getting an accurate number

- **Request a detailed CAS.** A summary CAS has no transactions, so XIRR cannot be computed.
- **Start the period from your first investment.** A shorter period gives the XIRR for that window only.
- **Include all folios.** The CAS covers all AMCs linked to your email, so check that every folio uses the same email address.

## Related guides

- [CAMS CAS statement analyser](https://docs.portfoliointel.co.in/guides/cams-cas-statement-analyser)
- [Compare your mutual funds against their benchmarks](https://docs.portfoliointel.co.in/guides/mutual-fund-benchmark-comparison)

Source: https://docs.portfoliointel.co.in/guides/xirr-from-cas-pdf/
