Scripting Formulas Finance


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)