Question: Columns C, D and E contain weekly returns of three stocks. Assume the stocks have the following weights KO = 10%, BBBY =30%, SBUX =

Columns C, D and E contain weekly returns of three stocks.

Columns C, D and E contain weekly returns of three stocks. Assume the stocks have the following weights KO = 10%, BBBY =30%, SBUX = 60% caculate the following;

In Column F calculate Average return and std deviation of each stock, returns of the weighted portfolio

Below Column F Calculate the returns of a weighted portfolio.

Please include EXCEL instructions/formulas used to get answers. Thanks!

A A B D E Returns KO BBBY SBUX 0.32% 1.81% -0.26% -0.56% -2.83% 1.55% -0.88% 1.02% -4.45% 0.57% -0.53% 2.69% 1.59% 3.52% 2.78% 1.56% 1.56% 1.92% -0.38% -5.84% -4.39% 1.41% 1.02% 1.91% 0.10% -5.21% 10.37% -3.25% -0.52% -4.37% 3.99% 3.73% 5.53% 3.10% 3.02% 0.97% 0.07% 10.49% -3.98% 1.11% 3.75% 1.70% 1/10/2011 1/18/2011 1/24/2011 1/31/2011 2/7/2011 2/14/2011 2/22/2011 2/28/2011 3/7/2011 3/14/2011 3/21/2011 3/28/2011 4/4/2011 4/11/2011 4/18/2011 4/25/2011 5/2/2011 5/9/2011 5/16/2011 5/23/2011 5/31/2011 6/6/2011 6/13/2011 6/20/2011 6/27/2011 7/5/2011 7/11/2011 7/18/2011 7/25/2011 -0.19% 2.61% 1.70% -0.65% -2.04% -2.16% -0.81% -0.80% 0.90% 1.90% -0.69% -0.05% -3.27% 0.19% 1.27% -2.63% -0.69% -0.40% -1.48% -3.46% -3.56% -0.20% 2.52% -0.12% 1.07% -1.74% 0.89% -1.03% 8.85% 5.41% 4.86% 4.95% 7.60% 0.86% 1.26% 0.39% -1.68% -2.46% -1.35% 3.26% 1.77% 1.37% -2.47% -2.03% -0.62% A A B D E Returns KO BBBY SBUX 0.32% 1.81% -0.26% -0.56% -2.83% 1.55% -0.88% 1.02% -4.45% 0.57% -0.53% 2.69% 1.59% 3.52% 2.78% 1.56% 1.56% 1.92% -0.38% -5.84% -4.39% 1.41% 1.02% 1.91% 0.10% -5.21% 10.37% -3.25% -0.52% -4.37% 3.99% 3.73% 5.53% 3.10% 3.02% 0.97% 0.07% 10.49% -3.98% 1.11% 3.75% 1.70% 1/10/2011 1/18/2011 1/24/2011 1/31/2011 2/7/2011 2/14/2011 2/22/2011 2/28/2011 3/7/2011 3/14/2011 3/21/2011 3/28/2011 4/4/2011 4/11/2011 4/18/2011 4/25/2011 5/2/2011 5/9/2011 5/16/2011 5/23/2011 5/31/2011 6/6/2011 6/13/2011 6/20/2011 6/27/2011 7/5/2011 7/11/2011 7/18/2011 7/25/2011 -0.19% 2.61% 1.70% -0.65% -2.04% -2.16% -0.81% -0.80% 0.90% 1.90% -0.69% -0.05% -3.27% 0.19% 1.27% -2.63% -0.69% -0.40% -1.48% -3.46% -3.56% -0.20% 2.52% -0.12% 1.07% -1.74% 0.89% -1.03% 8.85% 5.41% 4.86% 4.95% 7.60% 0.86% 1.26% 0.39% -1.68% -2.46% -1.35% 3.26% 1.77% 1.37% -2.47% -2.03% -0.62%

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!

this was all given information. Tableau Dashboard Activity 5-1 Account for Uncollectible Accounts Using the Aging Method Review the Tableau visualization, and then answer the questions that follow....

please provide Excel instructions afterwards I will rate UP- Thanks so much art 2 a. Columns C, D and E contain weekly returns of three stocks. Assume the stocks have the follow weights: KO = 10%,...

Part 2 1. Columns C, D and E contain weekly returns of three stocks. Assume the stocks have the following weights: KO = 10%, BBBY = 30%, and SBUX =60% calculate the following: a. Below the returns...

You have $20,000. After the "success" of the sequel of the "Hunger Games", you want to know if Lions Gate Entertainment Corp. (NYSE:LGE) is a good buy. The firm's total risk is 19%, its systematic...

Part 1 and Part 2 contain data to use for Parts 1 & 2.Make sure any cells that have functions or formulas for calculations are shown in each cell. Please show in excel sheet. Part 1 1. Calculate the...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

Problem 1 The following list of accounts and their balances represents the unadjusted trial balance of Alt Company at December 31, 2012: Cash $ 29,090 Equity Investments (trading) 60,000 Accounts...

financial management Name ID MULTIPLE CHOICE Choose the one alternative that best completes the statement or answers the question. 4 points 1) each 1) Aurand, Inc. has outstanding bonds with an %...

1.50 0.90 S&P 500 0.70 1.15 D 6-21. (Capital asset pricing model) MFI, Inc. has a beta of 0.86. If the expected mar- ket return is 11.5 percent and the risk-free rate is 3 percent, what is the...

A B C D E F G H J K L Stock Returns and Variance Estimating stock returns, variance and standard deviation. Problem 1: You bought 100 shares of Starbucks Corp. (SBUX) 7 years ago (1Aug '95) for $5.00...

Hello. I need to write a three page review for the two articles attached. Each review should include a brief summary that include the major points of the article, as well as a summary of my own...

Why do some low-wage countries, such as China, pose a threat to manufacturers in industrial countries, such as the United States, whereas other low-wage countries, such as Haiti, do not?

Referring to Example 2.2.7, find A B and A B if the two equations were replaced by inequalities: x2 +2x 8 and x2 +x 6.

Refer to Norton Materials segmented income statement in Example 8.4 (p. 462). Assume that dropping the product line reduces sales of blocks by 10% and sales of bricks by 8%. All other information...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...