How to calculate the effective interest rate
/The effective interest rate is the usage rate that a borrower actually pays on a loan. It can also be considered the market rate of interest or the yield to maturity. This rate may vary from the rate stated on the loan document, based on an analysis of several factors; a higher effective rate might lead a borrower to go to a different lender. These factors are the number of times the debt is compounded during the year, the actual amount of interest paid, and the amount the investor paid for the debt.
When only incorporating the impact of compounding on the interest rate, the steps required to calculate the effective interest rate are as follows:
Locate in the loan documents the compounding period. It is likely to be either monthly, quarterly, or annually.
Locate the stated interest rate in the loan documents.
Enter the compounding period and stated interest rate into the effective interest rate formula, which is:
r = (1 + i/n)^n-1
Where:
r = The effective interest rate
i = The stated interest rate
n = The number of compounding periods per year
Related AccountingTools Courses
Example of Calculating the Effective Interest Rate
As an example, a loan document contains a stated interest rate of 10% and mandates quarterly compounding. By entering this information into the effective interest rate formula, we arrive at the following effective interest rate:
(1 + 10%/4)^4-1 = 10.38% Effective interest rate
The format we presented for the effective interest rate can be used as an Excel formula.
How to Use the Effective Interest Rate
Conducting a complete analysis of the effective interest rate could be quite illuminating for a borrower, who may find that a prospective borrowing arrangement involves an effective rate so high that it should be avoided. The concept is also useful for comparing several alternative lending or borrowing arrangements that incorporate different interest rate calculations. You should conduct this analysis whenever you have received several lending offers, and need to determine which one represents the best possible deal.
Additional Factors to Consider
There are other circumstances that can alter the interest rate paid to an even greater extent. Consider the additional factors noted below:
Additional fees. The borrower may pay additional fees that are disguised forms of interest expense. These fees are worth including in the calculation, if they are material. A lender separates out these additional fees in order to drive down the stated interest rate on a loan - a practice that is more likely to attract a borrower.
Altered amount lent. If the investor does not agree that the market interest rate matches the stated interest rate to be paid by the borrower, the investor can bid less or more than the face amount to acquire the debt. Thus, if the market interest rate is higher than the face amount of the debt instrument, the borrower pays less for the debt, thereby creating a higher effective yield. Conversely, if the market interest rate is lower than the face amount of the debt instrument, the borrower is willing to pay more for the debt.
Related Articles
The Difference Between Simple Interest and Compound Interest