Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Go to finance.yahoo.com. Choose any stock that you want to analyze. Use data from Yahoo Finance to calculate the beta of the stock. Start

image text in transcribed

Go to finance.yahoo.com. Choose any stock that you want to analyze. Use data from Yahoo Finance to calculate the beta of the stock. Start by downloading the monthly adjusted closing prices of the stock and the S&P 500 (^GSPC) in the Historical Prices section. Copy the data into Excel and calculate the monthly rates of return (based on closing prices) for each series. Using the entire period for which data are available for both the stock and S&P 500, estimate a regression with stock's excess return as the dependent () variable and the S&P 500 excess return as the independent () variable. To compute excess return assume risk free rate to be 3%. Verify the and a from the regression with and a computed using the analytical formula given in Example 6.3 in BKM. Finally, compare your results to the beta listed in Yahoo Finance Stock Report. Do any of your results match the Yahoo Finance Report beta? What might explain the differences?

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

International financial management

Authors: Jeff Madura

9th Edition

978-0324593495, 324568207, 324568193, 032459349X, 9780324568202, 9780324568196, 978-0324593471

More Books

Students also viewed these Finance questions