pvfix (Financial Toolbox)

Present value with fixed periodic payments

Syntax

PresentVal = pvfix(Rate, NumPeriods, Payment, ExtraPayment, Due)

Arguments

rate
Periodic interest rate, as a decimal fraction.

NumPeriods
Number of periods.

Payment
Periodic payment.

ExtraPayment
(Optional) Payment received other than Payment in the last period. Default = 0.

Due
(Optional) When payments are due or made: 0 = end of period (default), or 1 = beginning of period.

`rate`	Periodic interest rate, as a decimal fraction.
`NumPeriods`	Number of periods.
`Payment`	Periodic payment.
`ExtraPayment`	(Optional) Payment received other than `Payment` in the last period. Default = 0.
`Due`	(Optional) When payments are due or made: 0 = end of period (default), or 1 = beginning of period.

Description

PresentVal = pvfix(Rate, NumPeriods, Payment, ExtraPayment, Due) returns the present value of a series of equal payments.

Examples

$200 is paid monthly into a savings account earning 6%. The payments are made at the end of the month for five years. To find the present value of these payments

PresentVal = pvfix(0.06/12, 5*12, 200, 0, 0)

returns

```
PresentVal =

             10345.11
```

See Also

fvfix, fvvar, payper, pvvar

prtbill pvvar