I'm looking for a formula that will replace a look up table. I have a base
amount of $250 that increases 5% with each event (compounded) such that the
first event is $250, second event is $512.50, then $788.13, etc. Is there a
financial (or other) function that would tell me the total amount of the xth
event?
--
Thanks,
Nick

Use the FV function: =-FV(5%,3,250) will tell you the value after the 3rd
event.

"Nick" wrote:

I'm looking for a formula that will replace a look up table. I have a base
amount of $250 that increases 5% with each event (compounded) such that the
first event is $250, second event is $512.50, then $788.13, etc. Is there a
financial (or other) function that would tell me the total amount of the xth
event?
--
Thanks,
Nick

This worked perfectly! So simple and elegant. I had tried the FV function
(and a bunch of others) but wasn't familiar with the -FV.

Thank you, Nick



"bpeltzer" wrote:

Use the FV function: =-FV(5%,3,250) will tell you the value after the 3rd
event.

"Nick" wrote:

I'm looking for a formula that will replace a look up table. I have a base
amount of $250 that increases 5% with each event (compounded) such that the
first event is $250, second event is $512.50, then $788.13, etc. Is there a
financial (or other) function that would tell me the total amount of the xth
event?
--
Thanks,
Nick

-FV isn't a separate function -- it means the negative of the result of the FV
function.

The sign is supposed to indicate the direction of the cash flow (eg, positive
values are money into your pocket and negative values are money out of your
pocket). Many people only want positive numbers, so they just insert a leading
negative sign, which converts FV's negative results into a positive.

--
Regards,
Fred


"Nick" wrote in message
...
This worked perfectly! So simple and elegant. I had tried the FV function
(and a bunch of others) but wasn't familiar with the -FV.

Thank you, Nick



"bpeltzer" wrote:

Use the FV function: =-FV(5%,3,250) will tell you the value after the 3rd
event.

"Nick" wrote:

I'm looking for a formula that will replace a look up table. I have a base
amount of $250 that increases 5% with each event (compounded) such that the
first event is $250, second event is $512.50, then $788.13, etc. Is there
a
financial (or other) function that would tell me the total amount of the
xth
event?
--
Thanks,
Nick