Increase amount to achieve target

[Guest]

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

 

[Niek Otten]

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

|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

 

[Guest]

That's brilliant, thanks Niek

 

[David Biddulph]

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