This is a present value of an annuity problem.

What is the present value of rental receipts of $7,000 to be received at the end of each of the next 6 years when discounted at 11.5%?

First, plug in the known values into the appropriate cells:

The number of periods – NPER – is 6

The interest rate – Rate – is 11.5%

The payment – PMT – is $7,000.00

Going to the formulas tab, look for the PV function.

The function wizard pops up

Select Rate,

Select NPER,

Select PMT

Hit OK

The PV is ($29,192)