Question

INCOME STATEMENT -  ALL NUMBERS IN THOUSANDS Revenue 12/31/17 12/31/16 Total Revenue 177,866,000 135,987,000 Cost of Revenue...

INCOME STATEMENT -  ALL NUMBERS IN THOUSANDS
Revenue 12/31/17 12/31/16
Total Revenue 177,866,000 135,987,000
Cost of Revenue 111,934,000 88,265,000
Gross Profit 65,932,000 47,722,000
Operating Expenses
Research Development 22,620,000 16,085,000
Selling General and Administrative 38,992,000 27,284,000
Non Recurring - -
Others 214,000 167,000
Total Operating Expenses 173,760,000 131,801,000
Operating Income or Loss 4,106,000 4,186,000
Income from Continuing Operations
Total Other Income/Expenses Net -304,000 -390,000
Earnings Before Interest and Taxes 4,106,000 4,186,000
Interest Expense -848,000 -484,000
Income Before Tax 3,802,000 3,796,000
Income Tax Expense 769,000 1,425,000
Minority Interest - -
Net Income From Continuing Ops 3,033,000 2,371,000
Non-recurring Events
Discontinued Operations - -
Extraordinary Items - -
Effect Of Accounting Changes - -
Other Items - -
Net Income
Net Income 3,033,000 2,371,000
Preferred Stock And Other Adjustments - -
Net Income Applicable To Common Shares 3,033,000 2,371,000

A. Include the vertical AND horizontal AND ratio analysis for the company, draw conclusions from the analysis

Homework Answers

Answer #1

1) Gross Margin:

For year 2017 =2.69

For year 2016 = 2.85

The gross margin ratio is decreased in this year. Gross margin ratio is a profitability ratio that measures how profitable a company can sell its inventory. It only makes sense that higher ratios are more favorable.

2) Operating Profit Ratio :

For Year 2017 : 0.02

For Year 2016 : 0.03

A higher operating margin is more favorable compared with a lower ratio because this shows that the company is making enough money from its ongoing operations to pay for its variable costs as well as its fixed costs.

3) Interest Coverage ratio :

For Year 2017 : 4.84

For year 2016 : 8.65

The company is extremely liquid and shouldn’t have problem getting a loan to expand.

4. R & D to sales : R & D expenses / Revenue

For year 2017 : 0.12

For year 2016 : 0.118

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
Find the ratios for the given Income Statement All numbers in thousands Revenue 12/31/2018 12/31/2017 Total...
Find the ratios for the given Income Statement All numbers in thousands Revenue 12/31/2018 12/31/2017 Total Revenue 243,770,000,000 239,575,376,000 Cost of Revenue 132,390,000,000 129,290,661,000 Gross Profit 111,380,000,000 110,284,715,000 Operating Expenses Research Development 18,350,000,000 16,355,612,000 Selling General and Administrative 34,140,000,000 38,947,445,000 Non Recurring - - - Others - - Total Operating Expenses 184,880,000,000 185,930,338,000 Operating Income or Loss 58,890,000,000 53,645,038,000 Income from Continuing Operations Total Other Income/Expenses Net 2,270,000,000 2,550,929,000 Earnings Before Interest and Taxes 58,890,000,000 53,645,038,000 Interest Expense - -655,402,000...
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...
Use Income statement shown below and calculate : Current Market cap, PE ratio, Earnings per share,...
Use Income statement shown below and calculate : Current Market cap, PE ratio, Earnings per share, Dividend yield ,PEG ratio and PEGY ratio Total Revenue 25,878,372   Cost of Revenue 18,521,400   Gross Profit 7,356,972   Operating Expenses Research Development - Selling General and Administrative 4,250,446   Non Recurring - Others - Total Operating Expenses - Operating Income or Loss 3,106,526   Income from Continuing Operations Total Other Income/Expenses Net - Earnings Before Interest And Taxes 3,106,526   Interest Expense 29,175   Income Before Tax 3,077,351   Income...
Sales Revenue 177089 Other Revenue - Total Revenue 177089 Direct Costs 144944 Gross Profit 32145 Selling...
Sales Revenue 177089 Other Revenue - Total Revenue 177089 Direct Costs 144944 Gross Profit 32145 Selling General & Admin 24652 Depreciation & Amortization - Restruct Remediation & Impair - Other Operating Expense 483 Total Indirect Operating Costs 25135 Operating Income 7010 Interest Income -6394 Gains on Sale of Assets 1095 Other Non-Operating Income 0 Total Non-Operating Income -5299 Earnings Before Tax 1711 Taxation -512 Earnings After Tax 2223 Minority Interests 280 Equity Earnings 285 Discontinued Operations 47 Extraordinary Items 0...
Make an income statement with the following: Sales Revenue Net Income    Net Income from continuing...
Make an income statement with the following: Sales Revenue Net Income    Net Income from continuing operations Cost of Goods Sold Gain/Loss on sale of assets Gross Profit Gain/Loss from discontinued operations, net of tax Interest Revenue Dividend Revenue selling, general, and administrative expenses Operating Income Interest Expense Income before taxes Income tax expense
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 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...
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...
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...