# PPMT

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function returns the amount of payment of principal for a loan given the present value, specified interest rate, and number of terms.

## Syntax

PPMT(*rate*,*per*,*nper*,*pval*,*fval*,*type*)

## Arguments

This function has these arguments:

| **Argument** | **Description** |
| -------- | ----------- |
| *rate* | Value of interest rate per period. |
| *per* | Number of the period for which to find the interest, between 1 and *nper* |
| *nper* | Total number of payment periods in an annuity. |
| *pval* | Present value, worth now |
| *fval* | [Optional] Future value, cash value after the last payment; if omitted, the calculation uses zero |
| *type* | [Optional] Indicates when payments are due; at the end (0) or beginning (1) of the period; if omitted, the calculation uses the end (0) |

## Remarks

Be sure to express the interest rate as per annum. For example, if the interest rate is 8 percent, use 8 for the rate argument.
The result is represented by a negative number because it is money paid out by you.
See the [PV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPV) function for the equation for calculating financial values.

## Data Types

Accepts numeric data for all arguments. Returns numeric data.

## Examples

`PPMT(B1,C4,C5,C6,C7,1)`
`PPMT(R1C2,R4C3,R6C3,R7C3,0)`
`PPMT(0.45, 22, 30, 6000, 7000)` gives the result -$206.47

## Version Available

This function is available in product version 1.0 or later.

## See Also

[IPMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsFtoK/FunctionIPMT) \| [PMT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPMT) \| [PV](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionPV) \| [Financial Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functsfinance)