FV

Scripting Formulas Finance

FINANCE.FV

FINANCE.FV(rate, periods, payment, present_value = 0, end_or_start = 0)

Calculates the future value of an investment with period constant payments and a constant interest rate.

  • rate: Interest rate per period.
  • periods: Total number of period payments.
  • payment: Payment made per period, entered as a negative number.
  • present_value: Present value of future payments, entered as a negative number.
  • end_or_beginning: Whether payments are due at the end (0) or the beginning (1) of each period.