J No 11 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? c10 x V fx A B C D E F G H I #shares Authorized #shares Outstanding wat place S Par Value Total $ Total $ Important information may be on faceliarine y Melete the Current Y Prior Y Current Yr P rior Yr per Share Current Year Prior Year Change from Note 11 from St SE 5 NA Preferred Stock NA NA NA $ $ $ 6 Common Stock (Class A) 400 million same 329 1 329 no par 7. Common Stock (Class B) 2400 millior same 1,272 1,314 no par 8 Additional Paid in Capital 6,3845,710 674 9 Treasury Stock 10 Retained Earnings 3,517 6 ,907 (3,390) 11 Accumulated Other Comprehensive income (Loss) (92) (213) 121 12 Other equity account(s) 13 Total Equity 9,812 $ 12,407 $ (2,595) 14 provine 15 Totals - Total Se on BS 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 Hinti tott of land look for retained earnings OR accumulated deficit column 17 Beginning balance If 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 Est 21 Ending balance proveline 24 ne 12 above FALSE 23 Calculate the following ratios for your company for the current and prior years and compare to industry averages. Link: Current Year et Yew Prior Year Industry L Discuss your findings. | ani NA type narrative from Note 12- 165810 27 ROE: formularul in f ormem Ink type narrative here link denominato 29 Price earnings ratio 1 710 f u ll $ 32.99 A l le l ink type narrative here) At domin 31 Dividend yield Ink type narrative here can take dividend yield from Note 11 - and back into Dividend Per Shore 210 instructions about finding stock prket is not already included in table above) change in market priceyr over yr 18.81 This anilgament requires you to calculate the price earnings ratio-Current stock price/ EPS. However, you cannot use today's stock thenumer Brause you are takulating toas ole ted ForcampApple's yearend is Sept 30, 2017 for the current year and Sept 24, 2016 for the prior year. You'd have to find Apple's stock price on those EPS 3 5.5% Home Insert Draw Page Layout Formulas Data Review = = SE 11 A Calibri BI U A A Paste Recover Unsaved Workbooks. We were able to save changes to one or more files A1 1 x fx Consolidated Statements of Income - USD ($) $ in M 12 Months Ended Consolidated Statements of Income - USD ($) $ in Millions May 31, 2018 May 31, 2017 May 31, 2016 $36,397 20,441 15,956 $ 34,350 19,038 15,312 $ 32,376 17,405 14,971 Income Statement(Abstract] Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense Page 1 3,577 7,934 11,511 3,341 7,222 10,563 3,278 7,191 10.469 54 4,325 Interest expense (income), net Other expense (income), net Income before income taxes Income tax expense NET INCOME Earnings per common share: Basic (in dollars per share) Diluted (in dollars per share) Dividends declared per common share in dollars per share 59 (196) 4,886 646 $ 4,240 (140) 4,623 863 $ 3,760 2,392 $ 1,933 $ 1.19 $ 1.17 $ 0.78 $ 2.56 $ 2.51 $ 0.70 $ 2.21 $ 2.16 $ 0.62 Recover Unsaved Workbooks. We were able to save changes to one or mor 126 x fx Consolidated Balance Sheets - USD ($) $ in Millions May 31, 2018 May 31, 2017 $ 4,249 996 3,498 5,261 1,130 15,134 4,454 285 154 2,509 $ 22,536 $ 3,808 2,371 3,677 5,055 1,150 16,061 3,989 283 139 2,787 $ 23,259 $6 S6 Current assets: Cash and equivalents 4 Short-term investments 5 Accounts receivable, net 6 Inventories 7 Prepaid expenses and other current assets Total current assets 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 28 Capital in excess of stated value 29 Accumulated other comprehensive loss 30 Retained earings 31 Total shareholders' equity 32 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 33 Class A Convertible Common Stock Page 1 325 2,048 3.011 336 2,279 3,269 150 6,040 3,468 3.216 12,724 5,474 1.907 10.852 for Nike, o - essentia 6,384 (92) 3,517 9,812 $ 22,536 5,710 (213) 6,907 12,407 23.259 11 A Calibri B I U A A Paste E Recover Unsaved Workbooks. We were able to save changes to one or more file x fe Stock-based compensation C D A8 12 Months Ended May 31, May 31, 2018 2017 May 31, Consolidated Statements of Cash Flows - USD ($) $ in Millions 2016 $ 4,240 $ 3,760 706 (273) 215 RO 199) (117) 98 1255) (426) (231) 1120) 1158) (590) (161 (586 4,955 3,846 (4,783) 3,613 2,495 0 (1,028) (5,928) 3,623 2,423 Page 5.367 2,924 2,386 150 (1,143 (1,105) Cash provided by operations Net Income Adjustments to reconcile net income to net cash provided by operations: Depreciation beered income 8 Stock-based compensation Amortization and other 10 Net foreign currency adjustments 11 Changes in certain working capital components and other assets and liabilities: 12 Decrease increase in accounts receivable 13 increase in inventories 14 Decrease increase in prepaid expenses and other current and non-current assets increase (decrease in accounts payable accrued liabilities and other current and non- 15 kumtibilities 16 Cash provided by operations 17 Cash provided used) by Investing activities: 18 Purchases of short term investments 19 Matures of short term investments 20 sales of short term investments 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, including current portion 29 crise decrease in notes payable 30 Payments on capital lease and other financing obligations 31 Proceeds from rise of stock options and other stock issuances 32 Repurchase of common stock 33 Dividends - common and pered 34 Tax payments for net share settlement of equity awards 35 Cash used by financing 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 29 CASH AND EQUIVALENTS, END OF YEAR 40 Cash paid during the yew for Interest, net of capitalized interest 42 comes 43 Non cash additions to property, plant and equipment Dividends declared and not paid 10 (25) 276 (34) (1,008) 11.034) 1,482 981 (106 (44) 733 (23) 489 507 14.254) 3,223) 3,238 (1,243) (1,133) (1,022 (55) 14,835) 2,148) 45201105 (29) 1714 3,808 $ 4,249 3,138 $ 3,808 $ 3,138 703 294 $ 320 $ 300 271 Home Insert Draw Page Layout Formulas Data Review View Calibri 11 A A ce General Paste BIU D $ % 9 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? 4 x fx Class A Common Stock Les 8 a pi Concordement of shareholder' quity USDS) that is Million Accumulated One Campahan Comman Cass A Common Soccormont Common Value beginning balance May 31, 2015 PREDC) in Schelden' Hall Ford EFFE 7 Cannon to Class Common cash Conversion to Class Common Stock Common Suck in the 1 S toCommon Sech 11 Dicends on common fack and p e stoc 12 of chams to employees, net of shares wie 1 of that play of shares wie 14 p atien ge 13 Ending balance May 31, 2016 Den in Schelden yoll Forward onto Casa Common Stock of Class Common Socks she chase of C Cammon Stock Page 2 ce of shares to employment of shares witheld for employees ce of shares to employees, net of shares withheld for employees LID LEILA 3 wome ding Balance in sha May 31, 2017 ding balance May 31, 2017 RCS De n Stockholdes" quity Roll Forward FFFFF 1 ce of shares to employees, net of she winhed / sive income foss) Ending Balance De May 31, 2018 Ending May 11, 2018 In Deere Scheldenv all Forward // / // / // // // // Spandards 1018-02 Checklist SLA - Equity es SSE Reuters Industry a J No 11 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? c10 x V fx A B C D E F G H I #shares Authorized #shares Outstanding wat place S Par Value Total $ Total $ Important information may be on faceliarine y Melete the Current Y Prior Y Current Yr P rior Yr per Share Current Year Prior Year Change from Note 11 from St SE 5 NA Preferred Stock NA NA NA $ $ $ 6 Common Stock (Class A) 400 million same 329 1 329 no par 7. Common Stock (Class B) 2400 millior same 1,272 1,314 no par 8 Additional Paid in Capital 6,3845,710 674 9 Treasury Stock 10 Retained Earnings 3,517 6 ,907 (3,390) 11 Accumulated Other Comprehensive income (Loss) (92) (213) 121 12 Other equity account(s) 13 Total Equity 9,812 $ 12,407 $ (2,595) 14 provine 15 Totals - Total Se on BS 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 Hinti tott of land look for retained earnings OR accumulated deficit column 17 Beginning balance If 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 Est 21 Ending balance proveline 24 ne 12 above FALSE 23 Calculate the following ratios for your company for the current and prior years and compare to industry averages. Link: Current Year et Yew Prior Year Industry L Discuss your findings. | ani NA type narrative from Note 12- 165810 27 ROE: formularul in f ormem Ink type narrative here link denominato 29 Price earnings ratio 1 710 f u ll $ 32.99 A l le l ink type narrative here) At domin 31 Dividend yield Ink type narrative here can take dividend yield from Note 11 - and back into Dividend Per Shore 210 instructions about finding stock prket is not already included in table above) change in market priceyr over yr 18.81 This anilgament requires you to calculate the price earnings ratio-Current stock price/ EPS. However, you cannot use today's stock thenumer Brause you are takulating toas ole ted ForcampApple's yearend is Sept 30, 2017 for the current year and Sept 24, 2016 for the prior year. You'd have to find Apple's stock price on those EPS 3 5.5% Home Insert Draw Page Layout Formulas Data Review = = SE 11 A Calibri BI U A A Paste Recover Unsaved Workbooks. We were able to save changes to one or more files A1 1 x fx Consolidated Statements of Income - USD ($) $ in M 12 Months Ended Consolidated Statements of Income - USD ($) $ in Millions May 31, 2018 May 31, 2017 May 31, 2016 $36,397 20,441 15,956 $ 34,350 19,038 15,312 $ 32,376 17,405 14,971 Income Statement(Abstract] Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense Page 1 3,577 7,934 11,511 3,341 7,222 10,563 3,278 7,191 10.469 54 4,325 Interest expense (income), net Other expense (income), net Income before income taxes Income tax expense NET INCOME Earnings per common share: Basic (in dollars per share) Diluted (in dollars per share) Dividends declared per common share in dollars per share 59 (196) 4,886 646 $ 4,240 (140) 4,623 863 $ 3,760 2,392 $ 1,933 $ 1.19 $ 1.17 $ 0.78 $ 2.56 $ 2.51 $ 0.70 $ 2.21 $ 2.16 $ 0.62 Recover Unsaved Workbooks. We were able to save changes to one or mor 126 x fx Consolidated Balance Sheets - USD ($) $ in Millions May 31, 2018 May 31, 2017 $ 4,249 996 3,498 5,261 1,130 15,134 4,454 285 154 2,509 $ 22,536 $ 3,808 2,371 3,677 5,055 1,150 16,061 3,989 283 139 2,787 $ 23,259 $6 S6 Current assets: Cash and equivalents 4 Short-term investments 5 Accounts receivable, net 6 Inventories 7 Prepaid expenses and other current assets Total current assets 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 28 Capital in excess of stated value 29 Accumulated other comprehensive loss 30 Retained earings 31 Total shareholders' equity 32 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 33 Class A Convertible Common Stock Page 1 325 2,048 3.011 336 2,279 3,269 150 6,040 3,468 3.216 12,724 5,474 1.907 10.852 for Nike, o - essentia 6,384 (92) 3,517 9,812 $ 22,536 5,710 (213) 6,907 12,407 23.259 11 A Calibri B I U A A Paste E Recover Unsaved Workbooks. We were able to save changes to one or more file x fe Stock-based compensation C D A8 12 Months Ended May 31, May 31, 2018 2017 May 31, Consolidated Statements of Cash Flows - USD ($) $ in Millions 2016 $ 4,240 $ 3,760 706 (273) 215 RO 199) (117) 98 1255) (426) (231) 1120) 1158) (590) (161 (586 4,955 3,846 (4,783) 3,613 2,495 0 (1,028) (5,928) 3,623 2,423 Page 5.367 2,924 2,386 150 (1,143 (1,105) Cash provided by operations Net Income Adjustments to reconcile net income to net cash provided by operations: Depreciation beered income 8 Stock-based compensation Amortization and other 10 Net foreign currency adjustments 11 Changes in certain working capital components and other assets and liabilities: 12 Decrease increase in accounts receivable 13 increase in inventories 14 Decrease increase in prepaid expenses and other current and non-current assets increase (decrease in accounts payable accrued liabilities and other current and non- 15 kumtibilities 16 Cash provided by operations 17 Cash provided used) by Investing activities: 18 Purchases of short term investments 19 Matures of short term investments 20 sales of short term investments 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, including current portion 29 crise decrease in notes payable 30 Payments on capital lease and other financing obligations 31 Proceeds from rise of stock options and other stock issuances 32 Repurchase of common stock 33 Dividends - common and pered 34 Tax payments for net share settlement of equity awards 35 Cash used by financing 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 29 CASH AND EQUIVALENTS, END OF YEAR 40 Cash paid during the yew for Interest, net of capitalized interest 42 comes 43 Non cash additions to property, plant and equipment Dividends declared and not paid 10 (25) 276 (34) (1,008) 11.034) 1,482 981 (106 (44) 733 (23) 489 507 14.254) 3,223) 3,238 (1,243) (1,133) (1,022 (55) 14,835) 2,148) 45201105 (29) 1714 3,808 $ 4,249 3,138 $ 3,808 $ 3,138 703 294 $ 320 $ 300 271 Home Insert Draw Page Layout Formulas Data Review View Calibri 11 A A ce General Paste BIU D $ % 9 Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? 4 x fx Class A Common Stock Les 8 a pi Concordement of shareholder' quity USDS) that is Million Accumulated One Campahan Comman Cass A Common Soccormont Common Value beginning balance May 31, 2015 PREDC) in Schelden' Hall Ford EFFE 7 Cannon to Class Common cash Conversion to Class Common Stock Common Suck in the 1 S toCommon Sech 11 Dicends on common fack and p e stoc 12 of chams to employees, net of shares wie 1 of that play of shares wie 14 p atien ge 13 Ending balance May 31, 2016 Den in Schelden yoll Forward onto Casa Common Stock of Class Common Socks she chase of C Cammon Stock Page 2 ce of shares to employment of shares witheld for employees ce of shares to employees, net of shares withheld for employees LID LEILA 3 wome ding Balance in sha May 31, 2017 ding balance May 31, 2017 RCS De n Stockholdes" quity Roll Forward FFFFF 1 ce of shares to employees, net of she winhed / sive income foss) Ending Balance De May 31, 2018 Ending May 11, 2018 In Deere Scheldenv all Forward // / // / // // // // Spandards 1018-02 Checklist SLA - Equity es SSE Reuters Industry a