View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
catslgc catslgc is offline
external usenet poster
 
Posts: 1
Default How to calculate the present value of a security, $5000 @ 7%, 20y.

I'm trying to use excell to calculate the present value of a security that
will pay $5000.00 in 20 years at 7% interest. PV=FVn/(1+I)N