Question

P5-38. Analysis and Interpretation of Return on Investment for Competitors Balance sheets and income statements for The HomeHOME DEPOT, INC. LOWES COMPANIES Balance Sheets Balance Sheets ($ millions) 2014 2013 2014 2013 $1,723 $ 1,929 $ 406 125 $ 3HOME DEPOT, INC. LOWES COMPANIES Income Statements Income Statements ($ millions) 2014 2013 2014 2013 : $83,176 54,222 $78,8REQUIRED a. Compute return on equity (ROE), return on assets (ROA), and return on financial leverage (ROFL) for each company

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

Ratio Home Depot Lowe's

ROE

(Net Income / Shareholder's equity)

= $6,345 / $9,322

= 68.06%

= $2,698 / $9,968

= 27.07%

ROA

(Net Income / Total Assets)

=$6,345 / $39,945

= 15.88%

= $2,698 / $31,827

= 8.48%

Interest Rate

(Interest/ Interest Paying Debt)

=$830/17,197

=4.83%

=522/11,367

=4.59%

ROFL

(ROA - Interest Rate)

=15.88% - 4.83%

=11.05%

=8.48% - 4.59%

= 3.89%

B) Home Depot

* Profit Margin = Net Income / Sales = $6,345 / $83,176 = 7.63%

* Asset turnover = Sales / Total Assets = $83,176 /  $39,945 = 2.082

ROA = PM x AT = 7.63% x 2.082 = 15.88%

Both profit margin and asset turnover drive the ROA for Home Depot.

Lowe's Company

* Profit Margin = Net Income / Sales = $2,698 / $56,223 = 4.80%

* Asset turnover = Sales / Total Assets = $56,223 / $31,827= 1.77

ROA = PM x AT = 4.80% x 1.77 = 8.48%

The asset turnover is the main driving force of ROA for Lowe's company.

C)

Ratio Home depot Lowe's

Gross profit margin

Gross profit / Sales *100

= $28954 / $83,176

= 34.81%

= $19558 / $56,223

= 34.79%

Operating expenses to sales

Operating expenses / Sales

= $18,485 / $83,176

= 22.22%

=$14766 / $56,223

= 26.26%

The Gross profit ratio of home depot is more than Lowe's company that means Home depot is more profitable.

Add a comment
Know the answer?
Add Answer to:
P5-38. Analysis and Interpretation of Return on Investment for Competitors Balance sheets and income statements for...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Analysis and Interpretation of Return on Investment for Competitors Balance sheets and income statements for The...

    Analysis and Interpretation of Return on Investment for Competitors Balance sheets and income statements for The Home Depot, Inc., and Lowe's Companies, Inc., follow. Refer to these financial statements to answer the requirements. P5-38. Analyzing and Interpreting Financial Statemen HOME DEPOT, INC. LOWE'S 2014 2013 2014 ..$ 1,723 $1,929 466s 11,079 11,0578,911 Balance Sheets S millions) 125 1,398911 9,127 Cash and cash equivalents Short-term investments.... Receivables, net 1.016 95578 15,302 15,27910,080 22,720 23,348 20,034 1,289 BO10.296 Other current assets Total...

  • P5-38 Analysis and Interpretation of Return on Investment for Competitors Balance sheets and income statements for...

    P5-38 Analysis and Interpretation of Return on Investment for Competitors Balance sheets and income statements for The Home Depot, Inc., and Lowe’s Companies, Inc., follow. Refer to these financial statements to answer the requirements. Compute return on equity (ROE), return on assets (ROA), and return on financial leverage (ROFL) for each company in 2014. Disaggregate the ROA’s computed into profit margin (PM) and asset turnover (AT) components. Which of these factors drives ROA for each company? Compute the gross profit...

  • Balance sheets and income statements for the home depot inc. and lowe's companies inc . 1.Compute...

    Balance sheets and income statements for the home depot inc. and lowe's companies inc . 1.Compute return on equity, return on assets, and return on financial leverage for each company in 2014 2. Disaggregate the ROA's computed into profit margin (PM) and asset turnover (AT) components. Which of these factors drives ROA for each company? 3. Compute the gross profit margin (GPM) and operating expense-to-sales ratios for each company. How do these companies' profitability measures compare? 4. Compute the accounts...

  • P4-42. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below...

    P4-42. Compute the DuPont Disaggregation of ROE Refer to the balance sheets and income statement below for Under Armour Inc. UNDER ARMOUR INC. Consolidated Statements of Income For 12 Months Ended ($ in 000s) Dec. 31, 2015 M Net revenues ................................ Cost of goods sold ......... Gross profit.. Selling, general and administrative expenses ....... Income from operations ........ Interest expense, net ....... Other expense, net..................................................... Income before income taxes........... Provision for income taxes............... Net income.... o n o polduOHS. ...............

  • Refer to the January 29, 2016, income statement and balance sheet of Lowe's Companies Inc. below....

    Refer to the January 29, 2016, income statement and balance sheet of Lowe's Companies Inc. below. LOWE'S COMPANIES INC. Income Statement (In millions) For Fiscal Year Ended January 29, 2016 Net sales.............................................. Cost of sales.................................. ... Gross margin ....................................... Selling, general and administrative Depreciation.. tion......................................... Interest-net........................................ Total expenses... Pretax earnings Income tax provision ... Net earnings $59,074 38,504 20,570 14,115 1,484 552 16.151 4,419 1,873 $ 2,546 Required: Compute the following liquidity, solvency, and coverage ratios for Lowe's Companies. Interpret...

  • Analysis and Interpretation of Profitability Balance sheets and income statements for Nordstrom, Inc., follow. Refer to...

    Analysis and Interpretation of Profitability Balance sheets and income statements for Nordstrom, Inc., follow. Refer to these financial statements to answer the requirements. Nordstrom, Inc. Consolidated Statements of Earnings For Fiscal Years Ended ($ millions) 2016 2015 2014 Net Sales $14,095 $13,110 $12,166 Credit card revenues 342 396 374 Total revenues 14,437 13,506 12,540 Cost of sales and related buying and occupancy costs (9,168) (8,406) (7,737) Selling, general and administrative expenses (4,168) (3,777) (3,453) Earnings before interest and income taxes...

  • PLease answer A-D P4-41. Analysis and Interpretation of Profitability Balance sheets and income statements for 3M...

    PLease answer A-D P4-41. Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years Ended Dec. 31 ($ millions) 2015 2013 2014 $31,821 $30,274 $30,871 15,383 6,182 1,763 16,447 6,469 1,770 24,686 7135 16,106 6,384 1,715 24,205 6,666 23,328 6,946 Net sales ............................................ Operating expenses Cost of sales. Selling, general and administrative expenses ......... Research, development and related expenses ........ Total operating expenses....... Operating income..... Interest expense and...

  • Refer to the balance sheets and income statement for Under Armour Inc. in P3-47. Use these...

    Refer to the balance sheets and income statement for Under Armour Inc. in P3-47. Use these financials to answer the requirements. For the 2015 fiscal year, Under Armour had a return on net operating assets (RNOA) of 15.17%. a. Compute ROE. b. Compute net nonoperating obligations (NNO). c. Compute FLEV and Spread. d. Show that ROE = RNOA + (FLEV X Spread). e. What is the nonoperating return for the year? What does this suggest about Under Armour's use of...

  • Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY...

    Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2015 2014 2013 Net sales $30,274 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general and administrative expenses 6,182 6,469 6,384 Research, development and related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 6,946 7,135 6,666 Interest expenses and income Interest expense 149 142 145 Interest...

  • Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY...

    Analysis and Interpretation of Profitability Balance sheets and income statements for 3M Company follow. 3M COMPANY Consolidated Statements of Income For Years ended December 31 ($ millions) 2015 2014 2013 Net sales $30,274 $31,821 $30,871 Operating expenses Cost of sales 15,383 16,447 16,106 Selling, general and administrative expenses 6,182 6,469 6,384 Research, development and related expenses 1,763 1,770 1,715 Total operating expenses 23,328 24,686 24,205 Operating income 6,946 7,135 6,666 Interest expenses and income Interest expense 149 142 145 Interest...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT