NOMINALCalculates 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