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

## Bookmarks