XIRR

FINANCE.XIRR

FINANCE.XIRR(amounts..., dates..., rate_guess = 0.1)

Calculates the internal rate of return for a schedule of cash flows. The amounts and dates parameters must be the same length.

The first amount should correspond to the first date, and so on.

• amounts: List of incomes associated with the investment.

• dates: List of dates associated with the income amounts.

• rate_guess: An estimate for the internal rate of return. Defaults to 0.1.

  FINANCE.XIRR(amount1, amount2, amount3, date1, date2, date3, 0.5)