Loading…
Loading…
PMT returns the payment for a loan with constant payments and rate.
=PMT(rate, nper, pv, [fv], [type])
| Argument | Required? | What it is |
|---|---|---|
| rate | Required | The interest rate per period. For monthly payments, divide the annual rate by 12. |
| nper | Required | The total number of payment periods, such as 360 for 30 years of monthly payments. |
| pv | Required | Present value: the amount now, such as the loan amount. |
| fv | Optional | Future value: the balance you want left after the last payment. Usually 0. |
| type | Optional | When payments are made: 0 (or left out) at the end of each period, 1 at the start. |
Type the formula yourself and get it graded instantly, no Excel needed.