What is the present value of $115,292 to be paid in six years discounted at 11.5% compounded annually?

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

The future value – FV – is $115,292

The interest rate – Rate – is 11.5%

The number of periods – NPER – is 6

The unknown – present value – PV is determined by

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

The function wizard pops up

Select FV,

Select Rate,

Select NPER

Hit OK

The present value is $60,000