FV

  • Updated

Calculates the future value of an annuity investment based on a constant interest rate.

 

Sample Usage

FV(0.01,12,-1000)
FV(A2,B2,C2,D2,1)

 

Syntax

FV(rate, total_periods, payment_amount, [future_value], [type])

  • rate - The annualized rate of interest.
  • total_periods - The total number of payment periods.
  • payment_amount - The amount to be paid per period.
  • present_value - [OPTIONAL] The present value of the annuity.
  • type - [OPTIONAL] The due date type for the payment – at the beginning (0) or end of each period (1).

 

Examples

FV(0.01,12,-1000) returns the value: 12682.5

Notes

  • Ensure that consistent units are used for rate, total_periods and payment_amount.