Excel PMT function: loan payment
calc_excel_pmtThe payment per period for a loan or an investment, the same as Excel's PMT.
PMT(rate, nper, pv, [fv], [type]): the constant payment that brings pv to fv over nper periods at rate. Negative when you pay, as in Excel.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"rate": "<rate>",
"nper": "<nper>",
"pv": "<pv>"
},
"name": "calc_excel_pmt"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fv | No | Future value wanted after the last payment. A ratio of two decimals such as "0.08/12" is accepted. Allowed: >= -1000000000000000 and <= 1000000000000000. | 0 |
| pv | Yes | Present value: the amount now (a loan you receive is positive). A ratio of two decimals such as "0.08/12" is accepted. Allowed: >= -1000000000000000 and <= 1000000000000000. | |
| nper | Yes | Total number of payment periods. A ratio of two decimals such as "0.08/12" is accepted. Allowed: > 0 and <= 12000. | |
| rate | Yes | Interest rate per period, as a decimal (0.005 for 0.5%). Write a monthly rate from an annual one as "0.06/12". A ratio of two decimals such as "0.08/12" is accepted. Allowed: > -1 and <= 1000. | |
| type | No | When payments are due: 0 at the end of each period, 1 at the beginning. Allowed: >= 0 and <= 1. | |
| options | No | Precision and rounding of the results (default: rounding=half_even, significant_digits=15). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| inputs | Yes | The inputs as understood. | |
| result | Yes | ||
| formula | No | ||
| receipt | No | Only with ?receipt=true: a signed receipt for this answer, a JSON Web Token signed with Ed25519 (alg EdDSA). Its claims are iss, iat, jti (the request id), endpoint, date and response (this response without the receipt). Check it with the keys at /.well-known/jwks.json or POST /v1/receipts/verify. | |
| warnings | Yes | ||
| exactness | Yes | For each decimal output: exact; rounded (correctly, to the precision); rounded_uncertified (the last digit could not be proven); or underflow (below 1e-100, reported as 0). | |
| precision | No | The precision and rounding that were applied. | |
| calculator | Yes | The calculator and version that ran. | |
| references | No |