| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to calculate a value with a percentage growth over 22 years
i need formula for excel
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to calculate a value with a percentage growth over 22 years
Try this
=FV(0.05, 22, 0,-1000) Where 0.05 is the intereset rate 22 is the number of years 1000 is the starting capital (Note the minus sign) Mike "mike" wrote: i need formula for excel |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to calculate a value with a percentage growth over 22 years
If your growth rate is in cell A3 and it is compounded annually, and the
original value is in A2, the answer is =A2*(1+A3)^22 Next time, please remember to ask your question in the body of the message, not in the subject line. -- David Biddulph "mike" wrote in message ... i need formula for excel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need formula to figure out percentage of change for 5 years | Excel Discussion (Misc queries) | |||
| How can I calculate trend growth rates in Excel? | Excel Discussion (Misc queries) | |||
| determine percentage of growth | Excel Discussion (Misc queries) | |||
| What formula do I use to calculate compound annual growth rate (C. | Excel Discussion (Misc queries) | |||
| percentage of growth | Excel Worksheet Functions | |||
Linear Mode
