please answer all parts and 1

Search DYMO Label QuickBooks AutoSave On R o Excel TemplateAssignment Ch14 (1) Excel File Home Insert Page Layout Formulas Data Review View Help V40 X fi F G 1 E14-2 Prepare vertical analysis 2 Operating data for Navarro Corporation are presented below. Net sales Cost of goods sold Selling expenses Administrative expenses Income tax expense Net income 2017 $750,000 465,000 105,000 60,000 36,000 84,000 2016 $600,000 390.000 66,000 54,000 27,000 63,000 12 Instructions 13 Prepare a schedule showing a vertical analysis for 2017 and 2016. 14 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". NAVARRO CORPORATION Condensed Income Statements For the Years Ended December 31 E 2017 2016 Amount Percent Amount Percent Net Sales Value Value Cost of goods sold Value Value Gross Profit Selling expenses Value Value Administrative expenses Value Total operating expenses Income before income taxes Value Income tax expense Value Value Net income ? Value Value 614-1 E14-2 P14-3 P14-9 Home Insert Page Layout Formulas Data Review View Help DYMO Label QuickB G Selling expenses Administrative expenses Income tax expense Net income 105,000 60,000 36,000 84,000 66,000 54,000 27,000 63,000 ructions are a schedule showing a vertical analysis for 2017 and 2016. TE: Enter a number in cells requesting a value; enter either a number or a formula in cel NAVARRO CORPORATION Condensed Income Statements For the Years Ended December 31 2017 2016 Amount Percent Amount Percent Net Sales Value Value Cost of goods sold Value Value Gross Profit Selling expenses Value Value Administrative expenses Value Value Total operating expenses Income before income taxes Value Value Income tax expense Value Value Net income Assume that 2017 net sales changed to $735,000. Show the impact of this change on the vertical analysis for 2017. | 14:9 E14-2 P14:3 P14:9 | Type here to search O P OT Gel