The NOMINAL function in Excel is a financial formula used to calculate the nominal annual interest rate given the effective annual interest rate and the number of compounding periods per year. The nominal rate is the stated interest rate of a loan or investment, while the effective rate is the actual rate of return or interest earned after accounting for compounding.
=NOMINAL(effect_rate, npery)
Where:
The result of the NOMINAL function is the nominal annual interest rate, which is expressed as a percentage rate per year, compounded npery times.
For example
=NOMINAL(B4,C4)
The formula =NOMINAL(B4,C4) is using the NOMINAL function in Excel to calculate the nominal annual interest rate, given the effective annual interest rate and the number of compounding periods per year. Here's what each argument of the function represents:
The result of this formula will be the nominal annual interest rate, expressed as a percentage rate per year, compounded C3 times.
For example, if cell B4 contains an effective annual interest rate of 6% and cell C4 contains the number of compounding periods per year of 12 (monthly compounding), then the formula =NOMINAL(B4,C4) will return the nominal annual interest rate, compounded monthly, as
The NOMINAL function is a useful tool for converting the effective annual interest rate into the nominal annual interest rate, taking into account the compounding periods per year. It is often used in financial analysis and investment planning to compare different financial instruments and understand their true cost or return after accounting for compounding.
The result of this formula would be the nominal annual interest rate of 5.84%, compounded monthly.
Learn All in Tamil © Designed & Developed By Tutor Joes | Privacy Policy | Terms & Conditions