Calculators · Investing
XIRR calculator
Use this XIRR calculator to find the annualised return on investments made on different dates, such as SIP instalments, lumpsums and partial withdrawals. Enter each cash flow with its date and today's value.
Worth · Planning Tools
Seven calculators for the money questions people actually ask
Educational tools built on standard formulas. Every figure below is illustrative, computed from the inputs you enter — not a projection, recommendation or guarantee.
SIP Calculator
The future value of a monthly SIP over your chosen horizon, assuming a constant expected rate of return. Instalments are treated as invested at the start of each month.
Your inputs
- Total invested
- —
- Wealth gained
- —
- Absolute return
- —
- Instalments paid
- —
Mandatory disclaimerThis calculator uses an assumed constant return rate for illustration. Actual mutual fund returns vary with market conditions and are not guaranteed. Past performance is not indicative of future results.
Mutual Fund Returns Calculator
What a mutual fund investment could grow to — a one-time amount, a monthly SIP, or both running together. Add an annual step-up if you plan to raise your SIP as your income grows, and see what the final value is worth in today's money.
What you invest
Assumptions
- Total invested
- —
- Wealth gained
- —
- Absolute return
- —
- From the one-time investment
- —
- From the SIP instalments
- —
- Annualised return (XIRR)
- —
- Value in today's money
- —
Both legs grow at the same effective annual rate you enter: the one-time amount compounds annually, and SIP instalments compound monthly at the equivalent monthly rate, (1 + r)^(1/12) − 1. The annualised return is a true XIRR across every cash flow, so it matches your assumed rate and accounts for the fact that later instalments have less time to grow.
Mandatory disclaimerThis calculator uses an assumed constant return rate for illustration. Actual mutual fund returns vary with market conditions, scheme selection and asset allocation, and are not guaranteed. Expense ratio, exit load and capital gains tax are not modelled here and will reduce what you actually receive. Past performance is not indicative of future results.
XIRR Calculator
Annualised return on investments with irregular cash flows — multiple SIPs, lump sums or withdrawals on different dates. Enter investments as negative amounts and redemptions or current value as positive.
Cash flows
| Date | Amount (₹) |
|---|
Negative = money in (SIP, lump sum). Positive = money out (redemption) or today's portfolio value. The last row is normally your current value.
- Total invested
- —
- Total withdrawn / current value
- —
- Absolute gain / loss
- —
- Holding period
- —
Mandatory disclaimerXIRR calculates the annualised return of investments made at different dates. This is the standard metric used to evaluate returns on SIPs and irregular investments. Results are for illustration and depend entirely on values you input.
Retirement Calculator
The corpus needed to sustain your lifestyle after retirement, and the monthly SIP required to build it. Expenses are inflated to your retirement date, then funded using an inflation-adjusted real return through retirement.
About you
Assumptions
- Years until retirement
- —
- Monthly expenses at retirement
- —
- Corpus needed at retirement
- —
- Real return during retirement
- —
- Years funded in retirement
- —
Mandatory disclaimerThis calculator uses assumed return and inflation rates for illustration. Actual returns depend on market conditions and asset allocation. Retirement planning should account for healthcare, dependents and individual circumstances not modelled here. Consult a SEBI Registered Investment Adviser for personalised planning.
Emergency Fund Calculator
How large your emergency fund should be, based on monthly expenses, dependents, how stable your income is, and whether insurance already covers your biggest risks.
Your situation
Park this amount somewhere you can reach within a day or two — a liquid mutual fund or a savings account — rather than in anything with a lock-in or market risk.
Mandatory disclaimerEmergency fund recommendations vary by personal circumstances. This calculator provides general guidance. It is not personalised financial advice. Consider your individual liquidity needs, existing insurance coverage and family obligations.
SWP Calculator
How long a corpus lasts if you withdraw a fixed amount each period, with the remaining balance still earning a return. Returns are applied first, then the withdrawal is taken.
Your inputs
- Total withdrawn over the period
- —
- Returns earned
- —
- Balance at the end
- —
- Withdrawal rate (annualised)
- —
Mandatory disclaimerSWPs assume constant return rates, which do not reflect real market volatility. Sequence of returns risk — poor returns in the early years — can significantly reduce how long a corpus lasts. This is illustrative and not investment advice.
Mutual Fund Overlap Calculator
How much two funds hold in common. Enter each fund's holdings with their portfolio weights; shared weight for a stock is the smaller of the two weights, and the total is the overlap.
Fund A holdings
| Stock | Wt % |
|---|
Fund B holdings
| Stock | Wt % |
|---|
Matched holdings
| Stock | Fund A | Fund B | Shared |
|---|
Mandatory disclaimerOverlap % is based on the portfolio weights you input. Actual mutual fund portfolios change over time and this calculator only reflects the snapshot you provided. This is an educational tool. It does not constitute a recommendation to invest in, redeem or switch any mutual fund scheme.
The method
How the XIRR calculator works
XIRR finds the single annual rate at which the present value of all your cash flows is zero. Money you invest is entered as a negative amount and money you receive, or today's value, as a positive amount.
- Cₖ is each cash flow
- dₖ is the number of days from the first cash flow
The rate is found numerically, so the calculator tells you if it cannot converge on a set of cash flows.
Worked example
- 1 Jan 2025: invested
- −₹1,00,000
- 1 Jul 2025: invested
- −₹1,00,000
- 1 Jan 2026: current value
- +₹2,20,000
- Absolute gain
- ₹20,000
- XIRR
- 13.44% a year
The gain is 10% of the money invested, but the second ₹1,00,000 was invested for only half the year, so the annualised rate is higher.
The essentials
XIRR meaning, formula and how it compares with CAGR
What is XIRR?
XIRR stands for extended internal rate of return. It is the annualised return on a series of cash flows that happen on irregular dates. For mutual fund investors it is the standard way to measure SIP returns, because each instalment is invested on a different date and stays invested for a different length of time.
XIRR vs CAGR
CAGR suits a single investment with one start value and one end value. XIRR handles many cash flows, so it is the right measure for a SIP, a mix of lumpsums, or a portfolio with withdrawals. Using CAGR on a SIP understates or overstates the return, because it ignores when each rupee went in.
How to calculate XIRR in Excel
List each cash flow in one column, with investments as negative numbers and the current value as a positive number, and the matching dates in the next column. Then use =XIRR(values, dates). This calculator does the same calculation without a spreadsheet. To project a SIP before you invest, use the SIP calculator.
Common questions
XIRR Calculator: frequently asked questions
What is XIRR in mutual funds?
What is the difference between XIRR and CAGR?
How is XIRR calculated?
Why are investments entered as negative numbers?
Can XIRR be negative?
For grievance redressal, contact tanish@worthostech.com or visit our Grievance Redressal page. If unresolved, escalate through SEBI SCORES or SMART ODR.
