Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Forecast 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

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

Recommended Textbook for

Accounting Ethics

Authors: Ronald F. Duska, Brenda Shay Duska, Julie Anne Ragatz

2nd Edition

1405196130, 978-1405196130

More Books

Students also viewed these Accounting questions

Question

Find VO in the circuit shown. 24 W

Answered: 1 week ago

Question

Summarize the types of job analysis information.

Answered: 1 week ago

Question

Explain the human resource planning process.

Answered: 1 week ago