Скачать или смотреть NOMINAL & EFFECT Function in 3 Mins l Professional Excel l Day-55

Here description Nominal and Effect function:
1. Nominal Function:
The `NOMINAL` function in Excel is used to calculate the nominal interest rate given the effective interest rate and the number of compounding periods per year.
The syntax of the `NOMINAL` function is:
=NOMINAL(effect_rate, npery)
`effect_rate`: The effective interest rate per period.
`npery`: The number of compounding periods per year.
Example:
=NOMINAL(0.06, 12)
This formula calculates the nominal interest rate for an effective interest rate of 6% compounded monthly (12 times a year).
2. Effect Function:
The `EFFECT` function, on the other hand, is used to calculate the effective interest rate given the nominal interest rate and the number of compounding periods per year.
The syntax of the `EFFECT` function is:
=EFFECT(nominal_rate, npery)
`nominal_rate`: The nominal interest rate per period.
`npery`: The number of compounding periods per year.
Example:
=EFFECT(0.05, 4)
This formula calculates the effective interest rate for a nominal interest rate of 5% compounded quarterly (4 times a year).