Assume that you half your money invested in times Mirror, the media comapny, and the other half invested in Unilever, the consumer product giant. The expected returns and standard deviations on the two investments are as follows. Times Mirror Unilever Expected Return 14% 18% Standar Deviation 25% 40% Estimate the variance of the portfolio as a function of the correlation coefficient. (Start with -1 and increase the correlation to + 1 in0.2 increments). Pleaase use excel and provide formulas so I can learn how to use excel..

Assume that you half your money invested in times Mirror, the media comapny, and the other half invested in Unilever, the consumer product giant. The expected returns and standard deviations on the two investments are as follows. Times Mirror Unilever Expected Return 14% 18% Standar Deviation 25% 40% Estimate the variance of the portfolio as a function of the correlation coefficient. (Start with -1 and increase the correlation to + 1 in0.2 increments). Pleaase use excel and provide formulas so I can learn how to use excel..

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter8: Analysis Of Risk And Return

Section: Chapter Questions

Problem 5P

See similar textbooks

Similar questions

Suppose Johnson & Johnson and Walgreen Boots Alliance have expected returns and volatilities shown here, with a correlation of 20%. Calculate a. the expected return and b. the volatility(standard deviation) of a portfolio that consists of a long position of $12,000 in Johnson & Johnson and a short position of $2,000 in Walgreens. Expected Return Standard Deviation Johnson & Johnson 7.7% 16.5% Walgreens 9.4% 19.2%
Consider the following information regarding a new investment that a company intends toundertake:.State of the Economy Probability Market Return Investment ReturnExpansion 0.30 40% 60%Normal 0.50 10% 25%Recession 0.20 -15% -40%a). Compute the variance and standard deviation of each b). Compute the correlation between the market the investment return(s) c). Compute the beta of the investment d). Assuming the risk free rate is 5% p.a. Compute the required rate return and advice if the investment is worth undertaken.
Consider a position consisting of 200,000 investment in asset A and 300,000 investment in asset B. Assume that the daily volatility of the assets are 1.5% and 1.8% respectively, and that coefficient of correlation between their returns is 0.4. What is the five day 95% VAR for the portfolio (given 95% confidence level represents 1.65 standard deviations on the left side of the normal distribution)?
Consider Microsoft Corporation (MSFT) and Meta Platforms, Inc. (META) that have returns variances of 6.25% and 3.24%, respectively. Calculate the standard deviation of portfolio returns for an equal-weighted portfolio of the two assets when their correlation of returns is 0. A. 24.71% B. 19.20% C. 15.40% D. 10.28%
You have $20,000 available to invest in two securities A and B and a one-year investmenthorizon. Security A has an expected return of 10% and a standard deviation of 30% whilesecurity B has an expected return of 5% and a standard deviation of 20%. If the returns on thesesecurities are perfectly negatively correlated, the expected return of the minimum varianceportfolio is closest to: A. 6.67%.B. 7.00%.C. 8.00%.D. 8.33%.
Consider a position consisting of a K200,000 investment in Asset A and a K300,000 investment in Asset B. Assume that the daily volatilities of the assets are 1.5% and 1.8% respectively, and that the coefficient of correlation between their returns is 0.4. What is the five day 95% Value at Risk (VaR) for the portfolio (95% confidence level represents 1.65 standard deviations on the left side of a normal distribution)?
Compute the weights in a portfolio consisting of two kinds of stock if the expected return on the portfolio is to be E(KV ) = 20%, given the following information on the returns on stock 1 and 2: Scenario ω1 (recession) Probability Return K1 Return K2 0.1 ω2 (stagnation) 0.5 ω3 (boom) 0.4 −10% 0% 20% 10% 20% 30% To compute the variance of KV we need to know not only the variances of the returns K1 and K2 on the components in the portfolio, but also the covariance between the two returns.
Your portfolio invests in the stock of two companies. Company A’s stock has a variance of 0.25, while Company B’s stock has a standard deviation of 0.30. The correlation between the two stocks is 0.40. If 30% of your portfolio is invested in Company A, and 70% in Company B, what is the standard deviation of your portfolio? A. 28.74% B. 24.96% C. 30.30% D. 28.50%
Consider the following information on a portfolio of three stocks: State of Economy Probability of State of Economy Stock A Rate of Return Stock B Rate of Return Stock C Rate of Return Boom .25 .04 .33 .55 Normal .60 .09 .13 .19 Bust .15 .15 −.14 −.28 If your portfolio is invested 40 percent each in A and B and 20 percent in C, what is the portfolio’s expected return? The variance? The standard deviation? Note: Do not round intermediate calculations. Round your variance answer to 5 decimal places, e.g., .16161. Enter your other answers as a percent rounded to 2 decimal places, e.g., 32.16. If the expected T-bill rate is 3.4 percent, what is the expected risk premium on the portfolio? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.
Consider the following information on a portfolio of three stocks: State of Probability of Economy State of Economy Boom .12 Normal Bust .33 Stock A Rate of Return .07 .16 Stock B Rate of Return .32 .27 -.26 Stock Rate of Return .45 .25 -.35 a. If your portfolio is invested 40 percent each in A and B and 20 percent in C, what is the portfolio's expected return, the variance, and the standard deviation ? Note: Do not round intermediate calculations . Round your variance answer to 5 decimal places, e.g., .16161. Enter your other answers as a percent rounded to 2 decimal places , e.g., 32.16. bIf the expected T-bill rate is 4.5 percent, what is the expected risk premium on the portfolio ? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16 . % a. Expected return Variance Standard deviation % b. Expected risk premium %
Consider the following information on a portfolio of three stocks: State of Economy Probability of State of Economy Stock A Rate of Return Stock B Rate of Return Stock C Rate of Return Boom.13.02.32.50 Normal.55.10.22.20 Bust .32.16.21.35 If your portfolio is invested 40 percent each in A and B and 20 percent in C, what is the portfolio's expected return, the variance, and the standard deviation? Note: Do not round intermediate calculations. Round your variance answer to 5 decimal places, e.g., 16161. Enter your other answers as a percent rounded to 2 decimal places, e. g., 32.16. If the expected T-bill rate is 4.25 percent, what is the expected risk premium on the portfolio? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e. g., 32.16.
Using the single factor model for firm with a Beta of 1 and when the standard deviation of the market is .3. A) What can we say about the standard deviation of this firm’s stock? B) If a new firm Gexco has a Beta of 2 and has a standard deviation of 0.65, what is this Gexco’s firm specific risk? C) Use the known information to find the ratio of explained to total variance, also known as R-squared. Explain what R-square means using words such as systematic and firm specific risk. D) If Gexco’s expected return is 20% and the markets expected return is 12% and the risk free rate is 5%, come up with an estimate of Alpha. Explain and show how a tracking portfolio could be used and what would result. Is the possible gain risk free? 2).Write out the CAPM Model and explain each part.