Compounding Interest

**matt b** · 09-22-2011, 12:17 PM

is anyonne able to help me, I am trying to work out a formula to calculate compounded interest rates.

I have a table that is 24 columns wide (months).
1 row that will have amounts input in to the columns (these will be different amounts)

I want to have a row along the bottom that calulates the compounded interest at a fixed interest rate on the total amount that is in the first row.

i have mnaged to do this using a table but surely there is a formula for this as the table can become very troublesome if the input amounts change.

Ive added an image (attached) to hopefully make this a bit clearer.

Many thanks in advance if you can help you will be saving me days of work

**quekbc** · 09-26-2011, 07:09 AM

Hi matt b,

Please see attached.

**matt b** · 09-26-2011, 09:38 AM

Hi quwkbc

is it possible to do this so that i can add more amounts at any period?

thanks

**quekbc** · 09-26-2011, 11:12 AM

Hi Matt,

If you want it to be fully flexible, I would recommend doing it via a control account method. Please see attached.

**matt b** · 09-26-2011, 11:35 AM

that is perfect thank very much for your help

**llrittenhouse** · 08-02-2014, 06:43 PM

You still there?

How would this change if my columns were monthly for additions, not yearly? Do I just change the header to Month 1 and make the interest 1/12 of 10%?

**protonLeah** · 08-02-2014, 06:47 PM

@llrittenhouse,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.