User Tools

Site Tools


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

PREFV(presentvalue,periods,rate,payment)

PREFV 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 then 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:

PREFV.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

prefv_future_value_with_prepayment_.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1