MIRR

MIRR(arg1, arg2, arg3) → { number | string | boolean }

Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash.

Parameters:

Name Type Description
arg1 ApiRange

Is an array or a reference to cells that contain numbers that represent a series of payments (negative) and income (positive) at regular periods.

arg2 number

Is the interest rate you pay on the money used in the cash flows.

arg3 number

Is the interest rate you receive on the cash flows as you reinvest them.

Returns:

Type
number | string | boolean