header

PV Function

=PV(rate, nper, pmt, fv, type)

The periodic rate is in cell B6. The number of periods, nper, is in cell B8. The periodic payment, pmt, is in cell B3. Don't forget that this argument should be negative (-B3) since it represents an outflow. The future value, fv, is zero. The type is also zero because the payments are made at the end of the period. Here is the appropriate formula:

=PV(B6,B8,-B3,0,0)

Since the last two arguments are both zero (the default value), you can also write this as:

=PV(B6,B8,-B3)