SLA 9 Nike updated vo2 mutoSave ome Insert X Data Review View AB S U : Draw Page Layout Calibri (Body) 10 BI O E Formulas A A A 29 Custom Core Ford Cel $ % 96 -2 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? Calculate the following raties for your company for the current and prior years and compare to Industry everages Must discuss your findings, what is meaning of results! Current Y Prior Industry M e Current ratio type narrative here Total Debt to Equity type narrative here Times interest Earned sometimes referred to as Interest coverage type narrative here! 2018 2017 Interest expense incomel.net Checklist Capital Structure IS V&H BS V&H Reuters Industry 15mar 2019 Ratios Exhibit VICT Dald RUVIEW = = EB General Home Insert Draw Page Layout Formulas Calibri (Body) 11 A A Paste the BI UNIV a. A X $ % 1+1 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to re =12 x & fx A B C D E F G H I J Note: any videos provided aren't meant to be 100% answers, just guidance. After you complete, stop and review your work. Is underlining Nike, Inc. Income Statements For the Fiscal Years Ended May 31, $'in milions, c hart 2017 2016 Net Sales Cost of Sales Gross Profit Operating Expenses Operating Income Other (revenues) & expenses Earnings before Taxes Income Tax Expense Net Income 2018 $36,397 20,441 15956 11,511 4445 120 $34,350 19,038 15,312 10,563 4,749 (137) $32,376 17405 14,971 10469 4,502 (121) 4886 4,623 646 953 4,325 2,392 $1,933 $ 1.17 $4,240 $ 2.51 $3,760 $ 2.16 EPS 20 Nike, Inc Income Statements: Horizontal Analysis For the Fiscal Years Ended May 31, IS's in millions ZULE VS. ZURI 201/ VS. ZUID $ Inc 2018 Iner (Decrx Change 2017 * Change 2016 Net Sales $36,397 $2,047 5.96% $3435051974 6.10% $32,376 Cost of Sales 20441 1403 7.37% 19038 1633 9.38% 17405 Gross Profit 15,956 644 4.21% 15,312 341 2.28% 14,971 Operating Expenses 11,511 948 8.97% 10,563 94 0.90% 10.469 Operating Income 4,445 (304) -6,40% 4,749 247 5.49% 4.502 Other (revenues) & expenses 120 257 187.59% (137) (16) 13.22% (121) Earnings before Taxes 4,325 (561) 11.48% 4,886 263 5.69% 4,623 Income Tax Expense 2,392 1,746 270.28% 646 (217) 25.14% 863 Net Income $1.933 ($2.307 54.41% $4.240 $480 12.77% $3.760 Checklist Capital Structure IS V&H BS V&H Reuters industry 15ma 29 31 34 Data View AutoSave OFF S U = Home Insert Draw Page Layout Formulas Calibri (Body) 11 AA BI U Dva. A. Review E General LO ( 0 $ Paste % Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to F12 x fx G H Nike, Inc. Income Statements: Horizontal Analysis For the Fiscal Years Ended May 31, I' millions Na 2U/ VS. LULD LUIS VS. 2017 since 2018 Change 20,441 15,956 11,511 4445 Net Sales Cost of Sales Gross Profit Operating Expenses Operating Income Other (revenues) & expenses Earnings before Taxes Income Tax Expense Net Income EPS 30 $ Incr (Decr) * Change 2017 5.96% $34,350 1403 7.37% 19,038 644 4.21% 15,312 948 8.97% 10,563 (304) -6.40% 4,749 257 -187,59% (137) (561) -11.48% 4,886 1.746 270,28% 646 ($2,307) -54.41% $4,240 $ (1.34) 53.39% ##### Dec $1,974 1,633 341 94 247 (16) 263 (217) $480 $0.35 * Change 6.10% 9.38% 2.28% 0.90% 5.49% 13.22% 5.69% -25.14% 12.77% 16.20% 2016 $32,376 17,405 14,971 10,469 4,502 (121) 4,623 120 863 4,325 2392 $1.933 $ 1.17 $3,760 $ 2.16 in o Newer Year Older Year $ Increase (Decrease) + Older Year Percentage Change Nike, Inc. Income Statements: Vertical Analysis For the Fiscal Years Ended Mav 31. s's in million ONM00 2018 Net Sales Cost of Sales Gross Profit Operating Expenses Operating Income Other (revenues) & expenses Earnings before Taxes Income Tax Expense Net Income EPS $36,397 20,441 15,956 11,511 4445 % of Net Sales 100.00%' 56.51' 43.84% 31.63%' 12.21% 0.33%' 11.88% 6.57%' 5.31% % of 2017 Net Sales 2016 $34,350 100.00% $32,376 19,038 55,42% 17,405 15,312 44.58% 14,971 10,563 30.75% 10,469 4,749 13.83% 4,502 (137) 0.40%' (121) 4,886 14.22% 4,623 646 1.88%' 863 $4,240 12.34% 53,760 % of Net Sales 100.00% 53.76% 46.24% 32.34% 13.91% -0.37% 14.28% 2.67% 11.61% 120 4,325 2392 $1923 Paste EE B IUDA E Recover Unsaved Workbooks. We were able to save changes to one or more files. Do G8 D 4 2017 2016 $3,808 3,677 5,055 3,521 16,061 3,989 3,209 $23,259 $3,138 3,241 4,838 3,808 15,025 3,520 2,834 $21,379 16 2017 2016 May 31, IS's in millions) ASSETS 2018 Current Assets Cash and Cash Equivalents $4,249 Accounts Receivable, net 3,498 Inventories 5,261 Other Current Assets 2,126 . Total Current Assets 15,134 Property, Plant and Equipment, net 4,454 Total Intangibles and Other Assets 2,948 Total Assets $22,536 LABIUTIES AND STOCKHOLDERS' EQUITY Current Liabilities 2018 Accounts Payable $2,279 Accrued Liabilities 3,269 Other Current Liabilities 492 Total Current Liabilities 6,040 Long-Term Debt 3,468 Other Noncurrent Liabilities 3,216 Total Liabilities 12,724 Stockholders' Equity Common Stock Additional Paid-in Capital 6,384 Retained Earnings 3,517 Accumulated Other Comprehensive Income (Loss) (92) Less: Treasury Stock at cost Total Stockholders' Equity 9,812 Total Liabilities and Stockholders' Equity $22,536 $2,048 3,011 $2,191 3,037 130 415 5,474 3,471 1,907 10,852 5,358 1,993 1,770 9,121 7,786 4,151 5,710 6,907 (213) 0 318 12,407 $23,259 12,258 $21,379 Checklist Capital Structure IS V&H BS V&H Reuters indu utoSave OFF s u = SLA 9 Nike u me Insert View .. Draw Page Layout Calibri (Body) 11 I - - Formulas Data Review AA= a. A General $ % 8 B 9 to Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? x fx Total Liabilities and Stockholders' Equity $22,536 $23,259 $21,379 Nike, Inc Balance Sheets: Horontal Analysis May 31, $3,138 Current Assets Cash and Cash Equivalents Accounts Receivable, net Inventories Other Current Assets Total Current Assets Property, plant and Equipment, net TotalIntang bles and Other Assets Total Assets 2018 $4,249 1498 5.261 2.126 15.134 4454 2.968 $22516 2017 $3,808 3,677 5.055 3,521 16,061 3.989 2018 vs. 2017 Sinar (Deer Change $441 11.58% (179) 4.87% 205 4,08 (1,395) -39.62% (927) 5.77% 465 11.66% (251) 8.13 5723) 3115 2018 vs. 2017 $ Iner (Decr] Change $231 11.28 258 8.57% 18.55% 566 10.34% -0.09 1,309 68.64% 1.872 17.25% 3209 $23.259 2017 vs. 2016 Incer (Decrl Change $670 21.35% 436 13.45% 217 4.49% (287) -7.54% 1036 6. SON 469 1332 375 1323 $1.880 8.79% 2017 vs. 2016 ner(Decr] Change $143) -6.53% (26) 0.86% 285 219.23 116 2.16N 1478 74.16% 1377.74 1,731 18.98% 3520 2834 $21.379 2013 $2.279 3.269 2016 $2,191 3,037 77 2017 $2048 3,011 415 5,474 3.471 1.907 10,852 6,040 3.468 3.216 12,724 9.121 Current Liabilities Accounts Payable Accrued Liabilities Other Current Liabilities Total Current Liabilities Long-Term Debt Other Noncurrent Labs Total Labs Stockholders' Equity Common Stock Additional Pald-in Capital Retained Eamings Accumulated Other Comprehensive Income (Loss) Less: Treasury Stock at cost Total Stockholders' Equity Total Labies and Stockholders' Equity 20 +674 13,390) 121 0.00% 11.80 49.08% -56,81% #DIV/01 20.92 -3.11% 6,384 3,517 (92) 0 9,812 $22.536 7,786 4,151 318 0 0.00% (2,076) -26.66% 2,756 66.39% (531) -166.98% 0 HDIV/0! 149 1.22% $1.880 8.79% 5.710 6.907 1213) 0 12407 $23.259 O (2,595) (5723) 12.258 $21.379 Newer Year-Older Years Increase (Decrease) +Older Year:Percentage Change Checklist Capital Structure IS V&H BS V&H Reuters industry 15mar2019