RATIO FORMULA WORK ANSWER Current Ratio Current Assets Current Liabilities 17724 14133 1.25 Debt to Asset Net Profit Margin Asset Turnover Return on Equity Inventory Tumover Average Days to Sell Inventory Gross Profit Margin Return on Assets Earnings Per Share Google the stock price for Jan 29,2017 Accounts Receivable Turnover Average Days to Collect A/R Ratios Auditors Report and Comments Sheet1 THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Balance Sheets January 29,2017January 31, 2016 amounts in millions, except share and per share data ASSETS Current Assets "Fiscal 2016" "Fiscal 2015" 2,538 2,029 12,549 608 17,724 40,426 18,512 21,914 2,093 1,235 $42,966 Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets S 2,216 1,890 11,809 569 16,484 39,266 17,075 22,191 2,102 1,196 S41,973 Total Current Assets Property and Equipment, at cost Less Accumulated Depreciation and Amortization Net Property and Equipment Goodwill Other Assets Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: $ 710 7,000 1,484 508 1,669 25 542 2,195 14,133 22,349 1,855 296 38,633 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 $ 350 6,565 1,515 476 1,566 34 1,941 12,524 20,789 1,965 379 35.657 Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes Total Liabilities STOCKHOLDERS EQUITY Common Stock, par value S0.05; authorized: 10 billion shares; issued: 1.776 billion shares at January 29, 2017 and 1.772 billion shares at January 31, 2016; outstanding:1.203 billion shares at January 29, 2017 and 1.252 billion shares at January 31, 2016 Paid-in Capital Retained Earnings Accumulated Other Comprehensive Loss Treasury Stock, at cost, 573 million shares at January 29, 2017 and 520 million 9,787 35,519 (867) (40,194) 9,347 30,973 (898) (33,194) shares at January 31, 2016 Total Stockholders' Equity 4,333 $42,966 6,316 Total Liabilities and Stockholders' Equity $41,973 THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Earnings Fiscal Year EndedI) amounts in millions, except per share data NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Jan. 29, 2017 "Fiscal 2016" $94,595 62,282 32,313 Jan. 31, 2016 "Fiscal 2015" $88.519 58,254 30,265 Feb. 1, 2015 "Fiscal 2014" $83,176 54,787 28,389 17,132 1,754 18,886 13,427 16,801 1,690 18,491 11,774 16,280 1,640 17,920 10,469 Selling. General and Administrative Depreciation and Amortization Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense Interest and Investment Income (36) 972 936 12,491 4,534 7,957 1,229 S 6.47 1,234 S 6.45 (166) 919 753 11,021 4,012 7,009 1,277 S 5.49 1,283 S 5.46 (337) 830 493 9,976 3,631 $ 6,345 1,338 $4.74 1,346 $ 4.71 Interest Expense Interest and Other, net EARNINGS BEFORE PROVISION FOR INCOME TAXES Provision for Income Taxes NET EARNINGS Weighted Average Common Shares BASIC EARNINGS PER SHARE Diluted Weighted Average Common Shares DILUTED EARNINGS PER SHARE THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Comprehensive Income Fiscal Year Ende Jan. 29, 2017 "Fiscal 2016" "Fiscal 2015 Jan. 31, 2016 amounts in millions Net Earnings Other Comprehensive Income (Loss) Feb. 1, 2015 "Fiscal 2014' 6,345 $7,957 $7,009 Foreign Currency Translation Adjustments Cash Flow Hedges, net of tax Other (412) (34) (510) 34 31 (446) $6,563 (498) $5.847 Total Other Comprehensive Income (Loss) COMPREHENSIVE INCOME $7,988 (I) Fiscal years ended January 29, 2017, January 31, 2016, and February 1, 2015 include 52 weeks. See accompanying Notes to Comsolidated Financial Statements THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Stockholders' Equity Common Stock Accumulated Other Comprehensive Income (Loss) S 46 Treasury Paid-In Capital $8,402 Retained Earnings $23,180 Shares Amount Shares amounts in millions, except per share data Balance, February 2, 2014 Net Earnings Shares Issued Under Employee Stock Plans Tax Effect of Stock-Based Compensation Foreign Currency Translation Adjustments Cash Flow Hedges, net of tax Stock Options, Awards and Amortization of Restricted Stock Repurchases of Common Stock Cash Dividends (S1.88 per share) Other Balance, February 1, 2015 Net Earnings Shares Issued Under Employee Stock Plans Tax Effect of Stock-Based Compensation Foreign Currency Translation Adjustments Cash Flow Hedges, net of tax Stock Options, Awards and Amortization of Restricted Stock Repurchases of Common Stock Cash Dividends (S2.36 per share) Balance, January 31, 2016 Net Earnings Shares Issued Under Employee Stock Plans 1,761 $88 (381) 6.345 122 136 (510) 225 (80) (2,530) $26,995 7,009 1,768 $88 $8,885 $(452) (461) 73 145 (412) (34) 244 (59) (3,031) $30,973 7,957 1,772 $88 $9,347 $(898) (520) 76 Stock Options, Awards and Amortization of Restricted Stock Repurchases of Common Stock Cash Dividends (S2.36 per share) Balance, January 31, 2016 Net Earnings Shares Issued Under Employee Stock Plans Tax Effect of Stock-Based Compensation Foreign Currency Translation Adjustments Cash Flow Hedges, net of tax Stock Options, Awards and Amortization of Restricted Stock Repurchases of Common Stock Cash Dividends ($2.76 per share) Other Balance, January 29, 2017 244 (59) (3,031) $30,973 7,957 1,772 $88 $9,347 $(898) (520) 76 97 34 267 (53) (3,404) 1,776 $88 S9,787 $35,519 $(867) (573) Page THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Cash Flows Jan. 29, 2017 "Fiscal 2016" Fiscal Year Ended) Jan. 31, 2016 "Fiscal 2015" Feb. 1, 2015 "Fiscal 2014" amounts in millions CASH FLOWS FROM OPERATING ACTIVITIES: Net Earnings Reconciliation of Net Earnings to Net Cash Provided by Operating Activities: $7,957 $7,009 $6,345 1,973 Depreciation and Amortization Stock-Based Compensation Expense Gain on Sales of Investments Changes in Assets and Liabilities, net of the effects of 1,863 244 (144) 1,786 225 (323) 267 acquisitions Receivables, net Merchandise Inventories Other Current Assets Accounts Payable and Accrued Expenses Deferred Revenue Income Taxes Payable Deferred Income Taxes Other (138) (769) (48) 446 (81) (124) (199) 244 146 168 159 (104) 8,242 (181) (546) 109 154 15 (33) 9,373 109 (117) Net Cash Provided by Operating Activities 9,783 CASH FLOWS FROM INVESTING ACTIVITIES: Capital Expenditures, net of $179, $165 and $217 of non-cash capital expenditures in fiscal 2016, 2015 and 2014, respectively Proceeds from Sales of Investments Payments for Businesses Acquired, net Proceeds from Sales of Property and Equipment (1,442) 323 (200) 48 (1,271) (1,621) (1.503) 144 (1,666) 43 (2.982) 38 Net Cash Used in Investing Activities (1,583) capital expenditures in fiscal 2016, 2015 and 2014, respectively Proceeds from Sales of Investments Payments for Businesses Acquired, net Proceeds from Sales of Property and Equipment (1,621) (1,503) 144 (1,666) 43 (2,982) (1,442) 323 (200) 48 (1.271) 38 Net Cash Used in Investing Activities (1,583) CASH FLOWS FROM FINANCING ACTIVITIES: Proceeds from Short-Term Borrowings, net Proceeds from Long-Term Borrowings, net of discounts Repayments of Long-Term Debt Repurchases of Common Stock Proceeds from Sales of Common Stock Cash Dividends Paid to Stockholders Other Financing Activities 360 4,959 (3,045) (6,880) 218 (3,404) (78) (7,870) 330 60 3,991 (39) (7,000) 228 (3,031) 290 1,981 (39) (7,000) 252 (2,530) (25) (7,071) (100) (106) 1,929 $1,723 Net Cash Used in Financing Activities (5,787) 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 604 2,216 1,723 $2,538 $2,216 $ 924 $4,623 s 874 3,853 $ 782 $3,435