Question
In: Finance
You wish to create a portfolio consisting of the stocks Coil Inc. and Amp Engines. You observe the following information about past returns:
You wish to create a portfolio consisting of the stocks Coil Inc. and Amp Engines. You observe the following information about past returns:
Furthermore, your analysts have provided a preliminary report about the individual stock performance:
You consider investing 89% in stock A and 11% in stock B.
a) Compute the covariance and correlation between both stocks!
b) Compute the expected return of this portfolio!
c) Compute the expected volatility of this portfolio!
Solutions
Expert Solution
a.
Covariance and correlation can be calculated using below formula.
| Annual Return | Coil | Amp |
| 2018 | 5.26% | 4.84% |
| 2019 | 5.18% | 16.49% |
| 2020 | 4.70% | -4.45% |
| Avg | 5.05% | 5.63% |
| Covariance | 0.0179% | |
| Correlation | 56.78% |
| Weight | 89.00% | 11.00% | |
| Avg Return | 5.05% | 5.63% | |
| Volatility | 0.30% | 10.49% |
b.
Expected retun of the portfolio
| Expected return of Portfolio | 5.113800% | =(weight of stock a * expected return of stock a) + (weight of stock b * expected return of stock b) |
c. Expected volatility
| Portfolio Volatility | 4.873% |
Junaid answered 1 year agoRelated Solutions
You own a portfolio consisting of the following stocks:
You own a portfolio consisting of the following stocks:
Stock % of Portfolio Beta Historical Return Required Return
1 13% 1.15 .11
2 44% 0.95 .08
3 19% 1.60 .14
4 24% 1.30 .12
The risk-free rate is 5% and the expected market return is 10%.
a. Calculate the required return for each stock.
b. Calculate the historical return on the portfolio.
c. Calculate the portfolio beta.
d. Calculate the required return...
The following table contains the historic returns from a portfolio consisting of large stocks and a...
The following table contains the historic returns from a
portfolio consisting of large stocks and a portfolio consisting of
long-term Treasury bonds over the last 20 years. T-bills returns
represent risk-free returns. Analyze the risk-return trade-off that
would have characterized these portfolios. The following dataset is
also available in Excel format in Module 3 Resources on Canvas.
Returns in the dataset are in percents. For example, 31.33 means
31.33% per year.
Year
Large Stock
Long-Term
T-Bonds
T-Bills
1997
31.33
11.312...
The following table contains the historic returns from a portfolio consisting of large stocks and a...
The following table contains the historic returns from a
portfolio consisting of large stocks and a portfolio consisting of
long-term Treasury bonds over the last 20 years. T-bills returns
represent risk-free returns. Analyze the risk-return trade-off that
would have characterized these portfolios. The following dataset is
also available in Excel format in Module 3 Resources on Canvas.
Returns in the dataset are in percents. For example, 31.33 means
31.33% per year.
Year
Large Stock
Long-Term
T-Bonds
T-Bills
1997
31.33
11.312...
Portfolio returns and deviations. Consider the following information on a portfolio of three stocks: State of...
Portfolio returns and deviations. Consider the following
information on a portfolio of three stocks:
State of
Probability
of
Stock A Rate of return Stock B
ROR Stock C ROR
Economy
State of Economy
Boom
.15
.02
.32
.60
Normal
.60
.10
.12
.20
Bust
.25
.16
-.11
-.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? the standard deviation?
b. if...
You are given the following information about the stocks in a two-stock portfolio:
You are given the following information about the stocks in a two-stock portfolio:
Stock
Return
Portfolio Weight
Standard Deviation
The Blue Hotel, Inc.
22%
45%
9%
Joys Food, Inc.
25%
55%
11%
Correlation coefficient between the two stocks is 0.5.
Using the information above, calculate the following:
The expected return of the portfolio,
The variance of the portfolio,
The standard deviation of the portfolio.
（All calculations must be shown for intermediate calculations）
For the stocks A and B you observe the following monthly returns over the last three...
For the stocks A and B you observe the following monthly returns
over the last three months:
Month
A
B
1
8.62%8.62%
1.80%1.80%
2
18.01%18.01%
7.04%7.04%
3
15.20%15.20%
10.91%10.91%
Compute the covariance and correlation between these two
stocks.(rounded to four decimal places)
Select one:
a. 0.00110.0011; 0.52670.5267
b. 0.00110.0011; 0.47350.4735
c. 0.00160.0016; 0.68870.6887
d. 0.00160.0016; 0.73000.7300
e. 0.00110.0011; 0.4994
Create a portfolio using the four stocks and information below:
Create a portfolio using the four stocks and information below: (Do not round intermediate calculations. Record your answers in decimal form and round your answers to 4 decimal places. Ex. X.XXXX)What is the variance of A?What is the variance of B?What is the variance of C?What is the variance of D?What is the Correlation (A,A)?What is the Correlation (B,B)?What is the Correlation (C,C)?What is the Correlation (D,D)?What is the Covariance (A,A)?What is the Covariance (A,B)?What is the Covariance (A,C)?What is the...
Consider a portfolio consisting of the following three stocks: Portfolio Weight Volatility Correlation with Market Portfolio...
Consider a portfolio consisting of the following three
stocks:
Portfolio Weight
Volatility
Correlation with Market Portfolio
HEC Corp
0.26
13%
0.35
Green Midget
0.29
28%
0.52
Alive And Well
0.45
11%
0.54
The volatility of the market portfolio is 10% and it has an
expected return of 8%. The risk-free
rate is 3%.
Compute the beta and expected return of each stock.
Using your answer from part (a), calculate the expected return
of the portfolio.
What is the beta of...
Given the following information about the returns of stocks A, B, and C, what is the...
Given the following information about the returns of stocks A,
B, and C, what is the expected return of a portfolio invested 30%
in stock A, 40% in stock B, and 30% in stock C?
State of Economy
Probability
Stock A
Stock B
Stock C
Boom
0.19
0.36
0.24
0.37
Good
0.22
0.21
0.12
0.24
Poor
0.28
0.06
0
0.02
Bust
--
-0.1
-0.27
-0.25
Answer must be in percents!
Given the following information about the returns of stocks A, B, and C, what is the...
Given the following information about the returns of stocks A,
B, and C, what is the expected return of a portfolio invested 30%
in stock A, 40% in stock B, and 30% in stock C?
State of economy
Probability
Stock A
Stock B
Stock C
Boom
0.14
0.33
0.36
0.26
Good
0.29
0.29
0.15
0.27
Poor
0.21
0
0.01
0.02
Bust
--
-0.19
-0.21
-0.11
Enter answer in percents.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Why normalization and referential integrity are important principles when designing relational databases?
- Respond to the following in a minimum of 175 words: Discuss what elements should be present...
- 1) The 3rd bright fringe of a double slit interference pattern is 30.0 cm above the...
- A solar cell generates a potential difference of 0.320 V when a 445.0 ? resistor is...
- A ceiling fan consists of a small cylindrical disk with 5 thin rods coming from the...
- You measure the following quantities as A = 1.0 m ± 0.2 m, B = 2.0...
- Froya Fabrikker A/S of Bergen, Norway, is a small company that manufactures specialty heavy equipment for...
ADVERTISEMENT