E$18-2$ Prepare vertical analysis

Operating data for Navarro Corporation are presented below.

$20172016$

Net sales $$750,000$ $$600,000$

Cost of goods sold $465,000390,000$

Selling expenses $105,00066,000$

Administrative expenses $60,00054,000$

Income tax expense $36,00027,000$

Net income $84,00063,000$

Instructions

Prepare a schedule showing a vertical analysis for $2017$ and $2016.$ Round percentages to one decimal

point.

NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a $"?"$