Question

In: Finance

SHOW YOUR WORK, DO NOT USE EXCEL Consider a portfolio consisting of the following two assets:...

SHOW YOUR WORK, DO NOT USE EXCEL

Consider a portfolio consisting of the following two assets:  Stock A has E[RA] = 10% and ?? = 20%  Stock B has E[RB] = 20% and ?? = 40% Calculate the expected return and standard deviation of the portfolio under the four following sets of assumptions:

(a) wA = 1/2 and wB = 1/2 and ???= 0

(b) wA = 1/2 and wB = 1/2 and ???= -1 (c) wA = 2/3 and wB = 1/3 and ??? = 0

(d) wA = 2/3 and wB = 1/3 and ??? = -1

Solutions

Expert Solution

a

Expected return%= Wt Asset A*Return Asset A+Wt Asset B*Return Asset B
Expected return%= 0.5*0.1+0.5*0.2
Expected return%= 15
Variance =( w2A*σ2(RA) + w2B*σ2(RB) + 2*(wA)*(wB)*Cor(RA, RB)*σ(RA)*σ(RB))
Variance =0.5^2*0.2^2+0.5^2*0.4^2+2*0.5*0.5*0.2*0.4*0
Variance 0.05
Standard deviation= (variance)^0.5
Standard deviation= 22.36%

b

Expected return%= Wt Asset A*Return Asset A+Wt Asset B*Return Asset B
Expected return%= 0.5*0.1+0.5*0.2
Expected return%= 15
Variance =( w2A*σ2(RA) + w2B*σ2(RB) + 2*(wA)*(wB)*Cor(RA, RB)*σ(RA)*σ(RB))
Variance =0.5^2*0.2^2+0.5^2*0.4^2+2*0.5*0.5*0.2*0.4*-1
Variance 0.01
Standard deviation= (variance)^0.5
Standard deviation= 10.00%

c

Expected return%= Wt Asset A*Return Asset A+Wt Asset B*Return Asset B
Expected return%= 0.6666*0.1+0.3333*0.2
Expected return%= 13.33
Variance =( w2A*σ2(RA) + w2B*σ2(RB) + 2*(wA)*(wB)*Cor(RA, RB)*σ(RA)*σ(RB))
Variance =0.6666^2*0.2^2+0.3333^2*0.4^2+2*0.6666*0.3333*0.2*0.4*0
Variance 0.03555
Standard deviation= (variance)^0.5
Standard deviation= 18.85%

d

Expected return%= Wt Asset A*Return Asset A+Wt Asset B*Return Asset B
Expected return%= 0.6666*0.1+0.3333*0.2
Expected return%= 13.33
Variance =( w2A*σ2(RA) + w2B*σ2(RB) + 2*(wA)*(wB)*Cor(RA, RB)*σ(RA)*σ(RB))
Variance =0.6666^2*0.2^2+0.3333^2*0.4^2+2*0.6666*0.3333*0.2*0.4*-1
Variance 0
Standard deviation= (variance)^0.5
Standard deviation= 0.00%

Related Solutions

Answer the following questions and use Excel or this document to show your work. 1. Consider...
Answer the following questions and use Excel or this document to show your work. 1. Consider the following results for two samples randomly taken from two normal populations with equal variances. Sample I Sample II Sample Size 28 35 Sample Mean 48 44 Population Standard Deviation 9 10 a. Develop a 95% confidence interval for the difference between the two population means. b. Is there conclusive evidence that one population has a larger mean? Explain.
Please Use Excel To Show All Work, I will like your asnwer if you do this...
Please Use Excel To Show All Work, I will like your asnwer if you do this :) 15.35 Refer to the Johnson Filtration problem introduced in this section. Suppose that in addition to information on the number of months since the machine was serviced and whether a mechanical or an electrical repair was necessary, the managers obtained a list showing which repairperson performed the service. The revised data follow. Repair Time in Hours Months Since Last Service Type of Repair...
(Note: show your work, do not use excel) Real Options and Option to Abandon Problem: An...
(Note: show your work, do not use excel) Real Options and Option to Abandon Problem: An integrated oil company is evaluating the exploration and development of an oil field. Initial investment of $100 mil is needed for start-up costs. After a year of start-up, three levels of oil are expected to be uncovered. There is a 20% chance of getting a high level with expected annual FCFF of $25 mil for 20 years; a 60% chance that annual FCFF will...
Use Excel to show your work and include the formula in the cell to show how...
Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...
Answer the following questions and use Excel to show your work. The mean time required to...
Answer the following questions and use Excel to show your work. The mean time required to complete a certain type of construction project is 52 weeks with a standard deviation of 3 weeks. Answer questions 4–7 using the preceding information and modeling this situation as a normal distribution. 4. What is the probability of the completing the project in no more than 52 weeks? a) 0.25 b) 0.50 c) 0.75 d) 0.05 5. What is the probability of the completing...
Answer the following questions and use Excel to show your work. A student has an important...
Answer the following questions and use Excel to show your work. A student has an important exam coming up and is contemplating not studying for the exam in order to attend a party with his friends. The student must earn a minimum score of 70% on the exam in order to successfully maintain his desired GPA. Suppose the student knows in advance that the exam will consist of 20 multiple-choice questions with 4 possible answers for each question. Answer questions...
Answer the following questions and use Excel to show your work. Customers arrive at a supermarket...
Answer the following questions and use Excel to show your work. Customers arrive at a supermarket check-out counter with an average arrival rate of 9 customers per hour. Answer questions 8–10 using the preceding information and modeling this situation as a Poisson distribution. 8. What is the probability of less than 5 customers arriving at the supermarket check-out counter in a given 1-hour period? a) 0.054 b) 0.446 c) 0.359 d) 0.612 9. What is the probability of exactly 12...
PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on...
PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on the information provided below. What dollar amount will you invest in each stock to achieve the desired return goal? Stock X Stock Y Expected Return 14.0% 9.0% Goal Return of Portfolio: 10.00% Dollar Amount to Invest: $20,000
Consider a portfolio consisting of 2 assets, a share with a beta of 0.9 and market...
Consider a portfolio consisting of 2 assets, a share with a beta of 0.9 and market risk premium of 15%, and a risk-free asset with an expected return of 4%. If the portfolio weighting is 40% of shares and 60% of the risk-free asset what is the expected return on the portfolio? a. 10.6% b. 9.4% c. 8.4% d. 7.69%
Formulate the problem as a linear programming model use excel and show your excel work. Thank...
Formulate the problem as a linear programming model use excel and show your excel work. Thank you. To (cost, in 100's) From New york Philadelphia Chicago Boston Supply Tampa $9 $14 $12 $17 200 Miami 11 10 6 10 200 Fresno 12 8 15 7 200 Demand 130 170 100 50
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT