Question
When you go on the Web to find a firms beta, you do not know how recently it was computed, what index was used as
When you go on the Web to find a firms beta, you do not know how recently it was computed, what index was used as a proxy for the market portfolio, or which time series of returns the calculations used. Earlier in this chapter, it was shown that when we went on the Web to find a beta for AT&T, we found the following: MSN Money (0.53), Yahoo! Finance (0.38), and Zacks (0.54). An alternative is to compute 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 free from websites like Yahoo! Finance. Using monthly prices, you can compute the monthly returns, as (Pn Pn 1) Pn 1. Below are 60 monthly returns for AT&T and the S&P 500 Index. You can use these returns to compute AT&Ts beta. A spreadsheet, like Excel, can run a regression (go to Tool menu, select Data Analysis, and then Regression). Select AT&T returns as the y variable and S&P 500 Index return as the x variable. The coefficient for the x variable is the beta estimate. The regression will provide all the statistical information you might like. However, if you only want beta, you can simply use the SLOPE function in Excel. Or you may have learned to run a regression using statistical software. a. Compute AT&Ts beta using the listed returns. b. Compare your estimate with the ones found on the Web as listed. c. How different will the required returns be using these betas? Compute required return using each beta (assume that the risk-free rate is 5 percent and the market return will be 13 percent).
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