Framework:FKT PPMT: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
Created page with '==Function== Gibt einen Wert vom Typ Währung zurück, der die Tilgungszahlung für einen bestimmten Zeitraum einer Annuität bei regelmäßigen, konstanten Zahlungen und einem …' |
No edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Function== | ==[[Framework:Formulae#Functions|Function]]== | ||
<span {{CoPFormel}}>FKT_PPMT(<amount of loan>,<date of borrowing>,<date of end of term>, <interest rate>, <period of reimbursement>) </span> | |||
{| class="wikitable" width="80%" | |||
|- {{Tabellentitel}} | |||
| Parameter | |||
{| | | Description | ||
|- | |||
| | |||
| | |||
|- | |- | ||
|Amount of loan | |Amount of loan | ||
| Line 26: | Line 23: | ||
|Date for which the repayment portion is to be determined. The higher this date, the higher the repayment portion since the interest portion is always calculated on the basis of the outstanding amount of the loan and such amount decreases over the period of time. | |Date for which the repayment portion is to be determined. The higher this date, the higher the repayment portion since the interest portion is always calculated on the basis of the outstanding amount of the loan and such amount decreases over the period of time. | ||
|} | |} | ||
This function belongs to [[:Category:Functions_-_server-side|server-side functions]]. | |||
==Result== | |||
Returns a currency value which indicates the repayment for a specific period of time of an annuity in the case of regular, constant payments and a constant interest rate. | |||
==Sample== | |||
<span {{CoPFormel}}>FKT_PPmt( [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Darlehenshöhe] , [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Zeit_1.Datum] , [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Zeit_2.Datum] , [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Zinssatz] , [Darlehen_PLAN.Zeit_1.Datum] ) </span> | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category: | [[Category:Functions|PPMT]] | ||
[[Category:Functions_-_server-side|PPMT]] | |||
[[de:Framework:FKT PPMT]] | [[de:Framework:FKT PPMT]] | ||
Latest revision as of 14:37, 22 October 2013
Function
FKT_PPMT(<amount of loan>,<date of borrowing>,<date of end of term>, <interest rate>, <period of reimbursement>)
| 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 was taken out – is also the date of the start of repayment. |
| Date of end of term | Date of the last repayment and thus complete reimbursement of the loan. |
| Interest rate | Iinterest rate p.a. |
| Period of reimbursement | Date for which the repayment portion is to be determined. The higher this date, the higher the repayment portion since the interest portion is always calculated on the basis of the outstanding amount of the loan and such amount decreases over the period of time. |
This function belongs to server-side functions.
Result
Returns a currency value which indicates the repayment for a specific period of time of an annuity in the case of regular, constant payments and a constant interest rate.
Sample
FKT_PPmt( [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Darlehenshöhe] , [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Zeit_1.Datum] , [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Zeit_2.Datum] , [Darlehen_PLAN.Darlehen_Stammdaten_PLAN_1.Zinssatz] , [Darlehen_PLAN.Zeit_1.Datum] )
