View Question
Q: Bond valuation and yield to maturity ( Answered ,   0 Comments )
 Question
 Subject: Bond valuation and yield to maturity Category: Business and Money > Finance Asked by: help123-ga List Price: \$15.00 Posted: 11 Feb 2005 05:34 PST Expires: 13 Mar 2005 05:34 PST Question ID: 472843
 ```Mark Goldsmith's brooker has shown him two bonds. Each has a maturity of 5 years, a par value of \$1,000, and a yeild to maturity of 12%. Bond A has a cupon intrerest rate of 6% paid annually. Bond B has a cipon interest rate of 14% paid annually. a) Calculat the selling price for each of the bonds. b) Mark has \$20,000 in invest. Judging on the basis of the price of the bonds, how many of either one could Mark purchase if he were to choose ot over the other? (Mark cannot really purchase a fraction of a bond, but for the purposes of the question, pretend that he can.) c) Calculate the yearly interest income of each bond on the basis of its cupon rate and the number of bonds that Mark could buy with his \$20,000 d) Assume that Mark will reinvest the interest payments as they are paid (at the end of each year) and that his rate of return on the reinvestment is only 10%. For each bond, calculate the value of the principal payment plus the value of Mark's reinvestment account at the end of the 5 years. c) Why are the two values calculated in part d different? If Mark were worried that he would earn less than the 12% yield to maturity on the reinvested interest payments, which of these two bonds would be a better choice?``` Clarification of Question by help123-ga on 11 Feb 2005 16:18 PST `Oh yeah, I need the answer by tomorrow!!!`
 ```Help123 ? Dividend paying bonds and yield-to-maturity are one of the more-difficult financial calculations to model, in part because of the problem of dividend reinvestment which is brought up in (d) of your question. Even if we?re earning 12% today ? who says dividends will be reinvested at that rate? Also, from a mathematical standpoint it can involve a number of ?attempts? or iterations to get close to the right interest rate. Luckily we have spreadsheets to do the heavy lifting and this solution is aided by using the PRICE or YIELD functions in Microsoft Excel. I?ve provided a linked spreadsheet, which is viewable in your browser, and if you have Excel you can even change the entries for different assumptions. If you?re uncertain about the definition of this bond yield, see the section on ?Bonds? for a precise definition of Yield-to-Maturity (YTM): QuickMBA.com ?Investment Management? http://www.quickmba.com/finance/invest/ SECTION A ========== I?m going to calculate the bond price two ways ? one using NPV and discount factors. In the second, we?ll check the result using Excel?s PRICE function. You?ll find models for Bond A and Bond B at the top and we?ve taken the cash flows and applied NPV discount factors to them to arrive at today?s selling price. (If there are any questions about how Net Present Value works to discount tomorrow?s dollars to an equivalent today, please use ask for a Clarification before rating this answer): http://www.mooneyevents.com/YTM2005.xls You?ll see that I?ve checked the math, using Excel?s PRICE function, where the entries are defined in the following way. It?s important to note that while bonds are typically figured per \$1,000 of value, for some reason Excel treats everything adjusted to a ?per \$100? value: PRICE(settlement,maturity,rate,yld,redemption,frequency,basis) So, multiplying the Microsoft Excel numbers by 10, you?ll see that they check. Bond A = \$783.71 Bond B = \$1,072.10 And it makes sense ? the coupon rate of bond B is higher than the YTM ? so the present value of the flow of dividends is greater than the cash value of the dividends themselves. SECTION B ========== How many can Mark buy with \$20K? Bond A = \$20,000/\$783.71 = 25.52 Bond B = \$20,000/\$1,072.10 = 18.66 SECTION C =========== Bond A = 25.52 * \$60 = \$1,531.20 Bond B = 18.66 * \$140 = \$2,612.40 Note that this assumes nothing about the re-investment of interest payments. Section D will get to that issue. SECTION D ========== Note that each year your dividends are accumulating in an account and being reinvested, so we?ll go BACK to the spreadsheet to calculate the totals: Bond A: Annual dividend: \$1,531.20 Principal: \$25,520 Dividends reinvested: \$9,348.13 TOTAL = \$34,868.13 Bond B: Annual dividend: \$2,612.40 Principal: \$18,660 Dividends reinvested: \$15,948.96 TOTAL = \$34,608.96 SECTION E ========== WHY ARE THE 2 DIFFERENT? First let?s talk about when they?d be the same ? it would be when interest rates (the yield-to-maturity is 12%). There?s a discount of \$6,660 built into the purchase price Bond A because of its lower interest rate ? and it gets paid back at 12% over the life of the bond. Bond B has a higher current yield at 14% -- if that money doesn?t get reinvested at a minimum of 12% Bond A will win out in the long-term due to the initial purchase discount. This is an excellent exercise in time value. If you have any questions, please let me know via a clarification request. Best regards, Omnivorous-GA``` Clarification of Answer by omnivorous-ga on 12 Feb 2005 08:25 PST ```Help123 -- That section E paragraph should read: > WHY ARE THE 2 DIFFERENT? First let?s talk about when they?d be the > same ? it would be when interest rates are the SAME at 12% (the > yield-to-maturity is 12%). Best regards, Omnivorous-GA```
 help123-ga rated this answer: and gave an additional tip of: \$1.00 `Thanks!!!`