Excel guru help needed please..

C_Mababejive

OK so i have had a go at this with limited success..

Heres what i want to do..


column headings (corrected)

A1 (year) B1 Amount(in money) C1 A percentage figure

The year column is of minor importance...

So i want to put an amount (not yet specified) in A2. I want to put a percentage in A3

I then want to display in B3 the sum of B2 plus the % increase in C3


I want this to repeat vertically downward for subsequent years.

Maybe there is a formula that can be input and i can just drag in down the columns?

Effectively its a cumulative growth sum...

Thanks for any help ..

wongataa

In B3 the equation is =B2*(1+C3)


Just drag down cell B3 as far as you want and in the C column type in whatever percentages you want.

Neil_Jones

So you want something like:

100 + 10% = 110 + 10% = 121 etc?

Remember that if you drag down the cells the referenced formula cells will auto increase too, you can avoid this by using absolute cell references in the formula, ie $A$1 will always reference A1 no matter how far down you drag it.

That being said, Excel has a function for compound interest, have a look at this:
https://www.ablebits.com/office-addins-blog/2016/08/03/calculate-cagr-excel-formulas/

stragglebod

A1, B2, C3?

Those form a diaganal line, not a row.

What exactly are you trying to do?

C_Mababejive

stragglebod wrote: »

A1, B2, C3?

Those form a diaganal line, not a row.

What exactly are you trying to do?

Sorry ,,that should be A1 B1 C1

This is what id like to happen for example....

YEAR AMOUNT PERCENT
1 100 5
2 105
3 110.25
4 115.76

etc etc

Id like to be able to input a diffent amount and/or percentage and then just drag the formula down the amount column for it to auto calculate the compound new amount.. It doesnt display too well when i post but year amount and percent are separate columns and the top columns should read 1 100 and 5 (percent)Thanks all

Cornucopia

The solutions already posted in the thread will do what you want.

B1 has your starting amount
C1 has your percentage (enter it using the percentage format, or as a decimal i.e. 5% = 0.05)

B2 then has "=B1+(B1*$C$1)"
"$" fixes the percentage as an absolute cell reference.

Then copy B2 down column B to derive further values.

Heedtheadvice

OR.....


If you want to enter and calculate a varying interest rate, year to year, then put those rates in column C such that they align with the row for the applicable year. So formula in B2 would now be:

=B1+(B1*$C1)

...still summing but based upon the intetest rate applicable for the preceding year rather than a single fixed rate.
As you copy down the formula and b1 increments to b2, b3 etc so will the formula rate in colum c be incremented to the c2, c3 etc.


If your saving is incremented for compound interest at a period other than annually you can change the rows to be months (or whatever) instead of years such as it might be for a monthly saver account.

C_Mababejive

Thanks all,this is working well for me now