Livecycle

PV

Returns the present value of an investment of periodic constant payments at a constant interest rate.

Note:

Interest rate calculation methods differ from country to country. This function calculates an interest rate based on U.S. interest rate standards.

Syntax

PV(n1, n2, n3)

Parameters

 

Parameter	Description
n1	A numeric value or expression representing the payment amount.
n2	A numeric value or expression representing the interest per period of the investment.
n3	A numeric value or expression representing the total number of payment periods.

The function returns an error if either n1 or n3 is negative or 0. If any parameter is null, the function returns null.

Note:

FormCalc follows the IEEE-754 international standard when handling floating point numeric values. For more information, see “Number literals”.

Examples

The following expressions are examples of using the PV function:

 

Expression	Returns
PV(400, 0.10 / 12, 30 * 12)	45580.32799074439. This is the value after 30 years, of a $400 a month investment growing at 10% annually.
PV(1000, 0.075 / 4, 10 * 4)	58791.96145535981. This is the value after ten years of a $1000 a month investment growing at 7.5% a quarter.
PV(Payment[0], Int_Rate / 4, Time)	This example uses variables in place of actual numeric values or expressions.

PV