Navigation: Templates > Guide to all Templates > Additional Libraries and Templates > Finance Library >====== PREFV (future value with prepayment) ====== | |
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:
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