Funzione di Google Sheets

PV

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

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

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

Esempi

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

Risultato: -10328.01

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

Domande frequenti

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.

Funzioni correlate

FV PMT RATE NPER