Question
A 4-year 6%pa semi-annual coupon-paying bond has just been issued and is trading at a yield of 7.5%pa. If the bond has a face value
A 4-year 6%pa semi-annual coupon-paying bond has just been issued and is trading at a yield of 7.5%pa. If the bond has a face value of $100, calculate the following using Excel:
a) Calculate the current value of the bond. (3 marks)
b) Calculate the Macaulay duration of the bond. (6 marks)
c) Assume the yield decreases to 6.7%pa. Using your duration measure, what is the estimated value of the bond? (3 marks)
d) Calculate the convexity of the bond at a yield of 7.5%pa. (5 marks)
e) Assume the yield falls to 6.7%pa. Using your duration and convexity measure, what is the estimated value of the bond? (3 marks)
f) Calculate the actual value of the bond when the yield falls to 6.7%pa. and comment on your result compared to your answers to questions (c) & (e). (3 marks)
Please use the one excel document to answer all parts of the question.
Step by Step Solution
3.40 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
Apologies but as a textbased AI model I am unable to directly interact with or use external software like Excel However I can provide you with the for...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