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 ECB WCB 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

Answer to the Question:

The Risk will be significantly reduced if the portfolio consists of ECB and WCB equally weighted. The SD of the Portfolio is 12.31% from 16.55% of a portfolio consisted of only ECB i.e 4.24%

A B D E F G H I J K L M N O Answer to Part Requried 1 Porfolio Expected Return 2 Portfolio Variance 3 ECB Standard Deviation 4 WCB Standard Deviation 5 Portfolio Standard Deviation 1 Answer Formula 11.50% =(E14*H8)+(F14*H9) 0.02 =((H9^2)*(642)+(H10^2) *H42)+(2*G30*H9*H10) 16.55% =G38 17.20% =G38 12.31% =SQRT(D3) Weight Stock 0.50 ECB 0.50 WCB WCB Calculation of Average Return 2 Years ECB 2,014 2,015 2,106 2,017 2,018 Average Return 20.00% 25.00% -10.00% 15.00% 35.00% 5.00% -5.00% -10.00% 15.00% 35.00% 11.00% 12.00% Calculation of Co-Variance Years 2,014 2,015 2,106 2,017 2,018 3 ECB WCB 20.00% 25.00% -10.00% 15.00% 35.00% 5.00% -5.00% -10.00% 15.00% 35.00% Co-Variance 4 5 6 A-(A) B-BL 5 X6 0.0900 0.1300 0 .0117 -0.2100 0.0300 -0.0063 0.2400 -0.1700 -0.0408 -0.1600 -0.2200 0.0352 0.0400 0.2300 0.0092 0.0018 Calculation of Variance & SD 2 ECB Probability 2,014 2,015 2,106 2,017 2,018 Varaince Standard Deviation 1 3 WCB 20.00% 25.00% -10.00% 15.00% 35.00% 5.00% -5.00% -10.00% 15.00% 35.00% 4 5 6 7 A-(A) B-(B) (A-A)^2 (B-(B)^2 0.0900 0.13001 0.0081 0.0169 -0.2100 0.0300 0.0441 0.0009 0.2400 -0.1700 0.0576 0.0289 -0.1600 -0.2200 0 .0256 0.0484 0.0400 0.2300 0.0016 0.0529 2.74% 2.96% 16.55% 17.20%


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%...
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...
Robert Arias recently inherited a stock portfolio from his uncle. Wishing to learn more about the companies in which he is now​ invested, Robert performs a ratio analysis on each one and decides to compare them to each other.
  FIN101 Robert Arias recently inherited a stock portfolio from his uncle. Wishing to learn more about the companies in which he is now​ invested, Robert performs a ratio analysis on each one and decides to compare them to each other. Some of his ratios are listed here:   Island Burger Fink Roland   Ratio Electric Utility Heaven Software Motors Current ratio 1.06 1.35 6.79 4.55 Quick ratio 0.92 0.87 5.23 3.73 Debt ratio 0.69 0.45 0.04 0.34 Net profit...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT