(PV1(pmt,int,per))
Returns the present value of a series of equal payments of the amount, pmt, periodic interest rate, int, and compounding periods, per.
In the following example, PV1 returns the present value of an annuity with an annual interest rate of 9% and for which you want to pay $500 each month for 20 years. The value of vpv1 (the present value) is $55,572.48.
SET VAR vpv1 = (PV1(500,.0075,240))