by Moonde » Thu Oct 28, 2010 9:51 am
ericu wrote:That doesn't add onto the previous years, im usually good at this but im juggling three projects right now and just cant wrap my head around the mathematical equation.
the interest for the next year has to account for the interest that was already added on from the previous year, for instance.
100$ to start, with 10% interest would come out to 110$ after the first year, i then need it to continue to add interest onto that for however many years the user puts in. so the second year should be 110$ * 10% = 111$ and so on and so on.
I just can't think of how to actually write that as a formula
Sorry ericu, from the your op I thought you had the loop down and you just needed the formula. For loop would have worked nice as well.
[quote="ericu"]That doesn't add onto the previous years, im usually good at this but im juggling three projects right now and just cant wrap my head around the mathematical equation.
the interest for the next year has to account for the interest that was already added on from the previous year, for instance.
100$ to start, with 10% interest would come out to 110$ after the first year, i then need it to continue to add interest onto that for however many years the user puts in. so the second year should be 110$ * 10% = 111$ and so on and so on.
I just can't think of how to actually write that as a formula[/quote]
Sorry ericu, from the your op I thought you had the loop down and you just needed the formula. For loop would have worked nice as well.