compound capital interest

[wolverinec7]

Is it possible either by a formula or a function to work out compound capital interest within a crystal report?

 

[pgtek]

hi
can you give more deatil?
what version of crystal and so on

pgtek

 

[pgtek]

hi
check this out

http://www.unb.ca/web/jhsc/TME_courses/FIN320_content/Interest/interest-06.htm

cheers
pg

pgtek

 

[pgtek]

hi
check this one also

http://tfsfrd.tamu.edu/tdss/Basic/cid.htm

cheers

pgtek

 

[wolverinec7]

thanks for the reply, basically i have a form designed in crysal 8.5 that produces a letter based on debt owed to our company. if its the 31/12 and a customer has had an invoice for £10 every 1st of the month and they haven't paid us we are allowed to charge interest @ X% per day on the total amount i.e. on the first invoice we can charge x % on £10 for 31 days (jan)until the next invoice is due, then we can charge x% for 28 days(feb)on £20 until the next invoice is due and so on.its not quite compound capital interest but i don't think its far off....any ideas?

cheers

 

[AlohaMichael]

I do the same thing for AR Statements to customers.

One variable in the report header looks like this:

shared numbervar ar_intrate;
ar_intrate := 0.12;

second variable in the detail section looks like this:
shared numbervar ar_intrate;
shared numbervar int30;

if {JrnlHdr.MainAmount} - {JrnlHdr.AmountPaid} > 1 and
{JrnlHdr.TransactionDate}+30 <{?par_ReportDate} then
int30 := ACCRINTM({JrnlHdr.TransactionDate}+30,{?par_ReportDate},ar_intrate,{JrnlHdr.MainAmount}-{JrnlHdr.AmountPaid},1)
else
int30 := 0;

Simply if the MainAmount - CustomerPayments > 1 &
the InvoiceDate is more then 30 days old
THEN
int30 := Interest Amount
or
int30 := 0

so in essence I think you need to use the ACCRINTM formula

I share the int30 because I set up columns to show how much interest is being charged on different invoices and total them later.