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:
<tbody>
</tbody>
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:
1000 | 5% |
=ROUNDDOWN(A1*(1+$B$1),0) | |
=ROUNDDOWN(A2*(1+$B$1),0) | |
=ROUNDDOWN(A3*(1+$B$1),0) | |
=ROUNDDOWN(A4*(1+$B$1),0) | |
=ROUNDDOWN(A5*(1+$B$1),0) |
<tbody>
</tbody>
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 :
- 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: