Learn how to calculate effective interest rate on bonds using Excel. Different effective interest rates get calculated using Excel functions.