Coupon Bond Worksheets
Coupon Bond Worksheets
10% Coupon Bond - yield to maturity = 10%
[pic]
[pic]
Click Here for a pic of the 10 Year from FRED
[pic]
Example from 11/4/2014
Consider the following from the WSJ
[pic]
Let us focus on the 3-year note - yield = .948 % (94.8 basis points)
We now go to Stock Trak to take a look at the price of this 3 year Gov security
[pic]
This 3 year note matures 10/31/2017 - the date of this spot price is 11/04/2014, close enough to three years.
Note that this note (ha ha!) has a coupon payment of 1.88%. We know that the 'current' yield (think of it as a snapshot) is .948 %. Since the coupon rate = 1.88% is greater than the current yield = .948, this bond will sell at a premium. The quoted price from stock trak is $1026.70, ...... $26.70 higher than par - of course, whenever the coupon rate is above the yield (from the WSJ), then the bond (note) will sell at a premium and vica versa.
Worksheet from excel - estimated price pretty close!
[pic]
Rate of Return vs yield
On to Chapter 6
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- coupon bond calculator
- short rate model coupon bond option
- coupon bond price formula
- coupon bond valuation calculator
- calculate coupon bond price
- zero coupon bond formula excel
- zero coupon bond calculator
- coupon bond equation
- coupon bond yield example
- annual coupon bond calculator
- yield to maturity zero coupon bond calculator
- zero coupon bond calculator excel