ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Increase amount to achieve target (https://www.excelbanter.com/excel-worksheet-functions/165042-increase-amount-achieve-target.html)

pkeegs

Increase amount to achieve target
 
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

Increase amount to achieve target
 
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



pkeegs

Increase amount to achieve target
 
That's brilliant, thanks Niek

"Niek Otten" wrote:

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




David Biddulph[_2_]

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





All times are GMT +1. The time now is 05:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com