Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

They are asking for the 2018 fiscal year. February 3,2019 is the end of the fiscal year. Using this information can you help me find

They are asking for the 2018 fiscal year. February 3,2019 is the end of the fiscal year. Using this information can you help me find the Quick Ratio, Inventory Turnover, and Average Days to Sell Inventory image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3, January 28, in millions, except per share data Assets Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Net property and equipment Goodwill Other assets Total assets 1,778 $ 1,936 13,925 890 18,529 22,375 2,252 847 44,003 $ 3,595 1,952 12,748 638 18,933 22,075 2,275 1,246 44,529 $ 1,559 7,244 1,640 Liabilities and Stockholders' Equity Current liabilities: Short-term debt Accounts payable Accrued salaries and related expenses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term debt Other accrued expenses Total current liabilities 520 1,339 $ 7,755 1,506 656 1,782 11 1,056 2,611 - 16.716 1,805 1,202 2,170 16,194 1,506 656 1,782 1,640 520 1,805 Pu Accrued salaries and related expenses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term debt Other accrued expenses Total current liabilities Long-term debt, excluding current installments Deferred income taxes Other long-term liabilities Total liabilities 1,056 2,611 16,716 26.807 491 1,867 45,881 1,202 2.170 16.194 24,267 440 2,174 43,075 89 Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,782 at February 3, 2019 and 1,780 shares at January 28, 2018; outstanding: 1,105 shares at February 3, 2019 and 1,158 shares at January 28, 2018 Paid-in capital Retained earnings Accumulated other comprehensive loss Treasury stock, at cost, 677 shares at February 3, 2019 and 622 shares at January 28, 2018 Total stockholders' (deficit) equity Total liabilities and stockholders' equity 89 10,578 46,423 (772) 10,192 39,935 (566) (58,196) (1,878) 44,003 $ (48,196) 1,454 44,529 $ Fiscal 2017 100,904 66,548 34,356 $ Fiscal 2016 94,595 62,282 32,313 17,864 1,811 17,132 1,754 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal in millions, except per share data 2018 Net sales 108,203 $ Cost of sales 71,043 Gross profit 37,160 Operating expenses: Selling, general and administrative 19,513 Depreciation and amortization 1,870 Impairment loss 247 Total operating expenses 21,630 Operating income 15,530 Interest and other (income) expense: Interest and investment income (93) Interest expense 1,051 Other Interest and other, net 974 Earnings before provision for income taxes 14,556 Provision for income taxes 3,435 Net earnings $ 11,121 $ 18.886 19,675 14,681 13,427 (74) (36) 972 1,057 16 983 13,698 5,068 8,630 936 12,491 4,534 7,957 $ Basic weighted average common shares Basic earnings per share 1,137 9.78 1,1781 7.33 $ ,229 6.47 $ 1 Diluted weighted average common shares Diluted earnings per share 1,143 9.73 $ 1,184 7.29 $ ,234 6.45 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal 2018 11,121 $ Fiscal 2017 Fiscal 2016 $ 8,630 $ 7,957 (267) in millions Net earnings Other comprehensive (loss) income: Foreign currency translation adjustments Cash flow hedges, net of tax Other Total other comprehensive (loss) income Comprehensive income 53 8 (206) 10,915 311 (1) (9) 301 8,931 $ 31 $ $ 7,988 wiew.usy.eu/21/e/content/1927281/viewcontent/28554875/View | THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY Fiscal 2018 Fiscal 2017 Fiscal 2016 in millions Common Stock: Balance at beginning of year Shares issued under employee stock plans Balance at end of year 89 $ 88 88 89 10,192 104 9,347 9,787 132 Paid-in Capital: Balance at beginning of year Shares issued under employee stock plans Tax effect of stock-based compensation Stock-based compensation expense Balance at end of year 97 282 10,578 273 10,192 267 9,787 39,935 35,519 30,973 Retained Earnings: Balance at beginning of year Cumulative effect of accounting change Net earnings Cash dividends Other Balance at end of year 11,121 (4,704) 7,957 (3,404) 8,630 (4,212) (2) 39,935 46,423 35,519 (867) (898) Accumulated Other Comprehensive Income (Loss): Balance at beginning of year Foreign currency translation adjustments Cash flow hedges, net of tax Other (566) (267) 53 311 9 35,519 3 0,973 Retained Earnings: Balance at beginning of year Cumulative effect of accounting change Net earnings Cash dividends Other Balance at end of year 39,935 75 11,121 (4,704) (4) 46,423 8,630 (4,212) (2) 39,935 7,957 (3,404) (7) 35,519 (898) Accumulated Other Comprehensive Income (Loss): Balance at beginning of year Foreign currency translation adjustments Cash flow hedges, net of tax Other Balance at end of year (566) (267) 53 (867) 311 (1) (9) (772) (566) (867) Treasury Stock: Balance at beginning of year Repurchases of common stock Balance at end of year Total stockholders' (deficit) equity (48,196) (10,000) (58,196) (1,878) $ (40,194) (8,002) (48,196) 1.454 $ (33,194) (7,000) (40,194) 4,333 $ InC NUNC UCRUI, IVU. CONSOLIDATED STATEMENTS OF CASH FLOWS . Fiscal 2018 Fiscal 2017 Fiscal 2016 $ 11,121 $ 8,630 $ 7,957 ti 2,062 1,973 267 " in millions Cash Flows from Operating Activities: Net earnings Reconciliation of net earnings to net cash provided by operating activities: Depreciation and amortization Stock-based compensation expense Impairment loss Changes in receivables, net Changes in merchandise inventories Changes in other current assets Changes in accounts payable and accrued expenses Changes in deferred revenue Changes in income taxes payable Changes in deferred income taxes Other operating activities Net cash provided by operating activities 139 (84) (10) (138) (769) (48) 446 352 80 128 29 92 420 12,031 109 (117) 26 (103) 13,038 (2,442) (1,621) (1,897) (374) Cash Flows from Investing Activities: Capital expenditures, net of non-cash capital expenditures Payments for businesses acquired, net Proceeds from sales of property and equipment Other investing activities Net cash used in investing activities 47 14 (2,416) (2,228) (1,583) (374) 4738 Payments for businesses acquired, net Proceeds from sales of property and equipment Other investing activities Net cash used in investing activities 33 14 (4) (2,416) (2,228) (1,583) (9,963) Cash Flows from Financing Activities: (Repayments of) proceeds from short-term debt, net Proceeds from long-term debt, net of discounts Repayments of long-term debt Repurchases of common stock Proceeds from sales of common stock Cash dividends Other financing activities Net cash used in financing activities Change in cash and cash equivalents Effect of exchange rate changes on cash and cash equivalents Cash and cash equivalents at beginning of year Cash and cash equivalents at end of year (220) 3,4662 ,991 4,959 (1,209) (543) (3,045) (8,000) 236255218 (4,704) (4,212) (3,404) (26) (211) (78) (12,420) (8,870) (7.870) (1,798) 933 330 (19) 124 (8) 3,595 2 ,538 2,216 1.778 $ 3,595 $ 2,538 $ Supplemental Disclosures: Cash paid for income taxes Cash paid for interest, net of interest capitalized Non-cash capital expenditures 3,774 $ 1,035 248 4,732 $ 9 91 150 4,623 924 in millions Card receivables Rebate receivables Customer receivables Other receivables Receivables, net February 3, 696 660 284 296 1,936 January 28, $ 734 609 261 348 $ 1,952

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

Accounting Information Systems

Authors: Steven M. Bragg

2nd Edition

164221079X, 9781642210798

More Books

Students also viewed these Accounting questions

Question

What is JMS?

Answered: 1 week ago