Definition. This function calculates the nominal interest rate which (finance mathematically) leads to equivalence from a given effective interest rate.
Effect_Rate (required) The given effective annual interest rate, determined from the compound interest of an intra-annual yield.
Npery (required) The number of
interest periods per year. If the Npery argument is a number with decimal
places, it is truncated to an integer. The result must be greater than zero. Otherwise, NOMINAL()
returns the error
#NUMBER!. If one of the arguments is not a numeric expression
or if Effect_Rate is not positive, NOMINAL() also returns the
Background. For various financial transactions (such as mortgage ...