Is there any funtions for computing Compound Interest in Web Focus 7.1.1


Dan

compound interest;;;
Not that I'm aware of, but you could do a compute by converting the compound interest formula to an equation in WebFOCUS.

Hi Dan,

Just checked with our internal people and I was told that we don't have a user function for Compound Interest. Many thanks for Leah's input on this one.

You may code the calculation for compound interest just like any other calculation and do it in a define or a compute. Can you please provide the formula for compound interest? Then we can start working from there.

Hope this helps.

Cheers,

Kerry

dan, pretty easy
use ** for exponentiation
1.05**6 would give you the result after 6 years of a 5% apr.
and should you need to back out an annual rate , use **(1/n) which will give you the nth root. There is a SQRT function, but i can't see every using it, when **(1/n) works with n=2
-s.
needless to add, you aren't restricted to integers, of course.

This message has been edited. Last edited by: susannah,

Thanks All I thing some of this info will help

Dan