FV Function in Excel: Syntax, Examples and Free Practice
FV is an Excel Financial function. Calculates the future value of an investment based on regular payments.
FV syntax
Arguments
rate: The interest rate per periodnper: The total number of payment periodspmt: The fixed payment made each periodpv: The present value of the amount (optional)type: Whether payments are due at the start or end of a period (optional)
When to use FV
FV is used in loan, investment, or valuation models where precise financial math is required.
Practice FV online, free
Open the live Excel-style spreadsheet and try FV yourself. No Excel install or sign-up needed to start.
Practice FV now →More Financial functions
Frequently asked questions
What does the FV function do in Excel?
Calculates the future value of an investment based on regular payments.
What is the syntax of FV in Excel?
The syntax is =FV(rate, nper, pmt, [pv], [type]). rate: The interest rate per period; nper: The total number of payment periods; pmt: The fixed payment made each period; pv: The present value of the amount (optional); type: Whether payments are due at the start or end of a period (optional).
Where can I practice FV online for free?
Open the free live spreadsheet on Cellgrids and try FV 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