Related Topics:

Spreadsheet Math Functions

Formulas Tab and Insert Function

Data Entry Tips for Functions

Function Wizard

FV

Description: Returns the future value based on periodic, constant payments and constant interest rate.

Syntax: FV(Rate, Nper, Pmt, [PV], [Type])

Set type equal to If payments are due
0 or omitted

At the end of the period

1

At the beginning of the period

Remarks:

Example:

FV(.06/12, 10, -200, -500, 1) = 2581.40

 

© 1992-2016. ReliaSoft Corporation. ALL RIGHTS RESERVED.

E-mail Link