Google Answers Logo
View Question
Q: Bond valuation and yield to maturity ( Answered 5 out of 5 stars,   0 Comments )
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

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!!!
Subject: Re: Bond valuation and yield to maturity
Answered By: omnivorous-ga on 12 Feb 2005 08:21 PST
Rated:5 out of 5 stars
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

If you?re uncertain about the definition of this bond yield, see the
section on ?Bonds? for a precise definition of Yield-to-Maturity
?Investment Management?


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):

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:

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.


How many can Mark buy with $20K?

Bond A = $20,000/$783.71 = 25.52
Bond B = $20,000/$1,072.10 =  18.66


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.


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
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


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,


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,

help123-ga rated this answer:5 out of 5 stars and gave an additional tip of: $1.00

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy