NOMINAL

Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.

Sample Usage

NOMINAL(0.85,12)

NOMINAL(A2,A3)

Syntax

NOMINAL(effective_rate, periods_per_year)

  • effective_rate - The effective interest rate per year.

  • periods_per_year - The number of compounding periods per year.

See Also

INTRATE: Calculates the effective interest rate generated when an investment is purchased at one price and sold at another with no interest or dividends generated by the investment itself.

EFFECT: Calculates the annual effective interest rate given the nominal rate and number of compounding periods per year.

Examples

Was this helpful?
How can we improve it?
Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
true
true
true
true
35
false