FV - script and chart function

This function returns the future value of an investment based on periodic, constant payments and a simple annual interest.

Syntax:  

FV(rate, nper, pmt [ ,pv [ , type ] ])

Return data type: numeric. The result has a default number format of money. .

Arguments:  

Argument Description
rate The interest rate per period.
nper The total number of payment periods in an annuity.

pmt

The payment made each period. It cannot change over the life of the annuity. A payment is stated as a negative number, for example, -20.

pv

The present value, or lump-sum amount, that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero).

type

Should be 0 if payments are due at the end of the period and 1 if payments are due at the beginning of the period. If type is omitted, it is assumed to be 0.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?