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
Get step-by-step solutions from verified subject matter experts
