how do you calculate the modified internal rate of return?
Alternatively, the MIRR can be easily calculated in spreadsheet applications such as Microsoft Excel. For example, in MS Excel, it can be calculated using the function called “=MIRR (cash flows, financing rate, reinvestment rate).”