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

Andrew is a Docs and Sheets expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?
How can we improve it?