The Modified Internal rate of Return (MIRR) in cell E9 will be the Internal Rate of Return (IRR) in E8. A B F D Year 0 1 2 3 4 5 6 7 8 9 10 1 2 3 4 Required Return IRR MIRR E Cash Flows (78,000) 28,000 35,000 18,000 12,000 10.00% 8.69% =MIRR(E2:E6, E7,E7) less than equal to Ogreater than none of the above