“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

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