Documentation/Calc Functions/PMT

Function name:
PMT

Category:
Financial Analysis

Summary:
Calculates the periodic payment for an annuity with constant interest rates.

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

Returns:
Returns a real number (in currency units) which is the payment made each period for investment with given parameters.

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.

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 NPer is 0 then the function returns an error value.
 * If Type is anything accept 0 or 1, then the function returns an error value.

Additional details:

 * PMT solves the following equation for Pmt:

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

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

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

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

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

ODF standard:
Section 6.12.36, part 2

Equivalent Excel functions:
PMT