complete the problem using Excel formulas

P.12: Du Pont system of analysis (LO3) AilState Trucking Co. has the following ratios compared to its industry for last year (below) Explain why the return-on-assets ratio is so much more favorable than the return-on-sales ratio compared to the industry. Hint: Compare Asset Turnover (using the derived formula from the "Supplemental" sheet) to explain. P.13: Du Pont system of analysis (LO3) Front Beam Lighting Company has the following ratios compared to its industry for last year (below). Explain why the return-on-equity ratio as compared to Return on Assets is so much less favorable than that of the industry. Hint: Starting with the formula: Return on Equity w Return on Assets/(1-Debt/Assets), derive a new formula that algebraically isolates Debt/fotal Assets and then compare front Beam's to the Industry