Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the following ratios for Home Depot FOR ALL THREE YEARS: Debt/Leverage: -Times Interest Earned -Debt to Equity -Total Liabilities / Tangible Net Worth (in

Calculate the following ratios for Home Depot FOR ALL THREE YEARS:

Debt/Leverage: -Times Interest Earned

-Debt to Equity

-Total Liabilities / Tangible Net Worth (in the case of Lowes why is it the same as Debt to Equity?)

Profitability: -Gross Margin

-Operating Margin

-Net Margin

-Total Asset Turnover

-Return on Total Assets

-Sales to Fixed Assets (Use PPE)

-Return on Equity

Home Depot IS
ncome Statement Get Income Statement for:
View: Annual Data | Quarterly Data All numbers in thousands
Period Ending 1-Feb-15 2-Feb-14 3-Feb-13
Total Revenue 83,176,000 78,812,000 74,754,000
Cost of Revenue 54,222,000 51,422,000 48,912,000
Gross Profit 28,954,000 27,390,000 25,842,000
Operating Expenses
Research Development - - -
Selling General and Administrative 16,834,000 16,597,000 16,508,000
Non Recurring - - -
Others 1,651,000 1,627,000 1,568,000
Total Operating Expenses - - -
Operating Income or Loss 10,469,000 9,166,000 7,766,000
Income from Continuing Operations
Total Other Income/Expenses Net 337,000 12,000 87,000
Earnings Before Interest And Taxes 10,806,000 9,178,000 7,853,000
Interest Expense 830,000 711,000 632,000
Income Before Tax 9,976,000 8,467,000 7,221,000
Income Tax Expense 3,631,000 3,082,000 2,686,000
Minority Interest - - -
Net Income From Continuing Ops 6,345,000 5,385,000 4,535,000
Non-recurring Events
Discontinued Operations - - -
Extraordinary Items - - -
Effect Of Accounting Changes - - -
Other Items - - -
Net Income 6,345,000 5,385,000 4,535,000
Preferred Stock And Other Adjustments - - -
Net Income Applicable To Common Shares
Home Depot BS
Balance Sheet Get Balance Sheet for:
View: Annual Data | Quarterly Data All numbers in thousands
Period Ending 1-Feb-15 2-Feb-14 3-Feb-13
Assets
Current Assets
Cash And Cash Equivalents 1,723,000 1,929,000 2,494,000
Short Term Investments - - -
Net Receivables 1,484,000 1,398,000 1,395,000
Inventory 11,079,000 11,057,000 10,710,000
Other Current Assets 1,016,000 895,000 773,000
Total Current Assets 15,302,000 15,279,000 15,372,000
Long Term Investments - - -
Property Plant and Equipment 22,720,000 23,348,000 24,069,000
Goodwill 1,353,000 1,289,000 1,170,000
Intangible Assets - - -
Accumulated Amortization - - -
Other Assets 571,000 602,000 473,000
Deferred Long Term Asset Charges - - -
Total Assets 39,946,000 40,518,000 41,084,000
Liabilities
Current Liabilities
Accounts Payable 9,473,000 9,379,000 8,871,000
Short/Current Long Term Debt 328,000 33,000 1,321,000
Other Current Liabilities 1,468,000 1,337,000 1,270,000
Total Current Liabilities 11,269,000 10,749,000 11,462,000
Long Term Debt 16,869,000 14,691,000 9,475,000
Other Liabilities 1,844,000 2,042,000 2,051,000
Deferred Long Term Liability Charges 642,000 514,000 319,000
Minority Interest - - -
Negative Goodwill - - -
Total Liabilities 30,624,000 27,996,000 23,307,000
Stockholders' Equity
Misc Stocks Options Warrants - - -
Redeemable Preferred Stock - - -
Preferred Stock - - -
Common Stock 88,000 88,000 88,000
Retained Earnings 26,995,000 23,180,000 20,038,000
Treasury Stock -26,194,000 -19,194,000 -10,694,000
Capital Surplus 8,885,000 8,402,000 7,948,000
Other Stockholder Equity -452,000 46,000 397,000
Total Stockholder Equity 9,322,000 12,522,000 17,777,000
Net Tangible Assets 7,969,000 11,233,000 16,607,000
6,345,000
5,385,000 4,535,000

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

Step: 3

blur-text-image

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

All About Options

Authors: Thomas McCafferty

3rd Edition

0071484795, 978-0071484794

More Books

Students also viewed these Finance questions