Interest

These functions are used to calculate all types of interest related calculations.

More:

AAPR() - Add-on Interest

ACCRINT() - Accrued interest

ACCRINTM() - Accrued interest at maturity

APR() - Annual percentage rate

CTERM() - Compounded terms

CVR() - Bond coverage

CVRI() - Bond coverage (interest)

DISCINT() - Discount interest

DISCLOAN() - Discount from principal

DISCNOTE() - Discount Note

DISCOUNT() - Bond discount

DISCRATE() - Discount percentage

DISC2SIMPLE() - Discount to Simple interest

DISCTIME() - Discount periods

EFFECT() - Effective interest rate

IRPP() - Interest rate per period

LINK1() - Link interest rates

LINK2() - Link interest rates

RATE() - Investment periods

SI() - Simple interest

SIA() - Simple interest accumulated

SIMPLERATE() - Simple interest rate

SIMPLE2DISC() - Simple to Discounted interest

SIP() - Simple Interest based Principal

SIR() - Simple interest rate

SIT() - Simple interest Time

TERM() - Payment terms