PV


Definition of PV

Calculates the present value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

Sample Usage

PV(2,12,100)

PV(A2,B2,C2,D2,1)

Syntax

PV(rate, number_of_periods, payment_per_period, [future_value, end_or_beginning])

  • rate - The interest rate.

  • number_of_periods - The number of payments to be made.

  • payment_amount - The amount per period to be paid.

  • future_value - [ OPTIONAL ] - The future value remaining after the final payment has been made.

  • end_or_beginning - [ OPTIONAL - 0 by default ] - Whether payments are due at the end (0) or beginning (1) of each period.

Notes

  • Ensure that consistent units are used for ratenumber_of_periods, and payment_per_period. For example, a car loan for 36 months may be paid monthly, in which case the annual percentage rate should be divided by 12 and the number of payments is 36. On the other hand, a different type of loan of the same length might be paid quarterly, in which case the annual percentage rate should be divided by 4 and the number of payments would be 12.

See Also

PPMT: Calculates the payment on the principal of an investment based on constant-amount periodic payments and a constant interest rate.

PMT: Calculates the periodic payment for an annuity investment based on constant-amount periodic payments and a constant interest rate.

NPER: Calculates the number of payment periods for an investment based on constant-amount periodic payments and a constant interest rate.

IPMT: Calculates the payment on interest for an investment based on constant-amount periodic payments and a constant interest rate.

FVSCHEDULE: Calculates the future value of some principal based on a specified series of potentially varying interest rates.

FV: Calculates the future value of an annuity investment based on constant-amount periodic payments and a constant interest rate.

In order to use the PV formula, start with your edited Excellentable:

Screen Shot 2016-06-07 at 2.24.16 PM.png

Then type in the PV Formula in the area you would like to display the outcome:

Screen Shot 2016-06-07 at 2.24.47 PM.png

By adding the values you would like to calculate the PV formula for, Excellentable will generate the outcome:

Screen Shot 2016-06-07 at 2.25.02 PM.png