PV Function in Excel: Syntax, Examples and Free Practice
PV is an Excel Financial function. Calculates the present value of a series of future payments.
PV syntax
Arguments
rate: The interest rate per periodnper: The total number of payment periodspmt: The fixed payment made each periodfv: The future value of the amount (optional)type: Whether payments are due at the start or end of a period (optional)
When to use PV
PV is used in loan, investment, or valuation models where precise financial math is required.
Practice PV online, free
Open the live Excel-style spreadsheet and try PV yourself. No Excel install or sign-up needed to start.
Practice PV now →More Financial functions
Frequently asked questions
What does the PV function do in Excel?
Calculates the present value of a series of future payments.
What is the syntax of PV in Excel?
The syntax is =PV(rate, nper, pmt, [fv], [type]). rate: The interest rate per period; nper: The total number of payment periods; pmt: The fixed payment made each period; fv: The future value of the amount (optional); type: Whether payments are due at the start or end of a period (optional).
Where can I practice PV online for free?
Open the free live spreadsheet on Cellgrids and try PV yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Financial functions · Excel case studies · Excel tutorials · Excel shortcuts