### 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