EFFECT function - The function of calculating the annual real interest rate in Excel
The following article details how to use the EFFECT function - The annual real interest rate calculation function which is very helpful for accountants and offices.
Description: The EFFECT function helps you to calculate the actual interest rate to be paid in each year.
Syntax: EFFECT (nominal_rate, npery) .
Inside:
- Nominal_rate : Nominal annual interest rate, is a required parameter.
- Npery : The number of periods for compounding in each year, which is the required parameter.
Attention:
- The calculation formula of EFFECT function is as follows:
- The parameters must be numeric values otherwise the #NUM !.
- If 1 of the above 2 parameters is less than 0 => The function returns the #NUM! Error value.
- Where Npery is a function decimal, it will take the integer value of Npery.
For example:
With the following data sheet, calculate the interest rates payable for investments.
In the cell to be calculated enter the following formula: = EFFECT (D6, D7) .
After pressing Enter the result is:
So you have to pay nominally at the interest rate of 0.06% but in fact you have to pay the annual interest rate of 0.06090 => there arises extra.
Above is a detailed guide on how to use the EFFECT function, hoping you can calculate it correctly and get the investment with the lowest interest rate.
Good luck!
You should read it
- How to use the MOD function and QUOTIENT function in Excel
- How to use the SUM function to calculate totals in Excel
- How to use the SUBTOTAL function in Excel
- NPER function - The function calculates the period number of an investment in Excel
- TBILLYIELD function - The function calculates the discount rate for a bond in treasury in Excel
- PMT function in Excel - Usage and examples
- COUPNUM function - The function returns the number of interest payments on a security in Excel
- Intrate function - Calculate interest rates in Excel
May be interested
- PMT function in Excel - Usage and examplesthe pmt function is one of the built-in financial functions of the excel software used to calculate the payment for a loan based on regular payments and a constant interest rate. the pmt function is not only useful for businesses, but also very practical for users if you want to calculate a loan.
- The easiest way to calculate the percentage (%)calculating percentages on excel doesn't have to use excel functions, it's just a normal calculation. so how to calculate the fastest percentage, and also need the most accurate. the following article will guide you how to calculate the most accurate percentage value.
- FVSCHEDULE function - Returns the future value of an investment that has variable or adjustable interest in period in Excelthe following article details the meaning and usage of the fvschedule function - returns the future value of an investment that has an interest rate that changes or can be adjusted periodically in excel.
- COUPNUM function - The function returns the number of interest payments on a security in Excelin the process of investing in securities, paying special interest is very important. it helps you calculate and plan a reasonable calculation and investment. the following article details the coupnum function - the function returns the number of interest payments of securities in excel.
- What is the CORREL function in Excel?data can be overwhelming, but excel's correl function helps you cut through the noise. calculating the correlation coefficient is the secret weapon for uncovering hidden trends and making smarter decisions.
- How to calculate the interest rate for bank depositsbank deposits are now one of the safest and most secure ways to invest. currently, in addition to direct transactions at the bank, some banks also have a service of saving money directly through the electronic banking application.
- STDEVP function - The function of calculating standard deviations in Excelthe following article details how to use the stdevp function in excel, which helps you calculate standard deviations based on patterns.
- Tips for quickly calculating Totals in Exceltips for quickly calculating totals in excel
- MS Excel 2007 - Lesson 6: Calculation in Excelexcel supports many calculation functions, logic functions for calculating, filtering, collating and analyzing data. this is also a feature that makes excel an indispensable tool for office jobs. in this article, tipsmake.com will show you how to use the overview calculation function in excel 2007.
- DURATION function - The function returns the periodic periodic interest payments in Excelthe following article details how to use the duration function to determine the period of periodic interest payment.