Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What are the following Ratios using the below financial statements with observations and comments? 1. Current Ratio (Current Assets/Current Liabilities) 2. Quick Ratio ((current assets-inventory)/current

What are the following Ratios using the below financial statements with observations and comments?

1. Current Ratio (Current Assets/Current Liabilities)

2. Quick Ratio ((current assets-inventory)/current liabilities)

3. Inventory Turnover (sales/average inventory)

4. Receivables Turnover (sales/accounts receivable)

5. Average collection period (accounts receivable/sales per day)

6. Fixed asset Turnover (Sales/fixed assets)

7. Total Asset Turnover (sales/total assets)

8. Gross Profit margin (revenues - cost of goods sold)/sales))

9. Operating profit margin (operating earnings/sales)

10. Net profit margin (earnings after taxes/sales)

11. Return on Assets (earnings after taxes/total assets)

12. Return on Equity (earnings after taxes/equity)

13. Basic earning power (EBIT/Total Assets)

14.Debt Ratio (debt/total assets)

15. Debt to equity ratio (debt/equity)

Consolidated Statements of Income - USD ($) $ in Millions 12 Months Ended
May 31, 2017 May 31, 2016
Income Statement [Abstract]
Revenues $ 34,350 $ 32,376
Cost of sales 19,038 17,405
Gross profit 15,312 14,971
Demand creation expense 3,341 3,278
Operating overhead expense 7,222 7,191
Total selling and administrative expense 10,563 10,469
Interest expense (income), net 59 19
Other (income) expense, net -196 -140
Income before income taxes 4,886 4,623
Income tax expense 646 863
NET INCOME $ 4,240 $ 3,760
Earnings per common share:
Basic (in dollars per share) $ 2.56 $ 2.21
Diluted (in dollars per share) 2.51 2.16
Dividends declared per common share (in dollars per share) $ 0.70 $ 0.62

Consolidated Balance Sheets - USD ($) $ in Millions

May 31, 2017 May 31, 2016
Current assets:
Cash and equivalents $ 3,808 $ 3,138
Short-term investments 2,371 2,319
Accounts receivable, net 3,677 3,241
Inventories 5,055 4,838
Prepaid expenses and other current assets 1,150 1,489
Total current assets 16,061 15,025
Property, plant and equipment, net 3,989 3,520
Identifiable intangible assets, net 283 281
Goodwill 139 131
Deferred income taxes and other assets 2,787 2,422
TOTAL ASSETS 23,259 21,379
Current liabilities:
Current portion of long-term debt 6 44
Notes payable 325 1
Accounts payable 2,048 2,191
Accrued liabilities 3,011 3,037
Income taxes payable 84 85
Total current liabilities 5,474 5,358
Long-term debt 3,471 1,993
Deferred income taxes and other liabilities 1,907 1,770
Commitments and contingencies
Redeemable preferred stock 0 0
Shareholders equity:
Capital in excess of stated value 8,638 7,786
Accumulated other comprehensive (loss) income -213 318
Retained earnings 3,979 4,151
Total shareholders equity 12,407 12,258
TOTAL LIABILITIES AND SHAREHOLDERS EQUITY 23,259 21,379
Class A Convertible Common Stock
Shareholders equity:
Common stock at stated value 0 0
Class B Common Stock
Shareholders equity:
Common stock at stated value $ 3 $ 3

Consolidated Statements of Cash Flows - USD ($) $ in Millions 12 Months Ended
May 31, 2017 May 31, 2016 May 31, 2015
Cash provided by operations:
Net income $ 4,240 $ 3,760 $ 3,273
Income charges (credits) not affecting cash:
Depreciation 706 649 606
Deferred income taxes -273 -80 -113
Stock-based compensation 215 236 191
Amortization and other 10 13 43
Net foreign currency adjustments -117 98 424
Changes in certain working capital components and other assets and liabilities:
(Increase) decrease in accounts receivable -426 60 -216
(Increase) in inventories -231 -590 -621
(Increase) in prepaid expenses and other current assets -120 -161 -144
(Decrease) increase in accounts payable, accrued liabilities and income taxes payable -364 -889 1,237
Cash provided by operations 3,640 3,096 4,680
Cash used by investing activities:
Purchases of short-term investments -5,928 -5,367 -4,936
Maturities of short-term investments 3,623 2,924 3,655
Sales of short-term investments 2,423 2,386 2,216
Investments in reverse repurchase agreements 0 150 -150
Additions to property, plant and equipment -1,105 -1,143 -963
Disposals of property, plant and equipment 13 10 3
Other investing activities -34 6 0
Cash used by investing activities -1,008 -1,034 -175
Cash used by financing activities:
Net proceeds from long-term debt issuance 1,482 981 0
Long-term debt payments, including current portion -44 -106 -7
Increase (decrease) in notes payable 327 -67 -63
Payments on capital lease and other financing obligations -17 -7 -19
Proceeds from exercise of stock options and other stock issuances 489 507 514
Excess tax benefits from share-based payment arrangements 177 281 218
Repurchase of common stock -3,223 -3,238 -2,534
Dividends common and preferred -1,133 -1,022 -899
Cash used by financing activities -1,942 -2,671 -2,790
Effect of exchange rate changes on cash and equivalents -20 -105 -83
Net increase (decrease) in cash and equivalents 670 -714 1,632
Cash and equivalents, beginning of year 3,138 3,852 2,220
CASH AND EQUIVALENTS, END OF YEAR 3,808 3,138 3,852
Cash paid during the year for:
Interest, net of capitalized interest 98 70 53
Income taxes 703 748 1,262
Non-cash additions to property, plant and equipment 266 252 206
Dividends declared and not paid $ 300 $ 271 $ 240

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Pricing Analytics Models And Advanced Quantitative Techniques For Product Pricing

Authors: Walter R. Paczkowski

1st Edition

1138623938, 9781138623934

More Books

Students also viewed these Finance questions