Calculates the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
EFFECT(nominal_rate, npery)The EFFECT function is used to determine the actual interest rate earned or paid on an investment or loan when compounding occurs multiple times per year. It converts a nominal rate into an effective annual rate, allowing for easier comparison between different financial products. The result is calculated using the formula: (1 + nominal_rate / npery) ^ npery - 1.
=EFFECT(0.06, 4)Ergebnis: 0.06136355
Calculates the effective rate for a 6% nominal rate compounded quarterly.
Excel will truncate the value to an integer.