Using the MIRR function:
The arguments for the MIRR function are:
Argument  Required?  Description 

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. 