IPMT
Returns the interest payment for an investment for a given period
Syntax
IPMT(rate, per, nper, pv, [fv], [type])
Parameters
- rate: Required. The interest rate per period
- per: Required. The period for which you want to find the interest
- 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
=IPMT(0.1/12, 1, 3*12, 8000)