Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started