Question
9. a. Youre considering buying a 10 year US Treasury 7% coupon bond with a face value of $1000. The bond pays coupons semi-annually. The
9.
a. Youre considering buying a 10 year US Treasury 7% coupon bond with a face value of $1000. The bond pays coupons semi-annually. The next coupon will be paid in 6 months. The bond is currently selling for $977.12. Using Excels IRR command, determine the YTM of the bond. Express your answer as an effective annual rate (EAR). (Not at an APR).
Report your answer as a decimal, not as a percent, using at least 4 significant digits.
Hint: Be careful here. Because youll need to express the cash flows with a 6 month frequency, the IRR command will return the YTM expressed as an effective 6-month rate.
b. Youre considering buying a 7 year US Treasury 3% coupon bond with a face value of $1000. The bond pays coupons semi-annually. The next coupon will be paid in 6 months. The bond has a YTM of 7.4% when expressed as an effective annual rate (EAR). Determine the price of the bond. Express you answer in dollars and cents.
HINT: If you use Excels NPV command, remember that it must not include the cash flow at t = 0. If you do the computation by hand, be sure to keep the accuracy of your computations high. Id suggest you do both in order to check your answer before you enter it
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started