Nominal Interest Rate Formula


i = m x ((1 + r)1/m - 1)
r = Effective annual rate of interest
i = Annual nominal rate of interest
m = Number of compounding periods in a year


The nominal interest rate formula calculates the annual nominal rate of interest (i), based on an effective annual rate (r). and a number of compounding periods in a year (m).

Excel Function

The Excel NOMINAL function can be used instead of the nominal interest rate formula, and has the syntax shown below.

i = NOMINAL(r,m)

Nominal Interest Rate Formula Example

If the effective rate is given as 5.116%, what is the annual nominal interest rate if compounding takes place monthly?

The nominal interest rate for the year is calculated using the nominal interest rate formula as follows:

Nominal interest rate = i = m x ((1 + r)1/m - 1)
r = effective annual rate = 5.116%
m = compounding periods in a year = 12
Nominal interest rate = 12 x ((1 + 5.116%)1/12 - 1)
Nominal interest rate = 5.000%

The same answer can be obtained using the Excel NOMINAL function as follows:

Effective annual rate = NOMINAL(r,m)
r = 5.116%
m = 12
Nominal interest rate = NOMINAL(5.116%, 12)
Nominal interest rate = 5.000%

The nominal interest rate formula is one of many annuity formulas used in time value of money calculations, discover another at the links below.

Nominal Interest Rate Formula November 6th, 2016Team

You May Also Like

Related pages

cash received receipt templateimpairment loss on intangible assetstrial balance of balancesrequisition slip sampleimprest system of petty cash book exampledouble entry bookkeeping example questionsdebit memo accounting entryconsumable suppliesbasic bookkeeping testcontinuos compoundingprepare a retained earnings statementdefinition endowment fundbalance sheet worksheetyield to maturity formula exceladjusting entries for accrued salariesgaap chart of accounts standardformula of cost of good soldinstallment notescash receipt journal examplecalculating annuity payments in exceldividends declared income statementfactory overhead appliedadjusting journal entries exampleincome tax payable journal entryaccounts receivable and allowance for doubtful accountsaccrual entries in accountingvariable cost definition in accountinggross profit percentage calculation formulahow to calculate double declining depreciationformula for future value of annuitydebtors account receivableprove it test answers excelformula of operating cyclejournal entry for warrantydeferred taxation meaningaccrual journal entryeom meaningrate of markup calculatorfob origin vs fob destinationan nsf check is aintangible assets on balance sheet examplestockholders equity examplestated annual interest rateexpense payable journal entryexcel depreciationhow to calculate annuity paymentshow to calculate allowance for doubtful accountshow to calculate marketable securities from balance sheetcalculate wip inventorydupont analysis calculatorexample of single step income statementdefine contra accountannuity formulapresent value of anuitycalculating depreciation straight lineexcel accounting formulas cheat sheetlifo equationinternal controls accounts payablepercentage markup on costpresent value of a future annuity calculatoraccounting adjusting entries rulesformula asset turnoverexcel straight line depreciationaccounting quizzes with answersinsurance paid in advance journal entrybond repayment scheduleirr example exceldefine bank reconciliation statementirr formula in excelan adjusting entry iscorrecting entry accountingcalculating pvcash versus accrual accounting