Excel Functions
Bonds
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. |
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
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. |
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
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. |
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
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. |
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