Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 (S in millions, except per share amounts) Aweredumpensational netisodesprema Assume that net sales for the year of 2007 as of Dec. 31, was $60,000 and that cost of goods sold was $38,000 Q3 (20 Points) A-For the Balance Sheet above do the vertical and horizontal analysis as shown in the right columns B- Calculate Accounts Reccivable Tumover Ratio? Write your comment C- Calculate Accounts Receivable Tumover in days Ratio? Write your comment D- Inventory Turnover ratio? Write your comment E- Inventory Turnover in Days? Write your comment F-Calculate how long an investment is locked up in production before turning into cash?"calculate the operating cycle" G-Current Ratio? Write your comment H- Acid-Test Ratio ? Write your comment Dec.31 (S in millions, except per share amounts) Horizontal Commen Sie 919 Assets December December Vertical 31, 2007 31, 2006 Commen Sie for 2007 Current Assets Cash and cash equivalents S 1.205 $ 745 Short-term investments 3,041 Receivables Merchandise inventories 3.338 Other current assets 712 Total current assets 9,081 7.985 Property and Equipment Land and buildings 705 580 Leasehold improvements 1.340 1.325 Fixtures and equipment 2.898 Property under capital lease 32 Total Property and equipment 4.904 4836 Less accumulated depreciation Net property and equipment 2.935 2,712 Goodwill 557 Trade names 8144 Long-Term Investments 318 218 Other Assets Total Assets S 13.570 S11.864 Liabilities and Shareholders' Equity Current Liabilities Accounts payable $ 3.934 $ 3.234 Unredeemed gift card liabilities Accrued compensation and related expenses 354 Accrued liabilities 878 Accrued income taxes 703 Short-term debe Current portion of long-term debt Total current liabilities Non Current Liabilities Long-Term Liabilities 373 Long Term Debt 590 Minority Interests 35 Total Non Current Liabilities 551 Shareholders' Equity Preferred stock. $1.00 par value: Authorized 400.000 shares, issued and outstanding some Common stock, S. 10 par value: Authorized-1 billion shares, issued and 48 outstanding 480,635,000 and 485,095,000 shares, respectively Additional paid-in capital Retained casting 5.500 404 Accumulated other comprehensive income Total shareholders' equity Total Liabilities and Shareholders' Equity SI Best Buy Co., Inc. Consolidated Balance Sheets Dec.31 (S in millions, except per share amounts) Aweredumpensational netisodesprema Assume that net sales for the year of 2007 as of Dec. 31, was $60,000 and that cost of goods sold was $38,000 Q3 (20 Points) A-For the Balance Sheet above do the vertical and horizontal analysis as shown in the right columns B- Calculate Accounts Reccivable Tumover Ratio? Write your comment C- Calculate Accounts Receivable Tumover in days Ratio? Write your comment D- Inventory Turnover ratio? Write your comment E- Inventory Turnover in Days? Write your comment F-Calculate how long an investment is locked up in production before turning into cash?"calculate the operating cycle" G-Current Ratio? Write your comment H- Acid-Test Ratio ? Write your comment Dec.31 (S in millions, except per share amounts) Horizontal Commen Sie 919 Assets December December Vertical 31, 2007 31, 2006 Commen Sie for 2007 Current Assets Cash and cash equivalents S 1.205 $ 745 Short-term investments 3,041 Receivables Merchandise inventories 3.338 Other current assets 712 Total current assets 9,081 7.985 Property and Equipment Land and buildings 705 580 Leasehold improvements 1.340 1.325 Fixtures and equipment 2.898 Property under capital lease 32 Total Property and equipment 4.904 4836 Less accumulated depreciation Net property and equipment 2.935 2,712 Goodwill 557 Trade names 8144 Long-Term Investments 318 218 Other Assets Total Assets S 13.570 S11.864 Liabilities and Shareholders' Equity Current Liabilities Accounts payable $ 3.934 $ 3.234 Unredeemed gift card liabilities Accrued compensation and related expenses 354 Accrued liabilities 878 Accrued income taxes 703 Short-term debe Current portion of long-term debt Total current liabilities Non Current Liabilities Long-Term Liabilities 373 Long Term Debt 590 Minority Interests 35 Total Non Current Liabilities 551 Shareholders' Equity Preferred stock. $1.00 par value: Authorized 400.000 shares, issued and outstanding some Common stock, S. 10 par value: Authorized-1 billion shares, issued and 48 outstanding 480,635,000 and 485,095,000 shares, respectively Additional paid-in capital Retained casting 5.500 404 Accumulated other comprehensive income Total shareholders' equity Total Liabilities and Shareholders' Equity SI
