Scripting Formulas Finance


FINANCE.MIRR(values..., finance_rate, reinvestment_rate)

Calculates the internal rate of return for a series of period cash flows, considering the cost of the investment and the interest on the reinvestment of cash.

  • values: List of income or payments associated with the investment. Must contain at least 1 positive and 1 negative value.
  • finance_rate: Interest rate paid on funds invested.
  • reinvestment_rate: Return earned on reinvestment of income received from the investment.