Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

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-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.