| Date | Close | Dividend |
| Aug-11 | 171.91 | 0.75 | | | | | Note: Values in Column B represent the closing price on the last trading day of the month. |
| Sep-11 | 174.87 | 0 | | | | | Values in Column C represent dividend payments made during the month indicated. |
| Oct-11 | 184.63 | 0 | | | | | If you buy the stock at the August 2011 close, you have missed the August dividend! |
| Nov-11 | 188 | 0.75 | | | | | Create new rows or columns in this spreadsheet as needed. |
| Dec-11 | 183.88 | 0 | | | | | Report final results in yellow boxes beginning in row 32. |
| Jan-12 | 192.6 | 0 |
| Feb-12 | 196.73 | 0.75 |
| Mar-12 | 208.65 | 0 |
| Apr-12 | 207.08 | 0 |
| May-12 | 192.9 | 0.85 |
| Jun-12 | 195.58 | 0 |
| Jul-12 | 195.98 | 0 |
| Aug-12 | 194.85 | 0.85 |
| Sep-12 | 207.45 | 0 |
| Oct-12 | 194.53 | 0 |
| Nov-12 | 190.07 | 0.85 |
| Dec-12 | 191.55 | 0 |
| Jan-13 | 203.07 | 0 |
| Feb-13 | 200.83 | 0.85 |
| Mar-13 | 213.3 | 0 |
| Apr-13 | 202.54 | 0 |
| May-13 | 208.02 | 0.95 |
| Jun-13 | 191.11 | 0 |
| Jul-13 | 195.04 | 0 |
| Aug-13 | 182.64 | 0.95 |
| Report your final results in the cells below |
| Arithmetic mean of monthly HPRs: |
| Geometric mean of monthly HPRs: |
| Standard deviation of monthly HPRs: |
| 5% VaR |
| Annualized HPR (arithmetic): |
| Annualized HPR (geometric): |
| Annualized standard deviation: |
glangsing
ibm_data_august_2013.xls
