RATIO FORMULA VORK ANSVER Current Ratio 1.00 Current Assets Current Liabilities 12000 11974 Debt to Asset 1.2 Total Liabilites Total Assets 27974 34408 Net Profit Margin Net Income Revenues 3093 3247 Asset Turnover Net Revenue Average net fixed asset Return on Equity 3093 Net Income - preferred dividends average common stockholders equity Inventory Turnover COGS average inventory 42553 10458 Average Days to Sell Inventory 365 inventory turnover Gross Profit Margin 2.8 net sale. COGS net sales 65017 - 42553 = 22464 65017 Return on Assets Earnings Per Share 0.34 net income-preferred dividends average #common shares outstanding 3093 - 433= 2660 910 Price-Earnings (Google the stock price for Feb 3rd, 2017 Accounts Receivable Turnover 3247 net sales revenue average net receivables Average Days to Collect AIR January 29, 2017 "Fiscal 2016" January 31, 2016 "Fiscal 2015" $ 2.216 1,890 11,809 569 16,484 $ 2,538 2,029 12:549 608 17.724 40,426 18.512 21.914 2,093 1,235 $42,966 39.266 17,075 22,191 2,102 1.196 $41.973 $ 710 $ 350 6,565 1,515 amounts in millions, except share and per share data ASSETS Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets 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: 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 Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes Total Liabilities STOCKHOLDERS' EQUITY Common Stock, par value $0.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 shares at January 31, 2016 Total Stockholders' Equity Total Liabilities and Stockholders' Equity 7.000 1,484 508 1,669 25 542 2,195 476 1,366 34 77 1941 12.524 20,789 1,965 379 35.657 22,349 1,855 296 38.633 88 88 9.-8- 35:519 (86) (40,194) 9:347 30,973 (898) (33.194) 4:333 S42,066 6.216 $41.973 . 34.78 Page AB THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Earnings Fiscal Year Ended(1) Jan. 29, 2017 Jan. 31, 2016 Feb. 1, 2015 amounts in millions, except per share data "Fiscal 2016" "Fiscal 2015" "Fiscal 2014" NET SALES S94:59 $88,519 $83,176 Cost of Sales 62,282 58.254 GROSS PROFIT 32,313 30,265 28,389 Operating Expenses: Selling, General and Administrative 17.132 16,801 16280 Depreciation and Amortization 1,754 1,690 1,640 Total Operating Expenses 18,886 18,491 17.920 OPERATING INCOME 13,427 11,774 10,469 Interest and Other (Income) Expense: Interest and Investment Income (36) (166) (337) Interest Expense 919 820 Interest and other, net 753 493 EARNINGS BEFORE PROVISION FOR INCOME TAXES 12.491 11.021 Provision for Income Taxes 4:534 4,012 3.631 NET EARNINGS $ 7.009 $ $7.952 6345 Weighted Average Common Shares 1,229 1-277 1.338 BASIC EARNINGS PER SHARE $ 6.47 $4.74 Diluted Weighted Average Common Shares 1,234 1,283 1,346 DILUTED EARNINGS PER SHARE $ 6.45 $ 5.46 92 936 9.976 $ 5-49 $ 4.74 Feb. 1. 2015 (1) Fiscal years ended.ary 20, 2017 January 3, 2006, and awary 1, 2015 inchide Sarowarying Notes to Consolidated Financial Statements. THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Comprehensive Income Fiscal Year Ended (1) Jan. 29, 2017 Jan. 31, 2016 amounts in millions "Fiscal 2016" "Fiscal 2015" "Fiscal 2014" Net Earnings $7.957 $7,009 Other Comprehensive Income (Loss): Foreign Currency Translation Adjustments (3) (412) (510) Cash Flow Hedges, net of tax 34 (34) Other Total Other Comprehensive Income (Loss) 31 14.46 (498) COMPREHENSIVE INCOME $7.088 $6,563 $5.842 $6 345 kelige 11 g* *125 Common Stock Shares 1,-61 Accumulatec Other Comprehensive Income (Loss) S 46 Paid-In Capital 58,402 Amount S88 Retained Earnings $23,180 6 345 122 236 (510) - - - 11 225 (2,530) 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 ($1.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 ($2.36 per share) Balance, January 31, 2016 1.-68 S88 58,885 S26,995 7,009 S(452) II 4 73 145 - - - - (412) 244 11 (3.031) $30,973 1,772 $88 $9.347 S(898) Wat rinor Feb. 1. 2015 "Fiscal 2014 $6 345 1,863 1,786 225 (323) (81) 446 THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Cash Flows Fiscal Year Ended (1) Jan. 29, 2017 Jan. 31, 2016 amounts in millions "Fiscal 2016" "Fiscal 2015" CASH FLOWS FROM OPERATING ACTIVITIES: Net Earnings S-.957 $7,009 Reconciliation of Net Earnings to Net Cash Provided by Operating Activities: Depreciation and Amortization 1.973 Stock-Based Compensation Expense 26 244 Gain on Sales of Investments Changes in Assets and Liabilities, net of the effects of acquisitions: Receivables, net (138) (181) Merchandise Inventories (-69) (546) Other Current Assets (48) Accounts Payable and Accrued Expenses 888 Deferred Revenue 99 109 Income Taxes Payable 109 154 Deferred Income Taxes 15 Other (33) Net Cash Provided by Operating Activities 9.783 9.373 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 (1,621) (1:503) Proceeds from Sales of Investments 144 Payments for Businesses Acquired, net (1666) Proceeds from Sales of Property and Equipment 38 43 Net Cash Used in Investing Activities (1.583) (2.982) CASH FLOWS FROM FINANCING ACTIVITIES: Proceeds from Short-Term Borrowings, net 360 60 Proceeds from Long-Term Borrowings, net of discounts 4:959 3.991 Repayments of Long-Term Debt (3,045) (39) Repurchases of Common Stock (6,880) 6,000) Proceeds from Sales of Common Stock 218 228 Cash Dividends Paid to Stockholders (3.404) (3,031) Other Financing Activities (-8) (199) 244 146 168 159 (104) 8,242 (1.442) 323 (200) 48 (1271) 290 1,981 (39) (7,000) 252 (2530) 6.870) 330 (5:787) 604 (207) (100) 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 (8) 2,216 $2,538 (111) 1.722 S2.216 (106) 1.929 S1.723 $ 924 $4,623 $ 874 $3853 $ 782 $3:435