Syntax
=PPMT(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 PPMT
PPMT takes 4 required arguments and 2 optional arguments. Type =PPMT( 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.
=PPMT(0.1/12, 1, 2*12, 2000)Result =PPMT(0.08, 10, 10, 200000)Result Related financial functions
- ODDLPRICEReturns the price per 100 face value of a security with an odd (short or long) last period.
- ODDLYIELDReturns the yield of a security with an odd (short or long) last period.
- PDURATIONReturns the number of periods an investment needs to grow to a target value at a constant rate.
- PMTReturns the payment per period of a loan or investment with a constant rate and constant payments.
- PRICEReturns the price per 100 face value of a security that pays periodic interest.
- PRICEDISCReturns the price per 100 face value of a discounted security.
- PRICEMATReturns the price per 100 face value of a security that pays interest at maturity.
- PVReturns the present value of a series of equal future payments.
- RATEReturns the interest rate per period of a loan or investment, found by iteration.