Question: You need to write down all necessary steps/formulas leading to your results in EXCEL FORMAT: You agree that the stock is relatively safe, but you

You need to write down all necessary steps/formulas leading to your results in EXCEL FORMAT:

You agree that the stock is relatively safe, but you want to demonstrate that his risk would be even lower if he were more diversified. You obtain the following returns data for West Coast Bank. Both banks have had less variability than most other stocks over the past 5 years.

Year ECB WCB

2004 40.00% 40.00%

2005 - 10.00% 15.00%

2006 35.00% -5.00%

2007 -5.00% -10.00%

2008 15.00% 35.00%

a. What is the expected return and risk of each stock?

b. Measured by the standard deviation of returns, by how much would your uncle's risk have been reduced if he had held a portfolio consisting of 60% in ECB and the remainder in WCB? In other words, what is the difference between the portfolio's standard deviation and the weighted average of components' standard deviations?

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!