Scripting Formulas Finance


FINANCE.IRR_WITH_ESTIMATE(values..., rate_guess)

Calculates the internal rate of return for a series of cash flows. This method is compatible with the IRR method used in popular spreadsheet programs.

  • values: Income or payments associated with the investment. Must contain at least 1 negative and 1 positive value, and the first amount must be negative.
  • rate_guess: Estimated internal rate of return.