Best Math Formula website. Search anything about Math Formula in this website.
what is accrint function in excel with example. The function will calculate the accrued interest. The Excel ACCRINT function calculates the interest accrued for a security that pays interest periodically.
How To Use The Excel Accrint Function Exceljet from exceljet.net
The ACCRINTM Function is an Excel Financial function. It helps users calculate the accrued interest on a security such as a bond when the security is sold or transferred to a new owner on a date other than the issue date. This function returns the accrued interest for a security that pays periodic interest.
To understand how the following function works lets study an example for the same.
The security has an issue date of 01-Jan-2012 and a settlement date of 31-Dec-2012. How to use the ACCRINT Function in Excel In this article we will learn about how to use the ACCRINT function in Excel. The ACCRINTM Function is an Excel Financial function. So to total the returns of the same ACCRINT Function of Excel is used.
