Question: how do you calculate the modified internal rate of return?
Answer: 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).”