Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to compute coupon amount for bond? | Excel Discussion (Misc queries) | |||
How to compute coupon amount for bond? | Excel Discussion (Misc queries) | |||
what is a coupon rate and ytm of a bond? | Excel Worksheet Functions | |||
Bond duration for monthly coupon | Excel Worksheet Functions | |||
Bond YTM if Coupon Payment is at Maturity? | Excel Discussion (Misc queries) |