Functions
FV
Future value
Try it
When to use it
When should I use FV instead of PV?
Use FV to find the future value of an investment after a series of payments; use PV to find what those future cash flows are worth today.
Use cases
Grow a lump sum at an annual rate
Project a retirement balance from monthly contributions
Used in
finance · personal-finance · real-estate
Syntax
FV(rate, nper, pmt)Examples
=FV(2,12,100,400) // => -239148400
=FV(2,12,100,400,1) // => -292292400