Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Forecasting the Statement of Cash Flows Following are the income statements and balance sheets of Best Buy Co., Inc. Income Statement, Fiscal Years Ended ($

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 $52,786 $50,272
Cost of goods sold 39,484 37,611
Restructuring charges - cost of goods sold -- 24
Gross profit 13,302 12,637
Selling, general and administrative expenses 10,821 10,325
Restructuring charges -- 198
Goodwill and tradename impairment -- --
Operating income 2,481 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,445 2,078
Income tax expense 841 714
Equity in income of affiliates 2 2
Net earnings including noncontrolling interests 1,606 1,366
Net earnings attributable to noncontrolling interests (104) (89)
Net earnings attributable to Best Buy Co., Inc. $1,502 $1,277

Balance Sheet ($ millions) 2012 Estimated Feb. 26, 2011
Assets
Cash and cash equivalents $1,161 $1,103
Short-term investments 866 22
Receivables 2,481 2,348
Merchandise inventories 6,176 5,897
Other current assets 1,161 1,103
Total current assets 11,845 10,473
Gross property and equipment 8,697 7,905
Less accumulated depreciation 5,031 4,082
Net property and equipment 3,666 3,823
Goodwill 2,454 2,454
Tradenames, Net 108 133
Customer Relationships, Net 165 203
Equity and Other Investments 328 328
Other assets 475 435
Total assets $ 19,041 $ 17,849
Liabilities and Equity
Accounts payable $ 5,120 $ 4,894
Unredeemed giftcard liabilities 475 474
Accrued compensation and related expenses 581 570
Accrued liabilities 1,531 1,471
Accrued income taxes 264 256
Short-term debt 557 557
Current portion of long-term debt 37 441
Total current liabilities 8,565 8,663
Long-term liabilities 1,183 1,183
Long-term debt 674 711
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,595 6,372
Accumulated other comprehensive income 173 173
Total Best Buy Co., Inc. shareholders' equity 7,825 6,602
Noncontrolling interests 794 690
Total equity 8,619 7,292
Total liabilities and shareholders' equity $19,041 $17,849

CAPEX (Increase in gross Property and equipment)/Net sales 1.50%
Depreciation expense/Prior year gross PPE 12.00%
Dividends/Net income 18.60%
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 Forcasted Statement of Cash Flows
($ millions) 2012 Estimated
Net income including noncontrolling interests $Answer

0.00 points out of 1.00

Add: depreciation Answer

0.00 points out of 1.00

Add: amortization Answer

0.00 points out of 1.00

Change in Accounts receivable Answer

0.00 points out of 1.00

Change in Inventories Answer

0.00 points out of 1.00

Change in Other current assets Answer

0.00 points out of 1.00

Change in Other long-term assets Answer

0.00 points out of 1.00

Change in Accounts payable Answer

0.00 points out of 1.00

Change in Unredeemed gift card liabilities Answer

0.00 points out of 1.00

Change in Accrued compensation and related expenses Answer

0.00 points out of 1.00

Change in Accrued liabilities Answer

0.00 points out of 1.00

Change in Accrued income taxes Answer

0.00 points out of 1.00

Net cash from operating activities Answer

0.00 points out of 1.00

Capital expenditures Answer

0.00 points out of 1.00

Increase in Short-term investments Answer

0.00 points out of 1.00

Net cash from investing activities Answer

0.00 points out of 1.00

Dividends Answer

0.00 points out of 1.00

Payments of LT debt Answer

0.00 points out of 1.00

Net cash from financing activities Answer

0.00 points out of 1.00

Net change in cash Answer

0.00 points out of 1.00

Beginning cash Answer

0.00 points out of 1.00

Ending cash $Answer

0.00 points out of 1.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions

Question

What are negative messages? (Objective 1)

Answered: 1 week ago