Excel PV function

Function: PV

Description: Excel PV function, one of the financial functions, calculates the present value of a loan or an investment, based on a constant interest rate. You can use PV with either periodic, constant payments (such as a mortgage or other loan), or a future value that’s your investment goal.

The syntax for the PV function is as follows:

Syntax: PV(rate, nper, pmt, [fv], [type])

Where:

  • rate: The interest rate per period.
  • nper: The total number of periods over which the investment is made.
  • pmt: The periodic payment made each period. This value can be negative or positive, depending on whether the payment is an inflow or outflow of cash.
  • [fv]: Optional. The future value, or the balance remaining after the final payment is made. If this value is not specified, it is assumed to be 0 (zero).
  • [type]: Optional. A logical value that indicates when the payments are due. If this value is omitted or set to 0 (zero), payments are due at the end of the period. If this value is set to 1, payments are due at the beginning of the period.

Examples:

To calculate the present value of an investment that will pay $100 per year for 10 years at an annual interest rate of 6%, you can use the following formula:

=PV(6%/1, 10, -100, 0, 0)