Documentation/Calc Functions/NOMINAL

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:
Returns a non-negative real number (expressed as a percentage or fraction) which is the annual nominal interest rate for the given arguments.

Arguments:
Effective Rate is a positive real number (expressed as a percentage or fraction) or a reference to the cell containing that number which is the effective interest rate.

NPerY is a positive whole number or a reference to the cell containing that number which is the number of periodic interest payments per year.


 * If Effective Rate is less than or equal to 0 then the function returns an error value.
 * If NPerY is not an integer then it is truncated to an integer.
 * If after truncation NPerY is less than 1 then the function returns an error value.

Additional details:

 * Suppose that P is the present value, NPerY is the compounding periods per year, the future value after one year is

The mapping between the nominal rate and the effective rate is

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/EFFECT EFFECT]

[[Special:MyLanguage/Documentation/Calc_Functions/NOMINAL_ADD NOMINAL_ADD]

ODF standard:
Section 6.12.28, part 2

Equivalent Excel functions:
NOMINAL