 # Get instant live expert help on how to calculate effective interest rate in excel “My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I-Bar Co. sold bonds on January 1, 2012. The bonds pay interest on January 1 and July 1 and I-Bar. Data relating to these bonds are as follows: Face \$100,000 Stated Rate 8% Issued at 92.278% Effective Rate 10% Instructions: a) Calculate the Semi Annual Bond Interest Rates b) Calculate the Cash Received from the Bond Sale Annual Semi-Annual Stated Rate Effective Rate Cash Received
Solved by S. A. in 13 mins
Calculate, in cell D20, the interest amount for period 1 by multiplying the balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by 12. Dividing the interest rate by 12 results in the monthly interest rate. This formula is reusable. The interest for a given period is always the monthly interest rate times the balance from the previous period. [3 points]
Solved by X. W. in 16 mins
Calculate the periodic interest rate in cell E3. I am only aloud to use absolute references.
Solved by D. H. in 24 mins
I need to use the VLOOKUP function to calculate interest rate
Solved by T. E. in 25 mins
hi, I need help with a formula to calculate interest btw 2 periods with an annual interest rate and semi-annual compounding?
Solved by K. J. in 23 mins