Financial ratio analysis for Merck case

User Generated

gvssnalgbat111103

Writing

Description

Financial Ratios Analysis

Please check the financial ratios in excel and read the word file. Use the word file to help you completed this paper. I highlight the ratios you need to analyze in excel. You don’t need to analyze all ratios. You just need to use three significant ratios from my highlight to do the analysis. If the case has the competitors ratios, you need to compare the company ratio to it's competitors ratios too. Remember that, all the ratios are relative. Find out the relationship of the three significant ratios you choose and combine the information from the case to analyze. For example, the net profit margin is decreasing from 2009 to 2013. You need to indicate what these % mean and You need to find out the reasonable reasons in the case like patent expire to explain why the net profit margin is decreasing. Remember that, you only can use the information in the case, do not use any reasons that do not mention in the case. The case date is up to 2015. No introduction and conclusion require.

Unformatted Attachment Preview

Merck cash and short-term investments reveivables inventories property depreciation asset a/p long term debt liabilities stockholders equity sale/turnover cost of good sold selling general and adm expense income taxes income before rxtraordinart items net income Net profit margin Return on Asset Return on Equity Debt to Asset Ratio Debt to Equity Ratio Equity Multiplier Asset Turnover 2013 17486 7184 6226 14973 18121 105645 2274 20539 53319 49765 44033 9570 18795 1028 4404 4404 2012 16141 7672 6535 16030 17385 106132 1753 16254 50669 53020 47267 9379 20461 2440 6168 6168 2011 14972 8261 6254 16297 16176 105128 2462 15525 48185 54517 48047 9304 21341 942 6272 6272 2010 12201 7344 5868 17082 13481 105781 2308 15482 48976 54376 45987 8916 21363 671 861 861 2009 9605 6603 8055 18274 12595 112090 2237 16075 50597 59058 27428 4948 13899 2268 12901 12901 10.00% 4.17% 8.85% 50.47% 107.14% 212.29% 41.68% 13.05% 5.81% 11.63% 47.74% 95.57% 200.17% 44.54% 13.05% 5.97% 11.50% 45.83% 88.39% 192.84% 45.70% 1.87% 0.81% 1.58% 46.30% 90.07% 194.54% 43.47% 47.04% 11.51% 21.84% 45.14% 85.67% 189.80% 24.47%
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

N...


Anonymous
Nice! Really impressed with the quality.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags