Formula Generator - ACCRINTM function
The ACCRINTM function calculates the accrued interest of a security that pays interest at maturity. It takes into account the issue date, maturity date, annual interest rate, redemption value, and day count convention. The function returns the accrued interest amount.How to generate an ACCRINTM formula using AI.
To get the ACCRINTM formula from an AI chatbot, you can ask: "Can you provide me with the formula for calculating accrued interest using the ACCRINTM function in Excel?"
ACCRINTM formula syntax.
The ACCRINTM function in Excel calculates the accrued interest for a security that pays interest at maturity. The syntax for ACCRINTM is: =ACCRINTM(issue, settlement, rate, par, basis) - issue: The date the security was issued. - settlement: The date the security was purchased. - rate: The annual interest rate of the security. - par: The face value of the security. - basis: The day count basis to use for calculation (optional). The function returns the accrued interest for the security between the issue date and the settlement date.
Calculating Accrued Interest for a Bond
This use case demonstrates how to calculate the accrued interest for a bond using the ACCRINTM function. ACCRINTM calculates the accrued interest of a security that pays interest at maturity.
ACCRINTM(issue, maturity, rate, [redemption], [day_count_convention])
Calculating Accrued Interest for Multiple Bonds
This use case demonstrates how to calculate the accrued interest for multiple bonds using the ACCRINTM function. It shows how to use the function in an array formula to calculate accrued interest for a range of bonds.
ACCRINTM(issue_range, maturity_range, rate_range, [redemption_range], [day_count_convention])
Calculating Accrued Interest with Different Day Count Conventions
This use case demonstrates how to calculate the accrued interest for a bond with different day count conventions using the ACCRINTM function. It shows how to use different day count conventions to calculate accrued interest based on different methods of counting days.