Question
Suppose settlement is on a coupon payment date, so / = 0. For a 10-Year, 6% annual payment bond with face value =$100. Assume the
Suppose settlement is on a coupon payment date, so / = 0. For a 10-Year, 6% annual payment bond with face value =$100. Assume the yield-to-maturity is = 5%. a. (15 points) Calculate bond price , Macaulay duration, and convexity by filling in the following blanks: 1. 0 = ( = 100, = 6%, = 10, = 5%) =______________. 2. =______________, 3. =______________.
Suppose we have a small interest rate (yield) move: = +0.01%. Calculate the new bond price + for + = + = 5.01% . Then calculate the price change: = + 0 . Finally, use Duration and Convexity calculated in part a to approximate the price change . Which approximation is closer to the real ? You should simply follow the steps below: 1. + = ( = 100, = 6%, = 10, = 5.01%) = _____________. 2. = + 0 = ______________ ______________ = ______________. 3. 1 = 0 = (+0.01%) ______________ ______________ = ______________. 4. 2 = 1 + 1 2 () 2 0 = ______________ + 0.5 (0.01%) 2 ______________ ______________ = ______________. Page 2 of 3 5. ______________ (choose 1 or 2) is closer to .
please show the excel works
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