Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 11th 08, 03:03 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2008
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.

  #2   Report Post  
Old March 11th 08, 03:34 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2007
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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to compute coupon amount for bond? [email protected] Excel Discussion (Misc queries) 1 March 13th 07 02:43 PM
How to compute coupon amount for bond? [email protected] Excel Discussion (Misc queries) 0 March 13th 07 08:12 AM
what is a coupon rate and ytm of a bond? Art Excel Worksheet Functions 2 September 18th 06 01:44 PM
Bond duration for monthly coupon N. Excel Worksheet Functions 0 September 8th 06 10:36 PM
Bond YTM if Coupon Payment is at Maturity? Babar Ali Excel Discussion (Misc queries) 0 October 25th 05 02:05 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017