ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel equations... (https://www.excelbanter.com/excel-discussion-misc-queries/19145-excel-equations.html)

thanatologist

Excel equations...
 
What is the equation used in calculating interest compounded for a value
representing years?

KemS

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?


Fred Smith

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?





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

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