View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael Michael is offline
external usenet poster
 
Posts: 791
Default present value of a future amount

=PV(0.04/12,120,0,10000,1)
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"xrbbaker" wrote:

How do I find out the current value of a future amount? Let's assume 10
years from now somebody hands me $10,000. Assuming 4% inflation, how do I
determine how much that $10k is worth today? When I look at PV and NPV they
seem to want periodic payments which this doesn't have.

thanks