Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use Excel to answer this question End of month Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Risk-free 0.442% 0.436% 0.452% 0.413% 0.450% Rates of return Share index

image text in transcribed

image text in transcribedUse Excel to answer this question

End of month Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Risk-free 0.442% 0.436% 0.452% 0.413% 0.450% Rates of return Share index Share A -1.710% 4.786% 3.337% -0.627% 0.023% 0.076% 1.799% -0.799% 0.141% 0.316% 0.028% 3.806% -2.544% 4.211% -2.105% -4.441% -4.611% 4.062% -3.200% 2.082% -6.108% 1.839% 7.443% 0.132% Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 0.449% 0.384% 0.445% 0.387% 0.453% 0.366% 0.308% (a) Calculate the monthly excess returns of the Share index and Share A. (b) Add a graph of the excess returns of Share A on the vertical axis (Y axis) and the Share index on the horizontal axis (X axis). On this graph, plot the linear regression line and display the regression equation and the R-squared. (c) Using appropriate Excel functions to calculate the Alpha, Beta and R-squared of the regression of the excess returns of the Share index on the excess returns of Share A. Provide a brief explanation on what these quantities measure

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

ISE Essentials Of Investments

Authors: Zvi Bodie, Alex Kane, Alan Marcus

12th International Edition

1265450099, 9781265450090

More Books

Students also viewed these Finance questions