Documentation/Calc Functions/NOMINAL

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

NOMINAL

Category:

Financial Analysis

Summary:

Calculates the yearly nominal interest rate, given the effective rate and the number of compounding periods per year.

Syntax:

NOMINAL(Effective Rate; NPerY)

Returns:

Arguments:

Effective Rate is the effective interest rate

NPerY is the number of periodic interest payments per year.

Additional details:

Examples:

What is the nominal interest per year for an effective interest rate of 13.5% if twelve payments are made per year.

=NOMINAL(13.5%;12) = 12.73%. The nominal interest rate per year is 12.73%.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: