Financial

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