Okay friends, I have a math problem I need help with!! LOL
In April 2003 I invested $366.52 in BOBE stock. I never added anything else but did let the dividends reinvest. Today, that investment is worth $955.93
How do I correctly figure the rate of return my investment has made?
How Do I Figure The Interest Rate
March 29th, 2012 at 01:30 am
March 29th, 2012 at 12:17 pm 1333023445
Interest = Principal * APY * years
I = 955.93 - 366.52 = 589.41
P = 366.52
t = 2012 - 2003 = 9
589.41 = 366.52*r*9
r = 589.41/(366.52*9)
r = 0.178680563
APY = 17.87%
March 29th, 2012 at 12:57 pm 1333025850
April 13th, 2013 at 07:50 am 1365839412
It's an easy Excel formula, where you just fiddle with the average RoR each year until the total matches. It's assuming nine full years (1 April 2003-31 March 2012), with the dividend credited at the end of the year.
OpenBalance Annual RoR Balance EndYear with RoR credited
Yr 1 366.52 11.2394 407.7146489
Yr 2 407.7146489 11.2394 453.5393291
Yr 3 453.5393291 11.2394 504.5144285
Yr 4 504.5144285 11.2394 561.2188232
Yr 5 561.2188232 11.2394 624.2964516
Yr 6 624.2964516 11.2394 694.4636269
Yr 7 694.4636269 11.2394 772.5171718
Yr 8 772.5171718 11.2394 859.3434668
Yr 9 859.3434668 11.2394 955.9285165
(In my excel formula, I had Annual RoR equal to another cell, in which i just plugged various numbers until it works (any one year may be higher or lower; this is working out the average return.) Funnily enough, that's what excel was created for, but everyone prefers it for holding lists :-) ).