Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Following are the financial statements of Nike, Inc. Consolidated Statements of Income Year ended May 31 In Millions 2011 2010 Revenues $ 20,862 $ 19,014

Following are the financial statements of Nike, Inc.

Consolidated Statements of Income
Year ended May 31
In Millions20112010
Revenues$ 20,862$ 19,014
Cost of sales11,35410,214
Gross profit9,5088,800
Demand creation expense2,4482,356
Operating overhead expense4,2453,970
Total selling and administrative expense6,6936,326
Interest expense (income), net46
Other (income)(33)(49)
Income before income taxes2,8442,517
Income taxes711610
Net income$ 2,133$ 1,907

Balance Sheets
May 31
In Millions20112010
Assets
Cash and equivalents$ 1,955$ 3,079
Short-term investments2,5832,067
Accounts receivable, net3,1382,650
Inventories2,7152,041
Deferred income taxes312249
Prepaid expenses and other current assets594873
Total current assets11,29710,959
Property, plant and equipment, net2,1151,932
Identifiable intangible assets (net)487467
Goodwill205188
Deferred income taxes and other assets894873
Total assets$ 14,998$ 14,419
Liabilities and Shareholders' Equity
Current portion of long-term debt$ 200$ 7
Notes payable187139
Accounts payable1,4691,255
Accrued liabilities1,9851,904
Income taxes payable11759
Total current liabilities3,9583,364
Long-term debt276446
Deferred income taxes and other liabilities921855
Total liabilities5,1554,665
Common stock at stated value33
Capital in excess of stated value3,9443,441
Accumulated other comprehensive income95215
Retained earnings5,8016,095
Total shareholders' equity9,8439,754
Total liabilities and shareholders' equity$ 14,998$ 14,419

We forecast Nike's income statement using the following forecast assumptions:

Revenue growth based on growth in revenues from 2010 to 201110%
Cost of sales/Revenues54.4%
Demand creation expense/Revenues11.7%
Operating overhead expenses/Revenues20.3%
Income taxes/Income before income taxes25.0%

Instructions: Forecast Nike's fiscal year 2012 income statement.

Assume no change for: other income and interest expense.

Round forecasts to $ millions.

Do not use negative signs with your answers in the income statement.

Consolidated Statements of Income
($ millions)20112012
Revenues$20,862$Answer
Cost of sales11,354Answer
Gross profit9,508Answer
Demand creation expense2,448Answer
Operating overhead expense4,245Answer
Interest expense, net4Answer
Other income33Answer
Income before income taxes2,844Answer
Income taxes711Answer
Net Income$ 2,133$Answer

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

Accounts receivable/Revenues15.0%
Inventories/Revenues13.0%
Deferred income taxes/Revenues1.5%
Prepaid expenses and other current assets/Revenues2.8%
L-T deferred income taxes and other assets/Revenues4.3%
Depreciation expense/Prior-year PPE, net (incl. in overhead)17.3%
Amortization expense$24
Accounts payable/Revenues7.0%
Accrued liabilities/Revenues9.5%
Income taxes payable/Revenues0.6%
Deferred income taxes and other liabilities/Revenues4.4%
Capital expenditures/Revenues2.1%
Dividends/Net income26.0%
Current portion of L/T due in 2013$48

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

Balance Sheet
($ millions)20112012
Assets
Cash and equivalents$ 1,955$Answer
Short-term investments2,583Answer
Accounts receivable, net3,138Answer
Inventories2,715Answer
Deferred income taxes312Answer
Prepaid expenses and other current assets594Answer
Total current assets11,297Answer
Property, plant and equipment, net2,115Answer
Identifiable intangible assets, net487Answer
Goodwill205Answer
Deferred income taxes and other assets894Answer
Total assets$14,998$Answer
Liabilities and Shareholders' Equity
Current portion of long-term debt$ 200$ Answer
Notes payable187Answer
Accounts payable1,469Answer
Accrued liabilities1,985Answer
Income taxes payable117Answer
Total current liabilities3,958Answer
Long-term debt276Answer
Deferred income taxes and other liabilities921Answer
Total liabilities5,155Answer
Common stock at stated value3Answer
Capital in excess of stated value3,944Answer
Accumulated other comprehensive income95Answer
Retained earnings5,801Answer
Total shareholders' equity9,843Answer
Total liabilities and shareholders' equity$14,998$ Answer

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

Remember to use negative signs with your answers below, when appropriate.

Nike's Forecasted Statement of Cash Flows
($ millions)2012 Est.
Net income$ Answer
Add: depreciationAnswer
Add: amortizationAnswer
Change in Accounts receivableAnswer
Change in InventoriesAnswer
Change in Deferred income taxesAnswer
Change in Prepaid expenses & other current assetsAnswer
Change in LT Deferred income taxes & other assetsAnswer
Change in Accounts payableAnswer
Change in Accrued liabilitiesAnswer
Change in Income taxes payableAnswer
Change in LT Deferred income taxes and other liabilitiesAnswer
Net cash from operating activitiesAnswer
Capital expendituresAnswer
Net cash from investing activitiesAnswer
DividendsAnswer
Payments of LT debtAnswer
Net cash from financing activitiesAnswer
Net change in cashAnswer
Beginning cashAnswer
Ending cash$ Answer

Step by Step Solution

3.57 Rating (157 Votes )

There are 3 Steps involved in it

Step: 1

Required solution Consolidated Statement of Income In Millions 2011 2012 Revenues 20862 22948 Cost of Sales 11354 12484 Gross Profit 9508 10464 Demand ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: J. David Spiceland, Wayne Thomas, Don Herrmann

2nd Edition

0078110823, 9780078110825

More Books

Students also viewed these Accounting questions

Question

Describe Hobbess position on epistemology.

Answered: 1 week ago

Question

14. State the all-or-none law.

Answered: 1 week ago