Loading…
Loading…
PV returns the present value of regular payments.
=PV(rate, nper, pmt, [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. |
| pmt | Required | The payment made each period. Money you pay out is negative. |
| 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.