Documentation/Calc Functions/EFFECT ADD

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

EFFECT_ADD

Category:

Financial Analysis

Summary:

Calculates the effective annual rate of interest on the basis of the nominal interest rate and the number of interest payments per annum.

Syntax:

EFFECT_ADD(Nominal Rate; NPerY)

Returns:

Arguments:

Nominal Rate is the annual nominal rate of interest.

NPerY is the number of interest payments per year.

Additional details:

The functions whose names end with _ADD or _EXCEL2003 return the same results as the corresponding Microsoft Excel 2003 functions without the suffix. Use the functions without suffix to get results based on international standards.

Examples:

What is the effective annual rate of interest for a 5.25% nominal rate and quarterly payment.

=EFFECT_ADD(0.0525;4) returns 0.053543 or 5.3543%.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: