Present Value of One Time Payment N Years in Future

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Will - 11 Jun 2007 05:23 GMT

How do you calculate the present value of a one time payment that is N years
in the future?

Signature

Will

Reply to this Message

joeu2004 - 11 Jun 2007 07:07 GMT

> How do you calculate the present value of a one time payment that is N years
> in the future?

Suppose the future value is $100,000 in 20 years. You need to know
the annual "rate" -- an interest rate, average growth rate, or a
discount rate. Suppose it is 5%. Then the present value is:

=pv(5%, 20, 0, -100000)

Reply to this Message

Murph - 11 Jun 2007 08:46 GMT

I am a newbee to 2007 and have lost the function of saving a *.dbf file back
to a compatible database structure. Is there a fix?

Reply to this Message

Roger Govier - 11 Jun 2007 16:49 GMT

Hi

It has been removed from XL2007, but not from Access2007.
Your only options would therefore appear to be to transfer to access if
you have it, or save in a 97-2003 compatibility mode, and pick it up in
XL2003 (if you still have it) and export from there to db format.

Signature

Regards

Roger Govier

>I am a newbee to 2007 and have lost the function of saving a *.dbf file
>back to a compatible database structure. Is there a fix?

Reply to this Message

Stan Brown - 16 Jun 2007 15:55 GMT

Sun, 10 Jun 2007 21:23:30 -0700 from Will <westes-
usc@noemail.nospam>:

> How do you calculate the present value of a one time payment that is N years
> in the future?

If A1 is the future value, A2 is the interest rate per year, and A3
is the number of years, then the present value is

= A1 / (1+A2) ^ A3

Caution: A2 must be a percernt, e.g. .05 or 5% and not plain 5.

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

Reply to this Message