Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the financial information presented in Exhibit 13.1, calculate the following ratios for The Home Depot: (Round your answers to 2 decimal places.) Return on
Using the financial information presented in Exhibit 13.1, calculate the following ratios for The Home Depot: (Round your answers to 2 decimal places.)
Return on equity Return on assets Total asset turnover Inventory turnover Current ratio Quick ratio Cash coverage ratio Debt-to-equity ratio THE HOME DEPOT, INC., AND SUBSIDIARIES Consolidated Statements of Earnings (amounts in millions, except per share data) Fiscal Year Ended February 1, February 2, February 3, 2015 2014 2013 Net Sales $ 83,176 $ 78,812 $74,754 Cost of Sales 54.222 51,422 48.912 Gross Profit 28,954 27,390 25.842 Operating Expenses: Selling, General and 16,834 16,597 16,508 Administrative Depreciation and 1,651 1.627 Amortization 1.568 Total Operating 18,485 18,224 18.076 Expenses Operating Income 10,469 9,166 7,766 Interest and Other (Income) Expense: Interest and Investment (337) (12) (20) Income Interest Expense 830 711 632 Other - = Interest and Other, net _493 699 545 Earnings before Provision for Income Taxes 9,976 8,467 7.221 Provision for Income Taxes 3,631 3,082 2.686 Net Earnings $ 6,345 $ 5,385 $ 4,535 Weighted Average Common 1,338 1.425 1,499 Shares Basic Earnings per Share $ 4.74 $ 3.78 $ 3.03 Diluted Weighted Average 1,346 1,434 1,511 Common Shares Diluted Earnings per Share $ 4.71 $ 3.76 $ 3.00 - (67) 88 88 STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 billion shares, issued: 1.768 billion shares at February 1, 2015, and 1.761 billion shares at February 2, 2014; outstanding: 1.307 billion shares at February 1, 2015, and 1.380 billion shares at February 2, 2014 Paid-In Capital Retained Earnings Accumulated Other Comprehensive (Loss) Income Treasury Stock, at cost, 461 million shares at February 1, 2015, and 381 million shares at February 2, 2014 Total Stockholders' Equity Total Liabilities and Stockholders' Equity 8,885 26,995 (452) 8,402 23,180 46 (26,194) (19.194) 9.322 $ 39,946 12.522 $ 40.518 THE HOME DEPOT, INC., AND SUBSIDIARIES Consolidated Statements of Cash Flows (amounts in millions) Fiscal Year Ended February 1, February 2, February 3, 2015 2014 2013 CASH FLOWS FROM OPERATING ACTIVITIES: Net Earnings $ 6,345 $5,385 $4,535 Reconciliation of Net Earnings to Net Cash Provided by Operating Activities: Depreciation and 1,786 1,757 Amortization Stock-Based Compensation 225 Expense Gain on Sales of Investments (323) Goodwill Impairment Changes in Assets and Liabilities, net of the effects of acquisitions: Receivables, net $ (81) $ (15) $ (143) $ $ $ (143) (350) (81) (124) (199) 244 (15) (455) (5) 605 93 698 146 75 121 168 159 119 (31) 119 107 168 87 (31) 159 (152) 107 (180) __48 13 (48) 7.628 8,242 6.975 (1,442) (1,389) (1.312) Receivables, net Merchandise Inventories Other Current Assets Accounts Payable and Accrued Expenses Deferred Revenue Income Taxes Payable Deferred Income Taxes Income Taxes Payable Deferred Income Taxes Other Long-Term Liabilities Other Net Cash Provided by Operating Activities CASH FLOWS FROM INVESTING ACTIVITIES: Capital Expenditures, net of $217, $46, and $98 of non-cash capital expenditures in fiscal 2014, 2013, and 2012, respectively Proceeds from Sales of Investments Payments for Businesses Acquired, net Proceeds from Sales of Property and Equipment Net Cash Used in Investing Activities CASH FLOWS FROM FINANCING ACTIVITIES: Proceeds from Short-Term Borrowings, net Proceeds from Long-Term Borrowings, net of discount Repayments of Long-Term Debt Repurchases of Common Stock Proceeds from Sales of Common Stock Cash Dividends Paid to 323 - - (200) (206) (170) _88 - 50 _ 48 (1,271) (1.507) (1.432) 290 1,981 5,222 (39) (1.289) (32) (7,000) 252 (8,546) 241 (3,984) 784 (2,530) (2,243) (1,743) (2,530) (2,243) (1,743) (25) (7,071) (37) (6.652) (59) (5.034) (100) (531) 509 (106) (34) (2) Cash Dividends Paid to Stockholders 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 SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR: Interest, net of interest capitalized Income Taxes 1.929 2.494 $1.929 1.987 $2,494 $1,723 $ 782 $ 639 $ 617 $3,435 $ 2,839 $ 2,482Step 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