You probably need the XNPV() function. Check Help. If the function is not
available: ToolsAdd-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten

"PJF" wrote in message
.net...
I apologize for reposting this question but I may not have originally
stated
the problem adequately.

I have an application that makes a single payment 2 years after the
signing
of a contract. I need to calculate the PV of that payment asof the date
the
contract is signed based on the discount rate that includes the two years
during which no payments were made.

Example:

Contract signed 1/1/2005
no payments due 2005 or 2006
principal due in full 1/1/2007
discount rate 5%

Question: how do I calculate the discounted value of the principal from
1/1/2005 until principal payment due date on 1/1/2007, considering there
are
no payments due either in 2005 or 2006? I know what the PV is but can't
get
to it in Excel.

Any suggestions would be appreciated.

PJF