Answer yellow boxes with excel formula.

1. SALES 2. COST OF SALES 3. GROSS PROFIT 4. SELUING, GENERAL \& ADMINISTRATIVE X 5. RESEARCH \& DEVELOPMENT X 6. DEPRECIATION \& AMORTIZATION X 7. OPERATING INCOME (OPERATING PROFIT) 8. OTHER INCOME (EXPENSE) 9. EARNINGS BEFORE INTEREST \& TAXES (EBIT) 10. INTEREST INCOME (EXPENSE) 11. EARNINGS BEFORE TAXES (EBT) [PRETAX INCOME] 12. TAXES 13. EARNINGS AFTER TAXES (EAT) [NET INCOME] 14. PREFERRED STOCK DIVIDENDS 15. EARNINGS AVAILABLE TO COMMON STOCKHOLDERS (NET INCOME APPLICABLE TO COMMON) (NET PROFIT) (NET EARNINGS) 16. COMMON SHARES OUTSTANDING 17. EARNINGS PER SHARE (EPS) 18. DILUTED EARNINGS PER SHARE (580,000 SHARES) \begin{tabular}{|c|c|c|} \hline$ & 22,000,000 & % \\ \hline$ & (13,456,744) & \\ \hline \end{tabular} $ $ % GROSS MARGIN (3,744,000) $(234,055) $(560,000) $ S (80,643) % OPERATING MARGIN $ $ $ (124,800) $ \$ $ $ % % EBIT \& EBITDA (124,800) \% EBT (956,884) \% NET INCOME (345.000) \$ \% NET PROFIT MARGIN NET PROFIT MARGIN \$ 540000 $