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.
The future amount of an investment with compound interest can be calculated through the equation,
F = P x (1 + ieff)^n
where F is the future amount, P is the current value of the money, ieff is the effective interest (rate per year), and n is the number of years.
From the equation, all are given except for the effective interest, i. Now, substituting the known values,
14,398.87 = (7,775) x (1 + ieff)^14
The value of ieff from the equation is 0.044999.
Since the value of the ieff when translated to percentage is equal to 4.5% as well, the interest rate is compounded yearly.