Financial

Here are the articles in this section:
ACCRINT
Accrued interest of a security
AMORLINC
Depreciation for accounting period
COUPDAYBS
Nmber of days until settlement
COUPDAYS
Number of days in coupon period for settlement date
COUPDAYSNC
Number of days from settlement date until next coupon
COUPNCD
Next coupon date after settlement date
COUPNUM
Number of coupons between dates
COUPPCD
Last coupon date before settlement date
CUMIPMT
Cumulative interest
CUMPRINC
Cumulative principal paid
CURRENCY_DECIMAL
Currency decimal
CURRENCY_FRACTIONAL
Currency fractional
DECLINING_BALANCE
Arithmetic declining balance method
DISC
Discount rate of 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
Effective interest rate
INVESTMENT_DURATION
Number of compounding periods required for investment
INVESTMENT_MDURATION
Modified Macaulay duration of security paying periodic interest
INVESTMENT_PDURATION
Periods required for investment to grow to given value
IPMT
Payment on interest
IRR
Investment's internal rate of return
ISPMT
Investment's interest paid
MIRR
Modified internal rate
NET_PRESENT_VALUE
Net present value
NOMINAL
Nominal interest rate
NPER
Number of payment periods
PMT
Annuity investment's periodic payment
PPMT
Investment's payment on interest
PRESENT_VALUE
Annuity investment's present value
PRICE
Price of security that pays periodic interest
PRICEDISC
Price of discount security
PRICEMAT
Price of security that pays interest at maturity
RATE
Interest rate for annuity investment
RECEIVED
Amount received at maturity for fixed-income security investment
RRI
Interetest rate needed to reach specific investment value
SLN
Straight-line method
SYD
Sum of years digits method
TBILLPRICE
US Treasury Bill price based on discount rate
TBILLYIELD
US Treasury Bill yield based on price
VDB
Depreciation of asset for period
XIRR
Investment internal rate of return
XNPV
Investment net present value
YIELDDISC
Discount security annual yield
YIELDMAT
Calculates the annual yield of a security paying interest