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 the beginning of 2013.

To compute dollar-weighted return, prepare a chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2010, to January 1, 2013. (Enter your answer as an integer. Negative amounts should be indicated by a minus sign.)

Date	Cash Flow (for the investor)
1/1/2010	?

Expert Solution


Year	Price at the begin	Dividend received at year end	return(%)
2010	$124	$4
2011	$135	$4	12.097	((135-124+4)/124)*100
2012	$115	$4	-11.852	((115-135+4)/135)*100
2013	$120	$4	7.826	((120-115+4)/115)*100

Date	net cash flow			Cumulative Number of shares
01/01/2010	-$744	[ buy 6 shares * $124 per share]	-124*6	6
01/01/2011	-$246	[ buy 2 shares * $135 per share]+[received $4 dividend*6 shares]	(-1352)+(46)	6+2=8
01/01/2012	$147	[sell one share* $115 per share]+[ received $4 dividend*8 shares]	(1115)+(84)	8-1=7
01/01/2013	$868	[sell seven share* $120 per share]+[ received $4 dividend*7 shares]	(1207)+(47)	7-7=0

Dollar weighted return is the IRR of the cash flow = 0.961%

IRR can be calculated in excel by using the IRR formula function

jeff jeffy answered 2 years ago

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 2015 $ 130 $ 5 2016 144 5 2017 120 5 2018 125 5 An investor buys six shares of XYZ at the beginning of 2015, buys another three shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all eight 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 $100 $4 2011 $110 $4 2012 $90 $4 2013 $95 $4 Compute the standard deviation of stock return.

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 $ 120 $ 2 2016 129 2 2017 115 2 2018 120 2 An investor buys six shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all seven 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 2015 $ 114 $ 5 2016 120 5 2017 100 5 2018 105 5 An investor buys four shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all five remaining shares at the beginning of 2018. a. What are the arithmetic and geometric average time-weighted rates...

Question

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

Solutions

Expert Solution

Related Solutions

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...

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...

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...

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...

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...