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

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  

YearsCash flow

0-76.63

11.37

21.55

31.66

41.74

586.61  

IRR4.08%

Find attached for detailed computation.

answer///parietal;

two years ago, when picking flowers in the mountains back of yosemite valley, i found a book. it was blotted and storm-beaten; all of its outer pages were mealy and crumbly. the paper seemed to dissolve like the snow beneath which it had been buried, however; many of the inner pages were well preserved. and although all were more or less stained and torn, whole chapters were easily readable. this is the condition of the great open book of yosemite glaciers today; its granite pages have been torn and blurred by the same storms that wasted the castaway book.

two years ago, when picking flowers in the mountains back of yosemite valley; i found a book. it was blotted and storm-beaten, all of its outer pages were mealy and crumbly. the paper seemed to dissolve like the snow beneath which it had been buried, however, many of the inner pages were well preserved. and although all were more or less stained and torn; whole chapters were easily readable. this is the condition of the great open book of yosemite glaciers today, its granite pages have been torn and blurred by the same storms that wasted the castaway book.