| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
| need help to achieve this calculation | Excel Discussion (Misc queries) | |||
| Increase group of numbers by same amount | Excel Worksheet Functions | |||
| In Excel how do I increase the amount in an entire column by a %? | Excel Discussion (Misc queries) | |||
| Amount of Increase of Wages | Excel Worksheet Functions | |||
Hybrid Mode
