NEED ASAP:
Pro Forma Balance Sheet model with appropriate use of modeling assumptions for key accounts and variables. (Use data from year 2020 to make projections about next year)
Nike Inc. 1 2 Consolidated Balance Sheet 3 4 US$ in millions 5 Assets May 31, 2020 May 31, 2019 May 31, 2018 6 Cash and equivalents 8,348 4,466 4,249 7 Short-term investments 439 197 996 2,749 7,367 4,272 5,622 3,498 5,261 1,968 16,525 4,744 1,130 15,134 4,454 B 9 10 11 12 3 -4 5 6 7 8 9 0 Accounts receivable, net Inventories Deferred income taxes Prepaid expenses and other current assets Current assets Property, plant and equipment, net Operating lease right-of-use assets, net Identifiable intangible assets, net Goodwill Deferred income taxes and other assets Non-current assets Total assets 1,653 20,556 4,866 3,097 274 223 2,326 10,786 31,342 283 154 2,011 7,192 23,717 285 154 2,509 7,402 22,536 bir B 10,786 31,342 C 7,192 23,717 D 7,402 22,536 3 6 9 2,612 6 336 2,279 248 2,248 445 1,248 1,178 1,232 1,218 897 20 A 8 Non-current assets 9 Total assets 0 1 Liabilities 2 Current portion of long-term debt 3 Notes payable Accounts payable 5 Current portion of operating lease liabilities 5 Compensation and benefits, excluding taxes 7 Sales-related reserves Allowance for cumulative foreign currency translation 3 losses Endorsement compensation Dividends payable Import and logistics costs Taxes other than income taxes payable Fair value of derivatives Liabilities held-for-sale Advertising and marketing Collateral received from counterparties to hedging instruments Other Accrued liabilities Income taxes payable Current liahilities 405 393 384 273 202 190 146 97 424 346 296 234 425 320 268 224 184 52 114 140 668 5.184 156 RRA 289 805 5,010 229 7 R66 23 768 3,269 150 6.nan B D 184 52 190 146 97 114 140 289 805 5,010 229 7,866 3,464 668 5,184 156 8,284 9,406 2,913 2,684 15,003 23,287 Fair value of derivatives Liabilities held-for-sale Advertising and marketing Collateral received from counterparties to hedging instruments Other Accrued liabilities Income taxes payable Current liabilities Long-term debt, excluding current portion Operating lease liabilities, excluding current portion Deferred income taxes and other liabilities Non-current liabilities Total liabilities Redeemable preferred stock Common stock at stated value Capital in excess of stated value Accumulated other comprehensive income (loss) Retained earnings (deficit) Shareholders' equity Total liabilities and shareholders' equity 23 768 3,269 150 6,040 3,468 3,347 6,811 14,677 3,216 6,684 12,724 1 3 3 8,299 (56) (191) 8,055 31,342 3 7,163 231 1,643 9,040 23,717 3 6,384 (92) 3,517 9,812 22,536 Nike Inc. 1 2 Consolidated Balance Sheet 3 4 US$ in millions 5 Assets May 31, 2020 May 31, 2019 May 31, 2018 6 Cash and equivalents 8,348 4,466 4,249 7 Short-term investments 439 197 996 2,749 7,367 4,272 5,622 3,498 5,261 1,968 16,525 4,744 1,130 15,134 4,454 B 9 10 11 12 3 -4 5 6 7 8 9 0 Accounts receivable, net Inventories Deferred income taxes Prepaid expenses and other current assets Current assets Property, plant and equipment, net Operating lease right-of-use assets, net Identifiable intangible assets, net Goodwill Deferred income taxes and other assets Non-current assets Total assets 1,653 20,556 4,866 3,097 274 223 2,326 10,786 31,342 283 154 2,011 7,192 23,717 285 154 2,509 7,402 22,536 bir B 10,786 31,342 C 7,192 23,717 D 7,402 22,536 3 6 9 2,612 6 336 2,279 248 2,248 445 1,248 1,178 1,232 1,218 897 20 A 8 Non-current assets 9 Total assets 0 1 Liabilities 2 Current portion of long-term debt 3 Notes payable Accounts payable 5 Current portion of operating lease liabilities 5 Compensation and benefits, excluding taxes 7 Sales-related reserves Allowance for cumulative foreign currency translation 3 losses Endorsement compensation Dividends payable Import and logistics costs Taxes other than income taxes payable Fair value of derivatives Liabilities held-for-sale Advertising and marketing Collateral received from counterparties to hedging instruments Other Accrued liabilities Income taxes payable Current liahilities 405 393 384 273 202 190 146 97 424 346 296 234 425 320 268 224 184 52 114 140 668 5.184 156 RRA 289 805 5,010 229 7 R66 23 768 3,269 150 6.nan B D 184 52 190 146 97 114 140 289 805 5,010 229 7,866 3,464 668 5,184 156 8,284 9,406 2,913 2,684 15,003 23,287 Fair value of derivatives Liabilities held-for-sale Advertising and marketing Collateral received from counterparties to hedging instruments Other Accrued liabilities Income taxes payable Current liabilities Long-term debt, excluding current portion Operating lease liabilities, excluding current portion Deferred income taxes and other liabilities Non-current liabilities Total liabilities Redeemable preferred stock Common stock at stated value Capital in excess of stated value Accumulated other comprehensive income (loss) Retained earnings (deficit) Shareholders' equity Total liabilities and shareholders' equity 23 768 3,269 150 6,040 3,468 3,347 6,811 14,677 3,216 6,684 12,724 1 3 3 8,299 (56) (191) 8,055 31,342 3 7,163 231 1,643 9,040 23,717 3 6,384 (92) 3,517 9,812 22,536
