> Calculating interest with stocks.?

Calculating interest with stocks.?

Posted at: 2014-12-05 
You can set this up in Excel or another spread sheet program very easily. For a rough approximation, the basic equation is

Final Value = [Initial Value * (1+Interest Rate)]+ Added Contributions

For Example, using your 26% on a per year basis:

Annual Contribution

$2000

Annual Interest Rate

26%



01 $1,700.00

02 $4,142.00

03 $7,218.92

04 $11,095.84

05 $15,980.76

06 $22,135.75

07 $29,891.05

08 $39,662.72

09 $51,975.03

10 $67,488.54

This equation assumes you earn a constant rate of return, and make new contributions at the end of each period. The periods could be anything, but your interest rate must match the period (years for annual return, quarters for quarterly return, etc)

Dragging that equation out for 40 years in excel gives you about $77 million

Your stated interest rate is 26% semi-annually, so dragging that for 80 periods with $1000 semi-annual contribution gives $471,264,768,287.03 after 40 years.

I have made a 26.42% increase on my stocks since I started purchasing them in January. I am wondering how much my account will be worth if that percentage doesn't change after x amount of years. Can someone help me get a formula or something. I have put in over $1700 and the account is worth over $2200. If I keep buying and the rate stays the same I want to know how much my account will be worth. Or how I could calculate if it were to go up or down. Please help.