Question

In: Finance

Supposethattheannualreturnsontwosharesareperfectlynegativelycorrelatedandthat? =0.07, ? ? = 0.20,? = 0.12 , and ? = 0.5. Assuming that there...

Supposethattheannualreturnsontwosharesareperfectlynegativelycorrelatedandthat? =0.07, ?

? = 0.20,? = 0.12 , and ? = 0.5. Assuming that there are no arbitrage opportunities, by using ???

the Goal Seek function (excel) calculate the weight (proportion) of the two assets that produce the lowest portfolio variance? (Use the Goal Seek function)

Solutions

Expert Solution

Write down the facts given :

Assume Weight of asset 1 to be .50 and weight of asset 2 to ve .50 and use the formula in the above mentioned screenshot to calculate portfolio variance:

Remember , in cell representing value of weight of 2 we will put in formula "1-cell containing value of weight of 1"

In cell representing value of portfolio variance, we will put in formula in 1st screenshot

Using formula for portfolio variance in 1st Screenshot, we get variance = .0361

The next step is to go to Data in excel, select What if Analysis and select Goal Seek

In the Goal Seek Table , fill in the the following values:

Set Cell : Select cell containing the value of portfolio variance

To value : 0.000001

By Changing Cell : Select cell containing value of weight 1

Press Ok.

Goal seek will apply and we will get the following values:

This shows that weight of asset 1 as .85 and weight of asset 2 as .15 will give the minimum variance of .001

PS: Open images in new tab for better view.


Related Solutions

Q1. Given the following Information Investment Expected return Standard deviation 1 0.12 0.3 2 0.15 0.5...
Q1. Given the following Information Investment Expected return Standard deviation 1 0.12 0.3 2 0.15 0.5 3 0.21 0.16 4 0.24 0.21 U=E(r) - (A/2)s2 , where A=4.0 a) Briefly describe the variable of E(r), s and A and how these variables affect the utility of individual. b) Based on the utility function above, which investment would you select? (shows your calculation. c) Redo part (b) if the investor is risk neutral.
Utilizing the market for reserves and assuming that initially the federal funds rate is 0.5 percentage...
Utilizing the market for reserves and assuming that initially the federal funds rate is 0.5 percentage point below the discount rate but 0.5 percentage point above the interest rate paid on reserves, a. Show what would happen to the federal funds rate if the FED decreased the discount rate by 0.3 percent b. Show what would happen to the federal funds rate if the FED increased the interest rate paid on reserves by 0.75 percent
Let v1 = [-0.5 , v2 = [0.5 , and v3 = [-0.5 -0.5 -0.5   ...
Let v1 = [-0.5 , v2 = [0.5 , and v3 = [-0.5 -0.5 -0.5    0.5 0.5    0.5    0.5 -0.5]    0.5] 0.5] Find a vector v4 in R4 such that the vectors v1, v2, v3, and v4 are orthonormal.
Determine the pH of (a) 0.20 M sulfuric acid (b) 0.20 M hydrochloric acid, (c) 0.20...
Determine the pH of (a) 0.20 M sulfuric acid (b) 0.20 M hydrochloric acid, (c) 0.20 M sodium hydroxide, (d) 0.20 M acetic acid, and (e) 0.20 M solution of NH3 at 25 oC.
Assuming Green-Ampt infiltration and: porosity = 0.5; initial moisture content = 0.2; saturated hydraulic conductivity =...
Assuming Green-Ampt infiltration and: porosity = 0.5; initial moisture content = 0.2; saturated hydraulic conductivity = 0.65 cm/hr; wetting front suction = 5.5 cm and rainfall from 0-1 hr = 0.6 cm.hr and 1-2 hr = 3 cm/hr. a) Determine the time ponding first occurs in this storm. b) Determine the depth of infiltration at depth of runoff generated in each 1 hr interval. c) What is the depth of the wetting front at the end of the two hour...
A sealed 1.0-L flask, initially containing 0.20 M COCl2, 0.20 M Cl2, and 0.20 M CO,...
A sealed 1.0-L flask, initially containing 0.20 M COCl2, 0.20 M Cl2, and 0.20 M CO, is heated to 700 K and allowed to come to equilibrium. COCl2(g) ⇌ Cl2(g) + CO(g) Kc = 0.12 at 700 K a. What are the molar concentrations of COCl2, Cl2, and CO once the reaction has reached equilibrium at 700 K? COCl2:_______________________________ Cl2:_______________________________ CO:_______________________________ b. 0.10 mol COCl2 is added to the equilibrium mixture. What are the molar concentrations of COCl2, Cl2, and...
Calculate the pH at the equivalence point for the titration of 0.20 M HCl with 0.20...
Calculate the pH at the equivalence point for the titration of 0.20 M HCl with 0.20 M NH3 (Kb = 1.8 ◊ 10–5).
For the titration of 25.0 mL of 0.20 M hydrofluoric acid with 0.20 M sodium hydroxide...
For the titration of 25.0 mL of 0.20 M hydrofluoric acid with 0.20 M sodium hydroxide , determine the volume of based added when pH is a) 2.85 b) 3.15 c)11.89
A 100.0 mL sample of 0.20 M HF is titrated with 0.20 M KOH. Determine the...
A 100.0 mL sample of 0.20 M HF is titrated with 0.20 M KOH. Determine the pH of the solution after the addition of 50.0 mL of KOH. The Ka of HF is 3.5 × 10-4. A. 2.08 B. 3.15 C. 4.33 D. 3.46 E. 4.15
There are 13000 units of productive capacity in the Eldorado. Let Y = 0 + 0.07...
There are 13000 units of productive capacity in the Eldorado. Let Y = 0 + 0.07 X be the cotton production function. Let Y = 0 + 0.35 X be the iron production function. There are 10000 units of productive capacity in the Noplacia. Let Y = 0 + 0.05 X be the cotton production function. Let Y = 0 + 0.026 X be the iron production function. The two countries will engage in international trade, if the international terms...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT