Homework Help is Here – Start Your Trial Now!
Business
Finance
Financial Data for Best Buy and Circuit Calculate Common- City (all financial data in millions) Sized Statements Here BALANCE SHEET - FISCAL 2006 Assets Best Buy Circuit City Best Buy Circuit City Cash & Equivalents Receivables Net Inventories 3,732 506 838 226 3,338 1,698 Other Current Assets 409 71 Total Current Assets 1,985 2,833 Property, Plant & Equipment - Net 2,712 839 Other Assets 1,025 299 Total Assets 11,722 3,971 Liabilities Accounts Payable 3,234 1,053 ST Debt & Current Portion Due LT Dbt 418 29 Income Taxes Payable 708 22 76 Other Current Liabilities 1,347 485 Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities 5,702 1,623 178 52 585 341 6,485 2,016 Profitability Asset Productivity Financial Leverage Return on Equity (ROE) Return on Assets (ROA) Gross Profit Margin Operating Profit Margin Current Ratio Cash Ratio Debt-to-Equity Ratio Inventory Turnover Capital Intensity Sq ft per store Sales per square foot Sales per store Sales per employee Notes for class discussion Calculate Ratios Here Best Buy Circuit City Difference in the Business model between Best Buy and CC 164 Make notre of all of the observations you made from the comparisons above. Shareholder Equity Common Equity 5,257 1,955 Total Liabilities & Shareholder Equity 11,722 3,971 INCOME STATEMENT - FISCAL 2006 Sales 30,848 11,598 Cost of Goods Sold 22,666 8,603 Gross Profit 8,182 2,995 Depreciation, Depletion & Amortization 456 Selling, General & Admin Costs 6,078 2,590 Operating Income 1,648 241 Non-Operating Income Earnings Before Interest & Taxes 1,755 Interest Expense 30 Income Taxes 577 Net Income Before Extraordinary Items 1,140 Extraordinary Items 0 Net Income 1,140 ལྤlཊྛ¥ 263 3 67 151 -9 142 SELECTED OPERATING DATA No. of Employees 140,000 42,359 No. of Stores Square footage of retail (millions) 1,035 33 1,460 22

Financial Data for Best Buy and Circuit Calculate Common- City (all financial data in millions) Sized Statements Here BALANCE SHEET - FISCAL 2006 Assets Best Buy Circuit City Best Buy Circuit City Cash & Equivalents Receivables Net Inventories 3,732 506 838 226 3,338 1,698 Other Current Assets 409 71 Total Current Assets 1,985 2,833 Property, Plant & Equipment - Net 2,712 839 Other Assets 1,025 299 Total Assets 11,722 3,971 Liabilities Accounts Payable 3,234 1,053 ST Debt & Current Portion Due LT Dbt 418 29 Income Taxes Payable 708 22 76 Other Current Liabilities 1,347 485 Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities 5,702 1,623 178 52 585 341 6,485 2,016 Profitability Asset Productivity Financial Leverage Return on Equity (ROE) Return on Assets (ROA) Gross Profit Margin Operating Profit Margin Current Ratio Cash Ratio Debt-to-Equity Ratio Inventory Turnover Capital Intensity Sq ft per store Sales per square foot Sales per store Sales per employee Notes for class discussion Calculate Ratios Here Best Buy Circuit City Difference in the Business model between Best Buy and CC 164 Make notre of all of the observations you made from the comparisons above. Shareholder Equity Common Equity 5,257 1,955 Total Liabilities & Shareholder Equity 11,722 3,971 INCOME STATEMENT - FISCAL 2006 Sales 30,848 11,598 Cost of Goods Sold 22,666 8,603 Gross Profit 8,182 2,995 Depreciation, Depletion & Amortization 456 Selling, General & Admin Costs 6,078 2,590 Operating Income 1,648 241 Non-Operating Income Earnings Before Interest & Taxes 1,755 Interest Expense 30 Income Taxes 577 Net Income Before Extraordinary Items 1,140 Extraordinary Items 0 Net Income 1,140 ལྤlཊྛ¥ 263 3 67 151 -9 142 SELECTED OPERATING DATA No. of Employees 140,000 42,359 No. of Stores Square footage of retail (millions) 1,035 33 1,460 22

Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
8th Edition
ISBN:9781305961883
Author:Carl Warren
Publisher:Carl Warren
Chapter15: Capital Investment Analysis
Section: Chapter Questions
Problem 15.5.3MBA
See similar textbooks
icon
Related questions
Question
100%

Would someone please show me how to do the calculations for common-sized statements? please don't just give me answers, please show me how to calculate them myself. Thank you!

IMPORTANT TO NOTE:  There is a valuable xcel keyboard  shortcut for completing  Common Size  Financial Statements. For the income Statement, in the cell immediately to the right of Net Sales, enter the formula Net Sales/Net Sales  then press the F4 Key. The number 1 will appear.  Then drag your curser down to the cell immediately to the right of Net Profit.  The column will be populated by fractions. Highlight that Column and format the column to convert to Percentages displayed as a percent to one decimal point. 

Go to the Balance Sheet---Repeat the same process with Total Assets calculating the % of each entry on the left side of the Balance Sheet. Then do the same on the right side of the Balance sheet using Liabilities+ Equity as the denominator. Now you can compare the two retailers and draw conclusions about the two retailers. 

Financial Data for Best Buy and Circuit Calculate Common- City (all financial data in millions) Sized Statements Here BALANCE SHEET - FISCAL 2006 Assets Best Buy Circuit City Best Buy Circuit City Cash & Equivalents Receivables Net Inventories 3,732 506 838 226 3,338 1,698 Other Current Assets 409 71 Total Current Assets 1,985 2,833 Property, Plant & Equipment - Net 2,712 839 Other Assets 1,025 299 Total Assets 11,722 3,971 Liabilities Accounts Payable 3,234 1,053 ST Debt & Current Portion Due LT Dbt 418 29 Income Taxes Payable 708 22 76 Other Current Liabilities 1,347 485 Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities 5,702 1,623 178 52 585 341 6,485 2,016 Profitability Asset Productivity Financial Leverage Return on Equity (ROE) Return on Assets (ROA) Gross Profit Margin Operating Profit Margin Current Ratio Cash Ratio Debt-to-Equity Ratio Inventory Turnover Capital Intensity Sq ft per store Sales per square foot Sales per store Sales per employee Notes for class discussion Calculate Ratios Here Best Buy Circuit City Difference in the Business model between Best Buy and CC 164 Make notre of all of the observations you made from the comparisons above. Shareholder Equity Common Equity 5,257 1,955 Total Liabilities & Shareholder Equity 11,722 3,971 INCOME STATEMENT - FISCAL 2006 Sales 30,848 11,598 Cost of Goods Sold 22,666 8,603 Gross Profit 8,182 2,995 Depreciation, Depletion & Amortization 456 Selling, General & Admin Costs 6,078 2,590 Operating Income 1,648 241 Non-Operating Income Earnings Before Interest & Taxes 1,755 Interest Expense 30 Income Taxes 577 Net Income Before Extraordinary Items 1,140 Extraordinary Items 0 Net Income 1,140 ལྤlཊྛ¥ 263 3 67 151 -9 142 SELECTED OPERATING DATA No. of Employees 140,000 42,359 No. of Stores Square footage of retail (millions) 1,035 33 1,460 22
Transcribed Image Text:Financial Data for Best Buy and Circuit Calculate Common- City (all financial data in millions) Sized Statements Here BALANCE SHEET - FISCAL 2006 Assets Best Buy Circuit City Best Buy Circuit City Cash & Equivalents Receivables Net Inventories 3,732 506 838 226 3,338 1,698 Other Current Assets 409 71 Total Current Assets 1,985 2,833 Property, Plant & Equipment - Net 2,712 839 Other Assets 1,025 299 Total Assets 11,722 3,971 Liabilities Accounts Payable 3,234 1,053 ST Debt & Current Portion Due LT Dbt 418 29 Income Taxes Payable 708 22 76 Other Current Liabilities 1,347 485 Total Current Liabilities Long Term Debt Other Liabilities Total Liabilities 5,702 1,623 178 52 585 341 6,485 2,016 Profitability Asset Productivity Financial Leverage Return on Equity (ROE) Return on Assets (ROA) Gross Profit Margin Operating Profit Margin Current Ratio Cash Ratio Debt-to-Equity Ratio Inventory Turnover Capital Intensity Sq ft per store Sales per square foot Sales per store Sales per employee Notes for class discussion Calculate Ratios Here Best Buy Circuit City Difference in the Business model between Best Buy and CC 164 Make notre of all of the observations you made from the comparisons above. Shareholder Equity Common Equity 5,257 1,955 Total Liabilities & Shareholder Equity 11,722 3,971 INCOME STATEMENT - FISCAL 2006 Sales 30,848 11,598 Cost of Goods Sold 22,666 8,603 Gross Profit 8,182 2,995 Depreciation, Depletion & Amortization 456 Selling, General & Admin Costs 6,078 2,590 Operating Income 1,648 241 Non-Operating Income Earnings Before Interest & Taxes 1,755 Interest Expense 30 Income Taxes 577 Net Income Before Extraordinary Items 1,140 Extraordinary Items 0 Net Income 1,140 ལྤlཊྛ¥ 263 3 67 151 -9 142 SELECTED OPERATING DATA No. of Employees 140,000 42,359 No. of Stores Square footage of retail (millions) 1,035 33 1,460 22
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Century 21 Accounting General Journal
Century 21 Accounting General Journal
Accounting
ISBN:
9781337680059
Author:
Gilbertson
Publisher:
Cengage
College Accounting, Chapters 1-27 (New in Account…
College Accounting, Chapters 1-27 (New in Account…
Accounting
ISBN:
9781305666160
Author:
James A. Heintz, Robert W. Parry
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS