Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider 3 Treasury bonds which pay semi-annual coupons. Bond A has 5 years remaining to maturity and a coupon rate of 10%. Bond B has

image text in transcribed

Consider 3 Treasury bonds which pay semi-annual coupons. Bond A has 5 years remaining to maturity and a coupon rate of 10%. Bond B has 20 years remaining to maturity and a coupon rate of 10%, and Bond C has 20 years remaining to maturity and a coupon rate of 4%.

If all bonds provided a 10% return (APR, compounded semiannually) if they were purchased today and held to maturity, what is the price today of each of the bonds? Essentially, what is the price of each bond if the YTM is 10%?

What is the price of each bond if the YTM was 4%? What if it was 16%

Using Excel, create a single graph showing the price of Bonds A & B for varying YTMs. Let YTM range from 0.5% to 18% per year (compounded semi-annually) in increments of 50 basis points (1 basis point is 1/100 of a percent ? thus examples of a 50 basis point change would be a change from 4.5% to 5% or 11.2% to 11.7%). Is the graph linear? If not, what shape is it? Does a change in YTM affect the price of each of the two bonds the same way? Why or why not?

Create a similar graph for Bonds B & C. Is the graph linear? If not, what shape is it? Does a change in YTM affect the price of each of the two bonds the same way? Why or why not?

image text in transcribed Consider 3 Treasury bonds which pay semi-annual coupons. Bond A has 5 years remaining to maturity and a coupon rate of 10%. Bond B has 20 years remaining to maturity and a coupon rate of 10%, and Bond C has 20 years remaining to maturity and a coupon rate of 4%. If all bonds provided a 10% return (APR, compounded semiannually) if they were purchased today and held to maturity, what is the price today of each of the bonds? Essentially, what is the price of each bond if the YTM is 10%? What is the price of each bond if the YTM was 4%? What if it was 16% Using Excel, create a single graph showing the price of Bonds A & B for varying YTMs. Let YTM range from 0.5% to 18% per year (compounded semi-annually) in increments of 50 basis points (1 basis point is 1/100 of a percent - thus examples of a 50 basis point change would be a change from 4.5% to 5% or 11.2% to 11.7%). Is the graph linear? If not, what shape is it? Does a change in YTM affect the price of each of the two bonds the same way? Why or why not? Create a similar graph for Bonds B & C. Is the graph linear? If not, what shape is it? Does a change in YTM affect the price of each of the two bonds the same way? Why or why not

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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 Investments, Valuation and Management

Authors: Bradford Jordan, Thomas Miller, Steve Dolvin

8th edition

1259720697, 1259720691, 1260109437, 9781260109436, 978-1259720697

More Books

Students also viewed these Finance questions