Excel functions / Financial
EFFECT function
The yearly rate you really pay or earn, once interest is added several times a year.
Syntax
=EFFECT(nominal_rate, npery)
Arguments
nominal_rate: The quoted yearly rate.npery: How many times a year interest is added.
When to use it
EFFECT turns a quoted yearly rate into the effective rate once compounding is counted. 12% compounded monthly earns more than 12% in a year, because each month's interest earns interest too.
Examples
5.25% compounded quarterly
A B C D 1 Quoted Per year 2 5.25% 4 5.354% In D2:
=EFFECT(A2, B2)→ 5.354%12% compounded monthly
A B C D 1 Quoted Per year 2 12% 12 12.683% In D2:
=EFFECT(A2, B2)→ 12.683%
Common mistakes
- Periods per year. The second argument is how many times a year interest is added, not the number of years.
EFFECT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: EFFECT
- Danish: EFFEKTIV.RENTE
- Dutch: EFFECT.RENTE
- Finnish: KORKO.EFEKT
- French: TAUX.EFFECTIF
- German: EFFEKTIV
- Hungarian: TÉNYLEGES
- Italian: EFFETTIVO
- Norwegian: EFFEKTIV.RENTE
- Polish: EFEKTYWNA
- Portuguese (Brazil): EFETIVA
- Portuguese (Portugal): EFETIVA
- Russian: ЭФФЕКТ
- Spanish: INT.EFECTIVO
- Swedish: EFFRÄNTA
- Turkish: ETKİN