Question 1A Year 1 2 3 4 Return ( ) 3 5 27 7 11 7 4 3 The last four years of returns for a stock are as shown here a What is the average annual return b What is the variance of the stock's returns c What is the standard deviation of the stock's returns Note Notice that the average return and standard deviation must be entered in percentage format The variance must be entered in decimal format a What is the average annual return The average return is (Round to two decimal places ) b What is the variance of the stock's returns The variance of the returns is (Round to five decimal places ) c What is the standard deviation of the stock's returns The standard deviation is (Round to two decimal places ) Question 1B Date SBUX Dividend GOOG Dividend 16 Nov 2017 $57 24 $0 00 $1048 47 $0 00 07 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 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 The return without the dividends is (Round to three decimal places ) With the dividends b What is the return for GOOG over the period The return is (Round to three decimal places ) c If you have 67 of your portfolio in SBUX and 33 in GOOG, what was the return on your portfolio excluding dividends The return of the portfolio is (Round to three decimal places )

The Answer is in the image, click to view ...

Question: Question 1A: Year 1 2 3 4 Return (%) -3.5 27.7 11.7 4.3 The last four years of returns for a stock are as shown

Question 1A:

Year	1	2	3	4
Return (%)	-3.5	27.7	11.7	4.3

The last four years of returns for a stock are as shown here:

a. What is the average annual return?

b. What is the variance of the stock's returns?

c. What is the standard deviation of the stock's returns?

Note: Notice that the average return and standard deviation must be entered in percentage format. The variance must be entered in decimal format.

a. What is the average annual return?

The average return is %. (Round to two decimal places.)

b. What is the variance of the stock's returns?

The variance of the returns is. (Round to five decimal places.)

c. What is the standard deviation of the stock's returns?

The standard deviation is %. (Round to two decimal places.)

Question 1B:

Date	SBUX	Dividend	GOOG	Dividend
16-Nov-2017	$57.24	$0.00	$1048.47	$0.00
07-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

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?

The return without the dividends is %. (Round to three decimal places.)

With the dividends?

b. What is the return for GOOG over the period?

The return is %. (Round to three decimal places.)

c. If you have 67% of your portfolio in SBUX and 33% in GOOG, what was the return on your portfolio excluding dividends?

The return of the portfolio is %. (Round to three decimal places.)

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!

(Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Year 1 2 3 4 Return - 4.4% + 27.9% + 11.7% +4.3% The last four years of...

WILL RATE! Year 1 2 3 4 Return 4.1% +28.3% +11.7% +4.1% The last four years of returns for a stock are as shown in the table: a. What is the average annual return? b. What is the variance of the...

Year 1 2 3 4 Return -3.9% 27.8% 11.6% 4.3% The last four years of returns for a stock are as shown here: a. What is the average annual return? round to two decimals b. What is the variance of the...

What is the standard Deviation of the stock's return? Year 1 2 3 4 Return -3.80% 28.40% 12.50% 3.80% The last four years of returns for a stock are as shown here a. What is the average annual return?...

- Data table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 1 2 3 4 Return - 4.0% + 28.0% + 12.0% + 4.0% The last four years of returns for a stock are as shown...

Year 1 2 3 4 Return - 4.4% - + 28.3% + 12.2% + 3.9% The last four years of returns for a stock are as shown here: a. What is the average annual return? b. What is the variance of the stock's returns?...

Year 1 2 3 4 Return -4.2% +27.8 % +11.6 % +3.6 % The last four years of returns for a stock are as shown here: LOADING... . a. What is the average annual return? in % b. What is the variance of the...

Year 1 2 3 4 Return -4.0% 28.0% 12.0% 4.0% The last four years of returns for a stock are as shown here: a. what is the average annual return? b. What is the variance of the stock's returns? c. What...

Year 1 2 3 4 Return - 3.9% + 28.2% + 12.4% + 4.2% The last four years of returns for a stock are as shown here: a. What is the average annual return? b. What is the variance of the stock's returns?...

Question 3 The last four years of returns for a stock are as shown here: Year 1 2 3 4 Return -3.5% +28.2% +11.7% +4.2% . a. What is the average annual return? (Round to two decimal places.) b. What...

Child's Play Company makes a plastic rattle for toddlers. The rattle is generally marketed through exclusive retailers located in upscale shopping malls. The company used 23 retailers. In late 2016,...

On January 1, 2019, Commercial Equipment Sales issued $36,000 in bonds for $16,700. These are six-year bonds with a stated interest rate of 15%, and pay semiannual interest on June 30 and December...

Candace homeowner policy a 2 0 1 1 addition of insurance service office Inc. standard form HO 3 has a 2 0 0 , 0 0 0 limit on the coverage that applies to her dwelling building before putting the...

Question 2 The portfolios performance should be compared to guidelines specified in the policy statement, not on the portfolios overall return. Elucidate the standards for evaluating portfolio...

4. A meal at a McDonalds restaurant in New York costs $8. The identical meal at a McDonalds restaurant in London costs 4. According to the purchasing-power-parity theory of exchange rates, the...

11. last word If a country like Greece that has joined the European Monetary Union can no longer use an independent monetary policy to offset a recession, what sorts of fiscal policy initiatives...

5. Suppose that the Fed is fixing the dollar-pound exchange rate at $2.50 = 1. If the Feds reserve of pounds falls by 500 million, by how much would the supply of dollars increase, all other things...