PLEASE SHOW EXCEL FORMULAS.

Problem 1 - 30 points Use the following information to complete the income statement for Company A for the year ending December Income Statement Information Revenue Gross Margin Selling General and Administrative (SG&A) Research and Development (R&D) Depreciation expense (D&A) Interest Expense Interest Income Tax Rate of revenue of revenue $ 120,000,000 56.0% 21.0% 15.0% $ 5,000,000 $ 5,000,000 $ 2,500,000 21% Securities Information Weighted Average Shares (12/31/1X) A Warrants exercisable @ $2.25 B Warrants exercisable @ $3.00 Stock Price (12/31/1X) 10,000,000 2,500,000 2,500,000 $ 5.00 Points Complete the following Income Statement Answers go in the yellow boxes Revenue Cost of Goods Sold Gross Profit $ 120,000,000 1 1 Operating Expenses SG&A R&D D&A Operating Expenses Total 1 1 1 Operating Income 5 Interest Expense, net 1 Pre Tax Income Tax Net Income 1 1 2 EPS Basic EPS Diluted 5 10