Present value with fixed periodic payments
Calculate the Present Value of a Series of Equal 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
Payment in 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.