Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Omit any extraneous information (e.g., # shares of stock issued, outstanding, eps for other than the net income, etc.), Compute the ratios and financial analysis

Omit any extraneous information (e.g., # shares of stock issued,

outstanding, eps for other than the net income, etc.), Compute the ratios and financial

analysis for each company as indicated below:

1. Horizontal analysis of the balance sheet and income statement (% change from

year to year) for all the years presented. Use comparative analysis, not trend

analysis.

2.Vertical analysis of the balance sheet and income statement for all years shown.

3. Ratio Analysis (Illustration 5A-1) for two years for each company

a.Current ratio

b. Quick ratio

c. Profit Margin on Sales

d. Price-Earnings ratio (you will have to google stock price on the balance

sheet date)

e. Debt to Assets ratio

image text in transcribedimage text in transcribedimage text in transcribed

Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended May 31, May 31, May 31, 2019 2018 2017 Income Statement [Abstract] Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense Interest expense (income), net Other (income) expense, net Income before income taxes Income tax expense NET INCOME Earnings per common share: Basic (in dollars per share) Diluted (in dollars per share) Weighted average common shares outstanding: Basic (in shares) Diluted (in shares). $ 39,117 $ 36,397 $ 34,350 21,643 20,441 19,038 17,474 15,956 15,312 3,753 3,577 3,341 8,949 7,934 7,222 12,702 11,511 10,563 | 49 - 54 591 (78) 66 (196) 4,801 4,325 4,886 772 2,392 646 $ 4,029 $1,933 $ 4,240 $ 2.55 $ 2.49 $ 1.19 $ 1.17 $ 2.56 $ 2.51 | 1,579.7 1,618.4 1,623.8 1,659.1 1,657.8 1,692 Dulcu s ual _ _ __ .. Consolidated Balance Sheets - USD ($) $ in Millions May 31, May 31, 2019 2018 Current assets: Cash and equivalents $ 4,466 $4,249 Short-term investments 197 996 Accounts receivable, net 4,272 3 4QR Inventories 5,622 5,261 Prepaid expenses and other current assets 1,968 1,130 8 Total current assets Property, plant and equipment, net 16,525 4,744 15,134 4,454 285 10 Identifiable intangible assets, net 11 Goodwill Deferred income taxes and other assets 283 154 2,011 154 2,509 23,717 22,536 6 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 336 2,279 3.269 9 2,612 5,010 229 7,866 3,464 150 6,040 3,468 9 2,612 5,010 16 Notes payable 17 Accounts payable 18 Accrued liabilities 19 Income taxes payable 20 Total current liabilities 21 Long-term debt Deferred income taxes and other liabilities 229 336 2,279 3,269 150 6,040 3,468 3,216 7,866 3,464 3,347 22 Commitments and contingencies (Note 18) 24 Redeemable preferred stock 25 Shareholders' equity: 26 Capital in excess of stated value Accumulated other comprehensive income (loss) 7,163 231 6,384 (92) 1,643 9,040 23,717 3,517 9,812 22,536 28 Retained earnings 29 Total shareholders' equity TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 30 Class A Convertible Common Stock 31 32 Shareholders' equity: 33 Common stock at stated value 34 Class B Common Stock 35 Shareholders' equity: 36 Common stock at stated value $3 $3 Consolidated Statements of Income - USD ($) shares in Millions, $ in Millions 12 Months Ended May 31, May 31, May 31, 2019 2018 2017 Income Statement [Abstract] Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Total selling and administrative expense Interest expense (income), net Other (income) expense, net Income before income taxes Income tax expense NET INCOME Earnings per common share: Basic (in dollars per share) Diluted (in dollars per share) Weighted average common shares outstanding: Basic (in shares) Diluted (in shares). $ 39,117 $ 36,397 $ 34,350 21,643 20,441 19,038 17,474 15,956 15,312 3,753 3,577 3,341 8,949 7,934 7,222 12,702 11,511 10,563 | 49 - 54 591 (78) 66 (196) 4,801 4,325 4,886 772 2,392 646 $ 4,029 $1,933 $ 4,240 $ 2.55 $ 2.49 $ 1.19 $ 1.17 $ 2.56 $ 2.51 | 1,579.7 1,618.4 1,623.8 1,659.1 1,657.8 1,692 Dulcu s ual _ _ __ .. Consolidated Balance Sheets - USD ($) $ in Millions May 31, May 31, 2019 2018 Current assets: Cash and equivalents $ 4,466 $4,249 Short-term investments 197 996 Accounts receivable, net 4,272 3 4QR Inventories 5,622 5,261 Prepaid expenses and other current assets 1,968 1,130 8 Total current assets Property, plant and equipment, net 16,525 4,744 15,134 4,454 285 10 Identifiable intangible assets, net 11 Goodwill Deferred income taxes and other assets 283 154 2,011 154 2,509 23,717 22,536 6 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 336 2,279 3.269 9 2,612 5,010 229 7,866 3,464 150 6,040 3,468 9 2,612 5,010 16 Notes payable 17 Accounts payable 18 Accrued liabilities 19 Income taxes payable 20 Total current liabilities 21 Long-term debt Deferred income taxes and other liabilities 229 336 2,279 3,269 150 6,040 3,468 3,216 7,866 3,464 3,347 22 Commitments and contingencies (Note 18) 24 Redeemable preferred stock 25 Shareholders' equity: 26 Capital in excess of stated value Accumulated other comprehensive income (loss) 7,163 231 6,384 (92) 1,643 9,040 23,717 3,517 9,812 22,536 28 Retained earnings 29 Total shareholders' equity TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 30 Class A Convertible Common Stock 31 32 Shareholders' equity: 33 Common stock at stated value 34 Class B Common Stock 35 Shareholders' equity: 36 Common stock at stated value $3 $3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Simple recursion

Answered: 1 week ago