accounting information for business decisions

3. The following is information for three local auto dealers: 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. What conclusions can you draw about each operation? Part a: Bell's Domestics Junior's Used Europe's Best Industry Average Average Selling Price Unit Sales Interest Expense Variable Costs (\% of Sales) Fixed Costs Preferred Dividends Common Shares Tax Rate Bell's Domestics Junior's Used Europe's Best Industry Average Sales 14 Variable Costs 15 Fixed Costs 16 Earnings Before Interest and Taxes 17 Interest Expense 18 Earnings Before Taxes 19 Taxes 20 Net Income 21) 22 Preferred Dividends 23 Net Income Available to Common 24 25 Earnings per Common Share A Earnings per Common Share Part b: Break-even Point (Units) Break-even Point (Dollars) Degree of Operating Leverage 2 Degree of Financial Leverage Degree of Combined Leverage Part c: Week 4 Assignment: Chapter 7 Problem \#3 Requirement: You will complete most of your weekly assignments using Excel. These assignments will reference the concepts learned from your text, from your chapter PowerPoints, and other vid previded for you to view. Please be sure to review the chapter PowerPoints before beginning your assignments. Topic: Using the information provided in Chapter 7 Problem \#3, complete parts "a" through "c" using the provided Excel template below. Chapter 7 Problem \#3 Student Name Template x. S Graded Activity: 1. Read Chapter 7 of your text 2. Review the PowerPoint for Chapter 7 and any related videos provided for the week. 3. Complete Week 4 Assignment: Chapter 7 Problem \#3. Please click on the title link above labeled "Week 4 Assignment: Chapter 7 Problem \#3" to enter and