Hi Currently I am making a compounding calculator. Here is what I have and what I need to find out.
Say you get 190% of something after 20 times. Each time is compounded ontop of eachother. What I need to find out is how much % would you need to make 190% if you compounded. In this case it would be 3.2613218237364% compounded 20 times.
The code I use to find out what 3.2613218237364% is this
VB Code:
total = starting + (starting * percentage / 100) For j = 2 To timescompounded total = total + (total* percentage / 100) Next j
So in this case it would be
VB Code:
total = 100 + (100 * 3.2613218237364 / 100) For j = 2 To 20 total = total + (total* 3.2613218237364 / 100) Next j
How can I find 3.2613218237364 If all I have is the total starting amount and times compounded?
Thank You
Robert AKA Messup000




Reply With Quote