#2 Using the two provided Sheets construct a Ratio Table with the following Ratios

Profitability Ratios

Return on assets (ROA)

Return on capital (ROC)

Return on equity (ROE)

Operating profit margin

Efficiency Ratios

Asset Turnover

Fixed-asset turnover

Receivables turnover

Average collection period (days)

Inventory turnover

Days in inventory

Leverage Ratios

Long-term debt ratio

Long-term debt-equity ratio

Total debt ratio

Times interest earned

Liquidity Ratios

Net working capital to assets

Current ratio

Quick ratio

Cash ratio

• Use only the 2019 information (which is available on January 31 or February 2, 2020). You don't need the 2018 information even when you need the average. Just use the 2019 numbers.
• If you can't find any specific accounts, consider it as zero or N.A. (not available).

nome vepol in. Consolidated Income Statement Jan 31, 2016 88,519 (58,254) 30,265 (16,801) (1,690) Feb 1, 2015 83,176 (54,222) 28,954 (16,834) (1,651) US$ in millions 12 months ended: Feb 2, 2020 Feb 3, 2019 Jan 28, 2018 Jan 29, 2017 Net sales 110,225 108,203 100,904 94,595 Cost of sales (72,653) (71,043) (66,548) (62,282) Gross profit 37,572 37,160 34,356 32,313 Selling, general and administrative (19,740) (19,513) (17,864) (17,132) Depreciation and amortization (1,989) (1,870) (1,811) (1,754) Impairment loss (247) Operating expenses (21,729) (21,630) (19,675) (18,886) Operating income 15,843 15,530 14,681 13,427 Interest and investment income 73 93 74 36 Interest expense (1,201) (1,051) (1,057) (972) Other (16) Interest and other, net (1,128) (974) (983) (936) Earnings before provision for income taxes 14,715 14,556 13,698 12,491 Provision for income taxes (3,473) (3,435) (5,068) (4,534) Net earnings 11,242 11,121 8,630 7,957 Based on:10-K (filing date: 2020-03-25), 10-K (filing date: 2019-03-28), 10-K (filing date: 2018-03-22),10-K (filing date: 2017-03-23),10-K (filing date: 2016-03-24),10-K (filing date: 2015-03-26). (18,491) 11,774 166 (919) (18,485) 10,469 337 (830) (753) 11,021 (4,012) 7,009 (493) 9,976 (3,631) 6,345 Home Depot Inc. Consolidated Balance Sheet: Assets US$ in millions 31-Jan-20 31-Jan-19 $ 1,778 1,936 13,925 890 2,133 $ 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 31,426 51,236 $ 18,529 22,375 2,252 847 25,474 44,003 $ $ Assets: Cash and cash equivalents Receivables, net Merchandise inventories Other current assets Total current assets Net property and equipment Operating lease right-of-use assets Goodwill Other assets Total fixed assets Total assets Liabilities: Payables and accrued expenses Current debt and capital obligations Current deferred liabilities Current liablities Other current liabilities Total current liabilities Long term debt and capital obligations Non current deferred liabilities Other non current liabilities Total non current liabilties Total liabilities Stockholder's Equity: Capital stock Additional paid in capital Retained earnings Treasury stock Gains losses not affecting Total stockholder's equity 12,618 $ 3,641 2,116 18,375 5,453 23,828 33,736 706 1,535 35,977 54,352 $ 12,539 2,395 1,782 16,716 5,060 21,776 26,807 491 1,867 29,165 45,881 $ $ 89 $ 11,001 51,729 (65,196) (739) (3,116) $ 89 10,578 46,423 (58,196) (772) (1,878) $