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.
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.
> I need a future value formula
=FV(100%,3,,-1000000)
(Returns 8,000,000)
--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003
"heater" <[email protected]> wrote in message
news:[email protected]...
>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.
heater wrote:
> 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.
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 ***-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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks