Use the data in the table below to answer the following questions: a. What is the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the data in the table below to answer the following questions: a. What is the return for SBUX over the period without including its dividends? dividends? b. What is the return for GOOG over the period? c. If you have 30% of your portfolio in SBUX and 70% in GOOG, what was the one-year holding period return on your portfolio? Date 2011-11-14 SBUX Dividend GOOG Dividend S 43.64 S S 613.00 S 2012-02-06 S 48.29 S 0.17 S 609.09 $ 2012-05-07 S 55.48 S 0.17 S 607.55 S 2012-08-06 S 43.48 S 0.17 S 642.82 $ 2012-12-13 53.18 S 0.21 S 659.05 $ a. What is the return for SBUX over the period without including its dividends? dividends? Return Date Return with Div 2011-11-14 2012-02-06 2012-05-07 2012-08-06 2012-12-13 Return b. What is the return for GOOG over the period? b. What is the return for GOOG over the period? 27 28 29 30 Date 2011-11-14 31 2012-02-06 32 2012-05-07 33 2012-08-06 Return 34 35 36 2012-12-13 Return c. If you have 30% of your portfolio in SBUX and 70% in GOOG, what was the one-year holding period return on your portfolio? 37 38 39 SBUX 40 GOOG 41 42 Return 43 44 30% 70% 45 Requirements 46 47 48 49 50 51 52 53 1 In cell range D21:D24, by using cell references, calculate the holding period return without dividends for SBUX for each of the periods from 2011-11-14 to 2012-12-13 (4 pt.). 2 In cell range E21:E24, by using cell references, calculate the holding period return with dividends for SBUX for each of the periods from 2011-11-14 to 2012-12-13 (4 pt.). 3 In cell D25, by using cell references, calculate the holding period return without dividends for SBUX for the period from 2011-11-14 to 2012-12-13 (1 pt.). 4 In cell E25, by using cell references, calculate the holding period return with dividends for SBUX for the period from 2011-11-14 to 2012-12-13 (1 pt.). 5 In cell range D31:D34, by using cell references, calculate the holding period return for GOOG for each of the periods from 2011-11-14 to 2012-12-13 (4 pt.). 6 In cell D35, by using cell references, calculate the holding period return for GOOG for the period from 2011- 11-14 to 2012-12-13 (1 pt.). 7 In cell D42, by using cell references, calculate the holding period return for the portfolio of SBUX (with Div) and GOOG (1 pt.). Use the data in the table below to answer the following questions: a. What is the return for SBUX over the period without including its dividends? dividends? b. What is the return for GOOG over the period? c. If you have 30% of your portfolio in SBUX and 70% in GOOG, what was the one-year holding period return on your portfolio? Date 2011-11-14 SBUX Dividend GOOG Dividend S 43.64 S S 613.00 S 2012-02-06 S 48.29 S 0.17 S 609.09 $ 2012-05-07 S 55.48 S 0.17 S 607.55 S 2012-08-06 S 43.48 S 0.17 S 642.82 $ 2012-12-13 53.18 S 0.21 S 659.05 $ a. What is the return for SBUX over the period without including its dividends? dividends? Return Date Return with Div 2011-11-14 2012-02-06 2012-05-07 2012-08-06 2012-12-13 Return b. What is the return for GOOG over the period? b. What is the return for GOOG over the period? 27 28 29 30 Date 2011-11-14 31 2012-02-06 32 2012-05-07 33 2012-08-06 Return 34 35 36 2012-12-13 Return c. If you have 30% of your portfolio in SBUX and 70% in GOOG, what was the one-year holding period return on your portfolio? 37 38 39 SBUX 40 GOOG 41 42 Return 43 44 30% 70% 45 Requirements 46 47 48 49 50 51 52 53 1 In cell range D21:D24, by using cell references, calculate the holding period return without dividends for SBUX for each of the periods from 2011-11-14 to 2012-12-13 (4 pt.). 2 In cell range E21:E24, by using cell references, calculate the holding period return with dividends for SBUX for each of the periods from 2011-11-14 to 2012-12-13 (4 pt.). 3 In cell D25, by using cell references, calculate the holding period return without dividends for SBUX for the period from 2011-11-14 to 2012-12-13 (1 pt.). 4 In cell E25, by using cell references, calculate the holding period return with dividends for SBUX for the period from 2011-11-14 to 2012-12-13 (1 pt.). 5 In cell range D31:D34, by using cell references, calculate the holding period return for GOOG for each of the periods from 2011-11-14 to 2012-12-13 (4 pt.). 6 In cell D35, by using cell references, calculate the holding period return for GOOG for the period from 2011- 11-14 to 2012-12-13 (1 pt.). 7 In cell D42, by using cell references, calculate the holding period return for the portfolio of SBUX (with Div) and GOOG (1 pt.).
Expert Answer:
Related Book For
Fundamentals Of Corporate Finance
ISBN: 9780135811603
5th Edition
Authors: Jonathan Berk, Peter DeMarzo, Jarrad Harford
Posted Date:
Students also viewed these finance questions
-
in 5-8 sentences How might the grieving process vary depending upon the age of the surviving person? How might the mode of death or the age of the person who died affect grief in survivors? in 5-8...
-
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...
-
Question: Old MathJax webview Old MathJax webview i need ans of these question but the source is alot Old MathJax webviewOld MathJax webview i need ans of these question but the source is alot these...
-
ABC Insurance Company has issued a commercial package policy to the Henderson Company. ABC recently discovered that company executives misrepresented important information about the business to...
-
Point loads of magnitude 100, 200, and 400 kN act at B, C, and D, respectively (Figure 10.39). Determine the increase in vertical stress at a depth of 6 m below the point A. Use Boussinesq's...
-
What is delegation? What is its significance in structural modeling?
-
Acompany wishes to make a rights issue to its existing shareholders. The rights issue is a 2 for 5 rights issue at a price of 1.20 per share. The par value of each share is 1 and the shares trade in...
-
Erikstein Colleges statement of financial position for the year ended June 30, 2013, is presented here. Erikstein is a private college. The following transaction information pertains to the year...
-
Dominique Clement a renowned restauranteur and the owner of the seafood restaurant 'Rock Lobster Pty Ltd' located on King Island in Bass Strait. Her seafood specialty is King Island Crayfish (Lobs...
-
Suppose you discover a treasure chest of $100 billion in cash. Is this a real asset or financial asset? Is society any richer for the discovery? Are you wealthier? Is anyone worse off as a result of...
-
To fund your dream around-the-worldvacation, you plan to save $1,375 per year for the next 11 years starting one year from now. If you can earn an interest rate of 6.01 percent, how much will you...
-
Given the following information, compute the total number of units for the period: Direct labor hours12,300Direct labor cost$2.70per hourDirect materials cost$75per unitTotal manufacturing...
-
Predict VectorCal's indirect costs based on the direct costs (e.g. direct labor, direct materials or both). Speculate on what the indirect costs of the existing companies bodes for the future of...
-
A firm incurs manufacturing costs totalling $240 000 in process 1 to produce the following three beverages emerging from that process at the split-off point: Apple juice: sold immediately it emerges...
-
The following data is available for the production of Product H-15 for the current period: Direct materials $45,000 Direct labor-hours 630 labor-hours Direct labor wage rate $13 per labor-hour...
-
If the formula =IF(A1="","X",IF(A1 <0,A1^2,A1)) was placed into cell E1 and copied over to column G and down to row #3, what would the results in E1:G3 be? A B C D E F G 1 72 4.32 -4 2 0 middle...
-
Use nodal analysis to determine voltages v1, v2, and v3 in the circuit Fig. 3.76. Figure 3.76 4 S 3i, 2 A 4A
-
Determine if the following sequences are arithmetic sequences. Explain your reasoning. 1. \(\{4,7,10,13,16,19,22,25, \ldots\}\) 2. \(\{20,40,80,160,320,640\}\) 3....
-
As mentioned in the opening to this section, it is estimated that we're producing 2.5 quintillion bytes of data per day. A good estimate is that there are 7.674 billion people on the planet. Convert...
-
Identify \(a_{1}\) and \(d\) for the following arithmetic sequence. Use this information to determine the 60 th term. \[ \{18,31,44,57,70,83, \ldots\} \]
Study smarter with the SolutionInn App