Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this is my second time posting this question. it has not been answered for the past 3 days. please answer this question. please calculate ALL
this is my second time posting this question. it has not been answered for the past 3 days. please answer this question.
Table of Contents THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3 2010 February 2 2020 $ 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 Operating lease right-of-use assets Goodwill Other assets Total assets 2,133 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 51.236 $ 1,778 1,936 13,925 890 18,529 22,375 2,252 847 44,003 $ $ 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 Current operating lease liabilities Other accrued expenses Total current liabilities Long-term debt excluding current installments Long-term operating lease liabilities Deferred income taxes Other long-term liabilities Total liabilities 1,339 7.755 1.506 656 1,782 11 1,056 974 7,787 1,494 605 2,116 55 1.839 828 2,677 18,375 28,670 5,066 706 1.535 54,352 2,611 16.716 28,807 491 1,867 45,881 Common stock, par value $0.05 authorized: 10.000 shares; issued: 1,786 shares at February 2, 2020 and 1,782 shares at February 3, 2019, outstanding 1,077 shares at February 2, 2020 and 1,105 shares at February 3, 2019 Paid-in capital Retained eamings Accumulated other comprehensive loss Treasury stock, at cost. 709 shares at February 2, 2020 and 677 shares at February 3, 2019 Total stockholders' (deficit) equity Total liabilities and stockholders' equity 89 11,001 51,729 (739) (65.196) (3,116) 51,236 $ 89 10.578 46,423 (772) (58.196) (1.878) 44,003 See accompanying notes to consolidated financial statements Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal 2018 Fiscal 2010 110.225 72.653 37,572 $ $ 108 203 71,043 37. 180 Fiscal 2017 100.904 66,548 34 356 19,740 1.989 17,804 1.811 In millions, except per share data Net sales Cost of sales Gross profit Operating expenses: Selling general and administrative Depreciation and amortization Impairmentloos Total operating expenses Operating income Interest and other income) expenses Interest and investment income Interest expense Other Interest and other net Earnings before provision for income taxes Provision for income taxes Net earnings 19.513 1,870 247 21.630 15,530 21,720 15,843 19.675 14,681 193) 174) 173) 1,201 1,057 1,128 14,715 3.473 11,242 1.051 15 974 14,556 3.435 11.121 983 13,898 5.068 8.630 $ 1,000 10.20 1,137 9.78 5 1.178 733 Basic weighted average common shares Basic earning per sham Diluted weighted average common shares Diluted earnings per share 1.097 10.25 1.143 9.73 1,184 720 $ 5 Fiscal 2019 and focal 2017 nude wok 2018 weeks Sowonge o condott Tala Catai THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS Fiscal Fisca 2019 Fiscal 2018 2017 O 8.630 11.2425 11.121 $ 2.296 251 2062 273 2,152 282 247 33 (1.244) (257) Cash Flows from Operating Activities: Net Garnings Reconciliation of net eamings to net cash provided by operating activities: Depreclion and amortization Stock band compensation expense Impairment loss Changes in receivables, net Changes in merchandise inventores Changes in the current assets Changes in accounts payable and accrued expenses Changes in deferred revenue Changes in income taxes payable Changes in deferred income fares Other operating activities Net cash provided by operating activities Cash Flows from investing Activities: Capital expenditures Payments for businesses acquired, net Proceeds from wes of property and equipment One invessing activities Nel cash used in investing activities (170) (593) (135) 68 334 44 202 184 13.723 743 80 (42) 26 (103) 13,038 139 (84) (10) 352 128 29 92 420 12,031 (2.678) 37 (12) (2.653) (2.442) (21) 33 14 12.416) (1.897) (374) 47 (4) (2 228) Cash Flows from Financing Activities: (Repayments of proceeds from short-term debt net Proceeds from long term debt net of discounts and premium Repayments of long term debe Repurchases of common stock Proceeds from sales of common stock Cash dividends Other financing advies Net cath used in financing activ Change in cash and cash equivalents Effect of exchange rate changes on cash and cash equivalents Cash and cash equivalents a beginning of year Cath and cash quvlarts at end of year Supplemental Disclosures Cash paid for income taxes Cash paid for interest net of interest capitalized Non-cash croita ependitures (365) 3.420 (1.070) (6,965) 280 (5.958) (178) (10,83) 238 119 1,778 2.133 (220) 3,466 (1.209) (9,963) 236 (4.704) (26) (12,420) (1.798) (19) 3,595 1,778 5 850 2.991 (543) (8,000) 255 (4.212) (211) (8.870) 933 124 2538 3.595 $ 3.220 1,112 $ 4,732 3,774 1,035 248 991 136 150 2019 and 2017 dec 2018 de Ser conto consolidated francaments THE HOME DEPOT.INC CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY Common Stock Balance at beginning of year Shares issued under employee stock plans Balance at end of year ca 2013 2018 2017 89 $ 89 1 89 Paid in Capital Balance at beginning of year Shares insed under er ployee stock plans Stock-based compensation expense Balance at end of year 10.578 172 250 11.001 10.192 104 282 10:57 9.787 132 273 10.192 Retained Earnings: Balance at beginning of year Cumulative effect of accounting changes Net earnings Cash dividends Other Balance at end of year 35519 20 11.242 (5.958) 44) 51,729 30.935 75 11.121 14.704) (4) 46423 6.630 4212 12) 30.935 Accumulated Other Comprehensive Income (L08): Balance at beginning of year Cumulative tect of accounting changes Foreign currency translation adjustments Cash flow hedges, net of tax Other Balance at end of year (564) (867) (772) (31) 53 8 3 739 (267) 311 (1) 8 (772) 1566) Treasury Stock Balance at beginning of year Repurchases of common stock Bance at end of year Total stockholders' deficit) quity Faww 2017 chalewa wote wa Se compagnemend trend (58.100) (7,000 (65,196) 13.150) 5 (48 196) (10.000) (58196) 11.870) 5 (40.194) (8.002) (48.100) 1454 5 Table of Contents THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3 2010 February 2 2020 $ 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 Operating lease right-of-use assets Goodwill Other assets Total assets 2,133 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 51.236 $ 1,778 1,936 13,925 890 18,529 22,375 2,252 847 44,003 $ $ 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 Current operating lease liabilities Other accrued expenses Total current liabilities Long-term debt excluding current installments Long-term operating lease liabilities Deferred income taxes Other long-term liabilities Total liabilities 1,339 7.755 1.506 656 1,782 11 1,056 974 7,787 1,494 605 2,116 55 1.839 828 2,677 18,375 28,670 5,066 706 1.535 54,352 2,611 16.716 28,807 491 1,867 45,881 Common stock, par value $0.05 authorized: 10.000 shares; issued: 1,786 shares at February 2, 2020 and 1,782 shares at February 3, 2019, outstanding 1,077 shares at February 2, 2020 and 1,105 shares at February 3, 2019 Paid-in capital Retained eamings Accumulated other comprehensive loss Treasury stock, at cost. 709 shares at February 2, 2020 and 677 shares at February 3, 2019 Total stockholders' (deficit) equity Total liabilities and stockholders' equity 89 11,001 51,729 (739) (65.196) (3,116) 51,236 $ 89 10.578 46,423 (772) (58.196) (1.878) 44,003 See accompanying notes to consolidated financial statements Table of Contents THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal 2018 Fiscal 2010 110.225 72.653 37,572 $ $ 108 203 71,043 37. 180 Fiscal 2017 100.904 66,548 34 356 19,740 1.989 17,804 1.811 In millions, except per share data Net sales Cost of sales Gross profit Operating expenses: Selling general and administrative Depreciation and amortization Impairmentloos Total operating expenses Operating income Interest and other income) expenses Interest and investment income Interest expense Other Interest and other net Earnings before provision for income taxes Provision for income taxes Net earnings 19.513 1,870 247 21.630 15,530 21,720 15,843 19.675 14,681 193) 174) 173) 1,201 1,057 1,128 14,715 3.473 11,242 1.051 15 974 14,556 3.435 11.121 983 13,898 5.068 8.630 $ 1,000 10.20 1,137 9.78 5 1.178 733 Basic weighted average common shares Basic earning per sham Diluted weighted average common shares Diluted earnings per share 1.097 10.25 1.143 9.73 1,184 720 $ 5 Fiscal 2019 and focal 2017 nude wok 2018 weeks Sowonge o condott Tala Catai THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF CASH FLOWS Fiscal Fisca 2019 Fiscal 2018 2017 O 8.630 11.2425 11.121 $ 2.296 251 2062 273 2,152 282 247 33 (1.244) (257) Cash Flows from Operating Activities: Net Garnings Reconciliation of net eamings to net cash provided by operating activities: Depreclion and amortization Stock band compensation expense Impairment loss Changes in receivables, net Changes in merchandise inventores Changes in the current assets Changes in accounts payable and accrued expenses Changes in deferred revenue Changes in income taxes payable Changes in deferred income fares Other operating activities Net cash provided by operating activities Cash Flows from investing Activities: Capital expenditures Payments for businesses acquired, net Proceeds from wes of property and equipment One invessing activities Nel cash used in investing activities (170) (593) (135) 68 334 44 202 184 13.723 743 80 (42) 26 (103) 13,038 139 (84) (10) 352 128 29 92 420 12,031 (2.678) 37 (12) (2.653) (2.442) (21) 33 14 12.416) (1.897) (374) 47 (4) (2 228) Cash Flows from Financing Activities: (Repayments of proceeds from short-term debt net Proceeds from long term debt net of discounts and premium Repayments of long term debe Repurchases of common stock Proceeds from sales of common stock Cash dividends Other financing advies Net cath used in financing activ Change in cash and cash equivalents Effect of exchange rate changes on cash and cash equivalents Cash and cash equivalents a beginning of year Cath and cash quvlarts at end of year Supplemental Disclosures Cash paid for income taxes Cash paid for interest net of interest capitalized Non-cash croita ependitures (365) 3.420 (1.070) (6,965) 280 (5.958) (178) (10,83) 238 119 1,778 2.133 (220) 3,466 (1.209) (9,963) 236 (4.704) (26) (12,420) (1.798) (19) 3,595 1,778 5 850 2.991 (543) (8,000) 255 (4.212) (211) (8.870) 933 124 2538 3.595 $ 3.220 1,112 $ 4,732 3,774 1,035 248 991 136 150 2019 and 2017 dec 2018 de Ser conto consolidated francaments THE HOME DEPOT.INC CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY Common Stock Balance at beginning of year Shares issued under employee stock plans Balance at end of year ca 2013 2018 2017 89 $ 89 1 89 Paid in Capital Balance at beginning of year Shares insed under er ployee stock plans Stock-based compensation expense Balance at end of year 10.578 172 250 11.001 10.192 104 282 10:57 9.787 132 273 10.192 Retained Earnings: Balance at beginning of year Cumulative effect of accounting changes Net earnings Cash dividends Other Balance at end of year 35519 20 11.242 (5.958) 44) 51,729 30.935 75 11.121 14.704) (4) 46423 6.630 4212 12) 30.935 Accumulated Other Comprehensive Income (L08): Balance at beginning of year Cumulative tect of accounting changes Foreign currency translation adjustments Cash flow hedges, net of tax Other Balance at end of year (564) (867) (772) (31) 53 8 3 739 (267) 311 (1) 8 (772) 1566) Treasury Stock Balance at beginning of year Repurchases of common stock Bance at end of year Total stockholders' deficit) quity Faww 2017 chalewa wote wa Se compagnemend trend (58.100) (7,000 (65,196) 13.150) 5 (48 196) (10.000) (58196) 11.870) 5 (40.194) (8.002) (48.100) 1454 5 please calculate ALL Financial statement ratios for the Home Depot. two years when possible
Step 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