In this example, the PV function returns the present value of an annuity given the expected annual percentage rate (APR), the total number of payments (TotPmts), the amount of each payment (YrIncome), the total future value of the investment (FVal), and a number that indicates whether each payment is made at the beginning or end of the payment period (PayType). Note that because YrIncome represents cash paid out from the annuity each year, it's a negative number.
PV([APR], [TotPmts], -[YrIncome], [FVal], [PayType])