User Tools

Site Tools


fv_future_value_.htm
Navigation:  Templates > Guide to all Templates > Additional Libraries and Templates > Finance Library >====== FV (future value) ====== Previous pageReturn to chapter overviewNext page

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:

FV.jpg

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

fv_future_value_.htm.txt · Last modified: 2021/04/15 15:57 (external edit)