Return Analysis
XIRR, IRR & NPV Calculator
Add your actual investment and redemption dates to see your true annualised return — the same method your CAS statement uses.
Cash Flow Schedule
25/60Add every investment (outflow) and redemption / current value (inflow) with its actual date.
Cash Flow Timeline
Red bars = money out (investments) · Green bars = money in (redemptions / current value)
All Cash Flows
Chronological order — as used in the XIRR calculation
| Date | Type | Amount | Label |
|---|---|---|---|
| 05 Aug 24 | OUT | -₹10,000 | — |
| 05 Sept 24 | OUT | -₹10,000 | — |
| 05 Oct 24 | OUT | -₹10,000 | — |
| 05 Nov 24 | OUT | -₹10,000 | — |
| 05 Dec 24 | OUT | -₹10,000 | — |
| 05 Jan 25 | OUT | -₹10,000 | — |
| 05 Feb 25 | OUT | -₹10,000 | — |
| 05 Mar 25 | OUT | -₹10,000 | — |
| 05 Apr 25 | OUT | -₹10,000 | — |
| 05 May 25 | OUT | -₹10,000 | — |
| 05 Jun 25 | OUT | -₹10,000 | — |
| 05 Jul 25 | OUT | -₹10,000 | — |
| 05 Aug 25 | OUT | -₹10,000 | — |
| 05 Sept 25 | OUT | -₹10,000 | — |
| 05 Oct 25 | OUT | -₹10,000 | — |
| 05 Nov 25 | OUT | -₹10,000 | — |
| 05 Dec 25 | OUT | -₹10,000 | — |
| 05 Jan 26 | OUT | -₹10,000 | — |
| 05 Feb 26 | OUT | -₹10,000 | — |
| 05 Mar 26 | OUT | -₹10,000 | — |
| 05 Apr 26 | OUT | -₹10,000 | — |
| 05 May 26 | OUT | -₹10,000 | — |
| 05 Jun 26 | OUT | -₹10,000 | — |
| 05 Jul 26 | OUT | -₹10,000 | — |
| 19 Jul 26 | IN | +₹2.70 L | Current Value (Today) |
Why XIRR — not CAGR — is the right measure for SIPs
CAGR (Compound Annual Growth Rate) only works when there is exactly one investment and one redemption. A SIP has many instalments on different dates, so there is no single "invested amount" and "holding period" to plug into a CAGR formula. XIRR solves this by finding the single annualised rate that, when applied to every dated cash flow, discounts them all back to zero net present value — that is exactly what your AMC's CAS (Consolidated Account Statement) does to show your SIP return.
IRR is the same concept applied to equally-spaced periods (Year 0, Year 1, Year 2...) instead of real calendar dates — useful for simple annual projections. NPV takes the same cash flows and discounts them at a rate you choose, rather than solving for the rate — so a positive NPV tells you the flows beat your chosen rate, and a negative NPV tells you they fell short.
Want your actual portfolio's XIRR checked against your goals?
Share your contact — your Relationship Manager will review your real cash-flow history and walk you through what your XIRR means for your plan. AMFI-registered Mutual Fund Distributor (ARN-286886), zero obligation.
Calculator results are for illustration purposes only. Actual returns may vary based on market conditions, fund performance, and other factors. Mutual fund investments are subject to market risks. Read all scheme-related documents carefully before investing. Past performance does not guarantee future returns. XIRR is computed using the Newton-Raphson method on a 365-day-year basis, consistent with the convention used in Excel and AMC-issued CAS statements. IRR and NPV on the Year-wise tab assume equal (annual) intervals between cash flows.
Turn These Numbers Into Your Real Wealth
Get a personalized investment roadmap on WhatsApp in 30 seconds — our team will map these calculations to actual funds and a goal-based SIP plan, completely free.
Trustner Asset Services Pvt. Ltd. · AMFI ARN-286886 · No obligation, no charges
Related Calculators
Explore more tools that pair well with this one
TVM Calculator
The universal time-value-of-money solver — find any of PV, FV, payment, rate, or tenure from the other four.
Compound Interest Calculator
Maturity value at any compounding frequency, with a Rule-of-72 doubling timeline and simple-vs-compound comparison.
CAGR & Returns Calculator
Convert between absolute return and CAGR — and see why a 100% gain over 6 years is only ~12% a year.
SIP Future Value Calculator
Calculate how much your monthly SIP will grow over time with the power of compounding.
Retirement SIP Planner
Calculate the monthly SIP needed for your retirement corpus.