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 $53,288 $50,272
Cost of goods sold 39,859 37,611
Restructuring charges - cost of goods sold -- 24
Gross profit 13,429 12,637
Selling, general and administrative expenses 10,924 10,325
Restructuring charges -- 198
Goodwill and tradename impairment -- --
Operating income 2,505 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,469 2,078
Income tax expense 849 714
Equity in income of affiliates 2 2
Net earnings including noncontrolling interests 1,622 1,366
Net earnings attributable to noncontrolling interests (105) (89)
Net earnings attributable to Best Buy Co., Inc. $1,517 $1,277

Balance Sheet ($ millions) 2012 Estimated Feb. 26, 2011
Assets
Cash and cash equivalents $1,172 $1,103
Short-term investments 837 22
Receivables 2,505 2,348
Merchandise inventories 6,235 5,897
Other current assets 1,172 1,103
Total current assets 11,921 10,473
Gross property and equipment 8,704 7,905
Less accumulated depreciation 5,031 4,082
Net property and equipment 3,673 3,823
Goodwill 2,454 2,454
Tradenames, Net 108 133
Customer Relationships, Net 165 203
Equity and Other Investments 328 328
Other assets 480 435
Total assets $ 19,129 $ 17,849
Liabilities and Equity
Accounts payable $ 5,169 $ 4,894
Unredeemed giftcard liabilities 480 474
Accrued compensation and related expenses 586 570
Accrued liabilities 1,545 1,471
Accrued income taxes 266 256
Short-term debt 557 557
Current portion of long-term debt 37 441
Total current liabilities 8,640 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,607 6,372
Accumulated other comprehensive income 173 173
Total Best Buy Co., Inc. shareholders' equity 7,837 6,602
Noncontrolling interests 795 690
Total equity 8,632 7,292
Total liabilities and shareholders' equity $19,129 $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
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

HRD Audit Evaluating The Human Resource Function For Business Improvement

Authors: RAO

1st Edition

0761993509, 978-0761993506

More Books

Students also viewed these Accounting questions