Compound Interest Problem

[Andrew Mackenzie]

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.

[Mangesh Yadav]

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

Mangesh



"Andrew Mackenzie" <a_d_mackenzie@hotmail.com> wrote in message
news:OGi2zWCwFHA.4056@TK2MSFTNGP11.phx.gbl...
> 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.
>
>

[Myrna Larson]

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"
<a_d_mackenzie@hotmail.com> 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.
>