Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows The

ID: 2797549 • Letter: F

Question

Forecasting the Income Statement, Balance Sheet, and Statement of Cash Flows
The following are the financial statements of Nike, Inc.

(in Millions)

In Millions

Instructions: Forecast Nike's fiscal year 2014 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.

Interest income, net

Instructions: Forecast Nike's fiscal year 2014 balance sheet.

Assume no change for: short-term investments, goodwill, notes payable, liabilities from discontinued operations, common stock, capital in excess of stated value and accumulated other comprehensive income.

Round forecasts to $ millions.

We forecast Nike's balance sheet using the following forecast assumptions:

Instructions: Forecast Nike's fiscal year 2014 stastement of cash flows.

Use negative signs with your answers below, when appropriate.

Consolidated Statements of Income Year ended May 31

(in Millions)

2013 2012 2011 Income from continuing operations: Revenues $25,313 $23,331 $20,117 Cost of sales 14,279 13,183 10,915 Gross profit 11,034 10,148 9,202 Demand creation expense 2,745 2,607 2,344 Operating overhead expense 5,035 4,458 4,017 Total selling and administrative expense 7,780 7,065 6,361 Interest expense (income), net (3) 4 4 Other (income) (15) 54 (25) Income before income taxes 3,272 3,025 2,862 Income tax expense 808 756 690 Net income from continuing operations 2,464 2,269 2,172 Net income (loss) from discontinued operations 21 (46) (39) Net income $ 2,485 $ 2,223 $ 2,133

Explanation / Answer

Forecasted Nike's fiscal year 2014 income statement ( $ Millions)

Income from continuing operations:

Year 2014

REMARKS

Revenues

27338

8% Increase over Year 2013

Cost of sales

15419

56.4% of revenues

Gross profit

11919

Revenues - Cost of Sales

Demand creation expense

2953

10.8% of Revenues

Operating overhead expense

5440

19.9% of Revenues

Total selling and administrative expense

8393

Gross Profit- Total Selling & Administrative Expenses

Interest expense (income), net

-3

Other (income)

-15

Income before income taxes

3545

Income tax expense

876

24.70%

Net income from continuing operations

2669

Net income (loss) from discontinued operations

Forecasted Nike's fiscal year 2014 income statement ( $ Millions)

Income from continuing operations:

Year 2014

REMARKS

Revenues

27338

8% Increase over Year 2013

Cost of sales

15419

56.4% of revenues

Gross profit

11919

Revenues - Cost of Sales

Demand creation expense

2953

10.8% of Revenues

Operating overhead expense

5440

19.9% of Revenues

Total selling and administrative expense

8393

Gross Profit- Total Selling & Administrative Expenses

Interest expense (income), net

-3

Other (income)

-15

Income before income taxes

3545

Income tax expense

876

24.70%

Net income from continuing operations

2669

Net income (loss) from discontinued operations

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote