PMT
Description
Returns the payment required to pay off a loan or investment, based on a constant interest rate and for a specified period.
Syntax
PMT(
rate
,
nper
,
pv
, [
fv
], [
type
])
- rate: The interest rate for each period.
- nper: The total number of periods for the loan or investment.
- pv: The present value.
- fv: The future value.
- type: The payment timing. 0 or Empty = the payment occurs at the end of the period; 1 = the payment occurs at the beginning of the period.