(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

You invest $1,000 a year for 10 years at 6 percent and then invest $2,000 a year for an additional 10 years at 6 percent. How much will you have accumulated at the end of the 20 years? Answer: $49,967 *Please include all work & formulas

No ai please! What is the role of an underwriter in an IPO?A) To lend money to the companyB) To set the dividend policyC) To buy the securities and sell them to the publicD) To manage the company’s operations need he

No ai tool What is the role of an underwriter in an IPO?A) To lend money to the companyB) To set the dividend policyC) To buy the securities and sell them to the publicD) To manage the company’s operations

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