![]() |
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 |
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 |
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 |
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