Get instant live expert help on I need help with effective interest rate excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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
I have a problem regarding to The Interest Rate Function in Excel
Solved by E. Y. in 24 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
Someone took a loan for 7 months. The accrued interest was 122,2 and the interest rate 4,87 % (p.a.). What was the original loan capital?
Solved by G. H. in 23 mins