Then input "=IRR(D2:D6)" in cell D9 for the second scenario. The formula ... with low returns may be a better investment than one with high risk and high returns. Calculating MIRR in Excel and ...