Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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,268 $ 1,325 $ 1,482 Receivables, net 991 973 2,141 Merchandise Inventories 10,768 10,263 12,649 Other Current Assets 1,201 1,331 607 Total Current Assets 14,228 13,892 16,879 Net Property and Equipment 26,423 25,704 21,892 Goodwill 1,144 1,172 2,077 Other Assets 408

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,268 $ 1,325 $ 1,482
Receivables, net 991 973 2,141
Merchandise Inventories 10,768 10,263 12,649
Other Current Assets 1,201 1,331 607
Total Current Assets 14,228 13,892 16,879
Net Property and Equipment 26,423 25,704 21,892
Goodwill 1,144 1,172 2,077
Other Assets 408 242 1,238
Total Assets $ 42,203 $ 41,010 42,086
Liabilities and stockholders equity
Current Liabilities:
Short-Term Debt $ 550 $ 370 $ 610
Accounts Payable 4,821 5,413 7,000
Accrued Salaries and Related Expenses 1,110 1,247 1,484
Sales Taxes Payable 326 360 508
Deferred Revenue 1,153 1,145 1,769
Income Taxes Payable 283 102 28
Current Installments of Long-Term Debt 1,760 1,019 342
Other Accrued Expenses 1,633 1,584 2,225
Total Current Liabilities 11,636 11,240 13,966
Long-Term Debt, excluding current installments 9,649 8,660 8,985
Deferred Income Taxes 361 309 276
Other Long-Term Liabilities 2,196 2,128 1,755
Total Liabilities 24,634 23,173 26,475
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,297 shares at February 3, 2019 , 1,072 shares at January 28, 2018 and 1,181 shares at January 29, 2017 83 84 86
Paid-In Capital 6,036 6,296 5,901
Retained Earnings 43,701 57,555 24,189
Accumulated Other Comprehensive Loss (79 ) (354 ) (655 )
Treasury stock, at cost, 383 shares at February 3, 2019 , 588 shares at January 28, 2018 and 539 shares at January 29, 2017 (32,172 ) (46,452 ) (37,730 )
Total stockholders (deficit) equity 17,569 17,129 68,561
Total Liabilities and Stockholders Equity $ 42,203 $ 41,010 42,086

THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS
in millions, except per share data Fiscal 2018 Fiscal 2017 Fiscal 2016
Net sales $ 66,181 $ 71,293 $ 77,351
Cost of Sales 43,746 47,291 51,341
Gross profit 22,435 24,002 26,010
Operating Expenses:
Selling, General and Administrative 15,887 17,829 17,038
Depreciation and Amortization 1,700 1,773 1,688
Impairment loss 247
Total Operating Expenses 17,834 19,602 18,726
Operating income 4,601 4,400 7,284
Interest and Other (Income) Expense:
Interest and Investment Income (24 ) (24 ) (81 )
Interest Expense 663 610 687
Other 156
Interest and Other, net 795 586 606
Earnings before provision for income taxes 3,806 3,814 6,678
Provision for Income Taxes 1,342 1,270 2,402
Net earnings $ 2,464 $ 2,544 $ 4,276
Basic weighted average common shares 1,589 1,652 1,738
Basic earnings per share $ 1.55 $ 1.54 $ 2.46
Diluted weighted average common shares 1,601 1,660 1,599
Diluted earnings per share $ 1.54 $ 1.53 $ 2.67

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.

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.

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

Information For Decision Making Readings In Cost And Managerial Accounting

Authors: Alfred Rappaport

3rd Edition

0134643542, 978-0134643540

More Books

Students also viewed these Accounting questions

Question

Th ey told me Id have to write a lett er. Whos got time for that?

Answered: 1 week ago