![]() ![]() The generic formula for calculating EAR (in Excel formula syntax) is: =(1+i/n)^n–1 The EFFECT function returns the calculated EAR for each of the given periods. The nominal interest rate is provided in cell H4, which is the named range "rate".īecause named ranges behave like absolute references, this formula can simply be copied down the table. To demonstrate how this works, the table shown in the example is set up with various compounding periods in column C. The EFFECT function calculates the effective annual interest rate based on the nominal annual interest rate, and the number of compounding periods per year. In other words, the EAR is the rate actually earned due to the effect of compounding more frequently than once a year (annually). The Effective Annual Rate (EAR) is the interest rate after factoring in compounding.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |