Required information

Skip to question

The following are the balance sheet and consolidated statement of earnings of The Home Depot, Inc.

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,263		$	1,324		$	1,481
Receivables, net		988			976			2,144
Merchandise Inventories		10,698			10,248			12,634
Other Current Assets		1,194			1,340			616
Total Current Assets		14,143			13,888			16,875
Net Property and Equipment		26,322			25,651			21,839
Goodwill		1,141			1,172			2,077
Other Assets		401			241			1,237
Total Assets	$	42,007		$	40,952			42,028
Liabilities and stockholders equity
Current Liabilities:
Short-Term Debt	$	550		$	360		$	610
Accounts Payable		4,814			5,433			7,500
Accrued Salaries and Related Expenses		1,111			1,247			1,384
Sales Taxes Payable		335			346			508
Deferred Revenue		1,147			1,141			1,669
Income Taxes Payable		270			103			22
Current Installments of Long-Term Debt		1,749			1,019			342
Other Accrued Expenses		1,639			1,586			2,175
Total Current Liabilities		11,615			11,235			14,210
Long-Term Debt, excluding current installments		9,655			8,660			8,985
Deferred Income Taxes		354			309			356
Other Long-Term Liabilities		2,179			2,123			1,955
Total Liabilities		24,596			23,159			26,819
Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,640 at February 3, 2019, 1,660 shares at January 28, 2018 and 1,700 shares at January 29, 2017; outstanding: 1,286 shares at February 3, 2019 , 1,051 shares at January 28, 2018 and 1,160 shares at January 29, 2017		82			83			85
Paid-In Capital		6,038			6,293			5,898
Retained Earnings		42,787			57,000			25,484
Accumulated Other Comprehensive Loss		(80	)		(359	)		(660	)
Treasury stock, at cost, 374 shares at February 3, 2019 , 589 shares at January 28, 2018 and 540 shares at January 29, 2017		(31,416	)		(45,942	)		(36,720	)
Total stockholders (deficit) equity		17,411			17,075			68,847
Total Liabilities and Stockholders Equity	$	42,007		$	40,952			42,028

THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS
in millions, except per share data	Fiscal 2018				Fiscal 2017				Fiscal 2016
Net sales	$	66,178			$	71,296			$	77,354
Cost of Sales		43,760				47,278				51,349
Gross profit		22,418				24,018				26,005
Operating Expenses:
Selling, General and Administrative		15,895				17,836				17,047
Depreciation and Amortization		1,699				1,774				1,691
Impairment loss		237
Total Operating Expenses		17,831				19,610				18,738
Operating income		4,587				4,408				7,267
Interest and Other (Income) Expense:
Interest and Investment Income		(18	)			(18	)			(79	)
Interest Expense		673				613				695
Other		155
Interest and Other, net		810				595				616
Earnings before provision for income taxes		3,777				3,813				6,651
Provision for Income Taxes		1,348				1,267				2,398
Net earnings	$	2,429			$	2,546			$	4,253
Basic weighted average common shares		1,539				1,602				1,688
Basic earnings per share	$	1.58			$	1.59			$	2.52
Diluted weighted average common shares		1,551				1,610				1,549
Diluted earnings per share	$	1.57			$	1.58			$	2.75

Fiscal 2018 includes 53 weeks. Fiscal 2017 and fiscal 2016 include 52 weeks.

rev: 06_17_2020_QC_CS-216907

Assume that you are the credit manager of a medium-size supplier of building materials and related products. Home Depot wants to make credit purchases from your company, with payment due in 60 days.

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.

rev: 10_19_2020_QC_CS-236093