(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%. (5 marks)

(b) Calculate the break-even points, in units and in dollars, for each company and

the industry average. (8 marks)

(c) Calculate the degrees of operating, financial, and combined leverage for each

company and the industry average.

can you please get the solution done in microsoft excel

SFN3433 FINANCIAL M = Open with Google Docs 3. The following is information for three local auto dealers: Bell's Domestics Junior's Used Europe's Best Industry Average 559,460 $37,500 872 Average Selling Price Unit Sales Interest Expense Variable Costs of Sales) Fixed Costs Preferred Dividends Common Shares $40,000 1,512 816,750 60% 9.900,000 815,000 4,500,000 $30,875 1,832 1,089,000 45% 6,930,000 1,265 1,633,500 4896 3,267,000 4096 19,800,000 452,000 2,700,000 10,890,000 0 7,200,000 315,000 6,300,000