Question

Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...

Please compute the following ratios

using 237.65b market cap (if needed)

Asset turnover

Operating profit margin

Long-term debt to equity ratio

Current ratio

The Home Depot, Inc. Balance Sheet
All numbers in thousands
Period Ending 1/29/17 1/31/16
Current Assets
Cash And Cash Equivalents 2,538,000 2,216,000
Short Term Investments - -
Net Receivables 2,029,000 1,890,000
Inventory 12,549,000 11,809,000
Other Current Assets 608,000 569,000
Total Current Assets 17,724,000 16,484,000
Long Term Investments - -
Property Plant and Equipment 21,914,000 22,191,000
Goodwill 2,093,000 2,102,000
Intangible Assets - -
Accumulated Amortization - -
Other Assets 1,235,000 1,196,000
Deferred Long Term Asset Charges - -
Total Assets 42,966,000 41,973,000
Current Liabilities
Accounts Payable 11,212,000 10,531,000
Short/Current Long Term Debt 1,252,000 427,000
Other Current Liabilities 1,669,000 1,566,000
Total Current Liabilities 14,133,000 12,524,000
Long Term Debt 22,349,000 20,789,000
Other Liabilities 1,855,000 1,965,000
Deferred Long Term Liability Charges 296,000 379,000
Minority Interest - -
Negative Goodwill - -
Total Liabilities 38,633,000 35,657,000
Stockholders' Equity
Misc. Stocks Options Warrants - -
Redeemable Preferred Stock - -
Preferred Stock - -
Common Stock 88,000 88,000
Retained Earnings 35,519,000 30,973,000
Treasury Stock -40,194,000 -33,194,000
Capital Surplus 9,787,000 9,347,000
Other Stockholder Equity -867,000 -898,000
Total Stockholder Equity

4,333,000

6,316,000

The Home Depot, Inc. Income Statement
All numbers in thousands
Revenue 1/29/17 1/31/16
Total Revenue 94,595,000 88,519,000
Cost of Revenue 62,282,000 58,254,000
Gross Profit 32,313,000 30,265,000
Operating Expenses
Research Development - -
Selling General and Administrative 17,132,000 16,801,000
Non Recurring - -
Others 1,754,000 1,690,000
Total Operating Expenses - -
Operating Income or Loss 13,427,000 11,774,000
Income from Continuing Operations
Total Other Income/Expenses Net 36,000 166,000
Earnings Before Interest and Taxes 13,463,000 11,940,000
Interest Expense 972,000 919,000
Income Before Tax 12,491,000 11,021,000
Income Tax Expense 4,534,000 4,012,000
Minority Interest - -
Net Income From Continuing Ops 7,957,000 7,009,000
Non-recurring Events
Discontinued Operations - -
Extraordinary Items - -
Effect Of Accounting Changes - -
Other Items - -
Net Income
Net Income 7,957,000 7,009,000
Preferred Stock And Other Adjustments - -
Net Income Applicable To Common Shares 7,957,000 7,009,000
The Home Depot, Inc. Cash Flow
All numbers in thousands
Period Ending 1/29/17 1/31/16
Net Income 7,957,000 7,009,000
Operating Activities, Cash Flows Provided By or Used In
Depreciation 1,973,000 1,863,000
Adjustments To Net Income 267,000 100,000
Changes In Accounts Receivables -138,000 -181,000
Changes In Liabilities 654,000 1,151,000
Changes In Inventories -769,000 -546,000
Changes In Other Operating Activities -161,000 -23,000
Total Cash Flow From Operating Activities 9,783,000 9,373,000
Investing Activities, Cash Flows Provided By or Used In
Capital Expenditures -1,621,000 -1,503,000
Investments - 144,000
Other Cash flows from Investing Activities 38,000 -1,623,000
Total Cash Flows From Investing Activities -1,583,000 -2,982,000
Financing Activities, Cash Flows Provided By or Used In
Dividends Paid -3,404,000 -3,031,000
Sale Purchase of Stock -6,662,000 -6,772,000
Net Borrowings 2,274,000 4,012,000
Other Cash Flows from Financing Activities -78,000 4,000
Total Cash Flows From Financing Activities -7,870,000 -5,787,000
Effect Of Exchange Rate Changes -8,000 -111,000
Change In Cash and Cash Equivalents 330,000 604,000

Homework Answers

Answer #1

Asset Turnover - Net sales / Total assets

2017 : 94,595,000/ 42,966,000 = 2.20x

2016 : 88,519,000/ 41,973,000 = 2.10x

Operating profit margin - Operating Earnings / Revenue

2017 : 13,427,000/ 94,595,000 = 14%

2016 : 11,774,000/ 88,519,000 = 13.3%

Long-term debt to equity ratio - Total debt / total equity

2017 : 22,349,000/ 4,333,000 = 5.15

2016 : 20,789,000/ 6,316,000 = 3.29

Current ratio : Current assets/ current liabilities

2017 : 17,724,000/ 14,133,000 = 1.25

2016 : 16,484,000/ 12,524,000 = 1.31


Know the answer?
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
Similar Questions
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin...
Please compute the following ratios using 237.65b market cap (if needed) Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000...
Please compute the following ratios using $237.36B. market cap Market value added Market to book ratio...
Please compute the following ratios using $237.36B. market cap Market value added Market to book ratio Return on Asset The Home Depot, Inc. Balance Sheet All numbers in thousands Period Ending 1/29/17 1/31/16 Current Assets Cash And Cash Equivalents 2,538,000 2,216,000 Short Term Investments - - Net Receivables 2,029,000 1,890,000 Inventory 12,549,000 11,809,000 Other Current Assets 608,000 569,000 Total Current Assets 17,724,000 16,484,000 Long Term Investments - - Property Plant and Equipment 21,914,000 22,191,000 Goodwill 2,093,000 2,102,000 Intangible Assets -...
Please Calculate the following ratios: Asset turnover Operating profit margin Long-term debt to equity ratio Current...
Please Calculate the following ratios: Asset turnover Operating profit margin Long-term debt to equity ratio Current ratio The Home Depot, Inc. Income Statement All numbers in thousands Revenue 1/29/17 1/31/16 Total Revenue 94,595,000 88,519,000 Cost of Revenue 62,282,000 58,254,000 Gross Profit 32,313,000 30,265,000 Operating Expenses Research Development - - Selling General and Administrative 17,132,000 16,801,000 Non Recurring - - Others 1,754,000 1,690,000 Total Operating Expenses - - Operating Income or Loss 13,427,000 11,774,000 Income from Continuing Operations Total Other Income/Expenses...
Which of the following is not, historically, typical of the attitude of an analyst where business...
Which of the following is not, historically, typical of the attitude of an analyst where business trends are upward (or positive)? Tendency to apply higher multiples on past earnings and cash flows. Build in speculative components to price target based upon future expected improvement. Neglect to differentiation between value and speculation. Fully account for possibility that forecasts are too optimistic. Financing activities is defined as: The principal revenue-generating activities of an organization and other activities that are not investing or...
-BEFC reported cost of goods sold (COGS) of $1.8 million and average inventory for the year...
-BEFC reported cost of goods sold (COGS) of $1.8 million and average inventory for the year of $300,000. What was the Day's Sales in Inventory (DSOs) for the year? 60.0 days 60.8 days 64.3 days 68.8 days -A statement of cash flow will include all except: Operating activities Investing activities Financing activities Foreign trading activities -Operating activities is defined as: The principal revenue-generating activities of an organization and other activities that are not investing or financing; any cash flows from...
Financial Statement Analysis: You have just taken the position of Assistant to the Vice President for...
Financial Statement Analysis: You have just taken the position of Assistant to the Vice President for Finance for a Medical Center, a 240-bed acute care hospital. The Vice President has asked you to study the organization's recent financial statements - Profit and Loss, Balance Sheet, Cash Flow (sheets are included in the files below) and provide your analysis of the organization’s strength and vulnerabilities. Considering the accounting and financial tools and skills used in technology healthcare, how would you go...
Plese give a conclusion and recommendation for investment for CVS & Walgreens. Please reposnd in a...
Plese give a conclusion and recommendation for investment for CVS & Walgreens. Please reposnd in a paragraph or four or more senetences. CVS Balance Sheet All numbers in thousands Period Ending 12/31/2017 12/31/2016 12/31/2015 Current Assets Cash And Cash Equivalents 1,696,000 3,371,000 2,459,000 Short Term Investments 111,000 87,000 88,000 Net Receivables 13,181,000 12,164,000 11,888,000 Inventory 15,296,000 14,760,000 14,001,000 Other Current Assets 945,000 660,000 722,000 Total Current Assets 31,229,000 31,042,000 29,158,000 Long Term Investments - - - Property Plant and Equipment...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is trend in Liquidity ratios of CVS over the last three years - Explain using ratios and three sentences? b. What is trend in Liquidity ratios of Walgreens over the last three years - Explain using rations and three sentences? c. Which company has had better Liquidity ratios over the last 3 years? Explain with ratios and three sentences CVS Balance Sheet All numbers in...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is...
Please answer all question using a full paragraph, watch you grammar and syntax. a. What is trend in profitability ratios of CVS over the last three years - Explain using ratios and three sentences? b. What is trend in profitability ratios of Walgreens over the last three years - Explain using rations and three sentences? c. Which company has had better profitability ratios over the last 3 years? Explain with ratios and three sentences CVS Balance Sheet All numbers in...
Please Give a Horizontal Analysis for CVS and Walgreens CVS Balance Sheet All numbers in thousands...
Please Give a Horizontal Analysis for CVS and Walgreens CVS Balance Sheet All numbers in thousands Period Ending 12/31/2017 12/31/2016 12/31/2015 Current Assets Cash And Cash Equivalents 1,696,000 3,371,000 2,459,000 Short Term Investments 111,000 87,000 88,000 Net Receivables 13,181,000 12,164,000 11,888,000 Inventory 15,296,000 14,760,000 14,001,000 Other Current Assets 945,000 660,000 722,000 Total Current Assets 31,229,000 31,042,000 29,158,000 Long Term Investments - - - Property Plant and Equipment 10,292,000 10,175,000 9,855,000 Goodwill 38,451,000 38,249,000 38,106,000 Intangible Assets 13,630,000 13,511,000 13,878,000 Accumulated...