Smith Bottling Company (SBC) expects this year's sales to be $290,000. SBC's variable operating costs are 60 percent of sales and its fixed operating costs are $76,000. SBC pays interest on its debt equal to $20,000 per year and its marginal tax rate is 35 percent. SBC has no preferred stock.

Compute SBC's DOL, DFL, and DTL. Do not round intermediate calculations. Round your answers to two decimal places.

DOL:

DFL:

DTL:

If sales turn out to be $298,700 rather than $290,000, what will be SBC's EBIT and net income? Do not round intermediate calculations. Round your answers to the nearest dollar.

EBIT: $

Net income: $

please share the formulas and steps used in Excel