Question

In: Finance

The analysis of outcomes for sales and the associated rate of return on common stocks for...

The analysis of outcomes for sales and the associated rate of return on common stocks for companies X and Y are shown below. You intend to form a portfolio by allocating $3750 of your total wealth of $5000 in company X, and the remainder in company Y. The covariance between the two companies is -0.000927. Show all work to receive credit.

DECLINING FLAT RISING
probability 40% 25% 35%
% of return X -0.4% 10.8% 21.7%
% of return Y 5.2% 18.3% 23.5%

1. What is the expected return and standard deviation for common stock in each company?

2. What is the portfolio return and standard deviation for this two stock portfolio? Explain in words how and why portfolio variance is different than the individual standard deviation of the stocks?

Solutions

Expert Solution

1. Expected Return of X  =Probability of Flat*Return of X+Probability of Rising*Return of X in Rising+Probability of Other Scenario*Return of X =40%*-0.4%+25%*10.80%+35%*21.7% =10.135% or 10.14%
Standard Deviation of X =(40%*(-0.4%-10.135%)^2+25%*(10.80%-10.135%)^2+35%*(21.7%-10.135%)^2)^0.5=9.5560%
or 9.56%
Expected Return of Y  =Probability of Flat*Return of Y+Probability of Rising*Return of Y in Rising+Probability of Other Scenario*Return of Y=40%*5.2%+25%*18.30%+35%*23.50% =14.88%
Standard Deviation of Y=(40%*(5.2%-14.88%)^2+25%*(18.30%-14.88%)^2+35%*(23.50%-14.88%)^2)^0.5=8.1493%
or 8.15%

2. Weight of X =3750/5000 =75%
Weight of Y =25%
Expected Return =Weight of X*Expected Return of X+Weight of Y*Expected Return of Y
=75%*10.135%+25%*14.88% =11.32%
Standard Deviation with Covariance =((Weight of X*Standard Deviation of X)^2+(Weight of Y*Standard Deviation of Y)^2+2*Weight of X*Weight of Y*Covariance)^0.5 =((75%*9.5560%)^2+(25%*8.1493%)^2+2*75%*25%*-0.000927)^0.5 =
7.21%
Portfolio standard Deviation is different from individual stocks because of following reasons
1. The covariance is negative which reduces the overall standard deviation as compared to individual stocks. Higher the covariance higher is the standard deviation of portfolio and lower the covariance lower is the standard deviation of portfolio.
2. Weights of the stocks are different,which creates the variation the standard deviation.


Related Solutions

The annual rates of return for Canadian common stocks and Japanese common stocks are provided in...
The annual rates of return for Canadian common stocks and Japanese common stocks are provided in the following table: Year Canadian Common Stocks Japanese Common Stocks 2014 -.141 .051 2015 .088 .229 2016 .280 -.224 2017 .050 .313 2018 .210 .155 2019 .220 .009 1. Compute the arithmetic mean rate of return and sample standard deviation of rates of returns for the two series. Discuss these two alternative investments in terms of their arithmetic average rates of return and their...
Rate of Return Analysis: The table below shows the cash flows associated with a certain investment....
Rate of Return Analysis: The table below shows the cash flows associated with a certain investment. (a) How many possible rates of return are there for this set of cash flows? (b) Find all the rate of return values for these cash flows between 0% and 100%. Please, explain and show solution procedures. Year                              0                    1                2               3                4                  5                   6 Cash Flow ($)         15,000          -30,000         1500          6000          6000          6000            6000
What are the Problems associated with Internal Rate of Return ("IRR") analysis? Why do people use...
What are the Problems associated with Internal Rate of Return ("IRR") analysis? Why do people use this, then?
a) Define rate of return analysis and list one advantage of rate of return analysis. b)...
a) Define rate of return analysis and list one advantage of rate of return analysis. b) How do fees or discounts affect the interest rate? c) Explain some of the disadvantages of rate of return analysis (Hint, think about how they are dealt with.)
Consider the following scenario analysis:    Rate of Return Scenario Probability Stocks Bonds Recession 0.2 -5...
Consider the following scenario analysis:    Rate of Return Scenario Probability Stocks Bonds Recession 0.2 -5 % 17 % Normal economy 0.6 18 11 Boom 0.2 24 4 Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds. a. What is the rate of return on the portfolio in each scenario? (Enter your answer as a percent rounded to 1 decimal place.) b. What are the expected rate of return and standard deviation of the portfolio? (Do...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.2 -7 %...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.2 -7 % 19 % Normal economy 0.5 20 7 Boom 0.3 23 6 Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds. a. What is the rate of return on the portfolio in each scenario? Rate of Return Recession_______% Normal economy_______% Boom______% b. What are the expected rate of return and standard deviation of the portfolio? Expected return____% Standard deviation_____% c. Would...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.3 -5 %...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.3 -5 % 14 % Normal economy 0.6 15 10 Boom 0.1 24 5 Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds. What is the rate of return on the portfolio in each scenario? (Enter your answer as a percent rounded to 1 decimal place.) b. What are the expected rate of return and standard deviation of the portfolio? (Do not round...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.2 -5 %...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.2 -5 % 13 % Normal economy 0.5 14 9 Boom 0.3 23 4 Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds. a.What is rate of return on the portfolio in each scenario? (Enter your answer as a percent rounded to 1 decimal place.) Recession rate of return:?% Normal Economy rate of return:?% Boom rate of return:?% b. What are the expected...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.3 -4 %...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.3 -4 % 12 % Normal economy 0.4 13 7 Boom 0.3 22 3 Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds. a. What is the rate of return on the portfolio in each scenario? (Enter your answer as a percent rounded to 1 decimal place.) Rate of Return Recession % Normal economy % Boom % b. What are the expected rate...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.3 -4 %...
Consider the following scenario analysis: Rate of Return Scenario Probability Stocks Bonds Recession 0.3 -4 % 12 % Normal economy 0.4 13 7 Boom 0.3 22 3 Assume a portfolio with weights of 0.60 in stocks and 0.40 in bonds. a. What is the rate of return on the portfolio in each scenario? (Enter your answer as a percent rounded to 1 decimal place.) b. What are the expected rate of return and standard deviation of the portfolio? (Do not...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT