Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 January 30, 2022 January 31, 2021 $ 2,343 $ 7,895 3,426 2,992 22,068 16,627 1,218 963 29,055 28,477 25,199 24,705 5,968 5,962 7,449 7,126 4,205 4,311 71,876 $ 70,581 Liabilities and Stockholders' Equity Current liabilities: Short-term debt $ 1,035 $ Accounts payable 13,462 11,606 Accrued salaries and related expenses 2,426 2,463 Sales taxes payable 848 774 Deferred revenue 3,596 2.823 Income taxes payable 158 193 Current installments of long-term debt 2,447 1,416 Current operating lease liabilities 830 828 Other accrued expenses 3,891 3,063 Total current liabilities 28,693 23,166 Long-term debt, excluding current installments 36.604 35,822 Long-term operating lease liabilities 5,353 5,356 Deferred income taxes: 909 1.131 Other long-term liabilities Total liabilities 2.013 1,807 73,572 67,282 Common stock, par value $0.05; authorized: 10,000 shares; issued: 1,792 shares at January 30, 2022 and 1,789 shares at January 31, 2021; outstanding: 1,035 shares at January 30, 2022 and 1,077 shares at January 31, 2021 Paid-in capital Retained eamings Accumulated other comprehensive loss Treasury stock, at cost, 757 shares at January 30, 2022 and 712 shares at January 31, 2021 Total stockholders' (deficit) equity Total liabilities and stockholders' equity 90 89 12,132 11,540 67,580 58,134 (704) (671) (80,794) (65,793) (1,696) 3,299 $ 71,876 $ 70,581 THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Fiscal Fiscal In millions, except per share data 2021 2020 2019 Net sales Cost of sales Gross profit Operating expenses: Selling, general and administrative Depreciation and amortization Total operating expenses Operating income Interest and other (income) expense: Interest and investment income Interest expense Interest and other, net 151,157 $ 132,110 $ 110,225 100,325 87,257 72,653 50,832 44,853 37,572 25,406 24,447 19,740 2,386 2,128 1,989 27,792 26,575 21,729 23,040 18,278 15,843 (44) (47) (73) 1,347 1,347 1,201 1,303 1,300 1,128 Earnings before provision for income taxes 21,737 16,978 14,715. Provision for income taxes 5,304 4,112 3,473 Net earnings S 16,433 $ 12,866 $ 11.242 Basic weighted average common shares 1,054 1,074 1,093 Basic earnings per share $ 15.59 $ 11.98 $ 10.29 Diluted weighted average common shares 1,058 1,078 1,097 Diluted earnings per share $ 15.53 $ 11.94 $ 10.25 in millions THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME Net earnings Other comprehensive (loss) income, net of tax: Foreign currency translation adjustments Cash flow hedges Other Total other comprehensive (loss) income, net of tax Comprehensive income See accompanying notes to consolidated financial statements Fiscal 2021 Fiscal Fiscal 2020 2019 16,433 $ 12,866 $ 11,242 (77) 60 53 9 8 8 35 3 (33) 68 64 16,400 $ 12,934 $ 11,306 In millions THE HOME DEPOT, INC. CONSOLIDATED STATEMENTS OF STOCKHOLDERS' EQUITY Fiscal 2021 Fiscal Fiscal 2020 2019 Common Stock: Balance at beginning of year Shares issued under employee stock plans Balance at end of year 89 $ 89 $ 89 1 90 89 89 Paid-in Capital: Balance at beginning of year 11,540 11,001 10,578 Shares issued under employee stock plans 194 229 172 Stock-based compensation expense 398 310 251 Balance at end of year 12,132 11,540 11,001 Retained Earnings: Balance at beginning of year 58,134 51,729 46,423 Cumulative effect of accounting changes 26 Net earnings 16,433 12,866 11,242 Cash dividends (6,985) (6,451) (5,958) Other (2) (10) (4) Balance at end of year 67,580 58,134 51,729 Accumulated Other Comprehensive Loss: Balance at beginning of year Cumulative effect of accounting changes Foreign currency translation adjustments, net of tax Cash flow hedges, net of tax Other, net of tax Balance at end of year Treasury Stock: Balance at beginning of year (671) (739) (772) (31) E (77) 60 53 9 8 8 35 3 (704) (671) (739) (65,793) (65,196) (58,196) Repurchases of common stock (15.001) Balance at end of year (80,794) (597) (65,793) (7.000) (65,196) Total stockholders' (deficit) equity $ (1.696) $ 3,299 $ (3.116) CONSOLIDATED STATEMENTS OF CASH FLOWS In millions Fiscal 2021 Fiscal 2020 Fiscal 2019 Cash Flows from Operating Activities: Net earnings $ 16,433 $ 12,866 $ 11,242 Reconciliation of net earnings to net cash provided by operating activities: Depreciation and amortization 2,862 2,519 2,296 Stock-based compensation expense 399 310 251 Changes in receivables, net (435) (465) (170) Changes in merchandise inventories (5,403) (1,657) (593) Changes in other current assets (330) 43 (135) Changes in accounts payable and accrued expenses 2,401 5,118 32 Changes in deferred revenue 775 702 334 Changes in income taxes payable (51) (149) 44 Changes in deferred income taxes (276) (569) 202 Other operating activities 196 121 184 Net cash provided by operating activities 16,571 18,839 13,687 Cash Flows from Investing Activities: Capital expenditures Payments for businesses acquired, net Other investing activities Net cash used in investing activities (2.566) (2.463) (2,678) (421) (7,780) 18 73 25 (2,969) (10,170) (2.653) Cash Flows from Financing Activities: Proceeds from (repayments of) short-term debt, net 1,035 (974) (365) Proceeds from long-term debt, net of discounts and premiums 2,979 7.935 3,420 Repayments of long-term debt (1,532) (2,872) (1,070) Repurchases of common stock (14,809) (791) (6,965) Proceeds from sales of common stock 337 326 280 Cash dividends. (6.985) (6,451) (5.958) Other financing activities (145) (154) 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 $ 2,343 $ 7,895 $ 2,133 (19.120) (2.983) (140) (10,798) (5,518) 5,686 236 (34) 7,895 76 119 2.133 1.778 Supplemental Disclosures: Cash paid for income taxes 5,504 4,654 $ 3,220 Cash paid for interest, net of interest capitalized 1,269 1,241 1,112 Non-cash capital expenditures 421 274 136 Refer to the 10-K for The Home Depot. Required: 1. What does the company report for the following accounts for the most current fiscal year: Enter your answer in millions. If an amount is zero, enter "0". a. Cash b. Short-term investments (or marketable securities) 2,343 c. Accounts receivable d. Inventory e. Other current assets 3,426 22,068 1,218 f. Accounts payable 13,462 g. Other current liabilities 15,231 h. Cash flow from operations 2. The company projects the following to occur in the next fiscal year: Accounts payable will increase by 2%. Other current liabilities are expected to increase by 2%. Cash flow from operations is expected to increase by 6%. Assume all other items remain unchanged from the prior year. Provide the next year's forecasted balances for the following accounts and cash flow from operations. Round your answer to the nearest million. If an amount is zero, enter "0". a. Cash b. Short-term investments (or marketable securities) c. Accounts receivable d. Inventory e. Other current assets f. Accounts payable g. Other current liabilities h. Cash flow from operations 3. Compute the forecasted current ratio for the next fiscal year. Round your answer to two decimal places. 4. Compute the forecasted quick ratio for the next fiscal year. Round your answer to two decimal places. 5. Compute the forecasted cash ratio for the next fiscal year. Round your answer to two decimal places. 6. Compute the forecasted operating cash flow ratio for the next fiscal year. Round your answer to two decimal places
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