300 or more words on a competitor analysis and comparison to the following informationincome statement, balance sheet, statement of cash flows, horizontal analysis, vertical analysis, and ratio analysis THE HOME DEPOT INC (HD) INCOME STATEMENT Fiscal year ends in January USD in millions except per share data Vertical Analysis of Income Statement 2016 01 2015 01 2014 01 2013 01 2012 01 $ $ $ $ $ Revenue $ 88,519 100 00 $ 83,176 100 00 $ 78,812 100 00 $ 74,754 100 00 $ 70,395 100 00 Cost of revenue $ 58,254 65 81 $ 54,222 65 19 $ 51,422 65 25 $ 48,912 65 43 $ 46,133 65 53 Gross profit $ 30,265 34 19 $ 28,954 34 81 $ 27,390 34 75 $ 25,842 34 57 $ 24,262 34 47 Operating expenses Sales, General and administrative $ 16,801 18 98 $ 16,834 20 24 $ 16,597 21 06 $ 16,508 22 08 $ 16,028 22 77 Other operating expenses $ 1,690 1 91 $ 1,651 1 98 $ 1,627 2 06 $ 1,568 2 10 $ 1,573 2 23 Total operating expenses $ 18,491 20 89 $ 18,485 22 22 $ 18,224 23 12 $ 18,076 24 18 $ 17,601 25 00 Operating income $ 11,774 13 30 $ 10,469 12 59 $ 9,166 11 63 $ 7,766 10 39 $ 6,661 9 46 Interest Expense $ 919 1 04 $ 830 1 00 $ 711 0 90 $ 632 0 85 $ 606 0 86 Other income (expense) $ 166 0 19 $ 337 0 41 $ 12 0 02 $ 87 0 12 $ 13 0 02 Income before income taxes $ 11,021 12 45 $ 9,976 11 99 $ 8,467 10 74 $ 7,221 9 66 $ 6,068 8 62 Provision for income taxes $ 4,012 4 53 $ 3,631 4 37 $ 3,082 3 91 $ 2,686 3 59 $ 2,185 3 10 Net income from continuing operations $ 7,009 7 92 $ 6,345 7 63 $ 5,385 6 83 $ 4,535 6 07 $ 3,883 5 52 Net income $ 7,009 7 92 $ 6,345 7 63 $ 5,385 6 83 $ 4,535 6 07 $ 3,883 5 52 Earnings per share Basic $ 5 49 $ 4 74 $ 3 78 $ 3 03 $ 2 49 Diluted $ 5 46 $ 4 71 $ 3 76 $ 3 00 $ 2 47 Weighted average shares outstanding Basic $ 1,277 $ 1,338 $ 1,425 $ 1,499 $ 1,562 Diluted $ 1,283 $ 1,346 $ 1,434 $ 1,511 $ 1,570 EBITDA $ 13,803 15 59 $ 12,592 15 14 $ 10,935 13 87 $ 9,537 12 76 $ 8,356 11 87 THE HOME DEPOT INC (HD) INCOME STATEMENT Fiscal year ends in January USD in millions except per share data Horizontal Analysis of Income Statement 2016 01 2015 01 2014 01 2013 01 2012 01 $ $ $ $ $ Revenue $ 88,519 106 42 $ 83,176 105 54 $ 78,812 105 43 $ 74,754 106 19 $ 70,395 100 00 Cost of revenue $ 58,254 107 44 $ 54,222 105 45 $ 51,422 105 13 $ 48,912 106 02 $ 46,133 100 00 Gross profit $ 30,265 104 53 $ 28,954 105 71 $ 27,390 105 99 $ 25,842 106 51 $ 24,262 100 00 Operating expenses Sales, General and administrative $ 16,801 99 80 $ 16,834 101 43 $ 16,597 100 54 $ 16,508 102 99 $ 16,028 100 00 Other operating expenses $ 1,690 102 36 $ 1,651 101 48 $ 1,627 103 76 $ 1,568 99 68 $ 1,573 100 00 Total operating expenses $ 18,491 100 03 $ 18,485 101 43 $ 18,224 100 82 $ 18,076 102 70 $ 17,601 100 00 Operating income $ 11,774 112 47 $ 10,469 114 22 $ 9,166 118 03 $ 7,766 116 59 $ 6,661 100 00 Interest Expense $ 919 110 72 $ 830 116 74 $ 711 112 50 $ 632 104 29 $ 606 100 00 Other income (expense) $ 166 49 26 $ 337 2808 33 $ 12 13 79 $ 87 669 23 $ 13 100 00 Income before income taxes $ 11,021 110 48 $ 9,976 117 82 $ 8,467 117 26 $ 7,221 119 00 $ 6,068 100 00 Provision for income taxes $ 4,012 110 49 $ 3,631 117 81 $ 3,082 114 74 $ 2,686 122 93 $ 2,185 100 00 Net income from continuing operations $ 7,009 110 46 $ 6,345 117 83 $ 5,385 118 74 $ 4,535 116 79 $ 3,883 100 00 Net income $ 7,009 110 46 $ 6,345 117 83 $ 5,385 118 74 $ 4,535 116 79 $ 3,883 100 00 Earnings per share Basic $ 5 49 115 82 $ 4 74 125 40 $ 3 78 124 75 $ 3 03 121 69 $ 2 49 100 00 Diluted $ 5 46 115 92 $ 4 71 125 27 $ 3 76 125 33 $ 3 00 121 46 $ 2 47 100 00 Weighted average shares outstanding Basic $ 1,277 95 44 $ 1,338 93 89 $ 1,425 95 06 $ 1,499 95 97 $ 1,562 100 00 Diluted $ 1,283 95 32 $ 1,346 93 86 $ 1,434 94 90 $ 1,511 96 24 $ 1,570 100 00 EBITDA $ 13,803 109 62 $ 12,592 115 15 $ 10,935 114 66 $ 9,537 114 13 $ 8,356 100 00 THE HOME DEPOT INC (HD) BALANCE SHEET Fiscal year ends in January USD in millions except per share data Vertical Analysis of Balance Sheet 2016 01 2015 01 2014 01 2013 01 2012 01 $ $ $ $ $ Assets Current assets Cash Cash and cash equivalents $ 2,216 5 21 $ 1,723 4 31 $ 1,929 4 76 $ 2,494 6 07 $ 1,987 4 90 Total cash $ 2,216 5 21 $ 1,723 4 31 $ 1,929 4 76 $ 2,494 6 07 $ 1,987 4 90 Receivables $ 1,890 4 44 $ 1,484 3 72 $ 1,398 3 45 $ 1,395 3 40 $ 1,245 3 07 Inventories $ 11,809 27 75 $ 11,079 27 73 $ 11,057 27 29 $ 10,710 26 07 $ 10,325 25 48 Other current assets $ 1,078 2 53 $ 1,016 2 54 $ 895 2 21 $ 773 1 88 $ 963 2 38 Total current assets $ 16,993 39 94 $ 15,302 38 31 $ 15,279 37 71 $ 15,372 37 42 $ 14,520 35 84 Non current assets Property, plant and equipment Land $ 8,149 19 15 $ 8,243 20 64 $ 8,375 20 67 $ 8,485 20 65 $ 8,480 20 93 Fixtures and equipment $ 10,279 24 16 $ 9,602 24 04 $ 10,107 24 94 $ 9,338 22 73 $ 10,040 24 78 Other properties $ 20,838 48 97 $ 20,668 51 74 $ 20,582 50 80 $ 20,668 50 31 $ 20,455 50 48 Property and equipment, at cost $ 39,266 92 28 $ 38,513 96 41 $ 39,064 96 41 $ 38,491 93 69 $ 38,975 96 19 Accumulated Depreciation $ (17,075) 40 13 $ (15,793) 39 54 $ (15,716) 38 79 $ (14,422) 35 10 $ (14,527) 35 85 Property, plant and equipment, net $ 22,191 52 15 $ 22,720 56 88 $ 23,348 57 62 $ 24,069 58 58 $ 24,448 60 34 Goodwill $ 2,102 4 94 $ 1,353 3 39 $ 1,289 3 18 $ 1,170 2 85 $ 1,120 2 76 Other long term assets $ 1,263 2 97 $ 571 1 43 $ 602 1 49 $ 473 1 15 $ 430 1 06 Total non current assets $ 25,556 60 06 $ 24,644 61 69 $ 25,239 62 29 $ 25,712 62 58 $ 25,998 64 16 Total assets $ 42,549 100 00 $ 39,946 100 00 $ 40,518 100 00 $ 41,084 100 00 $ 40,518 100 00 Liabilities and stockholders' equity Liabilities Current liabilities Short term debt $ 427 1 00 $ 328 0 82 $ 33 0 08 $ 1,321 3 22 $ 30 0 07 Accounts payable $ 6,565 15 43 $ 5,807 14 54 $ 5,797 14 31 $ 5,376 13 09 $ 4,856 11 98 Taxes payable $ 510 1 20 $ 469 1 17 $ 408 1 01 $ 494 1 20 $ 414 1 02 Accrued liabilities $ 3,458 8 13 $ 3,197 8 00 $ 3,174 7 83 $ 3,001 7 30 $ 2,929 7 23 Deferred revenues $ 1,566 3 68 $ 1,468 3 67 $ 1,337 3 30 $ 1,270 3 09 $ 1,147 2 83 Total current liabilities $ 12,526 29 44 $ 11,269 28 21 $ 10,749 26 53 $ 11,462 27 90 $ 9,376 23 14 Non current liabilities Long term debt $ 20,888 49 09 $ 16,869 42 23 $ 14,691 36 26 $ 9,475 23 06 $ 10,758 26 55 Deferred taxes liabilities $ 854 2 01 $ 642 1 61 $ 514 1 27 $ 319 0 78 $ 340 0 84 Other long term liabilities $ 1,965 4 62 $ 1,844 4 62 $ 2,042 5 04 $ 2,051 4 99 $ 2,146 5 30 Total non current liabilities $ 23,707 55 72 $ 19,355 48 45 $ 17,247 42 57 $ 11,845 28 83 $ 13,244 32 69 Total liabilities $ 36,233 85 16 $ 30,624 76 66 $ 27,996 69 10 $ 23,307 56 73 $ 22,620 55 83 Stockholders' equity Common stock $ 88 0 21 $ 88 0 22 $ 88 0 22 $ 88 0 21 $ 87 0 21 Additional paid in capital $ 9,347 21 97 $ 8,885 22 24 $ 8,402 20 74 $ 7,948 19 35 $ 6,966 17 19 Retained earnings $ 30,973 72 79 $ 26,995 67 58 $ 23,180 57 21 $ 20,038 48 77 $ 17,246 42 56 Treasury stock $ (33,194) 78 01 $ (26,194) 65 57 $ (19,194) 47 37 $ (10,694) 26 03 $ (6,694) 16 52 Accumulated other comprehensive income $ (898) 2 11 $ (452) 1 13 $ 46 0 11 $ 397 0 97 $ 293 0 72 Total stockholders' equity $ 6,316 14 84 $ 9,322 23 34 $ 12,522 30 90 $ 17,777 43 27 $ 17,898 44 17 Total liabilities and stockholders' equity $ 42,549 100 00 $ 39,946 100 00 $ 40,518 100 00 $ 41,084 100 00 $ 40,518 100 00 THE HOME DEPOT INC (HD) BALANCE SHEET Fiscal year ends in January USD in millions except per share data Horizontal Analysis of Balance Sheet 2016 01 2015 01 2014 01 2013 01 2012 01 $ $ $ $ $ Assets Current assets Cash Cash and cash equivalents $ 2,216 128 61 $ 1,723 89 32 $ 1,929 77 35 $ 2,494 125 52 $ 1,987 100 00 Total cash $ 2,216 128 61 $ 1,723 89 32 $ 1,929 77 35 $ 2,494 125 52 $ 1,987 100 00 Receivables $ 1,890 127 36 $ 1,484 106 15 $ 1,398 100 22 $ 1,395 112 05 $ 1,245 100 00 Inventories $ 11,809 106 59 $ 11,079 100 20 $ 11,057 103 24 $ 10,710 103 73 $ 10,325 100 00 Other current assets $ 1,078 106 10 $ 1,016 113 52 $ 895 115 78 $ 773 80 27 $ 963 100 00 Total current assets $ 16,993 111 05 $ 15,302 100 15 $ 15,279 99 40 $ 15,372 105 87 $ 14,520 100 00 Non current assets Property, plant and equipment Land $ 8,149 98 86 $ 8,243 98 42 $ 8,375 98 70 $ 8,485 100 06 $ 8,480 100 00 Fixtures and equipment $ 10,279 107 05 $ 9,602 95 00 $ 10,107 108 24 $ 9,338 93 01 $ 10,040 100 00 Other properties $ 20,838 100 82 $ 20,668 100 42 $ 20,582 99 58 $ 20,668 101 04 $ 20,455 100 00 Property and equipment, at cost $ 39,266 101 96 $ 38,513 98 59 $ 39,064 101 49 $ 38,491 98 76 $ 38,975 100 00 Accumulated Depreciation $ (17,075) 108 12 $ (15,793) 100 49 $ (15,716) 108 97 $ (14,422) 99 28 $ (14,527) 100 00 Property, plant and equipment, net $ 22,191 97 67 $ 22,720 97 31 $ 23,348 97 00 $ 24,069 98 45 $ 24,448 100 00 Goodwill $ 2,102 155 36 $ 1,353 104 97 $ 1,289 110 17 $ 1,170 104 46 $ 1,120 100 00 Other long term assets $ 1,263 221 19 $ 571 94 85 $ 602 127 27 $ 473 110 00 $ 430 100 00 Total non current assets $ 25,556 103 70 $ 24,644 97 64 $ 25,239 98 16 $ 25,712 98 90 $ 25,998 100 00 Total assets $ 42,549 106 52 $ 39,946 98 59 $ 40,518 98 62 $ 41,084 101 40 $ 40,518 100 00 Liabilities and stockholders' equity Liabilities Current liabilities Short term debt $ 427 130 18 $ 328 993 94 $ 33 2 50 $ 1,321 4403 33 $ 30 100 00 Accounts payable $ 6,565 113 05 $ 5,807 100 17 $ 5,797 107 83 $ 5,376 110 71 $ 4,856 100 00 Taxes payable $ 510 108 74 $ 469 114 95 $ 408 82 59 $ 494 119 32 $ 414 100 00 Accrued liabilities $ 3,458 108 16 $ 3,197 100 72 $ 3,174 105 76 $ 3,001 102 46 $ 2,929 100 00 Deferred revenues $ 1,566 106 68 $ 1,468 109 80 $ 1,337 105 28 $ 1,270 110 72 $ 1,147 100 00 Total current liabilities $ 12,526 111 15 $ 11,269 104 84 $ 10,749 93 78 $ 11,462 122 25 $ 9,376 100 00 Non current liabilities Long term debt $ 20,888 123 82 $ 16,869 114 83 $ 14,691 155 05 $ 9,475 88 07 $ 10,758 100 00 Deferred taxes liabilities $ 854 133 02 $ 642 124 90 $ 514 161 13 $ 319 93 82 $ 340 100 00 Other long term liabilities $ 1,965 106 56 $ 1,844 90 30 $ 2,042 99 56 $ 2,051 95 57 $ 2,146 100 00 Total non current liabilities $ 23,707 122 49 $ 19,355 112 22 $ 17,247 145 61 $ 11,845 89 44 $ 13,244 100 00 Total liabilities $ 36,233 118 32 $ 30,624 109 39 $ 27,996 120 12 $ 23,307 103 04 $ 22,620 100 00 Stockholders' equity Common stock $ 88 100 00 $ 88 100 00 $ 88 100 00 $ 88 101 15 $ 87 100 00 Additional paid in capital $ 9,347 105 20 $ 8,885 105 75 $ 8,402 105 71 $ 7,948 114 10 $ 6,966 100 00 Retained earnings $ 30,973 114 74 $ 26,995 116 46 $ 23,180 115 68 $ 20,038 116 19 $ 17,246 100 00 Treasury stock $ (33,194) 126 72 $ (26,194) 136 47 $ (19,194) 179 48 $ (10,694) 159 76 $ (6,694) 100 00 Accumulated other comprehensive income $ (898) 198 67 $ (452) 982 61 $ 46 11 59 $ 397 135 49 $ 293 100 00 Total stockholders' equity $ 6,316 67 75 $ 9,322 74 44 $ 12,522 70 44 $ 17,777 99 32 $ 17,898 100 00 Total liabilities and stockholders' equity $ 42,549 106 52 $ 39,946 98 59 $ 40,518 98 62 $ 41,084 101 40 $ 40,518 100 00 HOME DEPOT INC LONG TERM DEBT PAYING RATIOS Formula 2016 2015 2014 2013 2012 Times Interest earned EBIT Interest expense 12 81 12 61 12 89 12 29 10 99 Debt Ratio Total Liabilities Total Assets 0 85 0 77 0 69 Long term debt to total capitalization ratio Long term Debt (Long term debt preferred equity Common Equity) 0 54 0 47 0 41 long term Debt to Equity Ratio Long term debt (preferred equity Common Equity) 3 62 2 01 1 34 Debt to Tangible net worth ratio Total Liabilities (Shareholders' equity intangible assets) 8 60 3 84 2 49 2 HOME DEPOT INC LIQUIDITY RATIOS Formula 2016 2015 2014 2013 2012 Quick Ratio (Total Current Assets Inventory Prepaid expenses) Total Current Liabilities 0 41 0 37 0 39 Current ratio Current Assets Current Liabilities 1 36 1 36 1 42 Working Capital ratio (Current Assets Current Liabilities) Current Liabilities 0 36 0 36 0 42 Accounts receivable turnover ratio Net Sales Average Accounts receivable 33 63 38 10 56 37 Inventory Turnover ratio Cost of Goods sold Average Inventory 5 10 5 01 7 13

The Answer is in the image, click to view ...

Question: 300 or more words on a competitor analysis and comparison to the following informationincome statement, balance sheet, statement of cash flows, horizontal analysis, vertical analysis,

300 or more words on a competitor analysis and comparison to the following informationincome statement, balance sheet, statement of cash flows, horizontal analysis, vertical analysis, and ratio analysis

THE HOME DEPOT INC (HD) INCOME STATEMENT
Fiscal year ends in January. USD in millions except per share data.

Vertical Analysis of Income Statement	2016-01		2015-01		2014-01		2013-01		2012-01
Vertical Analysis of Income Statement	$	%	$	%	$	%	$	%	$	%
Revenue	$ 88,519	100.00%	$ 83,176	100.00%	$ 78,812	100.00%	$ 74,754	100.00%	$ 70,395	100.00%
Cost of revenue	$ 58,254	65.81%	$ 54,222	65.19%	$ 51,422	65.25%	$ 48,912	65.43%	$ 46,133	65.53%
Gross profit	$ 30,265	34.19%	$ 28,954	34.81%	$ 27,390	34.75%	$ 25,842	34.57%	$ 24,262	34.47%
Operating expenses
Sales, General and administrative	$ 16,801	18.98%	$ 16,834	20.24%	$ 16,597	21.06%	$ 16,508	22.08%	$ 16,028	22.77%
Other operating expenses	$ 1,690	1.91%	$ 1,651	1.98%	$ 1,627	2.06%	$ 1,568	2.10%	$ 1,573	2.23%
Total operating expenses	$ 18,491	20.89%	$ 18,485	22.22%	$ 18,224	23.12%	$ 18,076	24.18%	$ 17,601	25.00%
Operating income	$ 11,774	13.30%	$ 10,469	12.59%	$ 9,166	11.63%	$ 7,766	10.39%	$ 6,661	9.46%
Interest Expense	$ 919	1.04%	$ 830	1.00%	$ 711	0.90%	$ 632	0.85%	$ 606	0.86%
Other income (expense)	$ 166	0.19%	$ 337	0.41%	$ 12	0.02%	$ 87	0.12%	$ 13	0.02%
Income before income taxes	$ 11,021	12.45%	$ 9,976	11.99%	$ 8,467	10.74%	$ 7,221	9.66%	$ 6,068	8.62%
Provision for income taxes	$ 4,012	4.53%	$ 3,631	4.37%	$ 3,082	3.91%	$ 2,686	3.59%	$ 2,185	3.10%
Net income from continuing operations	$ 7,009	7.92%	$ 6,345	7.63%	$ 5,385	6.83%	$ 4,535	6.07%	$ 3,883	5.52%
Net income	$ 7,009	7.92%	$ 6,345	7.63%	$ 5,385	6.83%	$ 4,535	6.07%	$ 3,883	5.52%
Earnings per share
Basic	$ 5.49		$ 4.74		$ 3.78		$ 3.03		$ 2.49
Diluted	$ 5.46		$ 4.71		$ 3.76		$ 3.00		$ 2.47
Weighted average shares outstanding
Basic	$ 1,277		$ 1,338		$ 1,425		$ 1,499		$ 1,562
Diluted	$ 1,283		$ 1,346		$ 1,434		$ 1,511		$ 1,570
EBITDA	$ 13,803	15.59%	$ 12,592	15.14%	$ 10,935	13.87%	$ 9,537	12.76%	$ 8,356	11.87%

THE HOME DEPOT INC (HD) INCOME STATEMENT

Fiscal year ends in January. USD in millions except per share data.

Horizontal Analysis of Income Statement

2016-01

2015-01

2014-01

2013-01

2012-01

Revenue

$ 88,519

106.42%

$ 83,176

105.54%

$ 78,812

105.43%

$ 74,754

106.19%

$ 70,395

100.00%

Cost of revenue

$ 58,254

107.44%

$ 54,222

105.45%

$ 51,422

105.13%

$ 48,912

106.02%

$ 46,133

100.00%

Gross profit

$ 30,265

104.53%

$ 28,954

105.71%

$ 27,390

105.99%

$ 25,842

106.51%

$ 24,262

100.00%

Operating expenses

Sales, General and administrative

$ 16,801

99.80%

$ 16,834

101.43%

$ 16,597

100.54%

$ 16,508

102.99%

$ 16,028

100.00%

Other operating expenses

$ 1,690

102.36%

$ 1,651

101.48%

$ 1,627

103.76%

$ 1,568

99.68%

$ 1,573

100.00%

Total operating expenses

$ 18,491

100.03%

$ 18,485

101.43%

$ 18,224

100.82%

$ 18,076

102.70%

$ 17,601

100.00%

Operating income

$ 11,774

112.47%

$ 10,469

114.22%

$ 9,166

118.03%

$ 7,766

116.59%

$ 6,661

100.00%

Interest Expense

$ 919

110.72%

$ 830

116.74%

$ 711

112.50%

$ 632

104.29%

$ 606

100.00%

Other income (expense)

$ 166

49.26%

$ 337

2808.33%

$ 12

13.79%

$ 87

669.23%

$ 13

100.00%

Income before income taxes

$ 11,021

110.48%

$ 9,976

117.82%

$ 8,467

117.26%

$ 7,221

119.00%

$ 6,068

100.00%

Provision for income taxes

$ 4,012

110.49%

$ 3,631

117.81%

$ 3,082

114.74%

$ 2,686

122.93%

$ 2,185

100.00%

Net income from continuing operations

$ 7,009

110.46%

$ 6,345

117.83%

$ 5,385

118.74%

$ 4,535

116.79%

$ 3,883

100.00%

Net income

$ 7,009

110.46%

$ 6,345

117.83%

$ 5,385

118.74%

$ 4,535

116.79%

$ 3,883

100.00%

Earnings per share

Basic

$ 5.49

115.82%

$ 4.74

125.40%

$ 3.78

124.75%

$ 3.03

121.69%

$ 2.49

100.00%

Diluted

$ 5.46

115.92%

$ 4.71

125.27%

$ 3.76

125.33%

$ 3.00

121.46%

$ 2.47

100.00%

Weighted average shares outstanding

Basic

$ 1,277

95.44%

$ 1,338

93.89%

$ 1,425

95.06%

$ 1,499

95.97%

$ 1,562

100.00%

Diluted

$ 1,283

95.32%

$ 1,346

93.86%

$ 1,434

94.90%

$ 1,511

96.24%

$ 1,570

100.00%

EBITDA

$ 13,803

109.62%

$ 12,592

115.15%

$ 10,935

114.66%

$ 9,537

114.13%

$ 8,356

100.00%

THE HOME DEPOT INC (HD) BALANCE SHEET
Fiscal year ends in January. USD in millions except per share data.

Vertical Analysis of Balance Sheet	2016-01		2015-01		2014-01		2013-01		2012-01
Vertical Analysis of Balance Sheet	$	%	$	%	$	%	$	%	$	%
Assets
Current assets
Cash
Cash and cash equivalents	$ 2,216	5.21%	$ 1,723	4.31%	$ 1,929	4.76%	$ 2,494	6.07%	$ 1,987	4.90%
Total cash	$ 2,216	5.21%	$ 1,723	4.31%	$ 1,929	4.76%	$ 2,494	6.07%	$ 1,987	4.90%
Receivables	$ 1,890	4.44%	$ 1,484	3.72%	$ 1,398	3.45%	$ 1,395	3.40%	$ 1,245	3.07%
Inventories	$ 11,809	27.75%	$ 11,079	27.73%	$ 11,057	27.29%	$ 10,710	26.07%	$ 10,325	25.48%
Other current assets	$ 1,078	2.53%	$ 1,016	2.54%	$ 895	2.21%	$ 773	1.88%	$ 963	2.38%
Total current assets	$ 16,993	39.94%	$ 15,302	38.31%	$ 15,279	37.71%	$ 15,372	37.42%	$ 14,520	35.84%
Non-current assets
Property, plant and equipment
Land	$ 8,149	19.15%	$ 8,243	20.64%	$ 8,375	20.67%	$ 8,485	20.65%	$ 8,480	20.93%
Fixtures and equipment	$ 10,279	24.16%	$ 9,602	24.04%	$ 10,107	24.94%	$ 9,338	22.73%	$ 10,040	24.78%
Other properties	$ 20,838	48.97%	$ 20,668	51.74%	$ 20,582	50.80%	$ 20,668	50.31%	$ 20,455	50.48%
Property and equipment, at cost	$ 39,266	92.28%	$ 38,513	96.41%	$ 39,064	96.41%	$ 38,491	93.69%	$ 38,975	96.19%
Accumulated Depreciation	$ (17,075)	-40.13%	$ (15,793)	-39.54%	$ (15,716)	-38.79%	$ (14,422)	-35.10%	$ (14,527)	-35.85%
Property, plant and equipment, net	$ 22,191	52.15%	$ 22,720	56.88%	$ 23,348	57.62%	$ 24,069	58.58%	$ 24,448	60.34%
Goodwill	$ 2,102	4.94%	$ 1,353	3.39%	$ 1,289	3.18%	$ 1,170	2.85%	$ 1,120	2.76%
Other long-term assets	$ 1,263	2.97%	$ 571	1.43%	$ 602	1.49%	$ 473	1.15%	$ 430	1.06%
Total non-current assets	$ 25,556	60.06%	$ 24,644	61.69%	$ 25,239	62.29%	$ 25,712	62.58%	$ 25,998	64.16%
Total assets	$ 42,549	100.00%	$ 39,946	100.00%	$ 40,518	100.00%	$ 41,084	100.00%	$ 40,518	100.00%

Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	$ 427	1.00%	$ 328	0.82%	$ 33	0.08%	$ 1,321	3.22%	$ 30	0.07%
Accounts payable	$ 6,565	15.43%	$ 5,807	14.54%	$ 5,797	14.31%	$ 5,376	13.09%	$ 4,856	11.98%
Taxes payable	$ 510	1.20%	$ 469	1.17%	$ 408	1.01%	$ 494	1.20%	$ 414	1.02%
Accrued liabilities	$ 3,458	8.13%	$ 3,197	8.00%	$ 3,174	7.83%	$ 3,001	7.30%	$ 2,929	7.23%
Deferred revenues	$ 1,566	3.68%	$ 1,468	3.67%	$ 1,337	3.30%	$ 1,270	3.09%	$ 1,147	2.83%
Total current liabilities	$ 12,526	29.44%	$ 11,269	28.21%	$ 10,749	26.53%	$ 11,462	27.90%	$ 9,376	23.14%
Non-current liabilities
Long-term debt	$ 20,888	49.09%	$ 16,869	42.23%	$ 14,691	36.26%	$ 9,475	23.06%	$ 10,758	26.55%
Deferred taxes liabilities	$ 854	2.01%	$ 642	1.61%	$ 514	1.27%	$ 319	0.78%	$ 340	0.84%
Other long-term liabilities	$ 1,965	4.62%	$ 1,844	4.62%	$ 2,042	5.04%	$ 2,051	4.99%	$ 2,146	5.30%
Total non-current liabilities	$ 23,707	55.72%	$ 19,355	48.45%	$ 17,247	42.57%	$ 11,845	28.83%	$ 13,244	32.69%
Total liabilities	$ 36,233	85.16%	$ 30,624	76.66%	$ 27,996	69.10%	$ 23,307	56.73%	$ 22,620	55.83%

Stockholders' equity
Common stock	$ 88	0.21%	$ 88	0.22%	$ 88	0.22%	$ 88	0.21%	$ 87	0.21%
Additional paid-in capital	$ 9,347	21.97%	$ 8,885	22.24%	$ 8,402	20.74%	$ 7,948	19.35%	$ 6,966	17.19%
Retained earnings	$ 30,973	72.79%	$ 26,995	67.58%	$ 23,180	57.21%	$ 20,038	48.77%	$ 17,246	42.56%
Treasury stock	$ (33,194)	-78.01%	$ (26,194)	-65.57%	$ (19,194)	-47.37%	$ (10,694)	-26.03%	$ (6,694)	-16.52%
Accumulated other comprehensive income	$ (898)	-2.11%	$ (452)	-1.13%	$ 46	0.11%	$ 397	0.97%	$ 293	0.72%
Total stockholders' equity	$ 6,316	14.84%	$ 9,322	23.34%	$ 12,522	30.90%	$ 17,777	43.27%	$ 17,898	44.17%
Total liabilities and stockholders' equity	$ 42,549	100.00%	$ 39,946	100.00%	$ 40,518	100.00%	$ 41,084	100.00%	$ 40,518	100.00%

THE HOME DEPOT INC (HD) BALANCE SHEET
Fiscal year ends in January. USD in millions except per share data.

Horizontal Analysis of Balance Sheet	2016-01		2015-01		2014-01		2013-01		2012-01
Horizontal Analysis of Balance Sheet	$	%	$	%	$	%	$	%	$	%
Assets
Current assets
Cash
Cash and cash equivalents	$ 2,216	128.61%	$ 1,723	89.32%	$ 1,929	77.35%	$ 2,494	125.52%	$ 1,987	100.00%
Total cash	$ 2,216	128.61%	$ 1,723	89.32%	$ 1,929	77.35%	$ 2,494	125.52%	$ 1,987	100.00%
Receivables	$ 1,890	127.36%	$ 1,484	106.15%	$ 1,398	100.22%	$ 1,395	112.05%	$ 1,245	100.00%
Inventories	$ 11,809	106.59%	$ 11,079	100.20%	$ 11,057	103.24%	$ 10,710	103.73%	$ 10,325	100.00%
Other current assets	$ 1,078	106.10%	$ 1,016	113.52%	$ 895	115.78%	$ 773	80.27%	$ 963	100.00%
Total current assets	$ 16,993	111.05%	$ 15,302	100.15%	$ 15,279	99.40%	$ 15,372	105.87%	$ 14,520	100.00%
Non-current assets
Property, plant and equipment
Land	$ 8,149	98.86%	$ 8,243	98.42%	$ 8,375	98.70%	$ 8,485	100.06%	$ 8,480	100.00%
Fixtures and equipment	$ 10,279	107.05%	$ 9,602	95.00%	$ 10,107	108.24%	$ 9,338	93.01%	$ 10,040	100.00%
Other properties	$ 20,838	100.82%	$ 20,668	100.42%	$ 20,582	99.58%	$ 20,668	101.04%	$ 20,455	100.00%
Property and equipment, at cost	$ 39,266	101.96%	$ 38,513	98.59%	$ 39,064	101.49%	$ 38,491	98.76%	$ 38,975	100.00%
Accumulated Depreciation	$ (17,075)	108.12%	$ (15,793)	100.49%	$ (15,716)	108.97%	$ (14,422)	99.28%	$ (14,527)	100.00%
Property, plant and equipment, net	$ 22,191	97.67%	$ 22,720	97.31%	$ 23,348	97.00%	$ 24,069	98.45%	$ 24,448	100.00%
Goodwill	$ 2,102	155.36%	$ 1,353	104.97%	$ 1,289	110.17%	$ 1,170	104.46%	$ 1,120	100.00%
Other long-term assets	$ 1,263	221.19%	$ 571	94.85%	$ 602	127.27%	$ 473	110.00%	$ 430	100.00%
Total non-current assets	$ 25,556	103.70%	$ 24,644	97.64%	$ 25,239	98.16%	$ 25,712	98.90%	$ 25,998	100.00%
Total assets	$ 42,549	106.52%	$ 39,946	98.59%	$ 40,518	98.62%	$ 41,084	101.40%	$ 40,518	100.00%

Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt	$ 427	130.18%	$ 328	993.94%	$ 33	2.50%	$ 1,321	4403.33%	$ 30	100.00%
Accounts payable	$ 6,565	113.05%	$ 5,807	100.17%	$ 5,797	107.83%	$ 5,376	110.71%	$ 4,856	100.00%
Taxes payable	$ 510	108.74%	$ 469	114.95%	$ 408	82.59%	$ 494	119.32%	$ 414	100.00%
Accrued liabilities	$ 3,458	108.16%	$ 3,197	100.72%	$ 3,174	105.76%	$ 3,001	102.46%	$ 2,929	100.00%
Deferred revenues	$ 1,566	106.68%	$ 1,468	109.80%	$ 1,337	105.28%	$ 1,270	110.72%	$ 1,147	100.00%
Total current liabilities	$ 12,526	111.15%	$ 11,269	104.84%	$ 10,749	93.78%	$ 11,462	122.25%	$ 9,376	100.00%
Non-current liabilities
Long-term debt	$ 20,888	123.82%	$ 16,869	114.83%	$ 14,691	155.05%	$ 9,475	88.07%	$ 10,758	100.00%
Deferred taxes liabilities	$ 854	133.02%	$ 642	124.90%	$ 514	161.13%	$ 319	93.82%	$ 340	100.00%
Other long-term liabilities	$ 1,965	106.56%	$ 1,844	90.30%	$ 2,042	99.56%	$ 2,051	95.57%	$ 2,146	100.00%
Total non-current liabilities	$ 23,707	122.49%	$ 19,355	112.22%	$ 17,247	145.61%	$ 11,845	89.44%	$ 13,244	100.00%
Total liabilities	$ 36,233	118.32%	$ 30,624	109.39%	$ 27,996	120.12%	$ 23,307	103.04%	$ 22,620	100.00%

Stockholders' equity
Common stock	$ 88	100.00%	$ 88	100.00%	$ 88	100.00%	$ 88	101.15%	$ 87	100.00%
Additional paid-in capital	$ 9,347	105.20%	$ 8,885	105.75%	$ 8,402	105.71%	$ 7,948	114.10%	$ 6,966	100.00%
Retained earnings	$ 30,973	114.74%	$ 26,995	116.46%	$ 23,180	115.68%	$ 20,038	116.19%	$ 17,246	100.00%
Treasury stock	$ (33,194)	126.72%	$ (26,194)	136.47%	$ (19,194)	179.48%	$ (10,694)	159.76%	$ (6,694)	100.00%
Accumulated other comprehensive income	$ (898)	198.67%	$ (452)	-982.61%	$ 46	11.59%	$ 397	135.49%	$ 293	100.00%
Total stockholders' equity	$ 6,316	67.75%	$ 9,322	74.44%	$ 12,522	70.44%	$ 17,777	99.32%	$ 17,898	100.00%
Total liabilities and stockholders' equity	$ 42,549	106.52%	$ 39,946	98.59%	$ 40,518	98.62%	$ 41,084	101.40%	$ 40,518	100.00%

HOME DEPOT INC
LONG-TERM DEBT PAYING RATIOS
	Formula	2016	2015	2014	2013	2012
Times Interest earned	EBIT/ Interest expense	12.81	12.61	12.89	12.29	10.99
Debt Ratio	Total Liabilities/ Total Assets	0.85	0.77	0.69
Long term debt to total capitalization ratio	Long term Debt/ (Long term debt + preferred equity + Common Equity)	0.54	0.47	0.41
long term Debt to Equity Ratio	Long term debt/ (preferred equity + Common Equity)	3.62	2.01	1.34
Debt to Tangible net worth ratio	Total Liabilities/ (Shareholders' equity - intangible assets)	8.60	3.84	2.49

HOME DEPOT INC
LIQUIDITY RATIOS
	Formula	2016	2015	2014	2013	2012
Quick Ratio	(Total Current Assets - Inventory - Prepaid expenses)/ Total Current Liabilities	0.41	0.37	0.39
Current ratio	Current Assets/ Current Liabilities	1.36	1.36	1.42
Working Capital ratio	(Current Assets - Current Liabilities)/ Current Liabilities	0.36	0.36	0.42
Accounts receivable turnover ratio	Net Sales/ Average Accounts receivable	33.63	38.10	56.37
Inventory Turnover ratio	Cost of Goods sold/ Average Inventory	5.10	5.01	7.13

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

On January 1, 20Y1 Caitlin Corporation issued $10 million in 10-year bonds. The bonds pay 7% interest annually on December 31. At issuance, the market rate of interest for bonds of comparable risk...

Any company financial statement (Carnival, Bank of America, Boeing) listed on the United States stock exchange . The following companies should not be selected: Walmart, Amazon, Apple, Johnson &...

1. Financial Statement Analysis Obtain the companys financial statements (Income Statement, Balance Sheet, and Cash Flow Statement) 2. Financial Ration Analysis. Please calculate the following...

I need help with projecting income statement, balance sheet and Cash flows. See attache Current assets: Cash and cash equivalents Marketable securities Inventories Accounts receivable, net and other...

Rajesh Vyas, a financial advisor at a brokerage firm in Mumbai, is tasked with assessing the financial performance and future of Amtek Auto, an integrated automotive component manufacturer...

Overview You have just started an internship at Workshire Bathaway (or WB"), a large and very successful conglomerate in New York. You cannot believe your good fortune at working and learning at such...

just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question 2..BTW,please focus the every step FINANCE SPOTLIGHT...

can any expert help me with the below assignment just only 2 questions ,please read the requirment word by word and be careful about the style of the reference(APA) , file 3.1 is for question...

Please see below the project description i discussed a few weeks back. Please review this and let me know what the cost would be. I have enjoyed your work so far so i look forward to working with you...

Need help with Part A and Part B Purpose: The purposes of this assignment are to introduce you to the concepts of financial statements analysis, to help you develop knowledge and skills associated...

ACCT 2101 Financial Statement Analysis Group Project Activity for Ch 9 MULTIPLE DUE DATES - SEE D2L Purpose: The purposes of this assignment are to introduce you to the concepts of financial...

Workers at Banner News were paid a total of $33,400 during the month of July. The company's standard wage rate was $8 per hour, and the direct labor rate variance for the month was $1,400 U. Required...

Xing, Inc., purchases a delivery truck on January 1 for $25,000. The truck has an estimated useful life of five years and an estimated salvage value of $2,500. Required For both the straight-line and...

Which one of the following statements about a budget is true? Group of answer choices It is usually general and not specific. It continues post the end of stated period. It is developed for only a...

A gourmet oil shop, sells three blends of olive oil-basil-pepper, mint-pepper, basil-mint-pepper. They use three types of oil to make the three blends. Although the recipes for the three blends are...

9. Consider a salt solution of unknown concentration. 1. In the laboratory you weigh an empty vial and determine the mass to be 14.096 g. You then measure out exactly 9.95 ml of the salt solution and...

Solve the matrix equation Ax 0. (If there is no solution, enter NO SOLUTION. If the system has an infinite number of solutions, express x1, X2, and x3 in terms of the parameter t.) X1 - [:] 3 -1 -1 A...

af: A transfumation a one-to-cne (onto) function ( mapping ) whase image aud domain are the same set. ag: Rotatiom : C>C >e (Ex: check that this i a trausfuatin) prove rotation this is a...

Q) Is there any difference in the construct validity of reflective and formative constructs? If yes then what are these describe in points.

Which of the following is NOT true about smaller batch size?

=+Let the idea drive the media, not the media drive the idea. It's purifying. What are you trying to say? What can this campaign do to get attention? Rather than what kind of ad can I do for Domino's?

=+1. Craig Miller, creative director at Crispin, Porter + Bogusky: We used to know what it was going to be: TV, radio, and so on, now I have no idea what it's going to be. It's back to the core idea.

2 What difference in attitude towards employees might be denoted by one professional adopting the title personnel manager and another the title human resource manager?