ACCRINTM function calculates the accrued interest for a security with a fixed maturity date, based on a specified interest rate. It is useful for financial analysis and investment management.<\/p>\n\n\n\n
ACCRINTM(issue, settlement, rate, par, basis)<\/strong><\/p>\n\n\n\n Arguments are used in the following way:<\/p>\n\n\n\n To use the ACCRINTM function, follow these steps:<\/p>\n\n\n\n 1. Enter the issue date, settlement date, annual interest rate, par value, and optionally, the day count basis in your Excel worksheet.<\/p>\n\n\n\n 2. Use the ACCRINTM function to calculate accrued interest based on the provided information.<\/p>\n\n\n\n 3. The function will return the accrued interest amount for the security.<\/p>\n\n\n\n Let’s look at some examples of how to use the ACCRINTM function:<\/p>\n\n\n\n This formula calculates the accrued interest for a security issued on January 1, 2023, and settled on July 1, 2023, with an annual interest rate of 5% and a par value of $1000. It uses the basis of 0, meaning it uses the US (NASD) 30\/360 day count basis.<\/p>\n\n\n\n This formula is similar to the previous one but uses a basis of 1, which corresponds to the actual\/actual day count basis.<\/p>\n\n\n\n These examples demonstrate how to use the ACCRINTM function to calculate accrued interest under different day count bases.<\/p>\n\n\n\nArguments<\/h2>\n\n\n\n
issue<\/strong><\/td> The issue date of the security.<\/td><\/tr> settlement<\/strong><\/td> The settlement date when the security was acquired.<\/td><\/tr> rate<\/strong><\/td> The annual interest rate of the security.<\/td><\/tr> par<\/strong><\/td> The par value of the security (face value).<\/td><\/tr> basis<\/strong><\/td> The day count basis to use for calculations. It specifies how days are counted. (Optional)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n How to Use<\/h2>\n\n\n\n
Examples<\/h2>\n\n\n\n
=ACCRINTM(\"01\/01\/2023\", \"07\/01\/2023\", 0.05, 1000, 0)<\/code><\/pre>\n\n\n\n=ACCRINTM(\"01\/01\/2023\", \"07\/01\/2023\", 0.05, 1000, 1)<\/code><\/pre>\n\n\n\nAdditional Information<\/h2>\n\n\n\n