MIRR

Definition: MIRR is a function that calculates the modified internal rate of return for a series of periodic cash flows.

Syntax: =MIRR(values, finance_rate, reinvest_rate)

Situation: This formula is appropriate when you need to calculate the modified internal rate of return for a series of periodic cash flows.

Example: If you have a series of cash flows and want to find the modified internal rate of return, the formula =MIRR(A1:A10, 0.1, 0.2) can be used, where A1:A10 contains the cash flows.