Compound interest percentage

[brianjohnlee]

Given the amount originally invested, the amount when the investment is cashed and the duration of the investment how does one calculate the annual compound interest percentage?

[seckert]

There are several financial functions tailored to different types of investments, but if this is a simple case of money out today and money in at some time in the future, the formula for the annual rate compounded monthly is:

Please Login or Register  to view this content.

or you can use the Rate() function

Please Login or Register  to view this content.

Hope this helps

SAE

[brianjohnlee]

SECKERT Many thanks, I've tried them both with success!BRIANJOHNLEE