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. |
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. |
All times are GMT +1. The time now is 02:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com