calculating the future value of an investment in excel

G

Guest

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
 
N

Niek Otten

=A1*(1+C1)^B1

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

jermsalerms

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IRR function in Excel 2010 returns #NUM! error for an investment withall negative cash flows 7
Calculating Future Value 6
How do I calculate a payment? 7
Future value plus annual contributions 3
calculating future value of one initial investment 2
FV formula 3
Future Value of Investment 2
Investing,Mutual Funds Formula? 18

Top