Hi Everyone,
I'd like to ask a question about a very simple excel problem but I don't know how to solve it, haha.
I have a sequence formula like this:
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]1000[/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A1*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A2*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A3*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A4*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A5*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Well, my question is there any single formula to solve this? Like calculating future value in investment, which the equation is just simply put this formula =$A$1*(1+$B$1)^(ROW(A2)-1) or in mathematic equation is :
where,
Thanks for your help guys..
Budyono from Indonesia
I'd like to ask a question about a very simple excel problem but I don't know how to solve it, haha.
I have a sequence formula like this:
[TABLE="class: grid, width: 300"]
<tbody>[TR]
[TD]1000[/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A1*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A2*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A3*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A4*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]=ROUNDDOWN(A5*(1+$B$1),0)[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Well, my question is there any single formula to solve this? Like calculating future value in investment, which the equation is just simply put this formula =$A$1*(1+$B$1)^(ROW(A2)-1) or in mathematic equation is :
![annual_compound_interest_formula.png](/board/proxy.php?image=https%3A%2F%2Fwww.excelfunctions.net%2Fimages%2Fannual_compound_interest_formula.png&hash=de758796e33103ff071615594a253cf1)
- P is the initial amount invested;
- r is the annual interest rate (as a decimal);
- n is the number of periods over which the investment is made.
Thanks for your help guys..
Budyono from Indonesia
Last edited: