XIRR Calculator
Calculate extended internal rate of return (XIRR) for irregular cash flows with different dates — ideal for SIPs, partial redemptions and real portfolios.
Client-Side Execution & Privacy Guarantee
Calculations run locally in your web browser. The amounts, rates, and other figures you enter are not sent to our servers. This calculator is for educational estimates only and is not personalized financial advice.
Measuring the exact performance of your investments is easy when you invest a lump sum once. But real-world investing is messy: you start SIPs, make ad-hoc lumpsum additions during market dips, and occasionally redeem funds. Standard metrics like CAGR fail here. The Extended Internal Rate of Return (XIRR) solves this by assigning an exact date to every single cash flow, giving you the true, annualized rate of return for your complex portfolio. The Codepackr Finance XIRR Calculator handles this complex iterative math instantly in your browser.
Your privacy is our priority—your financial dates and amounts never leave your device. Please note that XIRR uses an iterative algorithmic calculation to find the discount rate that makes the net present value of all cash flows zero. The output is an estimate of your annualized returns based purely on the data you enter. This tool is intended for educational and analytical purposes and does not constitute financial or investment advice. Always verify returns with official consolidated account statements.
Why CAGR is Not Enough
Compound Annual Growth Rate (CAGR) measures the return from a single starting point to a single ending point. If you invest via SIP, every monthly installment is invested for a different length of time.
Using CAGR on a SIP or a multi-transaction portfolio will give wildly inaccurate results. XIRR is required because it calculates the specific annualized return for each individual cash flow based on the exact number of days it remained invested.
Positive vs. Negative Cash Flows
To calculate XIRR accurately, the direction of the money matters. Money leaving your bank account (investments, purchases) must be entered as a negative number. Money returning to you (redemptions, dividends) is positive.
The final, current value of your portfolio is also treated as a positive cash flow on today's date, representing what you would receive if you sold everything right now.
Interpreting XIRR Results
XIRR is an annualized figure. If your XIRR is 12%, it means your money grew at a pace equivalent to earning a flat 12% a year. However, for investments less than a year old, XIRR can look deceptively large or small.
For example, a 5% absolute gain in just one month annualizes to a massive XIRR, which isn't sustainable. It is best to use XIRR to evaluate investments that have been active for at least one full year.
When to use this calculator
- Evaluating the true annualized return of a mutual fund SIP.
- Consolidating multiple buys and partial sells of a specific stock.
- Accounting for dividend payouts that were not reinvested.
- Comparing the performance of different complex portfolios.
How to use the XIRR Calculator
- Enter the date of your first investment and the amount as a negative number.
- Add rows for every subsequent investment (negative amounts) or redemption/dividend payout (positive amounts).
- In the final row, enter today's date (or evaluation date) and the current market value of the investment as a positive number.
- Click calculate to run the iterative algorithm and find your exact XIRR.
- Ensure there is at least one negative and one positive cash flow, otherwise XIRR cannot be calculated.
Worked examples
Standard Monthly SIP
Input
Jan 1: -10000, Feb 1: -10000, Mar 1: -10000, Apr 1 (Current Value): +32000
Output
XIRR is about 47% when the four cash flows are spaced one month apart (or about 47.8% using an actual 90-day span in a non-leap year).
A short three-month window can produce a very high annualized rate even when the cash profit is modest. XIRR is more meaningful over a year or longer. This is for informational purposes only and is not financial advice.
Lump Sum with Partial Redemption
Input
Jan 1, 2022: -100,000, Jan 1, 2023: +20,000 (Sold partial), Jan 1, 2024 (Current Value): +95,000
Output
XIRR is about 8.0% (approximately 7.98%).
The cash flows are −₹1,00,000 at the start, +₹20,000 after one year, and +₹95,000 after two years. That path compounds at about 8%, not 10%. A 10% XIRR would require a different terminal value (₹99,000 if the other flows stay the same).
Common mistakes and tips
- Always use negative signs for investments and positive signs for redemptions and current value.
- Don't forget to include dividend payouts as positive cash flows on the date they hit your bank account.
- Ignore XIRR for investments less than 6-12 months old; use absolute returns instead.
- Ensure exact dates are used. Moving an investment date by a few days can significantly alter the final percentage.
Frequently asked questions
What is the difference between XIRR and IRR?
IRR assumes regular, evenly spaced cash flows (like exactly monthly or yearly). XIRR is an extension that handles irregular cash flows occurring on specific, arbitrary dates.
Why is my XIRR showing an error?
XIRR requires at least one negative cash flow (investment) and at least one positive cash flow (redemption or current value). Without both, the formula cannot resolve.
Why is my XIRR negative?
A negative XIRR means you have lost money. The total value of your redemptions and current portfolio is less than the total amount you invested.
Should I use XIRR for stock portfolios?
Yes, XIRR is the most accurate way to measure personal stock portfolio returns, provided you track every buy, sell, and dividend date accurately.
Can XIRR be falsely inflated?
Yes, short-duration investments with high absolute returns will result in extremely high, unsustainable XIRR numbers because the math forces an annualization.
Related Investments Calculators
- SIP Calculator — Calculate Systematic Investment Plan (SIP) returns, wealth accumulation, and annual step-up compounding.
- Lumpsum Investment Calculator — Compute compound growth, maturity wealth, and inflation-adjusted real purchasing power for one-time investments.
- CAGR Calculator (Compound Annual Growth) — Calculate Compound Annual Growth Rate, annualized geometric returns, capital multiples, and holding trajectories.
- ROI Calculator (Return on Investment) — Calculate net return on investment, annualized holding period return, and capital multiples after fees.
- Compound Interest Calculator — Calculate compound interest growth with periodic deposits, flexible compounding frequencies, and APY rates.
- FD Calculator (Fixed Deposit) — Calculate fixed deposit maturity with monthly/quarterly/yearly compounding, senior citizen rates, pre/post-tax returns, TDS and inflation-adjusted real value.
- RD Calculator (Recurring Deposit) — Project recurring deposit maturity from monthly deposits with quarterly compounding, optional annual step-up and senior citizen rates.
- SWP Calculator (Systematic Withdrawal) — Project corpus drawdown under systematic monthly withdrawals with optional inflation step-up, survival years and year-wise balance.