INDIGO CORPORATION For the Years Ended December 31 2017 2016

INDIGO CORPORATION For the Years Ended December 31 2017 2016 Net sales Cost of goods sold Gross Profit $621,600 $541,200 439,700 171,200101,500 42,500 s 100,900 $ 59,000 450,400 70,300 Net income Prepare a horizontal analysis of the income statement data for Indigo Corporation, using 2016 as a base. (If amount and percentage are a decrease show the numbers as negative, e.g.-55,000,-20% or (55,000), (20%). Round percentages to 1 decimal place, e.g. 12.1%.) INDIGO CORPORATION Increase or (Decrease) During 2017 2017 2016 Net sales $621,600 $541,200 Cost af goods sold 450,400 439,700 171,200 101,500 42,500 s 100,900 59,000 Gross Profit Operating expenses Net income 70,300 LINK TO TEXT Prepare a vertical analysis of the income statement data for Indigo Corporation for both years. (Round percentages to 1 decimal place, e.g. 12.1%.) INDIGO CORPORATION 2017 2016 Percent Percent Net sales Cost af goods sold Gross Profit Operating expenses Net income $621,600 450,400 171,200 70,300 S 100,900 96 $541,200 196 439,700 %101,500 % 42,500 59,000 Click if you would like to Show Work for this question: Open Show Work

Solution

Horizontal analysis :

Vertical analysis :

	2017	2016	Increase amount	Increase percentage
Net sales	621600	541200	80400	14.9%
Cost of goods sold	450400	439700	10700	2.4%
Gross profit	171200	101500	69700	68.7%
Operating expenses	70300	42500	27800	65.4%
Net income	100900	59000	41900	71.0%