Prepare a Vertical Analysis of the Balance Sheets for Nike, Inc. for the current year ended 5/31/19 and the prior year ended 5/31/18, expressing each Balance Sheet item as a percentage of total assets. (Total Assets = 100%) Use a spreadsheet program to do this part of the assignment. Label the spreadsheet "Vertical Analysis - Balance Sheets - Nike, Inc." List each line item classification from the Balance Sheet (each Asset, Liability, and component of Shareholders' Equity) in Column A, and the amounts for the two years in Column B (2019) and Column D (2018). In Columns C and E, use a formula to convert the amounts in Columns B and D, respectively, to a percentage of Total Assets. NIKE, INC. CONSOLIDATED BALANCE SHEETS MAY 31, 2019 2018 S (Dollars in millions) ASSETS Current assets: Cash and equivalents Short-term investments Accounts receivable, net Inventories Prepaid expenses and other current assets Total current assets Property, plant and equipment, net Identifiable intangible assets, net Goodwill Deferred income taxes and other assets TOTAL ASSETS LIABILITIES AND SHAREHOLDERS' EQUITY Current liabilities: Current portion of long-term debt Notes payable Accounts payable Accrued liabilities Income taxes payable Total current liabilities Long-term debt Deferred income taxes and other liabilities Commitments and contingencies (Note 18) Redeemable preferred stock 4,466 197 4,272 5,622 1,968 16,525 4,744 283 154 2,011 23,717 4,249 996 3,498 5,261 1,130 15,134 4,454 285 154 2.509 22,536 $ 6 S 2,612 5,010 229 7.866 3,464 3.347 336 2.279 3.269 150 6,040 3,468 3.216 Shareholders' equity: Common stock at stated value: Class A convertible 315 and 329 shares outstanding Class B 1,253 and 1,272 shares outstanding Capital in excess of stated value Accumulated other comprehensive income (loss) Retained earnings Total shareholders' equity TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 7,163 231 1.643 9,040 23,717 6,384 (92) 3,517 9.812 22,536 S $