(a) To Discuss: To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given. Spreadsheet 11.1 Introduction: A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity. Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Question

Want to see the full answer?

Answer 1

Question

Chapter 16, Problem 21PS

Summary Introduction

(a)

To Discuss:

To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Summary Introduction

(b)

To Discuss:

To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Use the binomial method to determine the value of an American Put option at time t = 0. The option expires at time t = T = 1/2 and has exercise price E = 55. The current value of the underlying is S(0) = 50 with the underlying paying continuous dividends at the rate D = 0.05. The interest rate is r = 0.3. Use a time step of St = 1/6. Consider the case of p = 1/2 and suppose the volatility is σ = 0.3. Perform all calculations using a minimum of 4 decimal places of accuracy. =

Consider a European chooser option with exercise price E₁ and expiry date T₁ where the relevant put and call options, which depend on the value of the same underlying asset S, have the same exercise price E2 and expiry date T₂. Determine, in terms of other elementary options, the value of the chooser option for the special case when T₁ = T2. Clearly define all notation that you use.

The continuous conditional probability density function pc(S, t; S', t') for a risk neutral lognormal random walk is given by Pc(S, t; S', t') = 1 σS'√2π(t' - t) - (log(S/S) (ro²)(t − t)] exp 202 (t't) In the binomial method, the value of the underlying is Sm at time step môt and the value of the underlying at time step (m + 1)St is Sm+1. For this case evaluate Ec[(Sm+1)k|Sm] = [°° (S')*pc(S™, mdt; S', (m + 1)8t)dS' showing all steps, where k is a positive integer with k ≥ 1. You may assume that 1 e (x-n)2 2s2dx = 1 for all real numbers n and s with s > 0.

Answer 2

Question

Chapter 16, Problem 21PS

Summary Introduction

(a)

To Discuss:

To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Summary Introduction

(b)

To Discuss:

To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 3

Question

Chapter 16, Problem 21PS

Summary Introduction

(a)

To Discuss:

To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Summary Introduction

(b)

To Discuss:

To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 4

Question

Chapter 16, Problem 21PS

Summary Introduction

(a)

To Discuss:

To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Summary Introduction

(b)

To Discuss:

To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 5

Chapter 16, Problem 21PS

Summary Introduction

(a)

To Discuss:

To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Summary Introduction

(b)

To Discuss:

To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Answer 6

Chapter 16, Problem 21PS

Summary Introduction

(a)

To Discuss:

To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Answer 7

Chapter 16, Problem 21PS

Summary Introduction

(a)

To Discuss:

To use a spreadsheet to calculate the duration of the two bonds in Spreadsheet 11.1 if the market interest rate increases to 12%.The explanation of the reason of the fall in the duration of the coupon bond while the duration of the zero-coupon bond remaining unchanged is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond.A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Answer 8

Summary Introduction

(b)

To Discuss:

To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Answer 9

Summary Introduction

(b)

To Discuss:

To use the same spreadsheet to calculate the duration of the coupon bond if the coupon were 12% instead of 8%.The explanation of the reason of the duration of the coupon bond being lower is to be given.

Spreadsheet 11.1

Introduction:

A bond is a security that creates an obligation on the issuer to make specified payments to the holder for a given period of time. The face value of the bond is the amount the holder will receive on maturity along with the coupon rate which is also known as the interest rate of the bond. A zero-coupon bond is a bond where the face value is repaid at the time of maturity.

Yield to maturity means the discount rate which makes the present payments from the bond equal to the price, in simple terms it is the average rate of return a holder can expect from that bond. Duration is a measure of the sensitivity of the price -- the value of principal -- of a bond to a change in interest rates. The duration of a zero-coupon bond is equal to the time to maturity of the bond.

Answer 10

Expert Solution & Answer

Answer 11

Expert Solution & Answer

Answer 12

Want to see the full answer?

Check out a sample textbook solution

See solution

Answer 13

Ch. 16 - Prob. 1PS Ch. 16 - Prob. 2PS Ch. 16 - Prob. 3PS Ch. 16 - Prob. 4PS Ch. 16 - Prob. 5PS Ch. 16 - Prob. 6PS Ch. 16 - Prob. 7PS Ch. 16 - Prob. 8PS Ch. 16 - Prob. 9PS Ch. 16 - Prob. 10PS

Concept explainers

Videos

Want to see the full answer?

Chapter 16 Solutions