• Mathematical and Financial Functions
  • ABS Function
  • AVERAGE Function
  • CGROUP Function
  • CGROUPT Function
  • COLCOUNT Function
  • COUNTIF function
  • EXP Function
  • FV Function
  • LOG Function
  • Mathematical and Financial Functions
  • MAX Function
  • MEDIAN Function
  • MIN Function
  • MKDEC Function
  • MKINT Function
  • MOD Function
  • POS Function
  • PV Function
  • R Function
  • RATIO Function
  • RC Function
  • RCNV Function
  • RCR Function
  • RCTOTAL Function
  • ROUND Function
  • ROWCOUNT Function
  • RR Function
  • RRTOTAL Function
  • STDDEV Function
  • SUM Function
  • TOTAL Function

FV Function

The FV function calculates the future value factor that you can use to determine the future worth of an investment.

Syntax

FV(number of periods,rate of interest)

Where rate of interest is expressed as a percentage and the number of periods can be monthly or yearly.

Example

FV(5,8)

Returns the value of $1 five years from now at a rate of interest of 8%.

Related Topics

• Mathematical and Financial Functions