This should be easy (and can be done easily but tediously on an HP12C) but I
cannot figure out how to do it in Excel 2003. I have dozens of uneven
payments to be received monthly over the next few years, and I need the
present value of each payment, so that I can add them all up and come up
with the total. It is essential that I get the PV of each individual
payment. For example.

Date Payment PV

2/1/07 1,000 ??
3/1/07 2,000 ??
4/1/07 1,250 ??
5/1/07 22,352 ??
6/1/07 0 ??
7/1/07 2,715 ??
(assume a couple of hundred more uneven montly payments)

How can I perform this calculation (I need to solve for the various ??'s) in
Microsoft Excel 2003? (NOTE: the payments are evenly spaced, and interest
rate will not change)

Thanks!