Browse

PMT Function (LibreOffice Calc)

Financial Intermediate LibreOffice Calc

Learn the PMT function in LibreOffice Calc: Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic.

The PMT function in LibreOffice Calc is used for this task: Regular payments. Returns the periodic payment of an annuity, based on regular payments and a fixed periodic interest rate. Estimate the regular payment on a fixed-rate loan.

This guide explains how to read the formula, reproduce a concrete example, interpret its result and recognize common input mistakes.

Syntax and arguments

PMT(rate; nper; pv; [fv]; [type])
Argument Required? Meaning
Rate Yes The rate of interest per period.
NPER Yes Payment period. The total number of periods in which the annuity (pension) is paid.
PV Yes Present value. The current value of a series of payments
FV Optional Future value. The value (end value) to be attained after the final payment.
Type Optional Type = 1 denotes due at the beginning of the period, = 0 at the end.

Calc formulas normally use semicolons (;) between arguments in common configurations; the displayed separator may depend on settings or locale.

Worked example

=ROUND(PMT(0.05;3;1000);2)

Expected result: -367.21.

Why it works: Estimate the regular payment on a fixed-rate loan. For decimal results, display formatting can change how many digits appear without changing the underlying number.

How to use it in your own spreadsheet

  1. Identify the cells or inputs that correspond to the sample values above.
  2. Enter the formula in an empty cell, changing the references or literal values to match your sheet.
  3. Compare the output with a manual check on a small known example.
  4. Extend the formula to a larger dataset only after you understand the result.

Common problems and practical checks

  • Confirm that the data represents the intended sample, population, rate or cash-flow timing.
  • Keep units and percentage conventions consistent; a mathematically valid result can still answer the wrong question.
  • A pasted formula may produce an error when it uses the other program’s argument separator or unsupported options.

FV PV NPV IRR SLN.

Documentation and verification

  • LibreOffice Calc Help
  • The standalone example was calculated using LibreOffice Calc 25.2.3.2 on October 9, 2026 and its computed result matched the expected value. This does not certify every option, version, or other example.