Version

UltraCalcFunctionPV Class

Calculates an investment's present value by discounting what a series of fixed future payments is worth at a specified interest rate.
Syntax
'Declaration
 
Public Class UltraCalcFunctionPV 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionPV : BuiltInFunctionBase 
Remarks

PV(interestRate, nPeriods, amount, futureValue, paymentDue)

InterestRate is the per-period rate of interest used to discount the future payments. For positive interest rates, the value of future payments diminishes (discounts) to what they are worth now. It is assumed you can reinvest the present value at interestRate to receive futureValue after nPeriods.

NPeriods are the total number of payment periods over the course of the annuity. If your retirement plan annuitizes in 35-years, and you make a fixed quarterly contribution into it, then you would use 35x4 or 140 as your total number of payment periods.

Amount is how much is paid (or received) each period. This amount must be constant over the course of the investment. If you need to calculate the Net Present Value of a series of variable payment amounts, then you should consider using the NPV() function.

FutureValue is the expected cash balance of the investment at culmination. If this argument is omitted, it will be assumed to be zero. In the common usage scenario of calculating loan repayments, a future value of zero represents having a zero liability when the loan is fully repaid. When specifying a zero future value, ensure that amount is non-zero (otherwise the loan could never be repaid). In retirement planning, you would normally estimate the future value you would like to have when you retire.

PaymentDue is a numeric value of either 1 or 0, and indicates whether payments are invested in the annuity at the beginning of each period (1) or at the end of each period (0).

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also