View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Calgarychris Calgarychris is offline
external usenet poster
 
Posts: 10
Default Discounted Payback

Hi,

I've searched "payback" to find a good payback function and have read LSB
M's post regarding payback. Can you folks think of a way to incorporate
discounting? Basically my scenario is similar - I have 36 months where I
calculate profit and provide an NPV after 36 months. What I would like to
provide is the # of months until NPV = 0.

Thanks!