Excel Function : PV

Download now!

Excel Function : PV

Category

Financial

Description

Returns the present value of an investment

Microsoft Excel Reference Page

https://support.office.com/en-us/article/PV-function-23879d31-0e02-4321-be01-da16e8168cbd

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.