USE EXCEL and show formulas please!! Red Sunset Co. manufactures mobile phones and wants to add a new model to its current line of products. The firm has estimated that the new phones selling price will be $80 and that variable costs would represent 65% of the sale price. Fixed operating costs are estimated to be $15M and the firms marginal tax rate is expected to remain at 35%. The firm also has forecasted that interest expenses associated with the new chip will reach $5M. The firm has 5M of common shares outstanding and forecasts a total preferred dividend payment of $200,000 for the next year. If Red Sunset Co. expects to sell 1M units of the new phone, then:

1)Create an income statement with the previous information.

2)Calculate the operating break-even point in both units and dollars.

3)How many units would Red Sunset Co. need to sell in order to achieve earnings, before interest and taxes of $2M?

4)Calculate the degree of operating, financial, and combined leverage. Use the Goal Seek tool to determine the number of units that would allow Red Sunset Co. to break even in terms of its net income and the selling price to break even in terms of earnings before taxes.

5)Also, determine with the same tool how much preferred dividends the firm would need to pay to keep a degree of financial leverage of 2.