Question

Josh purchased 100 shares of XOM for $76.63 per share at the beginning of 2007. He received dividends per share of $1.37 (2007), $1.55 (2008), $1.66 (2009), $1.74 (2010), $1.85 (2011). At the end of 2011, just after receiving the last dividend, he sold the stock for $84.76. What was his average annual rate of return form both dividends and capital gains? (Hint: compute the IRR, assume that all dividends were received at the end of the year.)

Answer 1

Answer:

The IRR is 4.08%

Explanation:

In calculating the internal rate of return in excel,the cash outflow of $76.63 is shown in year 0 with a negative sign to indicate that it is the initial investment on the share, followed by dividends in received in later years shown as positive figures ,however in the fifth the dividend received and the cash received from disposing of the share were added together to show total cash inflow in the last year.

The computation of IRR is shown below

IRR for the share purchase  

 

Years Cash flow

0 -76.63

1 1.37

2 1.55

3 1.66

4 1.74

5 86.61  

IRR 4.08%

Find attached for detailed computation.

Download xlsx