In: Finance
Suppose the return for stocks A and B for the last six months have been the following:
A. B
3,2% 4,7%
4,1% 2,0%
-2,7% 1,4%
-0,5% -0,8%
6,7% 2,7%
5,5% -1,2%
a. What is the expected return, variance and standard deviation of the two stocks? What is the covariance and correlation among them?
b. What would the return and standard deviation of a portfolio that is 30% invested in stock A and 70% invested in stock B be?
STOCK A | |||||||
R1 | D1=R1-2.72 | E1=D1^2 | |||||
Period | Return(%) | Deviation from Mean | Deviation Squared | ||||
1 | 3.2 | 0.48 | 0.2304 | ||||
2 | 4.1 | 1.38 | 1.9044 | ||||
3 | -2.7 | -5.42 | 29.3764 | ||||
4 | -0.5 | -3.22 | 10.3684 | ||||
5 | 6.7 | 3.98 | 15.8404 | ||||
6 | 5.5 | 2.78 | 7.7284 | ||||
SUM | 16.3 | SUM | 65.4484 | ||||
EXPECTED RETURN =MEAN=16.3/6= | 2.72% | ||||||
VARIANCE OF RETURN=65.4484/(6-1) | 13.08968 | %% | |||||
STANDARD DEVIATION=SQRT(VARIANCE) | 3.62% | (Square Root (13.08968) | |||||
STOCK B | |||||||
R2 | D2=R2-1.47 | E2=D2^2 | |||||
Period | Return(%) | Deviation from Mean | Deviation Squared | ||||
1 | 4.7 | 3.23 | 10.4329 | ||||
2 | 2.0 | 0.53 | 0.2809 | ||||
3 | 1.4 | -0.07 | 0.0049 | ||||
4 | -0.8 | -2.27 | 5.1529 | ||||
5 | 2.7 | 1.23 | 1.5129 | ||||
6 | -1.2 | -2.67 | 7.1289 | ||||
SUM | 8.8 | SUM | 24.5134 | ||||
EXPECTED RETURN =MEAN=8.8/6= | 1.47% | ||||||
VARIANCE OF RETURN=24.5134/(6-1) | 4.90268 | %% | |||||
STANDARD DEVIATION=SQRT(VARIANCE) | 2.21% | (Square Root (4.90268) | |||||
COVARIANCE AND CORRELATION | D1=R1-2.72 | D2=R2-1.47 | F=D1*D2 | ||||
Period | Deviation from Mean(Stock A)(%) | Deviation from Mean(Stock B)(%) | Deviation StockA*Deviation StockB | ||||
1 | 0.48 | 3.23 | 1.5504 | ||||
2 | 1.38 | 0.53 | 0.7314 | ||||
3 | -5.42 | -0.07 | 0.3794 | ||||
4 | -3.22 | -2.27 | 7.3094 | ||||
5 | 3.98 | 1.23 | 4.8954 | ||||
6 | 2.78 | -2.67 | -7.4226 | ||||
SUM | 7.4434 | ||||||
COVARIANCE OF RETURN A&B=7.4434/6- | 1.240567 | %% | |||||
CORRELATION=(COVARIANCE)/(STD DEVIATION A*STD DEVIATION B) | |||||||
Correlation Coefficient=1.240567/(3.62*2.21) | 0.155 | ||||||
b | Return of Portfolio =Rp | ||||||
Standard Deviation of Portfolio =Sp | |||||||
Portfolio Variance =Vp | |||||||
Rp=w1*R1+w2*R2 | |||||||
w1=Weight of stock A in the portfolio=30%= | 0.3 | ||||||
w2=Weight of stock B in the portfolio=70%= | 0.7 | ||||||
R1=Expected Return of Stock A | 2.72% | ||||||
R2=Expected Return of Stock B | 1.47% | ||||||
Rp=Portfolio Return =0.3*2.72+0.7*1.47= | 1.84% | ||||||
Vp=(w1^2)*(VarianceA)+(w2^2)*VarianceB+2*w1*w2*COVA&B* | |||||||
Variance of Portfolio=(0.3^2)*13.08968+(0.7^2)*4.90268+2*0.3*0.7*1.240567= | 4.1014224 | %% | |||||
Sp=Portfolio Std Deviation=SQRT(Variance)= | 2.03% | Square Root (4.1014224) | |||||
Related SolutionsBased on the last six months of data, suppose that the percent of daily volume that...
Based on the last six months of data, suppose that the percent
of daily volume that occurs in each hour is as follows:
9:30-10:30
20%
10:30-11:30 10%
11:30-12:30 10%
12:30-1:30
10%
1:30-2:30
10%
2:30-3:30
15%
3:30-4:00
25%
You need to design a VWAP algo to buy
28,000 shares
Start time: 12:30
End time 4:00
Please enter your order sizes at the
end of each hour
10:30
11:30
12:30
1:30
2:30
3:30
Close:
For the last six months, Jill has been with A&A Accounting, a multi-billion dollar entity. A&A...For the last six months, Jill has been with A&A Accounting,
a multi-billion dollar entity. A&A has a high-level person
responsible for their ethics compliance program who requires all
personnel to view 20 hours of compliance videos. While on a flight
to another city, Jill happened to sit behind A&A’s ethics
officer and overheard the following: “Yes, Bill, we do have a
pretty good compliance program, but it’s really just window
dressing. Because of the Federal Sentencing Guidelines we have...
Suppose a company has the following sales for the last six months (January – June): Month...Suppose a company has the following sales for the last six
months (January – June):
Month
Period
Sales
January
1
16
February
2
25
March
3
20
April
4
20
May
5
31
June
6
35
July
7
26
August
8
(a)
Use exponential smoothing (a= 0.10) to forecast the sales for
August (to 2 decimals). What is the value?
Compute the MSE for the exponential smoothing method from the
above question (to 2 decimals).
Use a 2-period moving average...
What has been Walmart's recent actions (within the last six months) dealing with risk and uncertainty...What has been Walmart's recent actions (within the last six
months) dealing with risk and uncertainty and what is some advice
to Walmart for improving risk management.
Share references please.
Assume that we have 3 Stocks A, B & C. A B C Expected return 8%...Assume that we have 3 Stocks A, B & C.
A
B
C
Expected return
8%
12%
6%
Variance
0.012
0.028
0.009
If the covariance between stock A & B return is equal to
0.009159, stock A & C return is equal to
-0.005146 and stock B & C return
0.01572
Required
Calculate the Standard Deviation for stock A, B & C. which
stock is risky and why?
Calculate the correlation between every two stocks. What is the
indication of...
Stocks A and B each have an expected return of 15%, a standard deviation of 20%,...Stocks A and B each have an expected return of 15%, a standard
deviation of 20%, and a beta of 1.2. The returns on the two stocks
have a correlation coefficient of -1.0. You have a portfolio that
consists of 50% A and 50% B. Which of the following statements is
CORRECT?
The portfolio's standard deviation is zero (i.e., a riskless
portfolio).
The portfolio's standard deviation is greater than 20%.
The portfolio's expected return is less than 15%.
The portfolio's...
You have been following a stock for 3 months and the following is its past return...You have been following a stock for 3 months and the following
is its past return
Year 1: 7%
Year 2: 13%
Year 3: -3%
What is the standard deviation of the stock based on the
historical data? (Put the answer in decimal points instead of
percentage)
Stocks A and B have the same required return and the same price,$25. Stock A's...Stocks A and B have the same required return and the same price,
$25. Stock A's dividend is expected to grow at a constant rate of
10% per year, while Stock B's dividend is expected to grow at a
constant rate of 5% per year. Which of the following statements is
correct?a. Stock A's expected dividend at t = 1 is only half that of
Stock B.b. Since Stock A's growth rate is twice that of Stock B, Stock
A's...
Suppose we have the following projections for three stocks. What is the expected return on stock...Suppose we have the following projections for three stocks. What
is the expected return on stock B? What is the standard deviation
of returns on stock B?
State of Economy
Probability of State of Economy
Returns if State Occurs
Stock A
Stock B
Stock C
Boom
0.4
10%
15%
20%
Bust
0.6
8%
5%
0%
Research documents that firms with high historical returns in the last six months will continue such...
Research documents that firms with high historical returns in
the last six months will continue such performance in the next six
months, which is termed as momentum in literature. How will you
explain this finding if you believe in EMH? What will be your
explanation if you believe in behaviour finance? (20
marks)
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|