Question

7. XYZ stock price and dividend history are as follows: An investor buys three shares of XYZ at the beginning of 2010, buys another two shares at the beginning of 2011, sells one share at the beginning of 2012, and sells all four remaining shares at the beginning of 2013. (LO 5-1)

Answer 1

A lot of information (number are missing) as well as the requirements, so I looked for a similar question and found:

Year Beginning-of-Year Price Dividend Paid at Year-End

2010 $ 108 $4

2011 $ 112 $4

2012 $ 98 $4

2013 $ 103 $4

a. Calculate the time-weighted rate of return for the investor?

b. Calculate the money-weighted rate of return for the investor?

a) first we must determine the holding period return (HPR) for:

2010 = [($336 - $324) + $12] / $324 = 0.074

2011 = [($490 - $560) + $20] / $560 = -0.089

2012 = [($412 - $392) + $16] / $392 = 0.092

time weighted rate of return (TWRR) = [(1 + 0.074) x (1 - 0.089) x (1 + 0.092)] - 1 = 1.0684 - 1 = 0.0684 = 6.84%

b) calculating the money weighted rate of return is similar to calculating the IRR of a project:

cash flow at the beginning of 2010 = -$108 x 3 = -$324

cash flow at the beginning of 2011 = (-$112 x 2) + $12 = -$212

cash flow at the beginning of 2012 = $98 + $20 = $118

cash flow at the beginning of 2013 = ($103 x 4) + $20 = $432

using an excel spreadsheet, the MWRR = 1.08%