PRESENT VALUE Function

The PRESENT VALUE function calculates the present value of a loan or an investment, based on a constant interest rate.

If you know the rate, term, payment, future value and type of a savings scheme or loan you can use the PRESENT VALUE function to work out how much the investment is worth currently (i.e. how much money you need to invest over the same amount of payment periods to equal the return)

Function name

PRESENT VALUE

Usage model   PRESENT VALUE ( rate:NUM, term:NUM, payment:NUM, future value:NUM, type:NUM )
Parameters This function requires you to replace three of five parameters (two are optional):

rate: NUM

The function uses this value as the interest rate per payment period.

term: NUM

The function uses this value as the total number of payment periods.

payment: NUM

The function uses this value as the paid amount  in each payment period.

future value: NUM

(Optional) This represents the value after the last payment period, the default is zero.

type: NUM

(Optional) This value can be entered as a 0 or a 1, 0 meaning payments are due at the end of a payment period and 1 meaning payments are due at the beginning of a payment period. The default is zero.
Result A number value.

Example

For example, if you have an annual rate of 7.5% over 3 years, paying $100 a month and you know that the future value is $4,023.1381682 then you can work out the PRESENT VALUE by using the following figures:

SET RateNUM  TO 0.00625 //(0.075/12 to find the monthly rate)
SET TermNUM TO 36 //(amount of months in 3 years)
SET PaymentNUM  TO -100
SET FutureValueNUM TO 4023.1381682 
SET TypeNUM TO 0

PRESENT VALUE ( 0.00625, 36, -100, 4023.1381682, 0 )


This produces the result  of the Future Value being 0

See Also:
RATE
TERM
PAYMENT
FUTURE VALUE