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
-
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...
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
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...
-
Refer to Figure 10.40. Determine the vertical stress increase, ÎÏz, at point A with the following values: q1 = 90 kN/m; q2 = 325 kN/m; x1 = 4 m; x2 = 2.5 m; z = 3 m. Line load qi Line load...
-
How does a content plan relate to experience strategies? What are the elements included in the content plan?
-
Describe the role of a paralegal in an annulment action.
-
Listor Company made 3,800 bookshelves using 23,200 board feet of wood costing $290,000. The companys direct materials standards for one bookshelf are 8 board feet of wood at $12 per board foot. (1)...
-
ACTUAL $ 750,000 Big Boats, Inc. makes laury speed boats for water sking Actual results and the static budge Sales commissions are computed at 5% of gross sales The expected ROI for this subsidiary...
-
Company X set up a two-month trial phase to assess the bus line's profitability (44 weekdays). The average daily fees received throughout this experiment are kr 12,640, with a kr 1,500 standard...
-
Why do you think that several people didn't follow the official procedure for requesting ICU beds that day? Do you think this is a big problem? Why or why not? Patient Flow at Brigham and Women's...
-
Pick three of the following rations and using the data for the last two years from the Luluemon income statement classify the ratios as stable, decreasing, or increasing Income-Statement Based Ratios...
-
Why have ethics and social responsibility become so important in recent years? Why is it important that marketing ethics be incorporated into the company's strategic plan?
-
Open the most recent 10-K from EDGAR of PROCTER & GAMBLE. https://www.sec.gov/Archives/edgar/data/80424/000095015206007291/l21828ae10vk.htm This discussion board will focus on the Statement of...
-
Financial statements for Boston Corporation are presented below. Use for 17-29 Boston Corporation Comparative Balance Sheet December 31 Assets 2011 2010 Cash $ 120,000 $ 110,000 Accounts receivable...
-
Write an essay on The effects of Supply and Demand with the Price of Oil and Gas in which you need to explain specific economic principles and then applied to a newspaper article that would focus on...
-
Give the structural formulas of the alkenes that, on ozonolysis, give: a. (CH3)2C=O and CH2=O b. Only (CH3CH2)2C=O c. CH3CH=O and CH3CH2CH=O d. O=CHCH2CH2CH2CH=O
-
An investment has the following cash flow series where interest is 5 percent: a. Determine the present worth of the series. b. Determine the future worth of the series at the end of year 8. c. Find...
-
Develop a single spreadsheet that allows you to calculate any of the P|A, A|P F|A, or A|F factors. For each cell where the calculation is performed, place above it a small control panel that allows...
-
The manager at a Sherwin-Williams store has decided to purchase a new \($30\),000 paint-mixing machine with hi-tech instrumentation for matching color and other components. The machine may be paid...
Financial Fitness Workbook Your Path To Financial Mastery 1st Edition - ISBN: B0CTFCZCZH - Free Book
Study smarter with the SolutionInn App