Increase amount to achieve target

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top