ExcelFlux

NOMINAL function

the annual nominal interest rate.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Convert effective annual interest to a nominal annual rate for the specified compounding frequency.

A worked example from the workbook

RowAB
6Annual ratePeriods per year
70.1212
80.121
90.084
Record 1
=NOMINAL(A7,B7)

Expected result0.1138655152

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=NOMINAL(0.1,1)
Turkish Excel · tr-TR
=NOMİNAL(0,1;1)

Expected result

0.1

Worked examples

Convert effective annual interest to a nominal annual rate for the specified compounding frequency.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 Annual rate Periods per year
7 0.12 12
8 0.12 1
9 0.08 4
Case Formula Expected result
Record 1 =NOMINAL(A7,B7) 0.1138655152
Record 2 =NOMINAL(A8,B8) 0.12
Record 3 =NOMINAL(A9,B9) 0.07770618763
Microsoft Excel reference