The NOMRATE function
returns the nominal annual interest rate. NOMRATE computes the nominal
annual interest rate that corresponds to an effective annual interest
rate.
The following details
apply to the NOMRATE function:
-
The values for rates must be at
least –99.
-
In considering an effective interest
rate and a compounding interval, if
compounding-interval is 'CONTINUOUS', then the value that is returned by NOMRATE equals
loge(1+[rate/100]).
If
compounding-interval is not 'CONTINUOUS', and
m intervals occur in a year, the value that is
returned by NOMRATE equals the following:
-
The following values are valid
for
compounding-interval:
-
If the interval is 'DAY', then
m=365.