Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can someone help me create a ratio table for Home Depot using 2019's data? The income statements and balance sheet is attached. I have also

Can someone help me create a ratio table for Home Depot using 2019's data? The income statements and balance sheet is attached. I have also attached what I need to fill out.image text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed

Home Depot Balance Sheet: Assets US$ in millions 31-Jan-20 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 $ 2,133 2,106 14,531 1,040 19,810 22,770 5,595 2,254 807 31,426 $ 51,236 $ 12,618 3,641 2,116 18,375 5,453 23,828 33,736 706 1,535 35,977 $ 54,352 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 $ 89 11,001 51,729 (65,196) (739) $ (3,116) Home Depot Inc. Home Depot Income Statement US$ in millions 12 months ended: Feb 2, 2020 110,225 (72,653) 37,572 (19,740) (1,989) Net sales Cost of sales Gross profit Selling, general and administrative Depreciation and amortization Impairment loss Operating expenses Operating income Interest and investment income Interest expense Other Interest and other, net Earnings before provision for income taxes Provision for income taxes Net income (21,729) 15,843 73 (1,201) (1,128) 14,715 (3,473) 11,242 Home Depot 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Finance An Introduction To Accounting And Financial Management

Authors: Louis Gapenski

1st Edition

1567930905, 978-1567930900

More Books

Students also viewed these Finance questions