Skip to Content

NOMINAL

Returns the annual nominal interest rate, given the effective rate and the number of compounding periods per year

Syntax

NOMINAL(effect_rate, npery)

Parameters

  • effect_rate: Required. The effective interest rate
  • npery: Required. The number of compounding periods per year

Example

=NOMINAL(0.053543, 4)
Returns: NumberSince: Excel 2003