Question

In: Finance

XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End...

XYZ's stock price and dividend history are as follows:

Year Beginning-of-Year Price Dividend Paid at Year-End
2016 $ 100 $ 4
2017 120 4
2018 90 4
2019 100 4

An investor buys three shares of XYZ at the beginning of 2016, buys another two shares at the beginning of 2017, sells one share at the beginning of 2018, and sells all four remaining shares at the beginning of 2019.

a. What are the arithmetic and geometric average time-weighted rates of return for the investor? (Round your year-by-year rates of return and final answer to 2 decimal places. Do not round other calculations.)

b. What is the dollar-weighted rate of return? (Hint: Carefully prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2016, to January 1, 2019. If your calculator cannot calculate internal rate of return, you will have to use trial and error.) (Round your answers to 4 decimal places. Negative amount should be indicated by a minus sign.)

Solutions

Expert Solution

For time weighted return, we use the simple formula

R = [(1+R1) * (1+R2)* ....*(1+RN)]1/N - 1

Where R1 is the HPY of period 1 and N is the number of periods.

HPY 2016 = 4/100 *100 = 4%

HPY 2017 = 120-100+4/100 *100 =24%

And so on,

We calculated the HPY for all the 4 time periods and then put them into this formula. Number of period is 4. So, 1/N = 0.25. Hence we get the Geometric avg time weighted return of 3.94% and taking a arithmetic mean of the 4 HPY We get an arithmetic mean of 10.22%.

For the dollar weighted return.

We prepare the cash flows for each year.

1st = (-100*3) + (4*3) = -288

As 3 shares were purchased and we received dividend on them.

2nd = -120*2 + 5*4 = -220

2 shares were purchased for 120$ each and we received total dividends of 20$ on all the 5 shares.

And so on. After we compute the cash flows for 4 years. We use IRR function to calculate money weighted return.

Which is =IRR(Value1:Value4)


Related Solutions

XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2016 $ 185 $ 6 2017 195 6 2018 170 6 2019 185 6 An investor buys three shares of XYZ at the beginning of 2016, buys another two shares at the beginning of 2017, sells one share at the beginning of 2018, and sells all four remaining shares at the beginning of 2019. a. What are the arithmetic and geometric average time-weighted rates...
XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2017 $ 125 $ 7 2018 145 7 2019 115 7 2020 125 7 An investor buys three shares of XYZ at the beginning of 2017, buys another two shares at the beginning of 2018, sells one share at the beginning of 2019, and sells all four remaining shares at the beginning of 2020. a. What are the arithmetic and geometric average time-weighted rates...
XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ's stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2017 $ 190 $ 5 2018 200 5 2019 180 5 2020 190 5 An investor buys three shares of XYZ at the beginning of 2017, buys another two shares at the beginning of 2018, sells one share at the beginning of 2019, and sells all four remaining shares at the beginning of 2020. a. What are the arithmetic and geometric average time-weighted rates...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End   2010 $ 124                 $ 4                       2011 $ 135                 $ 4                       2012 $ 115                 $ 4                       2013 $ 120                 $ 4                     An investor buys six 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 seven remaining shares at...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End   2010 $ 124                 $ 4                       2011 $ 135                 $ 4                       2012 $ 115                 $ 4                       2013 $ 120                 $ 4            An investor buys six 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 seven remaining shares at...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End   2010 $ 124                 $ 4                       2011 $ 135                 $ 4                       2012 $ 115                 $ 4                       2013 $ 120                 $ 4                     An investor buys six 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 seven remaining shares at...
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2010 $ 102 $ 3 2011 $ 105 $ 3 2012 $ 91 $ 3 2013 $ 96 $ 3 An investor buys three shares of XYZ at the beginning of 2010, buys another one shares at the beginning of 2011, sells one share at the beginning of 2012, and sells all three remaining shares at the beginning of 2013. a. What are the...
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2010 $ 140 $ 4 2011 $ 159 $ 4 2012 $ 132 $ 4 2013 $ 137 $ 4 An investor buys five shares of XYZ at the beginning of 2010, buys another three shares at the beginning of 2011, sells one share at the beginning of 2012, and sells all seven remaining shares at the beginning of 2013. a. What are the...
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2015 $ 102 $ 3 2016 105 3 2017 91 3 2018 96 3 An investor buys three shares of XYZ at the beginning of 2015, buys another one shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all three remaining shares at the beginning of 2018. a. What are the arithmetic and geometric average time-weighted rates...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End...
XYZ stock price and dividend history are as follows:   Year Beginning-of-Year Price Dividend Paid at Year-End   2010 $ 124                 $ 4                       2011 $ 135                 $ 4                       2012 $ 115                 $ 4                       2013 $ 120                 $ 4                     An investor buys six 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 seven remaining shares at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT