please solve on excel and provide formulas

3. The following is information for three local auto dealers: Average Selling Price Unit Sales Interest Expense Variable Costs (% of Sales) Fixed Costs Preferred Dividends Common Shares Bell's Domestics $40,000 1,512 816,750 815,000 Junior's Used $30,875 1,832 45% Europe's Best $59,460 872 40% 452,000 Industry Average $37,500 1,265 1,633,500 315,000 6,300,000 a. Using the information given in the above table, construct income statements for each company and the industry average. Assume that each company faces a tax rate of 25%. b. Calculate the break-even points and the degrees of operating, financial, and combined leverage for each company and the industry average. c, Compare the companies to each other and the industry average.