calculating the future value of an investment in excel
 

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

calculating the future value of an investment in excel
 

Look in HELP for the FV() function

--
Kind regards,

Niek Otten

"John C." wrote in message
...
How can i calculate the future value of an investment in excel?

calculating 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." wrote in message
...
How can i calculate the future value of an investment in excel?

calculating 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." wrote in message
...
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." wrote in message
...
How can i calculate the future value of an investment in excel?

calculating 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