<div class="raw-html-embed">The ISPMT 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 interest payment for a specified period of an investment based on a constant payment schedule.
			<h5 class="pt8">Syntax</h5> 
			ISPMT(rate, per, nper, pv) 
			The ISPMT 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>rate</td>
 <td>The interest rate for the investment.</td>
 </tr>
				<tr>
 <td>per</td>
 <td>The period you want to find the interest payment for. The value must be from 1 to nper.</td>
 </tr>
				<tr>
 <td>nper</td>
 <td>A number of payments.</td>
 </tr>
				<tr>
 <td>pv</td>
 <td>A present value of the payments.</td>
 </tr>
 </tbody></table>
			
 <h5 class="pt8">Notes</h5>
 Cash paid out (such as deposits to savings) is represented by negative numbers; cash received (such as dividend checks) is represented by positive numbers. Units for rate and nper must be consistent: use N%/12 for rate and N*12 for nper in case of monthly payments, N%/4 for rate and N*4 for nper in case of quarterly payments, N% for rate and N for nper in case of annual payments.
 <a href="https://helpcenter.onlyoffice.com/onlyoffice-editors/onlyoffice-spreadsheet-editor/UsageInstructions/InsertFunction.aspx#applyfunction" onclick="onhyperlinkclick(this)">How to apply</a> the ISPMT function.
			
			<h5 class="pt8">Examples</h5>
 The figure below displays the result returned by the ISPMT function.
			<img alt="ISPMT Function" src="https://static-helpcenter.teamlab.info/ispmt_d2ee15081d.png"></div>

ISPMT function

Docs

Argument	Description
*rate*	The interest rate for the investment.
*per*	The period you want to find the interest payment for. The value must be from 1 to *nper*.
*nper*	A number of payments.
pv	A present value of the payments.

ISPMT function

Syntax

Notes

Examples

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