MicroStrategy ONE
Effect (Effective Annual Interest Rate)
Returns the effective annual interest rate on a given amount. This is the actual annual rate or yield on a loan.
Syntax
Where:
NominalRate is the nominal 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
- NominalRate £ 0
- Npery <= 1.