list11Data tableKUsing the data from Table 12.3 . what is the volatility of an equally weighted portfolio ofMicrosoft and Coca-Cola stock?The volatility of the portfolio is %. (Round to one decimal place.)TABLE 12.3Estimated Annual Volatilities and Correlations for Selected Stocks(Based on Monthly Returns, January 2009-December 2018)StandardMicrosoft StarbucksNetflixCoca-ColaMcDonald'sCiscoDeviation22%20%62%13%13%24%Microsoft10.290.230.320.330.52Starbucks0.2910.050.300.400.36Netflix0.230.05-0.040.000.10Coca-Cola0.320.30-0.040.530.11McDonald's0.330.400.000.5310.22Cisco0.520.360.100.110.22Boeing0.310.210.190.300.240.43Source: Authors' calculations based on data from Yahoo Finance.PrintDone<-- X

We can calculate the volatility by using the formula : σ=w12σ12+w22σ22+2w1w2ρ1,2σ1σ2…

Answered: list 11 Data table K Using the data…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter2: The Domestic And International Financial Marketplace

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

Directions: Compute the returns, average of returns and standard deviation of the following stocks and the PSEI. 1. 2. AGI SM Year Stock Return x x (x--x)² Year Stock Return x x (x-x)² Price Price 30/1/2014 27.100 30/1/2014 704.500 28/2/2014 30.000 28/2/2014 694.000 31/3/2014 28.500 31/3/2014 705.000 30/4/2014 31.150 30/4/2014 725.000 30/5/2014 29.650 30/5/2014 786.000 30/6/2014 29.100 30/6/2014 816.000 31/7/2014 26.350 31/7/2014 797.000 29/8/2014 24.600 29/8/2014 772.000 30/9/2014 26.000 30/9/2014 803.500 31/10/2014 25.300 31/10/2014 783.500 28/11/2014 24.800 28/11/2014 804.500 29/12/2014 22.550 29/12/2014 815.000 PSEI Year Stock Return x X (x-X)? 30/6/2014 6,844.31 Price 31/7/2014 6,864.82 30/1/2014 6,041.19 29/8/2014 7,050.89 3. 28/2/2014 6,424.99 30/9/2014 7,283.07 31/10/2014 7,215.73 31/3/2014 6,428.71 28/11/2014 7,294.38 30/4/2014 6,707.91 29/12/2014 7,230.57 30/5/2014 6,647.65
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
Using the data in the following table, and the fact that the correlation of A and B is 0.06, calculate the volatility (standard deviation) of a portfolio that is 70% invested in stock A and 30% invested in stock B. The return of stock A is ☐ %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Realized Returns Year Stock A Stock B 2017 15% 24% 2018 12% 22% 2019 9% 10% 2020 -4% -4% 2021 4% -3% 2022 11% 22%
Using the data in the following table, calculate the volatility (standard deviation) of a portfolio that is 60% invested in stock A and 40% in stock B. The volatility of the portfolio is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Stock A Stock B 2010 2011 2012 2013 2014 2015 -10% 19% 4% -3% 5% 12% 19% 39% 24% -8% -8% 35% Print Done Х
Using the data in the following table, E, calculate the volatility (standard deviation) of a portfolio that is 55% invested in stock A and 45% in stock B. The volatility of the p Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Stock A 2010 2011 2012 2013 2014 2015 -14% 11% 4% -10% 2% 12% Stock B 25% 33% 13% -3% -13% 26% Print Done - X
Using the data in the following table, calculate the volatility (standard deviation) of a portfolio that is 68% invested in stock A and 32% in stock B. The volatility of the portfolio is ☐ %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2010 2011 2012 2013 2014 2015 Stock A -6% 20% 3% - 1% 5% 15% Stock B 17% 4% 1% -1% - 12% 25% Print Done - ☑
Using the data in the following table, The average annual return for stock A is calculated the volatility (standard deviation) of a portfolio that is 35% invested in stock A and 65% invested in stock B. %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Stock A 2010 2011 2012 2013 2014 2015 - 1% 5% 5% - 3% 5% 5% Stock B 30% 38% 20% - 2% - 5% 28% Print Done - ☑
Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock A is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2010 2011 20% 2013 - 1% - 13% Stock A Stock B 20% 12% - 9% Print 2012 8% 9% C Done 2014 4% - 9% 2015 11% 27% - X
Using the data in the following table, and the fact that the correlation of A and B is 0.48, calculate the volatility (standard deviation) of a portfolio that is 70% invested in stock A and 30% invested in stock B. (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2008 2009 2010 2011 2012 2013 Realized Returns Stock A - 10% 20% 5% - 5% 2% 9% Stock B 21% 30% 7% - 3% - 8% 25% The standard deviation of the portfolio is %. (Round to two decimal places.)
Using the data in the following table,, estimate the: a. Average return and volatility for each stock. b. Covariance between the stocks. c. Correlation between these two stocks. a. Estimate the average return and volatility for each stock. The average return of stock A is %. (Round to two decimal places.) Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year Stock A 2010 2011 2012 2013 2014 2015 - 1% 6% 2% -5% 4% 6% Stock B 20% 9% 8% -3% - 5% 21% Print Done ☑ Clear
Stocks A and B have the following historical returns: Year Stock A's Returns, rA Stock B's Returns, rA 2014 (19.00 (14.70 %) 2015 34.75 19.50 2016 13.75 30.90 2017 (4.25 (9.30 ) 2018 34.25 33.10 Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places. Stock A Stock B Portfolio CV Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio?
Using the data in the following table, estimate the average return and volatility for each stock. (Click on the following icon in order to copy its contents into a spreadsheet) Realized Returns Year 2008 2009 2010 2011 2012 2013 Stock A -1% 13% 3% -3% 5% 11% Stock B 17% 20% 11% -3% -3% 32% The return of stock A is%. (Round to two decimal places.) CUIS

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Pfin (with Mindtap, 1 Term Printed Access Card) (…

Finance

ISBN:

9780357033609

Author:

Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:

Cengage Learning

International Financial Management

Finance

ISBN:

9780357130698

Author:

Madura

Publisher:

Cengage

Fundamentals of Financial Management, Concise Edi…

Finance

ISBN:

9781285065137

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Fundamentals Of Financial Management, Concise Edi…

Finance

ISBN:

9781337902571

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS