| ACCRINT | The accrued interest for a security that pays interest periodically. | ACCRINTM | The accrued interest for a security that pays interest at maturity. | AMORDEGRC | The depreciation of an asset over a particular period. | AMORLINC | The depreciation of an asset over a particular period. | COUPDAYBS | The number of days between a coupon starting and settlement. | COUPDAYS | The number of days between the next coupon and settlement. | COUPDAYSNC | The number of days from the settlement date to the next coupon. | COUPNCD | The next coupon date after the settlement date. | COUPNUM | The number of coupons between the settlement and maturity. | COUPPCD | The previous coupon date before the settlement. | CUMIPMT | The cumulative interest paid between two periods. | CUMPRINC | The cumulative principal paid on a loan between two dates. | DISC | The discount rate for a security. | DOLLARDE | The dollar fraction expressed as a decimal. | DOLLARFR | The dollar decimal expressed as a fraction. | DURATION | The annual duration of a security that pays interest periodically. | EFFECT | The annual interest rate given a nominal rate and compounding frequency. | FVSCHEDULE | The future value of an initial principal after applying compound interest rates. | INTRATE | The interest rate for a fully invested security. | MDURATION | The modified duration for a security that pays interest periodically. | NOMINAL | The nominal rate equivalent to a given annual effective with a given compounding frequency for a nominal rate. | ODDFPRICE | The price per $100 face value of a security with an odd first period. | ODDFYIELD | The yield of a security with an odd first period. | ODDLPRICE | The price per $100 face value of a security with an odd last period. | ODDLYIELD | The yield of a security with an odd last period. | PMT | The payment for a loan with constant payments and fixed interest. | PRICE | The price per $100 face value of a security. | PRICEDISC | The price per $100 face value of a discounted security. | PRICEMAT | The price per $100 face value of a security that pays interest at maturity. | RECEIVED | The number received at maturity for a fully invested security. | TBILLEQ | The bond equivalent yield for a treasury bill. | TBILLPRICE | The price per $100 face value for a treasury bill. | TBILLYIELD | The yield for a treasury bill. | XIRR | The annual effective interest rate for a schedule of cash flows. | XNPV | The net present value for a schedule of cash flows. | YIELD | The yield on a security that pays periodic interest. | YIELDDISC | The annual yield for a discounted security. | YIELDMAT | The annual yield of a security that pays interest at maturity. |
