Here are the articles in this section:

ACCRINT

Calculates the accrued interest of a security

AMORLINC

Calculates AMORLINC

COUPDAYBS

Calculates the number of days in the coupon period containg the settlement date

COUPDAYS

Calculates the number of days in the coupon period that contains the specified settlement date

COUPDAYSNC

Calculates the number of days from the settlement date until the next coupon

COUPNCD

Calculates next coupon date after the settlement date

COUPNUM

Calculates the number of coupons between dates

COUPPCD

Calculates last coupon date before the settlement date

CUMIPMT

CUMIPMT

CUMPRINC

CUMPRINC

CURRENCY_DECIMAL

Currency decimal

CURRENCY_FRACTIONAL

Currency fractional

DECLINING_BALANCE

Arithmetic declining balance method

DISC

Calculates the discount rate of a security

DOUBLE_DECLINING_BALANCE

Double-declining balance method

EFFECT

Annual effective interest rate

FUTURE_VALUE

Future value

FUTURE_VALUE_SCHEDULE

Future value by schedule

INTRATE

Calculates the effective interest rate

INVESTMENT_DURATION

Calculates the number of compounding periods required for an investment

INVESTMENT_MDURATION

Calculates the modified Macaulay duration of a security paying periodic interest

INVESTMENT_PDURATION

Periods for an investment

IPMT

IPMT

IRR

Calculates the internal rate of return on an investment based on a series of periodic cash flows

ISPMT

ISPMT

MIRR

Modified internal rate

NET_PRESENT_VALUE

Net present value

NOMINAL

Nominal

NPER

Number of payment periods

PMT

PMT

PPMT

PPMT

PRESENT_VALUE

Present value

PRICE

Calculates the price of a security paying periodic interest

PRICEDISC

Calculates the price of a discount (non-interest-bearing) security

PRICEMAT

Calculates the price of a security paying interest at maturity, based on expected yield

RATE

Calculates the interest rate

RECEIVED

Calculates the amount received at maturity for an investment in fixed-income securities

RRI

RRI

SLN

Straight-line method

SYD

Sum of years digits method

TBILLPRICE

Returns the TBILLPRICE

TBILLYIELD

Returns the TBILLYIELD

VDB

Calculates the the depreciation of an asset

XIRR

Calculate internal rate of return of an investment

XNPV

XNPV

YIELDDISC

Calculates the annual yield of a discount (non-interest-bearing) security

YIELDMAT

Calculates the annual yield of a security paying interest