Answered step by step
Verified Expert Solution
Link Copied!

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
Ratio of fixed assets to long-term liabilities
Ratio of liabilities to stockholders' equity
Times interest earned

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

The Complete Direct Investing Handbook

Authors: Kirby Rosplock

1st Edition

1119094712, 978-1119094715

More Books

Students also viewed these Finance questions