1-Using number from 5/31/2021, compute cash collected from customers:

Sales Revenue 32,376

Decrease in Accounts Receivable

Cash Collected from Customers

2-Using the numbers from 2016, compute cash paid for purchase of inventory:

Cost of Sales

$ 17,405

Increase in Inventories*

590

Cost of Inventories Purchased

Increase in Accounts Payable**

Cash Paid for Purchases of Inventory

 

Transcribed Image Text:

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 Exhibit 1.24 Consolidated Balance Sheet for Nike, Inc. (amounts in millions) (Case 1.2) 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 TOTAL LIABILITIES Shareholders equity: Common stock at stated value: Class A convertible-353 and 355 shares outstanding Class B-1,329 and 1,357 shares outstanding Capital in excess of stated value Accumulated other comprehensive income Retained earnings TOTAL SHAREHOLDERS EQUITY TOTAL LIABILITIES AND SHAREHOLDERS EQUITY Source: Nike, Inc., Form 10-K for the Fiscal Year ended May 31, 2016. At Fiscal Year End, May 31: 2015 2014 $ 2,220 2,922 3,434 3,947 818 $13,341 2,834 282 131 2,006 $18,594 $ 7 167 1,930 2,491 432 $ 5,027 1,199 1,544 $ 7,770 3 5,865 85 4,871 $10,824 $18,594 $ 3,852 2,072 3,358 4,337 1,968 $15,587 3,011 281 131 2,587 $21,597 $ 107 74 2,131 3,949 71 $ 6,332 1,079 1,479 $ 8,890 3 6,773 1,246 4,685 $12,707 $21,597 2016 $3,138 2,319 3,241 4,838 1,489 $15,025 $ 3,520 281 131 2,439 $21,396 44 1 2,191 3,037 85 $ 5,358 2,010 1,770 $9,138 3 7,786 318 4,151 $12,258 $21,396 Exhibit 1.25 Consolidated Income Statement for Nike, Inc. (amounts in millions except per share figures) (Case 1.2) Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Operating Income Interest (expense) income, net Other income (expense), net Income before income taxes Income tax expense NET INCOME Earnings per common share: Basic Diluted Dividends declared per common share Source: Nike, Inc., Form 10-K for the Fiscal Year ended May 31, 2016. Cash provided by operations: Net income Income charges (credits) not affecting cash: Depreciation Deferred income taxes. Stock-based compensation Amortization and other Not foreign curronoradictmontr For the Fiscal Year Ended May 31: 2015 $ 30,601 16,534 $14,067 3,213 6,679 $ 4,175 2014 $ 27,799 15,353 $12,446 3,031 5,735 $ 3,680 (33) (103) $ 3,544 851 $ 2,693 $ $ $ 1.52 1.49 0.47 Exhibit 1.26 Consolidated Statements of Cash Flows for Nike (amounts in millions) (Case 1.2) $ 2,693 (28) 58 $ 4,205 932 $ 3,273 518 $ $ $ (11) 177 68 56 1.90 1.85 0.54 $ 3,273 2016 For the Fiscal Years Ended May 31: 2014 2015 2016 606 (113) 191 43 424 $32,376 17,405 $14,971 3,278 7,191 $ 4,502 (19) 140 $ 4,623 863 $ 3,760 $ 2.21 $ 2.16 $ 0.62 $ 3,760 649 (80) 236 13 08 Exhibit 1.26 (Continued) Changes in certain working capital components and other assets and liabilities: Decrease (increase) in accounts receivable (Increase) in inventories (Increase) in prepaid expenses and other current assets (Decrease) increase in accounts payable, accrued liabilities and income taxes payable Cash provided by operations Cash used by investing activities: Purchases of short-term investments Maturities of short-term investments Sales of short-term investments Investments in reverse repurchase agreements Additions to property, plant, and equipment Disposals of property, plant, and equipment Decrease (increase) in other assets, net of other liabilities Cash used by investing activities Cash used by financing activities: Net proceeds from long-term debt issuance Long-term debt payments, including current portion (Decrease) increase in notes payable Payments on capital lease obligations Proceeds from exercise of stock options and other stock issuances Excess tax benefits from share-based payment arrangements Repurchases of common stock Dividends-common and preferred Cash used by financing activities Effect of exchange rate changes on cash and equivalents Net (decrease) increase in cash and equivalents Cash and equivalents, beginning of year Cash and equivalents, end of year Source: Nike, Inc., Form 10-K for the Fiscal Year ended May 31, 2016. (298) (505) (210) 525 $ 3,013 (5,386) 3,932 1,126 (880) 3 (2) $(1,207) (60) 75 (17) 383 132 (2,628) (799) $(2,914) (9) $(1,117) $ 3,337 $ 2,220 (216) (621) (144) 1,237 $ 4,680 (4,936) 3,655 2,216 (150) (963) 3 $ (175) (7) (63) (19) 514 218 (2,534) (899) $(2,790) (83) $ 1,632 $ 2,220 $ 3,852 60 (590) (161) (889) $ 3,096 (5,367) 2,924 2,386 150 (1,143) 10 6 $(1,034) 981 (106) (67) (7) 507 281 (3,238) (1,022) $(2,671) (105) $ (714) $ 3,852 $3,138 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 Exhibit 1.24 Consolidated Balance Sheet for Nike, Inc. (amounts in millions) (Case 1.2) 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 TOTAL LIABILITIES Shareholders equity: Common stock at stated value: Class A convertible-353 and 355 shares outstanding Class B-1,329 and 1,357 shares outstanding Capital in excess of stated value Accumulated other comprehensive income Retained earnings TOTAL SHAREHOLDERS EQUITY TOTAL LIABILITIES AND SHAREHOLDERS EQUITY Source: Nike, Inc., Form 10-K for the Fiscal Year ended May 31, 2016. At Fiscal Year End, May 31: 2015 2014 $ 2,220 2,922 3,434 3,947 818 $13,341 2,834 282 131 2,006 $18,594 $ 7 167 1,930 2,491 432 $ 5,027 1,199 1,544 $ 7,770 3 5,865 85 4,871 $10,824 $18,594 $ 3,852 2,072 3,358 4,337 1,968 $15,587 3,011 281 131 2,587 $21,597 $ 107 74 2,131 3,949 71 $ 6,332 1,079 1,479 $ 8,890 3 6,773 1,246 4,685 $12,707 $21,597 2016 $3,138 2,319 3,241 4,838 1,489 $15,025 $ 3,520 281 131 2,439 $21,396 44 1 2,191 3,037 85 $ 5,358 2,010 1,770 $9,138 3 7,786 318 4,151 $12,258 $21,396 Exhibit 1.25 Consolidated Income Statement for Nike, Inc. (amounts in millions except per share figures) (Case 1.2) Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Operating Income Interest (expense) income, net Other income (expense), net Income before income taxes Income tax expense NET INCOME Earnings per common share: Basic Diluted Dividends declared per common share Source: Nike, Inc., Form 10-K for the Fiscal Year ended May 31, 2016. Cash provided by operations: Net income Income charges (credits) not affecting cash: Depreciation Deferred income taxes. Stock-based compensation Amortization and other Not foreign curronoradictmontr For the Fiscal Year Ended May 31: 2015 $ 30,601 16,534 $14,067 3,213 6,679 $ 4,175 2014 $ 27,799 15,353 $12,446 3,031 5,735 $ 3,680 (33) (103) $ 3,544 851 $ 2,693 $ $ $ 1.52 1.49 0.47 Exhibit 1.26 Consolidated Statements of Cash Flows for Nike (amounts in millions) (Case 1.2) $ 2,693 (28) 58 $ 4,205 932 $ 3,273 518 $ $ $ (11) 177 68 56 1.90 1.85 0.54 $ 3,273 2016 For the Fiscal Years Ended May 31: 2014 2015 2016 606 (113) 191 43 424 $32,376 17,405 $14,971 3,278 7,191 $ 4,502 (19) 140 $ 4,623 863 $ 3,760 $ 2.21 $ 2.16 $ 0.62 $ 3,760 649 (80) 236 13 08 Exhibit 1.26 (Continued) Changes in certain working capital components and other assets and liabilities: Decrease (increase) in accounts receivable (Increase) in inventories (Increase) in prepaid expenses and other current assets (Decrease) increase in accounts payable, accrued liabilities and income taxes payable Cash provided by operations Cash used by investing activities: Purchases of short-term investments Maturities of short-term investments Sales of short-term investments Investments in reverse repurchase agreements Additions to property, plant, and equipment Disposals of property, plant, and equipment Decrease (increase) in other assets, net of other liabilities Cash used by investing activities Cash used by financing activities: Net proceeds from long-term debt issuance Long-term debt payments, including current portion (Decrease) increase in notes payable Payments on capital lease obligations Proceeds from exercise of stock options and other stock issuances Excess tax benefits from share-based payment arrangements Repurchases of common stock Dividends-common and preferred Cash used by financing activities Effect of exchange rate changes on cash and equivalents Net (decrease) increase in cash and equivalents Cash and equivalents, beginning of year Cash and equivalents, end of year Source: Nike, Inc., Form 10-K for the Fiscal Year ended May 31, 2016. (298) (505) (210) 525 $ 3,013 (5,386) 3,932 1,126 (880) 3 (2) $(1,207) (60) 75 (17) 383 132 (2,628) (799) $(2,914) (9) $(1,117) $ 3,337 $ 2,220 (216) (621) (144) 1,237 $ 4,680 (4,936) 3,655 2,216 (150) (963) 3 $ (175) (7) (63) (19) 514 218 (2,534) (899) $(2,790) (83) $ 1,632 $ 2,220 $ 3,852 60 (590) (161) (889) $ 3,096 (5,367) 2,924 2,386 150 (1,143) 10 6 $(1,034) 981 (106) (67) (7) 507 281 (3,238) (1,022) $(2,671) (105) $ (714) $ 3,852 $3,138

Answer rating: 100% (QA)

1 To compute cash collected from customers we start with sales revenue and adjust for the changes in accounts receivable We are given Sales Revenue 32... View the full answer