Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the financial statements of The Home Depot in Appendix A . (Note: Fiscal 2016 for The Home Depot runs from February 1, 2016,
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.
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. (e) 34.2% and 34.2% O 34.8% and 32.8% 34.1% and 34.2% 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. $62.282 $74,091 $63,022 $74,831 APPENDIX A Excerpts from the Fiscal 2016 Annual Report of The Home Depot, Inc 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: Cash and Cash Equivalents Receivables, net 2,538 2,029 12,549 S 2.216 1,890 11,809 Other Current Assets Total Current Assets 17,724 16.484 Property and Equipment, at cost 40,426 Net Property and Equipment Goodwill Other Assets 21,914 2,093 1,235 $42,966 22.191 2.102 1,196 Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: 710 7,000 1,484 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 S 350 1,515 1,669 1,566 2.195 4.133 Total Current Liabilities Long-Term Debt, excluding current installments Other Long-Term Liabilities Deferred Income Taxes 20,789 1,965 1,855 Total Liabilities 38,633 35,657 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 illion 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 Total Liabilities and Stockholders' Equity $42,966 See accompanying Notes to Conolidated Financial Statements. A6 APPENDIX A Excerpts from the Fiscal 2016 Annual Report of The Home Depot, Inc. THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Earnings Fiscal Year Ended Jan. 31, 2016 Jan. 29, 2017 "Fiscal 2016 Feb. 1, 2015 amounts in millions, except per share data NET SALES Cost of Sales GROSS PROFIT Operating Expenses: Fiscal 2015" Fiscal 2014 $88,519 58,254 $83,176 54.787 32,313 16,280 1,640 17,920 10.469 Selling, General and Administrative Depreciation and Amortization 17,132 1,754 18,886 13,427 16,801 1,690 18.491 11,774 Total Operating Expenses OPERATING INCOME Interest and Other (Income) Expense: Interest and Investment Income (36) 972 936 12,491 (166) 919 753 11,021 (337) 830 493 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 31, 2016, and February 1, 2015 include 52 week. 9,976 7,957 1,229 S 6.47 1,234 6.45 S 7,009 1,277 S 5.49 1,283 S 5.46 S 6,345 1,338 4.74 1,346 S 4.71 See accompanying Notes to Consolidated Financial Satements THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Comprehensive Income Fiseal Year Ended Jan. 31, 2016 Jan. 29, 2017 "Fiseal 2016" amounts in millions Feb. 1, 2015 Fiscal 201 15""Fiscal 2014" Net Earnings $7,957 $7,009 6,345 Other Comprehensive Income (Loss): Foreign Currency Translation Adjustments Cash Flow Hedges, net of tax Other (510) (412) (34) 34 Total Other Comprehensive Income (Loss) 31 (498) COMPREHENSIVE INCOME 988 $6,563 $5,847 (I) Fiscal years ended January 29, 2017, Janiay 31, 2016, and February I, 2013 inchude 52 weeks Nes to Consolidated Financial Statements APPENDIX A Excerpts from the Fiscal 2016 Annual Report of The Home Depot, Inc. A7 THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Stockholders' Equity Other Comprehensive Treasury Stock Shares Amount Common Stock Paid-In Retained Stockholders Equity amounts in millions, except per share data Shares Amount Capital Earnings Income (Loss 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 _ 1,761 S88 $8,402 $23,180 $ 46 (381) $(19,194) $12,522 6.345 122 136 136 (510) of Restricted Stochk Repurchases of Common Stock Cash Dividends ($1.88 per share) (80) (7,000) (7,000) (2,530) (2,530) Balance, February 1, 2015 Net Earnings Shares Issued Under Employee Stock Plans4 Tax Effect of Stock-Based Compensation Foreign Currency Translation Adjustments_ Cash Flow Hedges, net of tax Stock Options, Awards and Amortization _ 1,768 $88 $8,885 $26,995 $(452) (461) $(26,194) 9,322 7,009 145 (412) (34) 412) (34) of Restricted Stock Repurchases of Common Stock Cash Dividends ($2.36 per share) Balance, January 31, 2016 Net Earnings Shares Issued Under Employee Stock Plans 4- Tax Effect of Stock-Based Compensation Foreign Currency Translation Adjustments_ Cash Flow Hedges, net of tax Stock Options, Awards and Amortization _ (59) 7,000(7,000) (3,031) (520) $(33,194) 6.316 7,957 1.772 $88 $9,347 $30,973 S(898) 267 267 of Restricted Stock Repurchases of Common Stock Cash Dividends ($2.76 per share) (53) 7,000(7,000) (3,404) (3,404) 1.776 $88 $9,787 $35,519 S867) (573) $(40,194) 4,333 Balance, January 29, 2017 See accompanying Notes to Consolidated Financial Statements APPENDIX A Excerpts from the Fiscal 2016 Annual Report of The Home Depot Inc THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Cash Flows Fiscal Year Ended) Jan. 31,2016 "Fiscal 2016"Fiscal 2015"Fiscal 2014 Jan. 29, 2017 Feb. 1, 2015 amounts in millions CASH FLOWS FROM OPERATING ACTIVITIES: Net Earnings Reconciliation of Net Earnings to Net Cash Provided by Operating Activities: $7,009 Depreciation and Amortization Stock-Based Compensation Expense Gain on Sales of Investments Changes in Assets and Liabilities, net of the effects of acquisitions: (144) (323) Receivables, net Merchandise Inventories Other Current Assets Accounts Payable and Accrued Expenses Deferred Revenue Income Taxes Payable Deferred Income Taxes (138) (181) (546) (124) (199) (48) (117) Net Cash Provided by Operating Activities 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 Proceeds from Sales of Investments Payments for Businesses Acquired, net Proceeds from Sales of Property and Equipment (1,621) (1,503) (1,442) (1,666) 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 3,991 (3,045) (7,000) (7,000) (3,031) 2.530) Net Cash Used in Financing Activities 7.870) 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) Fiscal years ended January 29, 2017, January 31, 2016, and February I, 2015 include 52 weeks See accompanying Notes to Consolidated Financial Statements (100) 2,216 $2,538 1,723 924 $4,623 S 874 3,853 S 782 $3.435
Step 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