How to Interpret Investinginbonds.com Reported Yield on Bond Trades?

Financial Planning - Financial planning in general. (Moderated) 

get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
How to Interpret Investinginbonds.com Reported Yield on Bond Trades? Will 10-07-2008
Posted by Will on October 7, 2008, 7:01 am


The Investinginbonds.com web site allows you to see a history of trades for
specific bonds. Here is two lines of a typical report, reformatted to
make it readable here:

Time of Trade: 10/02/2008 16:31:17
Price Paid: $94.480
Yield: 19.742%
Size: $4K

Time of Trade: 10/02/2008 16:30:55
Price Paid: $85.572
Yield: 45.404%
Size: $50K

What I don't understand in the above is how are they calculating the Yield?
It cannot be that the same bond that gives the same coupon payment would
have the yields they are reporting given the sale prices.

To see this, consider the first trade at $94.480 with yield of 19.742.
That implies a coupon payment of $18.65 (if it were a once per annum payment
with a 19.742% yield per annum).

For the second trade, if it were purchased at $85.572 and had the same
$18.65 coupon payment, then the effective yield should be reported as
21.795% and not 45.404%.

Clearly I am not reading this correctly. Can someone familiar with how
they calculate Yield here explain it to me?

--
Will

--------------------------------------
Misc.invest.financial-plan is a moderated newsgroup where Moderators strive
to keep the conversations on-topic for financial planning. Other posting
guidelines include a request for brevity and another for trimming posts to
which we respond. For all of the other tips and suggestions, see "FROM THE
MODERATORS: Posting to misc.invest.financial-plan", a weekly post now on the
Newsgroup.


Posted by catalpa on October 7, 2008, 12:15 pm



> The Investinginbonds.com web site allows you to see a history of trades
> for
> specific bonds. Here is two lines of a typical report, reformatted to
> make it readable here:
>
> Time of Trade: 10/02/2008 16:31:17
> Price Paid: $94.480
> Yield: 19.742%
> Size: $4K
>
> Time of Trade: 10/02/2008 16:30:55
> Price Paid: $85.572
> Yield: 45.404%
> Size: $50K
>

The yields are quoted as the lowest yield to call or maturity. The reported
yields are so high because of the discount below par and a short term to
maturity.

--------------------------------------
Misc.invest.financial-plan is a moderated newsgroup where Moderators strive
to keep the conversations on-topic for financial planning. Other posting
guidelines include a request for brevity and another for trimming posts to
which we respond. For all of the other tips and suggestions, see "FROM THE
MODERATORS: Posting to misc.invest.financial-plan", a weekly post now on the
Newsgroup.


Posted by Rich Carreiro on October 7, 2008, 12:25 pm



> The Investinginbonds.com web site allows you to see a history of trades for
> specific bonds. Here is two lines of a typical report, reformatted to
> make it readable here:
>
> Time of Trade: 10/02/2008 16:31:17
> Price Paid: $94.480
> Yield: 19.742%
> Size: $4K
>
> Time of Trade: 10/02/2008 16:30:55
> Price Paid: $85.572
> Yield: 45.404%
> Size: $50K
>
> What I don't understand in the above is how are they calculating the Yield?
> It cannot be that the same bond that gives the same coupon payment would
> have the yields they are reporting given the sale prices.

Looks like the reported yield is likely yield-to-maturity (YTM), *not*
coupon yield. Do some googling on "yield to maturity" as well as
"internal rate of return" and "net present value" (the YTM calculation
is essentially an IRR calculation, and that in turn depends on the NPV
concept).

--
Rich Carreiro rlc-news@rlcarr.com

--------------------------------------
Misc.invest.financial-plan is a moderated newsgroup where Moderators strive
to keep the conversations on-topic for financial planning. Other posting
guidelines include a request for brevity and another for trimming posts to
which we respond. For all of the other tips and suggestions, see "FROM THE
MODERATORS: Posting to misc.invest.financial-plan", a weekly post now on the
Newsgroup.


Posted by Will on October 8, 2008, 5:28 am


>
>> The Investinginbonds.com web site allows you to see a history of trades
>> for
>> specific bonds. Here is two lines of a typical report, reformatted to
>> make it readable here:
>>
>> Time of Trade: 10/02/2008 16:31:17
>> Price Paid: $94.480
>> Yield: 19.742%
>> Size: $4K
>>
>> Time of Trade: 10/02/2008 16:30:55
>> Price Paid: $85.572
>> Yield: 45.404%
>> Size: $50K
>>
>> What I don't understand in the above is how are they calculating the
>> Yield?
>> It cannot be that the same bond that gives the same coupon payment would
>> have the yields they are reporting given the sale prices.
>
> Looks like the reported yield is likely yield-to-maturity (YTM), *not*
> coupon yield. Do some googling on "yield to maturity" as well as
> "internal rate of return" and "net present value" (the YTM calculation
> is essentially an IRR calculation, and that in turn depends on the NPV
> concept).

Let's assume they are using Yield to Maturity. So my present value is what
I pay today, and I generate from that cash flows at each coupon date and
then on repayment of the par. From those cash flows one can calculate an
internal rate of return (IRR).

Having said that, I am still confused. The above two lines I gave were for
the *same bond* and the difference in time of the trade is less than 30
seconds. So even if one wants to construct a yield to maturity IRR, I
don't see how the second trade above gets a 45.4% yield to maturity but the
first trade gets only $19.742% Can the yield to maturity be so remarkably
different for such a small difference in the current bond price?

Can someone recommend any software that would take as input the CUSIP, and
would show as output the stream of expected cash payments, and a calculation
of the IRR for that CUSIP? Of course I can do that in Excel but being
able to enter in a large group of these bonds (say 25 to 100) and have the
software constantly update the YTM calculation against current trades would
be a wonderful tool to have.

--
Will


======================================= MODERATOR'S COMMENT:
The moderators would be in your debt if you were to trim the posts a little
tighter.

--------------------------------------
Misc.invest.financial-plan is a moderated newsgroup where Moderators strive
to keep the conversations on-topic for financial planning. Other posting
guidelines include a request for brevity and another for trimming posts to
which we respond. For all of the other tips and suggestions, see "FROM THE
MODERATORS: Posting to misc.invest.financial-plan", a weekly post now on the
Newsgroup.


Posted by Rich Carreiro on October 8, 2008, 1:55 pm



> >> Time of Trade: 10/02/2008 16:31:17
> >> Price Paid: $94.480
> >> Yield: 19.742%
> >> Size: $4K
> >>
> >> Time of Trade: 10/02/2008 16:30:55
> >> Price Paid: $85.572
> >> Yield: 45.404%
> >> Size: $50K

> Having said that, I am still confused. The above two lines I gave were for
> the *same bond* and the difference in time of the trade is less than 30
> seconds.

But there's a huge price difference between the trades. The later
trade price is almost 10% more than the earlier one. That's going
to have a significant effect on YTM.

--
Rich Carreiro rlc-news@rlcarr.com

--------------------------------------
Misc.invest.financial-plan is a moderated newsgroup where Moderators strive
to keep the conversations on-topic for financial planning. Other posting
guidelines include a request for brevity and another for trimming posts to
which we respond. For all of the other tips and suggestions, see "FROM THE
MODERATORS: Posting to misc.invest.financial-plan", a weekly post now on the
Newsgroup.


Similar ThreadsPosted
Any Brokers Allow Limit Orders on Bond Trades? October 8, 2008, 7:35 pm
Any Site That Graphs Freddie Mac Bond Trades? October 30, 2008, 2:40 pm
company car...what is the compensation reported to me? June 12, 2008, 6:47 am
Where to View Freddie Mac Trades? October 8, 2008, 3:25 pm
Yield Question March 3, 2007, 8:45 am
Yield Average Effect February 19, 2007, 5:02 am
Hope none of your clients were in Schwab Yield Plus April 8, 2008, 4:38 pm
inverted yield curve post-mortem June 1, 2008, 11:51 am
inverted yield curve post-mortem June 1, 2008, 12:06 pm
mutual funds or high yield savings account November 24, 2006, 11:29 am

other essential online resources:
United States Treasury
US Securities and Exchange Commission
New York Stock Exchange
Tokyo Stock Exchange
Accounting and Tax Software Forums

Contact Us | Privacy Policy   XML SitemapXML Sitemap