Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

This question is on Excel. I could not upload the sheet Home Depot Inc. ***You must use cell referencesto earn credit. Common-Size Balance Sheets Dollar

This question is on Excel. I could not upload the sheet

Home Depot Inc.

***You must use cell referencesto earn credit. Common-Size Balance Sheets Dollar amounts in Millions Percentages

Feb. 02, 2020 Feb. 03, 2019 Feb. 02, 2020 Feb. 03, 2019

Current assets:

Cash and cash equivalents $ 2,133 $ 1,778

Receivables, net 2,106 1,936

Merchandise inventories 14,531 13,925

Other current assets 1,040 890

Total current assets 19,810 18,529

Net Property, Plant, and Equipment 22,770 22,375

Operating lease right-of-use assets 5,595 0

Goodwill 2,254 2,252

Other assets 807 847

Total assets 51,236 44,003

Liabilities and Stockholders' Equity

Current liabilities:

Short-term debt 974 1,339

Accounts payable 7,787 7,755

Accrued salaries and related expenses 1,494 1,506

Sales taxes payable 605 656

Deferred revenue 2,116 1,782

Income taxes payable 55 11

Current installments of long-term debt 1,839 1,056

Current operating lease liabilities 828 0

Other accrued expenses 2,677 2,611

Total current liabilities 18,375 16,716

Long-term debt, excluding current installments 28,670 26,807

Long-term operating lease liabilities 5,066 0

Deferred income taxes 706 491

Other long-term liabilities 1,535 1,867

Total liabilities 54,352 45,881

Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,786 shares at February 2, 2020 and 1,782 shares at February 3, 2019; outstanding: 1,077 shares at February 2, 2020 and 1,105 shares at February 3, 2019 89 89

Paid-in capital 11,001 10,578

Retained earnings 51,729 46,423

Accumulated other comprehensive loss (739) (772)

Treasury stock, at cost, 709 shares at February 2, 2020 and 677 shares at February 3, 2019 (65,196) (58,196)

Total stockholders' (deficit) equity (3,116) (1,878)

Total liabilities and stockholders' equity $ 51,236 $ 44,003

#1 Answer the following questions below forthe most recent year.

a.What are the company's 2 largest assets?

b.What are the company's 2 largest liabilities?

c.What percentage of total assets is financed by owners?

d.What percentage of total assets is financed by creditors?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Horngrens Financial and Managerial Accounting

Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura

5th edition

978-0133866292

Students also viewed these Accounting questions