Following are the ratios for the two years :-
| Ratios | Jan 28, 2018 | Jan 29, 2017 |
| Current ratios = (current asset/current liabilities ) |
1.17 (18933/16194) |
1.25 (17724/14133) |
| Liabilities-to-equity (total liabilities / stockholders equity) |
29.63 (43075/1454) |
8.92 (38633/4333) |
| Times interest earned (EBIT/interest) |
13.89 (14681/1057) |
13.81 (13427/972) |
| Return on equity (Net earning / stockholder equity) |
298.25 % (8630/{(1454+4333)/2} |
149.44 % (7957/{4333+6316)/2} |
| Profit margin (net earning/sales) |
8.55% (8630/100904) |
8.41% (7957/94595) |
| Asset turnover (sales /average asset) |
2.31 (100904/[{44529+42966}/2]) |
2.23 (94595/[{42966+41973}/2] |
| Financial leverage (average asset/average equity) |
15.12 [{(44529+42966)/2}/{(1454+4333)/2}] |
7.98 [{(42966+41973)/2}/{(4333+6316)/2}] |
| Return on equity (profit margin x asset turnover x financial leverage ) |
298.63% (0.0855x2.31x15.12) |
149.66% (0.0841x2.23x7.98) |
Home Depot Inc. Dollar amounts in Miltions Jan. 2a 2016 | Jan. 29,20171 Balance Sheets 4...
Home Depot Inc. Common-Size Balance Sheets Dollar amounts in Millions Jan. 28, 2018 Jan. 29, 2017 Current assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets $ 2,538 2,02 1,952 12,748 638 18,933 608 Net property and equipment Goodwill Other assets Total assets 22,075 2,275 1246 21,914 2,093 1,23 42,966 44,529 Current Liabilities: Short-term debt Accounts payable Accrued salaries and related expenses Sales taxes payable Deferred revenue Income taxes payable Current installments of long-term...
12 Months Ended in Millions $ Percentages Jan. 29, 2017 Home Depot, Inc. Common Size Statement of Earnings Jan. 28, 2018 Jan. 29, 2017 Jan. 31, 2016 Jan. 28, 2018 Jan. 31, 2016 88,519 Net sales Cost of sales Gross profit Operating expenses Sel S 100,904 66,548 S 94,595 62,282 100.00% 100.00% 100.00% 58.254 34.16% 34.19% ling, general and administrative Depreciation and amortization Total operating expenses Operating income Interest and other (income) expense Interest and investment income nterest expense Interest...
THE HOME DEPOT, INC. CONSOLIDATED BALANCE SHEETS February 3, 2019 January 28, 2018 in millions, except per share data Assets Current assets: Cash and cash equivalents 1,778 $ 3,595 Receivables, net 1,936 1,952 Merchandise inventories 13,925 12,748 Other current assets 890 638 Total current assets 18,529 18,933 22,375 Net property and equipment 22,075 Goodwill 2,252 2,275 Other assets 847 1,246 Total assets 44,003 44,529 Liabilities and Stockholders' Equity Current liabilities: 1,339 $ Short-term debt $ 1,559 Accounts payable Accrued salaries...
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. 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...
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...
The following are the consolidated statement of earnings and the balance sheet of Home Depot, Inc and Subsidiaries. THE HOME DEPOT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Year Ended(1) amounts in millions, except per share data January 31, 2016 February 1, 2015 February 2, 2014 NET SALES $ 88,519 $ 83,176 $ 78,812 Cost of Sales 58,254 54,787 51,897 GROSS PROFIT 30,265 28,389 26,915 Operating Expenses: Selling, General and Administrative 16,801 16,280 16,122 Depreciation and Amortization 1,690 1,640...
The following are the consolidated statement of earnings and the balance sheet of Home Depot, Inc and Subsidiaries. THE HOME DEPOT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Year Ended(1) amounts in millions, except per share data January 31, 2016 February 1, 2015 February 2, 2014 NET SALES $ 88,519 $ 83,176 $ 78,812 Cost of Sales 58,254 54,787 51,897 GROSS PROFIT 30,265 28,389 26,915 Operating Expenses: Selling, General and Administrative 16,801 16,280 16,122 Depreciation and Amortization 1,690 1,640...
The following are the consolidated statement of earnings and the balance sheet of Home Depot, Inc and Subsidiaries. THE HOME DEPOT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Year Ended(1) amounts in millions, except per share data January 31, 2016 February 1, 2015 February 2, 2014 NET SALES $ 88,519 $ 83,176 $ 78,812 Cost of Sales 58,254 54,787 51,897 GROSS PROFIT 30,265 28,389 26,915 Operating Expenses: Selling, General and Administrative 16,801 16,280 16,122 Depreciation and Amortization 1,690 1,640...
THE HOME DEPOT, INC. AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF EARNINGS Fiscal Year Ended(1) amounts in millions, except per share data January 31, 2016 February 1, 2015 February 2, 2014 NET SALES $ 88,519 $ 83,176 $ 78,812 Cost of Sales 58,254 54,787 51,897 GROSS PROFIT 30,265 28,389 26,915 Operating Expenses: Selling, General and Administrative 16,801 16,280 16,122 Depreciation and Amortization 1,690 1,640 1,627 Total Operating Expenses 18,491 17,920 17,749 OPERATING INCOME 11,774 10,469 9,166 Interest and Other (Income) Expense: Interest...
Balance sheets and income statements for the home depot inc. and
lowe's companies inc .
1.Compute return on equity, return on assets, and return on
financial leverage for each company in 2014
2. Disaggregate the ROA's computed into profit margin (PM) and
asset turnover (AT) components. Which of these factors drives ROA
for each company?
3. Compute the gross profit margin (GPM) and operating
expense-to-sales ratios for each company. How do these companies'
profitability measures compare?
4. Compute the accounts...