Using the MIRR function:
The arguments for the MIRR function are:
|values||Required||An array or a reference to cells that contain numbers. These numbers represent a series of payments (negative values) and income (positive values) occurring at regular periods.
• values must contain at least one positive value and one negative value to calculate the internal rate of return.
• If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.
|finance_rate||Required||The interest rate you pay on the money used in the cash flows.|
|reinvest_rate||Required||The interest rate you receive on the cash flows as you reinvest them.|