The ►Nom( command converts from an effective interest rate to a nominal interest rate. In other words, it converts an interest rate that takes compounding periods into account into one that doesn't. The two arguments are 1) the interest rate and 2) the number of compounding periods.
For example, you want to know the interest rate, compounded monthly, that will yield a total increase of 10% per year:
The formula for converting from an effective rate to a nominal rate is:(1)
Here, Eff is the effective rate, Nom is the nominal rate, and CP is the number of compounding periods.
- ERR:DOMAIN is thrown if the number of compounding periods is not positive, or if the nominal rate is -100% or lower (an exception's made for the nominal rate if there is only one compounding period, since ►Nom(X,1)=X).