PV(arg1, arg2, arg3, arg4, arg5) → { number | string | boolean }

Returns the present value of an investment: the total amount that a series of future payments is worth now.


Name Type Description
arg1 number

Is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% APR.

arg2 number

Is the total number of payment periods in an investment.

arg3 number

Is the payment made each period and cannot change over the life of the investment.

arg4 number

Is the future value, or a cash balance you want to attain after the last payment is made.

arg5 number

Is a logical value: payment at the beginning of the period = 1; payment at the end of the period = 0 or omitted.


number | string | boolean