Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Financial Management

Authors: Eugene F. Brigham, Joel F. Houston

Concise 6th Edition

324664559, 978-0324664553

More Books

Students also viewed these Finance questions