# How to compute effective interest rate in excel

**How to Calculate The Effective Interest Rate in Excel? Effective Interest Rate Infinite in MS Excel**

The function has given to the effective monthly rate of %. For the calculating of the nominal rate to the result need multiply by 12 (the term of loan).

EFFECT (nominal_rate,npery) is related to NOMINAL(effect_rate,npery) through effective_rate=(1+(nominal_rate/npery))*npery Example. Copy the example data in.

### How to compute effective interest rate in excel - Oct 10, · How to Calculate the Effective Interest Rate in Excel? Effective Interest Rate Infinite in MS www.keem-chee.ru the calculation of this rate, we need nominal interes.

### How to compute effective interest rate in excel - Oct 10, · How to Calculate the Effective Interest Rate in Excel? Effective Interest Rate Infinite in MS www.keem-chee.ru the calculation of this rate, we need nominal interes.

### VIDEO

Bond Effective Interest Rate Calculation Using Internal Rate Of Return (Excel Function)
=LAMBDA(opening_balance, base_rate, [interest], LET(_int, IF(ISOMITTED(interest), 0, interest), _new_close, opening_balance + _int, _avg_balance, AVERAGE(opening_balance, .

Rather useful idea

Earlier I thought differently, thanks for the help in this question.

I can not take part now in discussion - there is no free time. I will be free - I will necessarily express the opinion.

I apologise, but, in my opinion, you are mistaken. Let's discuss it. Write to me in PM.

I can not participate now in discussion - it is very occupied. But I will be released - I will necessarily write that I think.