View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default monthy payout on an annuity

On Fri, 18 May 2007 11:14:01 -0700, pallison
wrote:

I'm trying to calculate the monthly payment I would receive on a one time
contribution, fixed growth rate over a fixed period. Darned if I can find an
excel function/formula for it.


Use the PMT function
--ron