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

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

  1. 5.25% compounded quarterly

    ABCD
    1QuotedPer year
    25.25%45.354%

    In D2: =EFFECT(A2, B2) → 5.354%

    Try this example

  2. 12% compounded monthly

    ABCD
    1QuotedPer year
    212%1212.683%

    In D2: =EFFECT(A2, B2) → 12.683%

    Try this example

Common mistakes

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.

Translate a whole formula

Try EFFECT in the playground

Related functions