Using the financial information presented in Exhibit 13.1, calculate the following ratios for fiscol 2017 for The Home Depot: (Do not round your intermediate calculations and round your answers to 2 decimal places. Round your percentage answers to 2 decimal places. ( (.e., 0.1234 should be entered as 12.34).) THE HOME DEPOT, INC. Earnings before Provision for Income Taxes Provision for Income Taxes Net Earnings Basic Weighted Average Common Shares Basic Earnings per Share Diluted Weighted Average Common Shares Diluted Earnings per Share THE HOME DEPOT, INC. Consolidated Balance Sheets (amounts in millions, except per share data) \begin{tabular}{|lrr|} \hline & End of Fiscal 2017 & End of Fiscal 2016 \\ & & \\ & & \\ \hline Assets & 3,595 & $2,538 \\ Current Assets: & 1,952 & 2,029 \\ Cash and Cash Equivalents & 12,748 & 12,549 \\ Receivables, net & 638 & 608 \\ \cline { 2 - 4 } Merchandise Inventories & 18.933 & 17,724 \\ Other Current Assets & & \\ Total Current Assets & & \\ \hline \end{tabular} Goodwill Other Assets Total Assets Liabilities and Stockholders' Equity Current Liabilities: Stockholders' Equity Common Stock, par value $0.05; authorized: 10,000 shares; issued: 1,776 at January 29, 2017 Paid-In Capital Retained Earnings 10,19239,935(566)9.78735,519(867) Accumulated Other Comprehensive Loss Treasury Stock, at cost, 622 shares at January 28,2018 , and 573 shares at January 29, 2017 Total Stockholders' Equity Total Liabilities and \begin{tabular}{ll} 1,454(48,196) & 4,333(40,194) \\ \( \hdashline \mathbf{\$ 4 4 , 5 2 9} \) & $42,966 \\ \hline \end{tabular} Stockholders' Equity THE HOME DEPOT, INC. Consolidated Statements of Cash Flows (amounts in millions) Cash Flows from Operating Activities: Net Earnings $8,630$7,957$7,009 Reconciliation of Net Earnings to Net Cash Activities: Depreciation and 2,0621,9731,863 Amortization Stock-Based 273 267 244 Compensation Expense Gain on Sales of (144) Investments Changes in Assets and Liabilities, net of the effects of acquisitions: Receivables, net 139 (138) (181) Merchandise Inventories (84) (769) (546) Other Current Assets (10) (48) (5) Accounts Payable and 352 888 Accrued Expenses Operating Activities Cash Flows from Investing Activities: Activities: Capital Expenditures, net of non-cash capital expenditures (1,897)(1.621)(1.503)144 Proceeds from Sales of Investments Payments for Businesses (374) (1,666) Acquired, net Proceeds from Sales of \begin{tabular}{rrr} 47 & 38 & 43 \\ \hline (4) & \\ \hline(2,228) & 1,583) & \\ \hline \end{tabular} Other Investing Activities Net Cash Used in Investing Activities Cash Flows from Financing Activities: Proceeds from Short-Term 8502,9913604,959603,991 Proceeds from Long-Term Debt, net of discount Repayments of Long-Term (543) (3,045) (39) Debt Repurchases of Common (8,000)(6,880) (7,000) Stock Proceeds from Sales of 255 218 228 RepurchasesofCommonStock(8,000)(6,880)(7,000)
