Returns the constant interest rate per period of an annuity.
RATE(NPer; Pmt; PV; FV; Type; Guess)
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.
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%.