PPMT
Returns the payment on the principal for an investment for a given period
Syntax
PPMT(rate, per, nper, pv, [fv], [type])
Parameters
- rate: Required. The interest rate per period
- per: Required. The period. Must be in the range 1 to nper
- nper: Required. The total number of payment periods
- pv: Required. The present value
- fv: Optional. The future value (default 0)
- type: Optional. When payments are due (0=end, 1=beginning)
Example
=PPMT(0.1/12, 1, 2*12, 2000)