Question

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

Homework Answers

Answer #2
Ratio Formula 2017
Asset Turnover* Sales/Average Total Assets 2.23
94595000/((42966000+41973000)/2)
Operating Profit Margin Operating Profit/Sales 14.19%
13427000/94595000
Long Term debt to equity ratio Long term debt/Equity 5.16
22349000/4333000
Current Ratio Current Assets/current Liabilities 1.25
17724000/14133000
Alternatively, the asset turnover can also be calculate by dividing sales with total assets instead of average assets, since last year figures are given it is preferable to calculate average total assets
answered by: anonymous
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.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 -...
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 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...
a. Please give a summary of financial performance for CVS and Walgreens. Please do so in...
a. Please give a summary of financial performance for CVS and Walgreens. Please do so in a paragraph in five sentences or more. 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...
Please provide, in sentence form, a Balance Sheet and Income Sheet Analysis for CVS & Walgreens....
Please provide, in sentence form, a Balance Sheet and Income Sheet Analysis for CVS & Walgreens. Answer should refelect several paragraphs for each company, so at least one an half for the Income and one and half for the Balance sheet for each company. Please, Please, Please watch syntax and grammar!! 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...
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 calculate the following ratios: Current ratio debt to asset ratio quick ratio EXAMPLE COMPANY ASSETS...
Please calculate the following ratios: Current ratio debt to asset ratio quick ratio EXAMPLE COMPANY ASSETS LIABILITIES TOTAL CURRENT ASSETS=89,000 TOTAL CURRENT LIABILITIES = 61,000 INVESTMENT =36,000 TOTAL LONG TERM LIABILITIES = 420,000 PROPERTY,PLANT &EQUIP TOTAL LIABILITIES= 481,000 LAND = 5,500 STOCKHOLDERS EQUITY LAND IMPROVEMENTS = 6,500 COMMON STOCKS =110,000 BUILDINGS = 180,000 RETAINED EARNING = 220,000 EQUIPMENT = 201,000 ACCUM OTHER COMPREHENSIVE INCOME = 9,000 LESS: ACCUM DEPRECIATION = (56,000) LESS: TREASURY STOCK = (50,000) PROP,PLANT,EQUIP NET TOTAL= 337,000...