Unlocking the Power of ACCRINTM in Excel Accrued Interest Made Easy

Описание: #shorts #exceltips #exceltricks #exceltutorial #excel #excelformula
Unlocking the Power of ACCRINTM in Excel: Accrued Interest Made Easy

The ACCRINT-M function in Excel calculates the accrued interest for a security that pays interest on Maturity. The function takes the following arguments:

Issue date: The date the security was issued.
Settlement date: Date of Maturity of the security.
Rate: The annual coupon rate of the security.
Par: The par value of the security.
The ACCRINT-M function returns the total accrued interest from the issue date to the settlement date, depending on the value of the optional calc_method argument.

For example, if a security was issued on 1st April 2023,
a settlement date of 1st July 2025.
a coupon rate of 5%.
a par value of Rupees 100,000.
the ACCRINT-M function would return Rs 11,250
Formula:
=ACCRINT-M(B2,B3,B4,B5,B6)