FV Function in Google Sheets

Calculate the future value of an investment using the FV function.

FV Function

The FV function in Google Sheets calculates the future value of an investment based on periodic, constant payments and a constant interest rate.

Syntax

FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])
  • rate: The interest rate per period. This is a required parameter.
  • number_of_periods: The total number of payment periods. This is a required parameter.
  • payment_amount: The payment made each period. This is a required parameter.
  • present_value: (Optional) The present value, or the lump sum amount that a series of future payments is worth right now. If omitted, the default is 0.
  • end_or_beginning: (Optional) A value indicating when payments are due. Use 0 for payments at the end of the period (default), or 1 for payments at the beginning.

Examples

  1. Calculate Future Value

Calculate the future value of an investment with a 5% annual interest rate, over 10 years, with monthly payments of $100:

=FV(0.05/12, 10*12, -100)

This will output 15,528.46.

Notes

  • The FV function assumes consistent payments and a consistent interest rate.
  • If the payment_amount is an outflow (such as savings), it should be entered as a negative number.
  • PV: Calculate the present value of an investment.
  • NPV: Calculate the net present value of an investment.