# Documentation/Calc Functions/RATE

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

RATE

## Category:

Financial Analysis

## Summary:

Returns the constant interest rate per period of an annuity.

## Syntax:

RATE(**NPer**; **Pmt**; **PV**; **FV**; **Type**; **Guess**)

## Returns:

## Arguments:

**NPer** is the total number of periods, during which payments are made (payment period).

**Pmt** is the constant payment (annuity) paid during each period.

**PV** is the cash value in the sequence of payments.

**FV** (optional) is the future value, which is reached at the end of the periodic payments.

**Type** (optional) is the due date of the periodic payment, either at the beginning or at the end of a period.

**Guess** (optional) determines the estimated value of the interest with iterative calculation.

In the LibreOffice Calc functions, parameters marked as "optional" can be left out only when no parameter follows. For example, in a function with four parameters, where the last two parameters are marked as "optional", you can leave out parameter 4 or parameters 3 and 4, but you cannot leave out parameter 3 alone.

## Additional details:

## Examples:

What is the constant interest rate for a payment period of 3 periods if 10 currency units are paid regularly and the present cash value is 900 currency units.

=RATE(3;-10;900) = -75.63% The interest rate is therefore 75.63%.