Answered step by step
Verified Expert Solution
Question
1 Approved Answer
THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS millions, except per share data February 3, 2019 January 28, 2018 January 29, 2017 Assets Current Assets: Cash
THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS | |||||||||
millions, except per share data | February 3, 2019 | January 28, 2018 | January 29, 2017 | ||||||
Assets | |||||||||
Current Assets: | |||||||||
Cash and Cash Equivalents | $ | 1,259 | $ | 1,322 | $ | 1,479 | |||
Receivables, net | 991 | 974 | 2,142 | ||||||
Merchandise Inventories | 10,688 | 10,218 | 12,604 | ||||||
Other Current Assets | 1,204 | 1,334 | 610 | ||||||
Total Current Assets | 14,142 | 13,848 | 16,835 | ||||||
Net Property and Equipment | 26,334 | 25,667 | 21,855 | ||||||
Goodwill | 1,138 | 1,182 | 2,087 | ||||||
Other Assets | 407 | 227 | 1,223 | ||||||
Total Assets | $ | 42,021 | $ | 40,924 | 42,000 | ||||
Liabilities and stockholders equity | |||||||||
Current Liabilities: | |||||||||
Short-Term Debt | $ | 590 | $ | 370 | $ | 910 | |||
Accounts Payable | 4,812 | 5,433 | 6,700 | ||||||
Accrued Salaries and Related Expenses | 1,115 | 1,251 | 1,484 | ||||||
Sales Taxes Payable | 323 | 356 | 408 | ||||||
Deferred Revenue | 1,146 | 1,142 | 1,569 | ||||||
Income Taxes Payable | 272 | 99 | 29 | ||||||
Current Installments of Long-Term Debt | 1,761 | 1,013 | 442 | ||||||
Other Accrued Expenses | 1,638 | 1,570 | 2,220 | ||||||
Total Current Liabilities | 11,657 | 11,234 | 13,762 | ||||||
Long-Term Debt, excluding current installments | 9,654 | 8,653 | 8,978 | ||||||
Deferred Income Taxes | 360 | 317 | 256 | ||||||
Other Long-Term Liabilities | 2,196 | 2,132 | 1,955 | ||||||
Total Liabilities | 24,653 | 23,161 | 26,264 | ||||||
Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,620 at February 3, 2019, 1,640 shares at January 28, 2018 and 1,680 shares at January 29, 2017; outstanding: 1,268 shares at February 3, 2019 , 1,031 shares at January 28, 2018 and 1,140 shares at January 29, 2017 | 81 | 82 | 84 | ||||||
Paid-In Capital | 6,048 | 6,288 | 5,893 | ||||||
Retained Earnings | 42,942 | 56,385 | 24,365 | ||||||
Accumulated Other Comprehensive Loss | (83 | ) | (361 | ) | (662 | ) | |||
Treasury stock, at cost, 372 shares at February 3, 2019 , 589 shares at January 28, 2018 and 540 shares at January 29, 2017 | (31,620 | ) | (45,353 | ) | (37,260 | ) | |||
Total stockholders (deficit) equity | 17,368 | 17,041 | 68,264 | ||||||
Total Liabilities and Stockholders Equity | $ | 42,021 | $ | 40,924 | 42,000 | ||||
THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS | |||||||||||
in millions, except per share data | Fiscal 2018 | Fiscal 2017 | Fiscal 2016 | ||||||||
Net sales | $ | 66,182 | $ | 71,306 | $ | 77,359 | |||||
Cost of Sales | 43,757 | 47,291 | 51,351 | ||||||||
Gross profit | 22,425 | 24,015 | 26,008 | ||||||||
Operating Expenses: | |||||||||||
Selling, General and Administrative | 15,896 | 17,846 | 17,041 | ||||||||
Depreciation and Amortization | 1,695 | 1,783 | 1,699 | ||||||||
Impairment loss | 247 | ||||||||||
Total Operating Expenses | 17,838 | 19,629 | 18,740 | ||||||||
Operating income | 4,587 | 4,386 | 7,268 | ||||||||
Interest and Other (Income) Expense: | |||||||||||
Interest and Investment Income | (28 | ) | (28 | ) | (74 | ) | |||||
Interest Expense | 670 | 615 | 690 | ||||||||
Other | 151 | ||||||||||
Interest and Other, net | 793 | 587 | 616 | ||||||||
Earnings before provision for income taxes | 3,794 | 3,799 | 6,652 | ||||||||
Provision for Income Taxes | 1,352 | 1,274 | 2,404 | ||||||||
Net earnings | $ | 2,442 | $ | 2,525 | $ | 4,248 | |||||
Basic weighted average common shares | 1,539 | 1,602 | 1,688 | ||||||||
Basic earnings per share | $ | 1.59 | $ | 1.58 | $ | 2.52 | |||||
Diluted weighted average common shares | 1,551 | 1,610 | 1,549 | ||||||||
Diluted earnings per share | $ | 1.57 | $ | 1.57 | $ | 2.74 | |||||
Instructions:
a-1. Compute the current ratio for the fiscal years ending February 3, 2019, and January 28, 2018.
|
a-2. Compute the quick ratio for the fiscal years ending February 3, 2019, and January 28, 2018.
|
a-3. Compute the amount of working capital for the fiscal years ending February 3, 2019, and January 28, 2018.
|
a-4. Compute the change in working capital from the prior year for the fiscal years ending February 3, 2019, and January 28, 2018.
Change in Working Capital | |
February 3, 2019 | |
January 28, 2018 |
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