Google Sheets-functie

PV

Calculates the present value of a loan or an investment based on a constant interest rate.

Formule genereren met AI Dezelfde functie in Excel

Deze functie werkt in Google Spreadsheets hetzelfde als in Excel — dezelfde syntaxis en argumenten.

Syntaxis

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

The PV function determines the current worth of a series of future payments. It is commonly used to evaluate the value of an annuity or to determine how much a loan is worth today given future repayment terms.

Argumenten

ratevereistThe interest rate per period.
npervereistThe total number of payment periods in an annuity.
pmtvereistThe payment made each period; it cannot change over the life of the annuity.
fvoptioneelThe future value or a cash balance you want to attain after the last payment is made.
typeoptioneelThe number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

Voorbeelden

=PV(0.05/12, 12*5, 200)

Resultaat: -10328.01

Calculates the present value of a 5-year loan with a 5% annual interest rate and $200 monthly payments.

Veelgestelde vragen

Why is the result of the PV function negative?

Excel follows cash flow conventions; since payments are money leaving your pocket, they are represented as negative values.

Gerelateerde functies

FV PMT RATE NPER