Present value with fixed periodic payments
This example shows how to return the present value of a series of equal payments, where $200 is paid monthly into a savings account earning 6%. The payments are made at the end of the month for five years.
PresentVal = pvfix(0.06/12, 5*12, 200, 0, 0)
PresentVal = 1.0345e+04
Rate— Periodic interest rate
Periodic interest rate, specified as a decimal.
NumPeriods— Number of periods
Number of periods, specified as an integer.
Payment— Periodic payment
Periodic payment., specified as a numeric.
ExtraPayment— Payment received other than
Paymentin the last period
0(default) | numeric
(Optional) Payment received other than
Payment in the
last period, specified as a numeric.
Due— Indicator for when payments are due
0(default) | logical with value of
(Optional) Indicator for when payments are due, specified as a logical
with a value of
0 = end of period (default), or
1 = beginning of period.
PresentVal— Present value
Present value, returned as a series of equal payments.