Bonds- Price, YTM, Duration
Not what you're looking for?
Please show the steps as I am unable to get the answer for this question. Completed the rest this is the only one I have not been able to complete.
Abacus Inc. has asked you price a 5 year bullet bond issue for them, with Price, Yield to Maturity and Modified Duration. There are no comparable existing issues in the secondary market either by Abacus or a competitor and so you will need to price the issue from scratch.
You have the following set of US Treasury bond data and consultations with your Banks Equity Analyst and Debt Analyst suggest that a Z-spread for Abacus of 200 bps over Treasuries and a coupon rate of 6.5% should be appropriate to attract investors.
US Treasury Notes Coupon Yield to Maturity Zero coupon rate
1 Year 3.25% 3% 3%
2 Year 3.80% 3.25%
3 Year 4.5% 3.5%
4 Year 5% 4%
5 Year 6% 4.5%
You can assume that coupon payments are annual and that you are pricing on a coupon day (no accrued interest) and you may ignore basis conventions.
You should make your process and methodology clear with explanations at each stage.
Assignment hint: You will need to use the T-Note data to bootstrap a zero coupon treasury curve and apply the Z-spread to price the Abacus bond. You might find it easier to use the PV and RATE functions in Excel rather than PRICE and YIELD (but both will work).
Purchase this Solution
Solution Summary
Price, Yield to Maturity and Modified Duration of a Bond Issue using Excel worksheet functions.
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Basics of corporate finance
These questions will test you on your knowledge of finance.