Reference no: EM131075020
Solve the problem by using the template in the excel file provided and use population formulas provided in the files.
Portfolio Analysis Problem (Excel Spreadsheet)
Solve the following portfolio analysis problem using excel. Be sure to create a general spreadsheet as you will be graded by the accuracy of your spreadsheet for the 8 computations below with a change in some or all of the following: Portfolio Weights, Probabilities, Asset Returns. Be sure to put your name at the top of the spreadsheet and submit as an excel attachment in Canvas. Work out the problem manually before you create your spreadsheet. Check figures have been provided below. Along with the table below, remember to put your portfolio weights (for numbers 5 and 6) at the top of your spreadsheet and cell reference them in your formulas.
|
State
|
Probability
|
% Return A
|
% Return M
|
|
Good
|
.3
|
20
|
16
|
|
Normal
|
.4
|
18
|
10
|
|
Bad
|
.3
|
10
|
14
|
Compute:
1) Expected return for A and M A = 16.2 M = 13
2) Standard deviation for A and M (population) A = 4.1425 M = 2.5690
3) Covariance(A,M) COV = -.6
4) Correlation(A,M) CORR = -.0564
5) Expected return on a portfolio consisting of 30% A and 70% M. P = 13.96
6) Standard deviation of a portfolio consisting of 30% A and 70% M. P = 2.1275
7) The Beta of A. (assume that M is the market) BETA = -.0909
8) The portfolio weights for the minimum risk portfolio. W(A) = .2885 W(M) = .7115
Attachment:- Covariance_Correlation_Population.rar
|
What did you enjoy the most in the interview
: What are the similarities and differences between the ways college life is portrayed in the film, how it is discussed in the text and your own experiences? What do you think accounts for these differences?
|
|
Recommend an action for the board of regents
: 1. Recommend an action for the Board of Regents. 2. Propose a course of action plan that includes quantitative analysis methodologies to assist the Board of Regents with making this decision. 3. Justify all of your recommendations.
|
|
Output voltage of a noninverting op-amp circuit
: 1. Design a summing amplifier based on a 741 IC chip. The amplifier has Rf = 1 M 0, RI = 100 KO, R2 = 50 KO, and R;= 10 KO. The input voltages are VI= 100 mV sin (2000 t), and V. = 150 mV sin (3000 t), and l'3 = 200 mV sin (1000 t). Draw the summi..
|
|
Dispersion models and the structural basis
: First, discuss the six featured dispersion models and the structural basis for each. Second, select one dispersion model to fully describe in detail, while including an appropriate scenario for using that select dispersion model in industry.
|
|
Solve the given portfolio analysis problem using excel
: Solve the following portfolio analysis problem using excel. Be sure to create a general spreadsheet as you will be graded by the accuracy of your spreadsheet for the 8 computations below with a change in some or all of the following: Portfolio ..
|
|
Overcome initial resistance to change
: Managers can adopt various methods to overcome initial resistance to change. In which method does management neutralizes potential or actual resistance by exchanging something of value for cooperation?
|
|
Discuss the differences between the terms hazards
: Discuss the differences between the terms hazards, risk, residual risk, and acceptable risk. What level of risk do you believe constitutes an acceptable risk for machine guarding?
|
|
At what time do the trains pass each other
: At what time do the trains pass each other?
|
|
Create an orthogonal basis for p4
: Let V be P4 with the inner product in Example 2, involving evaluation of polynomials at -2, -1, 0, 1, and 2, and view P2 as a subspace of V. Produce an orthogonal basis for P2 by applying the Gram-Schmidt process to the polynomials 1, t, and t2.
|