Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started