Explore BrainMass

Bonds- Price, YTM, Duration

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

Solution Summary

Price, Yield to Maturity and Modified Duration of a Bond Issue using Excel worksheet functions.