Compunding Interest

's Computer Specifications

I have had to give up trying to do this myself.

I have a total of £2000 in cell 2A.
The monthly net interest is 0.02% in cell 2B
The number of periods is 12 in cell 2C
I want the total compound interest over the 12 periods to appear in cell 2D

Can anyone show me what formula achieves this?

TIA

Ed

's Computer Specifications

Hi Ed
in cell D2 enter
=A2*(1+B2)^12-A2

--
Regards

Roger Govier

"Ed O'Brien" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I have had to give up trying to do this myself.
>
> I have a total of £2000 in cell 2A.
> The monthly net interest is 0.02% in cell 2B
> The number of periods is 12 in cell 2C
> I want the total compound interest over the 12 periods to appear in
> cell 2D
>
> Can anyone show me what formula achieves this?
>
> TIA
>
> Ed
>

's Computer Specifications

Thanks, Roger.

Works a treat!

Best wishes,

Ed

"Roger Govier" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi Ed
> in cell D2 enter
> =A2*(1+B2)^12-A2
>
> --
> Regards
>
> Roger Govier
>
>
> "Ed O'Brien" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>I have had to give up trying to do this myself.
>>
>> I have a total of £2000 in cell 2A.
>> The monthly net interest is 0.02% in cell 2B
>> The number of periods is 12 in cell 2C
>> I want the total compound interest over the 12 periods to appear in cell
>> 2D
>>
>> Can anyone show me what formula achieves this?
>>
>> TIA
>>
>> Ed
>>
>
>

's Computer Specifications

Ed O'Brien wrote:
> I have a total of £2000 in cell 2A.
> The monthly net interest is 0.02% in cell 2B
> The number of periods is 12 in cell 2C
> I want the total compound interest over the 12 periods to appear in cell 2D

=FV(B2, C2,, -A2) - A2

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table: Compunding Return instead of Adding it?	evucina@gmail.com	Microsoft Excel Misc	0	20th Jan 2006 10:54 PM
Mtge calculation (Dly compound interest and multiple interest rate	=?Utf-8?B?U3B1ZHNvbg==?=	Microsoft Excel Programming	2	3rd Nov 2005 07:49 PM
How to calculate compound interest given table of dates/interest rate	Mike Deblis	Microsoft Excel New Users	1	4th Feb 2004 04:27 AM
How to calculate compound interest given table of dates/interest rate	Mike Deblis	Microsoft Excel Misc	1	4th Feb 2004 04:27 AM
Calculating compount interest from a table of dates/interest rates	Mike Deblis	Microsoft Excel Worksheet Functions	1	4th Feb 2004 04:07 AM