Complete Fiscal 2016 Home Depot 2016 Annual Report Ratios

- Include the formula for each raio.

- Show work.

- Provide answer.

*Some formulas may be wrong but, this is what I have come up with so far!*

Ratio	Formula	Work	Answer
Current Ratio	Current Assests/Current Liability	17724/14133	1.254
Debt to Assest	Total Liabilities/Total Assets	38633/42966	0.899
Net Profit Margin	Net Income/Revenues	7957/94595	0.084%
Assest Turnover	Net Sales Renenue/Average Net Fixes Assets	94595/22052.5	4.289
Return on Equity	Net Incomes/Average Common Stockholders	7957/?
Inventory Turnover	Cost of Goods Sold/Average Inventory	62282/12179	5.113
Average Days to Sell Inventory	365/Inventory Turnover Rate	365/5.113	71.386
Gross Profit Margin	Net Sales-Cost of Goods Sold/Net Sales	32313/94595	0.341%
Return on Assets	Net Income/Average Total Assets	7957/42469.5	0.187%
Earning Per Share	Net Income-Preferred Dividends/Average Number of Common Shares Outstanding
Price-Earning	Stock Price (per share)/Earnings per Share (annual)
Accounts Receivable Turnover	Net Sales/Average Accounts Receivable
Average Days to Collect A/R	365/Receivable Turnover Ratio

AS APPENDIX A Fxen mbs riscal 2016 Annual Report of Thellyne Liepot, L. THE HONE DEPOT, INC. AND SUBSIDIARIES Consolidaied Statements of Earnings I Jan. 29, 2017 "Tiscal 2016" Fiscal Year Ended (1) Jan 31, 2016 "Tiscal 2015" Feb. 1. 2015 "Fiscal 2014 amounts in milions, except per s e di n S88 519 58.254 30,255 $83,176 54,787 28,389 16,220 _1.540 16.801 1,670 18,181 11,774 17,920 -0,449 (166 NET SALES $94,595 Cost of Sales 62.262 GROSS PROFIT 32,313 Operating Expenses Selling, Gencre and Administrative 17,132 Deprcciaion and Amortization 1,754 Toral Operaticz Expenses 18,886 OPERATING INCOME 13.427 latrast 14 Ones Incore) Expence: Inlcrest and levestinent l a (36) Interest Expense 972 terest and 0 se, 936 EARNINGS BEFORE PROYTSTON FOR INCOME TARES 12:491 Pror-ision for Income Taxes 4,534 NET EARNINGS Weighted Average Coman Shares 1,229 BASIC EARNINGS I'ER SHARE Tinted Weightec Average Coucou Shares 1,234 1)TECTED RARNLNGS PER SHARE 9) Feel years ended Jarwary 29 20:7. Warugry 31, 2016, and February 9, 2015 include 52 weeks. Sre accompanying valet ic Comicidated licenci Staseret --919 830 753 11,02: 1999 899597132839 4,012 $7,009 1.277 5.49 1,283 4,976 9,531 S 6,345 1.338 1,346 4.71 $ THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Comprehensive Encome anyounis in millions Jan. 29, 2017 Tiscal 2016" Fiscal Year Ended Jan. 31, 2016 "Biscal 2015 Feb. 1. 2015 "Fiscal 2014" $6,345 57,957 $7.909 (412) (510, Nel Eatings Other Compre rusive ITC (255); Foreiga Checy T-arslariuc: 4:11 SET Cash Flow ledges, set of tax Other Total Other Comprehensive Incore (T.oss! COMPREHENSIVE INCOME F:vi yeurs ended January 29, 2017, amary, 2016, 3 February 2, 2015 l cumpering voter te Orsol.dand Financiai Kaserner 1 498) $7,988 36,552 $3,547 32 wini's, Source: The Home Depot APPENDIX A Exceps no Piscal 2016 sul Report of The Home Dex, Inc. THE HOME DEPOT, INS. AND SUBSIDIARIES Conscicated Statements of Stockholders' Ecuity Treasury Stock Shares Amourt (381) $(19.194) 1,761588 Accumulated Other Common Stock Paid-In Retained Coraprehensive Nounts in Millions, except per share data Shares Amount Capital Tarnings Louime (Loss) Balance February 2, 2014 $8,402 $23,180 $46 Nor barnin - 5,345 Shares Issued Under Copinyes Stock Plans 7 Tu E t of Stock-Based Compensation Tureign Currency Traslatioa Adjustaceats n3b Fow Tierges, act of tax Stock Uplioas, Awards und Amortization of Restricted Suck Repurchases Common Stock Cush Dividenils ($ 8 pec stars) (2,530) Stockholders' Feuity $12,522 6,345 122 136 (510) 1! 225 7,0000 (7,000) (2.530) Other $8.885 $26,995 SE452) (461) $426,194) $9.322 7,009 4 145 (412) 244 (59) (7,000) (3.031) 17. (3.61 S 6,316 7.957 $30,973 $1898) (520) Balance, February 1, 2015 Net Een Shares Issued Indian Empoyee Stock Piena Tar Pector Stock Basse Compensatia Foreign Crency Trancaiza Adjustments Cast Flos edge, Dei o tax Stock Opcione, Awards and A.To, Tization of Rusticted Stock Reparchiscs of Combor Stock Cash Dividends ($2.36 pe sture) Balance, January 31, 2016 Net Eurings Sacres Issuec Cades Capiorse Back Pans Tax Factor Suck Based Carprasation Forrige Currency Translation Adjustments Cash Fi Hodges, el tex . Stock: Opas, Awards - Amorizatio of Restricted Stock Roolchases of Common Stock Ces Dividends (52.76 per share) Olier Balance, Janitary 29, 2017 See accompanying Noses a Codured Fusencial S $(33,194) 7.957 (53) 7.000 (7.000) (3,464) - 1.76 To 59,787 528,519 $88 $4,38 $9,787 $1007 $35,519 $1867 159 5:46,30 (5 $40,194) 4,333 WAND Source: The Home Deo APPENDIX A Exemps to the Fiscal 296 4. Report cfTbc Fome Depo. Inc. 19E HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Balance Sheets January 29, 2017 Piscal 2016 January 31, 2016 "Fiscal 2015 $2,538 12,549 608 17,724 40.426 18,512 21.914 2,093 1,235 S42.966 S 2216 1.390 11,909 SOS 16,454 25,266 17.075 22,191 2,102 1,196 $4.913 $ $ 710 7.000 1.484 Grounds in millions, except share and per skare data ASSETS Cureat Assets Cash end Cash Equivalents Receivables, act Merchandise Inventuries Other Current Assets Tocal Cu.rent Aske's Popszy and Equipment, at Lass Accumulatcai Depreciation and Amatization Ner Property and Equipeut Goodwill Oibar Assets Total Assets LLABLLOJES AND STOCKHOLDERS' BOLTTY Carton: Liabilities: Short-Tero Debt Accounts Payable Accrued Saaries and Related Expenses Sales Texes Payabl: Deferred Revenue Eucome Taxes Payable Creat lasta_ments of Long-Tam Debt Other Accued Expenses Tual Correct I can.tics Long-acra Dess, excluding current installments Oto Long-Tecun Lily litics Defe-:1 Lcuzze Taxes Totaliabilises STOCKHOLDERS' EQUITY Coin ou Scoale, par value: SOCS; riva 10 billion base !! 1,776 billion shares at juary 29,2017 und! 1772 Walioa sbarcs | Jauery 21, 2016; outstanding: 0.203 bijor Sosa. January 29, 2017 1 1.252 billiunares ar jag gry 31, 2015 Paid-in Capita Retained Earnings Accumulated Othr Comurehensive LORS TIesny St:xk, svet, 573 milio sbarcs el Tatuery 29, 2017 24 520 million sta es at Jatusy 21, 2016 Total Stockholders' Equity Total Liabilities and Stockholders' Equity 250 6,565 1515 476 1,565 508 1,669 542 2,195 14,133 22,349 1,855 296 38,633 1,941 22,524 20,789 1.965 379 . 35,657 9,787 35,519 (867) 140,194) 9,347 30.973 (8981 93,199 5,316 41,973 $42.966 Scen aria? Nossos Consoldated Financial Servers Source: The Forne Depot AS APPENDIX A Fxen mbs riscal 2016 Annual Report of Thellyne Liepot, L. THE HONE DEPOT, INC. AND SUBSIDIARIES Consolidaied Statements of Earnings I Jan. 29, 2017 "Tiscal 2016" Fiscal Year Ended (1) Jan 31, 2016 "Tiscal 2015" Feb. 1. 2015 "Fiscal 2014 amounts in milions, except per s e di n S88 519 58.254 30,255 $83,176 54,787 28,389 16,220 _1.540 16.801 1,670 18,181 11,774 17,920 -0,449 (166 NET SALES $94,595 Cost of Sales 62.262 GROSS PROFIT 32,313 Operating Expenses Selling, Gencre and Administrative 17,132 Deprcciaion and Amortization 1,754 Toral Operaticz Expenses 18,886 OPERATING INCOME 13.427 latrast 14 Ones Incore) Expence: Inlcrest and levestinent l a (36) Interest Expense 972 terest and 0 se, 936 EARNINGS BEFORE PROYTSTON FOR INCOME TARES 12:491 Pror-ision for Income Taxes 4,534 NET EARNINGS Weighted Average Coman Shares 1,229 BASIC EARNINGS I'ER SHARE Tinted Weightec Average Coucou Shares 1,234 1)TECTED RARNLNGS PER SHARE 9) Feel years ended Jarwary 29 20:7. Warugry 31, 2016, and February 9, 2015 include 52 weeks. Sre accompanying valet ic Comicidated licenci Staseret --919 830 753 11,02: 1999 899597132839 4,012 $7,009 1.277 5.49 1,283 4,976 9,531 S 6,345 1.338 1,346 4.71 $ THE HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Statements of Comprehensive Encome anyounis in millions Jan. 29, 2017 Tiscal 2016" Fiscal Year Ended Jan. 31, 2016 "Biscal 2015 Feb. 1. 2015 "Fiscal 2014" $6,345 57,957 $7.909 (412) (510, Nel Eatings Other Compre rusive ITC (255); Foreiga Checy T-arslariuc: 4:11 SET Cash Flow ledges, set of tax Other Total Other Comprehensive Incore (T.oss! COMPREHENSIVE INCOME F:vi yeurs ended January 29, 2017, amary, 2016, 3 February 2, 2015 l cumpering voter te Orsol.dand Financiai Kaserner 1 498) $7,988 36,552 $3,547 32 wini's, Source: The Home Depot APPENDIX A Exceps no Piscal 2016 sul Report of The Home Dex, Inc. THE HOME DEPOT, INS. AND SUBSIDIARIES Conscicated Statements of Stockholders' Ecuity Treasury Stock Shares Amourt (381) $(19.194) 1,761588 Accumulated Other Common Stock Paid-In Retained Coraprehensive Nounts in Millions, except per share data Shares Amount Capital Tarnings Louime (Loss) Balance February 2, 2014 $8,402 $23,180 $46 Nor barnin - 5,345 Shares Issued Under Copinyes Stock Plans 7 Tu E t of Stock-Based Compensation Tureign Currency Traslatioa Adjustaceats n3b Fow Tierges, act of tax Stock Uplioas, Awards und Amortization of Restricted Suck Repurchases Common Stock Cush Dividenils ($ 8 pec stars) (2,530) Stockholders' Feuity $12,522 6,345 122 136 (510) 1! 225 7,0000 (7,000) (2.530) Other $8.885 $26,995 SE452) (461) $426,194) $9.322 7,009 4 145 (412) 244 (59) (7,000) (3.031) 17. (3.61 S 6,316 7.957 $30,973 $1898) (520) Balance, February 1, 2015 Net Een Shares Issued Indian Empoyee Stock Piena Tar Pector Stock Basse Compensatia Foreign Crency Trancaiza Adjustments Cast Flos edge, Dei o tax Stock Opcione, Awards and A.To, Tization of Rusticted Stock Reparchiscs of Combor Stock Cash Dividends ($2.36 pe sture) Balance, January 31, 2016 Net Eurings Sacres Issuec Cades Capiorse Back Pans Tax Factor Suck Based Carprasation Forrige Currency Translation Adjustments Cash Fi Hodges, el tex . Stock: Opas, Awards - Amorizatio of Restricted Stock Roolchases of Common Stock Ces Dividends (52.76 per share) Olier Balance, Janitary 29, 2017 See accompanying Noses a Codured Fusencial S $(33,194) 7.957 (53) 7.000 (7.000) (3,464) - 1.76 To 59,787 528,519 $88 $4,38 $9,787 $1007 $35,519 $1867 159 5:46,30 (5 $40,194) 4,333 WAND Source: The Home Deo APPENDIX A Exemps to the Fiscal 296 4. Report cfTbc Fome Depo. Inc. 19E HOME DEPOT, INC. AND SUBSIDIARIES Consolidated Balance Sheets January 29, 2017 Piscal 2016 January 31, 2016 "Fiscal 2015 $2,538 12,549 608 17,724 40.426 18,512 21.914 2,093 1,235 S42.966 S 2216 1.390 11,909 SOS 16,454 25,266 17.075 22,191 2,102 1,196 $4.913 $ $ 710 7.000 1.484 Grounds in millions, except share and per skare data ASSETS Cureat Assets Cash end Cash Equivalents Receivables, act Merchandise Inventuries Other Current Assets Tocal Cu.rent Aske's Popszy and Equipment, at Lass Accumulatcai Depreciation and Amatization Ner Property and Equipeut Goodwill Oibar Assets Total Assets LLABLLOJES AND STOCKHOLDERS' BOLTTY Carton: Liabilities: Short-Tero Debt Accounts Payable Accrued Saaries and Related Expenses Sales Texes Payabl: Deferred Revenue Eucome Taxes Payable Creat lasta_ments of Long-Tam Debt Other Accued Expenses Tual Correct I can.tics Long-acra Dess, excluding current installments Oto Long-Tecun Lily litics Defe-:1 Lcuzze Taxes Totaliabilises STOCKHOLDERS' EQUITY Coin ou Scoale, par value: SOCS; riva 10 billion base !! 1,776 billion shares at juary 29,2017 und! 1772 Walioa sbarcs | Jauery 21, 2016; outstanding: 0.203 bijor Sosa. January 29, 2017 1 1.252 billiunares ar jag gry 31, 2015 Paid-in Capita Retained Earnings Accumulated Othr Comurehensive LORS TIesny St:xk, svet, 573 milio sbarcs el Tatuery 29, 2017 24 520 million sta es at Jatusy 21, 2016 Total Stockholders' Equity Total Liabilities and Stockholders' Equity 250 6,565 1515 476 1,565 508 1,669 542 2,195 14,133 22,349 1,855 296 38,633 1,941 22,524 20,789 1.965 379 . 35,657 9,787 35,519 (867) 140,194) 9,347 30.973 (8981 93,199 5,316 41,973 $42.966 Scen aria? Nossos Consoldated Financial Servers Source: The Forne Depot