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)