Compound Interest Problem
 

Can anyone tell me if there is an Excel function to calculate the future
value of an initial principal amount after adding compound interest. E.g a
function that does the following

P x (1+i%)^n

Although the formula is straightforward my client, for reasons I do not
understand, wants a specific Excel function.

Any help much appreciated.

Andrew.

=FV(i, n, 0, -P)

Mangesh



"Andrew Mackenzie" wrote in message
...
Can anyone tell me if there is an Excel function to calculate the future
value of an initial principal amount after adding compound interest. E.g
a
function that does the following

P x (1+i%)^n

Although the formula is straightforward my client, for reasons I do not
understand, wants a specific Excel function.

Any help much appreciated.

Andrew.

Yes, there is, and strangely enough <g it's called Future Value or FV. Check
it out in Help.

On Fri, 23 Sep 2005 10:57:35 +0100, "Andrew Mackenzie"
wrote:

Can anyone tell me if there is an Excel function to calculate the future
value of an initial principal amount after adding compound interest. E.g a
function that does the following

P x (1+i%)^n

Although the formula is straightforward my client, for reasons I do not
understand, wants a specific Excel function.

Any help much appreciated.

Andrew.