Question

Assume that your uncle holds just one stock, East Coast Bank (ECB), which he thinks has very little risk. 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 (WCB). Both banks have had less variability than most other stocks over the past 5 years. 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 54% in ECB and the remainder in WCB? (Hint: Use the sample standard deviation formula.) Do not round your intermediate calculations.

Year                      ECB                       WCB

1                          40.00%                40.00%

2                          -10.00%                               15.00%

3                          35.00%                -5.00%

4                          -5.00%                -10.00%

  5                          15.00%                35.00%

Average return =                             15.00%                15.00%

Standard deviation =                     22.64%                22.64%

a.            3.59%

b.            4.27%

c.             2.99%

d.            3.99%

e.            4.51%

Excel in detail please

Answer 1

Answer to Option "E" i.e 4.51%