NOMINAL

NOMINAL

Synopsis

NOMINAL(r,nper)

Description

NOMINAL calculates the nominal interest rate from a given effective rate.

Nominal interest rate is given by a formula:

nper * (( 1 + r ) ^ (1 / nper) - 1 )

where:

r = effective interest rate

nper = number of periods used for compounding

  • If rate < 0, NOMINAL returns #NUM! error.
  • If nper <= 0, NOMINAL returns #NUM! error.

Examples

See also

EFFECT.