Question: E[r] Std 1 1.09% 4.98% 2 1.10% 4.36% 3 1.73% 5.38% 4 0.82% 6.58% 5 1.28% 8.05% 6 1.32% 6.93% I currently have 6 stocks

	E[r]	Std
1	1.09%	4.98%
2	1.10%	4.36%
3	1.73%	5.38%
4	0.82%	6.58%
5	1.28%	8.05%
6	1.32%	6.93%

I currently have 6 stocks in my portfolio and above are the current weights and expected returns. If I were to add let's say another stock to the portfolio like Microsoft, how can I show that this new stock would decrease the risk of my portfolio? thank you please use excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Synopsis of Incident at Morales Phaust Chemical manufactures "Old Stripper," a paint remover that dominates the market. On learning that Phaust's competitor, Chemitoil, plans to introduce a new paint...

E[r] Std 1 1.09% 4.98% 2 1.10% 4.36% 3 1.73% 5.38% 4 0.82% 6.58% 5 1.28% 8.05% 6 1.32% 6.93% WEIGHT 24.87% 24.30% 17.69% 11.72% 10.99% 10.43% I currently have 6 stocks in my portfolio and above are...

This question concerns Alibaba the internet e-commerce firm that recently went public. It is an open ended question that requires you to utilize the valuation techniques you have learnt in the course...

Hello. I see this question on chegg a lot on here. Trying to find the right answer if possible! Java please! ' 2015Rank Boys Births 1 Noah 19511 2 Liam 18281 3 Mason 16535 4 Jacob 15816 5 William...

Question 1 (10 marks) Read section 1.1 of the textbook. Use the provided spreadsheet (presenting the data used to create Figure 1.2 from the textbook). Consider Australia, China, USA and another two...

Question 1 (10 marks) Use the provided spreadsheet. Consider Australia, China, USA and another two countries of your choice. 1. For each country calculate the 90/10 ratio in 1980, 1990 and 2014. (3...

Use the provided spreadsheet (presenting the data used to create Figure 1.2 from the textbook). Consider Australia, China, USA and another two countries of your choice. 1. For each country calculate...

Write a code in C++ where as the first task, look at the data that is attached below which contains observations of interarrival and service times in a single-server queueing system of a company....

PLEASE I NEED THIS IN C LANGUAGE data file Customer# InterarrivalT ServiceT 1 3.64 5.01 2 2.61 98.10 3 3.84 1.63 4 1.86 9.64 5 20.35 24.88 6 2.28 13.89 7 1.28 9.82 8 9.65 3.00 9 42.88 20.35 10 21.22...

Exponential Probabilities Mean Lambda 8000 0.000125 x F(x) 0 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000 20000 21000 22000 23000 24000...

KIndly someone help me with this work in C language here in the data in data file Customer# InterarrivalT ServiceT 1 3.64 5.01 2 2.61 98.10 3 3.84 1.63 4 1.86 9.64 5 20.35 24.88 6 2.28 13.89 7 1.28...

Two infinitely long wires are parallel as seen in the figure 3 It is 2 m apart from each other. Number 1 wire, has current 4 A outward from the page plane. Wire 2 has 12 A. What is the net magnetic...

In quadrilateral PQRS, m angle x=n-18 and m angle y=n-71. Which is the value of n ?

ans Which of the following is/are true? Amass spectrometer has many uses in both physics and chemistry. Amass spectrometer can be used to identify charged particles with different masses. Amass...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...