I'm glad you revisited our frequent blog post about Excel A-to-z functions. Today we offer you the ACCRINTM function …
The ACCRINTM function
I want to change the name of this function ACCRINTM STANLEY – Football followers will get it! The ACCRINTM The function returns the interest accrued on a security that pays interest at maturity. This differs from ACCRINTM The function discussed last time, since it calculates the accrued interest for a security that pays periodic interest.
To take advantage of this function, use the following syntax:
= ACCRINTM (issue, liquidation, rate, through, [basis])
Before testing this function, there are a few things you need to know.
- Excel stores dates as sequential serial numbers so they can be used in calculations.. By default, the 1 of January of 1900 is the serial number 1 and the 1 of January of 2008 is the serial number 39448 because it is 39,448 days after 1 of January of 1900.
- trouble, coloniest, Y base they are truncated to whole numbers
- And issues O settlement is not a valid date, ACCRINTM returns the #VALUE! error value.
- And Speed <0 o si through > 0, ACCRINTM, return the #VALUE! error value
- And base <0 o si base > 4, ACCRINTM return the #ON ONE! error value
- And affair > settle, ACCRINTM return the #ON ONE! error value
- ACCRINTM = through X Speed X NOTICE
where:
- A = Number of accrued days counted monthly. For interest at maturity, the number of days from the issue date to today's maturity date is used.
- D = Annual year basis.
Arguments:
- affair – the issue date of the security
- settlement – the maturity date of the security
- Speed – the annual coupon rate of the security
- through – the face value of the security. If omitted, par, ACCRINTM uses $ 1,000
- base – It is optional and specifies the type of day count basis to be used.
