Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started