please answer this question with the complete formula in excel. thank you.

Three construction companies operate in the Middle East, their selected sales and operating data are as follows. Sales Average Operating Assets Net Operating Income Minimum Required Rate of Return Gama $40,000,000 $8,000,000 $1,280,000 16% Alfa $20,000,000 $5,000,000 $1,000,000 14% Beta $24,000,000 $12,000,000 $960,000 10% Required: 1. Compute the Return on Investment (ROI) for each company using the formula stated in terms of margin and turnover. [7.5 marks] 2. Compute the Residual Income for each company. [7.5 marks] 3. At one time the three companies were offered an investment opportunity that would yield a 15% rate of return. a) Using ROI as a performance measurement, which company or companies will probably accept or reject? Why? [5 marks] b) Using Residual Income as performance measurement, which company or companies will probably accept or reject the opportunity? Why? [5 marks] a