“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Can you get me the formula to calculate the interest as 0.08219178082 rate for 1,000,000 ?

Solved by T. C. in 12 mins