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.

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

Year                                  Return=(capital gains+dividend)/Price

2010-2011:                     (135-124+4)/124=0.123

2011-2012:                      (115-135+4)/135=-0.119

2012-2013:                      (120-115+4)/120=0.078

Arithmetic= [0.123+ (-0.119)+0.078)]/3=0.0273=2.73%

Geometric=

b-1. Prepare chart of cash flows for the four dates corresponding to the turns of the year for January 1, 2010, to January 1, 2013. (Negative amounts should be indicated by a minus sign.)

Date                                 Cash Flow

1/1/2010                        \$-496                                       {( -(124*4))

1/1/2011                        \$-389                                             {(-135*3)+4*4}

1/1/2012                        \$143                                 1 × 115 + (4 + 3) × 4 = 143

1/1/2013                         \$744

(4 + 3 − 1) × (120 + 4) = \$744

b-2. What is the dollar-weighted rate of return? (Hint: If your calculator cannot calculate internal rate of return, you will have to use a spreadsheet or trial and error.) (Negative value should be indicated by a minus sign. Round your answer to 4 decimal places.)

The dollar-weighted average return is the IRR of the cash flows provided in the above chart.

-496+(-389)/(1+r)+143/((1+r)^2)+744/((1+r)^3)=0

r =

I just need you to calculate R = ?

##### "Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!" 