Could someone please check this for me and also help with the preferred dividends and net income available to to common, common shares fields please

Consider the income statement for Squds and Suds, a very popular sports bar that serves only

one product: a plate of gourmet French fries and a pitcher of imported beer for $$16$ per

serving. In $2016,$ this company sold $156,250$ units of product. The variable costs are $60\%$ of

sales and the fixed costs are $$400,000.$ Tax rate of the company is $40\%.$ Squds and Suds has

interest expense of $$100,000,$ preferred dividends of $$100,000$ and $1,000,000$ of outstanding

shares.

In cell B$5,$ write a formula to calculate Sales.

In cell B$6,$ write a formula to calculate variable costs.

Complete the income statement $($cells B$7$ to B$12,$ and B$15).$

In cell B$17,$ write a formula to calculate earnings per share.

In cell B$26,$ write a formula to calculate operating breakeven point in units.

In cell B$27,$ write a formula to calculate operating breakeven point in dollars.

If target EBIT is $$800,000,$ write a formula to calculate units to meet EBIT target in

cell B$29.$

Assume that management of the company believe that unit sales will increases $10\%$ in

Furthermore, they expect that variable costs will remain to $60\%$ and fixed costs

will stay at $$400,000.$

In cell $C21,$ write a formula to calculate unit sales in $2017.$

Using cell referencing, complete the cells C$5-$C$12,$ C$14-$C$17,$ C$26$ and C$27.$

In cell C$33,$ write a formula to calculate $\%$ change in sales from prior year.

In cell C$34,$ write a formula to calculate $\%$ change in EBIT from prior year.

In cell B$36,$ write a formula to calculate degree of operating leverage in $2016.$

In cell B$37,$ write a formula to calculate degree of financial leverage in $2016.$

In cell B$38,$ write a formula to calculate degree of combined leverage in $2016.$

In cells C$36$ to C$38,$ using cell referencing to get the value of DOL, DFL and

DCL in $2017,$ respectively.