Skip to content
finplan

XIRR

The yearly return on money invested and received on different dates. The same method as Excel’s XIRR, so you can check it in a spreadsheet.

Cash flows

Add what you invested and what you received or hold today, each with its date.

  1. Cash flow 1
    Type

  2. Cash flow 2
    Type

  3. Cash flow 3
    Type

  4. Cash flow 4
    Type

Annualised return (XIRR)

10.46%

Cash flows
4

How this is calculated

Solves for the yearly rate at which the discounted cash flows sum to zero, with years = actual days ÷ 365.