Message Font: Serif | Sans-Serif

No. of Recommendations: 0
Generally speaking I have my own little stubborn way of calculating effective annual yield. I just take the annual interest number and divide it by what I paid for the bond and presto. I know this is not the exact methodology but usually it comes pretty close when I compare to quote services.

Right now I came across these Berkshire Hathoway/Burlington Long term bonds.

Redemption 2045
Coupon 3.2%
Selling price \$60.50

The quoted yield is pretty close to 6%. However when I do the math (annual coupon of \$32 divided by selling price of \$605), I come up with 5.28%. Is there a quick way to properly account for something like these notes that are selling at such a steep discount to par to come up with 5.9% like its being quoted?

Thanks
No. of Recommendations: 0
Actually found a formula online that accounts for a scenario like this when you have such a deep discounted bond like this at such a long term redemption interval.

Adjusted Current Yield = Annual Coupon divided by market price * 100 + (100 - market price) divided by years to maturity
No. of Recommendations: 2
YTM,

Excel offers decent tools for calculating various types of yields. Poke around in the Formulas section to find them. Let's work an example. Assume you have downloaded a couple hundred bonds into a spreadsheet and you’re checking the broker-calculated yields. Assume your data is in columns A through D, one row per bond.

A B C D
1 Alcoa 5.870 02/23/22 60.647
2 3ShopKo 9.250 03/15/22 60.548
3 Burlington 3.200 01/01/45 60.200

=YIELD(today(), C1, B1/100, D1, 100, 2, 1)

Obviously, any fact about any bond could be put into any column of the spreadsheet, and any fact could be entered in many different formats. Also, “settlement” is T-3, not “trade date”. But that formula will get you going. E.g., if today is Thursday, 03/17/2011, and if the ASK is 60.500, and if you're buying a single bond at Fido and paying \$8 in commish, and if you want to get fussy about settlement, then the formula would look like this:

=YIELD("03/22/2011", "07/24/2045", 0.032, 61.300, 100, 2, 1)

where the syntax is YIELD(Settlement, Due, Coupon_Rate, Price, Par, Frequency_of_Coupon, Year_Type), and the YTM is 6.1% (if I haven't screwed up on my math).

Caution: In buying any bond, not just long-dated ones, you need to estimate the impact of inflation on yield. (But that's a post for another time.)
No. of Recommendations: 0
Thanks Charlie for the data.
No. of Recommendations: 0
YTM,

You'll find that, by and large, broker-calculated yields are close enough. But that, occasionally, what they are reporting is far different than what Excel suggests. Therefore, running your own numbers should become a part of your due-diligence.

Also, once the offering-list has been imported into Excel, a yield-curve can be built.

Charlie