PV

  • Updated

Calculates the present value of an annuity investment based on a constant interest rate.

Sample Usage

PV(200,12,50)
PV(A2,B2,C2,D2,1)

 

Syntax

PV(rate, total_periods, payment_amount, [future_value], [type])

  • rate - The annualized rate of interest.
  • total_periods - The total number of payment periods.
  • payment_amount - The amount to be paid per period.
  • future_value - [OPTIONAL] The future value remaining after the final payment has been made.
  • type - [OPTIONAL] The due date type for the payment – at the beginning (0) or end of each period (1).

 

Examples

PV(200,12,50) returns -0.25, the present value of the annuity.

 

Notes

  • Ensure that consistent units are used for rate, total_periods and payment_amount.