deepcalc
DocsNOMINAL

NOMINAL

View as markdown/docs/functions/nominal.md Ask Claude about this pageOpens Claude with this page's address

Returns annual nominal interest rate.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Number

Examples

=NOMINAL(0.0535, 4)
Result 0.05245896887914281

Syntax

NOMINAL(effect_rate, npery)
effect_rate
number required
npery
number required
ACCRINTAccrued interest for a security paying periodic interest. ACCRINTMAccrued interest for a security paying at maturity. AMORDEGRCDepreciation per period, French accounting, degressive. AMORLINCDepreciation per period, French accounting, linear. COUPDAYBSDays from coupon period start to settlement. COUPDAYSDays in the coupon period containing settlement.