Question

You need to write down all necessary steps/formulas leading to your results in EXCEL FORMAT: 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?

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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. 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. Measured by 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...
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...
You need to write down all necessary steps/formulas leading to your results in EXCEL FORMAT: Company...
You need to write down all necessary steps/formulas leading to your results in EXCEL FORMAT: Company A has a beta of 0.70, while Company B's beta is 1.20. The required return on the stock market is 11.00%, and the risk-free rate is 4.25%. What is the difference between A's and B's required rates of return?
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…),...
(For this part, you MUST present sufficient solution steps, and MUST apply specific Excel functions =NPV(…), =IRR(…), =AVERAGE(…), =YIELD(…) whenever applicable. We are given the information that Microthin’s stock price was $21 in December 2013, $29 in December 2014, $27 in December 2015, $20 in December 2016, and $26 in December 2017. It also pays annual dividend amounts varying from 2013 through 2017. Let's assume you do the following transactions: a) In December 2013: buy 30,000 Microthin shares; b) In...
Use Minitab to answer the questions. Make sure to copy all output from the Minitab: 1.   Followings...
Use Minitab to answer the questions. Make sure to copy all output from the Minitab: 1.   Followings Tables shows previous 11 months stock market returns. Date Monthly SP500 Return Monthly DJIA Return 12/7/2007 -0.8628 -0.7994 1/8/2008 -6.1163 -4.6323 2/8/2008 -3.4761 -3.0352 3/8/2008 -0.5960 -0.0285 4/8/2008 4.7547 4.5441 5/8/2008 1.0674 -1.4182 6/8/2008 -8.5962 -10.1937 7/8/2008 -0.9859 0.2468 8/8/2008 1.2191 1.4548 9/8/2008 -9.2054 -6.0024 10/8/2008 -16.8269 -4.8410 Let consider we know the variance of monthly return for all stock were 25 percent in...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...