Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Year 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 Risk Free Rate 0.29%

image text in transcribed

image text in transcribed

Year 2019 2018 2017 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 2005 2004 2003 2002 2001 2000 Risk Free Rate 0.29% 0.27% 0.32% 0.31% 0.30% 0.32% 0.31% 0.34% 0.32% 0.30% 0.34% 0.37% 0.39% 0.41% 0.41% 0.44% 0.40% 0.41% 0.41% 0.39% Return S&P 500 MRK 3M GM 5.56% 9.64% 1.97% 1.92% 5.16% -4.47% 1.42% -0.63% 5.13% 6.20% -3.08% 7.22% 1.15% 4.58% 3.73% -0.45% -6.56% -4.77% 1.71% -5.74% -0.37% -2.15% 1.03% -1.44% -1.18% -4.13% -5.05% -7.15% 6.47% 9.53% 3.29% 21.17% -1.52% 18.67% 15.44% -14.52% -4.90% -8.83% -11.99% -18.73% 0.99% 1.85% 0.26% 4.02% -10.89% -2.05% 2.31% -12.92% -6.04% -10.73% -1.94% -13.99% -2.94% 5.06% 0.69% -2.40% -3.63% -5.63% 9.38% 6.12% 4.83% -5.58% -2.47% 14.10% -3.47% 3.63% 7.41% 4.65% -0.41% 0.64% -6.11% 5.22% 1.35% -12.76% 3.16% -2.21% 4.93% 6.18% 10.92% 21.69% 9) Use Excel function calculate the following: a) Median Return on MRK (0.5 mark) b) Total Return on Risk Free Rate (0.5 mark) c) Average Return on S&P 500 (0.5 mark) d) Variance Return on GM (0.5 mark) e) Standard Deviation Return on 3M (0.5 mark)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Statements Analysis Cases From Corporate India

Authors: Sandeep Goel

1st Edition

1138663921, 9781138663923

More Books

Students also viewed these Accounting questions

Question

What perspective or approach to talent would be appropriate?

Answered: 1 week ago

Question

What policies and practices for talent development are needed now?

Answered: 1 week ago