Tag: Banking

• accruedInterest

  finance/banking

  Finance functions

• billBondEquiv

  finance/banking

  Return the bond-equivalent yield for a treasury bill. <span align="right" style="background-color:99FF99"><strong>Excel: TBILLEQ</strong></span>

• billPrice

  finance/banking

  Calculate the price per 100 units face value of a treasury bill. <span align="right" style="background-color:99FF99"><strong>Excel: TBILLPRICE</strong></span>

• billYield

  finance/banking

  Calculate the yield for a treasury bill. <span align="right" style="background-color:99FF99"><strong>Excel: TBILLYIELD</strong></span>

• couponDaysAfterSet

  finance/banking

  Finance namespace

• couponDaysInPeriod

  finance/banking

  Return number of days in coupon period containing the settlement date. <span align="right" style="background-color:99FF99"><strong>Excel: COUPDAYS</strong></span>

• couponDaysToSet

  finance/banking

  Return the number of days from the start of the coupon period to the settlement date. <span align="right" style="background-color:99FF99"><strong>Excel: COUPDAYBS</strong></span>

• couponNextDate

  finance/banking

  Calculate the next coupon date for a security. <span align="right" style="background-color:99FF99"><strong>Excel: COUPNCD</strong></span>

• couponNumber

  finance/banking

  Compute the number of coupons payable between settlement and maturity. <span align="right" style="background-color:99FF99"><strong>Excel: COUPNUM</strong></span>

• couponPrevDate

  finance/banking

  Finance namespace

• dollar_decimal

  finance/banking

  Finance functions

• dollar_fraction

  finance/banking

  Finance functions

• future_value

  finance/banking

  Time within a period when a payment is made

• future_value_schedule

  finance/banking

  Evaluate the future value of an investment using a schedule of interest rates.

• interestEffective

  finance/banking

  Finance namespace

• interestNominal

  finance/banking

  Return the nominal annual interest rate. <span align="right" style="background-color:99FF99"><strong>Excel: NOMINAL</strong></span>

• interestSecurity

  finance/banking

  Return the interest rate for a fully invested security. <span align="right" style="background-color:99FF99"><strong>Excel: INTRATE</strong></span>

• nPeriods

  finance/banking

  Enumation of Payment point

• totalReceived

  finance/banking

  Returns the total amount received from a financial security at maturity <span align="right" style="background-color:99FF99"><strong>Excel: RECEIVED</strong></span>

• YearBasis

  finance/banking

  Year basis to be used in financial calculations

• yearFraction

  finance/banking

  Computes the fraction of the year between two serial dates, <span align="right" style="background-color:99FF99"><strong>Excel: YEARFRAC</strong></span>

• YearlyFreq

  finance/banking

  Yearly frequency to be used in financial calculations