The ACCRINTM function in Excel calculates the accrued interest for a security that pays interest only at maturity.Unlike ACCRINT, where periodic payments are made, ACCRINTM is used when the full interest amount is paid once, together with the principal at the end of the investment term.

The ACCRINT function in Excel calculates the accrued interest for a security (like a bond) that pays periodic interest.It is widely used in financial analysis, especially when working with bonds, loans, or any investment product that generates interest over time.