Answer:
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%
