Autosaven 50 SLA 11 Nike for mystudentsF19 Home Insert Draw Page Layout Formulas Data Review View Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? E25 x fx formula result NA Par Value Total Totals y Note Current Y Prior Yr Priory per Share Current Year Prior Year Change Note 1 5 Preferred Stok NA 6 Common Stock (Class A) 400 million same 329 329 no par 7 Common Stock (Class B) 2400 million same 1.272 1.314 no par 8 Additional Paid in Capital 6.384 5,710 9 Treasury Stock 10 Retained Earnings 3,517 6,907 (3,390) 11 Accumulated Other Comprehensive Income (Low) (92) (213) 12 Other equity account(s) 13 Total Equity $ 9,812 $ 12,407 S (2,595) 14 Dreve line 15 Tefal Total Stanas TRUE TRUE 15 Using the retained earnings equation provide the rollforward of retained earnings balance for both current and prior years. 16 RE rollforward insert all activity titles below: Current Year Prior Year (intro to Stmt oft and look for retained earnings or accumulated deficit column 17 Beginning balance ( there are no dividends, Insert zero in the appropriate line item) 18 net income 19 dividends 20 + other activity in RE sum here all other RE activity per SE stmt 21 Ending balance proveline line 12 obowe FALSE FALSE 23 Calculate the following ratios for your company for the current and prior years and compare to Industry averages. Unk: Current Year Prior Year Industry Discuss your findings 25 EPS formularest n umerator formula result NA narative here! from Note 12 27 ROE Anumertar forma t formule link type narrative bere mo 29 Price earnings ratio $ 7180 format formule link y arative bere link e narrative 31 Dividend yield can take dividend yield from Note 11 - and back into Dividend Per Shares Checklist SLA - Equity IS 730 BS SSE Reuters Industry Data Ratios Exhibit Home Review View Page Layout Formulas Data Insert Draw Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? 26 12 Months Ended Consolidated Statements of Income - USD ($) $ in Millions May 31, 2017 May 31, 2016 May 31, 2018 Income Statement [Abstract] Revenues Cost of sales Gross profit $ 34,350 $ 32,376 $ 36,397 19,038 17,405 20,441 15,956 14,971 15,312 Demand creation expense Operating overhead expense Total selling and administrative expense 3,577 3,341 3,278 Page 1 7,191 7,934 7,222 11,511 10,469 10,563 Interest expense (income), net Other expense (income), net e Income before income taxes 3 Income tax expense NET INCOME 5 Earnings per common share: 5 Basic (in dollars per share) -Diluted (in dollars per share) 54 59 19 (140) 66 (196) 4,325 4,886 4,623 863 2,392 646 $ 1,933 $ 4,240 $ 3,760 $ 2.21 $ 2.16 $ 1.19 $ 2.56 $ 2.51 $1.17 B Dividends declared per common share (in dollars per share) $0.62 $0.70 $0.78 Consolidated Balance Sheets - USD ($)$ in Millions May 31, 2018 May 31, 2017 2 Current assets: 3 Cash and equivalents 4 Short-term investments 5 Accounts receivable, net 6 Inventories 7 Prepaid expenses and other current assets $ 3,808 $4,249 996 2,371 3,498 3,677 5,261 5,055 1,130 1,150 8 Total current assets 15,134 16,061 9 Property, plant and equipment, net 10 identifiable intangible assets, net 11 Goodwill 12 Deferred income taxes and other assets 13 TOTAL ASSETS 14 Current liabilities: 15 Current portion of long-term debt 16 Notes payable 17 Accounts payable 18 Accrued liabilities 19 Income taxes payable 20 Total current liabilities 21 Long-term debt 22 Deferred income taxes and other liabilities 23 Total liabilities 24 Commitments and contingencies (Note 15) 25 Redeemable preferred stock 26 Shareholders' equity: 27 Common stock at stated value 3,989 4,454 285 283 154 139 2,787 2,509 $ 22,536 $ 23,259 $ 6 $ 6 Page 1 336 325 2,279 2,048 3,269 3,011 150 84 5,474 6,040 3,468 3,471 1,907 3,216 12,724 10,852 for Ni 28 Capital in excess of stated value 29 Accumulated other comprehensive loss 30 Retained earnings 5,710 - esse 6,384 (92) (213) 3,517 6,907 31 Total shareholders' equity 9,812 12,407 32 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY $ 22,536 $ 23,259 33 Class A Convertible Common Stock 34 12 Months Ended Consolidated Statements of Cash Flows - USD (S) $ in Millions May 31, 2018 May 31, 2017 May 31, 2016 3 Cash provided by operations: 4 Net income 5 Adjustments to reconcile net income to net cash provided by operations: 6 Depreciation Deferred income taxes 8 Stock-based compensation 9 JAmortization and other $1,933 $ 4,240 $ 3,760 747 706 649 647 (80 (273) 218 215 236 27 10 13 (117) 10 Net foreign currency adjustments 11 Changes in certain working capital components and other assets and liabilities: 12 Decrease (increase) in accounts receivable 13 KIncrease) in inventories 14 Decrease (increase) in prepaid expenses and other current and non-current assets ncrease (decrease) in accounts payable, accrued liabilities and other current and non-current 15 labilities 16 Cash provided by operations 17 Cash provided (used) by investing activities: 18 Purchases of short-term investments 19 Maturities of short-term investments 20 Sales of short-term investments 21 Investments in reverse repurchase agreements 22 Additions to property, plant and equipment 23 Disposals of property, plant and equipment 24 Other investing activities 25 Cash provided (used) by investing activities 26 Cash used by financing activities: 27 Net proceeds from long-term debt issuance 28 Long-term debt payments, induding current portion 29 Increase (decrease) in notes payable 30 Payments on capital lease and other financing obligations 31 Proceeds from exerdse of stock options and other stock issuances 32 Repurchase of common stock 33 Dividends - common and preferred 34 Tax payments for net share settlement of equity awards 35 Cash used by finanding activities 36 Effect of exchange rate changes on cash and equivalents 37 Net increase (decrease) in cash and equivalents 38 Cash and equivalents, beginning of year 39 CASH AND EQUIVALENTS, END OF YEAR 40 Cash paid during the year for: 41 Interest, net of capitalized interest (99) 98 187 (426) 60 (255) (231) (590) 35 (120) (161) 1,515 (158) (586) 4,955 3,846 3,399 (5,367 2,924 (4,783) (5,928) 3,613 3,623 Page 1 2,496 2,423 2,386 150 (1,028) (1,105) (1,143] 10 13 (25) (34) (1,034 276 (1,008) 981 1,482 (44) (106) (6) (67) 327 13 (71 (17) (23) 507 489 733 (3,238) (1,022) (22 (2,974) (105) (4,254) (1,243) (3,223) (1,133) (29) (55) (2,148) (4,835) (20) 45 (714) 3,852 $ 3,138 670 441 3,808 3,138 $ 3,808 $4,249 98 70 125 748 703 529 42 Income taxes 252 266 294 43 Non-cash additions to property, plant and equipment 44 Dividends dedared and not paid $ 300 $ 271 $ 320 45 A SLA 11 Nike for mystu AutoSave OFF Formulas Data Review View Draw Page Layout Home Insert Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? v fx Class A Common Stock F1 Aumul Ohe Comphee Cap in Clas A Clas Canseldad men ofanholden t U a ClasA Comman Cla Commen SciCommaneck Total Commen Comman laming oComman Sock Stock Stock income a kaneon Cla Comman puchae of Clas Commen en sham 10 hae of ClanComman Sck u brdnds on commen vteck and pefe steck ne ef shaame employ, ef sham withhed for empley tn u ef shamtomploy, ntof share witd ole 94 eempnon 236 236 as inceme 1s percomphne income os) 17ingan hm May 11, 201 1 ing baanoeMy 31, 20 18 e Demein hlen tety l ferwd 20 ck en nsham 1,329 12,254 525 age 1 22 enenion to ClasCommon Seck in ahar) 23 Canenen Ca Cemmon Seck 24 uchae of Cl Common Sack e sha 2s hee of Cl Common Stock 26 dends on cemmen steckand preted stoc 27 of shammploynes, naof shas wihartenle 2s ce of shartemployem, nat of sha withheld formgle 29 d compton 24 Page 2 in ta 108 121 215 4240 31 phe comphemsive income lo 32 ding tance h M , 2 33nding balance M 1 2017 4 e Deo ahelden tty foa 35 eptens ese sham 4cptons eise Conenion 3 oenion 39 punhee of CesCommen Sck n sha 40 he of ClaCommen Steck 41 pvded en eemmen knd pfed seck 42 f shat mplaye nat of sham wed for mploy tan 43 un f sha t play nt of sham w ed for mgloye tam 4 bnt comp on 45 hincome 44 her compheiven ele 4r nding Bance Ma 1, 201E 4ding bance atMa 1, 2018 4 eoein Stocholden tity l Fonand edesfiationsoaned ning in wdane with A 2018-02A ng se rtats update 201 81) 329 1314 1814 12.407 5,70 24 iComman Seck n sham Cla Comman p4) 110 218 218 104 104 329 329 1.272 $ 17 2. 54 SLA - Equity Checklist IS BS CF SSE Reuters Industry Autosaven 50 SLA 11 Nike for mystudentsF19 Home Insert Draw Page Layout Formulas Data Review View Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? E25 x fx formula result NA Par Value Total Totals y Note Current Y Prior Yr Priory per Share Current Year Prior Year Change Note 1 5 Preferred Stok NA 6 Common Stock (Class A) 400 million same 329 329 no par 7 Common Stock (Class B) 2400 million same 1.272 1.314 no par 8 Additional Paid in Capital 6.384 5,710 9 Treasury Stock 10 Retained Earnings 3,517 6,907 (3,390) 11 Accumulated Other Comprehensive Income (Low) (92) (213) 12 Other equity account(s) 13 Total Equity $ 9,812 $ 12,407 S (2,595) 14 Dreve line 15 Tefal Total Stanas TRUE TRUE 15 Using the retained earnings equation provide the rollforward of retained earnings balance for both current and prior years. 16 RE rollforward insert all activity titles below: Current Year Prior Year (intro to Stmt oft and look for retained earnings or accumulated deficit column 17 Beginning balance ( there are no dividends, Insert zero in the appropriate line item) 18 net income 19 dividends 20 + other activity in RE sum here all other RE activity per SE stmt 21 Ending balance proveline line 12 obowe FALSE FALSE 23 Calculate the following ratios for your company for the current and prior years and compare to Industry averages. Unk: Current Year Prior Year Industry Discuss your findings 25 EPS formularest n umerator formula result NA narative here! from Note 12 27 ROE Anumertar forma t formule link type narrative bere mo 29 Price earnings ratio $ 7180 format formule link y arative bere link e narrative 31 Dividend yield can take dividend yield from Note 11 - and back into Dividend Per Shares Checklist SLA - Equity IS 730 BS SSE Reuters Industry Data Ratios Exhibit Home Review View Page Layout Formulas Data Insert Draw Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? 26 12 Months Ended Consolidated Statements of Income - USD ($) $ in Millions May 31, 2017 May 31, 2016 May 31, 2018 Income Statement [Abstract] Revenues Cost of sales Gross profit $ 34,350 $ 32,376 $ 36,397 19,038 17,405 20,441 15,956 14,971 15,312 Demand creation expense Operating overhead expense Total selling and administrative expense 3,577 3,341 3,278 Page 1 7,191 7,934 7,222 11,511 10,469 10,563 Interest expense (income), net Other expense (income), net e Income before income taxes 3 Income tax expense NET INCOME 5 Earnings per common share: 5 Basic (in dollars per share) -Diluted (in dollars per share) 54 59 19 (140) 66 (196) 4,325 4,886 4,623 863 2,392 646 $ 1,933 $ 4,240 $ 3,760 $ 2.21 $ 2.16 $ 1.19 $ 2.56 $ 2.51 $1.17 B Dividends declared per common share (in dollars per share) $0.62 $0.70 $0.78 Consolidated Balance Sheets - USD ($)$ in Millions May 31, 2018 May 31, 2017 2 Current assets: 3 Cash and equivalents 4 Short-term investments 5 Accounts receivable, net 6 Inventories 7 Prepaid expenses and other current assets $ 3,808 $4,249 996 2,371 3,498 3,677 5,261 5,055 1,130 1,150 8 Total current assets 15,134 16,061 9 Property, plant and equipment, net 10 identifiable intangible assets, net 11 Goodwill 12 Deferred income taxes and other assets 13 TOTAL ASSETS 14 Current liabilities: 15 Current portion of long-term debt 16 Notes payable 17 Accounts payable 18 Accrued liabilities 19 Income taxes payable 20 Total current liabilities 21 Long-term debt 22 Deferred income taxes and other liabilities 23 Total liabilities 24 Commitments and contingencies (Note 15) 25 Redeemable preferred stock 26 Shareholders' equity: 27 Common stock at stated value 3,989 4,454 285 283 154 139 2,787 2,509 $ 22,536 $ 23,259 $ 6 $ 6 Page 1 336 325 2,279 2,048 3,269 3,011 150 84 5,474 6,040 3,468 3,471 1,907 3,216 12,724 10,852 for Ni 28 Capital in excess of stated value 29 Accumulated other comprehensive loss 30 Retained earnings 5,710 - esse 6,384 (92) (213) 3,517 6,907 31 Total shareholders' equity 9,812 12,407 32 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY $ 22,536 $ 23,259 33 Class A Convertible Common Stock 34 12 Months Ended Consolidated Statements of Cash Flows - USD (S) $ in Millions May 31, 2018 May 31, 2017 May 31, 2016 3 Cash provided by operations: 4 Net income 5 Adjustments to reconcile net income to net cash provided by operations: 6 Depreciation Deferred income taxes 8 Stock-based compensation 9 JAmortization and other $1,933 $ 4,240 $ 3,760 747 706 649 647 (80 (273) 218 215 236 27 10 13 (117) 10 Net foreign currency adjustments 11 Changes in certain working capital components and other assets and liabilities: 12 Decrease (increase) in accounts receivable 13 KIncrease) in inventories 14 Decrease (increase) in prepaid expenses and other current and non-current assets ncrease (decrease) in accounts payable, accrued liabilities and other current and non-current 15 labilities 16 Cash provided by operations 17 Cash provided (used) by investing activities: 18 Purchases of short-term investments 19 Maturities of short-term investments 20 Sales of short-term investments 21 Investments in reverse repurchase agreements 22 Additions to property, plant and equipment 23 Disposals of property, plant and equipment 24 Other investing activities 25 Cash provided (used) by investing activities 26 Cash used by financing activities: 27 Net proceeds from long-term debt issuance 28 Long-term debt payments, induding current portion 29 Increase (decrease) in notes payable 30 Payments on capital lease and other financing obligations 31 Proceeds from exerdse of stock options and other stock issuances 32 Repurchase of common stock 33 Dividends - common and preferred 34 Tax payments for net share settlement of equity awards 35 Cash used by finanding activities 36 Effect of exchange rate changes on cash and equivalents 37 Net increase (decrease) in cash and equivalents 38 Cash and equivalents, beginning of year 39 CASH AND EQUIVALENTS, END OF YEAR 40 Cash paid during the year for: 41 Interest, net of capitalized interest (99) 98 187 (426) 60 (255) (231) (590) 35 (120) (161) 1,515 (158) (586) 4,955 3,846 3,399 (5,367 2,924 (4,783) (5,928) 3,613 3,623 Page 1 2,496 2,423 2,386 150 (1,028) (1,105) (1,143] 10 13 (25) (34) (1,034 276 (1,008) 981 1,482 (44) (106) (6) (67) 327 13 (71 (17) (23) 507 489 733 (3,238) (1,022) (22 (2,974) (105) (4,254) (1,243) (3,223) (1,133) (29) (55) (2,148) (4,835) (20) 45 (714) 3,852 $ 3,138 670 441 3,808 3,138 $ 3,808 $4,249 98 70 125 748 703 529 42 Income taxes 252 266 294 43 Non-cash additions to property, plant and equipment 44 Dividends dedared and not paid $ 300 $ 271 $ 320 45 A SLA 11 Nike for mystu AutoSave OFF Formulas Data Review View Draw Page Layout Home Insert Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? v fx Class A Common Stock F1 Aumul Ohe Comphee Cap in Clas A Clas Canseldad men ofanholden t U a ClasA Comman Cla Commen SciCommaneck Total Commen Comman laming oComman Sock Stock Stock income a kaneon Cla Comman puchae of Clas Commen en sham 10 hae of ClanComman Sck u brdnds on commen vteck and pefe steck ne ef shaame employ, ef sham withhed for empley tn u ef shamtomploy, ntof share witd ole 94 eempnon 236 236 as inceme 1s percomphne income os) 17ingan hm May 11, 201 1 ing baanoeMy 31, 20 18 e Demein hlen tety l ferwd 20 ck en nsham 1,329 12,254 525 age 1 22 enenion to ClasCommon Seck in ahar) 23 Canenen Ca Cemmon Seck 24 uchae of Cl Common Sack e sha 2s hee of Cl Common Stock 26 dends on cemmen steckand preted stoc 27 of shammploynes, naof shas wihartenle 2s ce of shartemployem, nat of sha withheld formgle 29 d compton 24 Page 2 in ta 108 121 215 4240 31 phe comphemsive income lo 32 ding tance h M , 2 33nding balance M 1 2017 4 e Deo ahelden tty foa 35 eptens ese sham 4cptons eise Conenion 3 oenion 39 punhee of CesCommen Sck n sha 40 he of ClaCommen Steck 41 pvded en eemmen knd pfed seck 42 f shat mplaye nat of sham wed for mploy tan 43 un f sha t play nt of sham w ed for mgloye tam 4 bnt comp on 45 hincome 44 her compheiven ele 4r nding Bance Ma 1, 201E 4ding bance atMa 1, 2018 4 eoein Stocholden tity l Fonand edesfiationsoaned ning in wdane with A 2018-02A ng se rtats update 201 81) 329 1314 1814 12.407 5,70 24 iComman Seck n sham Cla Comman p4) 110 218 218 104 104 329 329 1.272 $ 17 2. 54 SLA - Equity Checklist IS BS CF SSE Reuters Industry