You purchased 100 shares of BJ's Corp. common stock on 04/01/2009 for $57.49 per share. On December 29, 2017 you sold the 100 shares for $172.12 per share. Dividend payment dates and amounts per share for the period of time you owned the stock are shown below. (A) Calculate your annual rate of return on this investment. (B) Calculate your annual rate of return without including the dividends in the calculation. You will need to use the XIRR function in EXCEL to calculate the answers for parts A & B.

$0.50	6/22/09
$0.50	9/16/09
$0.55	12/15/09
$0.55	3/15/10
$0.55	6/15/10
$0.55	9/16/10
$0.61	12/15/10
$0.61	3/15/11
$0.61	6/15/11
$0.61	9/16/11
$0.70	12/15/11
$0.70	3/15/12
$0.70	6/15/12
$0.70	9/18/12
$0.77	12/17/12
$0.77	3/15/13
$0.77	6/17/13
$0.77	9/17/13
$0.81	12/16/13
$0.81	3/17/14
$0.81	6/16/14
$0.81	9/16/14
$0.85	12/15/14
$0.85	3/16/15
$0.85	6/15/15
$0.85	9/16/15
$0.89	12/15/15
$0.89	3/15/16
$0.89	6/20/16
$0.89	9/16/16
$0.94	12/15/16
$0.94	3/15/17
$0.94	6/19/17
$0.94	9/18/17
$1.01	12/15/17