Spreadsheet: 87357d1287164409-excel-2007-using-xirr-with-dynamic-ranges-test-workbook-for-xirr-no-vba
Sheet: 10 OCT 10

MKSYM | PTDate | Transaction | NSB | CDCR | BasisValue | CASH_FLOW
BRKB | 2008-06-04 00:00:00 | PURCHASE | 200 |  | 22130.35 | -22130.35
BRKB | 2008-07-01 00:00:00 | Cash Dividend |  | 64 |  | 64
BRKB | 2008-10-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BRKB | 2009-04-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BRKB | 2009-07-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BRKB | 2009-10-01 00:00:00 | Cash Dividend |  | 80 |  | 80
BRKB | 2010-01-04 00:00:00 | Cash Dividend |  | 80 |  | 80
BRKB | 2010-02-16 00:00:00 | Cash Dividend |  | 67.84 |  | 67.84
BRKB | 2010-02-16 00:00:00 | Cash Dividend | 48 | 1550.2 |  | 1550.2
BRKB | 2010-02-16 00:00:00 | Cash Dividend |  | 52 |  | 52
BRKB | 2010-10-08 00:00:00 | MARKET |  |  |  | 20623.68
IJT | 2009-02-24 00:00:00 | PURCHASE | 110 |  | 4016.78 | -4016.78
IJT | 2009-03-31 00:00:00 | Cash Dividend |  | 1.69 |  | 1.69
IJT | 2009-06-29 00:00:00 | Cash Dividend |  | 7.53 |  | 7.53
IJT | 2009-09-29 00:00:00 | Cash Dividend |  | 5.08 |  | 5.08
IJT | 2009-11-10 00:00:00 | PURCHASE | 15 |  | 806.84 | -806.84
IJT | 2009-12-31 00:00:00 | Cash Dividend |  | 11.08 |  | 11.08
IJT | 2010-03-31 00:00:00 | Cash Dividend |  | 12.65 |  | 12.65
IJT | 2010-06-29 00:00:00 | Cash Dividend |  | 11.36 |  | 11.36
IJT | 2010-09-30 00:00:00 | Cash Dividend |  | 13.86 |  | 13.86
IJT | 2010-10-08 00:00:00 | MARKET |  |  |  | 7975.62
IPE | 2009-11-10 00:00:00 | PURCHASE | 290 |  | 15007.5 | -15007.5
IPE | 2009-12-09 00:00:00 | Cash Dividend |  | 27.65 |  | 27.65
IPE | 2010-01-07 00:00:00 | Cash Dividend |  | 31.75 |  | 31.75
IPE | 2010-02-09 00:00:00 | Cash Dividend |  | 27.84 |  | 27.84
IPE | 2010-04-12 00:00:00 | Cash Dividend |  | 56.19 |  | 56.19
IPE | 2010-05-11 00:00:00 | Cash Dividend |  | 22.06 |  | 22.06
IPE | 2010-06-09 00:00:00 | Cash Dividend |  | 72.94 |  | 72.94
IPE | 2010-07-12 00:00:00 | Cash Dividend |  | 41.57 |  | 41.57
IPE | 2010-08-10 00:00:00 | Cash Dividend |  | 27.82 |  | 27.82
IPE | 2010-09-10 00:00:00 | Cash Dividend |  | 3.34 |  | 3.34
IPE | 2010-10-08 00:00:00 | MARKET |  |  |  | 15964.5
ITM | 2009-11-10 00:00:00 | PURCHASE | 145 |  | 3062.7 | -3062.7
ITM | 2009-12-07 00:00:00 | Cash Dividend |  | 8.85 |  | 8.85
ITM | 2010-01-05 00:00:00 | Cash Dividend |  | 0.58 |  | 0.58
ITM | 2010-01-05 00:00:00 | Cash Dividend |  | 9.28 |  | 9.28
ITM | 2010-02-05 00:00:00 | Cash Dividend |  | 8.92 |  | 8.92
ITM | 2010-03-05 00:00:00 | Cash Dividend |  | 8.27 |  | 8.27
ITM | 2010-04-08 00:00:00 | Cash Dividend |  | 8.7 |  | 8.7
ITM | 2010-05-07 00:00:00 | Cash Dividend |  | 8.7 |  | 8.7
ITM | 2010-06-07 00:00:00 | Cash Dividend |  | 8.99 |  | 8.99
ITM | 2010-07-08 00:00:00 | Cash Dividend |  | 8.99 |  | 8.99
ITM | 2010-08-06 00:00:00 | Cash Dividend |  | 8.99 |  | 8.99
ITM | 2010-09-08 00:00:00 | Cash Dividend |  | 8.85 |  | 8.85
ITM | 2010-10-08 00:00:00 | MARKET |  |  |  | 3240.75
IWP | 2009-01-16 00:00:00 | PURCHASE | 70 |  | 2119.6 | -2119.6
IWP | 2009-02-24 00:00:00 | PURCHASE | 110 |  | 3077.66 | -3077.66
IWP | 2009-03-30 00:00:00 | Cash Dividend |  | 15.45 |  | 15.45
IWP | 2009-07-09 00:00:00 | Cash Dividend |  | 16.48 |  | 16.48
IWP | 2009-09-28 00:00:00 | Cash Dividend |  | 16.04 |  | 16.04
IWP | 2009-11-10 00:00:00 | PURCHASE | 20 |  | 867.6 | -867.6
IWP | 2009-12-30 00:00:00 | Cash Dividend |  | 25.95 |  | 25.95
IWP | 2010-01-11 00:00:00 | PURCHASE | 45 |  | 2088 | -2088
IWP | 2010-03-30 00:00:00 | Cash Dividend |  | 20.71 |  | 20.71
IWP | 2010-07-09 00:00:00 | Cash Dividend |  | 29.97 |  | 29.97
IWP | 2010-09-29 00:00:00 | Cash Dividend |  |  |  | 25.69
IWP | 2010-10-08 00:00:00 | MARKET |  |  |  | 12361.47
MLN | 2009-01-16 00:00:00 | PURCHASE | 120 |  | 2060.08 | -2060.08
MLN | 2009-02-24 00:00:00 | PURCHASE | 120 |  | 2046.47 | -2046.47
MLN | 2009-02-26 00:00:00 | Cash Dividend |  | 7.2 |  | 7.2
MLN | 2009-03-06 00:00:00 | Cash Dividend |  | 17.28 |  | 17.28
MLN | 2009-04-07 00:00:00 | Cash Dividend |  | 17.28 |  | 17.28
MLN | 2009-05-07 00:00:00 | Cash Dividend |  | 17.76 |  | 17.76
MLN | 2009-06-05 00:00:00 | Cash Dividend |  | 18.72 |  | 18.72
MLN | 2009-07-08 00:00:00 | Cash Dividend |  | 18 |  | 18
MLN | 2009-08-07 00:00:00 | Cash Dividend |  | 18 |  | 18
MLN | 2009-09-08 00:00:00 | Cash Dividend |  | 18 |  | 18
MLN | 2009-10-07 00:00:00 | Cash Dividend |  | 16.8 |  | 16.8
MLN | 2009-11-06 00:00:00 | Cash Dividend |  | 16.8 |  | 16.8
MLN | 2009-11-10 00:00:00 | PURCHASE | 100 |  | 1799.04 | -1799.04
MLN | 2009-12-07 00:00:00 | Cash Dividend |  | 22.44 |  | 22.44
MLN | 2010-01-05 00:00:00 | Cash Dividend |  | 33.42 |  | 24.14
MLN | 2010-02-05 00:00:00 | Cash Dividend |  | 22.27 |  | 22.27
MLN | 2010-03-05 00:00:00 | Cash Dividend |  | 21.42 |  | 21.42
MLN | 2010-04-08 00:00:00 | Cash Dividend |  | 23.46 |  | 23.46
MLN | 2010-05-07 00:00:00 | Cash Dividend |  | 32.5 |  | 32.5
MLN | 2010-06-07 00:00:00 | Cash Dividend |  | 24.14 |  | 24.14
MLN | 2010-07-08 00:00:00 | Cash Dividend |  | 22.44 |  | 22.44
MLN | 2010-08-06 00:00:00 | Cash Dividend |  | 23.12 |  | 23.12
MLN | 2010-09-08 00:00:00 | Cash Dividend |  | 23.12 |  | 6463.4
OAKBX | 2002-01-10 00:00:00 | PURCHASE | 2165.67 |  | 40000 | -40000
OAKBX | 2010-10-08 00:00:00 | MARKET |  |  |  | 75113.07
ROTH DIA | 2009-01-16 00:00:00 | PURCHASE | 25 |  | 2049.5 | -2049.5
ROTH DIA | 2009-03-16 00:00:00 | Cash Dividend |  | 9.13 |  | 9.13
ROTH DIA | 2009-04-13 00:00:00 | Cash Dividend |  | 4.42 |  | 4.42
ROTH DIA | 2009-05-11 00:00:00 | Cash Dividend |  | 3.35 |  | 3.35
ROTH DIA | 2009-05-11 00:00:00 | Cash Dividend |  | 3.35 |  | 3.35
ROTH DIA | 2009-06-15 00:00:00 | Cash Dividend |  | 6.15 |  | 6.15
ROTH DIA | 2009-07-12 00:00:00 | Cash Dividend |  | 7.06 |  | 7.06
ROTH DIA | 2009-08-17 00:00:00 | Cash Dividend |  | 3.15 |  | 3.15
ROTH DIA | 2009-09-14 00:00:00 | Cash Dividend |  | 8.22 |  | 8.22
ROTH DIA | 2009-10-13 00:00:00 | Cash Dividend |  | 4.38 |  | 4.38
ROTH DIA | 2009-11-16 00:00:00 | Cash Dividend |  | 2.35 |  | 2.35
ROTH DIA | 2009-12-14 00:00:00 | Cash Dividend |  | 8.45 |  | 8.45
ROTH DIA | 2010-01-11 00:00:00 | Cash Dividend |  | 10.01 |  | 10.01
ROTH DIA | 2010-03-15 00:00:00 | Cash Dividend |  | 6.62 |  | 6.62
ROTH DIA | 2010-04-12 00:00:00 | Cash Dividend |  | 5.17 |  | 5.17
ROTH DIA | 2010-05-17 00:00:00 | Cash Dividend |  | 2.28 |  | 2.28
ROTH DIA | 2010-06-14 00:00:00 | Cash Dividend |  | 9.53 |  | 9.53
ROTH DIA | 2010-07-08 00:00:00 | Cash Dividend |  | 35.2 |  | 4.76
ROTH DIA | 2010-09-13 00:00:00 | Cash Dividend |  | 9.6 |  | 9.6
ROTH DIA | 2010-10-08 00:00:00 | MARKET |  |  |  | 2754
[NAME] | 2009-12-11 00:00:00 | PURCHASE | 120 |  | 7584.96 | -7584.96
[NAME] | 2009-12-31 00:00:00 | Cash Dividend |  | 48.74 |  | 48.74
[NAME] | 2010-01-11 00:00:00 | PURCHASE | 150 |  | 10012.5 | -10012.5
[NAME] | 2010-06-30 00:00:00 | Cash Dividend |  | 140.4 |  | 140.4
[NAME] | 2010-10-08 00:00:00 | MARKET |  |  |  | 19426.5
ROTH GWL | 2009-12-11 00:00:00 | PURCHASE | 315 |  | 7522.2 | -7522.2
ROTH GWL | 2009-12-31 00:00:00 | Cash Dividend |  | 59.32 |  | 59.32
ROTH GWL | 2010-01-11 00:00:00 | PURCHASE | 400 |  | 9972 | -9972
ROTH GWL | 2010-06-30 00:00:00 | Cash Dividend |  | 229.01 |  | 229.01
ROTH GWL | 2010-10-08 00:00:00 | MARKET |  |  |  | 17882.15
ROTH IYC | 2009-01-16 00:00:00 | PURCHASE | 50 |  | 2020 | -2020
ROTH IYC | 2009-03-31 00:00:00 | Cash Dividend |  | 7.46 |  | 7.46
ROTH IYC | 2009-06-30 00:00:00 | Cash Dividend |  | 6.7 |  | 6.7
ROTH IYC | 2009-09-28 00:00:00 | Cash Dividend |  | 6.11 |  | 6.11
ROTH IYC | 2009-12-30 00:00:00 | Cash Dividend |  | 9.49 |  | 9.49
ROTH IYC | 2010-03-31 00:00:00 | Cash Dividend |  | 5.92 |  | 5.92
ROTH IYC | 2010-06-30 00:00:00 | Cash Dividend |  | 6.31 |  | 6.31
ROTH IYC | 2010-09-29 00:00:00 | Cash Dividend |  | 8.79 |  | 8.79
ROTH IYC | 2010-10-08 00:00:00 | MARKET |  |  |  | 3110.5
[NAME] | 2010-01-11 00:00:00 | PURCHASE | 80 |  | 8423.15 | -8423.15
[NAME] | 2010-02-05 00:00:00 | Cash Dividend |  | 36.16 |  | 36.16
[NAME] | 2010-02-26 00:00:00 | Cash Dividend |  | 35.57 |  | 35.57
[NAME] | 2010-04-08 00:00:00 | Cash Dividend |  | 37.5 |  | 37.5
[NAME] | 2010-05-07 00:00:00 | Cash Dividend |  | 36.12 |  | 36.12
[NAME] | 2010-06-07 00:00:00 | Cash Dividend |  | 35.47 |  | 35.47
[NAME] | 2010-07-08 00:00:00 | Cash Dividend |  | 35.2 |  | 35.2
[NAME] | 2010-08-06 00:00:00 | Cash Dividend |  | 35 |  | 35
[NAME] | 2010-09-08 00:00:00 | Cash Dividend |  | 33.95 |  | 33.95
[NAME] | 2010-10-08 00:00:00 | MARKET |  |  |  | 9048.8
ROTH PHB | 2010-01-11 00:00:00 | PURCHASE | 140 |  | 2578.79 | -2578.79
ROTH PHB | 2010-01-11 00:00:00 | PURCHASE | 200 |  | 3681.52 | -3681.52
ROTH PHB | 2010-01-29 00:00:00 | Cash Dividend |  | 40.35 |  | 40.35
ROTH PHB | 2010-02-26 00:00:00 | Cash Dividend |  | 39.7 |  | 39.7
ROTH PHB | 2010-03-31 00:00:00 | Cash Dividend |  | 40.78 |  | 40.78
ROTH PHB | 2010-04-30 00:00:00 | Cash Dividend |  | 40.38 |  | 40.38
ROTH PHB | 2010-05-28 00:00:00 | Cash Dividend |  | 40.93 |  | 40.93
ROTH PHB | 2010-06-30 00:00:00 | Cash Dividend |  | 41.3 |  | 41.3
ROTH PHB | 2010-07-30 00:00:00 | Cash Dividend |  | 41.65 |  | 41.65
ROTH PHB | 2010-08-31 00:00:00 | Cash Dividend |  | 40.42 |  | 40.42
ROTH PHB | 2010-09-30 00:00:00 | Cash Dividend |  | 36.49 |  | 36.49
ROTH PHB | 2010-10-08 00:00:00 | MARKET |  |  |  | 6289.96
RWJ | 2009-01-16 00:00:00 | PURCHASE | 130 |  | 2054 | -2054
RWJ | 2009-04-08 00:00:00 | Cash Dividend |  | 1.93 |  | 1.93
RWJ | 2009-07-09 00:00:00 | Cash Dividend |  | 1.81 |  | 1.81
RWJ | 2009-10-08 00:00:00 | Cash Dividend |  | 0.83 |  | 0.83
RWJ | 2009-11-10 00:00:00 | PURCHASE | 50 |  | 1217 | -1217
RWJ | 2010-01-07 00:00:00 | Cash Dividend |  | 4.84 |  | 4.84
RWJ | 2010-01-07 00:00:00 | Cash Dividend |  | 1.02 |  | 1.02
RWJ | 2010-07-09 00:00:00 | Cash Dividend |  |  |  | 3.63
RWJ | 2010-10-08 00:00:00 | MARKET |  |  |  | 5162.4
WGGFX | 2008-03-18 00:00:00 | PURCHASE | 985.724 |  | 16274.31 | -16274.31
WGGFX | 2010-10-08 00:00:00 | MARKET |  |  |  | 13233.21
XRT | 2009-01-16 00:00:00 | PURCHASE | 100 |  | 2010.77 | -2010.77
XRT | 2009-02-24 00:00:00 | PURCHASE | 155 |  | 3056.24 | -3056.24
XRT | 2009-04-01 00:00:00 | Cash Dividend |  | 7.93 |  | 7.93
XRT | 2009-07-01 00:00:00 | Cash Dividend |  | 20.72 |  | 20.72
XRT | 2009-09-30 00:00:00 | Cash Dividend |  | 17.02 |  | 17.02
XRT | 2009-11-10 00:00:00 | PURCHASE | 25 |  | 890.21 | -890.21
XRT | 2009-12-31 00:00:00 | Cash Dividend |  | 84 |  | 84
XRT | 2010-03-31 00:00:00 | Cash Dividend |  | 12.68 |  | 12.68
XRT | 2010-06-30 00:00:00 | Cash Dividend |  | 39.27 |  | 39.27
XRT | 2010-09-30 00:00:00 | Cash Dividend |  | 20.49 |  | 20.49
XRT | 2010-10-08 00:00:00 | MARKET |  |  |  | 11992.4
 |  |  |  |  |  | TOTAL