Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Choose a company and compute its stock beta yourself. A common estimation procedure is to use 60 months of return data and to use the
Choose a company and compute its stock beta yourself.
A common estimation procedure is to use 60 months of return data and to use the S&P 500 Index as the market portfolio.
You can obtain price data for a company and for the S&P 500 Index for free from Web sites like Yahoo! Finance. Using monthly prices, you can compute the monthly returns, as (Pn Pn-1) / Pn-1.
Once you have your previous 60 monthly returns for both your stock and the market index, use the SLOPE function on excel to find beta.
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