Excel Function : PV

Download now!

Excel Function : PV




Returns the present value of an investment

Microsoft Excel Reference Page


Syntax and Description of the PV Excel Function

=PV(rate,nper,pmt,[fv],[type]) rate - the interest rate per period nper - the total number of payment periods in an annuity pmt - the payment made each period; it cannot change over the life of the annuity fv - the future value, or a cash balance you want to attain at the end of the last payment period type - when the payments are due: 0 - at the end of the period 1 - at the beginning of the period

About PV Excel Function

PV is a function in Excel that calculates the present value of a loan or investment, using a given interest rate and number of periods.