Skip to main content
Skip table of contents

PV

Basic Overview

Description

(Present Value)

Calculates the present value of a certain sum in the future. It is based on an interest rate, a number of recurring payments in the future, the amount of payment per period, the future value and either ordinary annuity or annuity due (type) indicating whether payments are due at the beginning or the end of period.

Signature

PV('Rate',  'Nper',  'Pmt' [,  'Fv' , "Type"])

Parameters

  • Rate  -> The interest rate

  • Nper -> Number of periods: the number of payments to be made

  • Pmt  -> Payment per period:  the amount per period to be paid (Payments/costs should (but are not required to) be entered as a negative number e.g. -500)

  • Fv -> [Optional] Future value: the future value remaining after the final payment has been made. If not entered, 'fv' is set to 0.

  • Type -> [Optional] type (1=pmt at beginning of period (Annuity Due), 0=pmt at end of period (Ordinary Annuity)). By default 'type' is set to 0.

Notes

  • The argument 'Pmt' is the leading input node.

    • A leading input node is a function argument, for which we assume the levels to be correct. All other input nodes need to have the same dimensionality.

  • Each input node can be a single number

  • Providing all inputs with the same dimensionality results in a noticeable performance improvement

Limitations

  • All other inputs must not contain Levels that are not in the leading input node 'Pmt'.

  • All level values that are in the leading input node 'pmt', must be in all the other input nodes.

Positive Costs/Payments

In case the costs/payments are entered as a positive number within your model, this function needs to be multiplied by (-1).

Example

Rate

(Interest Rate)

0.03

Nper

(Number of Periods)

5

Pmt

(Payment per Period)

-500

Fv

(Future Value)

0

Type

Payment at Beginning of Period (Annuity Due) = 1

Payment at End of Period (Ordinary Annuity) = 0

0

Valsight Formula 

PV(Rate, Nper, Pmt, Fv, 0)

Result

2,289.85

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.