Syntax
=IPMT(rate, per, nper, pv, [fv], [type])Arguments
| Argument | Required | Description |
|---|---|---|
rate | Required | The interest rate per period |
per | Required | The period, 1 to nper |
nper | Required | The number of payments |
pv | Required | The present value |
fv | Optional | The value left after the last payment |
type | Optional | 0 for payments at the end of each period, 1 at the start |
How to use IPMT
IPMT takes 4 required arguments and 2 optional arguments. Type =IPMT( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=IPMT(0.1/12, 1, 3*12, 8000)Result =IPMT(0.1, 3, 3, 8000)Result Related financial functions
- EFFECTReturns the effective annual interest rate from a nominal rate and the compounding periods per year.
- FVReturns the future value of an investment with constant payments and a constant rate.
- FVSCHEDULEReturns the future value of a principal after applying a series of interest rates.
- INTRATEReturns the interest rate of a fully invested security.
- IRRReturns the internal rate of return of cash flows at regular periods.
- ISPMTReturns the interest paid in one period of a loan with equal principal repayments.
- MDURATIONReturns the modified duration in years of a security that pays periodic interest, for 100 face value.
- MIRRReturns the modified internal rate of return, with separate rates for financing and reinvestment.
- NOMINALReturns the nominal annual interest rate from an effective rate and the compounding periods per year.