Question
We forecast Nike's income statement using the following forecast assumptions: Revenue growth based on growth in revenues from 2015 to 2016 6.0% Cost of sales/Revenues
We forecast Nike's income statement using the following forecast assumptions: | |
Revenue growth based on growth in revenues from 2015 to 2016 | 6.0% |
Cost of sales/Revenues | 53.8% |
Demand creation expense/Revenues | 10.1% |
Operating overhead expenses/Revenues | 22.2% |
Income tax expense/Income before income taxes | 18.7% |
Instructions: Forecast Nike's fiscal year 2017 income statement.
-
Assume no change for other income and interest income.
-
Round forecasts to $ millions.
- Do not use negative signs with your answers in the income statement.
Nike Inc. Forecasted Statement of Income (in $ millions) | ||
---|---|---|
2017 Est | ||
Revenues | Answer | |
Cost of sales | Answer | |
Gross profit | Answer | |
Demand creation expense | Answer | |
Operating overhead expense | Answer | |
Total selling and administrative expense | Answer | |
Interest income/expense, net | Answer | |
Other income/expense, net | Answer | |
Income before income taxes | Answer | |
Income tax expense | Answer | |
Net income | Answer |
We forecast Nike's balance sheet using the following forecast assumptions:
Accounts receivable/Revenues | 10.0% |
Inventories/Revenues | 14.9% |
Prepaid expenses and other current assets/Revenues | 4.6% |
Depreciation expense/Prior-year PPE, net (incl. in overhead) | 21.6% |
Amortization expense | $13 |
L-T deferred income taxes and other assets/Revenues | 7.5% |
Accounts payable/Revenues | 6.8% |
Accrued liabilities/Revenues | 9.4% |
Income taxes payable/Revenues | 0.3% |
Deferred income taxes and other liabilities/Revenues | 5.5% |
Capital expenditures/Revenues | 3.5% |
Dividends/Net income | 27.2% |
Current portion of L/T debt due in 2018 | $6 |
Instructions: Forecast Nike's fiscal year 2017 balance sheet.
-
Assume no change for: short-term investments, goodwill, notes payable, common stock, capital in excess of stated value and accumulated other comprehensive income.
-
Round forecasts to $ millions.
Nike Inc. Forecasted Balance Sheet ($ in millions) | ||
---|---|---|
2016 Actual | 2017 Est. | |
Cash and equivalents | $ 3,138 | Answer |
Short-term investments | 2,319 | Answer |
Accounts receivable, net | 3,241 | Answer |
Inventories | 4,838 | Answer |
Prepaid expenses and other current assets | 1,489 | Answer |
Total current assets | 15,025 | Answer |
Property, plant and equipment, net | 3,520 | Answer |
Identifiable intangible assets, net | 281 | Answer |
Goodwill | 131 | Answer |
Deferred income taxes and other assets | 2,439 | Answer |
Total assets | $21,396 | Answer |
Current portion of long-term debt | $44 | Answer |
Notes payable | 1 | Answer |
Accounts payable | 2,191 | Answer |
Accrued liabilities | 3,037 | Answer |
Income taxes payable | 85 | Answer |
Total current liabilities | 5,358 | Answer |
Long-term debt | 2,010 | Answer |
Deferred income taxes and other liabilities | 1,770 | Answer |
Total liabilities | 9,138 | Answer |
Shareholders' equity: | ||
Class A Convertible Common Stock | 0 | Answer |
Class B common stock | 3 | Answer |
Capital in excess of stated value | 7,786 | Answer |
Accumulated other comprehensive income | 318 | Answer |
Retained earnings | 4,151 | Answer |
Total shareholders' equity | 12,258 | Answer |
Total liabilities and shareholders' equity | $21,396 | Answer |
Instructions: Forecast Nike's fiscal year 2017 stastement of cash flows.
Use negative signs with your answers below, when appropriate.
NIKE INC. | |
---|---|
Forecasted Statement of Cash Flows ($ in millions) | |
2017 Est. | |
Net income | Answer |
Add: depreciation | Answer |
Add: amortization | Answer |
Change in Accounts receivable | Answer |
Change in Inventories | Answer |
Change in Prepaid expenses & other current assets | Answer |
Change in Deferred income taxes and other assets | Answer |
Change in Accounts payable | Answer |
Change in Accrued liabilities | Answer |
Change in Income taxes payable | Answer |
Change in Deferred income taxes and other liabilities | Answer |
Cash from operating | Answer |
CAPEX | Answer |
Cash for investing | Answer |
Decrease in debt, net | Answer |
Dividends | Answer |
Cash for financing | Answer |
Change in cash | Answer |
Cash at start of year | Answer Mark 0.00 out of 1.00 |
Cash at end of year | Answer |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started