View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ditera Ditera is offline
external usenet poster
 
Posts: 1
Default how do you calculate the coupon rate of a bond in excel?

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.