2. A bond has a face value of $1,000, an annual coupon rate of 5 percent,...

2. A bond has a face value of $1,000, an annual coupon rate of 5 percent, yield to maturity of 10 percent, and 10 years to maturity

Calculate the bond's duration.

Please answer using EXCEL

Expert Solution

Hello, consider upvoting the answer, it helps a lot and if you have any questions, feel free to ask in the comments section.

calc:

Or you can use the Excel's built-in function:

calc:

jeff jeffy answered 2 years ago

A bond has a face value of $1,000, an annual coupon rate of 5 percent, yield...

A bond has a face value of $1,000, an annual coupon rate of 5 percent, yield to maturity of 10 percent, and 10 years to maturity Calculate the bond's duration.

A corporate bond has a $1,000 face value and a 5 percent coupon rate (annual payments)...

A corporate bond has a $1,000 face value and a 5 percent coupon rate (annual payments) maturing in 3 years. a. If the yield to maturity is 7%, what is the bond price? 2 marks b. An investor believes an appropriate rate to discount the future cash flow of the bond should be 6%, should the investor buy or sell the bond? Discuss the reason(s).

A corporate bond has a face value of $1,000 and a coupon rate of 5%. The...

A corporate bond has a face value of $1,000 and a coupon rate of 5%. The bond matures in 15 years and has a current market price of $950. If the corporation sells more bonds it will incur flotation costs of $25 per bond. If the corporate tax rate is 35%, what is the after-tax cost of debt capital? please show all steps in the calculation.

An Apple annual coupon bond has a coupon rate of 4.1%, face value of $1,000, and...

An Apple annual coupon bond has a coupon rate of 4.1%, face value of $1,000, and 4 years to maturity. If its yield to maturity is 4.1%, what is its Modified Duration? Answer in years, rounded to three decimal places.

An Apple annual coupon bond has a coupon rate of 6.9%, face value of $1,000, and...

An Apple annual coupon bond has a coupon rate of 6.9%, face value of $1,000, and 4 years to maturity. If its yield to maturity is 6.9%, what is its Modified Duration? Answer in years, rounded to three decimal places.

An Apple annual coupon bond has a coupon rate of 6.8%, face value of $1,000, and...

An Apple annual coupon bond has a coupon rate of 6.8%, face value of $1,000, and 4 years to maturity. If its yield to maturity is 6.8%, what is its Macaulay Duration? Answer in years, rounded to three decimal places.

An Apple annual coupon bond has a coupon rate of 5.1%, face value of $1,000, and...

An Apple annual coupon bond has a coupon rate of 5.1%, face value of $1,000, and 4 years to maturity. If its yield to maturity is 5.1%, what is its Modified Duration? Answer in years, rounded to three decimal places.

An annual bond has a face value of $1,000, a coupon rate of 7.4%, a yield...

An annual bond has a face value of $1,000, a coupon rate of 7.4%, a yield to maturity of 6.2% and has 12 years remaining to maturity. What is the price of the bond?

A $1,000 face value has a 5% annual coupon rate. The next coupon is due in...

A $1,000 face value has a 5% annual coupon rate. The next coupon is due in one year and the bond matures in 26 years. The current YTM on the bond is 4.2%. What is the dollar value of the price change if the bond's YTM increases to 6.3%? Round to the nearest cent. [Hint: 1) If the price drops, the change is a negative number. 2) Do not compute duration. You can calculate the precise impact of a yield...

A bond with face Value =$1,000 with semi-annual payments, a coupon rate of 7%, and has...

A bond with face Value =$1,000 with semi-annual payments, a coupon rate of 7%, and has 8 years to maturity. The market requires a yield of 8% on bonds of this risk. What is this bond’s price?

Question