Calculates the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 0.06136355
Calculates the effective rate for a 6% nominal rate compounded quarterly.
Excel will truncate the value to an integer.