i need helo doing a verticle and horizontal analysis performed on this statement. Please help with formula as well.

AutoSave OFF BES Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 ' 2 Wrap Text General X Cut LE Copy Format Poste B 7 U A 2 += Merge & Center $ % H 1 1 K L M N S9 X fx A B D E F G 1 NIKE, Inc. Consolidated Statements of Income 2 3 millions, except per sharedoto) 4 5 Revenues 6. Cost of sales 7 Gross profit 8 Demand creation expense 9 Operating overhead expense 10 Total selling and administrative expense 11 Interest expense (income), net 12 Other (income) expense, net 13 Income before income taxes 14 income tax expense 15 NET INCOME 16 17 Earnings per common share: 10 Basle 19 Diluted 20 21 Dividends declared per common share Year Ended May 31, 2017 2016 Amount Percent Amount Percent $ 34,850 100.0% $ 32,376 100.0% $ (19,038) -55.4% $ (17,405) 53.8% $ 15,312 44.6% $ 14,971 46,2% $ (3,341) -9.796 $ 3,278) -10.1% $ 17,222) 21.0% $ 17,191) -22.2% $ (10,563) -30.8% $ (10,469) -32.3% $ (59) -0.2% S (19) -0.1% S 196 0.6% S 140 0.4% S 4,886 14.2% $ 4,623 14.3% $ (646) -1.9% $ (863) -2.7% $ 4,240 12.3% $3,260 11.6% $ S 2.56 2.51 $ $ 2.21 2.16 $ 1 $ 0.62