Question
6)Ratio Analysis-Based on the financial statements of Home Depot for the fiscal year that ended February 3, 2019, calculate the following ratios for the last
6)Ratio Analysis-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: 2) Quick Ratio (x)
FYE 1/28/18 -
FYE 2/3/19 -
Better/Worse -
7)Ratio Analysis -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: 3) Inventory Turnover(x)
FYE 1/28/18 -
FYE 2/3/19 -
Better/Worse-
8) Ratio Analysis-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: 4) Days Sales Outstanding (Days)
FYE 1/28/18 -
FYE 2/3/19 -
Better/Worse -
9)Ratio Analysis -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: 5) Fixed Asset Turnover (x)
FYE 1/28/18 -
FYE 2/3/19 -
Better/Worse -
10)Ratio Analysis-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: 6) Total Asset Turnover (x)
FYE 1/28/18 -
FYE 2/3/19 -
Better/Worse -
THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3, 2019 January 28, 2018 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 $ A 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 Long-term debt, excluding current installments Deferred income taxes Other long-term liabilities Total liabilities 1,339 $ 7,755 1,506 656 1,782 11 1,056 2,611 16,716 26,807 491 1,867 45,881 1,559 7,244 1,640 520 1,805 54 1,202 2,170 16,194 24,267 440 2,174 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 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) 89 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 16 Interest and other, net 974 Earnings before provision for income taxes 14,556 Provision for income taxes 3,435 Net earnings $ 11,121 $ 19,675 14,681 18,886 13,427 (74) 1,057 (36) 972 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,178 7.33 $ 1,229 6.47 Diluted weighted average common shares Diluted earnings per share 1,143 9.73 $ 1,184 7.29 $ 1,234 6.45 $ Fiscal 2018 Fiscal 2016 7,957 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Fiscal in millions 2017 Net earnings $ 11,121 $ 8,630 $ Other comprehensive (loss) income: Foreign currency translation adjustments (267) 311 Cash flow hedges, net of tax 53 (1) Other 8 (9) Total other comprehensive (loss) income (206) 301 Comprehensive income $ 10,915 $ 8,931 $ (3) 34 31 7,988 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY Fiscal Fiscal 2017 Fiscal 2016 2018 in millions Common Stock: Balance at beginning of year Shares issued under employee stock plans Balance at end of year $ 89 $ 88 88 $ 1 89 89 88 10,192 104 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 9,347 76 97 267 9,787 282 10,578 273 10,192 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 39,935 75 11,121 (4,704) 8,630 (4,212) (2) 39,935 7,957 (3,404) (7) 35,519 46,423 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) (566) (898) (3) 34 8 (772) (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 $ Fiscal 2017 Fiscal 2016 2018 8,630 $ 7,957 2,062 273 1,973 267 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS Fiscal in millions Cash Flows from Operating Activities: Net earnings $ 11,121 $ Reconciliation of net earnings to net cash provided by operating activities: Depreciation and amortization 2,152 Stock-based compensation expense 282 Impairment loss 247 Changes in receivables, net 33 Changes in merchandise inventories (1,244) Changes in other current assets (257) Changes in accounts payable and accrued expenses 743 Changes in deferred revenue 80 Changes in income taxes payable (42) Changes in deferred income taxes 26 Other operating activities (103) Net cash provided by operating activities 13,038 139 (84) (10) 352 128 29 92 420 12,031 (138) (769) (48) 446 99 109 (117) 4 9,783 (1,621) 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 (2,442) (21) 33 (1,897) (374) 47 (4) (2,228) 38 14 (2,416) (1,583) 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,466 (1,209) (9,963) 236 (4,704) (26) (12,420) (1,798) (19) 3,595 1,778 $ 850 2,991 (543) (8,000) 255 (4,212) (211) (8,870) 933 124 2,538 3,595 $ 360 4,959 (3,045) (6,880) 218 (3,404) (78) (7,870) 330 (8) 2,216 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 $ 991 150 4,623 924 179Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started