90.2K

Verified Solution

Link Copied!

Forecasting the Statement of Cash Flows Following are the income statements and balance sheets of Best Buy Co., Inc.

Income Statement, Fiscal Years Ended ($ millions)	2012 Estimated	Feb. 26, 2011
Revenue	$51,780	$50,272
Cost of goods sold	38,731	37,611
Restructuring charges - cost of goods sold	--	24
Gross profit	13,049	12,637
Selling, general and administrative expenses	10,615	10,325
Restructuring charges	--	198
Goodwill and tradename impairment	--	--
Operating income	2,434	2,114
Other income (expenses)
Investment income and other	51	51
Interest expense	(87)	(87)
Earnings before income tax expense and equity in income of affiliates	2,398	2,078
Income tax expense	825	714
Equity in income of affiliates	2	2
Net earnings including noncontrolling interests	1,575	1,366
Net earnings attributable to noncontrolling interests	(118)	(89)
Net earnings attributable to Best Buy Co., Inc.	$1,457	$1,277

Balance Sheet ($ millions)	2012 Estimated	Feb. 26, 2011
Assets
Cash and cash equivalents	$1,139	$1,103
Short-term investments	925	22
Receivables	2,434	2,348
Merchandise inventories	6,058	5,897
Other current assets	1,139	1,103
Total current assets	11,695	10,473
Gross property and equipment	8,682	7,905
Less accumulated depreciation	5,031	4,082
Net property and equipment	3,651	3,823
Goodwill	2,454	2,454
Tradenames, Net	108	133
Customer Relationships, Net	165	203
Equity and Other Investments	328	328
Other assets	466	435
Total assets	$18,867	$17,849
Liabilities and equity
Accounts payable	$5,023	$4,894
Unredeemed gift card liabilities	466	474
Accrued compensation and related expenses	570	570
Accrued liabilities	1,502	1,471
Accrued income taxes	259	256
Short-term debt	557	557
Current portion of long-term debt	37	441
Total current liabilities	8,414	8,663
Long-term liabilities	1,183	1,183
Long-term debt	674	711
Contingencies and Commitments (Note 13)
Best Buy Co., Inc. Shareholders' Equity
Preferred stock, $1.00 par value: Authorized - 400,000 shares; Issued and outstanding - none	--	--
Common stock, $0.10 par value: Authorized - 1.0 billion shares; Issued and outstanding - 392,590,000 and 418,815,000 shares, respectively	39	39
Additional paid-in capital	18	18
Retained earnings	7,558	6,372
Accumulated other comprehensive income	173	173
Total Best Buy Co., Inc. shareholders' equity	7,788	6,602
Noncontrolling interests	808	690
Total equity	8,596	7,292
Total liabilities and Equity	$18,867	$17,849

CAPEX (Increase in gross Property and equipment)/Revenue	1.5%
Depreciation/Prior year gross PPE	12%
Dividends/Net income	18.6%
Long-term debt payments required in fiscal 2013	$37

Refer to the financial information above for Best Buy Co., Inc. Prepare a forecast of its financial year 2012 statement of cash flows. (Hint: Use net income including noncontrolling interests to begin the statement of cash flows. Use negative signs in answers when appropriate.)

Round all answers to the nearest whole number. Use negative signs with answers, when appropriate.

Best Buy Forecasted Statement of Cash Flows
($ millions)	2012 Estimated
Net income including noncontrolling interests	$Answer
Add: depreciation	Answer
Add: amortization	Answer
Change in Accounts receivable	Answer
Change in Inventories	Answer
Change in Other current assets	Answer
Change in Other long-term assets	Answer
Change in Accounts payable	Answer
Change in Unredeemed gift card liabilities	Answer
Change in Accrued compensation and related expenses	Answer
Change in Accrued liabilities	Answer
Change in Accrued income taxes	Answer
Net cash from operating activities	Answer
Capital expenditures	Answer
Increase in Short-term investments	Answer
Net cash from investing activities	Answer
Dividends	Answer
Payments of LT debt	Answer
Net cash from financing activities	Answer
Net change in cash	Answer
Beginning cash	Answer
Ending cash	$Answer

Answer & Explanation Solved by verified expert

See Answer