Refer to the financial statements of The Home Depot in Appendix A. (Note: Fiscal 2016 for The Home Depot runs from February 1, 2016, to January 29, 2017 Required: 1. What amount of Net Sales does the company report during the year ended January 29, 2017? $32,313 $62,282 $7,957 $94,595 2. Assuming that Cost of Sales is the company's term for Cost of Goods Sold, compute the company's gross profit percentage for fiscal 2016 and the year immediately prior to that. O 34.2% and 34.2% O 34.8% and 32.8% 341% and 34.2% O 65.8% and 65.8% 3. Assume that The Home Depot experienced no shrinkage in the most current year. Using the balance sheet and income statement, estimate the amount of purchases in the year ended January 29, 2017 $74,091 $63,022 $62,282 $74,831 THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Balance Sheets January 29, 2017 Fiscal 2016" January 31, 2016 "Fiscal 2015" amounts in millions, except share and per share data ASSETS Current Assets: $2,538 2,029 12,549 608 2,216 1,890 11,809 569 16,484 39,266 Cash and Cash Equivalents Receivables, net Other Current Assets Total Current Assets Property and Equipment, at cost 191 2,102 1,196 $41,973 Net Property and Equipment Goodwill Other Assets 2,093 $42,966 Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: $ 710 7,000 S 350 1,515 1,566 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 1,669 1,941 195 Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes 22,349 1,855 20,789 1,965 Total Liabilities 38,633 STOCKHOLDERS' EQUITY Common Stock, par value $0.05; authorized: 10 bilion 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,347 30,973 (898) 9,787 35,519 (867) shares at January 31, 2016 Total Stockholders' Equity Total Liabilities and Stockholders' Equity $42,966 $41,973 Consolidated Statements of Earnings Fiscal Year Ended) Jan. 31, 2016 Jan. 29, 2017 "Fiscal 2016" Feb. 1,2015 6 "Fiscal 2015" amounts in millions, except per share data NET SALES Cost of Sales GROSS PROFIT Operating Expenses: "Fiscal 2014" S83,176 54,787 28,389 $94,595 62,282 32,313 $88,519 58,254 30,265 17,132 1,754 18,886 13,427 Selling. General and Administrative 16,801 1,690 18,491 11,774 16,280 1,640 17,920 10,469 Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income (36) 972 936 12,491 4,534 7957 1,229 $ 6.47 1,234 $ 6.45 (166) 919 753 11,021 4,012 7,009 1,277 $ 5.49 1,283 $ 5.46 (337) 830 493 9,976 3,631 6,345 1,338 $4.74 1,346 S 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 (I) Fiscal years ended January 29, 2017, January 3I, 2016, and February I, 2015 include 52 weeks. THE HOME DEPOT, INC. AND SUBSIDIARIES Fiscal Year Ended) Jan. 31,2016 "Fiscal 2015" $7,009 Jan. 29, 2017 "Fiscal 2016" amounts in millions Feb. 1,2015 "Fiscal 2014" S6,345 Net Earnings $7,957 Other Comprehensive Income (Loss): (412) (34) (510) Foreign Currency Translation Adjustments Cash Flow Hedges, net of tax Other 34 31 446 498) Total Other Comprehensive Income (Loss) () $7.988 COMPREHENSIVE INCOME $6,563 $5,847 (I) Fiscal years ended January 29, 2017, January 3I, 2016, and February I, 2015 include 52 weeks. Notes to Consolidated Financial Statements THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Stockholders' Equity on Stock Treasury Stock Stockholders Paid-In Retained Comprehensive Capital amounts in millions, except per share data Shares Balance, February 2, 2014 Net Earnings Shares Issued Under Employee Stock Plans 7 Tax Effect of Stock-Based Compensation Foreign Currency Translation Adjustments_ Cash Flow Hedges, net of tax Stock Options, Awards and Amortization Amount Earnings Income (Loss) $ 46 Shares Equity (381) $(19,194) $12,522 6,345 122 136 Amount 1,761 $88 $8,402 $23,180 6.345 122 136 of Restricted Stock Repurchases of Common Stock Cash Dividends (S1.88 per share) (80)(7.000) (7000) (2,530) (2,530) 1,768 $88 $8,885 $26,995 7,009 $(452) (461) $(26,194)$9,322 7,009 73 145 (412) (34) 244 Balance, February 1,2015 Net Earnings Shares Issued Under Employee Stock Plans4 Tax Effect of Stock-Based Compenstion _ Foreign Currency Translation Adjustments_ Cash Flow Hedges, net of tax Stock Options, Awards and Amortization 73 145 (412) (34) 244 of Restricted Stock Repurchases of Common Stock Cash Dividends (S2.36 per share) Balance, January 31,2016 Net Earnings Shares Issued Under Employee Stock Plans4 Tax Effect of Stock-Based Compenstion _ Foreign Currency Translation Adjustments_ Cash Flow Hedges, net of tax Stock Options, Awards and Amortization (59) (7,000 7,000) (3,031) (3,031) 1,772 $88 $9,347 $30,973 7,957 $(898) (520) $(33,194) 6,316 7,957 76 97 97 34 34 267 267 of Restricted Stock Repurchases of Common Stock Cash Dividends (S2.76 per share) (53) (7,000 7,000) (3,404) (3,404) S(867)573) 1,776 $88 $9,787 $35,519 (573) $(40,194) 4,33:3 Balance, January 29, 2017 See accompanying Notes to OME Consolidated Statements of Cash Flows Fiscal Year Ended) Jan. 31, 2016 "Fiscal 2015" Jan. 29, 2017 "Fiscal 2016" 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 S6,345 1,786 (323) 1,973 267 1,863 244 (144) Stock-Based Compensation Expense Gain on Sales of Investments Changes in Assets and Liabilities, net of the effects of acquisitions: Receivables, net Merchandise Inventories Other Current Assets Accounts Payable and Accrued Expenses Deferred Revenue Income Taxes Payable Deferred Income Taxes Other (138) (181) (546) (124) (199) 244 146 168 159 104 (48) 446 109 154 15 (117) 9,783 Net Cash Provided by Operating Activities CASH FLOWS FROM INVESTING ACTIVITIES: Capital Expenditures, net of $179, $165 and S217 of non-cash capital expenditures in fiscal 2016, 2015 and 2014, respectively Proceeds from Sales of Investments (1,621) (1,503) (1,442) 323 (200) 48 144 Payments for Businesses Acquired, net Proceeds from Sales of Property and Equipment (1,666) 43 982 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 60 3,991 (39) (7,000) 290 1,981 (39) (7,000) 4,959 (3,045) (6,880) (3,404) (3,031) (2,530) Net Cash Used in Financing Activities 071 (100) (106) 1,929 S1,723 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 330 1,723 $2,216 $2,538 S 874 $3,853 $ 924 $4,623 S 782 $3,435