Vertical and Horizontal Analysis
Vertical and Horizontal Analysis
Vertical and Horizontal Analysis
Nike, Inc.
Consolidated Statements of Income
For the Years Endeded May 31,
Nike, Inc.
VERTICAL ANALYSIS of Consolidated Statements of Income
For the Years Endeded May 31,
REMEMBER: # DIVIDED BY REVENUE
2018 2017 2016
Revenue
Cost of sales
Gross profit
Demand creation expense
Operating overhead expense
Total selling and administrative expense
Interest expense (income), net
Other expense (income), net
Income before income taxes
Income tax expense
NET INCOME
2017 --> 2018 2016 --> 2017 2017 --> 2018 2016 --> 2017
Revenue Revenue
Cost of sales Cost of sales
Gross profit Gross profit
Demand creation expense Demand creation expense
Operating overhead expense Operating overhead expense
Total selling and administrative expense Total selling and administrative expense
Interest expense (income), net Interest expense (income), net
Other expense (income), net Other expense (income), net
Income before income taxes Income before income taxes
Income tax expense Income tax expense
NET INCOME NET INCOME
Nike, Inc.
Consolidated Statements of Income
For the Years Endeded May 31,
Nike, Inc.
VERTICAL ANALYSIS of Consolidated Statements of Income
For the Years Endeded May 31,
2017 --> 2018 2016 --> 2017 2017 --> 2018 2016 --> 2017
Revenue $ 5,047 $ (1,026) Revenue 16.10% -3.17%
Cost of sales 1,403 1,633 Cost of sales 7.37% 9.38%
Gross profit 3,644 (2,659) Gross profit 29.60% -17.76%
Demand creation expense 236 63 Demand creation expense 7.06% 1.92%
Operating overhead expense 712 31 Operating overhead expense 9.86% 0.43%
Total selling and administrative expen 948 94 Total selling and administrative expense 8.97% 0.90%
Interest expense (income), net (5) 40 Interest expense (income), net -8.47% 210.53%
Other expense (income), net 262 (56) Other expense (income), net -133.67% 40.00%
Income before income taxes 2,439 (2,737) Income before income taxes 129.32% -59.20%
Income tax expense 1,746 (217) Income tax expense 270.28% -25.14%
NET INCOME $ 693 $ (2,520) NET INCOME 55.89% -67.02%