Future Value formula

H

heater

I need a future value formula like this PV(1+r)n=FV. I am trying for this
outcome - 1,000,000(1+1.0)3=8,000,000.
 
J

joeu2004

heater said:
I need a future value formula like this PV(1+r)n=FV. I am
trying for this outcome - 1,000,000(1+1.0)3=8,000,000.
Click to expand...

The correct way to write that formula is:

=1000000*(1+1%)^3

Also, you can use the FV function, to wit:

=FV(1%, 3,, -1000000)

I ass-u-me you meant 1%, not "1.0", which is 100%. If did
indeed intend to write 100%, I suggest that you write "(1+100%)"
so that your intent is clear.
 
Top