How To Calculate Effective Interest Rate On Bonds Using Excel?
In cell C35, we calculated the internal rate of return or effective interest rate for these cash flows using Excel’s IRR function: =IRR (C29: C34). The internal rate of return, also known as the effective interest rate, is 3.88 percent. As you can see, there is a significant difference between purchasing a bond at a […]
How To Calculate Effective Interest Rate On Bonds Using Excel? Read More »
