Financial
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 in a single period (straight-line, implicit coefficient). |
AMORLINC | The depreciation of an asset in a single period (straight-line). |
COUPDAYBS | The number of days between the previous coupon date and the settlement date. |
COUPDAYS | The number of days between the coupon dates on either side of the settlement date. |
COUPDAYSNC | The number of days between the settlement date and the next coupon date. |
COUPNCD | The next coupon date after the settlement date. |
COUPNUM | The number of coupons between the settlement date and the maturity date. |
COUPPCD | The previous coupon date before the settlement date. |
CUMIPMT | The cumulative interest paid on a loan between two dates. |
CUMPRINC | The cumulative principal paid on a loan between two dates. |
DISC | The interest rate (or discount rate) for a security held to maturity. |
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 effective interest rate given a nominal interest rate and compounding frequency. |
FVSCHEDULE | The future value of an initial principal after applying compound interest rates. |
INTRATE | The interest rate for a security held to maturity. |
MDURATION | The modified duration for a security that pays interest periodically. |
NOMINAL | The nominal interest rate over a period given an annual interest 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 of a security that pays periodic interest. |
PRICEDISC | The price of a discounted security (no interest payments). |
PRICEMAT | The price of a security that pays interest at maturity. |
RECEIVED | The amount received at the end when a security is held to maturity. |
TBILLEQ | The yield (bond-equivalent) for a treasury bill. |
TBILLPRICE | The price per $100 face value for a treasury bill. |
TBILLYIELD | The yield for a treasury bill. |
XIRR | The interest rate for a series of unequal cash flows at irregular intervals. |
XNPV | The present value for a series of unequal cash flows at irregular intervals. |
YIELD | The interest rate (annual) for a series of equal cash flows at regular intervals. |
YIELDDISC | The interest rate (annual) for a discounted security (no interest payments). |
YIELDMAT | The interest rate (annual) for a security that pays interest at maturity. |
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top