Help me fill out the yellow collums. also make sure you add the formulas with the answers.
116 X D IF G 4 Present a comparative balance sheet 2018 2017 Dollar Change Percent Change Assets Cash Marketable securities Accounts receivable Inventories Deferred tax assets Vendor non-trade receivables Other current assets Total current assets Long-term securities PP&E Goodwill Intangible assets Other assets Total assets 21, 120 $ 13,844 20,481 11,233 16,849 17,460 2,349 2,111 5,546 4,318 13,494 9,759 9,539 9,806 89,378 68,531 164,065 130,162 22,471 20,624 5,116 4,616 3,893 4,142 5,556 3,764 290,479 $ 231,839 $ Liabilities Accounts payable Accrues expenses Deferred revenue Commercial paper Current nortion IT debt 35,490 25,181 8,940 8,499 2.500 30,196 18,453 8,491 6,308 Total assets $ 290,479 $ D 231,839 $ 30,196 18,453 8,491 6,308 Liabilities Accounts payable Accrues expenses Deferred revenue Commercial paper Current portion L-T debt Total current liabilities Deferred revenue-noncurrent Long-term debt Other noncurrent liabilities Total liabilities 35,490 25,181 8,940 8,499 2,500 80,610 3,624 53,463 33,427 171,124 63,448 3,031 28,987 24,826 120,292 $ $ $ $ Stockholders equity Common stock Retained earnings Accum. OCI Total stockholders' equity Total liab. and stock. equity 27,416 92,284 (345) 119,355 290,479 23,313 87,152 1,082 111,547 231,839 $ $ Clipboard Font Alignment Number L16 x DD 43 Present a comparative income statement: 2018 2017 Dollar Change Percent Change Net sales Cost of sales Gross margin Research and development Selling, general & administrative Total operating expenses Operating income Other income Income before taxes Income taxes Net income Basic earnings per share 233,715 $ 140,089 93,626 8,067 14,329 22,396 71,230 1,285 72,515 19,121 53,394 $ 9.28 $ 182,795 112,258 70,537 6,041 11,993 18,034 52,503 980 53,483 13,973 39,510 6.49 $ Net Sales Cost of Sales Operating expenses 2018 233,715 S 140,089 22,396 2017 2016 182,795 $ 170,910 112,258 106,606 18,034 15,305 2015 $ 156,508 $ 87,846 13,421 2014 108,249 10.028 Data and Answers instructions - c I D E F $ $ Net Sales Cost of Sales Operating expenses 2018 233,715 140,089 22,396 2017 S 182,795 112,258 18,034 2016 170,910 106,606 15,305 2015 156,508 $ 87,846 13,421 2014 108,249 64,431 10,028 Present a trend analysis: 2018 2017 2016 2015 2014 Net Sales Cost of Sales Operating expenses 74 Present common-size balance sheets: 75 74 Present common-size balance sheets: Common-size percents 2018 2017 2018 2017 Assets Cash Marketable securities Accounts receivable Inventories Deferred tax assets Vendor non-trade receivables Other current assets Total current assets Long-term securities PP&E Goodwill Intangible assets Other assets Total assets 21,120 $ 20,481 16,849 2,349 5,546 13,494 9,539 89,378 164,065 22,471 5,116 3,893 5,556 290,479 $ 13,844 11,233 17,460 2,111 4,318 9,759 9,806 68,531 130,162 20,624 4,616 4,142 3,764 231,839 $ Liabilities Accounts payable Accrues expenses Deferred revenue $ 35,490 25, 181 8.940 30, 196 18,453 8.491 87 Long term securities PP&E Goodwill Intangible assets Other assets Total assets 164,065 130,162 22,471 20,624 5,116 4,616 3,893 4,142 5,556 3,764 290,479 $ 231,839 $ $ Liabilities Accounts payable Accrues expenses Deferred revenue Commercial paper Current portion L-T debt Total current liabilities Deferred revenue-noncurrent Long-term debt Other noncurrent liabilities Total liabilities 35,490 25.181 8,940 8,499 2,500 80,610 3,624 53,463 33,427 171,124 30,196 18.453 8,491 6,308 - 63,448 3,031 28,987 24,826 120,292 102 103 106 107 108 Stockholders equity Common stock Retained earnings AOCI Total stockholders' pouty 27,416 92,284 (345) 119.355 23,313 87,152 1,082 111.547 Common stock Retained earnings Total stockholders' equity Total liab, and stock equity CT DE 27,416 23,313 92,284 87,152 (345) 1,082 119,355 111,547 290,479 $ 231,839 109 110 $ 113 Present common size income statements: Common-size percents 2018 2018 2017 2017 $ Net sales Cost of sales Gross margin Research and development Selling, general & administrative Total operating expenses Operating income Other income Income before taxes Income taxes Net income 233,715 140,089 93,626 8,067 14,329 22,396 71,230 1,285 72.515 19,121 53,394 182,795 112,258 70,537 6,041 11,993 18,034 52,503 980 53,483 13,973 39,510 $