Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover themy A21 x fx Ending balance C D G H HJK A company's equity structure can be quite complicated with common stock, preferred stock and treasury stock. Additionally, some companies have more than one "class of common stock and/or preferred stock. Also, authorized shares are different from issued shares and outstanding shares. Identify the following information from our company's equity accounts. MUST link to the financial statement tabs where possible; manual insert only when information is not in a separate cell in the F5. Shaded areas means no data in those cells not applicable) shares Authorized #shares Outstanding $Par Value Total o reld Total Important Information may be on f ity Note to the current Yr P rior Y Current Yr Prior Yr p er Share current Year Prior Year Change Note II 5 Preferred Stock 6 Common Stock (Class A) 400 million same 329 329 no par 7 Common Stock (Class B) 2400 millior same 1,272 1 ,314 no par 8 Additional Paid in Capital 6,384 9 Treasury Stock 10 Retained Earnings 3,517 6,907 (3,390) 11 Accumulated Other Comprehensive Income (Loss) 192) (213) 121 12 Other equity accounts 13 Total Equity $ 9,812 $ 12,407 $ 2,595) proutine 15 Total Total SE on - TRUE TRUE 15 Using the retained earnings equation, provide the rollforward of retained earning balance for both current and prior years. 16 RE rollforward install activity titles below current Year Prior Year hinto to Santo St and look for retained earning OR accumulated delicit column 17 Beginning balance Othere are no dividends, Insert zero in the appropriateline item) 18 net income 19 -dividends 20 other activity in RE -- sum here of other Reactivity per SE 21 - Ending balance as for your company for the current and prior years and compare 23 Calculate the following ratlos for your company for the Prior Year Industry Discuss your finding 25 EPS from Note 12 27 ROE L ink Tygen 29 Price earnings ratio 31 Dividend yield: Checklist Ank ite arrative here S SE SLA - Equity Ratios Exhibit IS BS C E * *E- Cell Styles Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? A21 x fx 'Ending balance 23 Calculate the following ratios for your company for the current and prior years and compare to industry averages. Link: 24 Current Year Prior Year Industry Discuss your findings 25 EPS: inkrum fomnule mult IntructorAma N A pe narrative here from Note 12 --> 27 ROE: pole mult u mer formal nk type narrative here 26 28 3 5.5% 29 Price earnings ratio type narrative here 3 .99 form 30 31 Dividend yield: | lm LION con toke dividend yield from Note 11 --> and back into Dividend Per Shares 33 instructions about finding stock price: (if it is not already included in table above) change in market priceyr over 18. 81 This signment requires you to calculate the Price earnings ratio Current stock price/ EPS. However, you cannot use today's stock price in the numerator because you are caculating this rations of a specific date. For example, Apple'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 dates 331 To find our company stock orice of both vear ends.co to https//finance.vahoo.com In the search box at top, type in company name Click on Historical Data Enter the date that you want in both the start and end date of Time Period and click Done and Apply Choose the Close price year end fails on a weekend, use the prior Friday close price Patins Fxhibit AutoSave OFF su 5 = Home Insert Draw Page Layout Formulas Review Data = = abe X C alibri 11 A A Paste BI U OA Recover Unsaved Workbooks. We were able to save changes to one or more files X V fx Consolidated Statements of Income - USD ($) $ in M Consolidated Statements of Income - USD ($) $ in Millions 12 Months Ended May 31, 2018 May 31, 2017 May 31, 2016 $36,397 20,441 15,956 $ 34,350 1 9,038 15,312 Income Statement [Abstract] Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense $ 32,376 17,405 14,971 3,278 7,191 10,469 3,577 7,934 Page 13 3,341 7,222 10,563 11,511 54 Interest expense (income), net Other expense (income), net 2 Income before income taxes 3 Income tax expense NET INCOME 5 Earnings per common share: 5 Basic (in dollars per share) 7 Diluted (in dollars per share) B Dividends declared per common share in dollars per share) 66 4,325 2,392 $ 1,933 59 19 (196) (140) 4,886 4,623 646863 $ 4,240 $ 3,760 $ 1.19 $ 1.17 $ 0.78 $ 2.56 $ 2.51 $ 0.70 $ 2.21 $ 2.16 $ 0.62 NM 126 x fx 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 8 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 $4,249 996 3498 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 325 2,048 3,011 84 336 2,279 3,269 150 6,040 3,468 3,216 12,724 5,474 3,471 1,907 10,852 for Nik 24 Commitments and contingencies (Note 15) 25 Redeemable preferred stock 26 Shareholders' equity: Common stock at stated value Capital in excess of stated value Accumulated other comprehensive loss 30 Retained earings 31 Total shareholders' equity 32 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY Class A Convertible Common Stock 5,710 | 27 ROE: pole mult u mer formal nk type narrative here 26 28 3 5.5% 29 Price earnings ratio type narrative here 3 .99 form 30 31 Dividend yield: | lm LION con toke dividend yield from Note 11 --> and back into Dividend Per Shares 33 instructions about finding stock price: (if it is not already included in table above) change in market priceyr over 18. 81 This signment requires you to calculate the Price earnings ratio Current stock price/ EPS. However, you cannot use today's stock price in the numerator because you are caculating this rations of a specific date. For example, Apple'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 dates 331 To find our company stock orice of both vear ends.co to https//finance.vahoo.com In the search box at top, type in company name Click on Historical Data Enter the date that you want in both the start and end date of Time Period and click Done and Apply Choose the Close price year end fails on a weekend, use the prior Friday close price Patins Fxhibit AutoSave OFF su 5 = Home Insert Draw Page Layout Formulas Review Data = = abe X C alibri 11 A A Paste BI U OA Recover Unsaved Workbooks. We were able to save changes to one or more files X V fx Consolidated Statements of Income - USD ($) $ in M Consolidated Statements of Income - USD ($) $ in Millions 12 Months Ended May 31, 2018 May 31, 2017 May 31, 2016 $36,397 20,441 15,956 $ 34,350 1 9,038 15,312 Income Statement [Abstract] Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense $ 32,376 17,405 14,971 3,278 7,191 10,469 3,577 7,934 Page 13 3,341 7,222 10,563 11,511 54 Interest expense (income), net Other expense (income), net 2 Income before income taxes 3 Income tax expense NET INCOME 5 Earnings per common share: 5 Basic (in dollars per share) 7 Diluted (in dollars per share) B Dividends declared per common share in dollars per share) 66 4,325 2,392 $ 1,933 59 19 (196) (140) 4,886 4,623 646863 $ 4,240 $ 3,760 $ 1.19 $ 1.17 $ 0.78 $ 2.56 $ 2.51 $ 0.70 $ 2.21 $ 2.16 $ 0.62 NM 126 x fx 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 8 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 $4,249 996 3498 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 325 2,048 3,011 84 336 2,279 3,269 150 6,040 3,468 3,216 12,724 5,474 3,471 1,907 10,852 for Nik 24 Commitments and contingencies (Note 15) 25 Redeemable preferred stock 26 Shareholders' equity: Common stock at stated value Capital in excess of stated value Accumulated other comprehensive loss 30 Retained earings 31 Total shareholders' equity 32 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY Class A Convertible Common Stock 5,710 |
