Finance Properties

none.

  Finance Methods

Returns

Name

Arguments

Description

Number 

fv 

(Number rate, Number nPeriods, Number paymentAmt, Number pv, Boolean annuityDue)

Calculates the future value of the loan/annuity after nPeriods at the specified rate and paymentAmt.  The annuityDue argument is optional.  If the payment is due at the beginning of the period (called an Annuity Due), then set annuityDue to true.  If the payment is due at the end of the period (more typical), then omit the annuityDue argument or set it to false.

Number 

getMonthlyPayment

(Number annualInterestRate, Number nYears, principal, annuityDue)

This is a convenience method that re-uses the pmt method to simplify the process of calculating a typical nYear loan with monthly payments.  The annuityDue argument is optional.  If the payment is due at the beginning of the period (called an Annuity Due), then set annuityDue to true.  If the payment is due at the end of the period (more typical), then omit the annuityDue argument or set it to false.

Number 

ipmt

(Number rate, Number period, Number nPeriods, Number pv, Number fv, Boolean annuityDue)

Calculates the amount of money required to cover interest in the specified period of a loan/annuity of the specified conditions.  The annuityDue argument is optional.  If the payment is due at the beginning of the period (called an Annuity Due), then set annuityDue to true.  If the payment is due at the end of the period (more typical), then omit the annuityDue argument or set it to false.

Number

pmt

(Number rate, Number nPeriods, Number pv, Number fv, Boolean annuityDue)

Calculates the necessary payment to satisfy the terms of the loan/annuity.  The annuityDue argument is optional.  If the payment is due at the beginning of the period (called an Annuity Due), then set annuityDue to true.  If the payment is due at the end of the period (more typical), then omit the annuityDue argument or set it to false.

Number

ppmt

(Number rate, Number period, Number nPeriods, Number pv, Number fv, Boolean annuityDue)

Calculates the amount of the specified period will go towards principal in the loan/annuity of the specified conditions.  The annuityDue argument is optional.  If the payment is due at the beginning of the period (called an Annuity Due), then set annuityDue to true.  If the payment is due at the end of the period (more typical), then omit the annuityDue argument or set it to false.

Number 

pv

(Number rate, Number nPeriods, Number paymentAmt, Number fv, Boolean annuityDue)

Calculates the present value of the loan/annuity given nPeriods at the specified rate and paymentAmt.  The annuityDue argument is optional.  If the payment is due at the beginning of the period (called an Annuity Due), then set annuityDue to true.  If the payment is due at the end of the period (more typical), then omit the annuityDue argument or set it to false.