Nominal Interest Rate Formula

Formula

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

Use

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


petty cash book samplepayback method exampledebit cash credit accounts receivableexamples current liabilitiesreversing entries in accountinginvoice journal entrytriple column cash booksteps for accounting cycletraditional costing formulahigh asset turnovernpv excel calculationpercentage of completion spreadsheetsample vouchers templatespresent value annuity calculatorspreadsheet for accounting in small businessprofit margin formula in excelslm depreciationaccounting adjustment entriescompute effective interest ratewhat is the meaning of brs in accountingtypical journal entries accountinghow to do unadjusted trial balancebonds payable on balance sheetaccount receivable days formulawhat is payroll liabilitiesformula for horizontal analysishow to calculate annual depreciation expensecontra account listratio to unit rate calculatorhow to calculate discount factor in excelhow to find the contribution margincalculate gearing ratiodeclaring dividends journal entrydefine cushionscost markup formulasyd depreciationhow to calculate the retained earningshow to calculate markup costreducing balance method depreciation calculatorcommon size balance sheetsaccrued expenses vs accounts payableimpress cashformula for calculating gross profitdeferred rent assetcheque payment receipt formattypes of transactions in transactional analysisbep formulalifo vs fifo accountingassets liabilities capital equationjournal entry for accrued rentgearing ratio analysisfixed overhead expenditure variancebank reconciliation exercisebank reconciliations definitionthe accounting for cash discounts and trade discounts arelessor accounting for capital leaseannuity on excelinterest accrual journal entrycapital lease balance sheet exampleannuity excel formulabank overdraft current liabilitydefine daybookdefinition of return on capital employedgrowing annuitybank reconciliation journal entryformula for total contribution marginproforma of petty cash bookproforma of petty cash bookpv table annuity dueavailable for sale securities journal entriesinventory count templatewhat is accrued salariesdebtor turnover formulacontribution to sales ratiodouble entry cash book exampledefine unearned revenuenormal balance of accounts payablehow to do closing entries in accountingannuity due tablecash count definition