Funkcja Arkuszy Google

NOMINAL

Returns the annual nominal interest rate for a given effective interest rate and number of compounding periods per year.

Wygeneruj formułę z SI Ta sama funkcja w Excelu

Ta funkcja działa w Arkuszach Google tak samo jak w Excelu — ta sama składnia i argumenty.

Składnia

NOMINAL(effect_rate, npery)

The NOMINAL function calculates the nominal rate based on the effective annual rate. It is the inverse of the EFFECT function, allowing you to determine the base rate before compounding effects are applied.

Argumenty

effect_ratewymaganeThe effective annual interest rate.
nperywymaganeThe number of compounding periods per year.

Przykłady

=NOMINAL(0.0535, 4)

Wynik: 0.05245

Calculates the nominal rate for an effective rate of 5.35% compounded quarterly.

Najczęstsze pytania

What is the difference between nominal and effective rates?

The nominal rate is the stated interest rate without compounding, while the effective rate accounts for the impact of compounding within the year.

Powiązane funkcje

EFFECT RATE NPER