Question

In: Accounting

Common size statements: the following are income statements for Lowe's and Home depot for the years...

Common size statements: the following are income statements for Lowe's and Home depot for the years ended February 3, 2012 and January 29, 2012, respectively:

1. The companies do not use exactly the same account titles. Align the accounts accross two companies int he manner you beleive to be the most appropriate. Then prepare common-size income statemens for Lowe's and The Home Depot.

2. Compare the two companies by using the common-size statements.

The income statements for the two companies are below:

Lowe's (in millions)
Net Sales 50,208
Cost of sales 32,858
Gross profit 17,350
selling, general and administrative 12,593
depreciation 1,480
interest, net 371
total operating expense 14,444
pretax earnings 2,906
Income tax provision 1,067
net earnings 1,839
The Home Depot (in millions)
Net Sales 70,395
Cost of sales 46,133
Gross profit 24,262
selling, general and administrative 16,028
Depreciation and amortization 1,573
total operating expense 17,601
Operating income 6,661
Interest and investment income -13
Interest Expense 606
Other
Interest and other, net 593
Earnings before provisions for income taxes 6,068
Provisions for income taxes 2,185
Net earnings 3,883

Solutions

Expert Solution

1) Common size income statements

Lowe's (in millions)
Particulars amount ($) %
Net Sales 50,208 100
Cost of sales 32,858 65
Gross profit 17,350 35
selling, general and administrative 12,593 26
depreciation 1,480 2
interest, net 371 1
total operating expense 14,444 29
pretax earnings 2,906 6
Income tax provision 1,067 2
net earnings 1,839 4
The Home Depot (in millions) Amount ($) %
Net Sales 70,395 100
Cost of sales 46,133 66
Gross profit 24,262 34
selling, general and administrative 16,028 23
Depreciation and amortization 1,573 2
Interest and other, net 593 1
total operating expense 18,194 26
Operating income 6,068 8
Provisions for income taxes 2,185 3
Net earnings 3,883 5


2)

sales are higher in home depot
Gross profit is less by 1 % in home depot due to cost of sales
Selling and admin Oh is higher in lowe's when compared to home depot
provision for income taxes are lower in lowe, Similarly they are high in home depot
Net earnings constitute 5 % of sales for home depot

Related Solutions

Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years are as follows: (amounts in thousands of dollars) 2017 2016 Sales revenue $60,000 $50,000 Cost of goods sold 42,000 30,000    Gross profit $18,000 $20,000 Selling and administrative expense 9,000 5,000    Operating income $9,000 $15,000 Interest expense 2,000 2,000    Income before tax $7,000 $13,000 Income tax expense 2,000 4,000    Net income $5,000 $9,000 Required: 1. Using the format in Example 13-5, prepare common-size comparative income...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years are as follows: (amounts in thousands of dollars) 2017 2016 Sales revenue $60,000 $50,000 Cost of goods sold 42,000 30,000    Gross profit $18,000 $20,000 Selling and administrative expense 9,000 5,000    Operating income $9,000 $15,000 Interest expense 2,000 2,000    Income before tax $7,000 $13,000 Income tax expense 2,000 4,000    Net income $5,000 $9,000 Required: 1. Using the format in Example 13-5, prepare common-size comparative income...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years...
Common-Size Income Statements and Horizontal Analysis Income statements for Mariners Corp. for the past two years are as follows: (amounts in thousands of dollars) 2017 2016 Sales revenue $60,000 $50,000 Cost of goods sold 42,000 30,000    Gross profit $18,000 $20,000 Selling and administrative expense 9,000 5,000    Operating income $9,000 $15,000 Interest expense 2,000 2,000    Income before tax $7,000 $13,000 Income tax expense 2,000 4,000    Net income $5,000 $9,000 Required: 1. Using the format in Example 13-5, prepare common-size comparative income...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup window: LOADING... . Which company is doing a better job of getting sales dollars to net income? Where is the one company having an advantage over the other company in turning revenue into net income? Complete the table below: (Round to two decimal places. Net income to three decimal places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window: Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below: (Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart, Inc. Starbucks...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window:   LOADING... . Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below:  ​(Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
After concluding your research about each company; home depot and lowe's, and after reviewing its annual...
After concluding your research about each company; home depot and lowe's, and after reviewing its annual report, discuss what non-financial criteria you would consider when choosing between these two investment options? Support your conclusions, why or why not?
Based on these Common-size Income Statements for Nike for the periods shown, which of the following...
Based on these Common-size Income Statements for Nike for the periods shown, which of the following statements is most accurate? Annual Income Statement (Values in Millions) 2015 2014 2013 2012 2011 Sales 100.0% 100.0% 100.0% 100.0% 100.0% Cost of Sales 53.4% 54.6% 56.6% 57.9% 58.7% Gross Profit 46.6% 45.4% 43.4% 42.1% 41.3% S, G & A Expense 30.7% 30.2% 29.3% 28.5% 28.3% Deprec & Amort 2.1% 2.5% 2.5% 2.8% 2.3% Operating Income 13.8% 12.6% 11.6% 10.8% 10.7% Interest Expense 0.3%...
Restate the following income statements for doing a Common Size comparison: Mega Corporation                            
Restate the following income statements for doing a Common Size comparison: Mega Corporation                                        My Small Company Sales                    7,000,000                                                  80,000 Costs                    5,000,000                                                  50,000 Gross Margin         2,000,000                                                  30,000 Depreciation          200,000                                                   15,000 EBIT                     1,800,000                                                  15,000 Taxes                   630,000                                                   5,000 Net Income           1,170,000                                                  10,000
prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS -...
prepare a common size income statement from the following income statement: CONSOLIDATED STATEMENTS OF OPERATIONS - USD ($) 12 Months Ended shares in Millions, $ in Millions Feb. 01, 2020 Feb. 02, 2019 Feb. 03, 2018 Total net sales $10,716 $11,664 $12,554 Credit income and other 451 355 319 Total revenues 11,167 12,019 12,873 Costs and expenses/(income): Cost of goods sold (exclusive of depreciation and amortization shown separately below) 7,013 7,870 8,208 Selling, general and administrative (SG&A) 3,585 3,596 3,845...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT