Our Formula Function Reference
Formula Function Reference
PV - Numbers
(Number rate, Number nskip, Number amt, Number npay)
Calculates the Present Value of a series of future payments. Rate is the discount rate for one time period. Nskip is the number of time periods before the first payment occurs. Amt is the amount of each payment. Npay is the number of payments in the series, spaced one time period apart.
PV(.10, 1, 100, 3) returns 248.69