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.