EX 1-26 Ratio of liabilities to stockholders’ equity

The Home Depot is the world’s largest home improvement retailer and one of the largest retailers in the United States based on net sales volume. The Home Depot operates over 2,200 Home Depot® stores that sell a wide assortment of building materials and home improvement and lawn and garden products.

The Home Depot recently reported the following balance sheet data (in millions):

                                                 Year 2 | Year 1
Total assets                            $39,946 | $40,518
Total stockholders’ equity         9,322 | 12,522

a. Determine the total liabilities at the end of Years 2 and 1.

b. Determine the ratio of liabilities to stockholders’ equity for Year 2 and Year 1. Round to two decimal places.

c.  What conclusions regarding the margin of protection to the creditors can you draw from (b)?

Answers:
a.
Year 2:  $30,624  ($39,946 – $9,322)
Year 1:  $27,996  ($40,518 – $12,522)

b.
Year 2:  3.29  ($30,624 ÷ $9,322)
Year 1:  2.24  ($27,996 ÷ $12,522)

c.
The ratio of liabilities to stockholders’ equity increased from 2.24 to 3.29 indicating an increase in risk for creditors from Year 1 to Year 2.