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. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext