Financial ratio analysis for Merck case

Anonymous
timer Asked: Mar 2nd, 2018
account_balance_wallet $25

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

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%

Tutor Answer

ameliajamie
School: UT Austin

N...

flag Report DMCA
Review

Anonymous
Totally impressed with results!! :-)

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors