# PV - script and chart function

This function returns the present value of an investment.

PV(rate, nper, pmt [ ,fv [ , type ] ])

Return data type: numeric. The result has a default number format of money. .

The present value is the total amount that a series of future payments is worth right now. For example, when borrowing money, the loan amount is the present value to the lender.

Arguments:

PV arguments

| Argument | Description |
| --- | --- |
| rate | The interest rate per<br>period. |
| nper | The total number of<br>payment periods in an annuity. |
| pmt | The payment made each<br>period. It cannot change over the life of the annuity. A payment is stated as a negative number, for example, -20. |
| fv | The future value, or<br>cash balance, you want to attain after the last payment is made. If fv is omitted, it is assumed to be<br>0. |
| type | Should be 0 if payments<br>are due at the end of the period and 1 if payments are due at the beginning<br>of the period. If type is omitted,<br>it is assumed to be 0. |

Examples and results:

Examples and results

| Example | Result |
| --- | --- |
| What is the present value of a debt, when you have to pay $100 at the end of each month during a five-year period, given an interest<br>rate of 7%?<br><br>`PV(0.07/12,12*5,-100,0,0)` | Returns $5,050.20 |