Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required information The following are the balance sheet and consolidated statement of earnings of The Home Depot, Inc. THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS

image text in transcribed

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Required information The following are the balance sheet and consolidated statement of earnings of The Home Depot, Inc. THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February January January millions, except per share data 3, 2019 28, 2018 29, 2017 Assets Current Assets: Cash and Cash Equivalents $ 1,268 $ 1,328 $ 1,485 Receivables, net 984 972 2,140 Merchandise Inventories 10,753 10,223 12,609 other Current Assets 1,193 1,340 616 Total Current Assets 14,198 13,863 16,850 Net Property and Equipment 26,329 25,669 21,857 Goodwill 1,149 1,177 2,082 other Assets 412 240 1,236 Total Assets $ 42,088 $ 40,949 42,025 Liabilities and stockholders' equity Current Liabilities: Short-Term Debt $ 580 $ 390 $ 810 Accounts Payable 4,807 5,433 6,900 Accrued Salaries and Related Expenses 1,116 1,247 1,384 Sales Taxes Payable 319 342 508 Deferred Revenue 1,162 1,142 1,769 Income Taxes Payable 284 98 26 Current Installments of Long-Term Debt 1,759 1,014 342 other Accrued Expenses 1,631 1,583 2,180 Total Current Liabilities 11,658 11,249 13,919 Long-Term Debt, excluding current installments 9,662 8,657 8,982 Deferred Income Taxes 356 317 276 Other Long-Term Liabilities 2:192 2:125 1:755 Total Liabilities 24,674 23.173 26.425 Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,660 at February 3, 2019, 1,680 shares at January 28, 2018 and 1,720 shares at January 29, 2017; outstanding: 1,307 shares at February 3, 2019 , 1,073 shares at January 28, 2018 and 1,182 shares at January 29, 2017 83 84 86 Paid-In Capital 6,037 6,298 5,903 Retained Earnings 43,083 57,408 24,141 Accumulated other Comprehensive Loss (84) (359) (660) Treasury stock, at cost, 373 shares at February 3, 2019 , 587 shares at January 28, 2018 and 538 shares at January 29, 2017 (31,705) (46,373) (37,660) Total stockholders' (deficit) equity 17,414 17,058 68,450 Total Liabilities and Stockholders' Equity $ 42,088 $ 40,949 42,025 r___________________________________________________________________________________ THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Fiscal Fiscal in millions, except per share data 2018 2017 2016 Net sales $66,191 $71,288 $77,353 Cost of Sales 43,760 47,298 51,332 Gross profit 22,431 23,990 26,021 Operating Expenses: Selling, General and Administrative 15,897 17,832 17,039 Depreciation and Amortization 1,703 1,778 1,689 Impairment loss 247 Total Operating Expenses 17,847 19,610 18,728 Operating income 4,584 4,330 7,293 Interest and other (Income) Expense: Interest and Investment Income (20) (20) (89) Interest Expense 658 611 685 other 152 Interest and other, net 790 591 596 Earnings before provision for income taxes 3,794 3,789 6,697 Provision for Income Taxes 1,354 1,278 2,407 Net earnings $ 2:440 $ 21511 $ 4:290 Basic weighted average common shares 1,519 1,582 1,668 Basic earnings per share $ 1.61 $ 1.59 $ 2.57 Diluted weighted average common shares 1,531 1,590 1,529 Diluted earnings per share $ 1.59 $ 1.58 $ 2.81 | Fiscal 2018 includes 53 weeks. Fiscal 2017 and fiscal 2016 include 52 weeks. 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. 3-2. Compute the quick ratio for the fiscal years ending February 3, 2019, and January 28, 2018. 3-3. Compute the amount of working capital for the fiscal years ending February 3,2019, and January 28, 2018. 3-4. Compute the change in working capital from the prior year for the fiscal years ending February 3, 2019, and January 28,2018. Req Al Req A2 Req A3 Req A4 Compute the current ratio for the fiscal years ending February 3, 2019, and January 28, 2018. (Round your answers to 2 decimal places.) Current Ratio February 3, 2019 to 1 January 28, 2018 : to 1Req A1 Req A2 Req A3 Req A4 Compute the quick ratio for the fiscal years ending February 3, 2019, and January 28, 2018. (Round your answers to 2 decimal places.) Quick Ratio February 3, 2019 to 1 January 28, 2018 to 1Compute the amount of working capital for the fiscal years ending February 3, 2019, and January 28, 2018. (Enter your answers in thousands.) Working Capital February 3, 2019 January 28, 2018Compute the change in working capital from the prior year for the fiscal years ending February 3, 2019, and January 28, 2018. (Enter your answers in thousands.) Change in Working Capital February 3, 2019 January 28, 2018

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Intermediate Accounting

Authors: J. David Spiceland, James Sepe, Lawrence A. Tomassini

4th Edition

0072994029, 9780072994025

More Books

Students also viewed these Accounting questions

Question

Of what value to investors are stock dividends and splits?

Answered: 1 week ago

Question

In what sense can the historian be objective?

Answered: 1 week ago

Question

1. Information that is currently accessible (recognition).

Answered: 1 week ago