Year | NYSE | Stock X |
1 | -26.5 | -21 |
2 | 37.2 | 19 |
3 | 23.8 | 15.5 |
4 | -7.2 | 5 |
5 | 6.6 | 11.4 |
6 | 20.5 | 19.2 |
7 | 30.6 | 20 |
Sum Total | 85 | 69.1 |
Average Return | 12.14 | 9.87 |
Std Deviation | 20.95 | 13.54 |
Covariance | 262.57 | |
Variance | 438.91 | |
Beta Formula | Covariance of X with NYSE / Variance of NYSE | |
Beta Coefficient | 0.60 | |
Year | NYSE | Stock X |
1 | -26.5 | -21 |
2 | 37.2 | 19 |
3 | 23.8 | 15.5 |
4 | -7.2 | 5 |
5 | 6.6 | 11.4 |
6 | 20.5 | 19.2 |
7 | 30.6 | 20 |
Sum Total | =SUM(C4:C10) | =SUM(D4:D10) |
Average Return | =AVERAGE(C4:C10) | =AVERAGE(D4:D10) |
Std Deviation | =STDEV.P(C4:C10) | =STDEV.P(D4:D10) |
Covariance | =COVARIANCE.P(C4:C10,D4:D10) | |
Variance | =VAR.P(C4:C10) | |
Beta Formula | Covariance of X with NYSE / Variance of NYSE | |
Beta Coefficient | =C14/C15 |
Required return = Risk free rate + Beta ( Market retrun - Risk free rate) | |||
Required return | 9.87 | ||
Market return | 12.14 | ||
Beta | 0.60 | ||
Recalculating the same we derive Rf = 4.31 |
Problem 3-5 Characteristic Line and Security Market Line You are given the following set of data:...
Characteristic Line and Security Market Line You are given the following set of data: HISTORICAL RATES OF RETURN Year Stock X NYSE - 10.0% 1 - 26.5% 2 37.2 20.0 19.0 3 23.8 4 - 7.2 5.0 6.6 11.1 6 20.5 17.8 7 30.6 18.8 a. 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. 0.4148 Beta b. Determine the arithmetic average rates of return...
The security market line is estimated to be pent. The beta of B 1.3. The more (11.1% ) You are considering two stocks. The beta Ais . The more dividend ved during the year of percent and a growth rate dividend yield during the year of 7.2 percent and a growth rate of 6.7 percent. a. What is the required return for each security? Round your answers to two decal places Stock: h. Why are the required rates of return...
. (Portfolio beta and security market line) You own a portfolio consisting of the following stocks The risk-free rate is 4 percent. Also, the expected return on the market portfolio is 9 percent. a. Calculate the expected return of your portfolio (Hint: The expected return of a portfolio equals the weighted average of the individual stocks' expected returns where the weights are the percentage invested in each stock.) b. Calculate the portfolio beta. c. Given the foregoing information, plot the...
Problem 6-23 (similar to) Question Help (Portfolio beta and security market line) You own a portfolio consisting of the following stocks: The risk-free rate is 3 percent. Also, the expected return on the market portfolio is 13 percent. a. Calculate the expected return of your portfolio. (Hint: The expected return of a portfolio equals the weighted average of the individual stocks' expected returns, where the weights are the percentage invested in each stock.) b. Calculate the portfolio beta, c. Given...
11. Changes to the security market line The following graph plots the current security market line (SML) and indicates the return that investors require from holding stock from Happy Corp. (HC). Based on the graph, complete the table that follows: REQUIRED RATE OF RETURN (Percent) Rotum on HC's Stock RISK (Beta) Ch 08: Assignment - Risk and Rates of Return Value CAPM Elements Risk-free rate (TRF) Market risk premium (RPM) Happy Corp. stock's beta Required rate of return on Happy...
8. Changes to the security market line The following graph plots the current security market line (SML) and indicates the return that investors require from holding stock from Happy Corp. (HC). Based on the graph, complete the table that follows. Return on HC Stock REQUIRED RATE OF RETURN (Percent) RISK (Beta) CAPM Elements Value Risk free rate ( Market risk premium (RPM) Value CAPM Elements Risk-free rate (TR) Market risk premium (RPM) Happy Corp. stock's beta Required rate of return...
The security market line (SML) is an equation that shows the relationship between risk as measured by beta and the required rates of return on individual securities. The SML equation is given below: If a stock's expected return plots on or above the SML, then the stock's return is -Select-insufficientsufficientCorrect 1 of Item 1 to compensate the investor for risk. If a stock's expected return plots below the SML, the stock's return is -Select-insufficientsufficientCorrect 2 of Item 1 to...
You are given the following information concerning a stock and the market Returns Market Stock Year 15% 27% 19 2011 2012 19 2013 25 5 2014 -12 -22 2015 35 16 2016 15 27 a. Calculate the average return and standard deviation for the market and the stock. (Use Excel to complete the problem. Do not round intermediate calculations. Enter your answers as a percent rounded to 2 decimal places.) Market Stock % Average return Standard deviation b. Calculate the...
(Portono pera and security market ine) Tou own a pontouo consisung or the Toulowing SOCKS The hsk-ree rate is 3 percent. Also, the expected return on the market portfolio is 13 percent. a. Calculate the expected return of your portfolio. (Hint: The expected return of a portfolio equals the weighted average of the individual stocks' expected returns, where the weights are the percentage invested in each stock.) b. Calculate the portfolio beta. C. Given the foregoing information, plot the security...
Ch 08: Assignment-Risk and Rates of Return 8. Changes to the security market line The following graph plots the current security market line (SML) and indicates the return that investors require from holding stock from Happy Corp. (HC). Based on the graph, complete the table that follows. REQUIRED RATE OF RETURN (Percent) Return on HC's Stock RISK (Beta) Value CAPM Elements Risk-free rate (rry) Market risk premium (RPM) Value CAPM Elements Risk free rate (TRE) Market risk premium (RPM) Happy...