1000 in A1, 1400 in A2:

=RATE(52,,A1,-A2)

Make sure the column is wide enough to show enough decimals

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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