Framework:FKT Tilgung
From CoPlanner 11
Jump to navigationJump to search
Function
FKT_Tilgung(<amount of loan>,<date of borrowing>,<date of end of term>, <start of repayment>,<periodicity>,<repayment>,<date of reimbursement>)
| Parameter | Description |
| Amount of loan | Value of loan. If the money is borrowed within the planning horizon, the borrowed amount must be used. If the date of borrowing is before the planning period, the value of the loan as per the start of the plan period must be entered. |
| Date of borrowing | Month in which the loan was taken out (date field) |
| Date of end of term | Month in which the term ends |
| Start of repayment | In the event of a continuous repayment loan, such start must be entered. Normally, this is the same as the date of borrowing, but it may also be a month after the month in which the loan was taken out. Repayments will be calculated only as of that month. |
| Periodicity | Number of repayments per year. It is possible to enter monthly (12), quarterly (4), half-yearly (2), yearly (1). |
| Repayment | Permitted values are “payable in advance” and “payable in arrears”. Normally, the “Loan_Repayment” lookup table will be used. |
| Date_Reimbursement | Month for which the amount of the repayment is to be calculated. |
This function belongs to server-side functions.
