Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Art Art is offline
external usenet poster
 
Posts: 587
Default what is a coupon rate and ytm of a bond?


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 623
Default what is a coupon rate and ytm of a bond?

It depends on the price you pay.

If you're asking how to calculate same, check out the Yield and Price functions.

--
Regards,
Fred


"art" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,574
Default what is a coupon rate and ytm of a bond?

Coupon rate is the interest rate paid on the bond.

Yield to maturity is the sum of the interest payments made on the bond until
maturity, at which time the bond itself is redeemable for its face value.

Yield to maturity takes into consideration the current market price of the
bond, the coupon rate, the time to maturity, and assumes interest payments
are reinvested at the bond's coupon rate.

For details on how these are calculated, google the terms and see what you
come up with. Investopedia.com and Wikipedia are decent places to start for
finance topics.
--
Brevity is the soul of wit.


"Fred Smith" wrote:

It depends on the price you pay.

If you're asking how to calculate same, check out the Yield and Price functions.

--
Regards,
Fred


"art" wrote in message
...




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



All times are GMT +1. The time now is 11:18 AM.

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

About Us

"It's about Microsoft Excel"