PMT
Returns the periodic payment for an annuity
Syntax
PMT(rate, nper, pv, [fv], [type])
Parameters
- rate: Required. The interest rate for the loan
- nper: Required. The total number of payments for the loan
- pv: Required. The present value, or the total amount that a series of future payments is worth now
- fv: Optional. The future value (default 0)
- type: Optional. When payments are due (0=end, 1=beginning)
Example
=PMT(0.08/12, 10, 10000)