Как пользоваться функцией ACCRINTM в Excel

The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity.

Syntax

In Microsoft Excel, the syntax for the ACCRINTM function is:

ACCRINTM(issue_date, maturity_date, rate, par_value, basis, [calculation_method]);

The syntax is identical in Google Sheets:

ACCRINTM(issue_date, maturity_date, rate, par_value, basis, [calculation_method])

Let»s break down each argument:

• issue_date — the date when the investment starts accruing interest.
• maturity_date — the date when the security matures.
• rate — the annual interest rate of the security.
• par_value — the nominal or face value of the security at maturity.
• basis — a number representing the day count basis to be used in the calculations (360 or 365 days).
• [calculation_method] — an optional argument specifying the precision of the result.

Use Cases

The ACCRINTM function is typically used for:

• Calculating accrued interest on bonds or other securities.
• Assessing the yield of a security assuming it is held to maturity.

Example Solutions

Example 1. Calculating the accrued interest for a bond with specified parameters:

=ACCRINTM("01.01.2021", "01.07.2021", 0.05, 1000, 1)

Example 2. Estimating bond yield with specified result precision:

=ACCRINTM("01.01.2021", "01.04.2021", 0.045, 750, 2, 3)

Больше информации: https://support.microsoft.com/ru-ru/office/накопдоходпогаш-функция-накопдоходпогаш-f62f01f9-5754-4cc4-805b-0e70199328a7