Question: Use the table below a.What was the average annual return of Microsoft stock from 2002-2014? b. What was the annual volatility for Microsoft stock from

Use the table below

a.What was the average annual return of Microsoft stock from 2002-2014?

b. What was the annual volatility for Microsoft stock from 2002-2014?

(Round to two decimal places.)

Realized Return for the S&P 500, Microsoft, and Treasury Bills, 2002-2014

Year End

S&P 500

Index

Dividends

Paid*

S&P 500

Realized Return

Microsoft Realized

Return

1-Month

T-Bill Return

2001

1148.08

2002

879.82

14.53

minus22.1%

minus22.0%

1.6%

2003

1111.92

20.80

28.7%

6.8%

1.0%

2004

1211.92

20.98

10.9%

8.9%

1.2%

2005

1248.29

23.15

4.9%

minus0.9%

3.0%

2006

1418.30

27.16

15.8%

15.8%

4.8%

2007

1468.36

27.86

5.5%

20.8%

4.7%

2008

903.25

21.85

minus37.0%

minus44.4%

1.5%

2009

1115.10

27.19

26.5%

60.5%

0.1%

2010

1257.64

25.44

15.1%

minus6.5%

0.1%

2011

1257.60

26.59

2.1%

minus4.5%

0.0%

2012

1426.19

32.67

16.0%

5.8%

0.1%

2013

1848.36

39.75

32.4%

44.2%

0.0%

2014

2058.90

42.47

13.7%

27.5%

0.0%

*Total dividends paid by the 500 stocks in the portfolio, based on the number of shares of each stock in the index, adjusted until the end of the year, assuming they were reinvested when paid.

Source:

Standard & Poor's, Microsoft and U.S. Treasury Data

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!