PV

FinancialExcel 2007

The present value of a future sum or an annuity.

Syntax

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

Examples

=PV(8%/12, 240, -25000)

→ loan you could service with a ₹25k EMI

Related functions

FV PMT NPV

More Financial functions

ACCRINT ACCRINTM AMORDEGRC AMORLINC COUPDAYBS COUPDAYS COUPDAYSNC COUPNCD COUPNUM COUPPCD CUMIPMT CUMPRINC

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.