<div class="raw-html-embed">The ACCRINTM function is one of the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#financial" onclick="onhyperlinkclick(this)">financial functions</a>. It is used to calculate the accrued interest for a security that pays interest at maturity.
			<h5 class="pt8">Syntax</h5> 
			ACCRINTM(issue, settlement, rate, par, [basis])
 The ACCRINTM function has the following arguments:
 <table style="width: 40%">
 <tbody><tr>
 <th style="background-color: #f4f4f4" width="150ch">Argument</th>
 <th style="background-color: #f4f4f4">Description</th>
 </tr>
 <tr>
 <td>issue</td>
 <td>The issue date of the security.</td>
 </tr>
 <tr>
 <td>settlement</td>
 <td>The maturity date of the security.</td>
 </tr>
 <tr>
 <td>rate</td>
 <td>The annual interest rate of the security.</td>
 </tr>
 <tr>
 <td>par</td>
 <td>The par value of the security. It is an optional argument. If it is omitted, the function will assume par to be $1000.</td>
 </tr>
 <tr>
 <td>basis</td>
 <td>The day count basis to use, a numeric value greater than or equal to 0, but less than or equal to 4. It is an optional argument. The possible values are listed in the table below.</td>
 </tr>
 </tbody></table>
 The basis argument can be one of the following:
 <table style="width: 40%">
 <tbody><tr>
 <th style="background-color: #f4f4f4">Numeric value</th>
 <th style="background-color: #f4f4f4">Count basis</th>
 </tr>
 <tr>
 <td>0</td>
 <td>US (NASD) 30/360</td>
 </tr>
 <tr>
 <td>1</td>
 <td>Actual/actual</td>
 </tr>
 <tr>
 <td>2</td>
 <td>Actual/360</td>
 </tr>
 <tr>
 <td>3</td>
 <td>Actual/365</td>
 </tr>
 <tr>
 <td>4</td>
 <td>European 30/360</td>
 </tr>
 </tbody></table>
 <h5 class="pt8">Notes</h5>
 Dates must be entered by using the <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/Functions/date.aspx" onclick="onhyperlinkclick(this)">DATE</a> function. 
			<a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the ACCRINTM function.			
			<h5 class="pt8">Examples</h5>
 The figure below displays the result returned by the ACCRINTM function.
			<img alt="ACCRINTM Function" src="https://static-helpcenter.teamlab.info/accrintm_0932784136.png"></div>

ACCRINTM function 

Docs

Argument	Description
*issue*	The issue date of the security.
*settlement*	The maturity date of the security.
*rate*	The annual interest rate of the security.
*par*	The par value of the security. It is an optional argument. If it is omitted, the function will assume *par* to be $1000.
*basis*	The day count basis to use, a numeric value greater than or equal to 0, but less than or equal to 4. It is an optional argument. The possible values are listed in the table below.

Numeric value	Count basis
0	US (NASD) 30/360
1	Actual/actual
2	Actual/360
3	Actual/365
4	European 30/360

ACCRINTM function

Syntax

Notes

Examples

Host ONLYOFFICE Docs on your own server or use it in the cloud