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..

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter8: Time Series Analysis And_forecasting

Section: Chapter Questions

Problem 16P: The following table reports the percentage of stocks in a portfolio for nine quarters: a. Construct...

See similar textbooks

Similar questions

Suppose that the returns on an investment are normally distributed with an expected return of 16% and standard deviation of 3%. What is the likelihood of receiving a return that is equal to or less than 19%? (Hint: the area under a curve for 1 std dev is 34.13%, 2 std dev is 47.73% and 3 std dev is 49.87%.).
Compute the (a) expected return, (b) standard deviation, and (c) coefficient of variation for investments with the following probability distributions: Probability r/A r/B 0.3 30.0% 5.0% 0.2 10.0 15.0 0.5 -2.0 25.0
Please answer fast i give you upvote.
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%
Suppose we form a portfolio invested in Mercedes and BMW stocks. The two stocks are equally weighted in the portfolio. The table below displays each stock’s mean return, variance, and standard deviation, as well as their covariance. Estimate the mean and variance of this portfolio, as well as its standard deviation. Show in detail your Asset returns Mercedes BMW Mean return 1.78% -0.48% Variance 0.0456 0.0276 Standard deviation 21.35% 16.61% Covariance 0.0020
An investiment portfolio consists of two securities, X and Y. The weight of X is 30%. Asset X's expected return is 15% and the standard deviation is 28%. Asset Y's expected return is 23% and the standard deviation is 33%. Assume the correlation coefficient between X and Y is 0.37. A. Calcualte the expected return of the portfolio. B. Calculate the standard deviation of the portfolio return. C. Suppose now the investor decides to add some risk free assets into this portfolio. The new weights of X, Y and risk free assets are 0.21, 0.49 and 0.30. What is the standard deviation of the new portfolio?
Calculate the (a) expected return, (b) standard deviation, and (c) coefficient of variation for an investment with the following probability distribution: Probability Payoff 0.45 32.0% 0.35 -4.0% 0.20 -20.0%
Two investments generated the following annual returns (refer to image): a. What is the average annual return on each investment?b. What is the standard deviation of the return on investments X and Y?c. Based on the standard deviation, which investment was riskier?
Consider the following two assets: Asset Expected return Standard deviation of returns 1 18% 30% 2 8% 10% The returns on the two assets are perfectly negatively correlated (i.e. coefficient of -1). Calculate the proportions of assets 1 and 2 that generate a portfolio with a standard deviation of zero. What is the expected return of that portfolio Calculate the expected returns and standard deviations of three other portfolios with weightingsof your choice. Present a graph of your results.
Consider two risky assets that have returns variances of 0.0625 and 0.0324, respectively. The assets' standard deviations of returns are then 25% and 1 8%, respectively. Calculate the variances and standard deviations of portfolio returns for an equal-weighted portfolio of the two assets when their correlation of returns is 1.
A portfolio consists of 70% of investment A and 30% of investment B. The expected returnon investment A is 7% and the expected return on investment B is 9%. The standarddeviation of returns of investment A is 2.19%. The standard deviation of returns ofinvestment B is 4.1%. The correlation coefficient of the returns of investment A andinvestment B=+1. Finda. the expected return from the portfoliob. the standard deviation (risk) of the returns from the portfolio