Version

UltraCalcFunctionPmt Class

Calculates what the payment amount should be on a loan at a fixed interest rate requiring a fixed number of payments.
Syntax
'Declaration
 
Public Class UltraCalcFunctionPmt 
   Inherits BuiltInFunctionBase
public class UltraCalcFunctionPmt : BuiltInFunctionBase
Remarks

PMT(interestRate, nPeriods, presentValue, futureValue, paymentDue)

InterestRate is the interest rate for the loan.

NPeriods is the number of payments required to pay back the loan.

PresentValue is the current value of the loan (also called the principal), which is a lump sum that the future series of nPeriods payments (which accumulate interest at interestRate) is worth today.

FutureValue is the cash balance in the future (for a loan, this will typically be a loan liability balance of zero) following this series of fixed payments, accruing a fixed interestRate. If omitted, a default future value of 0 is used.

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 Server 2012, 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