FV (future value)

Top  Previous  Next

 

FV(presentvalue,periods,rate,payment)

 

FV

Computes the future value of an investment plus an income stream.

presentvalue

A numeric constant or variable containing the present value of the investment.

periods

A numeric constant or variable containing the number of periods in which a cash flow occurred.

rate

A numeric constant or variable containing the periodic interest rate.

payment

A numeric constant or variable containing the periodic payment.

 

FV and PREFV determine the future value of an initial amount (presentvalue) plus an income stream. The income stream is defined as the total number of periods (periods), the periodic interest rate (rate), and a payment amount (payment). If payments occur at the beginning of each period, use the PREFV function, which takes into account the added interest earned on each period's payment.

Periodic rate may be calculated as follows:

PeriodicRate = AnnualInterestRate / (PeriodsPerYear * 100)

 

Return Data Type:     DECIMAL

 

Internal Formulas:

where int(periods) is the integer portion of the periods parameter.

Example:

 

PeriodicRate = AnnualRate / (PeriodsPerYear * 100)

IF TimeOfPayment = 'Beginning of Periods'

FutureValue = PREFV(PresentValue,TotalPeriods,PeriodicRate,Payment)

ELSE

FutureValue = FV(PresentValue,TotalPeriods,PeriodicRate,Payment)

END