Please answer question g, calculate MIRR for franchise L and S. Please show me how to Calculate MIRR in Excel

You have narrowed your sesection uown to two choices: (1) Franchise L, Lisa's Soups, Salads, \& Stuff, and (2) Franchise S, Sam's Fabulous Fried Chicken. The net cash flows shown below include the price you would receive for selling the franchise in Year 3 and the forecast of how each franchise will do over the 3-year period. Franchise L's cash flows will start off slowly but will increase rather quickly as people become more health-conscious, while Franchise S's cash flows will start off high but will trail off as other chicken competitors enter the marketplace and as people become more health-conscious and avoid fried foods. Franchise L serves breakfast and lunch whereas Franchise S serves only dinner, so it is possible for you to invest in both franchises. You see these franchises as perfect complements to one another: You could attract both the lunch and dinner crowds and the health-conscious and notso-health-conscious crowds without the franchises directly competing against one another. Here are the net cash flows (in thousands of dollars): Depreciation, salvage values, net working capital requirements, and tax effects are all included in these cash flows. You also have made subjective risk assessments of each franchise and concluded that both franchises have risk characteristics that require a return of 10%. You must now determine whether - - .. hoth of the franchises should be accepted. g. (1) Define the term modified IRR (MIRR). Find the MIRRs for Franchises L and S. (2) What are the MIRR's advantages and disadvantages vis--vis the regular IRR? What are the MIRR's advantages and disadvantages vis--vis the NPV