Answered step by step
Verified Expert Solution
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%
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started