Excel Functions


Interest

ACCRINTReturns the accrued interest for a security that pays interest periodically.
ACCRINTMReturns the accrued interest for a security that pays interest at maturity.


Other

COUPDAYBSReturns the number of days from the start of the coupon to the settlement date.
COUPDAYSReturns the number of days in the coupon period that contains the settlement date.
COUPDAYSNCReturns the number of days from the settlement date to the next coupon.
COUPNCDReturns the date of the next coupon after the settlement date.
COUPNUMReturns the number of coupons paid between the settlement date and maturity date.
COUPPCDReturns the date of the previous coupon before the settlement date.
DOLLARDEReturns the dollar fraction expressed as a decimal.
DOLLARFRReturns the dollar decimal expressed as a fraction.
DURATIONReturns the annual duration for a security that pays interest at regular intervals.
MDURATIONReturns the modified annual duration for a security that pays interest at regular intervals.
ODDFPRICEReturns the price per $100 face value for a security having an odd (short or long) first period.
ODDFYIELDReturns the yield of a security that has an odd (short or long) first period.
ODDLPRICEReturns the price per $100 face value for a security having an odd (short or long) last coupon period.
ODDLYIELDReturns the yield of a security that has an odd (short or long) last period.
PRICEReturns the price per $100 face value for a security that pays periodic interest.
PRICEDISCReturns the price per $100 face value for a discounted security.
PRICEMATReturns the price per $100 face value for a security that pays interest at maturity.
RATEReturns the interest rate for a series of equal cash flows at regular intervals.
TBILLEQReturns the bond-equivalent yield for a treasury bill.
TBILLPRICEReturns the price per $100 face value for a treasury bill.
TBILLYIELDReturns the yield for a treasury bill.
YIELDReturns the interest rate for a series of equal cash flows at regular intervals used for yield to maturity calculations.
YIELDDISCReturns the annual yield for a discounted security.
YIELDMATReturns the annual yield for a security that pays interest at maturity.


Depreciation

AMORDEGRCReturns the depreciation of an asset in a single period.
AMORLINCReturns the depreciation of an asset in a single period.

© 2018 Better Solutions Limited. All Rights Reserved. © 2018 Better Solutions Limited