Documentation/Calc Functions/PPMT

Function name:
PPMT

Category:
Financial Analysis

Summary:
Calculate the payment for a given period on the principal for an investment at a given interest rate and constant payments.

Syntax:
PPMT(Rate; Period; NPer; PV[; FV]; [Type]])

Returns:
Returns a real number which is the payment, for a given period, on the principal for an investment that is based on periodic and constant payments and a constant interest rate.

Arguments:
Rate is a real number (expressed as a percentage or fraction) or a reference to the cell containing that number which is the periodic interest rate.

Period is a positive whole number or a reference to the cell containing that number which is the period, for which the compound interest is calculated. Period=Nper if compound interest for the last period is calculated. It must be greater than or equal to 1.

NPer is a real number or a reference to the cell containing that number which is the number of periods in which annuity is paid.

PV is a real number or a reference to the cell containing that number which is the present cash value in a sequence of payments.

FV is a real number or a reference to the cell containing that number which is the desired value (future value) at the end of the periods. If it is omitted, then the function uses 0.

Type is the due date of the payment at the beginning or end of each period. If it is omitted, then the function uses 0.


 * If Period is not a positive whole number then the function returns an error vaue.
 * If Period is greater than NPer then the function returns an error value.
 * If Type is anything accept 0 or 1, then the function returns an error value.

Additional details:
None

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/IPMT IPMT]

[[Special:MyLanguage/Documentation/Calc_Functions/PMT PMT]

ODF standard:
Section 6.12.37, part 2

Equivalent Excel functions:
PPMT