Focal Point
Compund Interest

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3611050112

February 02, 2007, 11:02 AM
moyer1dl
Compund Interest
Does any body have an example of how they incoporated a compound interest into web focus code?

Thanks

Dan


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7
February 02, 2007, 11:12 AM
FrankDutch
how would you calculate it in Excel?

can you give more info




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

February 02, 2007, 12:12 PM
Kerry
Hi Dan,

Is this the same question with previous topic:
https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/6071091012

If so, please review the info.

Thanks to Frank's suggestion as well. Big Grin

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
February 03, 2007, 06:06 AM
OPALTOSH
Compound interest is

T=p*(1+i/100)**n

Where P is the starting amount, i is the interest rate per period and n is the number of periods.
February 05, 2007, 10:58 AM
moyer1dl
This is the Compound interest equation Im am using.

Amount=P*(1+I/Q)^N*Q

The last post was related to finding a function that did it, since there was no function, I rephrased my question in a new post

Thanks All

Dan Moyer


IBM Main Frame: MVS, FIX, VSAM

Windows SQL

WF 7.7