Question

Home Depot Inc. Dollar amounts in Miltions Jan. 2a 2016 | Jan. 29,20171 Balance Sheets 4 Current assets: Jn2g 2018- Jan. 29, 2017 Cash and cash equivalents 6 Receivables, net $2,538 2,029 12,549 608 3,595 1,952 2,748 8 Other aurrent assets Total current assets 10 11 Net property and equipment 12 Goodwi 13 Other assets 933 22,075 2,275 1,246 44,529 21,914 2,093 4957% 611% 4 Total assets 966 16 Current Liabilities 17 Short-term debt 18 Accounts payable 19 Accrued salaries and related 20 Sales taxes payable 21 Delerred revenue 1,559 7,244 1,640 520 1,484 508 1669 25 542 195 2 Income taxes payable 54 1,202 170 Current instalments of long-term debt 24 Other accrued expenses 25 Total current liablities 27 Long-term debt, excluding current installments 28 Deferred income taxes 22,349 296 24,267 440 54.50 Other long-term liabilities 4 88 30 Total Eabilities Common stock, par value $0.05, authorized: 10,000 shares, issued: 1,780 shares at January 28, 89 2018 and 1,776 shares at January 29, 2017 020% 22 89% 99 68% 0 20% 22 78% 82 67% 33 Paid-in capital 10,192 39,935 566 9,787 35,519 867 14 Retained eamings Accumulated other comprehensive loss 36 Treasury stock, at cost, 622 shares at January 28, 2018 and 573 shares at January 29, 2017 7 Total stockholders equity -93 55% 10 08% 38 Total liabilities and stockholders equity
12 Months Ended in Millions $ Home Depot, Inc. Common Size Statement of Earnings Jan. 28, 2018 Jan. 29, 2017 Jan. 31 2016 $100,904.た Net sales Cost of sales Gross proft Operating expenses Selling, general and administrative Depreciation and amortization Total operating expenses Operating income Interest and other (income) expense: Interest and investment income Interest expense Interest and other, net Earnings before provision for income taxes Provision for income taxes Net earnings 594,595 :- $ 88,519 58,254 66,548 62 282 32,313 356 17,132 16,801 1690 18,491 11,774 17,864 1.754 18,886 13,427 1.811 14,681 74 983 36 972 936 12,491 4,534 S 7,957 -166 919 1,057 A 13,698 11,021 4.012 $ 8,630
Home Depot Inc. 1 2 in Millions Total Assets 2016 $41,973 Total Stockholders equity 2016 $6,316 Jan. 28, 2018 Jan 29, 2017 7 1. Current ratio 8 2. Liabilities-to-equity 9 3. Times interest earned 10 percentage 11 percentage 4. Return on Equity-shown as a 5. Profit Margin-Shown as a 12 6. Asset Turnover 13 7. Financial Leverage 8. Redo your Return on Equity calculation by calculating Profit MarginAsset Tumover Financial 14 Leverage.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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)

Add a comment
Know the answer?
Add Answer to:
Home Depot Inc. Dollar amounts in Miltions Jan. 2a 2016 | Jan. 29,20171 Balance Sheets 4...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Home Depot Inc. Common-Size Balance Sheets Dollar amounts in Millions Jan. 28, 2018 Jan. 29, 2017...

    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...

    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 A...

    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...

    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...

    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...

    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...

    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...

    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,...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT