Google Sheets-funktion

PV

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

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

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.

Argument

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

Exempel

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

Resultat: -10328.01

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

Vanliga frågor

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.

Relaterade funktioner

FV PMT RATE NPER