Question: Complete a horizontal analysis using the balance sheet (BS) for the Nike, Inc. Find the amount and percent of increase or decrease for 2018 to

Complete a horizontal analysis using the balance sheet (BS) for the Nike, Inc. Find the amount and percent of increase or decrease for 2018 to 2019 and 2019 to 2020. 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. Please use commas in thousands (example. 12,500)

Increase/decrease 2019-2020 Increase/decrease 2019-2020 Increase/decrease 2018-2019 Increase/decrease 2018-2019
in millions 2020 2019 2018 Amount Percent Amount Percent
ASSETS
Current Assets
Cash and equivalents 8,348 4,466 4,249

fill in the blank 1

fill in the blank 2

fill in the blank 3

fill in the blank 4

Short-term investments 439 197 996

fill in the blank 5

fill in the blank 6

fill in the blank 7

fill in the blank 8

Accounts receivable, net 2,749 4,272 3,498

fill in the blank 9

fill in the blank 10

fill in the blank 11

fill in the blank 12

Inventories 7,367 5,622 5,261

fill in the blank 13

fill in the blank 14

fill in the blank 15

fill in the blank 16

Prepaid expenses and other current assets 1,653 1,968 1,130

fill in the blank 17

fill in the blank 18

fill in the blank 19

fill in the blank 20

Total Current Assets 20,556 16,525 15,134

fill in the blank 21

fill in the blank 22

fill in the blank 23

fill in the blank 24

Property, plant and equipment; net 4,866 4,744 4,454

fill in the blank 25

fill in the blank 26

fill in the blank 27

fill in the blank 28

Operating lease right-of-use assets, net 3,097 0 0

fill in the blank 29

n/a

fill in the blank 30

n/a
Indentifiable intangible assets, net 274 283 285

fill in the blank 31

fill in the blank 32

fill in the blank 33

fill in the blank 34

Goodwill 223 154 154

fill in the blank 35

fill in the blank 36

fill in the blank 37

fill in the blank 38

Deferred income taxes and other assets 2,326 2,011 2,509

fill in the blank 39

fill in the blank 40

fill in the blank 41

fill in the blank 42

Total Assets 31,342 23,717 22,536

fill in the blank 43

fill in the blank 44

fill in the blank 45

fill in the blank 46

LIABILITIES AND SHAREHOLDERS' EQUITY
Current Liabilities
Current portion of long-term debt 3 6 6

fill in the blank 47

fill in the blank 48

fill in the blank 49

fill in the blank 50

Notes payable 248 9 336

fill in the blank 51

fill in the blank 52

fill in the blank 53

fill in the blank 54

Accounts payable 2,248 2,612 2,279

fill in the blank 55

fill in the blank 56

fill in the blank 57

fill in the blank 58

Current portion of operating lease liabilities 445 0 0

fill in the blank 59

n/a

fill in the blank 60

n/a
Accrued liabilities 5,184 5,010 3,269

fill in the blank 61

fill in the blank 62

fill in the blank 63

fill in the blank 64

Income taxes payable 156 229 150

fill in the blank 65

fill in the blank 66

fill in the blank 67

fill in the blank 68

Total current liabilities 8,284 7,866 6,040

fill in the blank 69

fill in the blank 70

fill in the blank 71

fill in the blank 72

Long-term debt 9,406 3,464 3,468

fill in the blank 73

fill in the blank 74

fill in the blank 75

fill in the blank 76

Operating lease liabilities 2,913 0 0

fill in the blank 77

n/a

fill in the blank 78

n/a
Deffered income taxes and other liabilities 2,684 3,347 3,216

fill in the blank 79

fill in the blank 80

fill in the blank 81

fill in the blank 82

Commitments and contingencies
Redeemable preferred stock
Shareholder's equity
Common stock at stated value
Class A convertible-329 and 353 shares outstanding
Cass B-1,314 and 1,329 shares outstanding 3 3 3

fill in the blank 83

fill in the blank 84

fill in the blank 85

fill in the blank 86

Capital in excess of stated value 8,299 7,163 6,384

fill in the blank 87

fill in the blank 88

fill in the blank 89

fill in the blank 90

Accumulated other comprehensive (loss) income -56 231 -92

fill in the blank 91

fill in the blank 92

fill in the blank 93

fill in the blank 94

Retained earnings -191 1,643 3,517

fill in the blank 95

fill in the blank 96

fill in the blank 97

fill in the blank 98

Total Shareholders' equity 8,055 9,040 9,812

fill in the blank 99

fill in the blank 100

fill in the blank 101

fill in the blank 102

TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 31,342 23,717 22,536

fill in the blank 103

fill in the blank 104

fill in the blank 105

fill in the blank 106

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!