| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel equations...
What is the equation used in calculating interest compounded for a value
representing years? |
|
#2
|
|||
|
|||
|
Not sure this is exactly what you are seeking. This is the formula for
compound annual growth rate. =(EndValue/StartValue)^(1/3)-1 KS "thanatologist" wrote: What is the equation used in calculating interest compounded for a value representing years? |
|
#3
|
|||
|
|||
|
Most people would use the FV function to calculate the future value of the
amount. If you want just the interest, then subtract the present value from this result. -- Regards, Fred Please reply to newsgroup, not e-mail "thanatologist" wrote in message ... What is the equation used in calculating interest compounded for a value representing years? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I get a program error when I download an excel template | Excel Discussion (Misc queries) | |||
| html to excel | Excel Discussion (Misc queries) | |||
| Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
| Shortcut file fails to open | Excel Discussion (Misc queries) | |||
Linear Mode
