Interest % Calculation

[goodboy]

Hi,
Basically i want to know how much interest % i earned when I invested monthly.

Column A date when invested
Column B amt when invested
column C amt received as dividend
Column D date when dividend was received
Column C50 shows final amt received

kindly let me know how to calculate the interest percentage i earned.

Thanks in advance

[mehmetcik]

Maybe the attached file will help.

I have assumed that you withdrew the interest / Dividend each year.