Using the data in the following table for a number of firms in the same industry, do the following: Compute the total asset turnover, the net profit margin, the equity multiplier, and the return on equity for each firm.b. Evaluate each firms performance by comparing the firms with one another. Which firm or firms appear to be having problems? What corrective action would you suggest the poorer performing firms take? Finally, what additional data would you want to have on hand when conducting your analyses? If you want the formulas and any calculations, select the corresponding cell and press F2(Function Key on key board),It will show all calculations and formulas AutomaticallyQuestion a)Solution:…