Assignment Co

All your answers are to be typed into the Yellow boxes. You can type in formulas on the spreadsheets if you wish for potential partial credit.

Do not touch the Blue boxes.

Home Insert Draw Page Layout Tell me Share Q Comments A- % V Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editin 020 X foc D G Problem 1 - 30 points 4 Use the following information to complete the income statement for Company A for the year ending December 31, 201X (show work): 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 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 $ 120,000,000 56.0% 22.5% of revenue 15.0% of revenue $ 5,000,000 $ 5,000,000 $ 2,600,000 21% 10,000,000 2,500,000 2,500,000 S 5.00 21 Securities Information Weighted Average Shares (12/31/1X) A Warrants exercisable @ $2.50 B Warrants exercisable a $3.00 Stock Price (12/31/1X) Complete the following Income Statement Answers go in the yellow boxes Revenue Cost of Goods Sold Gross Profit 22 Points 24 $ 120,000,000 $ 120,000,000 1 26 27 Operating Expenses SG&A R&D D&A Operating Expenses Total 31 5,000,000 1 33 34 Operating Income 5 Interest Expense, net 1 36 37 39 Pre Tax Income Tax Net Income 2 40 41 42 43 44 EPS Basic EPS Diluted 5 10 Total Points 30 45 46 Note: For losses, only Basic Shares are used in calculating Diluted EPS Use this table (below) to help with your calculations Diluted Share Calculations 47 40 49 Basic A warrants B wamants Total 51 52 56 Proceeds A warrants B warrants Total Proceeds 56 57 58 Shares repurchased 50 61 Diluted share used to calculate Diluted EPS Prob. 1 - Income Stmt Prob. 2 - Working Capital Prob. 3 - Ratios + + 62%