Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table of Contents in millions, except per share data Assets Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Table of Contents 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 THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3, 2019 January 28, 2018 $ 1,778 $ 1,936 3,595 1,952 13,925 12,748 890 638 18,529 18,933 22,375 22,075 2,252 2,275 847 1,246 $ 44,003 $ 44,529 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 1,339 $ 1,559 7,755 7,244 1,506 1,640 656 520 1,782 1,805 11 54 1,056 1,202 2,611 2,170 Total current liabilities 16,716 16,194 Long-term debt, excluding current installments 26,807 24,267 Deferred income taxes 491 440 Other long-term liabilities 1,867 2,174 Total liabilities 45,881 43,075 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 89 89 Paid-in capital 10,578 10,192 Retained earnings 46,423 39,935 Accumulated other comprehensive loss (772) (566) Treasury stock, at cost, 677 shares at February 3, 2019 and 622 shares at January 28, 2018 (58,196) (48,196) Total stockholders' (deficit) equity (1,878) $ 44,003 $ 1,454 44,529 Total liabilities and stockholders' equity See accompanying notes to consolidated financial statements. 31 Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS in millions, except per share data Net sales Fiscal 2018 Fiscal 2017 Fiscal 2016 $ 108,203 $ 100,904 $ 94,595 Cost of sales Gross profit Operating expenses: Selling, general and administrative Depreciation and amortization 71,043 66,548 62,282 37,160 34,356 32,313 19,513 17,864 17,132 1,870 1,811 1,754 Impairment loss 247 Total operating expenses 21,630 19,675 18,886 Operating income 15,530 14,681 13,427 Interest and other (income) expense: Interest and investment income (93) (74) (36) Interest expense 1,051 1,057 972 Other 16 - - Interest and other, net 974 983 936 Earnings before provision for income taxes 14,556 13,698 12,491 Provision for income taxes 3,435 5,068 4,534 Net earnings $ 11,121 $ 8,630 $ 7,957 Basic weighted average common shares 1,137 1,178 1,229 Basic earnings per share $ 9.78 $ 7.33 $ 6.47 Diluted weighted average common shares 1,143 1,184 1,234 Diluted earnings per share $ 9.73 $ 7.29 $ 6.45 Fiscal 2018 includes 53 weeks. Fiscal 2017 and fiscal 2016 include 52 weeks. See accompanying notes to consolidated financial statements. 32 Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal in millions 2018 Fiscal 2017 Fiscal 2016 Net earnings $ 11,121 $ 8,630 $ 7,957 Other comprehensive (loss) income: Foreign currency translation adjustments (267) 311 (3) Cash flow hedges, net of tax 53 (1) 34 Other 8 (9) Total other comprehensive (loss) income (206) 301 31 Comprehensive income $ 10,915 $ 8,931 $ 7,988 Fiscal 2018 includes 53 weeks. Fiscal 2017 and fiscal 2016 include 52 weeks. See accompanying notes to consolidated financial statements. 33 Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY in millions Fiscal 2018 Fiscal 2017 Fiscal 2016 Common Stock: Balance at beginning of year $ 89 $ 88 $ 88 Shares issued under employee stock plans 1 Balance at end of year 89 89 88 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 10,192 9,787 9,347 104 132 76 97 282 273 267 10,578 10,192 9,787 Retained Earnings: Balance at beginning of year 39,935 35,519 30,973 Cumulative effect of accounting change 75 Net earnings 11,121 8,630 7,957 Cash dividends (4,704) (4,212) (3,404) Other (4) (2) (7) Balance at end of year 46,423 39,935 35,519 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 Treasury Stock: Balance at beginning of year Repurchases of common stock Balance at end of year Total stockholders' (deficit) equity Fiscal 2018 includes 53 weeks. Fiscal 2017 and fiscal 2016 include 52 weeks. See accompanying notes to consolidated financial statements. 34 (566) (867) (898) (267) 311 (3) 53 (1) 34 8 (9) - (772) (566) (867) (48,196) (40,194) (33,194) (10,000) (8,002) (7,000) (58,196) (48,196) (40,194) $ (1,878) $ 1,454 $ 4,333 Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS in millions Fiscal 2018 Fiscal 2017 Fiscal 2016 Cash Flows from Operating Activities: Net earnings $ 11,121 $ 8,630 $ 7,957 Reconciliation of net earnings to net cash provided by operating activities: Depreciation and amortization 2,152 2,062 1,973 Stock-based compensation expense 282 273 267 Impairment loss 247 - Changes in receivables, net 33 139 (138) Changes in merchandise inventories (1,244) (84) (769) Changes in other current assets (257) (10) (48) Changes in accounts payable and accrued expenses 743 352 446 Changes in deferred revenue 80 128 99 Changes in income taxes payable (42) 29 109 Changes in deferred income taxes 26 92 (117) Other operating activities (103) 420 Net cash provided by operating activities 13,038 12,031 9,783 Cash Flows from Investing Activities: Capital expenditures, net of non-cash capital expenditures (2,442) (1,897) (1,621) Payments for businesses acquired, net (21) (374) Proceeds from sales of property and equipment 33 47 38 Other investing activities 14 (4) Net cash used in investing activities (2,416) (2,228) (1,583) Cash Flows from Financing Activities: (Repayments of) proceeds from short-term debt, net (220) 850 360 Proceeds from long-term debt, net of discounts 3,466 2,991 4,959 Repayments of long-term debt (1,209) (543) (3,045) Repurchases of common stock (9,963) (8,000) (6,880) Proceeds from sales of common stock 236 255 218 Cash dividends (4,704) (4,212) (3,404) Other financing activities Net cash used in financing activities (26) (12,420) (211) (8,870) (78) (7,870) Change in cash and cash equivalents (1,798) 933 330 Effect of exchange rate changes on cash and cash equivalents (19) 124 (8) Cash and cash equivalents at beginning of year 3,595 2,538 2,216 Cash and cash equivalents at end of year $ 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 4,732 $ 4,623 1,035 991 924 248 150 179 Fiscal 2018 includes 53 weeks. Fiscal 2017 and fiscal 2016 include 52 weeks. See accompanying notes to consolidated financial statements. 35 D Question 13 Ratio Analysis 6 pts Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last two fiscal years and indicate whether they are getting better or worse: 9) Operating Profit Margin (%) FYE 1/28/18 % 200 FYE 2/3/19 Better/Worse % Please use two decimal points for your final answers.

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

Understanding financial statements

Authors: Lyn M. Fraser, Aileen Ormiston

9th Edition

136086241, 978-0136086246

More Books

Students also viewed these Finance questions