Tag: Finance

• 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

• deprecFixedDec

  finance/accounting

  Return the depreciation for a specified period using the fixed-declining balance method. <span align="right" style="background-color:99FF99"><strong>Excel: DB</strong></span>

• depreciation

  finance/accounting

  Return the depreciation for a specified period using the fixed-declining balance method. <span align="right" style="background-color:99FF99"><strong>Excel: DDB</strong></span>

• deprecProRated

  finance/accounting

  Return the depreciation for each accounting period. <span align="right" style="background-color:99FF99"><strong>Excel: AMORLINC</strong></span>

• deprecProRatedM

  finance/accounting

  Return the depreciation for each accounting period. <span align="right" style="background-color:99FF99"><strong>Excel: AMORDEGRC</strong></span>

• deprecStraight

  finance/accounting

  Finance namespace

• deprecSumOfYears

  finance/accounting

  Calculate the sum-of-years depreciation of an asset. <span align="right" style="background-color:99FF99"><strong>Excel: SYD</strong></span>

• 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>

• MertonModel

  finance

  Merton Model Calculation

• nPeriods

  finance/banking

  Enumation of Payment point

• npv

  finance/accounting

  Return the net present value of an investment.

• pv

  finance/accounting

  Return the present value of an investment.

• 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>

• xnpv

  finance/accounting

  Calculate net present value for a series of non-periodic cash flows. <span align="right" style="background-color:99FF99"><strong>Excel: XNPV</strong></span>

• YearBasis

  finance/banking

  Year basis to be used in financial calculations