Excel Functions


Bonds

ACCRINTReturns the accrued interest for a security that pays interest periodically.
ACCRINTMReturns the accrued interest for a security that pays interest at maturity.
PRICEReturns the price per $100 face value for a security that pays periodic interest.
PVReturns the present value of an annuity with fixed cash flows.
YIELDReturns the interest rate for a series of equal cash flows at regular intervals used for yield to maturity calculations.
ACCRINT
Returns the accrued interest for a security that pays interest periodically.
ACCRINTM
Returns the accrued interest for a security that pays interest at maturity.
PRICE
Returns the price per $100 face value for a security that pays periodic interest.
PV
Returns the present value of an annuity with fixed cash flows.
YIELD
Returns the interest rate for a series of equal cash flows at regular intervals used for yield to maturity calculations.

Coupons

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.
COUPDAYBS
Returns the number of days from the start of the coupon to the settlement date.
COUPDAYS
Returns the number of days in the coupon period that contains the settlement date.
COUPDAYSNC
Returns the number of days from the settlement date to the next coupon.
COUPNCD
Returns the date of the next coupon after the settlement date.
COUPNUM
Returns the number of coupons paid between the settlement date and maturity date.
COUPPCD
Returns the date of the previous coupon before the settlement date.

Irregular Coupons

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.
ODDFPRICE
Returns the price per $100 face value for a security having an odd (short or long) first period.
ODDFYIELD
Returns the yield of a security that has an odd (short or long) first period.
ODDLPRICE
Returns the price per $100 face value for a security having an odd (short or long) last coupon period.
ODDLYIELD
Returns the yield of a security that has an odd (short or long) last period.

Other

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.
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.
YIELDDISCReturns the annual yield for a discounted security.
YIELDMATReturns the annual yield for a security that pays interest at maturity.
DOLLARDE
Returns the dollar fraction expressed as a decimal.
DOLLARFR
Returns the dollar decimal expressed as a fraction.
DURATION
Returns the annual duration for a security that pays interest at regular intervals.
MDURATION
Returns the modified annual duration for a security that pays interest at regular intervals.
PRICEDISC
Returns the price per $100 face value for a discounted security.
PRICEMAT
Returns the price per $100 face value for a security that pays interest at maturity.
RATE
Returns the interest rate for a series of equal cash flows at regular intervals.
TBILLEQ
Returns the bond-equivalent yield for a treasury bill.
TBILLPRICE
Returns the price per $100 face value for a treasury bill.
TBILLYIELD
Returns the yield for a treasury bill.
YIELDDISC
Returns the annual yield for a discounted security.
YIELDMAT
Returns the annual yield for a security that pays interest at maturity.

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext