Question

In: Finance

Characteristic Line You are given the following set of data: Historical Rates of Return Year NYSE...

Characteristic Line

You are given the following set of data:

Historical Rates of Return
Year NYSE Stock Y
1 4.0 % 3.5 %
2 14.3 17.7
3 19.0 9.2
4 - 14.7 - 9.0
5 - 26.5 - 12.2
6 37.2 32.1
7 23.8 6.7
8 - 7.2 3.5
9 6.6 13.9
10 20.5 22.7
11 30.6 17.0
Mean = 9.8 % 9.6 %
σ = 19.6 % 13.1

%

Use a spreadsheet or a calculator with a linear regression function to estimate beta. Round your answer to two decimal places.

Beta =

Give a verbal interpretation of what the regression line and the beta coefficient show about Stock Y's volatility and relative risk as compared with those of other stocks. Round your answers to the nearest whole.
Stock Y is about ______ percent as volatile as the market; thus, its relative risk is about ______ percent of that of an average firm.

Solutions

Expert Solution

Determination of Beta:

Hence, the beta is 0.59.

Stock Y is about 59% percent as volatile as the market; thus, its relative risk is about 59% percent of that of an average firm.

Reason:

Beta is termed as the risk related with a security or a portfolio corresponding to the remainder of the market. The beta coefficient is a method of deciding how much a stock or security may move in contrast with the market.


Related Solutions

You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X...
You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X 1 - 26.5% - 19.0% 2 37.2    16.0    3 23.8    15.5    4 - 7.2    3.0    5 6.6    9.1    6 20.5    19.4    7 30.6    19.5    The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Use a spreadsheet (or a calculator with a linear regression function) to determine...
You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X...
You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X 1 - 26.5% - 10.0% 2 37.2    21.0    3 23.8    18.5    4 - 7.2    2.0    5 6.6    8.9    6 20.5    19.9    7 30.6    18.8    Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Round your answer to two decimal places. Beta = Determine the arithmetic average rates of return for Stock X and the NYSE over...
Characteristic Line and Security Market Line You are given the following set of data: HISTORICAL RATES...
Characteristic Line and Security Market Line You are given the following set of data: HISTORICAL RATES OF RETURN Year      NYSE         Stock X 1 - 26.5% - 17.0% 2 37.2    16.0    3 23.8    14.0    4 - 7.2    5.0    5 6.6    9.9    6 20.5    19.4    7 30.6    17.9    Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Round your answer to two decimal places. Beta = Determine the arithmetic average rates of return for...
You are given the following set of data: Year NYSE Stock X 1 -26.5% -14% 2...
You are given the following set of data: Year NYSE Stock X 1 -26.5% -14% 2 37.2 23.0 3 23.8 17.5 4 -7.2 2.0 5 6.6 8.1 6 20.5 19.4 7 30.6 18.2 a. Determine Stock X beta coefficient b. determine the arithmetic average rates of return for stock X and NYSE over the period given. Calculate the standard deviations of returns for both X and NYSE c. assume the situation during years 1 to 7 is expected to prevail...
Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012...
Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012 -19.60% -14.00% 2013 20.00 30.00 2014 12.00 35.30 2015 -1.00 -10.20 2016 31.50 1.80 Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places. Stock A % Stock B % Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the realized rate...
Given the following historical returns, calculate the average return and the standard deviation Year Return 1...
Given the following historical returns, calculate the average return and the standard deviation Year Return 1 12% 2 7% 3 10% 4 9%
You've collected the following historical rates of return for stocks A and B: Year (t) rA,t...
You've collected the following historical rates of return for stocks A and B: Year (t) rA,t rB,t 2016 0.02 0.02 2015 0.08 0.05 2014 0.12 0.07 Part 1: What was the average annual return for stock A= 0.0733 Part 2: What was the average annual return for stock B?= 0.04667 Part 3: What was the standard deviation of returns for stock A? Part 4: What was the standard deviation of returns for stock B? Can you solve Part 3 and...
REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Year Stock A's...
REALIZED RATES OF RETURN Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rB 2011 - 15.90% - 16.50% 2012 33.50 21.20 2013 11.25 31.60 2014 - 6.00 - 8.80 2015 34.00 29.35 Calculate the average rate of return for stock A during the period 2011 through 2015. Round your answer to two decimal places. % Calculate the average rate of return for stock B during the period 2011 through 2015. Round...
Problem 6-13 Historical Realized Rates of Return Stocks A and B have the following historical returns:...
Problem 6-13 Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012 -22.60% -15.90% 2013 32.50 18.60 2014 17.75 28.30 2015 -2.50 -13.50 2016 31.75 39.40 Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places. Stock A % Stock B % Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the...
Problem 6-13 Historical Realized Rates of Return Stocks A and B have the following historical returns:...
Problem 6-13 Historical Realized Rates of Return Stocks A and B have the following historical returns: Year 2012 -23.50% -14.60% 2013 29.75 21.40 2014 10.50 25.40 2015 -1.75 -7.50 2016 32.50 22.80 Calculate the average rate of return for each stock during the 5-year period. Round your answers to two decimal places. Stock A % Stock B % Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would have been the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT