How can i calculate the future value of an investment in excel?

Look in HELP for the FV() function

--
Kind regards,

Niek Otten

"John C." <(E-Mail Removed)> wrote in message
news:FA02F0A7-6903-48A9-9756-(E-Mail Removed)...
> How can i calculate the future value of an investment in excel?

This function works for a future value of payments. I simply have an amount
and I want to calculate the future value with interest compounded.

ljc

"Niek Otten" wrote:

> Look in HELP for the FV() function
>
> --
> Kind regards,
>
> Niek Otten
>
> "John C." <(E-Mail Removed)> wrote in message
> news:FA02F0A7-6903-48A9-9756-(E-Mail Removed)...
> > How can i calculate the future value of an investment in excel?
>
>
>

=A1*(1+C1)^B1

A1 is investment, B1 is number of periods, C1 is intrest percentage (as a
fraction, so 0.05 or 5%)

--
Kind regards,

Niek Otten

"John C." <(E-Mail Removed)> wrote in message
news:7D205E8E-D0B9-4653-B31F-(E-Mail Removed)...
> This function works for a future value of payments. I simply have an
> amount
> and I want to calculate the future value with interest compounded.
>
> ljc
>
> "Niek Otten" wrote:
>
>> Look in HELP for the FV() function
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "John C." <(E-Mail Removed)> wrote in message
>> news:FA02F0A7-6903-48A9-9756-(E-Mail Removed)...
>> > How can i calculate the future value of an investment in excel?
>>
>>
>>

Cell A1 = $1000.00 (Current Value)
Cell A2 = 20 (Years)
Cell A3 = 8% (Appreciation Rate)
Cell A4 = A1*(1+A3)^A2 (Future Value)

Cell A4 result is $4660.95


--
jermsalerms
------------------------------------------------------------------------
jermsalerms's Profile: http://www.excelforum.com/member.php...o&userid=30167
View this thread: http://www.excelforum.com/showthread...hreadid=516317