Calcist

Style

Buttons

Spacing

How much to show

Decimal places

Text size

XIRR calculator

Enter each deposit as a negative amount and each withdrawal (and today's value) as a positive one, with its date. Calcist finds the yearly rate of return, the same way Excel's XIRR does.

Cash flows: money in as negative, money out as positive

DateAmount
$
$
$
$
$
$

Private: calculated on your device. Nothing you type is sent anywhere.

Next: Cash flows evenly spaced, once a year? The IRR and NPV calculator adds NPV and MIRR. Just a start and an end? Use the ROI calculator.

What XIRR solves

Σ amounti ÷ (1 + r)(datei − date1) ÷ 365 = 0

XIRR is the rate r that makes the net present value of all your cash flows zero, discounting each one by the actual days since the first date over a 365-day year. That's how Microsoft Excel's XIRR and XNPV functions work. Unlike the plain IRR, the cash flows don't need to be evenly spaced.

Calcist starts at 10% (Excel's default guess) and uses Newton's method, which follows the slope of the NPV curve to the answer. If Newton's method doesn't settle, it switches to bisection: it finds two rates where the NPV has opposite signs and halves the gap until they agree. You need at least one negative and one positive amount.

Worked example

This is Microsoft's own example: −$10,000 on Jan 1, 2008, then $2,750 on Mar 1, 2008, $4,250 on Oct 30, 2008, $3,250 on Feb 15, 2009 and $2,750 on Apr 1, 2009. Excel's XIRR gives 0.373362535, and Calcist gives 37.34%. A simpler check: −$1,000 on Jan 1, 2024 and +$1,100 on Jan 1, 2025. That's 366 days (2024 is a leap year), so XIRR = 1.1365/366 − 1 = 9.97%, a touch under 10%.

Getting a realistic number

  • Include today's value. For an investment you still hold, enter its current value as a positive amount dated today.
  • Signs matter. Use negative for money you put in and positive for money you took out. Getting one wrong changes the answer completely.
  • Short periods exaggerate. A 2% gain over two weeks annualizes to about 68%.
  • Several sign changes (in, out, in again) can have more than one valid rate. Calcist, like Excel, reports the one it reaches from 10%.

This is an educational estimate, not financial, tax, legal or investment advice. Check the numbers with your own documents, lender or tax professional before you act.

Sources

How we checked this

Before every update, this calculator is run in a real browser with these known answers, and it must match all of them:

  • Microsoft's XIRR example: 37.34% ✓
  • −$1,000 to +$1,100 over leap year 2024 (366 days): 9.97% ✓
  • −$1,000 then +$900 a year later: −10% ✓
  • Two deposits and one withdrawal: 12.86% ✓
  • All positive amounts: no XIRR ✓

Last checked October 26, 2026. Spotted something wrong? The math is done in your browser with the formula shown on this page, so you can check any result by hand.

Add this calculator to your website (free)

Paste this code into any web page. The calculator works on your page, resizes itself, has no ads and no tracking cookies, and nothing your visitors type is sent anywhere. More about embedding.

Questions people ask

What is XIRR?

The extended internal rate of return: the yearly return on a series of cash flows that happen on irregular dates. It's the rate where the cash flows' net present value is zero.

What is the difference between IRR and XIRR?

IRR assumes cash flows are evenly spaced, such as once a year. XIRR uses the actual dates, so it works for deposits and withdrawals at any time.

Why use a 365-day year?

That's Excel's convention: each cash flow is discounted by (days since the first date) ÷ 365, even in leap years. Using it means Calcist matches Excel's answer.

Can XIRR be negative?

Yes. If you got back less than you put in, XIRR is negative. −$1,000 followed by +$900 a year later is −10%.

How do I calculate XIRR for my portfolio?

List every deposit as a negative amount and every withdrawal as a positive amount with its date, then add today's portfolio value as a final positive amount dated today.

Related calculators