View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Solving for discount rate in present value calculation

Hello,

Is there a function, similar to 'rate' but for an uneven cash flow. I
have an uneven cash flow and am trying to work backwards to solve for
what discount rate would give me a particular present value? 'rate'
only works for an annuity?

thanks,
Scott