1. I need the Pro Forma Income Statement model with appropriate use of modeling assumptions for key accounts and variables.
2. Next year's projection (Proforma) using 2020 data
Historical Income Statement Historical Balance Sheet Historical Statemer Nike Inc. Income Statement USS in millions 12 months ended: Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Selling and administrative expense Operating income Interest income Interest expense Interest income (expense), net Other income (expense), net Income before income taxes Income tax expense Net income May 31, 2020 37,403 (21.162) 16,241 (3,592) (9.534) (13,126) 3,115 62 (151) (89) (139) 2,887 (348) 2,539 May 31, 2019 39,117 (21,643) 17,474 (3.753) (8.949) (12,702) 4,772 82 (131) (49) 78 4,801 (772) 4,029 May 31, 2018 36,397 (20,441) 15,956 (3,577) (7,934) (11,511) 4,445 70 (124) (54) (66) 4,325 (2,392) 1,933 Historical Balance Sheet Historical Statement Cas Historical Income Statement Nike Inc. Consolidated Balance Sheet May 31, 2020 May 31, 2019 May 31, 2018 8.348 4,466 4.249 439 197 4.272 2.749 7.167 0 0 USS in millions Assets Cash and equivalents Short-term investments 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 3,498 5.261 0 1,130 15,134 4454 1.968 16.525 4,744 20.556 4,6 3,097 274 223 2.326 10.786 31.342 283 154 2011 7,192 23.717 285 154 2.500 7.402 22.536 3 248 2245 445 1.24 6 9 2,612 0 1.232 1.218 6 336 2.279 0 197 20 1.17 405 O D 425 320 393 384 273 202 190 146 97 424 346 296 234 52 0 114 224 184 0 140 Liabilities Current portion of long-term deht Notes payable Accounts payable Current portion of operating lease liabilities Compensation and benefits, excluding takes Sales-related reserves Allowance for cumulative foreign currency translation 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 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 Comason stock at stated value Capital in aceas of stated value Accumulated other comprehensive income (los) Retained camnings (deficit) Shareholders' equity Total abilities and shareholders' equity 0 289 23 805 5.010 229 7.864 3.464 668 5.184 156 8.254 9.406 2.913 2.684 15.003 23.287 0 3 $.299 (56) (191) 8.055 31.342 0 3,347 6.811 14,677 0 3 7.163 231 1.643 768 3.269 150 6,040 3,46% 0 3.216 6,684 12.724 0 3 6,384 192) 3.517 9.812 22.516 9.040 23,717 Historical Income Statement Historical Balance Sheet Historical Statement Cas Nike Inc. Consolidated Cash Flow Statement 2.539 USS in millions 12 months ended: May 31, 2020 May 31, 2019 May 31, 2018 Net income 4,029 1.933 Depreciation 721 705 747 Deferred income taxes (380) 34 647 Stock-based compensation 429 325 218 Amortization, impairment and other 398 15 27 Net foreign currency adjustments 23 233 (99) (Increase) decrease in accounts receivable 1.239 (270) 187 (Increase) decrease in inventories (1.854) (490) (255) (Increase) decrease in prepaid expenses, operating lease right-of-use assets and other current and non-current assets (654) (203) 35 Increase (decrease) in accounts payable, accrued liabilities, operating tease liabilities and other current and non-current liabilities 24 1.525 1.515 Changes in certain working capital components and other assets (1.245) 562 and liabilities 1.482 Adjustments to reconcile net income to net cash provided by (54) operations 1.874 3,022 Cash provided by operations 2.485 5.903 4.955 Purchases of short-term investments (2.426) (2.937) (4,783) Maturities of short-term investments 1.715 3,613 Sales of short-term investments 2,379 2,072 2,496 Investments in reverse repurchase agreements 0 O Additions to property, plant and equipment (1,086) (1.119) (1.028) Other investing activities 31 (22) Cash (used) provided by investing activities (1,028) (264) 276 Increase (decrease) in notes payable, net (325) 13 Proceeds from borrowings, net of debt issuance costs 6,134 0 0 Repayment of borrowings 0 (6) (6) Payments on capital lease and other financing obligations 0 (27) (23) Proceeds from exercise of stock options and other stock issuances 885 700 733 Excess tax benefits from share-based payment arrangements 0 Repurchase of common stock (3.067) (4.286) (4,254) Dividends, common and preferred (1.452) (1.332) (1.243) Other financing activities (58) (17) (55) Cash provided (used) by financing activities 2.491 (5.293) (4.835) Effect of exchange rate changes on cash and equivalents (66) (129) 45 Net Increase (decrease) in cash and equivalents 3.882 217 441 Cash and equivalents, beginning of your 4.466 4.249 3.808 Cash and equivalents, end of year 8,348 4,466 4.249 74 0 5 49 0 0 Historical Income Statement Historical Balance Sheet Historical Statemer Nike Inc. Income Statement USS in millions 12 months ended: Revenues Cost of sales Gross profit Demand creation expense Operating overhead expense Selling and administrative expense Operating income Interest income Interest expense Interest income (expense), net Other income (expense), net Income before income taxes Income tax expense Net income May 31, 2020 37,403 (21.162) 16,241 (3,592) (9.534) (13,126) 3,115 62 (151) (89) (139) 2,887 (348) 2,539 May 31, 2019 39,117 (21,643) 17,474 (3.753) (8.949) (12,702) 4,772 82 (131) (49) 78 4,801 (772) 4,029 May 31, 2018 36,397 (20,441) 15,956 (3,577) (7,934) (11,511) 4,445 70 (124) (54) (66) 4,325 (2,392) 1,933 Historical Balance Sheet Historical Statement Cas Historical Income Statement Nike Inc. Consolidated Balance Sheet May 31, 2020 May 31, 2019 May 31, 2018 8.348 4,466 4.249 439 197 4.272 2.749 7.167 0 0 USS in millions Assets Cash and equivalents Short-term investments 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 3,498 5.261 0 1,130 15,134 4454 1.968 16.525 4,744 20.556 4,6 3,097 274 223 2.326 10.786 31.342 283 154 2011 7,192 23.717 285 154 2.500 7.402 22.536 3 248 2245 445 1.24 6 9 2,612 0 1.232 1.218 6 336 2.279 0 197 20 1.17 405 O D 425 320 393 384 273 202 190 146 97 424 346 296 234 52 0 114 224 184 0 140 Liabilities Current portion of long-term deht Notes payable Accounts payable Current portion of operating lease liabilities Compensation and benefits, excluding takes Sales-related reserves Allowance for cumulative foreign currency translation 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 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 Comason stock at stated value Capital in aceas of stated value Accumulated other comprehensive income (los) Retained camnings (deficit) Shareholders' equity Total abilities and shareholders' equity 0 289 23 805 5.010 229 7.864 3.464 668 5.184 156 8.254 9.406 2.913 2.684 15.003 23.287 0 3 $.299 (56) (191) 8.055 31.342 0 3,347 6.811 14,677 0 3 7.163 231 1.643 768 3.269 150 6,040 3,46% 0 3.216 6,684 12.724 0 3 6,384 192) 3.517 9.812 22.516 9.040 23,717 Historical Income Statement Historical Balance Sheet Historical Statement Cas Nike Inc. Consolidated Cash Flow Statement 2.539 USS in millions 12 months ended: May 31, 2020 May 31, 2019 May 31, 2018 Net income 4,029 1.933 Depreciation 721 705 747 Deferred income taxes (380) 34 647 Stock-based compensation 429 325 218 Amortization, impairment and other 398 15 27 Net foreign currency adjustments 23 233 (99) (Increase) decrease in accounts receivable 1.239 (270) 187 (Increase) decrease in inventories (1.854) (490) (255) (Increase) decrease in prepaid expenses, operating lease right-of-use assets and other current and non-current assets (654) (203) 35 Increase (decrease) in accounts payable, accrued liabilities, operating tease liabilities and other current and non-current liabilities 24 1.525 1.515 Changes in certain working capital components and other assets (1.245) 562 and liabilities 1.482 Adjustments to reconcile net income to net cash provided by (54) operations 1.874 3,022 Cash provided by operations 2.485 5.903 4.955 Purchases of short-term investments (2.426) (2.937) (4,783) Maturities of short-term investments 1.715 3,613 Sales of short-term investments 2,379 2,072 2,496 Investments in reverse repurchase agreements 0 O Additions to property, plant and equipment (1,086) (1.119) (1.028) Other investing activities 31 (22) Cash (used) provided by investing activities (1,028) (264) 276 Increase (decrease) in notes payable, net (325) 13 Proceeds from borrowings, net of debt issuance costs 6,134 0 0 Repayment of borrowings 0 (6) (6) Payments on capital lease and other financing obligations 0 (27) (23) Proceeds from exercise of stock options and other stock issuances 885 700 733 Excess tax benefits from share-based payment arrangements 0 Repurchase of common stock (3.067) (4.286) (4,254) Dividends, common and preferred (1.452) (1.332) (1.243) Other financing activities (58) (17) (55) Cash provided (used) by financing activities 2.491 (5.293) (4.835) Effect of exchange rate changes on cash and equivalents (66) (129) 45 Net Increase (decrease) in cash and equivalents 3.882 217 441 Cash and equivalents, beginning of your 4.466 4.249 3.808 Cash and equivalents, end of year 8,348 4,466 4.249 74 0 5 49 0 0