MIRR(values, finance_rate, reinvest_rate) 
Returns the internal rate of return for a series of unequal cash flows at regular intervals (explicit reinvestment rate). 
values  A series of cash flows. 
finance_rate  The interest rate you pay on the money used in the cash flows. 
reinvest_rate  The interest rate you receive on the cash flows as you reinvest them. 
Remarks 
* This function takes into account the cost of borrowed money and assumes resulting cash flows are invested. * This function assumes all payments are at the end of each period. * Every cash flow occurs at the end of each period except for the first cash flow, which is at the beginning (check). * A negative number represents any cash you pay out. * A positive number represents any cash you receive (start with or end with). * The "values" series must contain at least one positive value and one negative value. Example ?? * Any cells that contain zero will be included. * If an array or reference argument contains text, logical values, or empty cells, those values are ignored. * This function uses the order of values to interpret the order of cash flows. * You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals. * You can use the IRR function to return the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate). * You can use the XIRR function to return the interest rate for a series of unequal cash flows at irregular intervals. * The equivalent VBA function is MIRR * For the Microsoft documentation refer to support.office.com 

5  What annual interest rate have you received  all the cash flows are positive 8  If "values" does not contain at least one positive and one negative value then #DIV/0! is returned 
© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top