Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Complete a horizontal analysis using the balance sheet for the Nike, Inc. Find the amount and percent of increase or decrease for 2016 to 2017
Complete a horizontal analysis using the balance sheet for the Nike, Inc. Find the amount and percent of increase or decrease for 2016 to 2017 and 2017 to 2018. Fill in the blanks on the table below. Amounts do not need the dollar sign ($), whole numbers only, no decimals. Percentages should be two decimal places and no percentage sign (%) is needed.
(in millions) | 2018 | 2017 | 2016 |
ASSETS | |||
Current Assets | |||
Cash and equivalents | 4,249 | 3,808 | 3,138 |
Short-term investments | 996 | 2,371 | 2,319 |
Accounts receivable, net | 3,498 | 3,677 | 3,241 |
Inventories | 5,261 | 5,055 | 4,838 |
Prepaid expenses and other current assets | 1,130 | 1,150 | 1,489 |
Total Current Assets | 15,134 | 16,061 | 15,025 |
Property, plant and equipment; net | 4,454 | 3,989 | 3,520 |
Identifiable intangible assets, net | 285 | 283 | 281 |
Goodwill | 154 | 139 | 131 |
Deferred income taxes and other assets | 2,509 | 2,787 | 2,422 |
TOTAL ASSETS | 22,536 | 23,259 | 21,379 |
LIABILITIES AND SHAREHOLDERS' EQUITY | |||
Current Liabilities | |||
Current portion of long-term debt | 6 | 6 | 44 |
Notes payable | 336 | 325 | 1 |
Accounts payable | 2,279 | 2,048 | 2,191 |
Accrued liabilities | 3,269 | 3,011 | 3,037 |
Income taxes payable | 150 | 84 | 85 |
Total current liabilities | 6,040 | 5,474 | 5,358 |
Long-term debt | 3,468 | 3,471 | 1,993 |
Deferred income taxes and other liabilities | 3,216 | 1,907 | 1,770 |
Commitments and contingencies | |||
Redeemable preferred stock | |||
Shareholders' equity | |||
Common stock at stated value | |||
Class A convertible - 329 and 353 shares outstanding | |||
Class B - 1,314 and 1,329 shares outstanding | 3 | 3 | 3 |
Capital in excess of stated value | 6,384 | 5,710 | 7,786 |
Accumulated other comprehensive (loss) income | (92) | (213) | 318 |
Retained earnings | 3,517 | 6,907 | 4,151 |
Total shareholders' equity | 9,812 | 12,407 | 12,258 |
TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY | 22,536 | 23,259 | 21,379 |
Statements of Income, Nike, Inc.
in millions, except per share data | 2018 | 2017 | 2016 |
Revenues | 36,397 | 34,350 | 32,376 |
Cost of sales | 20,441 | 19,038 | 17,405 |
Gross Profit | 15,956 | 15,312 | 14,971 |
Demand creation expense | 3,577 | 3,341 | 3,278 |
Operating overhead expense | 7,934 | 7,222 | 7,191 |
Total selling and administrative expense | 11,511 | 10,563 | 10,469 |
Interest expense (income), net | 54 | 59 | 19 |
Other expense (income), net | 66 | (196) | (140) |
Income before income taxes | 4,325 | 4,886 | 4,623 |
Income tax expense | 2,392 | 646 | 863 |
NET INCOME | 1,933 | 4,240 | 3,760 |
Earnings per common share: | |||
Basic | 1.19 | 2.56 | 2.21 |
Diluted | 1.17 | 2.51 | 2.16 |
Dividends declared per common share | 0.78 | 0.70 | 0.62 |
Liquidity | 2018 | 2017 | |
Working Capital | |||
Current Ratio | |||
Quick Ratio | |||
Profitability | 2018 | 2017 | |
Asset Turnover | |||
Return on Total Assets | |||
Return on Stockholder's Equity | |||
Solvency | 2018 | 2017 | |
| |||
| |||
|
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