EFFECT
Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year
Syntax
EFFECT(nominal_rate, npery)
Parameters
- nominal_rate: Required. The nominal interest rate
- npery: Required. The number of compounding periods per year
Example
=EFFECT(0.0525, 4)