Documentation/Calc Functions/EFFECT

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

EFFECT

Category:

Financial Analysis

Summary:

Returns the net annual interest rate for a nominal interest rate.

Syntax:

EFFECT(Nom; P)

Returns:

Nom is the nominal interest.

P is the number of interest payment periods per year.

Arguments:

Additional details:

Nominal interest refers to the amount of interest due at the end of a calculation period. Effective interest increases with the number of payments made. In other words, interest is often paid in installments (for example, monthly or quarterly) before the end of the calculation period.

Examples:

If the annual nominal interest rate is 9.75% and four interest calculation periods are defined, what is the actual interest rate (effective rate)?

=EFFECT(9.75%;4) = 10.11% The annual effective rate is therefore 10.11%.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: