Google Answers Logo
View Question
 
Q: Zero Coupon Bonds ( Answered,   2 Comments )
Question  
Subject: Zero Coupon Bonds
Category: Business and Money > Finance
Asked by: hatenumbers-ga
List Price: $2.50
Posted: 19 May 2004 06:16 PDT
Expires: 18 Jun 2004 06:16 PDT
Question ID: 348731
Fill in the table below for the following zero coupon bonds. The face
value of each bond is $1000.
Price            Maturity             Yield to Maturity
$300                30                    ?
$300                 ?                    8%
?                    10                   10%
Answer  
Subject: Re: Zero Coupon Bonds
Answered By: omnivorous-ga on 19 May 2004 07:49 PDT
 
Hatenumbers --

Each of these takes advantage of the formula:

Price * (1.X)^years = $1,000

where, x = percentage (in decimals)
^ years = is the settlement price raised as an exponent (the ^ sign) each year
and $1,000 is the bond price at maturity

It means that you'll need to take roots.  In question #1 you'll be
taking the 30th root on your calculator -- or you can use the POWER
function in Microsoft Excel and raise a number to the 1/30 POWER
(which is the same thing).

I've showed the progress and done the work partially in Excel here. 
This should be viewable in any browser, even if you don't have Excel:
http://www.mooneyevents.com/YTM1.xls

Excel has some YIELD and TBILLYIELD functions that do the same thing
but requires that you have the Analysis Toolpak loaded.  Even then, I
couldn't get the TBILL functions to work.

Best regards,

Omnivorous-GA
Comments  
Subject: Zero Coupon Bonds
From: sleepcut-ga on 11 Jun 2004 10:22 PDT
 
This is great information.  Can you expand a bit on how you go "B". 
Even on your spreadsheet I had difficulty understanding the formula.

Thanks
ZC
Subject: Re: Zero Coupon Bonds
From: sleepcut-ga on 11 Jun 2004 12:32 PDT
 
Specifically the 1/x = .064

I have tried every combination of calculations I can think of for this
and don't understand it in the least.

ZC

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 answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


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