MicroStrategy ONE
Nominal annual interest rate
Returns the nominal annual interest rate on an investment, based on the effective rate and the number of compounding periods per year. This is the interest rate that is not adjusted for actual or expected inflation.
Syntax
Where:
EffectiveRate is the effective interest rate.
Npery is the number of compounding periods per year.
Expression
Usage Notes
If Npery is not an integer, it is truncated.
The engine returns an empty cell if
- Either argument is nonnumeric
- EffectiveRate £ 0
- Npery < 1