Framework:FKT IPMT

From CoPlanner 11
Jump to navigationJump to search

Function

FKT_IPMT(<amount of loan>,<date of borrowing>,<date of end of term>, <interest rate>, <reimbursement period>)

Parameter Description
Amount of loan Amount of loan or cash value of the monthly payments to be made by you.
Date of borrowing Date the loan is taken out; is also the date of the beginning of the repayment.
Date of end of term Date of last repayment and thus complete reimbursement of the loan.
Interest rate Interest rate p.a.
Period of reimbursement Date for which the interest portion is to be determined. The higher the date, the lower the interest portion, since the latter is always calculated on the basis of the remaining amount of the loan.

This function belongs to server-side functions.

Result

Returns a currency type which indicates the payment of interests for a determined period of time of an annuity in the case of regular, constant payments and a constant interest rate. Kursiver Text