NOMINAL
Definition
Calculates the annual nominal interest rate given the effective rate and number of compounding periods per year.
Sample Usage
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.
In order to use the NOMINAL formula, start with your edited Excellentable:
A
|
B
|
C
|
D
|
|
|---|---|---|---|---|
1
|
||||
2
|
||||
3
|