Question: 1.) 2.) please help! Use the data for Starbucks (SBUX) and Google (GOOG) to answer the following questions: a. What is the return for SBUX

Use the data for Starbucks (SBUX) and Google (GOOG) to answer the following questions: a. What is the return for SBUX over the period without including its dividends? With the dividends? b. What is the return for GOOG over the period? c. If you have 72% of your portfolio in SBUX and 28% in GOOG, what was the return on your portfolio excluding dividends? i Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) Date SBUX Dividend GOOG Dividend 16-Nov-2017 $57.24 $0.00 $1048.47 $0.00 04-Feb-2018 $54.46 $0.30 $1055.41 $0.00 09-May-2018 $57.04 $0.30 $1089.00 $0.00 08-Aug-2018 $51.55 $0.36 $1261.33 $0.00 14-Nov-2018 $67.04 $0.36 $1054.58 $0.00 Print Done Ten annual returns are listed in the following table: (Click on the following icon in order to copy its contents into a spreadsheet.) - 19.5% 16.4% 18.1% -- 49.9% 43.2% 1.3% - 16.4% 46.1% 44.8% -3.4% a. What is the arithmetic average return over the 10-year period? b. What is the geometric average return over the 10-year period? c. If you invested $100 at the beginning, how much would you have at the end
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
