|
|
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% |
|
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 |
|
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 |
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 Home - Answers FAQ - Terms of Service - Privacy Policy |