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

You may find assistance here

http://www.businessfunctions.com/

An add-in for Excel with over 500 business/financial functions all free

Tryo

"Ditera" wrote in message
...
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.