Question

The Home Depot, Inc. (HD) operates over 2,200 home improvement retail stores and is a competitor...

The Home Depot, Inc. (HD) operates over 2,200 home improvement retail stores and is a competitor of Lowe's (LOW). The following data (in millions) were adapted from recent financial statements of The Home Depot.

Year 2 Year 1
Total assets $39,946 $40,518
Total liabilities 30,624 27,996
Total stockholders’ equity 9,322 12,522
Earnings per share $4.74 $3.78

1. Compute the debt ratio for Years 1 and 2. Round to one decimal place.

Year 2 Year 1
Debt ratio % %

2. Given your answer to part (1), what is the ratio of stockholders' equity to total assets? Round to one decimal place.

Year 2 Year 1
Ratio of stockholders' equity to total assets % %

3. Compute the ratio of liabilities to stockholders' equity. Round to one decimal place.

Year 2 Year 1
Ratio of liabilities to stockholders' equity % %

5. Comparing Years 1 and 2, should creditors feel more or less safe in Year 2?

6. With a market price of $104.43, compute the price-earnings ratio for Year 2. Round to one decimal place.

7. With a market price of $75.09, compute the price-earnings ratio for Year 1. Round to one decimal place.

Homework Answers

Answer #1

1) Debt ratio

Year 2 Year 1
Debt ratio 30624/39946 = 76.7% 27996/40518 = 69.1%

2. Given your answer to part (1), what is the ratio of stockholders' equity to total assets? Round to one decimal place.

Year 2 Year 1
Ratio of stockholders' equity to total assets 9322/39946 = 23.3% 12522/40518 = 30.9%

3. Compute the ratio of liabilities to stockholders' equity. Round to one decimal place.

Year 2 Year 1
Ratio of liabilities to stockholders' equity 30624/9322 = 328.5% 27996/12522 = 223.6%

5) Feel less safe

6) Price earning ratio = MPS/EPS = 104.43/4.74 = 22.0 Times

7) 75.09/3.78 = 19.9 Times

Know the answer?
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
Similar Questions
Debt and price-earnings ratios The Home Depot, Inc. (HD) operates over 2,200 home improvement retail stores...
Debt and price-earnings ratios The Home Depot, Inc. (HD) operates over 2,200 home improvement retail stores and is a competitor of Lowe's (LOW). The following data (in millions) were adapted from recent financial statements of The Home Depot. Year 2 Year 1 Total assets $39,946 $40,518 Total liabilities 30,624 27,996 Total stockholders’ equity 9,322 12,522 Earnings per share $4.74 $3.78 1. Compute the debt ratio for Years 1 and 2. Round to one decimal place. Year 2 Year 1 Debt...
The income statements for Home Depot, Inc. (HD) spanning the period 2014-2016 are found below: 2014...
The income statements for Home Depot, Inc. (HD) spanning the period 2014-2016 are found below: 2014 2015 2016 Earnings before interest and taxes $7,316,000 $9,700,000 $9,425,000 Interest expense    (696,000)      (392,000)      (143,000) Income before tax $6,620,000 $9,308,000 $9,282,000 Income tax expense (2,410,000) (3,547,000) (3,444,000) Net Income $4,210,000 $5,761,000 $5,838,000 Calculate the times interest earned ratio for each of the years for which you have data. What does this ratio tell you about Home Depot? What is your assessment...
Compute ROE and RNOA with Disaggregation Selected balance sheet and income statement information for Home Depot...
Compute ROE and RNOA with Disaggregation Selected balance sheet and income statement information for Home Depot follows. $ millions                               Jan. 31, 2016             Feb. 01, 2015 Operating assets                        $40,333                     $38,223 Nonoperating assets                      2,216                       1,723 Total assets                                   42,549                     39,946 Operating liabilities                       14,918                     13,427 Nonoperating liabilities                 21,315                    17,197 Total liabilities                                36,233                  30,624 Total stockholders' equity                6,316                    9,322 Sales                                              88,519 (NOPBT)       11,774 Nonoperting expense before tax        753 Tax expense                                     4,012 Net income 7,009 Round all answers to two decimal places (ex: 0.12345 = 12.35%)...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31 Assets Current assets: Cash $ 23,000 Accounts receivable, net 170,000 Merchandise inventory 350,000 Prepaid expenses 12,000 Total current assets 555,000 Property and equipment, net 850,000 Total assets $ 1,405,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 250,000 Bonds payable, 10% 390,000 Total liabilities 640,000 Stockholders’ equity: Common stock, $5 per value $ 180,000 Retained earnings 585,000 Total stockholders’ equity 765,000 Total liabilities...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31 Assets Current assets: Cash $ 24,000 Accounts receivable, net 210,000 Merchandise inventory 310,000 Prepaid expenses 8,000 Total current assets 552,000 Property and equipment, net 910,000 Total assets $ 1,462,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 210,000 Bonds payable, 12% 300,000 Total liabilities 510,000 Stockholders’ equity: Common stock, $10 par value $ 170,000 Retained earnings 782,000 Total stockholders’ equity 952,000 Total liabilities...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31   Assets   Current assets:      Cash $ 23,000      Accounts receivable, net 200,000      Merchandise inventory 400,000      Prepaid expenses 8,000   Total current assets 631,000   Property and equipment, net 850,000   Total assets $ 1,481,000   Liabilities and Stockholders' Equity   Liabilities:      Current liabilities $ 210,000      Bonds payable, 10% 310,000   Total liabilities 520,000   Stockholders’ equity:      Common stock, $10 par value $ 140,000      Retained earnings 821,000   Total stockholders’ equity 961,000   Total liabilities...
ABC Depot: Asset turnover ratio The ABC Depot reported the following data (in millions) in its...
ABC Depot: Asset turnover ratio The ABC Depot reported the following data (in millions) in its recent financial statements: Year 2 Year 1 Total sales $97,200 $100,520 Total assets: Beginning of year 62,400 67,200 End of year 67,200 76,400 a. Determine the asset turnover ratio for ABC Depot for Year 2 and Year 1. Round to one decimal place. Year 2 Year 1 Asset turnover ratio b. What does an asset turnover ratio indicate? Effectiveness in the use of assets...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31   Assets         Current assets:            Cash   $21,000      Accounts receivable, net    250,000      Merchandise inventory    370,000      Prepaid expenses    12,000        Total current assets    653,000   Property and equipment, net    820,000        Total assets   $1,473,000        Liabilities and Stockholders' Equity         Liabilities:            Current liabilities   $260,000      Bonds payable, 11%    400,000        Total liabilities    660,000   Stockholders’ equity:            Common stock, $10 par value   $150,000      Retained earnings    663,000        Total stockholders’ equity    813,000        Total liabilities and equity   $1,473,000      Castile Products, Inc. Income Statement For the Year...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31   Assets   Current assets:      Cash $ 23,000      Accounts receivable, net 190,000      Merchandise inventory 380,000      Prepaid expenses 12,000   Total current assets 605,000   Property and equipment, net 840,000   Total assets $ 1,445,000   Liabilities and Stockholders' Equity   Liabilities:      Current liabilities $ 220,000      Bonds payable, 10% 320,000   Total liabilities 540,000   Stockholders’ equity:      Common stock, $5 par value $ 140,000      Retained earnings 765,000   Total stockholders’ equity 905,000   Total liabilities...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December...
The financial statements for Castile Products, Inc., are given below: Castile Products, Inc. Balance Sheet December 31   Assets   Current assets:      Cash $ 18,000      Accounts receivable, net 190,000      Merchandise inventory 310,000      Prepaid expenses 8,000   Total current assets 526,000   Property and equipment, net 890,000   Total assets $ 1,416,000   Liabilities and Stockholders' Equity   Liabilities:      Current liabilities $ 240,000      Bonds payable, 10% 330,000   Total liabilities 570,000   Stockholders’ equity:      Common stock, $5 par value $ 130,000      Retained earnings 716,000   Total stockholders’ equity 846,000   Total liabilities...