
Excel formula:

Check my Fill in the missing information in the following table. Assume that Portfolio AB is...
Fill in the missing information in the following table. Assume that Portfolio AB is 40 percent invested in Stock A. (A negative value should be indicated by a minus sign. Do not round intermed iate calculations. Enter your answers as a percent rounded to 2 decimal places.) Annual Returns on Stocks A and B Year Stock A Stock B Portfolio AB 21 % 11 % 2012 (38) % 37 % 2013 2014 48% (21) % 2015 16 % 26 %...
Fill in the missing information in the following table. Assume that Portfolio AB IS 60 percent invested in Stock A. (Round your answer to 2 decimal places. Negative amounts should be indicated by a minus sign. Omit the "%" sign in your response.) Annual Returns on Stocks A and B Stock A Stock B Year Portfolio AB 16% 35% -17% 2006 2007 2008 2009 2010 Avg return Std deviation 24% -35% 45% 17% 25% 15% 27% 16.00% od
Fill in the missing data in the following table. Year Nominal GDP GDP deflator Real GDP $ 2012 $220000 100.0 2013 $215,000 110.0 2014 $260,000 $220,000 2015 $290,000 $ 123.0 2016 $240,000 130.0
Using Okun's law, fill in the four pieces of missing data in the table below. All of the following data are hypothetical Natural Actual Potential Unemployment Unemployment Year 2012 2013 2014 2015 Real GDP 15, 040 15,800 GDP Rate () Rate ( 16,000 16,000 16,500 3.5 17,160 Instruction: Enter your responses as whole numbers a. Actual unemployment rate in 2012 b. Potential GDP in 2013: $ 15800 c. Real GDP in 2014: $ 32000 Instructions: Enter your response rounded to...
* 8. Fill In the missing data in the following table. Nominal GDP (thousands of $) Real GDP (thousands of $) GDP Deflator Year $100 100.0 2013 108.0 2014 $110 2015 130 777 120.0 150 2016 2017 136 125.0
Consider the following information about 2 stocks: Year Stock Price Stock Price 2010 136.07 517.56 2011 138.97 525.17 2012 139.57 515.05 2013 142.13 532.76 2014 140.26 540.12 2015 143.89 544.32 2016 144.07 527.05 2017 142.67 557.43 2018 145.46 558.09 Calculate: -expected return and standard deviation for stock A; -expected return and standard deviation for stock B; -correlation, covariance, and beta between stocks A and B; -portfolio return and standard deviation, assuming 40% is invested in stock A
Assume the risk-free rate is 4.1% and expected market return is 10.2%. Suppose that you have observed the following returns over time: Year Stock A Stock B Market 2012 5% 14% 12% 2013 7% 15% 10% 2014 -9% -17% -12% 2015 1.5% 3% 1% 2016 10% 18% 15% 2017 17.5% 24.5% 20% What are the betas of Stock A and Stock B? What are the required rate of returns of Stocks A and B? What is the required rate of...
a. Using a
40/60 split, what is the weighted average standard deviation of the
two stocks?
b. Recalculate the standard deviation of a
portfolio of the two stocks
c. What is the reduction in standard deviation
that results from the creation of a portfolio of the two
stocks?
WeVest Financial Advisors suggests an investment in two stocks (40% in Stock A and 60% in Stock B). They claim the investment will reduce risk through diversification, but they need proof. This...
Check my work Assume these are the stock market and Treasury bill returns for a 5-year period: Year 2013 2014 2015 2016 2017 Stock Market Return (%) 31.90 11.20 -1.90 13.30 21.60 T-Bill Return ($) 0.04 0.04 0.04 0.22 0.24 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.)...
WeVest Financial Advisors suggests an investment in two stocks (40% in Stock A and 60% in Stock B). They claim the investment will reduce risk through diversification, but they need proof. This is the historical returns for the two stocks. Year Returns (%) Stock A Stock B 2012 14.72% 10.36% 2013 15.60% 11.30% 2014 12.69% 10.91% 2015 10.90% 12.26% 2016 11.40% 7.96% a. Using a 40/60 split, what is the weighted average standard deviation of the two stocks? (Enter your...