None Using the data in the following table, and the fact that the correlation of A and B is 0.56, calculate the volatility (standard deviation) of a portfolio that is 60% invested in share A and40% invested in share B. Click on the icon located on the top-right corner of the data table below to copy its contents into a spreadsheet.Realised ReturnsYearShare AShare B2007-4%20%20089%30%20095%11%2010-4%-3%20114%-7%201213%30%The standard deviation of the portfolio is %. (Round to two decimal places.)

Working Note : YearReturn on Share AReturn on Share BDeviation From Expected Return of Share…

Answered: Using the data in the following table,…

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

10th Edition

ISBN:9781337902571

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter8: Risk And Rates Of Return

Section: Chapter Questions

Problem 22SP

See similar textbooks

Similar questions

F1 plaese help.....
Excel Online Structured Activity: Historical Return: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2011 14 % 12 % 10 % 2012 20 7 9 2013 -13 -2 -13 2014 3 1 2 2015 19 9 12 Assume that the risk-free rate is 4% and the market risk premium is 6%. 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 What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 2 What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 3 What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. fill in the blank 4 % What is the required rate of return on Stock…
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% -11.0% 2 37.2 25.0 3 23.8 13.5 4 -7.2 2.0 5 6.6 11.1 20.5 18.5 7 30.6 19.0 a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round intermediate calculations. Round your answer to two decimal places. b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places. Stock X NYSE Average return, FAvg % % Standard deviation, ơ %
Please help me
Provide calculation this question general financial
What is Stock X's geometric returns if it has the following returns? Year 1 8% Year 2 - 5% Year 3 10% Year 4 - 6% Year 5 15% a. 4.1%. b. 5.2% c. 6.8% d. 8.5%
Hello Can you show how to calculate the following statistics
Problems BETA COEFFICIENTS AND RATES OF RETURN You are given the following set of data: 8A-1 Historical Rates of Return (r) Stock Y(F,) NYSE (F.) Year 1 3.0% 4.0% 18.2 14.3 9.1 19.0 (6.0) (14.7) (15.3) (26.5) 33.1 37.2 7 6.1 23.8 3.2 (7.2) 9. 14.8 6.6 10 24.1 20.5 11 18.0 30.6 Mean 9.8% 9.8% 13.8 19.6 d. Suppose the regression line had been downward sloping and the beta coefficient had been negative. What would this imply about (1) Stock Y's relative riskiness and (2) its probable risk premium? e. Construct an illustrative probability distribution graph of returns (see Figure 8.3) for portfolios consisting of (1) only Stock Y, (2) 1% each of 100 stocks with beta coefficients similar to that of Stock Y, and (3) all stocks (i.e., the distribution of returns on the market). Use as the expected rate of return the arithmetic mean as given previously for both Stock Y and the market, and assume that the distributions are normal. Are the expected returns "reasonable"; that is, is it reasonable…
Assume these are the stock market and Treasury bill returns for a 5-year period: Year 2016 2017 2018 2019 2020 Stock Market Return (%) 33.30 13.20 -3.50 14.50 23.80 Required: a. What was the risk premium on common stock in each year? b. What was the average risk premium? c. What was the standard deviation of the risk premium? (Ignore that the estimation is from a sample of data.) 3 Required A Required B T-Bill Return Complete this question by entering your answers in the tabs below. Standard deviation (%) 0.12 0.12 0.12 0.07 0.09 x Answer is complete but not entirely correct. Required C What was the standard deviation of the risk premium? (Ignore that the estimation is from a sample of data.) Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. 13.69 X % घ
please help!
You are given the following set of data: HISTORICAL RATES OF RETURN Year NYSE Stock X 1 - 26.5% - 22.0% 2 37.2 15.0 3 23.8 10.0 4 - 7.2 4.0 5 6.6 11.8 6 9 20.5 30.6 18.9 17.6 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. X Open spreadsheet a. Use a spreadsheet (or a calculator with a linear regression function) to determine Stock X's beta coefficient. Do not round intermediate calculations. Round your answer to two decimal places. Beta = b. Determine the arithmetic average rates of return for Stock X and the NYSE over the period given. Calculate the standard deviations of returns for both Stock X and the NYSE. Do not round intermediate calculations. Round your answers to two decimal places. NYSE Stock X Average return,π Avg % % Standard deviation, σ % % c. Assume that the situation during Years 1 to 7 is expected to prevail in the future (i.e., x = TX, Average ↑ M = TM,…
Using the data from Table 12.3 E, what is the volatility of an equally weighted portfolio of Coca - Cola and Starbucks stock? The volatility of the portfolio is %. (Round to one decimal place.) Data Table TABLE 12.3 Estimated Annual Volatilities and Correlations for Selected Stocks (Based on Monthly Returns, January 2006–December 2015) Standard Microsoft Starbucks Netflix Соса-Cola McDonald's Cisco Boelng Deviation 25% 29% 61% 16% 14% 28% 26% Microsoft 1 0.35 0.18 0.40 0.43 0.52 0.28 Starbucks 0.35 1 0.19 0.23 0.17 0.52 0.48 Netflix 0.18 0.19 1 0.00 0.13 0.10 0.10 Соса-Cola 0.40 0.23 0.00 0.59 0.27 0.34 McDonald's 0.43 0.17 0.13 0.59 1 0.28 0.37 Cisco 0.52 0.52 0.10 0.27 0.28 1 0.46 Enter your answer in the answe Вoeing 0.28 0.48 0.10 0.34 0.37 0.46 1 Source: Authors' calculations based on data from The Center for Research in Security Prices. Save for Later Print Done

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals Of Financial Management, Concise Edi…

Finance

ISBN:

9781337902571

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning