Ex 1-26 Ratio of liabilities to stockholders’ equity

The Home Depot, Inc., 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                          $40,125         $40,877
Total stockholders’ equity     18,889          19,393

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)?

Answer:
a.
Year 2:  $21,236  ($40,125 – $18,889)
Year 1:  $21,484  ($40,877 – $19,393)

b.
Year 2:  1.12  ($21,236 ÷ $18,889)
Year 1:  1.11  ($21,484 ÷ $19,393)

c.
The ratio of liabilities to stockholders’ equity increased from 1.11 to 1.12 indicating a slight increase in risk for creditors from Year 1 to Year 2.