Financial Info Saved Hel Compute the following three ratios for The Home Depot's year ended January 29, 2017:() fixed asset turnover. c) days to sell, and (1) debt-to-assets. To calculate the ratios, use the Fiscal 2016 financial statements of The Home Depot in Appendix A at the end of this book. (Note: Fiscal 2016 for The Home Depot runs from February 1, 2016, to January 29, 2017. As with many retail companies, The Home Depot labels the period "Fiscal 2016" even though it ends in the 2017 calendar year. The label "Fiscal 2016" is appropriate because Fiscal 2016 Includes 11 months from the 2016 calendar year. The Home Depot explains its choice of fiscal period in Note 1 to its financial statements.) (Use 365 days in a year. Round intermediate calculations to 2 decimal places. Round fixed asset turnover and debt-to-assets final ratios to 2 decimal places. Round days to sell ratio to 1 decimal place.) 2.37; 71.4: 0.90 O 2.37; 47.0; 0.52 4.29:47.0:0.90 4.29: 71.4: 0.90 AS APPENDIX A Escape from the Fal 2016 The Dine THE HOME DEPOT, INC. AND SUBSIDIARIES Codwied Balance Sheets January 29, 2017 "Thical 2016 January 31, 2016 scal 2015 52585 2.029 12.50 03 17.724 40,426 18,512 21.914 2,093 1,235 $42.966 S2215 1890 11.09 569 16.454 39,366 17.075 22.191 2.1 1.196 541.973 mohin millions, encep share and share data ASSETS Current Assets Cash and Cash Equivalents Receivables, nes Merchandise Invas Other Current Assets Total Current Assets Property and Equipment, tout Less Accumulated Depreciation and Amortization Net Property and quipment Goodwill Other Assets Total Assets LIABILITIES AND STOCKHOLDERS' EQUITY Current Liabilities: Short-Term Det Accounts Payable Accrued Salaries and Related Expenses Sales Taxes Payable Deferred Revenge Income Tunes Payable Current Installments of Long-Term Debt Other Accrued Expenses Total Current abilities Long-Term Detecluding current installments Other Long Term Liabilities Deferred Income Taxes Total Lisbilities STOCKHOLDERS' EQUITY Common Stock,pava 10.08; whorid: 10 hillice shares 1.776 billion sans tary 29,2017 und 1772 shares January 31, 201fic outstanding 1203 billion shara January 29, 2017 and 1232 billion shares at January 31, 2016 Pada Capital Retained Fannings Accumulated Other Comprehensive Trey Stock 573 million lures tary 29, 2017 and 30 milion real January 31, 2016 Tul Stockhollen Total Liabilities and Stockholders' pulty 5 710 7,000 1.484 SON 1.669 $350 6543 1.515 476 1.566 77 1.941 341 2,195 14133 2,39 1.855 296 38,633 279 170 15,519 30,973 40,19 (11 6.316 541.923 S6 AR APPENDIX A 5014 The Home Depot THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statement of Earnings Feb. 1. 2015 "Fiscal 2014 Fiscal Year Ended Jan. 31, 2016 "Fiscal 2015" 52519 58.254 30.265 $83.176 54.77 222 2389 16.280 1640 36.801 1,690 18.091 11,774 10.469 Jan. 29, 2017 amounts million, cepper hur dula "Fiscal 2016" NET SALES $94.95 Cost of Sales GROSS PROFIT 32,313 Operating Expenses Selling. General and Administrative 17.132 Depreciation and Amortization 1,754 Teal Operating Expenses 1.NO OPERATING INCOME Interest and Other Income Experie Inice and Imestment Income (36) Interest Expense 972 Tires Others 936 EARNINGS BEFORE PROVISION FOR INCOME TAXES 12.491 Provision for Income Tunes 4,534 NET EARNINGS $ 7,957 Weighted Average Common Shares 1.229 BASIC EARNINGS PER SHARE $ 641 Diluted Weighted Average Common Shares 1,234 DILUTED EARNINGS PER SHARE $ 6.45 (Final years and mary 29, 2017. Jury Merry .2015 rede week Ser Mom (166) 919 753 11.021 4,012 0337 8.30 493 9.976 3.631 57.000 1.272 55:49 1:33 $474 1.346 5471 $5.46 THE HOME DIPOT, INC. AND SUBSIDIARIES Contodated Statement of Comprehensive me min milli Jan. 29, 2017 "Fiscal 2016" 57.957 Fiscal Year Ended Jan 31, 2016 Fecal 2019 57.000 Feb 1, 2015 hal 2017 4123 5109 14 Net Warning Other Comprehensive Income (Los) Foreign Currency Translation Casa Flow Hedprset of us Other Total Other Comprehensive me. COMPREHENSIVE INCOME that may 29, 2017 1. Many 2015 1 31 $7, 446 56563 $5.847 AZ APPENDIX A cette Fiscal 2016 Report of theme Depot fi THE HOME DEPOT, INC. AND SUBSIDIARIES Contrated Statements of Stockholders' fiuty III Accumulated Commen Stock Other AMOUR in million, trapper share date Shares Amount Capital Earnings Income (Les) Shares Paid In Retained Comprehensive Treasury Stock Stockholders Amount Balance, February 2, 2014 Equity 1,761 $88 $8,402 $23.180 $46 (381) $12.198 $12.523 Net Farmin 6.305 Shures and Under Employee Stock Plans 6.345 122 123 Tex Effect of Stock-Based Compensation 136 136 Foreign Currency Translation Adjustment (510) (10) Cash Flow Hedges, net of tax Stock Options, Awards and Amortizatice 225 of Restricted Stock Repurchases of Common Stock (7.000) (700 Cash Dividends (51.88 per share) (2.5301 Other 1 Balance, February 1, 2015 1,768 Sa $5.885 $26.995 $1452) (461) $26.1949 Niet Earnings 7.000 7.000 Shares led Under Employee Stock Plus 78 73 Tax Effect of Stock-Based Compensation 145 Foreigs Currency Translation Adjustments (412) (412) Cash Flow Hedges, ner of tax (14) Stock Opcions, Awards and Amortisation 344 of Restricted Stack Repures of Com Stock (59) (7.000 (7.000 Cash Dwiede (5236 per share 1) (1031) Balance, January 31, 2016 1.772 $9,17 $10.973 1920) 194 $ 6316 Net rings 7.957 7.937 Shares sued Under ployee Stock Plans 76 76 The Effect of Stock-Based Compensation 97 Foreign Currency Trade 0 Cash Flow Hedges, of 34 34 Stock Option Awards and Ameri 267 of Rited Stack Repurchases of Cek (7.000 Cal Dividends (12.7 perc 014041 13,404 Other 62 Balance, January 29, 2017 1,776 SAN 59,787 SA319 (573) 5140,190 54 1181 LIIIII III 344 1 151 III IIIIIIIIIIIIIIIII III II Jan. 29, 2017 "Fiscal 2016 Fiscal Year Ended Jan 31, 2016 "Fiscal 2015 Feb 1, 2015 "Fiscal 2014 $7,957 57.009 1.973 267 1.863 244 (144) 1.786 225 (81) (124) (138) (769) (48) 45 99 109 (117) 4 9.783 (546) 153 X8 109 154 15 (39 9.373 244 146 166 159 (100 X.242 (1.621) (1.505) (1.440 a millions CASH FLOWS FROM OPERATING ACTIVITIES: Net Farnings Reconciliation of Net Earnings to Net Cash Provided by Operating Activities: Depreciation and Amortization Stock-Based Compensation Expense Gain on Sales of investments Changes in Assets and Liabilities, net of the effects of acquisitions: Receivables.net Merchandise Investories Other Current Assets Accounts Payable and Accrued Expenses Deferred Reven Income Taxes Payable Deferred Income Taxes Other Net Cash Provided by Operating Activities CASH FLOWS FROM INVESTING ACTIVITIES: Capital Expenditures set of $179, 5165 and $217 of non-cush capital expenditures in fiscal 2016, 2015 and 2014, respectively Proceeds from Sales of Investments Pagments for Business Acquired.net Proceeds from Sales of Property and Equipment Net Cash Used in Investing Activities CASH FLOWS FROM FINANCING ACTIVITIES: Proceeds from Short Term Bornwings.net Proceeds from Long-Term Hornwings, of discounts Repay of Long Term Debe Repurchases of Common Stock Proceeds from Sales of Como Stock Cash Tidende Paid to Stockholders Other Racing Activities Net Cash Used lisancing Activities Change in Chand Cash Equivalent Effect of Edat Chapeau Cash and Cash Events Call Callentaal ning of Year Chand Cash Equivalents and of Year SUPPLEMENTAL DISCLOSURE OF CASH PAYMENTS MADE FOR: Interest, net of captaland Income Taxes Child 22.01. Made 12 144 (1,665) 41 2.982 48 (1.583) 360 4,959 (3045) 16.80) 218 (9,404 (78 1770 330 05 60 3.991 030) 7.000 23 290 1.981 39 C.000 252 (111) 1.223 CAT (100) (106) 1.929 31.223 $934 S$14 3.RS 5 72 33.15