Financial

ACCRINTThe accrued interest for a security that pays interest periodically.
ACCRINTMThe accrued interest for a security that pays interest at maturity.
AMORDEGRCThe depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINCThe depreciation of an asset in a single period (straight-line).
COUPDAYBSThe number of days between the previous coupon date and the settlement date.
COUPDAYSThe number of days between the coupon dates on either side of the settlement date.
COUPDAYSNCThe number of days between the settlement date and the next coupon date.
COUPNCDThe next coupon date after the settlement date.
COUPNUMThe number of coupons between the settlement date and the maturity date.
COUPPCDThe previous coupon date before the settlement date.
CUMIPMTThe cumulative interest paid on a loan between two dates.
CUMPRINCThe cumulative principal paid on a loan between two dates.
DISCThe interest rate (or discount rate) for a security held to maturity.
DOLLARDEThe dollar fraction expressed as a decimal.
DOLLARFRThe dollar decimal expressed as a fraction.
DURATIONThe annual duration of a security that pays interest periodically.
EFFECTThe effective interest rate given a nominal interest rate and compounding frequency.
FVSCHEDULEThe future value of an initial principal after applying compound interest rates.
INTRATEThe interest rate for a security held to maturity.
MDURATIONThe modified duration for a security that pays interest periodically.
NOMINALThe nominal interest rate over a period given an annual interest rate.
ODDFPRICEThe price per $100 face value of a security with an odd first period.
ODDFYIELDThe yield of a security with an odd first period.
ODDLPRICEThe price per $100 face value of a security with an odd last period.
ODDLYIELDThe yield of a security with an odd last period.
PMTThe payment for a loan with constant payments and fixed interest.
PRICEThe price of a security that pays periodic interest.
PRICEDISCThe price of a discounted security (no interest payments).
PRICEMATThe price of a security that pays interest at maturity.
RECEIVEDThe amount received at the end when a security is held to maturity.
TBILLEQThe yield (bond-equivalent) for a treasury bill.
TBILLPRICEThe price per $100 face value for a treasury bill.
TBILLYIELDThe yield for a treasury bill.
XIRRThe interest rate for a series of unequal cash flows at irregular intervals.
XNPVThe present value for a series of unequal cash flows at irregular intervals.
YIELDThe interest rate (annual) for a series of equal cash flows at regular intervals.
YIELDDISCThe interest rate (annual) for a discounted security (no interest payments).
YIELDMATThe interest rate (annual) for a security that pays interest at maturity.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top