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

How to Calculate the Effective Interest Rate in Excel? Effective Interest Rate Infinite in MS Excel.
For the calculation of this rate, we need nominal interest rate & Number of the years compounding numbers. We use EFFECT function in Excel to calculate the effective interest rate annually, semiannually, monthly, semimonthly, weekly, semiweekly, daily, hours, minutes and infinite as well.

For the Effective Interest Rate Infinite in MS Excel, we use an indirect way to calculate it. Because of excel EFFECT function is not supporting in the infinite case. I explained step by step infinite cases in this video as well.

If you have still confusion, Please comments below. I will explain to you again.
Here is the link for other Excel tutorial:
How to calculate GPA and CGPA? (Grade Point Average) | HD
bit.ly/2D3moCb
How to get A+ in an accounting class?
bit.ly/2S3Kw1L
Basic Accounting in 10 minutes
bit.ly/2BgSIl0
Sales Budget: Definition & Examples
bit.ly/2S3PZ8T
How to Make a Purchase budget?
bit.ly/2GzPhcq
How to Prepare A Direct Labor Budget with Example & Direct Labor Formula
bit.ly/2UUYdNs
How to make a resume with Microsoft Word
youtu.be/XbSQ6UlUx6s

Social engagement:
Facebook: bit.ly/33cQBdo
Don't forget to subscribe to us.
Subscribe us: youtube.com/accountingplus
We are waiting for your feedback in the comments.
Thanks