Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show me the excell,how to Intro The following table shows historical end-of-year prices for a stock and the S&P 500, as well as the

please show me the excell,how to
image text in transcribed
Intro The following table shows historical end-of-year prices for a stock and the S&P 500, as well as the risk-free rate, r 1 Year 2 2011 3 2012 4 2013 2014 6 2015 7 2016 8 2017 9 2018 10 2019 Stock 24.55 20.82 16.49 20.58 26.88 36.85 42.5 51.33 56.21 S&P 500 1,065.57 973.37 943.71 1,186.9 1,321.85 1,385.72 1,617.04 1,815.06 1,998.45 0.038 0.022 0.015 0.025 0.036 0.035 0.038 0.038 0.035 Part 1 Calculate the annual returns. What was the average risk-free rate? Attempt 1/5 for 1 pts. 4+ decimals Submit Attempt 1/5 for 1 pts Part 2 Calculate the annual excess returns (returns over the risk-free rate). What was the covariance between the stock excess returns and the S&P 500 excess returns? 4+ decimals Submit

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

More Books