Present value of individual uneven payments

[Z Man]

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!

 

[Fred Smith]

I don't see the problem. Just calculate the PV of each payment. Using a discount
rate of 10% and a start date of 1/1/07, the formula is:

=PV(10%,(a2-date(7,1,1))/365,0,-b2)

Copy down as far as you want.