Question

In: Finance

Campbell's father holds just one stock, East Coast Bank (ECB), which he thinks is a very...

Campbell's father holds just one stock, East Coast Bank (ECB), which he thinks is a very low-risk security. Campbell agrees that the stock is relatively safe, but he wants to demonstrate that his father's risk would be even lower if he were more diversified. Campbell obtained the following returns data shown for West Coast Bank (WCB). Both have had less variability than most other stocks over the past 5 years. Measured by the standard deviation of returns, by how much would his father's historical risk have been reduced if he had held a portfolio consisting of 50% ECB and the remainder in WCB? Enter your answer rounded to two decimal places. Do not enter % in the answer box. For example, if your answer is 0.12345 or 12.345% then enter as 12.35 in the answer box.

Year         ECD                WCD

2014       20.00%        25.00%

2015       -10.00%          15.00%

2016        35.00%          -5.00%

2017      -5.00%           -10.00%

2018      15.00%         35.00%

Solutions

Expert Solution

The mean, standard deviation and covariance of the companies are calculated as follows:

In the excel, the following calculations are made:

Option 1: 100% amount invested in East Coast Bank (ECB) stock

Risk for holding only the stocks of East Coast Bank (ECB) = Standard deviation of the returns of ECB

= 18.51%

Option 2: The portfolio consists of 50% investment in East Coast Bank (ECB) and 50% investment in West Coast Bank (WCB)

Standard Deviation of Portfolio with 2 Assets is calculated as:

where, weight of ECB (Wa) = 50% = 0.5

Weight of WCB (Wb) = 50% = 0.5

Standard deviation of returns of ECB, σ(Ka) = 18.51%

Standard deviation of returns of WCB, σ(Kb)= 19.24%

Covariance of the returns of two stocks, Cov(Ka, Kb) = 0.23%

Puuting the values in the formula we get

σ(P)^2 = (0.5*18.51%)^2 + (0.5*19.24%)^2 + 2*0.5*0.5*0.23%

σ(P)^2 = 0.008566 + 0.009254 + 0.00115 = 0.01897

σ(P) = sqrt(0.01897) = 0.137731 = 13.77%

With the addition of WCB, the portfolio risk lowered by = 18.51% -  13.77% = 4.74%


Related Solutions

Campbell's father holds just one stock, East Coast Bank (ECB), which he thinks is a very...
Campbell's father holds just one stock, East Coast Bank (ECB), which he thinks is a very low-risk security. Campbell agrees that the stock is relatively safe, but he wants to demonstrate that his father's risk would be even lower if he were more diversified. Campbell obtained the following returns data shown for West Coast Bank (WCB). Both have had less variability than most other stocks over the past 5 years. Measured by the standard deviation of returns, by how much...
Campbell's father holds just one stock, East Coast Bank (ECB), which he thinks is a very...
Campbell's father holds just one stock, East Coast Bank (ECB), which he thinks is a very low-risk security. Campbell agrees that the stock is relatively safe, but he wants to demonstrate that his father's risk would be even lower if he were more diversified. Campbell obtained the following returns data shown for West Coast Bank (WCB). Both have had less variability than most other stocks over the past 5 years. Measured by the standard deviation of returns, by how much...
Assume that your uncle holds just one stock, East Coast Bank (ECB), which he thinks has...
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. Year                 ECB                  WCB 2004                 40.00%...
Assume that your uncle holds just one stock, East Coast Bank (ECB), which he thinks has...
Assume that your uncle holds just one stock, East Coast Bank (ECB), which he thinks has very little risk. You obtain the following forecasted returns data for West Coast Bank (WCB) for next year. Assume the possibility of different states of the economy is the same for the next year. Recession ECB 40% WCB 40% Below average ECB -10% WCB 15% Average ECB 35% WCB -5% Above average ECB -5% WCB -10% Booming ECB 15% WCB 35% a) Calculated the...
Campbell's father holds just one stock, G Co., which he thinks is a very low risk...
Campbell's father holds just one stock, G Co., which he thinks is a very low risk security. Campbell agrees that the stock is relatively safe, but he wants to demonstrate to his father that he could still reduce his risk by diversifying. He obtained the return shown below on G and E Corp. Both have had less variability than most other stocks over the past 5 years. Year G E Portfolio: 50% G and 50% E 2015 0.40 0.40 2016...
Assume that your cousin holds just one stock, Eastman Chemical Bonding (ECB), which he thinks has...
Assume that your cousin holds just one stock, Eastman Chemical Bonding (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 Wilder's Creations and Buildings (WCB). Both companies have had less variability than most other stocks over the past 5 years. Using the standard deviation of returns, by how much...
Assume that your cousin holds just one stock, Eastman Chemical Bonding (ECB), which he thinks has...
Assume that your cousin holds just one stock, Eastman Chemical Bonding (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 Wilder's Creations and Buildings (WCB). Both companies have had less variability than most other stocks over the past 5 years. Using the standard deviation of returns, by how much...
Twenty-one years later, the firm has 20 stores throughout 7 east coast states, of which 10...
Twenty-one years later, the firm has 20 stores throughout 7 east coast states, of which 10 are operated by the company and 10 by franchisees. Each store was built to the same specifications for both interior and exterior design. Locations were chosen in heavily African-American populated areas since their success depended greatly upon serving a target market of customers with the resources to purchase the firm’s art products. Inventory items were standardized into the three categories, and advertising focused on...
1A) Suppose that your friend, Angela, holds a single stock, Early Riser Bank (ERB), which she...
1A) Suppose that your friend, Angela, holds a single stock, Early Riser Bank (ERB), which she believes faces little risk. Despite the fact that you agree with Angela on the riskiness of the firm, you set out to show her that her risk would be even lower if she was more diversified. As a demonstration exercise, you find the following returns data for Late Riser Bank (LRB). Using the standard deviation of returns, by how much would Angela's risk have...
Suppose that your friend, Angela, holds a single stock, Early Riser Bank (ERB), which she believes...
Suppose that your friend, Angela, holds a single stock, Early Riser Bank (ERB), which she believes faces little risk. Despite the fact that you agree with Angela on the riskiness of the firm, you set out to show her that her risk would be even lower if she was more diversified. As a demonstration exercise, you find the following returns data for Late Riser Bank (LRB). Using the standard deviation of returns, by how much would Angela's risk have been...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT