| **Navigation:**  [[templates.htm|Templates]] > Guide to all Templates > [[additional libraries and templates.htm|Additional Libraries and Templates]] > Finance Library >====== PREFV (future value with prepayment) ====== | [[prepmt  payment of annuity with prepayment .htm|{{btn_prev_n.gif|Previous page}}]][[additional libraries and templates.htm|{{btn_home_n.gif|Return to chapter overview}}]][[prepers  periods of annuity with prepayment .htm|{{btn_next_n.gif|Next 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|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**