how do you calculate the coupon rate of a bond in excel?

D

Ditera

Can anyone tell me how you set up a formula in excel (2003) to find the
coupon rate for bonds, when given the # of periods(say 12), the selling price
of the bond, and the yield? I will appreciate your response.
Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel PRICE function: How does it compute Issue Date of the Security 5
Bond premium amortization using the constant yield method 1
How to calculate bond value and current yield 2
Excel finance function 1
Finance Formula Help 1
Building bonds amortization repayment plan in Access 0
How to calculate a bond price using Excel?? 1
How to compute coupon amount for bond? 0

Top