Use the following stock price data to calculate: (a) Return for SBUS over the period without...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following stock price data to calculate: (a) Return for SBUS over the period without dividends, and with dividends (b) Return for GOOG over the period (c) If you have 30% of your portfolio in SBUX and 70% in GOOG, what was the return on your portfolio? Note: calculate part c using the cumulative returns that automatically calculate in the spreadsheet Date 2011-11-14 2012-02-06 2012-05-07 2012-08-06 2012-12-13 SBUX Dividend Ret w/o div Ret w/div 43.64 48.29 55.48 43.48 53.18 Stock Golden Seas Jacobs MAG PDJB 43 0 0.17 0.17 0.17 0.21 5 1 1.25 Cumul. Ret 0.0000 30 10 GOOG 613.00 609.09 607.55 642.82 659.05 #3 A portfolio consists of the following four stocks, calculate the portfolio weights in each stock. shares Share price (million) Weight 13 22 Dividend 0 0 0 0 0 Cumul. Ret Ret 0.0000 Portfolio return: The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2010. Using these data, calculate the average monthly return and volatility for each stock. Then calculate the average return and volatility of a portfolio that is 55% invested in Cola Co. stock and 45% invested in Gas Co. Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average return Volatility (standard Deviation) Realized Returns Cola Co -10.84% 2.36% 6.60% 2.01% 18.36% -1.22% 2.25% -6.89% -6.04% 13.61% 3.51% 0.54% Gas Co. -6.00% 1.28% -1.86% -1.90% 7.40% -0.26% 8.36% -2.46% -2.00% 0.00% 4.68% 2.22% Portfolio of 55% Cola and 45% Gas The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2010. (You do NOT need to fill out the empty cells here again). Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average return Volatility Realized Returns Cola Co Gas Co. -10.84% -6.00% 2.36% 1.28% 6.60% -1.86% 2.01% -1.90% 18.36% 7.40% -1.22% -0.26% 2.25% 8.36% -6.89% -2.46% -6.04% -2.00% 13.61% 0.00% 3.51% 4.68% 0.54% 2.22% Portfolio of 55% Cola and 45% Gas Part I: calculate the correlation coefficient between Cola and Gas? Use the following stock price data to calculate: (a) Return for SBUS over the period without dividends, and with dividends (b) Return for GOOG over the period (c) If you have 30% of your portfolio in SBUX and 70% in GOOG, what was the return on your portfolio? Note: calculate part c using the cumulative returns that automatically calculate in the spreadsheet Date 2011-11-14 2012-02-06 2012-05-07 2012-08-06 2012-12-13 SBUX Dividend Ret w/o div Ret w/div 43.64 48.29 55.48 43.48 53.18 Stock Golden Seas Jacobs MAG PDJB 43 0 0.17 0.17 0.17 0.21 5 1 1.25 Cumul. Ret 0.0000 30 10 GOOG 613.00 609.09 607.55 642.82 659.05 #3 A portfolio consists of the following four stocks, calculate the portfolio weights in each stock. shares Share price (million) Weight 13 22 Dividend 0 0 0 0 0 Cumul. Ret Ret 0.0000 Portfolio return: The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2010. Using these data, calculate the average monthly return and volatility for each stock. Then calculate the average return and volatility of a portfolio that is 55% invested in Cola Co. stock and 45% invested in Gas Co. Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average return Volatility (standard Deviation) Realized Returns Cola Co -10.84% 2.36% 6.60% 2.01% 18.36% -1.22% 2.25% -6.89% -6.04% 13.61% 3.51% 0.54% Gas Co. -6.00% 1.28% -1.86% -1.90% 7.40% -0.26% 8.36% -2.46% -2.00% 0.00% 4.68% 2.22% Portfolio of 55% Cola and 45% Gas The following spreadsheet contains monthly returns for Cola Co. and Gas Co. for 2010. (You do NOT need to fill out the empty cells here again). Date Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average return Volatility Realized Returns Cola Co Gas Co. -10.84% -6.00% 2.36% 1.28% 6.60% -1.86% 2.01% -1.90% 18.36% 7.40% -1.22% -0.26% 2.25% 8.36% -6.89% -2.46% -6.04% -2.00% 13.61% 0.00% 3.51% 4.68% 0.54% 2.22% Portfolio of 55% Cola and 45% Gas Part I: calculate the correlation coefficient between Cola and Gas?
Expert Answer:
Answer rating: 100% (QA)
Here are the calculations stepbystep a Return for SBUX over the period Without dividends Final price ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Barton Industries has operating income for the year of $3,400,000 and a 25% tax rate. Its total invested capital is $20,000,000 and its after-tax percentage cost of capital is 6%. What is the firm's...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The following data are from Gennings, Chinchilli, and Carter, (1989). An in vitro toxicity study of isolated hepatocyte suspensions was conducted to study the impact of combining carbon tetrachloride...
-
Role-play a human resources manager trying to convince the company CEO and two of his executives (role-played by three students) that introducing some of the rewards discussed in the case opening is...
-
Cincinnati Soap Company manufactures powdered detergent. Phosphate is placed in process in the Making Department, where it is turned into granulars. The output of Making is transferred to the Packing...
-
Sketch the vector field F by drawing a diagram like Figure 5 or Figure 9. F(x, y, z) = y i y F (0, 3) F (2, 2) 2+ F (1, 0) -2 FIGURE 5 F(x, y) =-yi+xj 2.
-
Describing Findings in an ,^greed-Upon Procedures Engagement Agreed-upon procedures engagements on elements, accounts, or items of a financial statement and on nonfinancial statement assertions...
-
On January 1, Vanessa Corporation had 60,000 shares of no-par common stock issued and outstanding. The stock has a stated value of $4 per share. During the year, the following transactions occurred....
-
What is ERD diagram? In what model we develop it? What does it contain? Do we create table in the ERD? Explain.
-
write a closed-research legal memo using the case cases given, addressing whether Mr. Adler can assert an adverse possession claim to Scrub Lot 40. Please write up your memo using the issue , brief...
-
List several major advantages of the client/server architecture compared with other approaches. Describe the advantages/disadvantages of three-tiered architecture Describe the common components...
-
With consideration of HIPPA, what are the physical safeguards that include controls on access, workstation security and use, and device and media controls? What are the technical safeguards that...
-
The profession of Emergency Management as well as the nature of emergencies and disasters. Thinking about emergency management as a professional activity, one you might want to get into as a career,...
-
I am sure that you ___?___ the best lawyer in the entire state of Texas. Future. Select the word that best completes the sentence. I am sure that you ___?___ the best lawyer in the entire state of...
-
1. Gas phase decomposition of di-t-butyl peroxide is monitored in a batch reactor of constant volume at isothermal conditions of 170C. (CH3)3COOC(CH3)3 C2H6+2 CH3COCH3 The run is started with pure...
-
What is the correlation for following? A. Organiation commitment to Job satisfaction? Affective Commitment to Job Satisfaction? Continuance COmmitment to Job Satisfaction? Normative Commitment to Job...
-
1) Suppose you expect SugarCane's stock price to decline. So you decide to ask your broker to short 2,000 shares. The current market price is $40. Proceeds from the $80,000 short sale are credited to...
-
Stephen Schor, an accountant in New York City, advised his client, Andre Romanelli, Inc., to open an account at J. P. Morgan Chase Bank, N.A., to obtain a favorable interest rate on a line of credit....
-
Calculate the amount of the child and dependent care credit allowed for 2012 in each of the following cases, assuming the taxpayers had no income other than the stated amounts. a. William and Carla...
-
Greg died on July 1, 2012, and left Lea, his wife, a $50,000 life insurance policy which she elects to receive at $5,000 per year plus interest for 10 years. In the current year, Lea receives $6,200....
-
Ulysses and Penelope are married and file separate returns for 2012. Penelope itemizes her deductions on her return. Ulysses' adjusted gross income was $17,400, his itemized deductions were $2,250,...
-
Show that having the exact value for the estimated sensor bandwidth is not required for the experimental process to find KEst discussed in Section 10. 4.3.4. In Experiment 10E, corrupt the value of...
-
Provide the modeling equations for the following figure. Assume an analog PI controller (GC(s)), a single-pole low-pass filter with a break frequency of 200 Hz for the feedback filter (H(s)), and a...
-
What is the gain and phase of a single-pole low-pass filter (a) at its bandwidth and (b) at 1/10 its bandwidth? (c) Repeat for a two-pole low-pass filter with = 0.7
Study smarter with the SolutionInn App