Framework:FKT IPMT: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 2: | Line 2: | ||
<span {{CoPFormel}}>FKT_IPMT(<amount of loan>,<date of borrowing>,<date of end of term>, <interest rate>, <reimbursement period>)</span> | <span {{CoPFormel}}>FKT_IPMT(<amount of loan>,<date of borrowing>,<date of end of term>, <interest rate>, <reimbursement period>)</span> | ||
{| class="wikitable" width="80%" | {| class="wikitable" width="80%" | ||
| Line 24: | Line 23: | ||
|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. | |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 [[:Category:Functions_-_server-side|server-side functions]]. | |||
==Result== | ==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. | 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. | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Functions|IPMT]] | |||
[[Category:Functions_-_server-side|IPMT]] | [[Category:Functions_-_server-side|IPMT]] | ||
[[de:Framework:FKT IPMT]] | [[de:Framework:FKT IPMT]] | ||
''Kursiver Text'' | ''Kursiver Text'' | ||
Latest revision as of 08:36, 24 May 2012
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
