View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Increase amount to achieve target

=((1400/1000)^(1/52))-1
--
David Biddulph

"pkeegs" wrote in message
...
I want to increase an amount ($1,000) over a number of periods (52 weeks)
so
that it will achieve a 40% increase at the end to $1,400. I would like a
formula to see the increase for each period without using Goal Seek so
that I
can apply any starting amount or rate of increase to achieve an end term
target growth.

Regards